# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-12-30T17:55:03+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 = 97 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 "1010017","5.584","","5.584","","22.45","","90","","90","","120","","606.2","","","","","","","","","","","","","3","P 63/m m c","-P 6c 2c","194","","Sodium 11-aluminium oxide","","- Al11 Na O17 -","- Al11 Na O17 -","- Al22 Na2 O34 -","2","0.0833333","","Beevers, C. A.; Ross, M. A. S.","The crystal structure of ""β alumina"" Na~2~O · 11(Al~2~O~3~)","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1937","97","1-6","59","66","10.1524/zkri.1937.97.1.59","","","","","","","","","","","","","","","","","","","","","has coordinates","200083","2020-10-21","18:00:00","" "1010265","3.72","","14.61","","3.67","","90","","90","","90","","199.5","","","","","","","","","","","","","2","C m c m","-C 2c 2","63","","Zirconium silicide (1/2)","","- Si2 Zr -","- Si2 Zr -","- Si8 Zr4 -","4","0.25","","Naray-Szabo, S","Die Struktur des Zirkoniumsilicids Zr Si~2~","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1937","97","","223","228","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1010426","5.737","0.003","5.968","0.003","14.241","0.007","90","","90","","90","","487.6","","","","","","","","","","","","","3","P n m a","-P 2ac 2n","62","","Caesium rhenate(VII)","","- Cs O4 Re -","- Cs O2 Re -","- Cs4 O8 Re4 -","4","0.5","","Beintema, J","Die Kristallstruktur der Alkaliperrhenate und -periodate","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1937","97","","300","322","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1010427","5.623","0.003","5.791","0.003","13.295","0.007","90","","90","","90","","432.9","","","","","","","","","","","","","3","P n m a","-P 2ac 2n","62","","Thallium rhenate(VII)","","- O4 Re Tl -","- O2 Re Tl -","- O8 Re4 Tl4 -","4","0.5","","Beintema, J","Die Kristallstruktur der Alkaliperrhenate und -periodate","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1937","97","","300","322","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1010428","5.838","0.003","6.014","0.003","14.364","0.007","90","","90","","90","","504.3","","","","","","","","","","","","","3","P n m a","-P 2ac 2n","62","","Caesium iodate(VII)","","- Cs I O4 -","- Cs I O2 -","- Cs4 I4 O8 -","4","0.5","","Beintema, J","Die Kristallstruktur der Alkaliperrhenate und -periodate","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1937","97","","300","322","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1010705","","","","","","","","","","","","","","","","","","","","","","","","","","5","","","","","Potassium chromium sulfate hydrate","","- Cr H24 K O20 S2 -","","","","","","Saur, E","Ueber die Gitterkonstante von Alaunen mit schwerem und leichtem Kristallwasser","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1937","97","","523","525","","","","","","","","","","","","","","","","","","","","","","","278158","2022-09-26","15:28:11","" "1010706","","","","","","","","","","","","","","","","","","","","","","","","","","5","","","","","Potassium chromium sulfate deuterate","","- Cr D24 K O20 S2 -","","","","","","Saur, E","Ueber die Gitterkonstante von Alaunen mit schwerem und leichtem Kristallwasser","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1937","97","","523","525","","","","","","","","","","","","","","","","","","","","","","","278158","2022-09-26","15:28:11","" "1011013","4.436","","5.414","","3.381","","90","","90","","90","","81.2","","","","","","","","","","","","from Joplin district, Missouri","2","P n n m","-P 2 2n","58","","Iron(II) duo-disulfide","Marcasite","- Fe S2 -","- Fe S2 -","- Fe2 S4 -","2","0.25","","Buerger, M J","Interatomic Distances in Marcasite and Notes on the Bonding in Crystals of Loellingite, Arsenopyrite, and Marcasite Types.","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1937","97","","504","513","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""