# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2026-02-16T08:52:20+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 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
"1200015","7.906","","7.906","","7.906","","90","","90","","90","","494.2","","","","","","","","","","","","","2","F d -3 m :1","F 4d 2 3 -1d","227","","Aluminium oxide - η","","- Al2.66 O4 -","- Al2.669 O4 -","- Al21.352 O32 -","8","0.0416667","","Shirasuka, K.; Yanagida, H.; Yamaguchi, G.","The Preparation of η Alumina and its Structure","Journal of the Ceramic Association, Japan","1976","84","976","610","613","10.2109/jcersj1950.84.976_610","","","","","","0.06","","","","","","","","","","","","","","","has coordinates","201954","2020-10-21","18:00:00",""
"1511172","6.371","","6.365","","6.885","","90","","90","","90","","279.196","","","","","","","","","","","","","4","F m m 2","F 2 -2","42","","Li (B Ge O4)","","- B Ge Li O4 -","- B Ge Li O4 -","- B4 Ge4 Li4 O16 -","4","0.25","","Ihara, M.","The crystal structure of lithium boro-germanate, Li~2~OB~2~O~3~(GeO~2~)~2~","Journal of the Ceramic Association, Japan","1971","79","909","152","155","10.2109/jcersj1950.79.909_152","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1524597","6.618","","11.944","","5.724","","90","","90","","90","","452.456","","","","","","","","","","","","","5","C m c m","-C 2c 2","63","","(N H4) Al (C O3) (O H)2","","- C H6 Al N O5 -","- C Al N O5 -","- C4 Al4 N4 O20 -","4","0.25","","Iga, T.; Kato, S.","Crystal structure of NH~4~-dawsonite","Journal of the Ceramic Association, Japan","1978","86","999","509","512","10.2109/jcersj1950.86.999_509","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1530862","10.107","","11.485","","12.76","","90","","91.54","","90","","1480.63","","","","","","","","","","","","","4","P 1 21/c 1","-P 2ybc","14","","K3 Al B8 O15","","- Al B8 K3 O15 -","- Al B8 K3 O15 -","- Al4 B32 K12 O60 -","4","1","","Tanaka, Y.; Fukunaga, J.; Setoguchi, M.; Higashi, T.; Ihara, M.","The Crystal Structure of Tripotassium Aluminate Octaborate K~3~AlB~8~O~15~","Journal of the Ceramic Association, Japan","1982","90","1044","458","463","10.2109/jcersj1950.90.1044_458","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1534460","10.4579","","10.4579","","10.4579","","90","","90","","90","","1143.76","","","","","","","","","","","","","2","I a -3","-I 2b 2c 3","206","","Yb2 O3","","- O3 Yb2 -","- O3 Yb2 -","- O48 Yb32 -","16","0.333333","","Saiki, A.; Ishizawa, N.; Mizutani, N.; Kato, M.","Structural change of C-rare Earth sesquioxides Yb~2~O~3~ and Er~2~O~3~ as a function of temperature","Journal of the Ceramic Association, Japan","1985","93","1082","649","654","10.2109/jcersj1950.93.1082_649","","","","","","","","","","","","","","","","","","","","","has coordinates","175177","2020-10-21","18:00:00",""
"1534469","10.566","","10.566","","10.566","","90","","90","","90","","1179.59","","","","","","","","","","","","","2","I a -3","-I 2b 2c 3","206","","","","- Er2 O3 -","- Er2 O3 -","- Er32 O48 -","16","0.333333","","Saiki, A.; Ishizawa, N.; Mizutani, N.; Kato, M.","Structural change of C-rare Earth sesquioxides Yb~2~O~3~ and Er~2~O~3~ as a function of temperature","Journal of the Ceramic Association, Japan","1985","93","1082","649","654","10.2109/jcersj1950.93.1082_649","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1534781","4.6107","","4.6107","","2.9732","","90","","90","","90","","63.206","","","","","","","","","","","","","2","P 42/m n m","-P 4n 2n","136","","Ti O2","","- O2 Ti -","- O2 Ti -","- O4 Ti2 -","2","0.125","","Seki, H.; Ishizawa, N.; Mizutani, N.; Kato, M.","High Temperature Structures of the Rutile-Type Oxides, TiO~2~ and SnO~2~","Journal of the Ceramic Association, Japan","1984","92","1064","219","223","10.2109/jcersj1950.92.1064_219","","","","","","","","","","","","","","","","","","","","","has coordinates","303120","2025-10-31","16:25:09",""
"1534785","4.7456","","4.7456","","3.193","","90","","90","","90","","71.909","","","","","","","","","","","","","2","P 42/m n m","-P 4n 2n","136","","Sn O2","","- O2 Sn -","- O2 Sn -","- O4 Sn2 -","2","0.125","","Seki, H.; Ishizawa, N.; Mizutani, N.; Kato, M.","High Temperature Structures of the Rutile-Type Oxides, TiO~2~ and SnO~2~","Journal of the Ceramic Association, Japan","1984","92","1064","219","223","10.2109/jcersj1950.92.1064_219","","","","","","","","","","","","","","","","","","","","","has coordinates","303120","2025-10-31","16:25:09",""
"1535730","10.123","","10.569","","7.117","","109.71","","98.24","","78.15","","699.289","","","","","","","","","","","","","4","P -1","-P 1","2","","Na2 Ca3 Si6 O16","devitrite","- Ca3 Na2 O16 Si6 -","- Ca3 Na2 O16 Si6 -","- Ca6 Na4 O32 Si12 -","2","1","","Ihara, M.; Setoguchi, M.; Odani, K.; Yoshida, N.; Higashi, T.; Fukunaga, J.","The Crystal Structure of Devitrite (Disodium Tricalcium Hexasilicate), Na~2~Ca~3~Si~6~O~16~","Journal of the Ceramic Association, Japan","1984","92","1067","373","378","10.2109/jcersj1950.92.1067_373","","","","","","","","","","","","","","","","","","","","","has coordinates","175176","2020-10-21","18:00:00",""
"1535740","9.32","","9.32","","8.866","","90","","90","","120","","666.945","","","","","","","","","","","","","4","P 63","P 6c","173","","Ba Zn (Ge O4)","","- Ba Ge O4 Zn -","- Ba Ge O4 Zn -","- Ba6 Ge6 O24 Zn6 -","6","1","","Iijima, K.; Marumo, F.; Takei, H.","Structural Changes of a Piezoelectric Crystal BaZnGeO~4~ on Thermal Phase Transition","Journal of the Ceramic Association, Japan","1983","91","1050","67","72","10.2109/jcersj1950.91.1050_67","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1535744","5.407","","5.407","","8.975","","90","","90","","120","","227.236","","","","","","","","","","","","","4","P 63 2 2","P 6c 2c","182","","Ba Zn (Ge O4)","","- Ba Ge O4 Zn -","- Ba Ge O4 Zn -","- Ba2 Ge2 O8 Zn2 -","2","0.166667","","Iijima, K.; Marumo, F.; Takei, H.","Structural Changes of a Piezoelectric Crystal BaZnGeO~4~ on Thermal Phase Transition","Journal of the Ceramic Association, Japan","1983","91","1050","67","72","10.2109/jcersj1950.91.1050_67","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1536210","7.695","","7.695","","4.968","","90","","90","","90","","294.17","","","","","","","","","","","","","4","P -4 21 m","P -4 2ab","113","","La2 Ge (Be2 O7)","","- Be2 Ge La2 O7 -","- Be2 Ge La2 O7 -","- Be4 Ge2 La4 O14 -","2","0.25","","Ochi, Y.; Morikawa, H.; Marumo, F.; Nozaki, H.","Structures and Magnetic Properties of Rare Earth Compounds in the Melilite Group","Journal of the Ceramic Association, Japan","1983","91","1053","229","235","10.2109/jcersj1950.91.1053_229","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1536213","7.611","","7.611","","4.919","","90","","90","","90","","284.944","","","","","","","","","","","","","4","P -4 21 m","P -4 2ab","113","","Pr2 Ge (Be2 O7)","","- Be2 Ge O7 Pr2 -","- Be2 Ge O7 Pr2 -","- Be4 Ge2 O14 Pr4 -","2","0.25","","Ochi, Y.; Morikawa, H.; Marumo, F.; Nozaki, H.","Structures and Magnetic Properties of Rare Earth Compounds in the Melilite Group","Journal of the Ceramic Association, Japan","1983","91","1053","229","235","10.2109/jcersj1950.91.1053_229","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1536216","7.528","","7.528","","4.859","","90","","90","","90","","275.363","","","","","","","","","","","","","4","P -4 21 m","P -4 2ab","113","","Sm2 Ge (Be2 O7)","","- Be2 Ge O7 Sm2 -","- Be2 Ge O7 Sm2 -","- Be4 Ge2 O14 Sm4 -","2","0.25","","Ochi, Y.; Morikawa, H.; Marumo, F.; Nozaki, H.","Structures and Magnetic Properties of Rare Earth Compounds in the Melilite Group","Journal of the Ceramic Association, Japan","1983","91","1053","229","235","10.2109/jcersj1950.91.1053_229","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1536219","7.48","","7.48","","4.842","","90","","90","","90","","270.912","","","","","","","","","","","","","4","P -4 21 m","P -4 2ab","113","","Gd2 Ge (Be2 O7)","","- Be2 Gd2 Ge O7 -","- Be2 Gd2 Ge O7 -","- Be4 Gd4 Ge2 O14 -","2","0.25","","Ochi, Y.; Morikawa, H.; Marumo, F.; Nozaki, H.","Structures and Magnetic Properties of Rare Earth Compounds in the Melilite Group","Journal of the Ceramic Association, Japan","1983","91","1053","229","235","10.2109/jcersj1950.91.1053_229","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1536221","7.428","","7.428","","4.809","","90","","90","","90","","265.337","","","","","","","","","","","","","4","P -4 21 m","P -4 2ab","113","","Dy2 Ge (Be2 O7)","","- Be2 Dy2 Ge O7 -","- Be2 Dy2 Ge O7 -","- Be4 Dy4 Ge2 O14 -","2","0.25","","Ochi, Y.; Morikawa, H.; Marumo, F.; Nozaki, H.","Structures and Magnetic Properties of Rare Earth Compounds in the Melilite Group","Journal of the Ceramic Association, Japan","1983","91","1053","229","235","10.2109/jcersj1950.91.1053_229","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1536225","7.399","","7.399","","4.797","","90","","90","","90","","262.613","","","","","","","","","","","","","4","P -4 21 m","P -4 2ab","113","","Y2 Ge (Be2 O7)","","- Be2 Ge O7 Y2 -","- Be2 Ge O7 Y2 -","- Be4 Ge2 O14 Y4 -","2","0.25","","Ochi, Y.; Morikawa, H.; Marumo, F.; Nozaki, H.","Structures and Magnetic Properties of Rare Earth Compounds in the Melilite Group","Journal of the Ceramic Association, Japan","1983","91","1053","229","235","10.2109/jcersj1950.91.1053_229","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1536229","7.38","","7.38","","4.786","","90","","90","","90","","260.667","","","","","","","","","","","","","4","P -4 21 m","P -4 2ab","113","","Er2 Ge (Be2 O7)","","- Be2 Er2 Ge O7 -","- Be2 Er2 Ge O7 -","- Be4 Er4 Ge2 O14 -","2","0.25","","Ochi, Y.; Morikawa, H.; Marumo, F.; Nozaki, H.","Structures and Magnetic Properties of Rare Earth Compounds in the Melilite Group","Journal of the Ceramic Association, Japan","1983","91","1053","229","235","10.2109/jcersj1950.91.1053_229","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"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","301779","2025-08-18","16:06:44",""
"1542236","15.17","0.04","8.86","0.03","5.48","0.02","90","","90","","90","","736.546","","","","","","","","","","","","","4","P c c n","-P 2ab 2ac","56","","Sr B Al O4","","- Al B O4 Sr -","- Al B O4 Sr -","- Al8 B8 O32 Sr8 -","8","1","","Nagai, T.; Ihara, M.","Crystal Structure of Di-Strontium Boro-Aluminate, 2(SrO)~2~⋅Al~2~O~3~⋅B~2~O~3~","Journal of the Ceramic Association, Japan","1972","80","927","432","437","10.2109/jcersj1950.80.927_432","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""