# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-29T08:32:49+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 Physikalische Chemie (Leipzig)') 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
"1010274","4.39","0.04","4.39","0.04","7.02","0.06","90","","90","","120","","117.2","","","","","","","","","","","","","3","P 63 m c","P 6c -2c","186","","Ammonium fluoride","","- F H4 N -","- F H4 N -","- F2 H8 N2 -","2","0.166667","","Zachariasen, W H","Die Kristallstruktur des Ammoniumfluorids.","Zeitschrift fuer Physikalische Chemie (Leipzig)","1927","127","","218","224","","","","","","","","","","","","","","","","","","","","","","has coordinates","200452","2020-10-21","18:00:00",""
"1010275","3.397","0.003","3.397","0.003","5.691","0.01","90","","90","","120","","56.9","","","","","","","","","","","","","2","P -3 m 1","-P 3 2""","164","","Titanium sulfide","","- S2 Ti -","- S2 Ti -","- S2 Ti -","1","0.0833333","","Oftedal, I","Roentgenographische Untersuchungen von Sn S~2~, Ti S~2~, Ti Se~2~, Ti Te~2~","Zeitschrift fuer Physikalische Chemie (Leipzig)","1928","134","","301","310","","","","","","","","","","","","","","","","","","","","","","has coordinates","202022","2020-10-21","18:00:00",""
"1010276","3.533","0.003","3.533","0.003","5.995","0.01","90","","90","","120","","64.8","","","","","","","","","","","","","2","P -3 m 1","-P 3 2""","164","","Titanium selenide","","- Se2 Ti -","- Se2 Ti -","- Se2 Ti -","1","0.0833333","","Oftedal, I","Roentgenographische Untersuchungen von Sn S~2~, Ti S~2~, Ti Se~2~, Ti Te~2~","Zeitschrift fuer Physikalische Chemie (Leipzig)","1928","134","","301","310","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010277","3.774","0.003","3.774","0.003","6.539","0.01","90","","90","","120","","80.7","","","","","","","","","","","","","2","P -3 m 1","-P 3 2""","164","","Titanium telluride","","- Te2 Ti -","- Te2 Ti -","- Te2 Ti -","1","0.0833333","","Oftedal, I","Roentgenographische Untersuchungen von Sn S~2~, Ti S~2~, Ti Se~2~, Ti Te~2~","Zeitschrift fuer Physikalische Chemie (Leipzig)","1928","134","","301","310","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010278","3.93","","3.93","","6.12","","90","","90","","120","","81.9","","","","","","","","","","","","","2","P 3 2 1","P 3 2""","150","","Lanthanum oxide - $-alpha","","- La2 O3 -","- La2 O3 -","- La2 O3 -","1","0.166667","","Zachariasen, W H","Die Kristallstruktur der A-Modifikation von den Sesquioxyden der seltenen Erdmetalle. ( La~2~ O~3~, Ce~2~ O~3~, Pr~2~ O~3~, Nd~2~ O~3~ )","Zeitschrift fuer Physikalische Chemie (Leipzig)","1926","123","","134","150","","","","","","","","","","","","","","","","","","","","","","has coordinates","201954","2020-10-21","18:00:00",""
"1010279","3.88","","3.88","","6.06","","90","","90","","120","","79","","","","","","","","","","","","","2","P 3 2 1","P 3 2""","150","","Cerium oxide - $-alpha","","- Ce2 O3 -","- Ce2 O3 -","- Ce2 O3 -","1","0.166667","","Zachariasen, W H","Die Kristallstruktur der A-Modifikation von den Sesquioxiden der seltenen Erdmetalle. ( La~2~ O~3~, Ce~2~ O~3~, Pr~2~ O~3~, Nd~2~ O~3~ )","Zeitschrift fuer Physikalische Chemie (Leipzig)","1926","123","","134","150","","","","","","","","","","","","","","","","","","","","","","has coordinates","201954","2020-10-21","18:00:00",""
"1010280","3.85","","3.85","","6","","90","","90","","120","","77","","","","","","","","","","","","","2","P 3 2 1","P 3 2""","150","","Praseodymium oxide - A","","- O3 Pr2 -","- O3 Pr2 -","- O3 Pr2 -","1","0.166667","","Zachariasen, W H","Die Kristallstruktur der A-Modifikation von den Sesquioxiden der seltenen Erdmetalle. ( La~2~ O~3~, Ce~2~ O~3~, Pr~2~ O~3~, Nd~2~ O~3~ )","Zeitschrift fuer Physikalische Chemie (Leipzig)","1926","123","","134","150","","","","","","","","","","","","","","","","","","","","","","has coordinates","201954","2020-10-21","18:00:00",""
"1010281","3.84","","3.84","","6.01","","90","","90","","120","","76.7","","","","","","","","","","","","","2","P 3 2 1","P 3 2""","150","","Neodymium oxide - A","","- Nd2 O3 -","- Nd2 O3 -","- Nd2 O3 -","1","0.166667","","Zachariasen, W H","Die Kristallstruktur der A-Modifikation von den Sesquioxiden der seltenen Erdmetalle. ( La~2~ O~3~, Ce~2~ O~3~, Pr~2~ O~3~, Nd~2~ O~3~ )","Zeitschrift fuer Physikalische Chemie (Leipzig)","1926","123","","134","150","","","","","","","","","","","","","","","","","","","","","","has coordinates","202026","2020-10-21","18:00:00",""
"1010282","3.2","0.005","3.2","0.005","7.861","0.005","90","","90","","90","","80.5","","","","","","","","","","","","","2","I 4/m m m","-I 4 2","139","","Molybdenum silicide (1/2)","","- Mo Si2 -","- Mo Si2 -","- Mo2 Si4 -","2","0.0625","","Zachariasen, W H","Ueber die Kristallstruktur von Mo Si~2~ und W Si~2~","Zeitschrift fuer Physikalische Chemie (Leipzig)","1927","128","","39","48","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010283","3.212","0.005","3.212","0.005","7.88","0.005","90","","90","","90","","81.3","","","","","","","","","","","","","2","I 4/m m m","-I 4 2","139","","Tungsten silicide (1/2)","","- Si2 W -","- Si2 W -","- Si4 W2 -","2","0.0625","","Zachariasen, W H","Ueber die Kristallstruktur von Mo Si~2~ und W Si~2~","Zeitschrift fuer Physikalische Chemie (Leipzig)","1927","128","","39","48","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010284","5.05","","5.05","","5.05","","40.03","","40.03","","40.03","","48","","","","","","","","","","","","","3","R -3 :R","-P 3*","148","","Sodium hydrogen fluoride","","- F2 H Na -","- F2 H Na -","- F2 H Na -","1","0.166667","","Andersen, C C; Hassel, O","Die Struktur des kristallisierten Natriumhydrofluorids und die Gestalt des Ions H F~2~^-^","Zeitschrift fuer Physikalische Chemie (Leipzig)","1926","123","","151","159","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1010843","2.863","","2.863","","2.863","","90","","90","","90","","23.5","","","","","","","","","","","","","4","","","","","Tetrakis(ammonium) iron cyanide","","- C6 H16 Fe N10 -","","","","","","Brill, R; Mark, H","Roentgenographische Studien am Abbau komplexer Eisencyanide.","Zeitschrift fuer Physikalische Chemie (Leipzig)","1928","133","","443","455","","","","","","","","","","","","","","","","","","","","","","","278156","2022-09-26","15:27:21",""
"1010880","5.912","0.003","5.912","","5.912","","90","","90","","90","","206.6","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Calcium selenide","","- Ca Se -","- Ca Se -","- Ca4 Se4 -","4","0.0208333","","Oftedal, I","Die Gitterkonstanten von Ca O, Ca S, Ca Se, Ca Te.","Zeitschrift fuer Physikalische Chemie (Leipzig)","1927","127","","154","158","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010881","6.345","0.008","6.345","","6.345","","90","","90","","90","","255.4","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Calcium telluride","","- Ca Te -","- Ca Te -","- Ca4 Te4 -","4","0.0208333","","Oftedal, I","Die Gitterkonstanten von Ca O, Ca S, Ca Se, Ca Te.","Zeitschrift fuer Physikalische Chemie (Leipzig)","1927","127","","154","158","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010882","3.86","","3.86","","3.86","","90","","90","","90","","57.5","","","","","","","","","","","","","2","P m -3 m","-P 4 2 3","221","","Thallium antimonide","","- Sb Tl -","- Sb Tl -","- Sb Tl -","1","0.0208333","","Barth, T","Ueber das System Thallium-Antimon","Zeitschrift fuer Physikalische Chemie (Leipzig)","1927","127","","113","120","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011094","4.812","0.005","4.812","","4.812","","90","","90","","90","","111.4","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Calcium oxide","Lime","- Ca O -","- Ca O -","- Ca4 O4 -","4","0.0208333","","Oftedal, I","Die Gitterkonstanten von Ca O, Ca S, Ca Se, Ca Te.","Zeitschrift fuer Physikalische Chemie (Leipzig)","1927","128","","135","158","","","","","","","","","","","","","","","","","","","","","","has coordinates","202026","2020-10-21","18:00:00",""
"1011236","5.686","0.005","5.686","0.005","5.686","0.005","90","","90","","90","","183.8","","","","","","","","","","","","synthetic","2","F m -3 m","-F 4 2 3","225","","Calcium sulfide","Oldhamite","- Ca S -","- Ca S -","- Ca4 S4 -","4","0.0208333","","Oftedal, I","Die Gitterkonstanten von Ca O, Ca S, Ca Se, Ca Te.","Zeitschrift fuer Physikalische Chemie (Leipzig)","1927","128","","135","158","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""