# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-06T03:26:16+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 = 87 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
"1010199","7.95","0.03","7.95","0.03","7.95","0.03","97","0.33","97","0.33","97","0.33","490.2","","","","","","","","","","","","","4","R -3 c :R","-P 3* 2n","167","","Chromium chloride hexahydrate","","- Cl3 Cr H12 O6 -","- Cl3 Cr H12 O6 -","- Cl6 Cr2 H24 O12 -","2","0.166667","","Andress, K R; Carpenter, C","Kristallhydrate. II.Die Struktur von Chromchlorid- und Aluminiumchloridhexahydrat.","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1934","87","","446","463","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1010257","10.25","0.03","7.4","0.03","6.3","0.03","90","","93.5","0.33","90","","477","","","","","","","","","","","","","4","C 1 2/m 1","-C 2y","12","","Magnesium bromide hexahydrate","","- Br2 H12 Mg O6 -","- Br2 H12 Mg O6 -","- Br4 H24 Mg2 O12 -","2","0.25","","Andress, K R; Gundermann, J","Die Struktur von Magnesiumchlorid- und Magnesiumbromidhexahydrat.","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1934","87","","345","369","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1010263","3.66","","3.66","","10.27","","90","","90","","120","","119.1","","","","","","","","","","","","","4","P 63 m c","P 6c -2c","186","","Cadmium hydroxochloride","","- Cd Cl H O -","- Cd Cl H2 O -","- Cd2 Cl2 H4 O2 -","2","0.166667","","Hoard, J L; Grenko, J D","The Crystal Structure of Cadmium Hydroxychloride, Cd O H Cl","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1934","87","","110","119","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1010628","8.43","","8.43","","6.35","","90","","90","","90","","451.3","","","","","","","","","","","","","5","P -4 21 c","P -4 2n","114","","Silver sulfate tetrammonia","","- Ag2 H12 N4 O4 S -","- Ag2 H12 N4 O4 S -","- Ag4 H24 N8 O8 S2 -","2","0.25","","Corey, R B; Wyckoff, R W G","The crystal structure of silver sulfate tetrammoniate","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1934","87","","264","274","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1010629","6.99","","6.99","","8.75","","90","","90","","90","","427.5","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","Dipotassium dioxoosmium(VI) chloride","","- Cl4 K2 O2 Os -","- Cl4 K2 O2 Os -","- Cl8 K4 O4 Os2 -","2","0.0625","","Hoard, J L; Grenko, J D","The crystal structure of potassium osmyl chloride K~2~ Os O~2~ Cl~4~","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1934","87","","100","109","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010650","6.383","0.005","6.383","","6.383","","90","","90","","90","","260.1","","","","","","","","","","","","","3","F -4 3 m","F -4 2 3","216","","Disilver mercury iodide - $-alpha","","- Ag2 Hg I4 -","- Ag2 Hg I4 -","- Ag2 Hg I4 -","1","0.0104167","","Ketelaar, J A A","Die Kristallstruktur der Hochtemperaturmodifikationen von Ag~2~ Hg I~4~ und Cu~2~ Hg I~4~","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1934","87","","436","445","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010651","6.103","0.005","6.103","","6.103","","90","","90","","90","","227.3","","","","","","","","","","","","","3","F -4 3 m","F -4 2 3","216","","Copper mercury iodide - $-alpha","","- Cu2 Hg I4 -","- Cu2 Hg I4 -","- Cu2 Hg I4 -","1","0.0104167","","Ketelaar, J A A","Die Kristallstruktur der Hochtemperaturmodifikationen von Ag~2~ Hg I~4~ und Cu~2~ Hg I~4~","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1934","87","","436","445","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011008","7.85","0.03","7.85","0.03","7.85","0.03","97","0.33","97","0.33","97","0.33","471.9","","","","","","","","","","","","","4","R -3 c :R","-P 3* 2n","167","","Aluminium chloride hexahydrate","Chloraluminite ?","- Al Cl3 H12 O6 -","- Al Cl3 H12 O6 -","- Al2 Cl6 H24 O12 -","2","0.166667","","Andress, K R; Carpenter, C","Kristallhydrate. II.Die Struktur von Chromchlorid- und Aluminiumchloridhexahydrat.","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1934","87","","446","463","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1011081","8.641","0.001","5.07","0.001","9.72","0.004","90","","85.43","0.08","90","","424.5","","","","","","","","","","","","from Langesundsfjord, Brevig, Norway","3","P 1 21/n 1","-P 2yn","14","","Aluminium hydroxide","Gibbsite","- Al H3 O3 -","- Al H3 O3 -","- Al8 H24 O24 -","8","2","","Megaw, H D","The crystal structure of Hydrargillite Al (O H)3","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1934","87","","185","204","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1011187","8.45","","12.95","","7.1","","90","","116.1","","90","","697.7","","","","","","","","","","","","from Mt. Vesuvius, Italy","4","C 1 2/m 1","-C 2y","12","","Potassium tecto-alumotrisilicate","Sanidine","- Al K O8 Si3 -","- Al K O8 Si3 -","- Al4 K4 O32 Si12 -","4","0.5","","Taylor, W H","The structure of sanidine and other felspars","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1934","87","","464","481","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011249","9.9","0.03","7.15","0.03","6.1","0.03","90","","94","0.33","90","","430.7","","","","","","","","","","","","","4","C 1 2/m 1","-C 2y","12","","Magnesium chloride hexahydrate","Bischofite","- Cl2 H12 Mg O6 -","- Cl2 H12 Mg O6 -","- Cl4 H24 Mg2 O12 -","2","0.25","","Andress, K R; Gundermann, J","Die Struktur von Magnesiumchlorid- und Magnesiumbromidhexahydrat.","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1934","87","","345","369","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1011310","4.145","0.005","4.145","0.005","4.145","0.005","90","","90","","90","","71.2","","","","","","","","","","","","","2","P m -3 m","-P 4 2 3","221","","Calcium boride (1/6)","","- B6 Ca -","- B6 Ca -","- B6 Ca -","1","0.0208333","","Pauling, L; Weinbaum, S","The structure of calcium boride, Ca B6","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1934","87","","181","182","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""