# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-09-28T06:15:06+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 'Journal of the American Chemical Society') AND volume = 97 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
"5000048","8.859","0.001","8.859","0.001","38.119","0.005","90","","90","","120","","2590.85","","","","","","","","","","","","","5","P 31","P 31","144","","","","- C37 H42 Mg N4 O7 -","- C37 H42 Mg N4 O7 -","- C111 H126 Mg3 N12 O21 -","3","1","","Chow, H.-C.; Serlin, R.; Strouse, C. E.","Crystal and Molecular Structure and Absolute Configuration of Ethyl Chlorophyllide a Dihydrate. Model for the Different Spectral Forms of Chlorophyll a","Journal of the American Chemical Society","1975","97","25","7230","7237","10.1021/ja00858a006","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"5000254","21.137","0.007","12.861","0.005","9.516","0.003","90","","90","","90","","2586.86","","","","","","","","","","","","","4","P 21 21 21","P 2ac 2ab","19","","","","- C24 H22 Cl4 O6 -","- C24 H21 Cl4 O6 -","- C96 H84 Cl16 O24 -","4","1","","Arora, Satish K.; Bates, Robert B.; Grady, Raymond A.; Delfel, Norman E.","Crystal and molecular structure of the one to one complex of rotenone and carbon tetrachloride","Journal of the American Chemical Society","1975","97","20","5752","5755","10.1021/ja00853a020","","","","","","","","","","","","","","","","","","","","","has coordinates","175374","2020-10-21","18:00:00",""
"5000255","9.213","0.002","11.837","0.003","18.573","0.007","90","","90","","90","","2025.47","","","","","","","","","","","","","5","P 21 21 21","P 2ac 2ab","19","","","","- C12 H25 Cl2 N7 O5 -","- C12 Cl2 N7 O5 -","- C48 Cl8 N28 O20 -","4","1","","Bordner, Jon; Thiessen, William E.; Bates, Hans A.; Rapoport, Henry","Structure of a crystalline derivative of saxitoxin. Structure of saxitoxin","Journal of the American Chemical Society","1975","97","21","6008","6012","10.1021/ja00854a009","","","","","","","","","","","","","","","","","","","","","has coordinates","175374","2020-10-21","18:00:00",""
"5000277","13.676","0.005","30.663","0.009","6.821","0.002","90","","90","","90","","2860.37","","","","","","","","","","","","","4","P 21 21 21","P 2ac 2ab","19","","","","- C29 H30 N4 O10 -","- C29 H14 N4 O10 -","- C116 H56 N16 O40 -","4","1","","Chiu, Yuan-Yuan H.; Lipscomb, William N.","Molecular and crystal structure of streptonigrin","Journal of the American Chemical Society","1975","97","9","2525","2530","10.1021/ja00842a033","","","","","","","","","","","","","","","","","","","","","has coordinates","175374","2020-10-21","18:00:00",""