# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-07T15:22:55+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 'Recueil des Travaux Chimiques des Pays-Bas') 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
"1519190","22.62","0.02","11.53","0.01","11.83","0.01","90","","90","0.05","90","","3085","5","","","295","","","","","","","","","5","P 1 21/c 1","-P 2ybc","14","Pethidine hydrochloride","4-carbethoxy-1-methyl-4-phenylpiperdine hydrochloride","","- C15 H22 Cl N O2 -","- C15 Cl N O2 -","- C120 Cl8 N8 O16 -","8","2","","Tillack, JV; Seccombe, RC; Kennard, CHL; Oh, PWT","Analgetics: Part I. The crystal structure of pethidine hydrochloride, 4-carbethoxy-1-methyl-4-phenylpiperdine hydrochloride, C15H21NO2.HCl","Recueil des Travaux Chimiques des Pays-Bas","1974","93","6","164","165","","","x-ray","1.5418","CuKα","","","0.12","","","0.12","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00",""
"5000274","8.6992","0.0006","8.8017","0.0004","6.693","0.0003","103.71","0.01","103.93","0.01","66.49","0.01","450.35","","","","","","","","","","","","","3","P -1","-P 1","2","","","","- C4 H6 O2 -","- C4 H6 O2 -","- C16 H24 O8 -","4","2","","de Boer, J. S. A. M.; Stam, C. H.","The influence of substituents on the geometry of the cyclopropane ring. VI The molecular and crystal structures of cyclopropanecarboxylic acid and cyclopropanecarbonyl chloride","Recueil des Travaux Chimiques des Pays-Bas","1992","111","9","407","410","10.1002/recl.19921110905","","","","","","","","","","","","","","","","","","","","","has coordinates","175369","2020-10-21","18:00:00",""
"5900037","5.72","","6.85","","7.57","","106.17","","116","","83.33","","256.04","","","","408","","","","","","","","","3","P -1","","2","","Methylmalonic acid of form alpha","","- C4 H6 O4 -","- C4 O4 -","- C8 O8 -","2","1","","Rieck, G. D.","The crystal structure of α-succinic acid","Recueil des Travaux Chimiques des Pays-Bas","1944","63","9","170","180","10.1002/recl.19440630902","","","","","","","","","","","","","","","","","","","","","has coordinates","264769","2021-05-03","12:41:22",""
"6000214","8.708","","8.321","","9.836","","90","","95.437","","90","","709.5","","","","","","","","","","","","","4","C 1 2/c 1","","","","","","- C3 H5 N O -","","","","","","Deboer, J. S. A. M.; Schenk, H.","The influence of substituents on the geometry of the cyclopropane ring. 8. the molecular and crystal-structures of azocyclopropane N,N'-dioxide and 1,1'-dimethylazocyclopropane N,N'-dioxide","Recueil des Travaux Chimiques des Pays-Bas","1995","114","9-10","395","397","10.1002/recl.19951140904","","","","","","","","","","","","","","","","","","","","","","176292","2020-10-21","18:00:00",""
"6000215","10.727","","7.181","","5.969","","90","","90.52","","90","","459.78","","","","","","","","","","","","","4","P 1 21/n 1","","","","","","- C4 H7 N O -","","","","","","Deboer, J. S. A. M.; Schenk, H.","The influence of substituents on the geometry of the cyclopropane ring. 8. the molecular and crystal-structures of azocyclopropane N,N'-dioxide and 1,1'-dimethylazocyclopropane N,N'-dioxide","Recueil des Travaux Chimiques des Pays-Bas","1995","114","9-10","395","397","10.1002/recl.19951140904","","","","","","","","","","","","","","","","","","","","","","176292","2020-10-21","18:00:00",""