# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-10-01T03:29:24+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 'New journal of chemistry = Nouveau journal de chimie') AND volume = 38 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 "7054264","8.4302","0.0005","23.8152","0.0015","36.666","0.002","90","","90","","90","","7361.3","0.8","130","2","130","2","","","","","","","","5","P 21 21 21","P 2ac 2ab","19","","","","- C11 H6 F6 N2 S -","- C11 H6 F6 N2 S -","- C264 H144 F144 N48 S24 -","24","6","","Palmer, Joshua H.; Parkin, Gerard","Synthesis and Structural Characterization of 1-Arylimidazole-2-thiones and N,N'-Aryldiethoxyethylthioureas with Electronically Diverse Substituents: A Manifold of Hydrogen Bonding Networks.","New journal of chemistry = Nouveau journal de chimie","2014","38","9","4071","4082","10.1039/C4NJ00521J","","","0.71073","MoKα","","0.0381","0.0358","","","0.087","0.0882","","","","","","1.082","","","","has coordinates,has disorder","180096","2020-10-21","18:00:00","" "7054265","7.4408","0.0008","20.454","0.002","7.1759","0.0008","90","","91.0376","0.0014","90","","1092","0.2","130","2","130","2","","","","","","","","5","P 1 21/c 1","-P 2ybc","14","","","","- C9 H5 Cl3 N2 S -","- C9 H5 Cl3 N2 S -","- C36 H20 Cl12 N8 S4 -","4","1","","Palmer, Joshua H.; Parkin, Gerard","Synthesis and Structural Characterization of 1-Arylimidazole-2-thiones and N,N'-Aryldiethoxyethylthioureas with Electronically Diverse Substituents: A Manifold of Hydrogen Bonding Networks.","New journal of chemistry = Nouveau journal de chimie","2014","38","9","4071","4082","10.1039/C4NJ00521J","","","0.71073","MoKα","","0.0283","0.0276","","","0.0722","0.0728","","","","","","1.128","","","","has coordinates","180096","2020-10-21","18:00:00","" "7054266","7.2383","0.0006","7.9459","0.0007","22.324","0.002","90","","93.075","0.001","90","","1282.11","0.19","150","2","150","2","","","","","","","","5","P 1 21/c 1","-P 2ybc","14","","","","- C12 H14 N2 O3 S -","- C12 H14 N2 O3 S -","- C48 H56 N8 O12 S4 -","4","1","","Palmer, Joshua H.; Parkin, Gerard","Synthesis and Structural Characterization of 1-Arylimidazole-2-thiones and N,N'-Aryldiethoxyethylthioureas with Electronically Diverse Substituents: A Manifold of Hydrogen Bonding Networks.","New journal of chemistry = Nouveau journal de chimie","2014","38","9","4071","4082","10.1039/C4NJ00521J","","","0.71073","MoKα","","0.0745","0.0426","","","0.0914","0.1042","","","","","","1.049","","","","has coordinates","180096","2020-10-21","18:00:00","" "7054267","13.747","0.005","12.625","0.004","13.632","0.005","90","","106.496","0.005","90","","2268.5","1.4","130","2","130","2","","","","","","","","5","C 1 2/c 1","-C 2yc","15","","","","- C10 H9 N3 O3 S -","- C10 H9 N3 O3 S -","- C80 H72 N24 O24 S8 -","8","1","","Palmer, Joshua H.; Parkin, Gerard","Synthesis and Structural Characterization of 1-Arylimidazole-2-thiones and N,N'-Aryldiethoxyethylthioureas with Electronically Diverse Substituents: A Manifold of Hydrogen Bonding Networks.","New journal of chemistry = Nouveau journal de chimie","2014","38","9","4071","4082","10.1039/C4NJ00521J","","","0.71073","MoKα","","0.055","0.0449","","","0.1128","0.1182","","","","","","1.12","","","","has coordinates","180096","2020-10-21","18:00:00","" "7054268","12.5507","0.0013","13.4265","0.0014","21.715","0.002","90","","98.92","0.002","90","","3615","0.6","150","2","150","2","","","","","","","","6","P 1 21/n 1","-P 2yn","14","","","","- C15 H18 F6 N2 O2 S -","- C15 H18 F6 N2 O2 S -","- C120 H144 F48 N16 O16 S8 -","8","2","","Palmer, Joshua H.; Parkin, Gerard","Synthesis and Structural Characterization of 1-Arylimidazole-2-thiones and N,N'-Aryldiethoxyethylthioureas with Electronically Diverse Substituents: A Manifold of Hydrogen Bonding Networks.","New journal of chemistry = Nouveau journal de chimie","2014","38","9","4071","4082","10.1039/C4NJ00521J","","","0.71073","MoKα","","0.0844","0.0509","","","0.1153","0.1331","","","","","","1.019","","","","has coordinates,has disorder","180096","2020-10-21","18:00:00","" "7054269","6.769","0.002","23.886","0.008","10.834","0.004","90","","90.947","0.005","90","","1751.4","1","150","2","150","2","","","","","","","","6","P 1 21/c 1","-P 2ybc","14","","","","- C13 H17 Cl3 N2 O2 S -","- C13 H17 Cl3 N2 O2 S -","- C52 H68 Cl12 N8 O8 S4 -","4","1","","Palmer, Joshua H.; Parkin, Gerard","Synthesis and Structural Characterization of 1-Arylimidazole-2-thiones and N,N'-Aryldiethoxyethylthioureas with Electronically Diverse Substituents: A Manifold of Hydrogen Bonding Networks.","New journal of chemistry = Nouveau journal de chimie","2014","38","9","4071","4082","10.1039/C4NJ00521J","","","0.71073","MoKα","","0.0991","0.0505","","","0.0986","0.1151","","","","","","1.015","","","","has coordinates","180096","2020-10-21","18:00:00","" "7054270","10.344","0.003","12.952","0.004","13.814","0.004","95.357","0.004","95.836","0.004","92.996","0.004","1829.5","0.9","150","2","150","2","","","","","","","","5","P -1","-P 1","2","","","","- C16 H26 N2 O5 S -","- C16 H26 N2 O5 S -","- C64 H104 N8 O20 S4 -","4","2","","Palmer, Joshua H.; Parkin, Gerard","Synthesis and Structural Characterization of 1-Arylimidazole-2-thiones and N,N'-Aryldiethoxyethylthioureas with Electronically Diverse Substituents: A Manifold of Hydrogen Bonding Networks.","New journal of chemistry = Nouveau journal de chimie","2014","38","9","4071","4082","10.1039/C4NJ00521J","","","0.71073","MoKα","","0.1013","0.0498","","","0.1144","0.1356","","","","","","1.027","","","","has coordinates","180096","2020-10-21","18:00:00","" "7054271","13.241","0.004","15.16","0.004","8.398","0.002","90","","101.009","0.004","90","","1654.7","0.8","150","2","150","2","","","","","","","","5","P 1 21/c 1","-P 2ybc","14","","","","- C14 H21 N3 O5 S -","- C14 H21 N3 O5 S -","- C56 H84 N12 O20 S4 -","4","1","","Palmer, Joshua H.; Parkin, Gerard","Synthesis and Structural Characterization of 1-Arylimidazole-2-thiones and N,N'-Aryldiethoxyethylthioureas with Electronically Diverse Substituents: A Manifold of Hydrogen Bonding Networks.","New journal of chemistry = Nouveau journal de chimie","2014","38","9","4071","4082","10.1039/C4NJ00521J","","","0.71073","MoKα","","0.1648","0.0558","","","0.0641","0.0834","","","","","","1.003","","","","has coordinates","180096","2020-10-21","18:00:00",""