# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-28T23:40:21+02: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 volume = 46 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 "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","" "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",""