# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2025-01-02T14:21:29+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 Physik') AND volume = 31 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 "1011316","4.4","","4.4","","4.4","","90","","90","","90","","85.2","","","","","","","","","","","","synthetic","2","F m -3 m","-F 4 2 3","225","","Titanium(III) nitride","Osbornite","- N Ti -","- N Ti -","- N4 Ti4 -","4","0.0208333","","Becker, K; Ebert, F","Die Kristallstrukturen einiger binaerer Carbide und Nitride.","Zeitschrift fuer Physik","1925","31","","268","272","10.1007/BF02980580","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1011317","4.44","","4.44","","4.44","","90","","90","","90","","87.5","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Scandium(III) nitride","","- N Sc -","- N Sc -","- N4 Sc4 -","4","0.0208333","","Becker, K; Ebert, F","Die Kristallstrukturen einiger binaerer Carbide und Nitride.","Zeitschrift fuer Physik","1925","31","","268","272","10.1007/BF02980580","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1011318","4.28","","4.28","","4.28","","90","","90","","90","","78.4","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Vanadium(III) nitride","Uakitite","- N V -","- N V -","- N4 V4 -","4","0.0208333","","Becker, K; Ebert, F","Die Kristallstrukturen einiger binaerer Carbide und Nitride.","Zeitschrift fuer Physik","1925","31","","268","272","10.1007/BF02980580","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:11:44","" "1011319","4.41","","4.41","","4.41","","90","","90","","90","","85.8","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Niobium(III) nitride","","- N Nb -","- N Nb -","- N4 Nb4 -","4","0.0208333","","Becker, K; Ebert, F","Die Kristallstrukturen einiger binaerer Carbide und Nitride.","Zeitschrift fuer Physik","1925","31","","268","272","10.1007/BF02980580","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1011320","4.6","","4.6","","4.6","","90","","90","","90","","97.3","","","","","","","","","","","","synthetic","2","F m -3 m","-F 4 2 3","225","","Titanium carbide","Khamrabaevite","- C Ti -","- C Ti -","- C4 Ti4 -","4","0.0208333","","Becker, K; Ebert, F","Die Kristallstrukturen einiger binaerer Carbide und Nitride.","Zeitschrift fuer Physik","1925","31","","268","272","10.1007/BF02980580","","","","","","","","","","","","","","","","","","","","","has coordinates","278158","2022-09-26","15:28:11","" "1011321","4.3","","4.3","","4.3","","90","","90","","90","","79.5","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Vanadium(IV) carbide","","- C V -","- C V -","- C4 V4 -","4","0.0208333","","Becker, K; Ebert, F","Die Kristallstrukturen einiger binaerer Carbide und Nitride.","Zeitschrift fuer Physik","1925","31","","268","272","10.1007/BF02980580","","","","","","","","","","","","","","","","","","","","","has coordinates","278158","2022-09-26","15:28:11","" "1011322","4.76","","4.76","","4.76","","90","","90","","90","","107.9","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Zirconium carbide","","- C Zr -","- C Zr -","- C4 Zr4 -","4","0.0208333","","Becker, K; Ebert, F","Die Kristallstrukturen einiger binaerer Carbide und Nitride.","Zeitschrift fuer Physik","1925","31","","268","272","10.1007/BF02980580","","","","","","","","","","","","","","","","","","","","","has coordinates","278158","2022-09-26","15:28:11","" "1011323","4.4","","4.4","","4.4","","90","","90","","90","","85.2","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Niobium carbide (1/1)","","- C Nb -","- C Nb -","- C4 Nb4 -","4","0.0208333","","Becker, K; Ebert, F","Die Kristallstrukturen einiger binaerer Carbide und Nitride.","Zeitschrift fuer Physik","1925","31","","268","272","10.1007/BF02980580","","","","","","","","","","","","","","","","","","","","","has coordinates","278158","2022-09-26","15:28:11","" "1011324","4.49","","4.49","","4.49","","90","","90","","90","","90.5","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Tantalum(IV) carbide","","- C Ta -","- C Ta -","- C4 Ta4 -","4","0.0208333","","Becker, K; Ebert, F","Die Kristallstrukturen einiger binaerer Carbide und Nitride.","Zeitschrift fuer Physik","1925","31","","268","272","10.1007/BF02980580","","","","","","","","","","","","","","","","","","","","","has coordinates","278158","2022-09-26","15:28:11","" "1011361","4.63","","4.63","","4.63","","90","","90","","90","","99.3","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Zirconium(III) nitride","","- N Zr -","- N Zr -","- N4 Zr4 -","4","0.0208333","","Becker, K; Ebert, F","Die Kristallstrukturen einiger binaerer Carbide und Nitride.","Zeitschrift fuer Physik","1925","31","","268","272","10.1007/BF02980580","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""