# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2025-01-02T13:53:54+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 'Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie') AND volume = 71 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
"1010216","6.57","0.006","6.57","0.006","6.57","0.006","90","","90","","90","","283.6","","","","","","","","","","","","","3","P 21 3","P 2ac 2ab 3","198","","Sodium chlorate","","- Cl Na O3 -","- Cl Na O3 -","- Cl4 Na4 O12 -","4","0.333333","","Zachariasen, W H","The Crystal Structure of Sodium Chlorate.","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1929","71","","517","529","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010217","4.647","0.004","5.585","0.005","7.085","0.007","90","","109.63","0.08","90","","173.2","","","","","","","","","","","","","3","P 1 21/m 1 (a,b-1/4,c)","-P 2yb (x,y+1/4,z)","11","","Potassium chlorate","","- Cl K O3 -","- Cl K O3 -","- Cl2 K2 O6 -","2","","","Zachariasen, W. H.","The Crystal Structure of Potassium Chlorate","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie","1929","71","","501","516","10.1524/zkri.1929.71.1.501","","","","","","","","","","","","","","","","","","","","","has coordinates","204126","2020-10-21","18:00:00",""
"1010924","7.76","0.03","7.9","0.03","5.56","0.02","90","","90","","90","","340.9","","","","","","","","","","","","","3","P n n m","-P 2 2n","58","","Aluminium silicate oxide","Andalusite","- Al2 O5 Si -","- Al2 O5 Si -","- Al8 O20 Si4 -","4","0.5","","Taylor, W H","The Structure of Andalusite, Al2 Si O5","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1929","71","","205","218","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010987","7.09","0.02","7.72","0.04","5.56","0.02","90.09","","101.03","","105.74","","287","","","","","","","","","","","","","3","P -1","-P 1","2","","Dialuminium oxide silicate","Kyanite","- Al2 O5 Si -","- Al2 O5 Si -","- Al8 O20 Si4 -","4","2","","Naray-Szabo, S; Taylor, W H; Jackson, W W","The Structure of Cyanite","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1929","71","","117","130","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011074","10.47","","15.15","","6.28","","90","","98.97","","90","","984","","","","","","","","","","","","","4","C 1 2/m 1","-C 2y","12","","Calcium sulfate dihydrate","Gypsum","- Ca H4 O6 S -","- Ca H4 O6 S -","- Ca4 H16 O24 S4 -","4","0.5","","Onorato, E","Ueber den Feinbau des Gipses","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1929","71","","277","325","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""