# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-07-01T12:24:33+02:00 # Query: # SELECT data.* # FROM # data # WHERE # (status is null or status != 'retracted') and # (sg LIKE 'B 2 2 2' 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 "4133839","9.9892","0.0003","9.9304","0.0003","24.261","0.0009","90","","90","","90","","2406.61","0.14","363","2","363","2","","","","","","","","6","B 2 2 2","B 2 2","21","","","","- C24 H56 N12 O28 Rb Tb -","- C30 N8 O22 Rb Tb -","- C60 N16 O44 Rb2 Tb2 -","2","0.25","","Shi, Chao; Ye, Le; Gong, Zhi-Xin; Ma, Jia-Jun; Wang, Qin-Wen; Jiang, Jia-Ying; Hua, Miao-Miao; Wang, Chang-Feng; Yu, Hui; Zhang, Yi; Ye, Heng-Yun","Two-Dimensional Organic-Inorganic Hybrid Rare-Earth Double Perovskite Ferroelectrics.","Journal of the American Chemical Society","2019","","","","","10.1021/jacs.9b11697","","","0.71073","MoKα","","0.0659","0.0563","","","0.1311","0.1377","","","","","","0.979","","","","has coordinates","245530","2020-10-21","18:00:00","" "4133841","9.9498","0.0007","9.8982","0.0007","24.245","0.003","90","","90","","90","","2387.8","0.4","363","2","363","2","","","","","","","","6","B 2 2 2","B 2 2","21","","","","- C24 H56 Dy N12 O28 Rb -","- C30 Dy N8 O22 Rb -","- C60 Dy2 N16 O44 Rb2 -","2","0.25","","Shi, Chao; Ye, Le; Gong, Zhi-Xin; Ma, Jia-Jun; Wang, Qin-Wen; Jiang, Jia-Ying; Hua, Miao-Miao; Wang, Chang-Feng; Yu, Hui; Zhang, Yi; Ye, Heng-Yun","Two-Dimensional Organic-Inorganic Hybrid Rare-Earth Double Perovskite Ferroelectrics.","Journal of the American Chemical Society","2019","","","","","10.1021/jacs.9b11697","","","0.71073","MoKα","","0.0916","0.0713","","","0.1773","0.1896","","","","","","1.007","","","","has coordinates","245530","2020-10-21","18:00:00","" "4133845","9.9293","0.0003","9.8697","0.0003","24.3702","0.0009","90","","90","","90","","2388.26","0.14","343","2","343","2","","","","","","","","6","B 2 2 2","B 2 2","21","","","","- C24 H56 Ce K N12 O28 -","- C30 Ce K N8 O22 -","- C60 Ce2 K2 N16 O44 -","2","0.25","","Shi, Chao; Ye, Le; Gong, Zhi-Xin; Ma, Jia-Jun; Wang, Qin-Wen; Jiang, Jia-Ying; Hua, Miao-Miao; Wang, Chang-Feng; Yu, Hui; Zhang, Yi; Ye, Heng-Yun","Two-Dimensional Organic-Inorganic Hybrid Rare-Earth Double Perovskite Ferroelectrics.","Journal of the American Chemical Society","2019","","","","","10.1021/jacs.9b11697","","","0.71073","MoKα","","0.0568","0.055","","","0.1343","0.1355","","","","","","1.243","","","","has coordinates","245531","2020-10-21","18:00:00","" "4133847","9.9301","0.0003","9.8678","0.0003","24.3846","0.0008","90","","90","","90","","2389.4","0.13","343","2","343","2","","","","","","","","6","B 2 2 2","B 2 2","21","","","","- C24 H56 Ce K N12 O28 -","- C30 Ce K N8 O22 -","- C60 Ce2 K2 N16 O44 -","2","0.25","","Shi, Chao; Ye, Le; Gong, Zhi-Xin; Ma, Jia-Jun; Wang, Qin-Wen; Jiang, Jia-Ying; Hua, Miao-Miao; Wang, Chang-Feng; Yu, Hui; Zhang, Yi; Ye, Heng-Yun","Two-Dimensional Organic-Inorganic Hybrid Rare-Earth Double Perovskite Ferroelectrics.","Journal of the American Chemical Society","2019","","","","","10.1021/jacs.9b11697","","","0.71073","MoKα","","0.0573","0.0541","","","0.1367","0.1397","","","","","","0.981","","","","has coordinates","245531","2020-10-21","18:00:00","" "4133850","10.0737","0.0003","9.993","0.0003","24.153","0.0008","90","","90","","90","","2431.4","0.13","353","2","353","2","","","","","","","","5","B 2 2 2","B 2 2","21","","","","- C24 H56 Ce N13 O28 -","- C30 Ce N9 O22 -","- C60 Ce2 N18 O44 -","2","0.25","","Shi, Chao; Ye, Le; Gong, Zhi-Xin; Ma, Jia-Jun; Wang, Qin-Wen; Jiang, Jia-Ying; Hua, Miao-Miao; Wang, Chang-Feng; Yu, Hui; Zhang, Yi; Ye, Heng-Yun","Two-Dimensional Organic-Inorganic Hybrid Rare-Earth Double Perovskite Ferroelectrics.","Journal of the American Chemical Society","2019","","","","","10.1021/jacs.9b11697","","","0.71073","MoKα","","0.0523","0.0507","","","0.1184","0.1199","","","","","","1.069","","","","has coordinates","245532","2020-10-21","18:00:00",""