# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-26T22:58:48+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 'Naturwissenschaften') AND volume = 49 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
"1522851","7.861","","7.861","","5.452","","90","","90","","120","","291.771","","","","","","","","","","","","","2","P 63/m c m","-P 6c 2","193","","","","- Ga4 Ti5 -","- Ga4 Ti5 -","- Ga8 Ti10 -","2","0.0833333","","Schubert, K.; Meissner, H.G.; Rossteutscher, W.; Poetzschke, M.; Stolz, E.","Einige Strukturdaten metallischer Phasen (VII)","Naturwissenschaften","1962","49","","57","57","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1523807","3.11","","3.11","","3.11","","90","","90","","90","","30.08","","","","","","","","","","","","","3","P m -3 m","-P 4 2 3","221","","Ni (Sn0.5 Ti0.5)","","- Ni Sn0.5 Ti0.5 -","- Ni Sn0.5 Ti0.5 -","- Ni Sn0.5 Ti0.5 -","1","0.0208333","","Heine, W.; Zwicker, U.","Phasen des B2-Strukturtyps (Cs Cl-Typ) in ternaeren Systemen mit Kupfer und Nickel","Naturwissenschaften","1962","49","","391","391","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1523808","2.96","","2.96","","2.96","","90","","90","","90","","25.934","","","","","","","","","","","","","3","P m -3 m","-P 4 2 3","221","","Ni (Ti0.5 Zn0.5)","","- Ni Ti0.5 Zn0.5 -","- Ni Ti0.5 Zn0.5 -","- Ni Ti0.5 Zn0.5 -","1","0.0208333","","Heine, W.; Zwicker, U.","Phasen des B2-Strukturtyps (Cs Cl-Typ) in ternaeren Systemen mit Kupfer und Nickel","Naturwissenschaften","1962","49","","391","391","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1524533","2.96","","2.96","","2.96","","90","","90","","90","","25.934","","","","","","","","","","","","","3","P m -3 m","-P 4 2 3","221","","Cu (Sn.5 Ti.5)","","- Cu Sn0.5 Ti0.5 -","- Cu Sn0.5 Ti0.5 -","- Cu Sn0.5 Ti0.5 -","1","0.0208333","","Heine, W.; Zwicker, U.","Phasen des B2-Strukturtyps (Cs Cl-Typ) in ternaeren Systemen mit Kupfer und Nickel","Naturwissenschaften","1962","49","","391","391","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1524534","2.96","","2.96","","2.96","","90","","90","","90","","25.934","","","","","","","","","","","","","3","P m -3 m","-P 4 2 3","221","","Cu (Ti0.5 Zn0.5)","","- Cu Ti0.5 Zn0.5 -","- Cu Ti0.5 Zn0.5 -","- Cu Ti0.5 Zn0.5 -","1","0.0208333","","Heine, W.; Zwicker, U.","Phasen des B2-Strukturtyps (Cs Cl-Typ) in ternaeren Systemen mit Kupfer und Nickel","Naturwissenschaften","1962","49","","391","391","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1524535","3.03","","3.03","","3.03","","90","","90","","90","","27.818","","","","","","","","","","","","","3","P m -3 m","-P 4 2 3","221","","Cu (Zn0.5 Zr0.5)","","- Cu Zn0.5 Zr0.5 -","- Cu Zn0.5 Zr0.5 -","- Cu Zn0.5 Zr0.5 -","1","0.0208333","","Heine, W.; Zwicker, U.","Phasen des B2-Strukturtyps (Cs Cl-Typ) in ternaeren Systemen mit Kupfer und Nickel","Naturwissenschaften","1962","49","","391","391","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1528582","4.05","","4.05","","7.93","","90","","90","","90","","130.072","","","","","","","","","","","","","2","I 4/m m m","-I 4 2","139","","Sn F4","","- F4 Sn -","- F4 Sn -","- F8 Sn2 -","2","0.0625","","Hoppe, R.; Daehne, W.","Die Kristallstruktur von Sn F4 und Pb F4","Naturwissenschaften","1962","49","","254","255","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1528583","4.247","","4.247","","8.03","","90","","90","","90","","144.837","","","","","","","","","","","","","2","I 4/m m m","-I 4 2","139","","Pb F4","","- F4 Pb -","- F4 Pb -","- F8 Pb2 -","2","0.0625","","Hoppe, R.; Daehne, W.","Die Kristallstruktur von Sn F4 und Pb F4","Naturwissenschaften","1962","49","","254","255","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1535577","4.74","","4.74","","4.74","","90","","90","","90","","106.496","","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","","(Na2 Tb O3)1.333","","- Na2.666 O3.999 Tb1.333 -","- Na2.68 O4 Tb1.32 -","- Na2.68 O4 Tb1.32 -","1","0.00520833","","Hoppe, R.; Lidecke, W.","Ueber Oxoterbate(IV). Na2 Tb O3","Naturwissenschaften","1962","49","","255","255","","","","","","","","","","","","","","","","","","","","","","has coordinates","162994","2020-10-21","18:00:00",""
"1537419","3.413","","3.413","","13.3","","90","","90","","90","","154.926","","","","","","","","","","","","","3","I 4/m m m","-I 4 2","139","","Na2 (Hg O2)","","- Hg Na2 O2 -","- Hg Na2 O2 -","- Hg2 Na4 O4 -","2","0.0625","","Hoppe, R.; Roehrborn, H.J.","Ueber Oxomercurate(II): Na2 Hg O2 und K2 Hg O2","Naturwissenschaften","1962","49","","419","420","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1537420","3.928","","3.928","","13.88","","90","","90","","90","","214.157","","","","","","","","","","","","","3","I 4/m m m","-I 4 2","139","","K2 (Hg O2)","","- Hg K2 O2 -","- Hg K2 O2 -","- Hg2 K4 O4 -","2","0.0625","","Hoppe, R.; Roehrborn, H.J.","Ueber Oxomercurate(II): Na2 Hg O2 und K2 Hg O2","Naturwissenschaften","1962","49","","419","420","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1537474","4.85","","4.418","","6.402","","90","","97.8","","90","","135.908","","","","","","","","","","","","","3","P 1 21/m 1","-P 2yb","11","","Rb (N H2)","","- H2 N Rb -","- H2 N Rb -","- H4 N2 Rb2 -","2","0.5","","Juza, R.; Jacobs, H.; Klose, W.","Die Kristallstrukturen der Tieftemperaturmodifikationen von Rb N H2 und K N H2","Naturwissenschaften","1962","49","","35","36","","","","","","","","","","","","","","","","","","","","","","has coordinates","186592","2020-10-21","18:00:00",""
"1538504","8.94","","8.94","","8.94","","90","","90","","90","","714.517","","","","","","","","","","","","","3","I 21 3","I 2b 2c 3","199","","Hg3 S2 Cl2","","- Cl2 Hg3 S2 -","- Cl2 Hg3 S2 -","- Cl8 Hg12 S8 -","4","0.166667","","Puff, H.; Kuester, J.","Die Kristallstruktur der kubischen Triquecksilberdichalkonium-dihalogenide","Naturwissenschaften","1962","49","","464","465","","","","","","","","","","","","","","","","","","","","","","has coordinates","167094","2020-10-21","18:00:00",""
"1538505","9.06","","9.06","","9.06","","90","","90","","90","","743.677","","","","","","","","","","","","","3","I 21 3","I 2b 2c 3","199","","Hg3 Se2 Cl2","","- Cl2 Hg3 Se2 -","- Cl2 Hg3 Se2 -","- Cl8 Hg12 Se8 -","4","0.166667","","Puff, H.; Kuester, J.","Die Kristallstruktur der kubischen Triquecksilber- dichalkonium-dihalogenide","Naturwissenschaften","1962","49","","464","465","","","","","","","","","","","","","","","","","","","","","","has coordinates","167095","2020-10-21","18:00:00",""
"1538506","9.33","","9.33","","9.33","","90","","90","","90","","812.166","","","","","","","","","","","","","3","I 21 3","I 2b 2c 3","199","","Hg3 Te2 Cl2","","- Cl2 Hg3 Te2 -","- Cl2 Hg3 Te2 -","- Cl8 Hg12 Te8 -","4","0.166667","","Puff, H.; Kuester, J.","Die Kristallstruktur der kubischen Triquecksilber-dichalkonium-dihalogenide","Naturwissenschaften","1962","49","","464","465","","","","","","","","","","","","","","","","","","","","","","has coordinates","167096","2020-10-21","18:00:00",""
"1538507","9.54","","9.54","","9.54","","90","","90","","90","","868.251","","","","","","","","","","","","","3","I 21 3","I 2b 2c 3","199","","Hg3 Te2 Br2","","- Br2 Hg3 Te2 -","- Br2 Hg3 Te2 -","- Br8 Hg12 Te8 -","4","0.166667","","Puff, H.; Kuester, J.","Die Kristallstruktur der kubischen Triquecksilber-dichalkonium-dihalogenide","Naturwissenschaften","1962","49","","464","465","","","","","","","","","","","","","","","","","","","","","","has coordinates","167097","2020-10-21","18:00:00",""
"1539279","4.46","","4.46","","4.46","","90","","90","","90","","88.717","","","","","","","","","","","","","2","P m -3 m","-P 4 2 3","221","","","","- In Zr3 -","- In Zr3 -","- In Zr3 -","1","0.0208333","","Schubert, K.; Meissner, H.G.; Stolz, E.; Rossteutscher, W.; Poetzschke, M.","Einige Strukturdaten metallischer Phasen. VII","Naturwissenschaften","1962","49","","57","57","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"5000044","14.07","0.02","6.51","0.02","11.04","0.02","90","","105.6","0.1","90","","974","","","","","","","","","","","","","4","P 1 21/c 1","-P 2ybc","14","","Iron sulfate heptahydrate","Melanterite","?","- Fe H21 O11 S -","- Fe4 H84 O44 S4 -","4","1","","Baur, W H","","Naturwissenschaften","1962","49","","464","464","","","","","","","0.065","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""