# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-26T02:33:04+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 Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)') AND volume = 100 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
"1010446","6.71","","6.71","","6.71","","90","","90","","90","","302.1","","","","","","","","","","","","","3","P 21 3","P 2ac 2ab 3","198","","Sodium bromate","","- Br Na O3 -","- Br Na O3 -","- Br4 Na4 O12 -","4","0.333333","","Hamilton, J E","The Crystal Structure of Sodium Bromate","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1938","100","","104","111","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010447","3.81","","3.34","","11","","90","","90","","90","","140","","","","","","","","","","","","","2","P n m n","-P 2n 2n","58","","Palladium chloride","","- Cl2 Pd -","- Cl2 Pd -","- Cl4 Pd2 -","2","0.25","","Wells, A F","The Crystal Structure of Palladous Chloride Pd Cl~2~","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1938","100","","189","194","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010448","3.74","","4.71","","5.61","","90","","90","","90","","98.8","","","","","","","","","","","","","3","I m m m","-I 2 2","71","","Sodium cyanide","","- C N Na -","- C N Na -","- C2 N2 Na2 -","2","0.125","","Verweel, H J; Bijvoet, J M","Die Kristallstruktur des Na C N","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1938","100","","210","207","","","","","","","","","","","","","","","","","","","","","","has coordinates","208902","2020-10-21","18:00:00",""
"1010449","7.43","0.01","7.43","0.01","10.61","0.02","90","","90","","90","","585.7","","","","","","","","","","","","","3","C 4 2 21","","90","","Potassium hexabromostannate","","- Br6 K2 Sn -","- Br6 K2 Sn -","- Br24 K8 Sn4 -","4","","","Markstein, G; Nowotny, H","Die Kristallstrukturen von Bromostannaten A Sn Br~6~ (A= Cs, Rb, N H~4~, K )","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1938","100","","265","271","","","","","","","","","","","","","","","","","","","","","","has coordinates","277832","2022-09-14","15:07:16",""
"1010450","8.02","","8.02","","8.02","","90","","90","","90","","515.8","","","","","","","","","","","","","2","F d -3 m :2","-F 4vw 2vw 3","227","","Aluminium calcium (2:1)","","- Al2 Ca -","- Al2 Ca -","- Al16 Ca8 -","8","0.0416667","","Nowotny, H; Mohrheim, A","Die Kristallstruktur von Al~2~ Ca","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","100","","540","542","","","","","","","","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00",""
"1010710","20.47","","19.38","","22.4","","95.6","","94.72","","90.94","","8811.2","","","","","","","","","","","","","4","P -1","-P 1","2","","Dodecatungstosilicic acid hydrate","","- H32 O54 Si W12 -","","","8","4","","Kraus, O","Kristallographische und roentgenographische Untersuchungen an einer neuen Hydratgruppe der 12-Heteropolysaeuren","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","100","","394","413","","","","","","","","","","","","","","","","","","","","","","","130149","2020-10-21","18:00:00",""
"1010711","20.4","","19.27","","22.37","","96.17","","93.72","","90.98","","8721.9","","","","","","","","","","","","","4","P -1","-P 1","2","","Dodecatungstoboric acid hydrate","","- B H33 O54 W12 -","","","8","4","","Kraus, O","Kristallographische und roentgenographische Untersuchungen an einer neuen Hydratgruppe der 12-Heteropolysaeuren","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","100","","394","413","","","","","","","","","","","","","","","","","","","","","","","278158","2022-09-26","15:28:11",""
"1010712","20.21","","19.25","","22.5","","95.2","","96.63","","92.7","","8644.5","","","","","","","","","","","","","4","P -1","-P 1","2","","Dodecamolybdosilicic acid hydrate","","- H32 Mo12 O54 Si -","","","8","4","","Kraus, O","Kristallographische und roentgenographische Untersuchungen an einer neuen Hydratgruppe der 12-Heteropolysaeuren","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","100","","394","413","","","","","","","","","","","","","","","","","","","","","","","130149","2020-10-21","18:00:00",""
"1010713","20.48","","19.32","","22.48","","95.62","","95.15","","90.27","","8815.4","","","","","","","","","","","","","4","P -1","-P 1","2","","Dodecatungstophosphoric acid hydrate","","- H31 O54 P W12 -","","","8","4","","Kraus, O","Kristallographische und roentgenographische Untersuchungen an einer neuen Hydratgruppe der 12-Heteropolysaeuren","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","100","","394","413","","","","","","","","","","","","","","","","","","","","","","","130149","2020-10-21","18:00:00",""
"1010714","20.12","","19.25","","22.55","","95.28","","96.62","","92.88","","8622.4","","","","","","","","","","","","","4","P -1","-P 1","2","","Dodecamolybdophosphoric acid hydrate","","- H31 Mo12 O54 P -","","","8","4","","Kraus, O","Kristallographische und roentgenographische Untersuchungen an einer neuen Hydratgruppe der 12-Heteropolysaeuren","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","100","","394","413","","","","","","","","","","","","","","","","","","","","","","","130149","2020-10-21","18:00:00",""
"1011062","8.94","0.02","5.14","0.02","43","0.2","90","","90.33","0.17","90","","1975.9","","","","","","","","","","","","from St. Peters Dome, Pike's peak, Colorado, USA","4","C 1 c 1","C -2yc","9","","Dialuminium phyllo-disilicate tetrahydroxide","Nacrite 6M","- Al2 H4 O9 Si2 -","- Al2 H4 O9 Si2 -","- Al24 H48 O108 Si24 -","12","3","","Hendricks, S B","The Crystal Structure of Nacrite Al2 O3 * 2Si O2 * 2H2 O and the Polymorphism of the Kaolin Minerals.","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","100","","509","518","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1011296","5.644","0.003","5.644","","5.644","","90","","90","","90","","179.8","","","","","","","","","","","","","2","P m -3 m","-P 4 2 3","221","","Yttrium fluoride","","- F3 Y -","- F3 Y -","- F9 Y3 -","3","0.0625","","Nowacki, W","Die Kristallstruktur des kubischen Yttriumfluorids Y F3","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1938","100","","242","250","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011331","8.27","","11.63","","8.89","","90","","90","","90","","855","","","","","","","","","","","","","5","P b a m","-P 2 2ab","55","","Dipotassium tetrachloromercurate hydrate","","- Cl4 H2 Hg K2 O -","- Cl4 H2 Hg K2 O -","- Cl16 H8 Hg4 K8 O4 -","4","0.5","","MacGillavry, C H; de Wilde, J H; Bijvoet, J M","The crystal structure of K2 Hg Cl4 * H2 O","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1938","100","","212","220","","","","","","","","","","","","","","","","","","","","","","has coordinates","186542","2020-10-21","18:00:00",""
"8104233","4.282","","4.282","","4.282","","90","","90","","90","","78.513","","","","","","","","","","","","","1","I m -3 m","-I 4 2 3","229","","","","- Na -","- Na -","- Na2 -","2","0.0208333","","Aruja, E.; Perlitz, H.","Neubestimmung der Gitterkonstanten von Natrium","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (145,1977-148,1979)","1939","100","","195","200","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""