# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-21T18:22:43+01:00
# Query:
# SELECT data.*
# FROM
#  data JOIN jaltnames
#  ON altname = journal
# WHERE
#  (status is null or status != 'retracted') and
#  (journal_id IN (SELECT DISTINCT(journal_id) FROM jaltnames WHERE altname LIKE 'Latvijas PSR Zinatnu Akademijas Vestis, Khimijas Serija') AND duplicateof IS NULL AND (status is NULL OR status != 'errors') AND (method is NULL OR method != 'theoretical'))
# ORDER BY file asc
file,a,siga,b,sigb,c,sigc,alpha,sigalpha,beta,sigbeta,gamma,siggamma,vol,sigvol,celltemp,sigcelltemp,diffrtemp,sigdiffrtemp,cellpressure,sigcellpressure,diffrpressure,sigdiffrpressure,thermalhist,pressurehist,compoundsource,nel,sg,sgHall,sgNumber,commonname,chemname,mineral,formula,calcformula,cellformula,Z,Zprime,acce_code,authors,title,journal,year,volume,issue,firstpage,lastpage,doi,method,radiation,wavelength,radType,radSymbol,Rall,Robs,Rref,wRall,wRobs,wRref,RFsqd,RI,gofall,gofobs,gofgt,gofref,duplicateof,optimal,status,flags,svnrevision,date,time,onhold
"1529676","4.621","","4.621","","7.007","","90","","90","","90","","149.625","","","","","","","","","","","","","3","I -4","I -4","82","","P O N","","- N O P -","- N O P -","- N4 O4 P4 -","4","0.5","","Bondars, B.Ya.; Vitola, A.A.; Millers, T.N.; Ozolins, G.; Sila, Z.","Investigation of the structure of phosphorous oxynitride","Latvijas PSR Zinatnu Akademijas Vestis, Khimijas Serija","1977","1977","","632","632","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1530526","7.55","","8.95","","10.1","","90","","90","","90","","682.482","","","","","","","","","","","","","4","P n m a","-P 2ac 2n","62","","Zn (B3 O3 (O H)5) (H2 O)","","- B3 H7 O9 Zn -","- B3 O9 Zn -","- B12 O36 Zn4 -","4","0.5","","Ozols, J.; Tetere, I.V.; Ievins, A.","Crystal structure of zinc-triborate","Latvijas PSR Zinatnu Akademijas Vestis, Khimijas Serija","1973","1973","","3","7","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1530527","7.81","","13.71","","8.8","","90","","90","","90","","942.261","","","","","","","","","","","","","4","P n a 21","P 2c -2n","33","","K3 (B3 O4 (O H)4) (H2 O)2","","- B3 H8 K3 O10 -","- B3 K3 O10 -","- B12 K12 O40 -","4","1","","Ozols, J.","Crystal structure of potassium triborate K3 (B3 O4 (O H)4 ) * (H2 O)2 = 3 K B O2 (H2 O)1.33","Latvijas PSR Zinatnu Akademijas Vestis, Khimijas Serija","1977","1977","","356","357","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1534902","11.053","","7.867","","7.535","","90.13","","94.86","","107.95","","620.787","","","","","","","","","","","","","5","P -1","-P 1","2","","(N H4)2 (Co (H2 O)2 (B6 O7 (O H)6 )2 ) (H2 O)2","","- B12 Co H28 N2 O30 -","- B12 Co H28 N2 O30 -","- B12 Co H28 N2 O30 -","1","0.5","","Silin', E.Ya.; Zavodnik, V.E.; Tetere, I.V.; Ozolins, G.","Crystal structure of ammonium-cobalt double hexaborate (NH4)2 {Co(H2O)2:B6O7(OH)6:2} *2H2O","Latvijas PSR Zinatnu Akademijas Vestis, Khimijas Serija","1990","90","","173","180","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1537113","10.112","","10.112","","10.112","","90","","90","","90","","1033.98","","","","","","","","","","","","","3","P 21 3","P 2ac 2ab 3","198","","Na3 (P6 N11)","","- N11 Na3 P6 -","- N11 Na3 P6 -","- N44 Na12 P24 -","4","0.333333","","Ronis, Ya.V.; Bondars, B.Ya.; Vitola, A.A.; Miller, T.N.","Crystal structure of sodium-phosphorus nitride Na3 P6 N11","Latvijas PSR Zinatnu Akademijas Vestis, Khimijas Serija","1990","1990","","299","301","","","","","","","","","","","","","","","","","","","","","","has coordinates","165128","2020-10-21","18:00:00",""
"1541181","8.286","","8.286","","8.286","","90","","90","","90","","568.898","","","","","","","","","","","","","4","I -4 3 m","I -4 2 3","217","","Mg4 P6 (S N12)","","- Mg4 N12 P6 S -","- Mg4 N12 P6 S -","- Mg8 N24 P12 S2 -","2","0.0416667","","Ronis, Ya.V.; Tsirkunova, S.E.; Miller, T.N.; Kozlov, E.N.; Vitola, A.A.; Bondars, B.Ya.","Neutron diffraction study of magnesium phosphorus thionitride","Latvijas PSR Zinatnu Akademijas Vestis, Khimijas Serija","1989","2","","145","147","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1542023","5.9578","","8.5974","","14.8775","","90","","102.14","","90","","745.007","","","","","","","","","","","","","4","P 1 21/c 1","-P 2ybc","14","","Ba (B (O H)4)2 (H2 O)","","- B2 Ba H10 O9 -","- B2 Ba H10 O9 -","- B8 Ba4 H40 O36 -","4","1","","Ozols, J.; Peca, L.; Ievins, A.","Crystal structure of barium monoborate Ba (B (O H)4)2 (H2 O)","Latvijas PSR Zinatnu Akademijas Vestis, Khimijas Serija","1968","1968","","654","659","","","","","","","","","","","","","","","","","","","","","","has coordinates","189186","2020-10-21","18:00:00",""
"1542155","8.35","","5.88","","7.86","","108.28","","80","","65.85","","313.399","","","","","","","","","","","","","4","P -1","-P 1","2","","Sr (B (O H)4)2","","- B2 H8 O8 Sr -","- B2 O8 Sr -","- B4 O16 Sr2 -","2","1","","Ozols, J.; Ievins, A.","Structure of the triclinic modification of strontium monoborate Sr (B (O H)4)2","Latvijas PSR Zinatnu Akademijas Vestis, Khimijas Serija","1964","1964","","137","143","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""