# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-28T11:00:01+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 = 206 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
"1523370","5.086","","5.086","","5.086","","90","","90","","90","","131.562","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","(Nb0.035 Th0.965)","","- Nb0.035 Th0.965 -","- Nb0.035 Th0.965 -","- Nb0.14 Th3.86 -","4","0.0208333","","Carlson, O.N.; Lunt, H.E.; Dickinson, J.M.; Wilhelm, H.A.","Thorium-columbium and thorium-titanium alloy systems","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1956","206","","132","136","","","","","","","","","","","","","","","","","","","","","","has coordinates","143985","2020-10-21","18:00:00",""
"1523721","2.782","","2.782","","4.477","","90","","90","","120","","30.008","","","","","","","","","","","","","2","P 63/m m c","-P 6c 2c","194","","(Mo0.576 Pt0.424)","","- Mo0.576 Pt0.424 -","- Mo0.576 Pt0.424 -","- Mo1.152 Pt0.848 -","2","0.0833333","","Greenfield, P.; Beck, P.A.","Intermediate phases in binary systems of certain transition elements","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1956","206","","265","276","","","","","","","","","","","","","","","","","","","","","","has coordinates","144343","2020-10-21","18:00:00",""
"1523722","2.715","","2.715","","4.34","","90","","90","","120","","27.705","","","","","","","","","","","","","2","P 63/m m c","-P 6c 2c","194","","(Mo0.27 Rh0.73)","","- Mo0.27 Rh0.73 -","- Mo0.27 Rh0.73 -","- Mo0.54 Rh1.46 -","2","0.0833333","","Greenfield, P.; Beck, P.A.","Intermediate phases in binary systems of certain transition elements","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1956","206","","265","276","","","","","","","","","","","","","","","","","","","","","","has coordinates","144344","2020-10-21","18:00:00",""
"1523723","4.808","","4.808","","4.808","","90","","90","","90","","111.146","","","","","","","","","","","","","2","P m -3 n","-P 4n 2 3","223","","","","- Pt V3 -","- Pt V3 -","- Pt2 V6 -","2","0.0416667","","Greenfield, P.; Beck, P.A.","Intermediate phases in binary systems of certain transition elements","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1956","206","","265","276","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1523724","2.708","","2.708","","4.328","","90","","90","","120","","27.486","","","","","","","","","","","","","2","P 63/m m c","-P 6c 2c","194","","(Rh0.808 W0.192)","","- Rh0.808 W0.192 -","- Rh0.808 W0.192 -","- Rh1.616 W0.384 -","2","0.0833333","","Greenfield, P.; Beck, P.A.","Intermediate phases in binary systems of certain transition elements","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1956","206","","265","276","","","","","","","","","","","","","","","","","","","","","","has coordinates","144346","2020-10-21","18:00:00",""
"1524445","4.706","","4.706","","4.706","","90","","90","","90","","104.221","","","","","","","","","","","","","2","P m -3 n","-P 4n 2 3","223","","","","- Cr3 Pt -","- Cr3 Pt -","- Cr6 Pt2 -","2","0.0416667","","Greenfield, P.; Beck, P.A.","Intermediate phases in binary systems of certain transition elements","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1956","206","","265","276","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1527436","2.96","","2.96","","3.09","","90","","90","","90","","27.073","","","","","","","","","","","","","2","P 4/m m m","-P 4 2","123","","","","- Ru V -","- Ru V -","- Ru V -","1","0.0625","","Greenfield, P.; Beck, P.A.","Intermediate phases in binary systems of certain transition elements","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1956","206","","265","276","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1537897","4.6347","","4.6347","","4.6347","","90","","90","","90","","99.555","","","","","","","","","","","","","1","F m -3 m","-F 4 2 3","225","","","","- Pu -","- Pu -","- Pu4 -","4","0.0208333","","Ellinger, F.H.","Crystal structure of delta' plutonium and the thermal expansion characteristics of delta, delta' and epsilon plutonium","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1956","206","","1256","1259","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1538188","4.767","","4.767","","4.767","","90","","90","","90","","108.327","","","","","","","","","","","","","2","P m -3 n","-P 4n 2 3","223","","","","- Rh V3 -","- Rh V3 -","- Rh2 V6 -","2","0.0416667","","Greenfield, P.; Beck, P.A.","Intermediate phases in binary systems of certain transition elements","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1956","206","","265","276","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1538191","3.02","","3.02","","3.37","","90","","90","","90","","30.736","","","","","","","","","","","","","2","P 4/m m m","-P 4 2","123","","","","- Ru Ta -","- Ru Ta -","- Ru Ta -","1","0.0625","","Greenfield, P.; Beck, P.A.","Intermediate phases in binary systems of certain transition elements","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1956","206","","265","276","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1538194","5.11","","5.11","","5.11","","90","","90","","90","","133.433","","","","","","","","","","","","","2","P m -3 n","-P 4n 2 3","223","","","","- Nb3 Pt -","- Nb3 Pt -","- Nb6 Pt2 -","2","0.0416667","","Greenfield, P.; Beck, P.A.","Intermediate phases in binary systems of certain transition elements","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1956","206","","265","276","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1538197","5.115","","5.115","","5.115","","90","","90","","90","","133.825","","","","","","","","","","","","","2","P m -3 n","-P 4n 2 3","223","","","","- Nb3 Rh -","- Nb3 Rh -","- Nb6 Rh2 -","2","0.0416667","","Greenfield, P.; Beck, P.A.","Intermediate phases in binary systems of certain transition elements","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1956","206","","265","276","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1538200","3","","3","","3.38","","90","","90","","90","","30.42","","","","","","","","","","","","","2","P 4/m m m","-P 4 2","123","","","","- Nb Ru -","- Nb Ru -","- Nb Ru -","1","0.0625","","Greenfield, P.; Beck, P.A.","Intermediate phases in binary systems of certain transition elements","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1956","206","","265","276","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""