# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-01T05:23:45+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 Physik') 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
"1000063","4.252","0.002","4.252","0.002","4.252","0.002","90","","90","","90","","76.9","","","","","","","","","","","","synthetic","2","P n -3 m :1","P 4n 2 3 -1n","224","","Copper(I) oxide","Cuprite","- Cu2 O -","- Cu2 O -","- Cu4 O2 -","2","0.0416667","","Neuburger, M C","Praezisionsmessung der Gitterkonstante von Cuprooxyd Cu2 O","Zeitschrift fuer Physik","1930","67","","845","850","10.1007/BF01390765","","","","","","","","","","","","","","","","","","","","","has coordinates","202026","2020-10-21","18:00:00",""
"1010305","5.63","","5.63","","5.63","","90","","90","","90","","178.5","","","","","","","","","","","","","2","P 21 3","P 2ac 2ab 3","198","","Carbon(II) oxide","","- C O -","- C O -","- C4 O4 -","4","0.333333","","Vegard, L","Struktur und Leuchtfaehigkeit von festem Kohlenoxyd.","Zeitschrift fuer Physik","1930","61","","185","190","10.1007/BF01339658","","","","","","","","","","","","","","","","","","","","","has coordinates","201954","2020-10-21","18:00:00",""
"1010306","8.13","","8.13","","12.63","","90","","90","","90","","834.8","","","","","","","","","","","","","3","I 41/a :1","I 4bw -1bw","88","","Potassium iodate(VII)","","- I K O4 -","- I K O4 -","- I4 K4 O16 -","4","0.25","","Hylleraas, E","Die Atomanordnung in den tetragonalen Kristallen von K~2~ J~2~ O~8~, Kaliummetaperjodat.","Zeitschrift fuer Physik","1926","39","","308","321","10.1007/BF01322016","","","","","","","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00",""
"1010511","6.72","","6.72","","6.72","","90","","90","","90","","303.5","","","","","","","","","","","","","3","P 21 3","P 2ac 2ab 3","198","","Sodium bromate","","- Br Na O3 -","- Br Na O3 -","- Br4 Na4 O12 -","4","0.333333","","Vegard, L","Die Lage der Atome in den optisch aktiven Kristallen Na Cl O~3~ und Na Br O~3~.","Zeitschrift fuer Physik","1922","12","","289","303","10.1007/BF01328099","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010512","6.58","","6.58","","6.58","","90","","90","","90","","284.9","","","","","","","","","","","","","3","P 21 3","P 2ac 2ab 3","198","","Sodium chlorate","","- Cl Na O3 -","- Cl Na O3 -","- Cl4 Na4 O12 -","4","0.333333","","Vegard, L","Die Lage der Atome in den optisch aktiven Kristallen Na Cl O~3~ und Na Br O~3~.","Zeitschrift fuer Physik","1922","12","","289","303","10.1007/BF01328099","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010513","6.55","","6.55","","6.55","","90","","90","","90","","281","","","","","","","","","","","","","3","P 21 3","P 2ac 2ab 3","198","","Sodium chlorate","","- Cl Na O3 -","- Cl Na O3 -","- Cl4 Na4 O12 -","4","0.333333","","Kiby, W","Die Kristallstruktur von ""Natriumchlorat"" (Na Cl O~3~).","Zeitschrift fuer Physik","1923","17","","213","250","10.1007/BF01328680","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010514","3.113","","3.113","","4.981","","90","","90","","120","","41.8","","","","","","","","","","","","","2","P 63 m c","P 6c -2c","186","","Aluminium nitride","","- Al N -","- Al N -","- Al2 N2 -","2","0.166667","","Ott, H","Das Gitter des Aluminiumnitrids (Al N).","Zeitschrift fuer Physik","1924","22","","201","214","10.1007/BF01328124","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010515","9.35","","9.35","","9.35","","90","","90","","90","","817.4","","","","","","","","","","","","","4","P n -3 m :1","P 4n 2 3 -1n","224","","Triammonium zirconium fluoride","","- F7 H12 N3 Zr -","- F7 H12 N3 Zr -","- F28 H48 N12 Zr4 -","4","0.0833333","","Hassel, O; Mark, H","Ueber die Struktur der isomorphen Verbindungen (N H~4~)~3~ Zr F~7~ und (N H~4~)~3~ Hf F~7.~","Zeitschrift fuer Physik","1924","27","","89","101","10.1007/BF01328017","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1010516","7.77","","7.77","","7.77","","90","","90","","90","","469.1","","","","","","","","","","","","","2","I 21 3","I 2b 2c 3","199","","Dinitrogen tetraoxide","","- N2 O4 -","- N2 O4 -","- N12 O24 -","6","0.25","","Vegard, L","Die Struktur von festem N~2~ O~4~ bei der Temperatur von fluessiger Luft.","Zeitschrift fuer Physik","1931","68","","184","203","10.1007/BF01390966","","","","","","","","","","","","","","","","","","","","","has coordinates","202026","2020-10-21","18:00:00",""
"1010899","7","","7","","7","","90","","90","","90","","343","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Strontium chloride","","- Cl2 Sr -","- Cl2 Sr -","- Cl8 Sr4 -","4","0.0208333","","Mark, H; Tolksdorf, S","Ueber das Beugungsvermoegen der Atome fuer Roentgenstrahlen.","Zeitschrift fuer Physik","1925","33","","681","687","10.1007/BF01328353","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010948","4.464","","4.464","","10.9","","90","","90","","90","","217.2","","","","","","","","","","","","","2","I 4/m m m","-I 4 2","139","","Mercury(I) chloride","Calomel","- Cl2 Hg2 -","- Cl2 Hg2 -","- Cl4 Hg4 -","2","0.0625","","Hylleraas, E","Die Anordnung der Atome in den tetragonalen Kristallen der einwertigen Quecksilberhalogenide Hg2 Cl2, Hg2 Br2, Hg2 J2. Berechnung der optischen Doppelbrechung von Hg2 Cl2.","Zeitschrift fuer Physik","1926","36","","859","896","10.1007/BF01400219","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011061","6.623","","6.623","","11.18","","90","","90","","90","","490.4","","","","","","","","","","","","","2","I 4/m m m","-I 4 2","139","","Mercury(I) bromide","Kuzminite","- Br2 Hg2 -","- Br2 Hg2 -","- Br4 Hg4 -","2","0.0625","","Hylleraas, E","Die Anordnung der Atome in den tetragonalen Kristallen der einwertigen Quecksilberhalogenide Hg2 Cl2, Hg2 Br2, Hg2 J2. Berechnung der optischen Doppelbrechung von Hg2 Cl2.","Zeitschrift fuer Physik","1926","36","","859","896","10.1007/BF01400219","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011114","3.878","","3.878","","3.878","","90","","90","","90","","58.3","","","","","","","","","","","","synthetic, sheet","1","F m -3 m","-F 4 2 3","225","Platinum","Platinum","Platinum","- Pt -","- Pt -","- Pt4 -","4","0.0208333","","Uspenski, N; Konobejewski, S","Beugung der Roentgenstrahlen in mikrokrystallinen Strukturen","Zeitschrift fuer Physik","1923","16","","215","227","10.1007/BF01327394","","","","","","","","","","","","","","","","","","","","","has coordinates","201954","2020-10-21","18:00:00",""
"1011316","4.4","","4.4","","4.4","","90","","90","","90","","85.2","","","","","","","","","","","","synthetic","2","F m -3 m","-F 4 2 3","225","","Titanium(III) nitride","Osbornite","- N Ti -","- N Ti -","- N4 Ti4 -","4","0.0208333","","Becker, K; Ebert, F","Die Kristallstrukturen einiger binaerer Carbide und Nitride.","Zeitschrift fuer Physik","1925","31","","268","272","10.1007/BF02980580","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011317","4.44","","4.44","","4.44","","90","","90","","90","","87.5","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Scandium(III) nitride","","- N Sc -","- N Sc -","- N4 Sc4 -","4","0.0208333","","Becker, K; Ebert, F","Die Kristallstrukturen einiger binaerer Carbide und Nitride.","Zeitschrift fuer Physik","1925","31","","268","272","10.1007/BF02980580","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011318","4.28","","4.28","","4.28","","90","","90","","90","","78.4","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Vanadium(III) nitride","Uakitite","- N V -","- N V -","- N4 V4 -","4","0.0208333","","Becker, K; Ebert, F","Die Kristallstrukturen einiger binaerer Carbide und Nitride.","Zeitschrift fuer Physik","1925","31","","268","272","10.1007/BF02980580","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:11:44",""
"1011319","4.41","","4.41","","4.41","","90","","90","","90","","85.8","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Niobium(III) nitride","","- N Nb -","- N Nb -","- N4 Nb4 -","4","0.0208333","","Becker, K; Ebert, F","Die Kristallstrukturen einiger binaerer Carbide und Nitride.","Zeitschrift fuer Physik","1925","31","","268","272","10.1007/BF02980580","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011320","4.6","","4.6","","4.6","","90","","90","","90","","97.3","","","","","","","","","","","","synthetic","2","F m -3 m","-F 4 2 3","225","","Titanium carbide","Khamrabaevite","- C Ti -","- C Ti -","- C4 Ti4 -","4","0.0208333","","Becker, K; Ebert, F","Die Kristallstrukturen einiger binaerer Carbide und Nitride.","Zeitschrift fuer Physik","1925","31","","268","272","10.1007/BF02980580","","","","","","","","","","","","","","","","","","","","","has coordinates","278158","2022-09-26","15:28:11",""
"1011321","4.3","","4.3","","4.3","","90","","90","","90","","79.5","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Vanadium(IV) carbide","","- C V -","- C V -","- C4 V4 -","4","0.0208333","","Becker, K; Ebert, F","Die Kristallstrukturen einiger binaerer Carbide und Nitride.","Zeitschrift fuer Physik","1925","31","","268","272","10.1007/BF02980580","","","","","","","","","","","","","","","","","","","","","has coordinates","278158","2022-09-26","15:28:11",""
"1011322","4.76","","4.76","","4.76","","90","","90","","90","","107.9","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Zirconium carbide","","- C Zr -","- C Zr -","- C4 Zr4 -","4","0.0208333","","Becker, K; Ebert, F","Die Kristallstrukturen einiger binaerer Carbide und Nitride.","Zeitschrift fuer Physik","1925","31","","268","272","10.1007/BF02980580","","","","","","","","","","","","","","","","","","","","","has coordinates","278158","2022-09-26","15:28:11",""
"1011323","4.4","","4.4","","4.4","","90","","90","","90","","85.2","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Niobium carbide (1/1)","","- C Nb -","- C Nb -","- C4 Nb4 -","4","0.0208333","","Becker, K; Ebert, F","Die Kristallstrukturen einiger binaerer Carbide und Nitride.","Zeitschrift fuer Physik","1925","31","","268","272","10.1007/BF02980580","","","","","","","","","","","","","","","","","","","","","has coordinates","278158","2022-09-26","15:28:11",""
"1011324","4.49","","4.49","","4.49","","90","","90","","90","","90.5","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Tantalum(IV) carbide","","- C Ta -","- C Ta -","- C4 Ta4 -","4","0.0208333","","Becker, K; Ebert, F","Die Kristallstrukturen einiger binaerer Carbide und Nitride.","Zeitschrift fuer Physik","1925","31","","268","272","10.1007/BF02980580","","","","","","","","","","","","","","","","","","","","","has coordinates","278158","2022-09-26","15:28:11",""
"1011325","3.796","","3.796","","3.796","","90","","90","","90","","54.7","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Beryllium oxide","","- Be O -","- Be O -","- Be4 O4 -","4","0.0208333","","Gerlach, W","Die Gitterstruktur der Erdalkalioxyde.","Zeitschrift fuer Physik","1922","9","","184","192","10.1007/BF01326966","","","","","","","","","","","","","","","","","","","","","has coordinates","202026","2020-10-21","18:00:00",""
"1011326","4.22","0.02","4.22","0.02","4.22","0.02","90","","90","","90","","75.2","","","","","","","","","","","","synthetic","2","F m -3 m","-F 4 2 3","225","","Magnesium oxide","Periclase","- Mg O -","- Mg O -","- Mg4 O4 -","4","0.0208333","","Gerlach, W","Die Gitterstruktur der Erdalkalioxyde","Zeitschrift fuer Physik","1922","9","","184","192","10.1007/BF01326966","","","","","","","","","","","","","","","","","","","","","has coordinates","201954","2020-10-21","18:00:00",""
"1011327","4.778","0.05","4.778","0.05","4.778","0.05","90","","90","","90","","109.1","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Calcium oxide","Lime","- Ca O -","- Ca O -","- Ca4 O4 -","4","0.0208333","","Gerlach, W","Die Gitterstruktur der Erdalkalioxyde.","Zeitschrift fuer Physik","1922","9","","184","192","10.1007/BF01326966","","","","","","","","","","","","","","","","","","","","","has coordinates","201954","2020-10-21","18:00:00",""
"1011328","5.104","0.01","5.104","0.01","5.104","0.01","90","","90","","90","","133","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Strontium oxide","","- O Sr -","- O Sr -","- O4 Sr4 -","4","0.0208333","","Gerlach, W","Die Gitterstruktur der Erdalkalioxyde.","Zeitschrift fuer Physik","1922","9","","184","192","10.1007/BF01326966","","","","","","","","","","","","","","","","","","","","","has coordinates","201954","2020-10-21","18:00:00",""
"1011361","4.63","","4.63","","4.63","","90","","90","","90","","99.3","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Zirconium(III) nitride","","- N Zr -","- N Zr -","- N4 Zr4 -","4","0.0208333","","Becker, K; Ebert, F","Die Kristallstrukturen einiger binaerer Carbide und Nitride.","Zeitschrift fuer Physik","1925","31","","268","272","10.1007/BF02980580","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011362","5.496","0.02","5.496","0.02","5.496","0.02","90","","90","","90","","166","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Barium oxide","","- Ba O -","- Ba O -","- Ba4 O4 -","4","0.0208333","","Gerlach, W","Die Gitterstruktur der Erdalkalioxyde.","Zeitschrift fuer Physik","1922","9","","184","192","10.1007/BF01326966","","","","","","","","","","","","","","","","","","","","","has coordinates","201954","2020-10-21","18:00:00",""
"1200017","2.47","","2.47","","6.79","","90","","90","","120","","35.9","","","","","","","","","","","","from Kropfm}hl, Bavaria","1","P 63 m c","P 6c -2c","186","","Carbon","Graphite 2H","- C -","- C -","- C4 -","4","0.333333","","Hassel, O","Ueber die Kristallstruktur des Graphits","Zeitschrift fuer Physik","1924","25","","317","337","10.1007/BF01327534","","","","","","","","","","","","","","","","","","","","","has coordinates","202022","2020-10-21","18:00:00",""
"1537447","5.76","","5.76","","12.65","","90","","90","","90","","419.697","","","","","","","","","","","","","3","I 41/a :1","I 4bw -1bw","88","","K (I O4)","","- I K O4 -","- I K O4 -","- I4 K4 O16 -","4","0.25","","Hylleraas, E.","Die Atomanordnung in den tetragonalen Kristallen von K2 J2 O8, Kaliummetaperjodat.","Zeitschrift fuer Physik","1926","39","","308","321","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1538657","5.265","","5.265","","5.265","","90","","90","","90","","145.947","","","","","","","","","","","","","2","P m -3 n","-P 4n 2 3","223","","Ta3 Sb","","- Sb Ta3 -","- Sb Ta3 -","- Sb2 Ta6 -","2","0.0416667","","Luo, H.L.; Corenzwit, E.; Vielhaber, E.","Occurence of A-15 phases","Zeitschrift fuer Physik","1970","230","","443","448","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""