# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-01T16:07:20+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 'Nippon Kagaku Kaishi (= J.Chem.Soc.Japan) (1947-)') 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 "1509663","3.8251","","3.8251","","28.884","","90","","90","","90","","422.613","","","","","","","","","","","","","4","I 4/m m m","-I 4 2","139","","Ag2 La2 (Ti3 O10)","","- Ag2 La2 O10 Ti3 -","- Ag2 La2 O10 Ti3 -","- Ag4 La4 O20 Ti6 -","2","0.0625","","Sato, M.; Toda, K.; Watanabe, J.; Uematsu, K.","Structure determination and silver ion conductivity of layered perovskite compounds M2La2Ti3O10 (M=K and Ag)","Nippon Kagaku Kaishi (= J.Chem.Soc.Japan) (1947-)","1993","1993","","640","646","","","","","","","","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00","" "1524531","5.861","","5.712","","25.295","","90","","90","","90","","846.827","","","","","","","","","","","","","3","P n 21 a","P -2ac -2n","33","","Ce Si P3","","- Ce P3 Si -","- Ce P3 Si -","- Ce8 P24 Si8 -","8","2","","Hayakawa, H.; Ono, S.; Sasaki, Y.; Kobayashi, A.","The crystal structure of cerium silicon triphosphide Ce Si P3","Nippon Kagaku Kaishi (= J.Chem.Soc.Japan) (1947-)","1978","9","","1214","1220","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1535168","6.084","","5.986","","26.235","","90","","90","","90","","955.448","","","","","","","","","","","","","3","P b c a","-P 2ac 2ab","61","","La Si As3","","- As3 La Si -","- As3 La Si -","- As24 La8 Si8 -","8","1","","Hayakawa, H.; Ono, S.; Suzuki, A.","The crystal structure of lanthanum silicon triarsenide (La Si As3)","Nippon Kagaku Kaishi (= J.Chem.Soc.Japan) (1947-)","1984","1984","","697","701","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1535735","12.31","","12.292","","5.366","","90","","90","","90","","811.954","","","","","","","","","","","","","4","C m m 2","C 2 -2","35","","Ba2 Ge2 Ti O8","","- Ba2 Ge2 O8 Ti -","- Ba2 Ge2 O8 Ti -","- Ba8 Ge8 O32 Ti4 -","4","0.5","","Iijima, K.; Kimura, M.; Marumo, F.; Kawamura, T.","Structure of a ferroelastic crystal Ba2 Ti Ge2 O8 and its thermal phase transition.","Nippon Kagaku Kaishi (= J.Chem.Soc.Japan) (1947-)","1981","1981","","1557","1563","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1535866","8.71","","9.31","","12.58","","90","","91.1","","90","","1019.92","","","","","","","","","","","","","6","P 1 21/c 1","-P 2ybc","14","","(Co (C O3) (N H3)5) I (H2 O)","","- C H17 Co I N5 O4 -","- C H17 Co I N5 O4 -","- C4 H68 Co4 I4 N20 O16 -","4","1","","Nakai, H.; Kuroya, H.; Kushi, Y.","Crystal structure of carbonatopentaamminecobalt(III) iodide monohydrate","Nippon Kagaku Kaishi (= J.Chem.Soc.Japan) (1947-)","1967","88","","1126","1127","","","","","","","","","","","","","","","","","","","","","","has coordinates","186592","2020-10-21","18:00:00","" "1537141","7.16","","7.16","","10.13","","90","","90","","90","","519.321","","","","","","","","","","","","","6","I 4 m m","I 4 -2","107","","(Co (N C S) (N H3)5) Cl2","","- C H15 Cl2 Co N6 S -","- C H15 Cl2 Co N6 S -","- C2 H30 Cl4 Co2 N12 S2 -","2","0.125","","Kushi, Y.; Kuroya, H.; Komiyama, Y.","Crystal structure of isothiocyanato-pentaammine-cobalt(III) chloride","Nippon Kagaku Kaishi (= J.Chem.Soc.Japan) (1947-)","1967","88","","1151","1153","","","","","","","","","","","","","","","","","","","","","","has coordinates","186592","2020-10-21","18:00:00",""