# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-24T19:33:14+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 'Proceedings of the Japan Academy') 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
"1537454","7.1566","","9.1995","","8.9585","","91.75","","98.14","","77.3","","569.575","","","","","","","","","","","","","7","P -1","-P 1","2","","Fe Ca2 Al2 (B O3) (Si4 O12) O H","","- Al2 B Ca2 Fe H O16 Si4 -","- Al2 B Ca2 Fe O16 Si4 -","- Al4 B2 Ca4 Fe2 O32 Si8 -","2","1","","Ito, Tei-ichi; Takéuchi, Yoshio; Ozawa, Toru; Araki, Takaharu; Zoltai, Tibor; Finney, J. J.","The crystal Structure of Axinite Revised","Proceedings of the Japan Academy","1969","45","6","490","494","10.2183/pjab1945.45.490","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"9012885","13.712","","31.21","","4.131","","90","","90","","90","","1767.87","","","","","","","","","","","","Yakuki mine, Fukushima Prefecture, Japan","3","B b m m","-B 2 2b","63","","","Heyrovskyite","- Bi2 Pb6 S9 -","- Bi2 Pb6 S9 -","- Bi8 Pb24 S36 -","4","0.25","","Takeuchi, Yoshio; Takagi, Junkou","The Structure of Heyrovskyite (6PbS•Bi~2~S~3~)","Proceedings of the Japan Academy","1974","50","1","76","79","10.2183/pjab1945.50.76","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:48",""
"9012890","7.94","","7.32","","7.07","","90.03","","95.37","","103.43","","397.818","","","","","","","","","","","","","3","P -1","-P 1","2","","","Wollastonite-1A","- Ca O3 Si -","- Ca O3 Si -","- Ca6 O18 Si6 -","6","3","","Ito, Tei-ichi; Sadanaga, Ryoichi; Tak'euchi, Yoshio; Tokonami, Masayasu","The Existence of Partial Mirrors in Wollastonite","Proceedings of the Japan Academy","1969","45","10","913","918","10.2183/pjab1945.45.913","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:48",""