# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-01T13:36:30+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 = 66 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 "4123985","8.74","","9.84","","12.61","","90","","90","","90","","1084.48","","","","","","","","","","","","","4","P n m a","-P 2ac 2n","62","","(N H4)3 (Zn Cl4) Cl","","- Cl5 H12 N3 Zn -","- Cl5 H12 N3 Zn -","- Cl20 H48 N12 Zn4 -","4","0.5","","Klug, H.P.; Alexander, L.","The Crystal Structure of Ammonium Pentachlorozincate","Journal of the American Chemical Society","1944","66","","1056","1064","","","","","","","","","","","","","","","","","","","","","","has coordinates","189055","2020-10-21","18:00:00","" "4124637","20.23","","5.75","","5.95","","90","","90","","90","","692.119","","","","","","","","","","","","","4","I b c a","-I 2b 2c","73","","K Ag (C O3)","","- C Ag K O3 -","- C Ag K O3 -","- C8 Ag8 K8 O24 -","8","0.5","","Donohue, J.; Helmholz, L.","The crystal structure of potassium silver carbonate, K Ag C O3","Journal of the American Chemical Society","1944","66","","295","298","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""