# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-27T01:24:12+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 = 91 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
"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",""