# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-28T07:06:50+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 'Physical Review') AND volume = 25 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
"9011602","4.046","","4.046","","4.046","","90","","90","","90","","66.233","","","","","","","","","","","","","1","F m -3 m","-F 4 2 3","225","Aluminum","","Aluminum","- Al -","- Al -","- Al4 -","4","0.0208333","","Davey, W. P.","Lattice constants of twelve common metals Locality: synthetic Note: lattice parameter is average of runs 1 & 2","Physical Review","1925","25","","753","761","10.1103/PhysRev.25.753","","","","","","","","","","","","","","","","","","","","","has coordinates","264647","2021-04-28","11:19:17",""
"9011603","3.499","","3.499","","3.499","","90","","90","","90","","42.838","","","","","","","","","","","","","1","F m -3 m","-F 4 2 3","225","Nickel","","Nickel","- Ni -","- Ni -","- Ni4 -","4","0.0208333","","Davey, W. P.","Lattice constants of twelve common metals Locality: synthetic Note: lattice parameter is average of runs 1 & 2","Physical Review","1925","25","","753","761","10.1103/PhysRev.25.753","","","","","","","","","","","","","","","","","","","","","has coordinates","264647","2021-04-28","11:19:17",""
"9011604","3.597","","3.597","","3.597","","90","","90","","90","","46.539","","","","","","","","","","","","","1","F m -3 m","-F 4 2 3","225","Copper","","Copper","- Cu -","- Cu -","- Cu4 -","4","0.0208333","","Davey, W. P.","Lattice constants of twelve common metals Locality: synthetic Note: lattice parameter is average of runs 1,2 & 3","Physical Review","1925","25","","753","761","10.1103/PhysRev.25.753","","","","","","","","","","","","","","","","","","","","","has coordinates","264647","2021-04-28","11:19:17",""
"9011605","3.142","","3.142","","3.142","","90","","90","","90","","31.018","","","","","","","","","","","","","1","I m -3 m","-I 4 2 3","229","Molybdenum","","Molybdenum","- Mo -","- Mo -","- Mo2 -","2","0.0208333","","Davey, W. P.","Lattice constants of twelve common metals Locality: synthetic Note: lattice parameter is average of runs 1 & 2","Physical Review","1925","25","","753","761","10.1103/PhysRev.25.753","","","","","","","","","","","","","","","","","","","","","has coordinates","264647","2021-04-28","11:19:17",""
"9011606","3.136","","3.136","","3.136","","90","","90","","90","","30.841","","","","","","","","","","","","","1","I m -3 m","-I 4 2 3","229","Molybdenum","","Molybdenum","- Mo -","- Mo -","- Mo2 -","2","0.0208333","","Davey, W. P.","Lattice constants of twelve common metals Locality: synthetic Note: lattice parameter is average of runs 3 & 4","Physical Review","1925","25","","753","761","10.1103/PhysRev.25.753","","","","","","","","","","","","","","","","","","","","","has coordinates","264647","2021-04-28","11:19:17",""
"9011607","4.079","","4.079","","4.079","","90","","90","","90","","67.867","","","","","","","","","","","","","1","F m -3 m","-F 4 2 3","225","Silver","","Silver","- Ag -","- Ag -","- Ag4 -","4","0.0208333","","Davey, W. P.","Lattice constants of twelve common metals Locality: synthetic Note: lattice parameter is average of runs 1 & 2","Physical Review","1925","25","","753","761","10.1103/PhysRev.25.753","","","","","","","","","","","","","","","","","","","","","has coordinates","264647","2021-04-28","11:19:17",""
"9011608","4.058","","4.058","","4.058","","90","","90","","90","","66.825","","","","","","","","","","","","","1","F m -3 m","-F 4 2 3","225","Silver","","Silver","- Ag -","- Ag -","- Ag4 -","4","0.0208333","","Davey, W. P.","Lattice constants of twelve common metals Locality: synthetic Note: lattice parameter is average of runs 3 & 4","Physical Review","1925","25","","753","761","10.1103/PhysRev.25.753","","","","","","","","","","","","","","","","","","","","","has coordinates","264647","2021-04-28","11:19:17",""
"9011609","3.155","","3.155","","3.155","","90","","90","","90","","31.405","","","","","","","","","","","","","1","I m -3 m","-I 4 2 3","229","Tungsten","","Tungsten","- W -","- W -","- W2 -","2","0.0208333","","Davey, W. P.","Lattice constants of twelve common metals Locality: synthetic Note: lattice parameter is average of runs 1 & 2","Physical Review","1925","25","","753","761","10.1103/PhysRev.25.753","","","","","","","","","","","","","","","","","","","","","has coordinates","264647","2021-04-28","11:19:17",""
"9011610","3.157","","3.157","","3.157","","90","","90","","90","","31.465","","","","","","","","","","","","","1","I m -3 m","-I 4 2 3","229","Tungsten","","Tungsten","- W -","- W -","- W2 -","2","0.0208333","","Davey, W. P.","Lattice constants of twelve common metals Locality: synthetic Note: run 3","Physical Review","1925","25","","753","761","10.1103/PhysRev.25.753","","","","","","","","","","","","","","","","","","","","","has coordinates","264647","2021-04-28","11:19:17",""
"9011611","3.158","","3.158","","3.158","","90","","90","","90","","31.495","","","","","","","","","","","","","1","I m -3 m","-I 4 2 3","229","Tungsten","","Tungsten","- W -","- W -","- W2 -","2","0.0208333","","Davey, W. P.","Lattice constants of twelve common metals Locality: synthetic Note: lattice parameter is average of runs 3 & 4","Physical Review","1925","25","","753","761","10.1103/PhysRev.25.753","","","","","","","","","","","","","","","","","","","","","has coordinates","264647","2021-04-28","11:19:17",""
"9011612","4.065","","4.065","","4.065","","90","","90","","90","","67.171","","","","","","","","","","","","","1","F m -3 m","-F 4 2 3","225","Gold","","Gold","- Au -","- Au -","- Au4 -","4","0.0208333","","Davey, W. P.","Lattice constants of twelve common metals Locality: synthetic Note: lattice parameter is average of runs 1 & 2","Physical Review","1925","25","","753","761","10.1103/PhysRev.25.753","","","","","","","","","","","","","","","","","","","","","has coordinates","264647","2021-04-28","11:19:17",""
"9011613","4.073","","4.073","","4.073","","90","","90","","90","","67.568","","","","","","","","","","","","","1","F m -3 m","-F 4 2 3","225","Gold","","Gold","- Au -","- Au -","- Au4 -","4","0.0208333","","Davey, W. P.","Lattice constants of twelve common metals Locality: synthetic Note: lattice parameter is average of runs 1,2 & 3","Physical Review","1925","25","","753","761","10.1103/PhysRev.25.753","","","","","","","","","","","","","","","","","","","","","has coordinates","264647","2021-04-28","11:19:17",""
"9011614","4.539","","4.539","","11.829","","90","","90","","120","","211.057","","","","","","","","","","","","","1","P 63/m m c","-P 6c 2c","194","Bismuth","","Bismuth","- Bi -","- Bi -","- Bi2 -","2","0.0833333","","Davey, W. P.","Lattice constants of twelve common metals Locality: synthetic Note: lattice parameter is average of runs 1 & 2","Physical Review","1925","25","","753","761","10.1103/PhysRev.25.753","","","","","","","","","","","","","","","","","","","","","has coordinates","264647","2021-04-28","11:19:17",""
"9013414","2.858","","2.858","","2.858","","90","","90","","90","","23.345","","","","","","","","","","","","","1","I m -3 m","-I 4 2 3","229","Iron","","Iron","- Fe -","- Fe -","- Fe2 -","2","0.0208333","","Davey, W. P.","Lattice constants of twelve common metals Locality: synthetic Note: lattice parameter is average of runs 1 & 2","Physical Review","1925","25","","753","761","10.1103/PhysRev.25.753","","","","","","","","","","","","","","","","","","","","","has coordinates","264647","2021-04-28","11:19:17",""
"9013415","2.855","","2.855","","2.855","","90","","90","","90","","23.271","","","","","","","","","","","","","1","I m -3 m","-I 4 2 3","229","Iron","","Iron","- Fe -","- Fe -","- Fe2 -","2","0.0208333","","Davey, W. P.","Lattice constants of twelve common metals Locality: synthetic Note: lattice parameter is average of runs 3 & 4","Physical Review","1925","25","","753","761","10.1103/PhysRev.25.753","","","","","","","","","","","","","","","","","","","","","has coordinates","264647","2021-04-28","11:19:17",""
"9013416","3.859","","3.859","","3.859","","90","","90","","90","","57.468","","","","","","","","","","","","","1","F m -3 m","-F 4 2 3","225","Palladium","","Palladium","- Pd -","- Pd -","- Pd4 -","4","0.0208333","","Davey, W. P.","Lattice constants of twelve common metals Locality: synthetic Note: lattice parameter is average of runs 1 & 2","Physical Review","1925","25","","753","761","10.1103/PhysRev.25.753","","","","","","","","","","","","","","","","","","","","","has coordinates","264647","2021-04-28","11:19:17",""
"9013417","3.912","","3.912","","3.912","","90","","90","","90","","59.868","","","","","","","","","","","","","1","F m -3 m","-F 4 2 3","225","Platinum","","Platinum","- Pt -","- Pt -","- Pt4 -","4","0.0208333","","Davey, W. P.","Lattice constants of twelve common metals Locality: synthetic Note: lattice parameter is average of three runs","Physical Review","1925","25","","753","761","10.1103/PhysRev.25.753","","","","","","","","","","","","","","","","","","","","","has coordinates","264647","2021-04-28","11:19:17",""
"9013418","4.92","","4.92","","4.92","","90","","90","","90","","119.095","","","","","","","","","","","","","1","F m -3 m","-F 4 2 3","225","Lead","","Lead","- Pb -","- Pb -","- Pb4 -","4","0.0208333","","Davey, W. P.","Lattice constants of twelve common metals Locality: synthetic Note: lattice parameter is average of runs 1 & 2","Physical Review","1925","25","","753","761","10.1103/PhysRev.25.753","","","","","","","","","","","","","","","","","","","","","has coordinates","264647","2021-04-28","11:19:17",""