# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-24T12:47:28+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 Anorganische und Allgemeine Chemie') AND volume = 242 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
"1010160","3.84","","3.84","","12.03","","90","","90","","90","","177.4","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","Lithium tribismuth tetraoxide dichloride","","- Bi3 Cl2 Li O4 -","- Bi3 Cl2 Li O4 -","- Bi3 Cl2 Li O4 -","1","0.03125","","Sillen, L G","Roentgenuntersuchung von Li Bi~3~ O~4~ Cl~2~ und verwandten Stoffen","Zeitschrift fuer Anorganische und Allgemeine Chemie","1939","242","","41","46","10.1002/zaac.19392420104","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010161","3.877","","3.877","","12.13","","90","","90","","90","","182.3","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","Sodium tribismuth tetraoxide dichloride","","- Bi3 Cl2 Na O4 -","- Bi3 Cl2 Na O4 -","- Bi3 Cl2 Na O4 -","1","0.03125","","Sillen, L G","Roentgenuntersuchung von Li Bi~3~ O~4~ Cl~2~ und verwandten Stoffen","Zeitschrift fuer Anorganische und Allgemeine Chemie","1939","242","","41","46","10.1002/zaac.19392420104","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010162","3.876","","3.876","","12.47","","90","","90","","90","","187.3","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","Lithium tribismuth tetraoxide dibromide","","- Bi3 Br2 Li O4 -","- Bi3 Br2 Li O4 -","- Bi3 Br2 Li O4 -","1","0.03125","","Sillen, L G","Roentgenuntersuchung von Li Bi~3~ O~4~ Cl~2~ und verwandten Stoffen","Zeitschrift fuer Anorganische und Allgemeine Chemie","1939","242","","41","46","10.1002/zaac.19392420104","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010163","3.925","","3.925","","12.55","","90","","90","","90","","193.3","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","Sodium tribismuth tetraoxide dibromide","","- Bi3 Br2 Na O4 -","- Bi3 Br2 Na O4 -","- Bi3 Br2 Na O4 -","1","0.03125","","Sillen, L G","Roentgenuntersuchung von Li Bi~3~ O~4~ Cl~2~ und verwandten Stoffen","Zeitschrift fuer Anorganische und Allgemeine Chemie","1939","242","","41","46","10.1002/zaac.19392420104","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010164","3.943","","3.943","","12.62","","90","","90","","90","","196.2","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","Dicadmium dibismuth tetraoxide dibromide","","- Bi2 Br2 Cd2 O4 -","- Bi2 Br2 Cd2 O4 -","- Bi2 Br2 Cd2 O4 -","1","0.03125","","Sillen, L G","Roentgenuntersuchung von Li Bi~3~ O~4~ Cl~2~ und verwandten Stoffen","Zeitschrift fuer Anorganische und Allgemeine Chemie","1939","242","","41","46","10.1002/zaac.19392420104","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010165","3.941","","3.941","","13.19","","90","","90","","90","","204.9","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","Lithium tribismuth tetraoxide diiodide","","- Bi3 I2 Li O4 -","- Bi3 I2 Li O4 -","- Bi3 I2 Li O4 -","1","0.03125","","Sillen, L G","Roentgenuntersuchung von Li Bi~3~ O~4~ Cl~2~ und verwandten Stoffen","Zeitschrift fuer Anorganische und Allgemeine Chemie","1939","242","","41","46","10.1002/zaac.19392420104","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010166","3.99","","3.99","","13.31","","90","","90","","90","","211.9","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","Sodium tribismuth tetraoxide diiodide","","- Bi3 I2 Na O4 -","- Bi3 I2 Na O4 -","- Bi3 I2 Na O4 -","1","0.03125","","Sillen, L G","Roentgenuntersuchung von Li Bi~3~ O~4~ Cl~2~ und verwandten Stoffen","Zeitschrift fuer Anorganische und Allgemeine Chemie","1939","242","","41","46","10.1002/zaac.19392420104","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010171","9.3","","9.3","","9.3","","90","","90","","90","","804.4","","","","","","","","","","","","","2","I -4 3 d","I -4bd 2c 3","220","","Rubidium oxide (4/6)","","- O6 Rb4 -","- O7 Rb4 -","- O28 Rb16 -","4","0.0833333","","Helms, A; Klemm, W","Ueber die Kristallstrukturen der Rubidium- und Caesiumsesquioxyde","Zeitschrift fuer Anorganische und Allgemeine Chemie","1939","242","","201","214","10.1002/zaac.19392420210","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010172","9.86","","9.86","","9.86","","90","","90","","90","","958.6","","","","","","","","","","","","","2","I -4 3 d","I -4bd 2c 3","220","","Caesium oxide (4/6)","","- Cs4 O6 -","- Cs4 O7 -","- Cs16 O28 -","4","0.0833333","","Helms, A; Klemm, W","Ueber die Kristallstrukturen der Rubidium- und Caesiumsesquioxyde","Zeitschrift fuer Anorganische und Allgemeine Chemie","1939","242","","201","214","10.1002/zaac.19392420210","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010893","6.34","0.002","6.34","0.002","6.34","0.002","90","","90","","90","","254.8","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Ytterbium(II) telluride","","- Te Yb -","- Te Yb -","- Te4 Yb4 -","4","0.0208333","","Senff, H; Klemm, W","Ytterbochalkogenide","Zeitschrift fuer Anorganische und Allgemeine Chemie","1939","242","","92","96","10.1002/zaac.19392420111","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010894","5.867","0.002","5.867","0.002","5.867","0.002","90","","90","","90","","202","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Ytterbium(II) selenide","","- Se Yb -","- Se Yb -","- Se4 Yb4 -","4","0.0208333","","Senff, H; Klemm, W","Ytterbochalkogenide","Zeitschrift fuer Anorganische und Allgemeine Chemie","1939","242","","92","96","10.1002/zaac.19392420111","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1537396","9.86","","9.86","","9.86","","90","","90","","90","","958.585","","","","","","","","","","","","","1","I -4 3 d","I -4bd 2c 3","220","","Cs4 (O2)3","","- O3 -","- O3 -","- O12 -","4","0.0833333","","Helms, A.; Klemm, W.","Ueber die Kristallstrukturen der Rubidium- und Caesiumsesquioxyde","Zeitschrift fuer Anorganische und Allgemeine Chemie","1939","242","","201","214","","","","","","","","","","","","","","","","","","","","","","has coordinates","165525","2020-10-21","18:00:00",""
"1538157","4.252","","4.252","","7.044","","90","","90","","90","","127.352","","","","","","","","","","","","","2","I 4/m m m","-I 4 2","139","","Rb O2","","- O2 Rb -","- O2 Rb -","- O4 Rb2 -","2","0.0625","","Helms, A.; Klemm, W.","Die Kristallstrukturen von Rubidium- und Caesiumoxyd","Zeitschrift fuer Anorganische und Allgemeine Chemie","1939","242","","33","40","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1538289","3.355","","3.355","","6.134","","90","","90","","120","","59.794","","","","","","","","","","","","","2","P -3 m 1","-P 3 2""","164","","V Se2","","- Se2 V -","- Se2 V -","- Se2 V -","1","0.0833333","","Hoschek, E.","Vanadinselenide","Zeitschrift fuer Anorganische und Allgemeine Chemie","1939","242","","49","49","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1538290","3.582","","3.582","","5.992","","90","","90","","120","","66.582","","","","","","","","","","","","","2","P 63/m m c","-P 6c 2c","194","","V Se","","- Se V -","- Se V -","- Se2 V2 -","2","0.0833333","","Hoschek, E.","Vanadinselenide","Zeitschrift fuer Anorganische und Allgemeine Chemie","1939","242","","49","49","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1539317","5.878","","5.878","","5.878","","90","","90","","90","","203.09","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Yb Se","","- Se Yb -","- Se Yb -","- Se4 Yb4 -","4","0.0208333","","Senff, H.","Ytterbochalkogenide","Zeitschrift fuer Anorganische und Allgemeine Chemie","1939","242","","92","96","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""