# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-01T07:47:36+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 = 209 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
"1525450","4.677","","4.677","","4.677","","90","","90","","90","","102.306","","","","","","","","","","","","","2","P m -3 n","-P 4n 2 3","223","","","","- Cr3 Os -","- Cr3 Os -","- Cr6 Os2 -","2","0.0416667","","Waterstrat, R.M.; Kasper, J.S.","X-ray diffraction study of the sigma-phase in the systems Re - Cr, Ru - Cr, and Os - Cr","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1957","209","","872","873","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1539012","3.104","","3.104","","3.104","","90","","90","","90","","29.906","","","","","","","","","","","","","2","P m -3 m","-P 4 2 3","221","","","","- Re Ti -","- Re Ti -","- Re Ti -","1","0.0208333","","Philip, T.V.; Beck, P.A.","CsCl-type ordered structures in binary alloys of transition elements","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1957","209","","1269","1271","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1540214","4.03","","4.03","","4.03","","90","","90","","90","","65.451","","","","","","","","","","","","","2","P m -3 m","-P 4 2 3","221","","U Si3","","- Si3 U -","- Si3 U -","- Si3 U -","1","0.0208333","","Kaufmann, A.; Cullity, B.; Bitsianes, G.","Uranium-silicon alloys","Transactions of the American Institute of Mining, Metallurgical and Petroleum Engineers","1957","209","","23","27","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""