# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-21T19:10:17+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 'Journal of the Japan Institut of Metals (see: Nihon Kinzoku Gakkai-Shi)') AND volume = 47 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
"1509124","2.791","","2.791","","3.687","","90","","90","","90","","28.721","","","","","","","","","","","","","3","P 4/m m m","-P 4 2","123","","Silver gold copper (0.08/0.92/1)","","- Ag0.08 Au0.92 Cu -","- Ag0.08 Au0.92 Cu -","- Ag0.08 Au0.92 Cu -","1","0.0625","","Ishibata, S.; Kogachi, M.","Effect of additional elements on the axial ratio of the Cu Au L1,0-type ordered alloy","Journal of the Japan Institut of Metals (see: Nihon Kinzoku Gakkai-Shi)","1983","47","","912","917","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1510353","3.88","","3.88","","3.7","","90","","90","","90","","55.701","","","","","","","","","","","","","3","P 4/m m m","-P 4 2","123","","(Au9 Cu10 Ni)0.2","","- Au1.8 Cu2 Ni0.2 -","- Au1.8 Cu2 Ni0.2 -","- Au1.8 Cu2 Ni0.2 -","1","0.0625","","Kogachi, M.; Ishibata, S.","Effect of additional elements on the axial ratio of the CuAuL1o-type ordered alloys","Journal of the Japan Institut of Metals (see: Nihon Kinzoku Gakkai-Shi)","1983","47","","912","917","","","","","","","","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00",""
"1538829","3.281","","3.281","","5","","90","","90","","90","","53.825","","","","","","","","","","","","","2","I 4/m m m","-I 4 2","139","","","","- In1.74 Pb0.26 -","- In1.74 Pb0.26 -","- In1.74 Pb0.26 -","1","0.03125","","Koyama, Y.; Ukena, T.; Morikawa, K.; Nittono, O.","Martensitic transformations in indium - (13-x)at.% lead - x at.% tin pseudobinary alloys","Journal of the Japan Institut of Metals (see: Nihon Kinzoku Gakkai-Shi)","1983","47","","919","926","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1538831","3.27","","3.27","","5.02","","90","","90","","90","","53.678","","","","","","","","","","","","","3","I 4/m m m","-I 4 2","139","","Pb0.13 Sn0.13 In1.74","","- In1.74 Pb0.13 Sn0.13 -","- In1.74 Pb0.13 Sn0.13 -","- In1.74 Pb0.13 Sn0.13 -","1","0.03125","","Koyama, Y.; Ukena, T.; Morikawa, K.; Nittono, O.","Martensitic transformations in indium - (13-x)at.% lead - x at.% tin pseudobinary alloys","Journal of the Japan Institut of Metals (see: Nihon Kinzoku Gakkai-Shi)","1983","47","","919","926","","","","","","","","","","","","","","","","","","","","","","has coordinates","167523","2020-10-21","18:00:00",""
"1538833","3.25","","3.25","","5.05","","90","","90","","90","","53.341","","","","","","","","","","","","","2","I 4/m m m","-I 4 2","139","","","","- In1.74 Sn0.26 -","- In1.74 Sn0.26 -","- In1.74 Sn0.26 -","1","0.03125","","Koyama, Y.; Morikawa, K.; Ukena, T.; Nittono, O.","Martensitic transformations in indium - (13-x)at.% lead - x at.% tin pseudobinary alloys","Journal of the Japan Institut of Metals (see: Nihon Kinzoku Gakkai-Shi)","1983","47","","919","926","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1538835","3.39","","3.39","","4.47","","90","","90","","90","","51.37","","","","","","","","","","","","","2","I 4/m m m","-I 4 2","139","","","","- In1.74 Sn0.26 -","- In1.74 Sn0.26 -","- In1.74 Sn0.26 -","1","0.03125","","Koyama, Y.; Ukena, T.; Morikawa, K.; Nittono, O.","Martensitic transformations in indium - (13-x)at.% lead - x at.% tin pseudobinary alloys","Journal of the Japan Institut of Metals (see: Nihon Kinzoku Gakkai-Shi)","1983","47","","919","926","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""