# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-29T13:01:39+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 'Green Chemistry') AND volume = 8 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
"7203136","9.4647","0.0002","9.9534","0.0002","15.7079","0.0004","90","","98.509","0.001","90","","1463.49","0.06","150","2","150","2","","","","","","","","4","P 1 21/n 1","-P 2yn","14","N,N'-Bis(furan-2-ylmethylene)cyclohexane-1,2-diamine","","","- C16 H18 N2 O2 -","- C16 H18 N2 O2 -","- C64 H72 N8 O8 -","4","1","","van den Ancker, Tania R.; Cave, Gareth W. V.; Raston, Colin L.","Benign approaches for the synthesis of bis-imine Schiff bases","Green Chemistry","2006","8","1","50","","10.1039/b513289d","","","0.71073","MoKα","","0.0721","0.0467","","","0.1155","0.1285","","","","","","1.039","","","","has coordinates","180362","2020-10-21","18:00:00",""
"7203137","18.5478","0.0004","8.9189","0.0002","9.2148","0.0002","90","","101.388","0.001","90","","1494.36","0.06","150","2","150","2","","","","","","","","3","C 1 2/c 1","-C 2yc","15","N,N'-Bis(1H-pyrrol-2-ylmethylene)cyclohexane-1,2-diamine","","","- C16 H20 N4 -","- C16 H20 N4 -","- C64 H80 N16 -","4","0.5","","van den Ancker, Tania R.; Cave, Gareth W. V.; Raston, Colin L.","Benign approaches for the synthesis of bis-imine Schiff bases","Green Chemistry","2006","8","1","50","","10.1039/b513289d","","","0.71073","MoKα","","0.0402","0.0371","","","0.0989","0.1012","","","","","","1.067","","","","has coordinates","180362","2020-10-21","18:00:00",""
"7203138","35.5824","0.0014","5.701","0.0003","16.8318","0.0009","90","","112.752","0.002","90","","3148.7","0.3","150","2","396","2","","","","","","","","3","C 1 2/c 1","-C 2yc","15","(N-Pyridin-4-ylmethylene)(N'-pyridin-2-ylmethylene) cyclohexane-1,2-diamine","","","- C18 H20 N4 -","- C18 H20 N4 -","- C144 H160 N32 -","8","1","","van den Ancker, Tania R.; Cave, Gareth W. V.; Raston, Colin L.","Benign approaches for the synthesis of bis-imine Schiff bases","Green Chemistry","2006","8","1","50","","10.1039/b513289d","","","0.71073","MoKα","","0.1266","0.0665","","","0.1574","0.1844","","","","","","1.02","","","","has coordinates","180362","2020-10-21","18:00:00",""
"7203388","7.925","0.005","10.643","0.006","13.886","0.008","90","","99.478","0.008","90","","1155.2","1.2","193.1","","","","","","","","","","","5","P 1 21/a 1","-P 2yab","14","","","","- C12 H10 F3 N O2 -","- C12 H10 F3 N O2 -","- C48 H40 F12 N4 O8 -","4","1","","Kayaki, Yoshihito; Yamamoto, Masafumi; Suzuki, Tomoyuki; Ikariya, Takao","Carboxylative cyclization of propargylamines with supercritical carbon dioxide","Green Chemistry","2006","8","12","1019","","10.1039/b603700c","","","0.7107","MoKα","","","0.055","","","","0.162","","","","","","0.947","","","","has coordinates","202017","2020-10-21","18:00:00",""
"7203394","7.1209","0.0008","16.3999","0.0019","15.0997","0.0016","90","","92.716","0.004","90","","1761.4","0.3","193","2","193","2","","","","","","","","5","P 1 21/c 1","-P 2ybc","14","","1,8-dioxo-3, 3-dimethyl-9-(4-Chloro-phenyl)- 1,2,3,4,5,6,7,8,9,10-decahydroacridine","","- C21 H22 Cl N O2 -","- C21 H22 Cl N O2 -","- C84 H88 Cl4 N4 O8 -","4","1","","Wang, Guan-Wu; Miao, Chun-Bao","Environmentally benign one-pot multi-component approaches to the synthesis of novel unsymmetrical 4-arylacridinediones","Green Chemistry","2006","8","12","1080","","10.1039/b604064k","","","0.7107","MoKα","","0.0454","0.0412","","","0.0963","0.0986","","","","","","1.099","","","","has coordinates","176432","2020-10-21","18:00:00",""
"7203399","7.936","0.003","10.048","0.004","17.864","0.007","91.753","0.008","102.116","0.007","106.858","0.007","1326.5","0.9","173","2","173","2","","","","","","","","4","P -1","-P 1","2","benzethonium nitrate","","","- C27 H42 N2 O5 -","- C27 H42 N2 O5 -","- C54 H84 N4 O10 -","2","1","","Pernak, Juliusz; Smiglak, Marcin; Griffin, Scott T.; Hough, Whitney L.; Wilson, Timothy B.; Pernak, Anna; Zabielska-Matejuk, Jadwiga; Fojutowski, Andrzej; Kita, Kazimierz; Rogers, Robin D.","Long alkyl chain quaternary ammonium-based ionic liquids and potential applications","Green Chemistry","2006","8","9","798","","10.1039/b604353d","","","0.71073","MoKα","","0.1503","0.1123","","","0.3193","0.3388","","","","","","1.046","","","","has coordinates","202017","2020-10-21","18:00:00",""
"7203438","11.219","0.0003","12.8515","0.0003","14.1651","0.0004","82.272","0.001","88.467","0.001","75.715","0.001","1961.17","0.09","123","2","123","2","","","","","","","","3","P -1","-P 1","2","(E,E)-2-(4-Ethoxy-3-methoxybenzylidene)-6-(4- methoxybenzylidene)cyclohexanone","(E,E)-2-(4-Ethoxy-3-methoxybenzylidene)-6-(4-methoxybenzylidene)cyclohexanone","","- C24 H26 O4 -","- C24 H26 O4 -","- C96 H104 O16 -","4","2","","Rosamilia, Anthony E.; Giarrusso, Marilena A.; Scott, Janet L.; Strauss, Christopher R.","A direct, efficient synthesis of unsymmetrically substituted bis(arylidene)alkanones","Green Chemistry","2006","8","12","1042","","10.1039/b606042k","","","0.71073","MoKα","","0.0655","0.045","","","0.1069","0.1177","","","","","","1.024","","","","has coordinates","180365","2020-10-21","18:00:00",""
"7203439","7.8646","0.0003","9.683","0.0003","11.3746","0.0005","95.587","0.001","102.801","0.001","91.992","0.002","839.25","0.06","123","2","123","2","","","","","","","","4","P -1","-P 1","2","(E,E)-2-(4-Methoxybenzylidene)-6-(4- nitrobenzylidene)cyclohexanone","(E,E)-2-(4-Methoxybenzylidene)-6-(4-nitrobenzylidene)cyclohexanone","","- C21 H19 N O4 -","- C21 H19 N O4 -","- C42 H38 N2 O8 -","2","1","","Rosamilia, Anthony E.; Giarrusso, Marilena A.; Scott, Janet L.; Strauss, Christopher R.","A direct, efficient synthesis of unsymmetrically substituted bis(arylidene)alkanones","Green Chemistry","2006","8","12","1042","","10.1039/b606042k","","","0.71073","MoKα","","0.0658","0.04","","","0.0904","0.1018","","","","","","1.044","","","","has coordinates","202017","2020-10-21","18:00:00",""
"7203440","18.5748","0.0001","6.2641","0.0001","15.9337","0.0001","90","","115.194","0.001","90","","1677.59","0.03","123","2","123","2","","","","","","","","5","P 1 21/c 1","-P 2ybc","14","(E,E)-2-((6-Bromopyridin-2-yl)methylene)-6-(4- methoxybenzylidene)cyclohexanone","(E,E)-2-((6-Bromopyridin-2-yl)methylene)-6-(4-methoxybenzylidene)cyclohexanone","","- C20 H18 Br N O2 -","- C20 H18 Br N O2 -","- C80 H72 Br4 N4 O8 -","4","1","","Rosamilia, Anthony E.; Giarrusso, Marilena A.; Scott, Janet L.; Strauss, Christopher R.","A direct, efficient synthesis of unsymmetrically substituted bis(arylidene)alkanones","Green Chemistry","2006","8","12","1042","","10.1039/b606042k","","","0.71073","MoKα","","0.0656","0.0371","","","0.0697","0.0763","","","","","","1.027","","","","has coordinates","202017","2020-10-21","18:00:00",""
"7203441","11.5683","0.0004","12.3023","0.0004","13.6088","0.0005","98.825","0.001","110.125","0.002","111.483","0.002","1603.3","0.11","123","2","123","2","","","","","","","","5","P -1","-P 1","2","","(E)-N,N-dimethyl-9-(naphthalen-1-yl)-5-(naphthalen-2-ylmethylene) -2,3,4,4a,5,6,7,8,9,9a-decahydro-1H-xanthen-4a-amine hydrochloride salt","","- C36 H38 Cl N O -","- C36 H38 Cl N O -","- C72 H76 Cl2 N2 O2 -","2","1","","Rosamilia, Anthony E.; Giarrusso, Marilena A.; Scott, Janet L.; Strauss, Christopher R.","A direct, efficient synthesis of unsymmetrically substituted bis(arylidene)alkanones","Green Chemistry","2006","8","12","1042","","10.1039/b606042k","","","0.71073","MoKα","","0.1809","0.0644","","","0.1623","0.2063","","","","","","0.988","","","","has coordinates","180365","2020-10-21","18:00:00",""
"7203442","10.0896","0.0001","13.29","0.0002","16.6649","0.0003","90","","103.981","0.001","90","","2168.41","0.06","123","2","123","2","","","","","","","","4","P 1 21/n 1","-P 2yn","14","","(E)-N,N-dimethyl-9-(pyridin-4-yl)-5-(pyridin-4-ylmethylene) -2,3,4,4a,5,6,7,8,9,9a-decahydro-1H-xanthen-4a-amine","","- C26 H31 N3 O -","- C26 H31 N3 O -","- C104 H124 N12 O4 -","4","1","","Rosamilia, Anthony E.; Giarrusso, Marilena A.; Scott, Janet L.; Strauss, Christopher R.","A direct, efficient synthesis of unsymmetrically substituted bis(arylidene)alkanones","Green Chemistry","2006","8","12","1042","","10.1039/b606042k","","","0.71073","MoKα","","0.0836","0.0498","","","0.0985","0.1113","","","","","","1.059","","","","has coordinates","180365","2020-10-21","18:00:00",""
"7203443","8.763","0.0002","10.924","0.0002","20.1019","0.0005","90","","90","","90","","1924.29","0.07","123","2","123","2","","","","","","","","4","P b c a","-P 2ac 2ab","61","","7a-Dimethylamino-5,6,7,7a-tetrahydro-4H-benzofuran-2-one","","- C10 H15 N O2 -","- C10 H15 N O2 -","- C80 H120 N8 O16 -","8","1","","Rosamilia, Anthony E.; Giarrusso, Marilena A.; Scott, Janet L.; Strauss, Christopher R.","A direct, efficient synthesis of unsymmetrically substituted bis(arylidene)alkanones","Green Chemistry","2006","8","12","1042","","10.1039/b606042k","","","0.71073","MoKα","","0.0935","0.0496","","","0.1182","0.1495","","","","","","1.083","","","","has coordinates","180365","2020-10-21","18:00:00",""