# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2025-03-18T19:11:39+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 American Ceramic Society') 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 "1000059","4.7554","0.0003","4.7554","0.0003","12.991","0.0006","90","","90","","120","","254.4","","","","","","","","","","","","","2","R -3 c :H","-R 3 2""c","167","","Aluminium oxide","","- Al2 O3 -","- Al2 O3 -","- Al12 O18 -","6","0.166667","","Wang, X - L; Hubbard, C R; Alexander, K B; Becher, P F","Neutron diffraction measurements of the residual stresses in Al2 O3 - Zr O2 (Ce O2) ceramic composites","Journal of the American Ceramic Society","1994","77","6","1569","1575","10.1111/j.1151-2916.1994.tb09758.x","","","","","","0.07","","","","","","","","","","","","","","","has coordinates","202026","2020-10-21","18:00:00","" "1010858","6.85","","6.85","","10.95","","90","","90","","120","","445","","","","","","","","","","","","","3","","","","","Sodium catena-borate","","- B Na O2 -","","","16","","","Cole, S S; Scholes, S R; Amberg, C R","The System R~2~ O - B~2~ O~3~, II. Properties of Anhydrous and Hydrated Metaborates of Sodium and Potassium","Journal of the American Ceramic Society","1935","18","","58","61","10.1111/j.1151-2916.1935.tb19353.x","","","","","","","","","","","","","","","","","","","","","","120071","2020-10-21","18:00:00","" "1509477","3.9286","","3.9259","","3.9302","","90","","90.49","","90","","60.614","","","","","","","","","","","","","4","P 1 2/m 1","-P 2y","10","","Ag (Nb0.5 Ta0.5) O3","","- Ag Nb0.5 O3 Ta0.5 -","- Ag Nb0.5 O3 Ta0.5 -","- Ag Nb0.5 O3 Ta0.5 -","1","0.25","","Suvorov, D.; Valant, M.","New high-permittivity Ag Nb1-x Tax O3 microwave ceramics: Part I: crystal structures and phase-decomposition relations","Journal of the American Ceramic Society","1999","82","","81","87","10.1111/j.1151-2916.1999.tb01726.x","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1510979","3.5653","","6.316","","10.713","","90","","90","","90","","241.24","","","","","","","","","","","","","3","I m m m","-I 2 2","71","","Ce3 B2 N4","","- B2 Ce3 N4 -","- B2 Ce3 N4 -","- B4 Ce6 N8 -","2","0.125","","Rogl, P.; Klesnar, H.; Fischer, P.","Neutron powder diffraction studies of Ce3 B2 N4 and isotypic RE3 B2 N4 compounds (RE= La, Pr, Nd, MM)","Journal of the American Ceramic Society","1990","73","","2634","2639","10.1111/j.1151-2916.1990.tb06739.x","","","","","","","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00","" "1511089","3.793","","3.793","","8.847","","90","","90","","120","","110.228","","","","","","","","","","","","","3","P 63/m m c","-P 6c 2c","194","","Dy B O3","","- B Dy O3 -","- B0.9999 Dy O2.9999 -","- B1.9998 Dy2 O5.9998 -","2","0.0833333","","Newnham, R.E.; Santoro, R.P.; Redman, M.J.","Crystal structure of yttrium and other rare-earth borates","Journal of the American Ceramic Society","1963","46","","253","256","10.1111/j.1151-2916.1963.tb11721.x","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1511097","3.767","","3.767","","8.807","","90","","90","","120","","108.231","","","","","","","","","","","","","3","P 63/m m c","-P 6c 2c","194","","Er B O3","","- B Er O3 -","- B0.9999 Er O2.9999 -","- B1.9998 Er2 O5.9998 -","2","0.0833333","","Santoro, R.P.; Redman, M.J.; Newnham, R.E.","Crystal structure of yttrium and other rare-earth borates","Journal of the American Ceramic Society","1963","46","","253","256","10.1111/j.1151-2916.1963.tb11721.x","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1511112","3.842","","3.842","","8.937","","90","","90","","120","","114.245","","","","","","","","","","","","","3","P 63/m m c","-P 6c 2c","194","","Eu B O3","","- B Eu O3 -","- B0.9999 Eu O2.9999 -","- B1.9998 Eu2 O5.9998 -","2","0.0833333","","Newnham, R.E.; Santoro, R.P.; Redman, M.J.","Crystal structure of yttrium and other rare-earth borates","Journal of the American Ceramic Society","1963","46","","253","256","10.1111/j.1151-2916.1963.tb11721.x","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1511164","3.839","","3.839","","8.906","","90","","90","","120","","113.671","","","","","","","","","","","","","3","P 63/m m c","-P 6c 2c","194","","Gd B O3","","- B Gd O3 -","- B0.9999 Gd O2.9999 -","- B1.9998 Gd2 O5.9998 -","2","0.0833333","","Newnham, R.E.; Redman, M.J.; Santoro, R.P.","Crystal structur:0of yttrium and othe:0rare-earth borates","Journal of the American Ceramic Society","1963","46","","253","256","10.1111/j.1151-2916.1963.tb11721.x","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1511181","3.784","","3.784","","8.836","","90","","90","","120","","109.569","","","","","","","","","","","","","3","P 63/m m c","-P 6c 2c","194","","Ho B O3","","- B Ho O3 -","- B0.9999 Ho O2.9999 -","- B1.9998 Ho2 O5.9998 -","2","0.0833333","","Redman, M.J.; Newnham, R.E.; Santoro, R.P.","Crystal structure of yttrium and other rate-earth borates","Journal of the American Ceramic Society","1963","46","","253","256","10.1111/j.1151-2916.1963.tb11721.x","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1511228","3.727","","3.727","","8.722","","90","","90","","120","","104.922","","","","","","","","","","","","","3","P 63/m m c","-P 6c 2c","194","","Lu B O3","","- B Lu O3 -","- B0.9999 Lu O2.9999 -","- B1.9998 Lu2 O5.9998 -","2","0.0833333","","Newnham, R.E.; Santoro, R.P.; Redman, M.J.","Crystal structure of yttrium and other rare-earth borates","Journal of the American Ceramic Society","1963","46","","253","256","10.1111/j.1151-2916.1963.tb11721.x","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1511241","3.172","","17.841","","3.114","","90","","90","","90","","176.226","","","","","","","","","","","","","3","C m c m","-C 2c 2","63","","Nb2 B N.975","","- B N0.975 Nb2 -","- B N0.975 Nb2 -","- B4 N3.9 Nb8 -","4","0.25","","Klesnar, H.; Fischer, P.; Rogl, P.","Neutron powder diffraction of Nb2BN1-x","Journal of the American Ceramic Society","1988","71","","450","452","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1511278","3.862","","3.862","","8.978","","90","","90","","120","","115.967","","","","","","","","","","","","","3","P 63/m m c","-P 6c 2c","194","","Sm (B O3)","","- B O3 Sm -","- B0.9999 O2.9999 Sm -","- B1.9998 O5.9998 Sm2 -","2","0.0833333","","Santoro, R.P.; Newnham, R.E.; Redman, M.J.","Crystal structure of yttrium and other rare-earth borates","Journal of the American Ceramic Society","1963","46","","253","256","10.1111/j.1151-2916.1963.tb11721.x","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1511280","3.78","","3.78","","8.81","","90","","90","","120","","109.016","","","","","","","","","","","","","3","P 63/m m c","-P 6c 2c","194","","Tm B O3","","- B O3 Tm -","- B0.9999 O2.9999 Tm -","- B1.9998 O5.9998 Tm2 -","2","0.0833333","","Newnham, R.E.; Redman, M.J.; Santoro, R.P.","Crystal structure of yttrium and other rare-earth borates","Journal of the American Ceramic Society","1963","46","","253","256","10.1111/j.1151-2916.1963.tb11721.x","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1511281","6.54","","6.54","","8.81","","90","","90","","120","","326.334","","","","","","","","","","","","","3","P -6 c 2","P -6c 2","188","","Tm (B O3)","","- B O3 Tm -","- B O3 Tm -","- B6 O18 Tm6 -","6","0.5","","Redman, M.J.; Santoro, R.P.; Newnham, R.E.","Crystal structure of yttrium and other rare-earth borates","Journal of the American Ceramic Society","1963","46","","253","256","10.1111/j.1151-2916.1963.tb11721.x","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1511282","3.778","","3.778","","8.814","","90","","90","","120","","108.95","","","","","","","","","","","","","3","P 63/m m c","-P 6c 2c","194","","Y (B O3)","","- B O3 Y -","- B0.9999 O2.9999 Y -","- B1.9998 O5.9998 Y2 -","2","0.0833333","","Newnham, R.E.; Redman, M.J.; Santoro, R.P.","Crystal structure of yttrium and other rare-earth borates","Journal of the American Ceramic Society","1963","46","","253","256","10.1111/j.1151-2916.1963.tb11721.x","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1511287","3.735","","3.735","","8.747","","90","","90","","120","","105.675","","","","","","","","","","","","","3","P 63/m m c","-P 6c 2c","194","","Yb B O3","","- B O3 Yb -","- B0.9999 O2.9999 Yb -","- B1.9998 O5.9998 Yb2 -","2","0.0833333","","Newnham, R.E.; Redman, M.J.; Santoro, R.P.","Crystal structure of yttrium and other rare-earth borates","Journal of the American Ceramic Society","1963","46","","253","256","10.1111/j.1151-2916.1963.tb11721.x","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1514114","4.442","","4.442","","4.442","","90","","90","","90","","87.647","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","Manganese Oxide","","- Mn O -","- Mn O -","- Mn4 O4 -","4","0.0208333","","Barrett, C. A.; Evans, E. B.","Solid solubility and lattice parameter of Ni O - Mn O","Journal of the American Ceramic Society","1964","47","","533","533","10.1111/j.1151-2916.1964.tb13806.x","","","","","","","","","","","","","","","","","","","","","has coordinates","176808","2020-10-21","18:00:00","" "1521159","4.6085","","4.6085","","2.9817","","90","","90","","90","","63.326","","","","","","","","","","","","","3","P 42/m n m","-P 4n 2n","136","","(Ti0.9 Sn0.1) O2","","- O2 Sn0.1 Ti0.9 -","- O2 Sn0.1 Ti0.9 -","- O4 Sn0.2 Ti1.8 -","2","0.125","","Hirata, T.","Oxygen position, octahedral distortion, and bond-valence parameter from bond lengths in Ti1-x Snx O2 (0