# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-28T10:41:11+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 Physical Society of Japan') AND volume = 17 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
"1510519","5.586","","5.586","","33.4","","90","","90","","90","","1042.19","","","","","","","","","","","","","2","I 41/a c d :1","I 4bw 2aw -1bw","142","","","","- Au3 Zn -","- Au3 Zn -","- Au48 Zn16 -","16","0.5","","Iwasaki, H.","Study on the ordered phases with long period in the gold-zinc alloy system. II. Structure analysis of Au3 Zn (R1), Au3 Zn (R2) and Au3+Zn","Journal of the Physical Society of Japan","1962","17","","1620","1633","10.1143/JPSJ.17.1620","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1510520","16.65","","5.585","","5.594","","90","","90","","90","","520.187","","","","","","","","","","","","","2","C m c a","-C 2ac 2","64","","","","- Au3 Zn -","- Au3 Zn -","- Au24 Zn8 -","8","","","Iwasaki, H.","Study on the ordered phases with long period in the gold-zinc system. II.Structure analysis of Au3 Zn and Au3+ Zn","Journal of the Physical Society of Japan","1962","17","","1620","1633","10.1143/JPSJ.17.1620","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1510573","6.345","","8.971","","4.486","","90","","90","","90","","255.348","","","","","","","","","","","","","2","P m c 21","P 2c -2","26","","","","- Au5 Zn3 -","- Au5 Zn3 -","- Au10 Zn6 -","2","0.5","","Iwasaki, H.","The crystal structure and the phase transition of a metastable phase in the Au.662 Zn.378 alloy","Journal of the Physical Society of Japan","1962","17","","1620","1633","10.1143/JPSJ.17.1620","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1514105","4.444","0.001","4.444","","4.444","","90","","90","","90","","87.77","0.02","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Manganese Oxide","Manganosite","- Mn O -","- Mn O -","- Mn4 O4 -","4","0.0208333","","Kuriyama, M.; Hosoya, S.","X-ray measurement of scattering factors of manganese and oxygen in manganous oxide","Journal of the Physical Society of Japan","1962","17","","1022","1029","10.1143/JPSJ.17.1022","","","","","","","","","","","","","","","","","","","","","has coordinates","176808","2020-10-21","18:00:00",""
"1522568","3.288","","3.288","","3.313","","90","","90","","90","","35.817","","","","","","","","","","","","","2","P 4/m m m","-P 4 2","123","","","","- Hg Mn -","- Hg Mn -","- Hg Mn -","1","0.0625","","Nakagawa, Y.; Hori, T.","Magnetic transition and crystal distortion in Mn Hg and Mn Zn3","Journal of the Physical Society of Japan","1962","17","","1313","1314","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1538842","3.867","","3.867","","3.867","","90","","90","","90","","57.826","","","","","","","","","","","","","2","P m -3 m","-P 4 2 3","221","","","","- Mn4 N -","- Mn4 N -","- Mn4 N -","1","0.0208333","","Mekata, M.","Magnetic study on Mn4 N and its related compounds","Journal of the Physical Society of Japan","1962","17","","796","803","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1539089","4.498","","4.498","","4.498","","73.93","","73.93","","73.93","","82.032","","","","","","","","","","","","","3","R 3 m :R","P 3* -2","160","","K (N O3)","","- K N O3 -","- K N O3 -","- K N O3 -","1","0.166667","","Shinnaka, Y.","X-ray study on the disordered structure above the ferroelectric curie point in potassium nitrate","Journal of the Physical Society of Japan","1962","17","","820","828","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1541639","8.064","","8.064","","8.064","","90","","90","","90","","524.387","","","","","","","","","","","","","4","F m -3 m","-F 4 2 3","225","","Ba2 Ni (W O6)","","- Ba2 Ni O6 W -","- Ba2 Ni O6 W -","- Ba8 Ni4 O24 W4 -","4","0.0208333","","Nomura, S.; Kawakubo, T.","Phase transition in Sr (Ni W).5 O3 - Ba (Ni W).5 O3 system","Journal of the Physical Society of Japan","1962","17","","1771","1776","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""