# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2026-02-14T19:52:14+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 volume = 75 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 "1541217","7.708","","7.708","","2.906","","90","","90","","90","","172.655","","","","","","","","","","","","","3","P b a m","-P 2 2ab","55","","","","- Al6 K O9.5 -","- Al6 K O9.5 -","- Al6 K O9.5 -","1","0.125","","Mazza, D.; Busca, G.; Vallino, M.","Mullite-type structures in the system Al2O3-Me2O (Me= Na, K) and Al2O3-B2O3","Journal of the American Ceramic Society","1992","75","","1929","1934","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1541218","7.64","","7.64","","2.937","","90","","90","","90","","171.432","","","","","","","","","","","","","3","P b a m","-P 2 2ab","55","","","","- Al6 Na O9.5 -","- Al6 Na O9.5 -","- Al6 Na O9.5 -","1","0.125","","Mazza, D.; Vallino, M.; Busca, G.","Mullite-type structures in the system Al2O3-Me2O (Me= Na, K) and Al2O3-B2O3","Journal of the American Ceramic Society","1992","75","","1929","1934","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1541219","7.621","","7.621","","2.833","","90","","90","","90","","164.54","","","","","","","","","","","","","3","P b a m","-P 2 2ab","55","","","","- Al5 B O9 -","- Al5 B O9 -","- Al5 B O9 -","1","0.125","","Mazza, D.; Vallino, M.; Busca, G.","Mullite-type structures in the system Al2O3-Me2O (Me= Na, K) and Al2O3-B2O3","Journal of the American Ceramic Society","1992","75","","1929","1934","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1541220","7.617","","7.617","","2.827","","90","","90","","90","","164.019","","","","","","","","","","","","","3","P b a m","-P 2 2ab","55","","","","- Al4 B2 O9 -","- Al4 B2 O9 -","- Al4 B2 O9 -","1","0.125","","Mazza, D.; Vallino, M.; Busca, G.","Mullite-type structures in the system Al2O3-Me2O (Me= Na, K) and Al2O3-B2O3","Journal of the American Ceramic Society","1992","75","","1929","1934","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "9012588","3.5667","","3.5667","","3.5667","","90","","90","","90","","45.373","","","","","","","","","","","","","1","F d -3 m :1","F 4d 2 3 -1d","227","Carbon","","Carbon","- C -","- C -","- C8 -","8","0.0416667","","Ownby, P. D.; Yang, X.; Liu, J.","Calculated X-ray diffraction data for diamond polytypes Note: cubic, 3C structure Note: theoretically calculated structure values","Journal of the American Ceramic Society","1992","75","","1876","1883","10.1111/j.1151-2916.1992.tb07211.x","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:47","" "9012589","2.5221","","2.5221","","4.1186","","90","","90","","120","","22.688","","","","","","","","","","","","","1","P 63/m m c","-P 6c 2c","194","Carbon","","Carbon","- C -","- C -","- C4 -","4","0.166667","","Ownby, P. D.; Yang, X.; Liu, J.","Calculated X-ray diffraction data for diamond polytypes Note: hexagonal, 2H structure known as lonsdaleite Note: theoretically calculated structure values","Journal of the American Ceramic Society","1992","75","","1876","1883","10.1111/j.1151-2916.1992.tb07211.x","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:47","" "9012590","2.5221","","2.5221","","8.2371","","90","","90","","120","","45.376","","","","","","","","","","","","","1","P 63/m m c","-P 6c 2c","194","Carbon","","Carbon","- C -","- C -","- C8 -","8","0.333333","","Ownby, P. D.; Yang, X.; Liu, J.","Calculated X-ray diffraction data for diamond polytypes Note: hexagonal, 4H structure Note: theoretically calculated structure values","Journal of the American Ceramic Society","1992","75","","1876","1883","10.1111/j.1151-2916.1992.tb07211.x","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:47","" "9012591","2.5221","","2.5221","","12.3557","","90","","90","","120","","68.065","","","","","","","","","","","","","1","P 63/m m c","-P 6c 2c","194","Carbon","","Carbon","- C -","- C -","- C12 -","12","0.5","","Ownby, P. D.; Yang, X.; Liu, J.","Calculated X-ray diffraction data for diamond polytypes Note: hexagonal, 6H structure Note: theoretically calculated structure values","Journal of the American Ceramic Society","1992","75","","1876","1883","10.1111/j.1151-2916.1992.tb07211.x","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:47","" "9012592","2.5221","","2.5221","","16.4743","","90","","90","","120","","90.753","","","","","","","","","","","","","1","P 63/m m c","-P 6c 2c","194","Carbon","","Carbon","- C -","- C -","- C16 -","16","0.666667","","Ownby, P. D.; Yang, X.; Liu, J.","Calculated X-ray diffraction data for diamond polytypes Note: hexagonal, 8H structure Note: theoretically calculated structure values","Journal of the American Ceramic Society","1992","75","","1876","1883","10.1111/j.1151-2916.1992.tb07211.x","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:47","" "9012593","2.5221","","2.5221","","30.8893","","90","","90","","120","","170.162","","","","","","","","","","","","","1","R -3 m :H","-R 3 2""","166","Carbon","","Carbon","- C -","- C -","- C30 -","30","0.833333","","Ownby, P. D.; Yang, X.; Liu, J.","Calculated X-ray diffraction data for diamond polytypes Note: rhombohedral, 15R structure Note: theoretically calculated structure values","Journal of the American Ceramic Society","1992","75","","1876","1883","10.1111/j.1151-2916.1992.tb07211.x","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:47","" "9012594","2.5221","","2.5221","","43.245","","90","","90","","120","","238.227","","","","","","","","","","","","","1","R -3 m :H","-R 3 2""","166","Carbon","","Carbon","- C -","- C -","- C42 -","42","1.16667","","Ownby, P. D.; Yang, X.; Liu, J.","Calculated X-ray diffraction data for diamond polytypes Note: rhombohedral, 21R structure Note: theoretically calculated structure values","Journal of the American Ceramic Society","1992","75","","1876","1883","10.1111/j.1151-2916.1992.tb07211.x","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:47",""