# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-01T00:58:34+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 = 248 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
"1008217","5.756","0.003","5.756","","5.756","","90","","90","","90","","190.7","","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","","Lanthanum oxide fluoride","","- F La O -","- F La O -","- F4 La4 O4 -","4","0.0208333","","Klemm, W; Klein, H A","Lanthanoxyfluorid","Zeitschrift fuer Anorganische und Allgemeine Chemie","1941","248","","167","171","10.1002/zaac.19412480207","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1523296","3.838","","3.838","","8.799","","90","","90","","90","","129.611","","","","","","","","","","","","","2","I 4/m m m","-I 4 2","139","","","","- Hg2 Mg -","- Hg2 Mg -","- Hg4 Mg2 -","2","0.0625","","Brauer, G.; Rudolph, R.","Roentgenuntersuchungen an Magnesium-Amalgamen. I.","Zeitschrift fuer Anorganische und Allgemeine Chemie","1941","248","","405","424","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1539094","3.897","","3.897","","21.69","","90","","90","","90","","329.398","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","Ca0.75 (Ca0.5 Bi1.5) O2 Cl3","","- Bi1.5 Ca1.25 Cl3 O2 -","- Bi1.5 Ca1.25 Cl3 O2 -","- Bi3 Ca2.5 Cl6 O4 -","2","0.0625","","Sillen, L.G.; Gjoerling-Husberg, A.S.","Roentgenuntersuchung von Calcium/Wismutoxychloriden und -oxybromiden","Zeitschrift fuer Anorganische und Allgemeine Chemie","1941","248","","121","134","","","","","","","","","","","","","","","","","","","","","","has coordinates","167847","2020-10-21","18:00:00",""
"1539095","3.897","","3.897","","36.45","","90","","90","","90","","553.552","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","Ca.80 Bi3.80 O4 Cl5","","- Bi3.8 Ca0.8 Cl5 O4 -","- Bi3.8 Ca0.8 Cl5 O4 -","- Bi7.6 Ca1.6 Cl10 O8 -","2","0.0625","","Sillen, L.G.; Gjoerling-Husberg, A.S.","Roentgenuntersuchung von Calcium/Wismutoxychloriden und -oxybromiden","Zeitschrift fuer Anorganische und Allgemeine Chemie","1941","248","","121","134","","","","","","","","","","","","","","","","","","","","","","has coordinates","167848","2020-10-21","18:00:00",""
"1539096","3.923","","3.923","","20.79","","90","","90","","90","","319.957","","","","","","","","","","","","","4","P 4/n m m :1","P 4ab 2ab -1ab","129","","Ca Bi2 O3 Br2","","- Bi2 Br2 Ca O3 -","- Bi2 Br2 Ca O3 -","- Bi4 Br4 Ca2 O6 -","2","0.125","","Sillen, L.G.; Gjoerling-Husberg, A.S.","Roentgenuntersuchung von Calcium/Wismutoxychloriden und -oxybromiden","Zeitschrift fuer Anorganische und Allgemeine Chemie","1941","248","","121","134","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1542090","4.019","","4.019","","12.98","","90","","90","","90","","209.658","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","Ba Bi O2 Cl","","- Ba Bi Cl O2 -","- Ba Bi Cl O2 -","- Ba2 Bi2 Cl2 O4 -","2","0.0625","","Sillen, L.G.; Gjoerling-Husberg, A.S.","Die Verbindungen Ba Bi O2 Cl und Ba Bi O2 Br","Zeitschrift fuer Anorganische und Allgemeine Chemie","1941","248","","135","136","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1542091","4.068","","4.068","","13.2","","90","","90","","90","","218.442","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","Ba Bi O2 Br","","- Ba Bi Br O2 -","- Ba Bi Br O2 -","- Ba2 Bi2 Br2 O4 -","2","0.0625","","Sillen, L.G.; Gjoerling-Husberg, A.S.","Die Verbindungen Ba Bi O2 Cl und Ba Bi O2 Br","Zeitschrift fuer Anorganische und Allgemeine Chemie","1941","248","","135","136","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""