# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-24T12:46:21+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 'Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers') AND volume = 200 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
"1522697","3.009","","3.009","","4.041","","90","","90","","90","","36.588","","","","","","","","","","","","","2","P 4/m m m","-P 4 2","123","","","","- Hg Ti -","- Hg Ti -","- Hg Ti -","1","0.0625","","Pietrokowsky, P.","A cursory investigation of intermediate phases in the systems Ti-Zn, Ti-Hg, Zr-Zn, Zr-Cd, and Zr-Hg by X-ray powder methods","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1954","200","","219","226","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1522698","4.1654","","4.1654","","4.1654","","90","","90","","90","","72.272","","","","","","","","","","","","","2","P m -3 m","-P 4 2 3","221","","","","- Hg Ti3 -","- Hg Ti3 -","- Hg Ti3 -","1","0.0208333","","Pietrokowsky, P.","A cursory investigation of intermediate phases in the systems Ti-Zn, Ti-Hg, Zr-Zn, Zr-Cd, and Zr-Hg by X-ray powder methods","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1954","200","","219","226","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1522699","3.147","","3.147","","4.17","","90","","90","","90","","41.298","","","","","","","","","","","","","2","P 4/m m m","-P 4 2","123","","","","- Hg Zr -","- Hg Zr -","- Hg Zr -","1","0.0625","","Pietrokowsky, P.","A cursory investigation of intermediate phases in the systems Ti-Zn, Ti-Hg, Zr-Zn, Zr-Cd, and Zr-Hg by X-ray powder methods","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1954","200","","219","226","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1522700","4.3652","","4.3652","","4.3652","","90","","90","","90","","83.179","","","","","","","","","","","","","2","P m -3 m","-P 4 2 3","221","","","","- Hg3 Zr -","- Hg3 Zr -","- Hg3 Zr -","1","0.0208333","","Pietrokowsky, P.","A cursory investigation of intermediate phases in the systems Ti-Zn, Ti-Hg, Zr-Zn, Zr-Cd, and Zr-Hg by X-ray powder methods","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1954","200","","219","226","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1524399","5.826","","5.826","","7.328","","90","","90","","90","","248.729","","","","","","","","","","","","","2","P 42/m","-P 4c","84","","","","- Cu4 Pd -","- Cu4 Pd -","- Cu16 Pd4 -","4","0.5","","Geisler, A.H.; Newkirk, J.B.","Ordering reaction of the Cu4 Pd alloys","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1954","200","","1076","1082","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1527930","5.064","","5.064","","8.21","","90","","90","","120","","182.331","","","","","","","","","","","","","2","P 63/m m c","-P 6c 2c","194","","","","- Ti Zn2 -","- Ti Zn2 -","- Ti4 Zn8 -","4","0.166667","","Pietrokowsky, P.","A cursory investigation of intermediate phases Zr1-x Tix M2 and Hf1-x Tix M2 (M= Mo or W) systems","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1954","200","","219","226","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1527931","3.9322","","3.9322","","3.9322","","90","","90","","90","","60.8","","","","","","","","","","","","","2","P m -3 m","-P 4 2 3","221","","","","- Ti Zn3 -","- Ti Zn3 -","- Ti Zn3 -","1","0.0208333","","Pietrokowsky, P.","A cursory investigation of intermediate phases Zr1-x Tix M2 and Hf1-x Tix M2 (M= Mo or W) systems","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1954","200","","219","226","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1540812","4.817","","4.817","","2.844","","90","","90","","120","","57.15","","","","","","","","","","","","","2","P 6/m m m","-P 6 2","191","","","","- Ti U2 -","- Ti U2 -","- Ti U2 -","1","0.0416667","","Udy, M.C.; Boulger, F.W.","Uranium-titanium alloy system","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1954","200","","207","210","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""