# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-07-04T19:19:33+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 'Chemistry of materials : a publication of the American Chemical Society') AND volume = 31 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
"4002983","32.082","0.003","8.3226","0.0006","10.4238","0.0008","90","","90","","90","","2783.2","0.4","298","","298","","","","","","","","","5","P n a 21","P 2c -2n","33","","","","- C2 H12 Br4 N6 Sn -","- C2 H12 Br4 N6 Sn -","- C16 H96 Br32 N48 Sn8 -","8","2","","Nazarenko, Olga; Kotyrba, Martin R.; Yakunin, Sergii; Wörle, Michael; Benin, Bogdan M.; Rainò, Gabriele; Krumeich, Frank; Kepenekian, Mikaël; Even, Jacky; Katan, Claudine; Kovalenko, Maksym V.","Guanidinium and Mixed Cesium-Guanidinium Tin(II) Bromides: Effects of Quantum Confinement and Out-of-Plane Octahedral Tilting.","Chemistry of materials : a publication of the American Chemical Society","2019","31","6","2121","2129","10.1021/acs.chemmater.9b00038","","x-ray","0.71073","MoKα","","0.0574","0.0348","","","0.0674","0.0738","","","","","","1.013","","","","has coordinates","220407","2020-10-21","18:00:00",""
"4002984","6.0112","0.001","11.5363","0.0018","17.342","0.003","90","","90","","90","","1202.6","0.3","250","","250","","","","","","","","","6","I m m a","-I 2b 2","74","","","","- C H6 Br4 Cs N3 Sn -","- C H6 Br4 Cs N3 Sn -","- C4 H24 Br16 Cs4 N12 Sn4 -","4","0.25","","Nazarenko, Olga; Kotyrba, Martin R.; Yakunin, Sergii; Wörle, Michael; Benin, Bogdan M.; Rainò, Gabriele; Krumeich, Frank; Kepenekian, Mikaël; Even, Jacky; Katan, Claudine; Kovalenko, Maksym V.","Guanidinium and Mixed Cesium-Guanidinium Tin(II) Bromides: Effects of Quantum Confinement and Out-of-Plane Octahedral Tilting.","Chemistry of materials : a publication of the American Chemical Society","2019","31","6","2121","2129","10.1021/acs.chemmater.9b00038","","","0.71073","MoKα","","0.0279","0.0227","","","0.0512","0.053","","","","","","1.032","","","","has coordinates","220408","2020-10-21","18:00:00",""