# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-10-12T13:53:27+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 = 63 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
"1010495","3.83","","3.83","","3.83","","90","","90","","90","","56.2","","","","","","","","","","","","","4","P m -3 m","-P 4 2 3","221","","Lithium chloride hydrate","","- Cl H2 Li O -","- Cl H3 Li O -","- Cl H3 Li O -","1","0.0208333","","Ott, H","Das Gitter des Monohydrats des Li Cl (Li Cl+H~2~ O).","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1926","63","","231","235","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1010496","5.63","","5.63","","5.63","","90","","90","","90","","178.5","","","","","","","","","","","","","2","P a -3","-P 2ac 2ab 3","205","","Carbon dioxide","","- C O2 -","- C O2 -","- C4 O8 -","4","0.166667","","Kruener, H","Die Kristallstruktur des festen Kohlendioxyds.","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1926","63","","275","283","","","","","","","","","","","","","","","","","","","","","","has coordinates","201954","2020-10-21","18:00:00",""
"1010497","4.755","","10.21","","5.985","","90","","90","","90","","290.6","","","","","","","","","","","","","4","P b n m","-P 2c 2ab","62","","Magnesium iron(II) silicate (1.8/.2/1)","Olivine","- Fe0.2 Mg1.8 O4 Si -","- Fe0.2 Mg1.8 O4 Si -","- Fe0.8 Mg7.2 O16 Si4 -","4","0.5","","Bragg, W L; Brown, G B","Die Struktur des Olivins.","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1926","63","","538","556","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1010498","5.62","","5.62","","5.62","","90","","90","","90","","177.5","","","","","","","","","","","","","2","P a -3","-P 2ac 2ab 3","205","","Carbon dioxide","","- C O2 -","- C O2 -","- C4 O8 -","4","0.166667","","Mark, H; Pohland, E","Zur Kristallstruktur des festen Kohlendioxyds.","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1926","63","","113","114","","","","","","","","","","","","","","","","","","","","","","has coordinates","201954","2020-10-21","18:00:00",""
"1010945","6.43","","6.43","","6.43","","90","","90","","90","","265.8","","","","","","","","","","","","","2","F -4 3 m","F -4 2 3","216","","Mercury telluride","Coloradoite","- Hg Te -","- Hg Te -","- Hg4 Te4 -","4","0.0416667","","de Jong, W F","Die Struktur des Tiemannit und Koloradoit.","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1926","63","","466","472","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011055","11.82","0.06","11.82","0.06","11.82","0.06","90","","90","","90","","1651.4","","","","","","","","","","","","from Xalostoc, Mexico","4","I a -3 d","-I 4bd 2c 3","230","","Tricalcium dialuminium silicate","Grossular","- Al2 Ca3 O12 Si3 -","- Al2 Ca3 O12 Si3 -","- Al16 Ca24 O96 Si24 -","8","0.0833333","","Menzer, G","Die Kristallstruktur von Granat.","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1926","63","","157","158","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011197","4.42","","9.39","","5.47","","90","","90","","90","","227","","","","","","","","","","","","natural","3","P b n m","-P 2c 2ab","62","","Beryllium dialuminium oxide","Chrysoberyl","- Al2 Be O4 -","- Al2 Be O4 -","- Al8 Be4 O16 -","4","0.5","","Bragg, W L; Brown, G B","Die Kristallstruktur von Crysoberyll (Be Al2 O4).","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1926","63","","122","143","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011198","4.303","","4.303","","4.303","","90","","90","","90","","79.7","","","","","","","","","","","","synthetic from melt (Fe3 O4 + Fe)","2","F m -3 m","-F 4 2 3","225","","Iron oxide","Wuestite","- Fe O -","- Fe O -","- Fe4 O4 -","4","0.0208333","","Wyckoff, R W G; Crittenden, E D","Herstellung und Kristallstruktur von Ferrooxyd (Fe O).","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1926","63","","144","147","","","","","","","","","","","","","","","","","","","","","","has coordinates","201954","2020-10-21","18:00:00",""
"1011199","6.04","","6.04","","6.04","","90","","90","","90","","220.3","","","","","","","","","","","","","2","F -4 3 m","F -4 2 3","216","","Mercury selenide","Tiemannite","- Hg Se -","- Hg Se -","- Hg4 Se4 -","4","0.0416667","","de Jong, W F","Die Struktur des Tiemannit und Koloradoit.","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1926","63","","466","472","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011200","5.013","","5.013","","5.47","","90","","90","","120","","119","","","","","","","","","","","","","2","P 62 2 2","P 62 2 (0 0 4)","180","","Silicon oxide - β","Quartz high","- O2 Si -","- O2 Si -","- O6 Si3 -","3","0.25","","Wyckoff, Ralph W. G.","XXIX. Kriterien für hexagonale Raumgruppen und die Kristallstruktur von β-quarz","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1926","63","1-6","507","537","10.1524/zkri.1926.63.1.507","","","","","","","","","","","","","","","","","","","","","has coordinates","200080","2020-10-21","18:00:00",""
"1011261","6.58","","6.58","","5.93","","90","","90","","90","","256.7","","","","","","","","","","","","synthetic","3","I 41/a m d :1","I 4bw 2bw -1bw","141","","Zirconium silicate","Zircon","- O4 Si Zr -","- O4 Si Zr -","- O16 Si4 Zr4 -","4","0.125","","Hassel, O","Die Kristallstruktur einige Verbindungen von der Zusammensetzung M R O4. I.Zirkon Zr Si O4.","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1926","63","","247","254","","","","","","","","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00",""