# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2025-01-09T19:42:19+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 Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)') AND volume = 91 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 "1010115","7.76","","13.46","","5.26","","90","","90","","90","","549.4","","","","","","","","","","","","","4","P m n 21 S","","31","","Magnesium chlorate(VII) hexahydrate","","- Cl2 H12 Mg O14 -","- Cl2 H12 Mg O14 -","- Cl4 H24 Mg2 O28 -","2","","","West, C D","Crystal Structures of Hydrated Compounds. II. Structure Type Mg (Cl O~4~)~2~ (H~2~ O)~6~","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1935","91","","480","493","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1010461","3.95","","3.95","","3.95","","90","","90","","90","","61.6","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Aluminium oxide - $-gamma","","- Al2.666 O3.999 -","- Al2.6652 O4 -","- Al2.6652 O4 -","1","0.00520833","","Verwey, E. J. W.","The Structure of the electrolytical Oxide Layer on Aluminium","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie","1935","91","","317","320","10.1524/zkri.1935.91.1.317","","","","","","","","","","","","","","","","","","","","","has coordinates","202026","2020-10-21","18:00:00","" "1010657","19.05","","7.05","","5.35","","90","","90","","90","","718.5","","","","","","","","","","","","from Kola","5","","","","","Sodium titanium strontium silicate","Lamprophyllite","- Na2 O8 Si2 Sr Ti -","","","4","","","Gossner, B; Drexler, K","Ueber Kristallform und chemische Zusammensetzung von Lamprophyllit","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1935","91","","494","500","","","","","","","","","","","","","","","","","","","","","","","77586","2020-10-21","18:00:00","" "1010667","12.83","","12.83","","18.38","","90","","90","","90","","3025.5","","","","","","","","","","","","","4","P 4/m n c","-P 4 2n","128","","Tungstoboric acid *","","- B2 H132 O141 W24 -","","","1","0.0625","","Kraus, O","Untersuchungen ueber das Kristallgitter von Heteropoly-saeuren und deren Salzen","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1935","91","","402","409","","","","","","","","","","","","","","","","","","","","","","","278158","2022-09-26","15:28:11","" "1010668","12.8","","12.8","","18.4","","90","","90","","90","","3014.7","","","","","","","","","","","","","5","P 4/m n c","-P 4 2n","128","","Ammonium dodecatungstoborate 66-hydrate","","- B H72 N5 O66 W12 -","","","2","0.125","","Kraus, O","Untersuchungen ueber das Kristallgitter von Heteropoly-saeuren und deren Salzen","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1935","91","","402","409","","","","","","","","","","","","","","","","","","","","","","","278158","2022-09-26","15:28:11","" "1010669","12.98","","12.98","","18.52","","90","","90","","90","","3120.3","","","","","","","","","","","","","4","P 4/m n c","-P 4 2n","128","","Dodecatungstosilicic acid 24-hydrate","","- H52 O64 Si W12 -","","","2","0.125","","Kraus, O","Untersuchungen ueber das Kristallgitter von Heteropoly-saeuren und deren Salzen","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1935","91","","402","409","","","","","","","","","","","","","","","","","","","","","","","130149","2020-10-21","18:00:00","" "1010742","3.13","0.01","3.13","","24.7","0.1","90","","90","","120","","209.6","","","","","","","","","","","","","4","P 63 m c","P 6c -2c","186","","Cobalt bromide hydroxide (4.8/.8/8.8)","","- Br0.75 Co4.75 H8.75 O8.75 -","","","1","0.0833333","","Feitknecht, W; Lotmar, W","Die Struktur des gruenen basischen Kobaltbromids","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1935","91","","136","141","","","","","","","","","","","","","","","","","","","","","","","278158","2022-09-26","15:28:11","" "1010892","5.1","","6.83","","5.4","","106.9","","90.17","","102.6","","175.2","","","","","","","","","","","","","3","P -1","-P 1","2","","Potassium peroxodisulfate","","- K2 O8 S2 -","- K2 O8 S2 -","- K2 O8 S2 -","1","0.5","","Keen, R C","The Crystal Structure of Potassium Persulfate K~2~ S~2~ O~8~","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1935","91","","129","135","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1011297","11.86","","12.08","","6.81","","90","","90","","90","","975.7","","","","","","","","","","","","","4","P 21 21 21","P 2ac 2ab","19","","Nickel sulfate(VI) heptahydrate","Morenosite","- H14 Ni O11 S -","- H14 Ni O11 S -","- H56 Ni4 O44 S4 -","4","1","","Beevers, C A; Schwartz, C M","The crystal structure of nickel sulphate heptahydrate Ni S O4 (H2 O)7","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1935","91","","157","169","","","","","","","","","","","","","","","","","","","","","","has coordinates","186542","2020-10-21","18:00:00","" "8104301","4.5167","","7.6448","","4.5107","","90","","90","","90","","155.751","","","","","","","","","","","","","1","C m c a","-C 2ac 2","64","","","","- Ga -","- Ga -","- Ga8 -","8","","","Bradley, A.J.","The crystal structure of gallium","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1935","91","","302","316","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""