# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-28T07:57: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 Japan Institute of Metals') AND volume = 27 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
"1521751","4.945","","4.945","","4.945","","90","","90","","90","","120.92","","","","","","","","","","","","","3","P m -3 n","-P 4n 2 3","223","","(Fe0.2 V0.8)3 Sn","","- Fe0.6 Sn V2.4 -","- Fe0.6 Sn V2.4 -","- Fe1.2 Sn2 V4.8 -","2","0.0416667","","Kanematsu, K.","Stability of the Crystal Structure of (Fe, V)~3~M and (Fe, Ni)~3~M (M= Si, Ge, Sn) and its Analysis Based on Rigid Band Model","Transactions of the Japan Institute of Metals","1986","27","4","225","232","10.2320/matertrans1960.27.225","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1538633","3.542","","3.542","","3.542","","90","","90","","90","","44.437","","","","","","","","","","","","","2","P m -3 m","-P 4 2 3","221","","","","- Ni3 Si -","- Ni3 Si -","- Ni3 Si -","1","0.0208333","","Kanematsu, K.","Stability of the Crystal Structure of (Fe, V)~3~M and (Fe, Ni)~3~M (M= Si, Ge, Sn) and its Analysis Based on Rigid Band Model","Transactions of the Japan Institute of Metals","1986","27","4","225","232","10.2320/matertrans1960.27.225","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1540204","4.97","","4.97","","4.97","","90","","90","","90","","122.763","","","","","","","","","","","","","2","P m -3 n","-P 4n 2 3","223","","","","- Sn V3 -","- Sn V3 -","- Sn2 V6 -","2","0.0416667","","Kanematsu, K.","Stability of the Crystal Structure of (Fe, V)~3~M and (Fe, Ni)~3~M (M= Si, Ge, Sn) and its Analysis Based on Rigid Band Model","Transactions of the Japan Institute of Metals","1986","27","4","225","232","10.2320/matertrans1960.27.225","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"9014751","5.644","","5.644","","5.644","","90","","90","","90","","179.788","","","","","","","","","","","","Synthetic","2","F m -3 m","-F 4 2 3","225","","","Gupeiite","- Fe3 Si -","- Fe3 Si -","- Fe12 Si4 -","4","0.0208333","","Kanematsu, K.","Stability of crystal structure of (Fe,V)3M and (Fe,Ni)3M (M=Si,Ge,Sn) and its analysis based on rigid band model","Transactions of the Japan Institute of Metals","1986","27","","225","232","10.2320/matertrans1960.27.225","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:18",""