# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-26T16:48: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 Ceramic Association, Japan') AND volume = 73 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
"1541698","9.09","","9.09","","9.09","","90","","90","","90","","751.089","","","","","","","","","","","","","6","I -4 3 m","I -4 2 3","217","","Na6 Ca2 (Al6 Si6 O24) (S O4)2","","- Al6 Ca2 Na6 O32 S2 Si6 -","- Al6 Ca2 Na6 O32 S2 Si6 -","- Al6 Ca2 Na6 O32 S2 Si6 -","1","0.0208333","","Kondo, R.","The Synthesis and Crystallography of a Group of New Compounds Belonging to the Hauyne Type Structure","Journal of the Ceramic Association, Japan","1965","73","832","101","108","10.2109/jcersj1950.73.101","","","","","","","","","","","","","","","","","","","","","has coordinates","175163","2020-10-21","18:00:00",""
"1541779","9.29","","9.29","","9.29","","90","","90","","90","","801.765","","","","","","","","","","","","","4","I -4 3 m","I -4 2 3","217","","Ca4 (Al6 O12) (W O4)","","- Al6 Ca4 O16 W -","- Al6 Ca4 O16 W -","- Al12 Ca8 O32 W2 -","2","0.0416667","","Kondo, R.","The Synthesis and Crystallography of a Group of New Compounds Belonging to the Hauyne Type Structure","Journal of the Ceramic Association, Japan","1965","73","832","101","108","10.2109/jcersj1950.73.101","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1542034","9.19","","9.19","","9.19","","90","","90","","90","","776.152","","","","","","","","","","","","","4","I 2 3","I 2 2 3","197","","Ca4 (Al6 O12) (S O4)","","- Al6 Ca4 O16 S -","- Al6 Ca4 O16 S -","- Al12 Ca8 O32 S2 -","2","0.0833333","","Kondo, R.","The Synthesis and Crystallography of a Group of New Compounds Belonging to the Hauyne Type Structure","Journal of the Ceramic Association, Japan","1965","73","832","101","108","10.2109/jcersj1950.73.101","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1542036","9.4","","9.4","","9.4","","90","","90","","90","","830.584","","","","","","","","","","","","","4","I 2 3","I 2 2 3","197","","Sr4 (Al6 O12) (S O4)","","- Al6 O16 S Sr4 -","- Al6 O16 S Sr4 -","- Al12 O32 S2 Sr8 -","2","0.0833333","","Kondo, R.","The Synthesis and Crystallography of a Group of New Compounds Belonging to the Hauyne Type Structure","Journal of the Ceramic Association, Japan","1965","73","832","101","108","10.2109/jcersj1950.73.101","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1542038","9.42","","9.42","","9.42","","90","","90","","90","","835.897","","","","","","","","","","","","","4","I 2 3","I 2 2 3","197","","Sr4 (Al6 O12) (W O4)","","- Al6 O16 Sr4 W -","- Al6 O16 Sr4 W -","- Al12 O32 Sr8 W2 -","2","0.0833333","","Kondo, R.","The Synthesis and Crystallography of a Group of New Compounds Belonging to the Hauyne Type Structure","Journal of the Ceramic Association, Japan","1965","73","832","101","108","10.2109/jcersj1950.73.101","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1542181","5.772","","10.225","","7.513","","90","","90","","90","","443.407","","","","","","","","","","","","","3","P m c n","-P 2n 2a","62","","Ba2 (Si O4)","","- Ba2 O4 Si -","- Ba2 O4 Si -","- Ba8 O16 Si4 -","4","0.5","","Uchikawa, H.; Tsukiyama, K.","Indexing of the Powder X-ray Diffraction Patterns and Precise Determination of the Crystal Structure of Ba~2~SiO~4~","Journal of the Ceramic Association, Japan","1965","73","837","106","110","10.2109/jcersj1950.73.837_106","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""