# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-07T05:07:11+02: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 (-144,1977)') AND volume = 73 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
"1010214","6.48","","7.06","","7.08","","90","","90","","90","","323.9","","","","","","","","","","","","","3","B b m m","-B 2 2b","63","","Sodium chlorate(VII)","","- Cl Na O4 -","- Cl Na O4 -","- Cl4 Na4 O16 -","4","0.25","","Zachariasen, W H","The Crystal Structure of Sodium Perchlorate, Na Cl O~4~","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1930","73","","141","146","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010577","8.904","0.003","8.904","0.003","8.904","0.003","90","","90","","90","","705.9","","","","","","","","","","","","","4","F -4 3 m","F -4 2 3","216","","Ammonium hexafluoroaluminate","","- Al F6 H12 N3 -","- Al F6 H12 N3 -","- Al4 F24 H48 N12 -","4","0.0416667","","Menzer, G","Die Gitterkonstante des Ammoniumkryoliths.","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1930","73","","113","113","","","","","","","","","","","","","","","","","","","","","","has coordinates","200452","2020-10-21","18:00:00",""
"1011147","6.56","","8.58","","4.74","","90","","103.13","","90","","259.8","","","","","","","","","","","","from Iveland, Saetersdalen, S. Norway","3","C 1 2/m 1","-C 2y","12","","Discandium disilicate","Thortveitite","- O7 Sc2 Si2 -","- O7 Sc2 Si2 -","- O14 Sc4 Si4 -","2","0.25","","Zachariasen, W H","The structure of thortveitite, Sc2 Si O7","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1930","73","","1","6","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011220","6.55","0.01","8.7","0.01","7.43","0.01","90","","119.72","","90","","367.7","","","","","","","","","","","","from Lindvikskollen, Krageroe, Norway","4","C 1 2/c 1 S","","15","","Calcium titanium silicate oxide","Titanite","- Ca O5 Si Ti -","- Ca O5 Si Ti -","- Ca4 O20 Si4 Ti4 -","4","","","Zachariasen, W H","The crystal structure of titanite","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1930","73","","7","16","","","","","","","","","","","","","","","","","","","","","","has coordinates","77586","2020-10-21","18:00:00",""
"1011342","3.725","","9.79","","9.93","","90","","90","","90","","362.1","","","","","","","","","","","","from Aranyer Berg, Transylvania","3","C m c m","-C 2c 2","63","","Diiron(III) titanate dioxide","Pseudobrookite","- Fe2 O5 Ti -","- Fe2 O5 Ti -","- Fe8 O20 Ti4 -","4","0.25","","Pauling, L","The crystal structure of pseudobrookite","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1930","73","","97","113","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"8104210","5.29","","5.29","","5.29","","90","","90","","90","","148.036","","","","","","","","","","","","","4","P -4 3 m","P -4 2 3","215","","Cu3 (Fe Ge)0.5 S4","","- Cu3 Fe0.5 Ge0.5 S4 -","- Cu3 Fe0.5 Ge0.5 S4 -","- Cu3 Fe0.5 Ge0.5 S4 -","1","0.0416667","","de Jong, W.F.","Studies of mineral sulpho-salts. VII A systematic arrangement on the basis of cell dimensions","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1930","73","","176","180","","","","","","","","","","","","","","","","","","","","","","has coordinates","165323","2020-10-21","18:00:00",""