# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-24T10:24:01+01: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 'Can. J. Chem.') AND volume = 83 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
"1501607","9.627","0.005","4.9751","0.0005","35.2533","0.0005","90","","95.79","0.02","90","","1679.9","0.9","293","2","293","2","","","","","","","Synthesized by the authors. See text","4","P 1 21/n 1","-P 2yn","14","","","","- C14 H16 Cl N5 -","- C14 H16 Cl N5 -","- C56 H64 Cl4 N20 -","4","1","","Olivier LeBel; Thierry Maris; Hugues Duval; James D. Wuest","A practical guide to arylbiguanides — Synthesis and structural characterization","Can. J. Chem.","2005","83","","615","625","10.1139/v05-093","","","1.54178","CuKα","","0.0652","0.0563","","","0.1784","0.1869","","","","","","1.066","","","","has coordinates","176729","2020-10-21","18:00:00",""
"1501608","9.0317","0.0003","6.3945","0.0002","22.5874","0.0008","90","","99.588","0.002","90","","1286.27","0.07","100","2","100","2","","","","","","","Synthesized by the authors. See text","3","P 1 c 1","P -2yc","7","","","","- C14 H15 N5 -","- C14 H15 N5 -","- C56 H60 N20 -","4","2","","Olivier LeBel; Thierry Maris; Hugues Duval; James D. Wuest","A practical guide to arylbiguanides — Synthesis and structural characterization","Can. J. Chem.","2005","83","","615","625","10.1139/v05-093","","","1.54178","CuKα","","0.0745","0.0673","","","0.1525","0.1551","","","","","","1.024","","","","has coordinates,has disorder","201954","2020-10-21","18:00:00",""