# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-07-04T18:58:43+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 = 21 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
"4000965","8.129","0.003","44.017","0.018","8.57","0.004","90","","94.802","0.007","90","","3056","2","100","2","100","2","","","","","","","","4","P 1 21 1","P 2yb","4","(hexyl)2NPhPhDCDHF (5)","","","- C34 H40 N4 O -","- C34 H40 N4 O -","- C136 H160 N16 O4 -","4","2","","Lu, Zhikuan; Liu, Na; Lord, Samuel J.; Bunge, Scott D.; Moerner, W. E.; Twieg, Robert J.","Bright, Red Single-Molecule Emitters: Synthesis and Properties of Environmentally Sensitive Dicyanomethylenedihydrofuran (DCDHF) Fluorophores with Bisaromatic Conjugation.","Chemistry of materials : a publication of the American Chemical Society","2009","21","5","797","","10.1021/cm801783f","","","0.71073","MoKα","","0.1423","0.1064","","","0.2672","0.2934","","","","","","1.072","","","","has coordinates","178377","2020-10-21","18:00:00",""
"4000966","8.5644","0.0012","11.8532","0.0017","15.018","0.002","77.957","0.002","83.968","0.002","74.803","0.002","1436.8","0.3","273","2","273","2","","","","","","","","5","P -1","-P 1","2","(hexyl)2NThPhDCDHF (6)","","","- C32 H38 N4 O S -","- C32 H38 N4 O S -","- C64 H76 N8 O2 S2 -","2","1","","Lu, Zhikuan; Liu, Na; Lord, Samuel J.; Bunge, Scott D.; Moerner, W. E.; Twieg, Robert J.","Bright, Red Single-Molecule Emitters: Synthesis and Properties of Environmentally Sensitive Dicyanomethylenedihydrofuran (DCDHF) Fluorophores with Bisaromatic Conjugation.","Chemistry of materials : a publication of the American Chemical Society","2009","21","5","797","","10.1021/cm801783f","","","0.71073","MoKα","","0.0398","0.0324","","","0.0969","0.1084","","","","","","0.766","","","","has coordinates","201982","2020-10-21","18:00:00",""
"4000967","11.852","0.002","16.975","0.004","16.995","0.003","90","","103.695","0.004","90","","3322","1.1","160","2","160","2","","","","","","","","5","P 1 21/n 1","-P 2yn","14","(hexyl)2NPhThPhDCDHF (21)","","","- C38 H42 N4 O S -","- C38 H42 N4 O S -","- C152 H168 N16 O4 S4 -","4","1","","Lu, Zhikuan; Liu, Na; Lord, Samuel J.; Bunge, Scott D.; Moerner, W. E.; Twieg, Robert J.","Bright, Red Single-Molecule Emitters: Synthesis and Properties of Environmentally Sensitive Dicyanomethylenedihydrofuran (DCDHF) Fluorophores with Bisaromatic Conjugation.","Chemistry of materials : a publication of the American Chemical Society","2009","21","5","797","","10.1021/cm801783f","","","0.71073","MoKα","","0.1041","0.0555","","","0.1419","0.1781","","","","","","1.003","","","","has coordinates","201982","2020-10-21","18:00:00",""