# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2026-09-24T21:18:06+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 'Norsk Geologisk Tidsskrift') AND volume = 8 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 "1010526","2.694","","2.694","","4.393","","90","","90","","120","","27.6","","","","","","","","","","","","","2","P 63 m c","P 6c -2c","186","","Beryllium oxide","","- Be O -","- Be O -","- Be2 O2 -","2","0.166667","","Zachariasen, W H","Ueber die Kristallstruktur von Be O","Norsk Geologisk Tidsskrift","1925","8","","189","200","","","","","","","","","","","","","","","","","","","","","","has coordinates","301772","2025-08-18","12:31:56","" "1010535","6.07","","6.07","","6.07","","90","","90","","90","","223.6","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Zinc telluride","","- Te Zn -","- Te Zn -","- Te4 Zn4 -","4","0.0208333","","Zachariasen, W H","Die Kristallstruktur der Telluride von Zink,Cadmium und Quecksilber","Norsk Geologisk Tidsskrift","1926","8","","302","306","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1010536","6.41","","6.41","","6.41","","90","","90","","90","","263.4","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Cadmium telluride","","- Cd Te -","- Cd Te -","- Cd4 Te4 -","4","0.0208333","","Zachariasen, W H","Die Kristallstruktur der Telluride von Zink,Cadmium und Quecksilber","Norsk Geologisk Tidsskrift","1926","8","","302","306","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1010537","6.36","","6.36","","6.36","","90","","90","","90","","257.3","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Mercury telluride","","- Hg Te -","- Hg Te -","- Hg4 Te4 -","4","0.0208333","","Zachariasen, W H","Die Kristallstruktur der Telluride von Zink,Cadmium und Quecksilber","Norsk Geologisk Tidsskrift","1926","8","","302","306","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1010538","6.07","","6.07","","6.07","","90","","90","","90","","223.6","","","","","","","","","","","","","2","F -4 3 m","F -4 2 3","216","","Zinc telluride","","- Te Zn -","- Te Zn -","- Te4 Zn4 -","4","0.0416667","","Zachariasen, W H","Die Kristallstruktur der Telluride von Zink,Cadmium und Quecksilber","Norsk Geologisk Tidsskrift","1926","8","","302","306","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1010539","6.41","","6.41","","6.41","","90","","90","","90","","263.4","","","","","","","","","","","","","2","F -4 3 m","F -4 2 3","216","","Cadmium telluride","","- Cd Te -","- Cd Te -","- Cd4 Te4 -","4","0.0416667","","Zachariasen, W H","Die Kristallstruktur der Telluride von Zink,Cadmium und Quecksilber","Norsk Geologisk Tidsskrift","1926","8","","302","306","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1010949","6.36","","6.36","","6.36","","90","","90","","90","","257.3","","","","","","","","","","","","","2","F -4 3 m","F -4 2 3","216","","Mercury telluride","Coloradoite","- Hg Te -","- Hg Te -","- Hg4 Te4 -","4","0.0416667","","Zachariasen, W H","Die Kristallstruktur der Telluride von Zink,Cadmium und Quecksilber","Norsk Geologisk Tidsskrift","1926","8","","302","306","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1011064","3.906","0.02","3.906","","3.906","","90","","90","","90","","59.6","","","","","","","","","","","","synthetic in molten Na2CO3","3","P m -3 m","-P 4 2 3","221","","Sodium niobate","Lueshite","- Na Nb O3 -","- Na Nb O3 -","- Na Nb O3 -","1","0.0208333","","Barth, T","Die Kristallstruktur von Perowskit und verwandter Verbindungen","Norsk Geologisk Tidsskrift","1925","8","","201","219","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1011210","5.302","","5.366","","3.777","","90","","90","","90","","107.5","","","","","","","","","","","","from Zermatt, Swiss Alps","3","C m m m","-C 2 2","65","","Calcium titanate","Perovskite","- Ca O3 Ti -","- Ca O3 Ti -","- Ca2 O6 Ti2 -","2","0.125","","Barth, T","Die Kristallstruktur von Perowskit und verwandter Verbindungen","Norsk Geologisk Tidsskrift","1925","8","","201","216","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1011211","3.795","","3.795","","3.795","","90","","90","","90","","54.7","","","","","","","","","","","","from Zermatt, Swiss Alps","3","P m -3 m","-P 4 2 3","221","","Calcium titanate","Perovskite","- Ca O3 Ti -","- Ca O3 Ti -","- Ca O3 Ti -","1","0.0208333","","Barth, T","Die Kristallstruktur von Perowskit und verwandter Verbindungen","Norsk Geologisk Tidsskrift","1925","8","","201","216","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1011212","3.825","","3.825","","3.825","","90","","90","","90","","56","","","","","","","","","","","","from Magnet Cove, Arkansas","5","P m -3 m","-P 4 2 3","221","","Calcium sodium titanium niobium oxide *","Perovskite niobian","- Ca0.7 Na0.3 Nb0.3 O3 Ti0.7 -","- Ca0.7 Na0.3 Nb0.3 O3 Ti0.7 -","- Ca0.7 Na0.3 Nb0.3 O3 Ti0.7 -","1","0.0208333","","Barth, T","Die Kristallstruktur von Perowskit und verwandter Verbindungen","Norsk Geologisk Tidsskrift","1925","8","","201","216","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1011231","8.17","","8.17","","8.17","","90","","90","","90","","545.3","","","","","","","","","","","","Skutterud, Norway","2","I m -3","-I 2 2 3","204","","Cobalt arsenide (1/3)","Skutterudite","- As3 Co -","- As3 Co -","- As24 Co8 -","8","0.166667","","Oftedal, I","The crystal structure of skutterudite and related minerals","Norsk Geologisk Tidsskrift","1926","8","","250","257","","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:11:44",""