# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-01T05:24: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 'Transactions of the American Society for Metals') AND volume = 50 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
"1523086","3.3","","3.3","","3.3","","90","","90","","90","","35.937","","","","","","","","","","","","","2","I m -3 m","-I 4 2 3","229","","(Nb Ta)","","- Nb Ta -","- Nb Ta -","- Nb Ta -","1","0.0104167","","Williams, D.E.; Pechin, W.H.; Sokolovskaya, E.M.","The tantalum-columbium alloy system","Transactions of the American Society for Metals","1958","50","","1081","1089","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1523672","5.07","","5.07","","5.07","","90","","90","","90","","130.324","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","(Hf0.064 Th0.936)","","- Hf0.064 Th0.936 -","- Hf0.064 Th0.936 -","- Hf0.256 Th3.744 -","4","0.0208333","","Gibson, E.T.; Carlson, O.N.; Loomis, B.A.","Thorium-zirconium and thorium-hafnium alloy systems","Transactions of the American Society for Metals","1958","50","","348","349","","","","","","","","","","","","","","","","","","","","","","has coordinates","144293","2020-10-21","18:00:00",""
"1537904","7.577","","7.577","","7.577","","90","","90","","90","","435.003","","","","","","","","","","","","","2","F d -3 m :1","F 4d 2 3 -1d","227","","","","- Hf Mo2 -","- Hf Mo2 -","- Hf8 Mo16 -","8","0.0416667","","Elliott, R.P.; Rostoker, W.","The occurence of Laves-type phases among transition elements","Transactions of the American Society for Metals","1958","50","","617","633","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1537905","7.412","","7.412","","7.412","","90","","90","","90","","407.199","","","","","","","","","","","","","2","F d -3 m :1","F 4d 2 3 -1d","227","","","","- Hf V2 -","- Hf V2 -","- Hf8 V16 -","8","0.0416667","","Elliott, R.P.; Rostoker, W.","The occurence of Laves-type phases among transition elements","Transactions of the American Society for Metals","1958","50","","617","633","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1537906","7.571","","7.571","","7.571","","90","","90","","90","","433.97","","","","","","","","","","","","","2","F d -3 m :1","F 4d 2 3 -1d","227","","","","- Hf W2 -","- Hf W2 -","- Hf8 W16 -","8","0.0416667","","Elliott, R.P.; Rostoker, W.","The occurence of Laves-type phases among transition elements","Transactions of the American Society for Metals","1958","50","","617","633","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1539740","7.615","","7.615","","7.615","","90","","90","","90","","441.58","","","","","","","","","","","","","2","F d -3 m :1","F 4d 2 3 -1d","227","","","","- W2 Zr -","- W2 Zr -","- W16 Zr8 -","8","0.0416667","","Elliott, R.P.; Rostoker, W.","The occurence of Laves-type phases among transition elements","Transactions of the American Society for Metals","1958","50","","617","633","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""