# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-06T15:32: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 'European Journal of Organic Chemistry') 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
"1000508","13.7805","0.0012","29.081","0.005","8.4303","0.0012","90","","90","","90","","3378.45","","","","293","","","","","","","","","3","P c c n","-P 2ab 2ac","56","","Methyl (4S*,4aS*,8aS*)-4-t-butoxy-8a-methoxy-4a,5,6,7,8,8a-hexahydro-4H-chromene-2-carboxylate","","- C16 H26 O5 -","- C16 H26 O5 -","- C128 H208 O40 -","8","1","","Martel, A.; Leconte, S.; Dujardin, G.; Brown, E.; Maisonneuve, V.; Retoux, R.","Lewis Acid Catalysed [4+2] Heterocycloadditions between Ketone Enol Ethers and β-Ethylenic α-Oxo Esters","European Journal of Organic Chemistry","2002","2002","3","514","525","10.1002/1099-0690(20022)2002:3<514::AID-EJOC514>3.0.CO;2-Z","","","","","","","0.0535","","","0.0535","","","","","","","","","","","has coordinates","175065","2020-10-21","18:00:00",""
"1000509","28.084","0.003","8.3502","0.0007","20.303","0.003","90","","98.37","0.02","90","","4710.48","","","","293","","","","","","","","","4","C 1 2/c 1","-C 2yc","15","","Methyl (4R*,4aS*,8aR*)-8a-t-butyldimethylsiloxy-4-phenyl-4a,5,6,7,8,8a-hexahydro-4H-chromene-2-carboxylate","","- C23 H34 O4 Si -","- C23 H34 O4 Si -","- C184 H272 O32 Si8 -","8","1","","Martel, A.; Leconte, S.; Dujardin, G.; Brown, E.; Maisonneuve, V.; Retoux, R.","Lewis Acid Catalysed [4+2] Heterocycloadditions between Ketone Enol Ethers and β-Ethylenic α-Oxo Esters","European Journal of Organic Chemistry","2002","2002","3","514","525","10.1002/1099-0690(20022)2002:3<514::AID-EJOC514>3.0.CO;2-Z","","","","","","","0.0536","","","0.0536","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1000510","9.4586","0.0017","11.1593","0.0016","12.4892","0.0015","89.406","0.01","72.021","0.013","70.117","0.011","1172.52","","","","293","","","","","","","","","4","P -1","-P 1","2","","Methyl (4R*,4aS*,8aS*)-8a-t-butyldimethylsiloxy-4-phenyl-4a,5,6,7,8,8a-hexahydro-4H-chromene-2-carboxylate","","- C23 H34 O4 Si -","- C23 H34 O4 Si -","- C46 H68 O8 Si2 -","2","1","","Martel, A.; Leconte, S.; Dujardin, G.; Brown, E.; Maisonneuve, V.; Retoux, R.","Lewis Acid Catalysed [4+2] Heterocycloadditions between Ketone Enol Ethers and β-Ethylenic α-Oxo Esters","European Journal of Organic Chemistry","2002","2002","3","514","525","10.1002/1099-0690(20022)2002:3<514::AID-EJOC514>3.0.CO;2-Z","","","","","","","0.0822","","","0.0822","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1100173","9.3531","0.0011","10.5002","0.0013","15.9","0.002","90","","90","","90","","1561.53","","","","","","","","","","","","","4","P 21 21 21","P 2ac 2ab","19","","","","- C15 H22 N2 O4 -","- C15 H22 N2 O4 -","- C60 H88 N8 O16 -","4","1","","Schrey, Anna; Osterkamp, Frank; Straudi, Alrun; Rickert, Corry; Wagner, Holger; Koert, Ulrich; Herrschaft, Bernhard; Harms, Klaus","Synthesis of Enantiomerically Pure Amino Acids Containing 2,5-Disubstituted THF Rings in the Molecular Backbone","European Journal of Organic Chemistry","1999","1999","11","2977","2990","10.1002/(sici)1099-0690(199911)1999:11<2977::aid-ejoc2977>3.0.co;2-3","","","","","","","","","","","","","","","","","","","","","has coordinates","177980","2020-10-21","18:00:00",""
"1100264","5.753","0.001","8.297","0.001","25.098","0.002","90","","90","","90","","1197.99","","","","213","","","","","","","","","5","P 21 21 21","P 2ac 2ab","19","","(-)-(S)-4-Aminophenyl-4-methylphenylsulfoxide","","- C13 H13 N O S -","- C13 H13 N O S -","- C52 H52 N4 O4 S4 -","4","1","","Reichardt, Christian; Erfurt, Hans-Peter; Harms, Klaus; Schäfer, Gerhard","Syntheses, Absolute Configurations, and UV/Vis Spectroscopic Properties of New Chiral Tri- and Pentamethinium Streptocyanine Dyes with 4-Aminophenyl 4-Methylphenyl Sulfoxide Endgroups","European Journal of Organic Chemistry","2002","2002","3","439","452","10.1002/1099-0690(20022)2002:3<439::AID-EJOC439>3.0.CO;2-B","","","","","","","4.79","","","4.79","","","","","","","","","","","has coordinates","176878","2020-10-21","18:00:00",""
"1100265","5.4024","0.0004","16.4819","0.0013","33.13","0.018","90","","91.4","0.02","90","","2949.07","","","","193","","","","","","","","","6","P 1 21 1","P 2yb","4","","(-)-(S,S)-1,3-bis(4-(4-Methylphenylsulfinyl)phenylamino)trimethinium bromide trihydrate","","- C29 H33 Br N2 O5 S2 -","- C29 H31 Br N2 O5 S2 -","- C116 H124 Br4 N8 O20 S8 -","4","2","","Reichardt, Christian; Erfurt, Hans-Peter; Harms, Klaus; Schäfer, Gerhard","Syntheses, Absolute Configurations, and UV/Vis Spectroscopic Properties of New Chiral Tri- and Pentamethinium Streptocyanine Dyes with 4-Aminophenyl 4-Methylphenyl Sulfoxide Endgroups","European Journal of Organic Chemistry","2002","2002","3","439","452","10.1002/1099-0690(20022)2002:3<439::AID-EJOC439>3.0.CO;2-B","","","","","","","4.78","","","4.78","","","","","","","","","","","has coordinates","176878","2020-10-21","18:00:00",""
"1100266","7.9433","0.0016","7.26","0.001","21.921","0.005","90","","92.11","0.03","90","","1263.29","","","","193","","","","","","","","","5","P 1 21 1","P 2yb","4","","(-)-(S,S)-3-(4-(4-Methylphenylsulfinyl)phenylamino)propenal (4-(4-methylphenyl sulfinyl)phenylimine)","","- C29 H26 N2 O2 S2 -","- C29 H32 N2 O2 S2 -","- C58 H64 N4 O4 S4 -","2","1","","Reichardt, Christian; Erfurt, Hans-Peter; Harms, Klaus; Schäfer, Gerhard","Syntheses, Absolute Configurations, and UV/Vis Spectroscopic Properties of New Chiral Tri- and Pentamethinium Streptocyanine Dyes with 4-Aminophenyl 4-Methylphenyl Sulfoxide Endgroups","European Journal of Organic Chemistry","2002","2002","3","439","452","10.1002/1099-0690(20022)2002:3<439::AID-EJOC439>3.0.CO;2-B","","","","","","","5.67","","","5.67","","","","","","","","","","","has coordinates","176878","2020-10-21","18:00:00",""
"1100552","5.9843","0.0004","15.9963","0.0011","21.462","0.002","90","","90","","90","","2054.49","","","","","","","","","","","","","4","P 21 21 21","P 2ac 2ab","19","","","","- C27 H29 N O2 -","- C27 H29 N O2 -","- C108 H116 N4 O8 -","4","1","","Aurich, Hans Günter; Soeberdt, Michael; Harms, Klaus","Formation of Chiral N-Oxides from 2-Azabicyclo[3.3.0]octanes","European Journal of Organic Chemistry","1999","1999","5","1249","1252","10.1002/(sici)1099-0690(199905)1999:5<1249::aid-ejoc1249>3.0.co;2-p","","","","","","","","","","","","","","","","","","","","","has coordinates","177976","2020-10-21","18:00:00",""
"1100553","8.882","0.003","8.045","0.0012","8.9151","0.0016","90","","116.865","0.018","90","","568.28","","","","","","","","","","","","","4","P 1 21 1","P 2yb","4","","","","- C10 H21 N O3 -","- C10 H21 N O3 -","- C20 H42 N2 O6 -","2","1","","Aurich, Hans Günter; Soeberdt, Michael; Harms, Klaus","Formation of Chiral N-Oxides from 2-Azabicyclo[3.3.0]octanes","European Journal of Organic Chemistry","1999","1999","5","1249","1252","10.1002/(sici)1099-0690(199905)1999:5<1249::aid-ejoc1249>3.0.co;2-p","","","","","","","","","","","","","","","","","","","","","has coordinates","177976","2020-10-21","18:00:00",""
"1100569","9.055","0.002","13.424","0.002","15.699","0.003","75.51","0.02","78.26","0.02","85.15","0.02","1807.79","","","","","","","","","","","","","4","P -1","-P 1","2","","","","- C40 H48 O3 Si2 -","- C40 H48 O3 Si2 -","- C80 H96 O6 Si4 -","2","1","","Berninger, Jörn; Krauss, Rolf; Weinig, Hans-Georg; Koert, Ulrich; Ziemer, Burkhard; Harms, Klaus","2,3,6,7-Tetrasubstituted Perhydroanthracenes: Stereoselective Synthesis and Biconformationality Studies","European Journal of Organic Chemistry","1999","1999","4","875","884","10.1002/(sici)1099-0690(199904)1999:4<875::aid-ejoc875>3.0.co;2-#","","","","","","","","","","","","","","","","","","","","","has coordinates","177975","2020-10-21","18:00:00",""
"1100570","10.197","0.002","35.713","0.004","13.51","0.003","90","","98.48","0.01","90","","4866.09","","","","","","","","","","","","","4","P 1 21/n 1","-P 2yn","14","","","","- C55 H66 O5 Si2 -","- C55 H66 O5 Si2 -","- C220 H264 O20 Si8 -","4","1","","Berninger, Jörn; Krauss, Rolf; Weinig, Hans-Georg; Koert, Ulrich; Ziemer, Burkhard; Harms, Klaus","2,3,6,7-Tetrasubstituted Perhydroanthracenes: Stereoselective Synthesis and Biconformationality Studies","European Journal of Organic Chemistry","1999","1999","4","875","884","10.1002/(sici)1099-0690(199904)1999:4<875::aid-ejoc875>3.0.co;2-#","","","","","","","","","","","","","","","","","","","","","has coordinates","177975","2020-10-21","18:00:00",""
"1100571","10.892","0.003","14.457","0.004","29.015","0.008","100.29","0.03","96.06","0.03","90.11","0.03","4469.25","","","","","","","","","","","","","3","P -1","-P 1","2","","","","- C22 H39 O6.5 -","- C22 H39 O6.5 -","- C176 H312 O52 -","8","4","","Berninger, Jörn; Krauss, Rolf; Weinig, Hans-Georg; Koert, Ulrich; Ziemer, Burkhard; Harms, Klaus","2,3,6,7-Tetrasubstituted Perhydroanthracenes: Stereoselective Synthesis and Biconformationality Studies","European Journal of Organic Chemistry","1999","1999","4","875","884","10.1002/(sici)1099-0690(199904)1999:4<875::aid-ejoc875>3.0.co;2-#","","","","","","","","","","","","","","","","","","","","","has coordinates","177975","2020-10-21","18:00:00",""
"1100645","8.0799","0.0013","12.969","0.0015","14.451","0.0018","90","","90","","90","","1514.29","","","","","","","","","","","","","5","P 21 21 21","P 2ac 2ab","19","","","","- C15 H21 N O4 S -","- C15 H21 N O4 S -","- C60 H84 N4 O16 S4 -","4","1","","Schrey, Anna; Osterkamp, Frank; Straudi, Alrun; Rickert, Corry; Wagner, Holger; Koert, Ulrich; Herrschaft, Bernhard; Harms, Klaus","Synthesis of Enantiomerically Pure Amino Acids Containing 2,5-Disubstituted THF Rings in the Molecular Backbone","European Journal of Organic Chemistry","1999","1999","11","2977","2990","10.1002/(sici)1099-0690(199911)1999:11<2977::aid-ejoc2977>3.0.co;2-3","","","","","","","","","","","","","","","","","","","","","has coordinates","177980","2020-10-21","18:00:00",""
"1100646","8.455","0.001","11.6555","0.001","14.3828","0.001","90","","90","","90","","1417.39","","","","","","","","","","","","","5","P 21 21 21","P 2ac 2ab","19","","","","- C14 H19 N O4 S -","- C14 H19 N O4 S -","- C56 H76 N4 O16 S4 -","4","1","","Schrey, Anna; Osterkamp, Frank; Straudi, Alrun; Rickert, Corry; Wagner, Holger; Koert, Ulrich; Herrschaft, Bernhard; Harms, Klaus","Synthesis of Enantiomerically Pure Amino Acids Containing 2,5-Disubstituted THF Rings in the Molecular Backbone","European Journal of Organic Chemistry","1999","1999","11","2977","2990","10.1002/(sici)1099-0690(199911)1999:11<2977::aid-ejoc2977>3.0.co;2-3","","","","","","","","","","","","","","","","","","","","","has coordinates","177980","2020-10-21","18:00:00",""
"1100647","7.623","0.001","9.913","0.001","9.624","0.001","90","","95.9","0.01","90","","723.4","","","","","","","","","","","","","4","P 1 21 1","P 2yb","4","","","","- C12 H21 N O5 -","- C12 H21 N O5 -","- C24 H42 N2 O10 -","2","1","","Schrey, Anna; Osterkamp, Frank; Straudi, Alrun; Rickert, Corry; Wagner, Holger; Koert, Ulrich; Herrschaft, Bernhard; Harms, Klaus","Synthesis of Enantiomerically Pure Amino Acids Containing 2,5-Disubstituted THF Rings in the Molecular Backbone","European Journal of Organic Chemistry","1999","1999","11","2977","2990","10.1002/(sici)1099-0690(199911)1999:11<2977::aid-ejoc2977>3.0.co;2-3","","","","","","","","","","","","","","","","","","","","","has coordinates","177980","2020-10-21","18:00:00",""
"1100648","8.6269","0.0007","9.251","0.002","9.789","0.001","90","","106.459","0.008","90","","749.22","","","","","","","","","","","","","4","P 1 21 1","P 2yb","4","","","","- C12 H21 N O5 -","- C12 H21 N O5 -","- C24 H42 N2 O10 -","2","1","","Schrey, Anna; Osterkamp, Frank; Straudi, Alrun; Rickert, Corry; Wagner, Holger; Koert, Ulrich; Herrschaft, Bernhard; Harms, Klaus","Synthesis of Enantiomerically Pure Amino Acids Containing 2,5-Disubstituted THF Rings in the Molecular Backbone","European Journal of Organic Chemistry","1999","1999","11","2977","2990","10.1002/(sici)1099-0690(199911)1999:11<2977::aid-ejoc2977>3.0.co;2-3","","","","","","","","","","","","","","","","","","","","","has coordinates","177980","2020-10-21","18:00:00",""