# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2025-04-28T02:36:48+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 = 49 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
"1011065","7.45","","7.45","","7.88","","90","","90","","90","","437.4","","","","","","","","","","","","synthetic","5","P 42/m n m","-P 4n 2n","136","","Potassium tetrachlorocuprate dihydrate","Mitscherlichite","- Cl4 Cu H4 K2 O2 -","- Cl4 Cu H4 K2 O2 -","- Cl8 Cu2 H8 K4 O4 -","2","0.125","","Hendricks, S B; Dickinson, R G","The Crystal Structure of ammonium, potassium and rubidium cupric chloride dihydrates","Journal of the American Chemical Society","1927","49","","2149","2162","10.1021/ja01408a005","","","","","","","","","","","","","","","","","","","","","has coordinates","200452","2020-10-21","18:00:00",""
"1011075","4.92","","4.92","","11.64","","90","","90","","90","","281.8","","","","","","","","","","","","synthetic","2","I -4 m 2","I -4 -2","119","","Dimercury(I) iodide","Moschelite","- Hg2 I2 -","- Hg2 I2 -","- Hg4 I4 -","2","0.125","","Huggins, M L; Magill, P L","The crystal stuctures of mercuric and mercurous iodides","Journal of the American Chemical Society","1927","49","","2357","2367","10.1021/ja01409a003","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"4124693","6.99","","6.99","","6.99","","90","","90","","90","","341.532","","","","","","","","","","","","","2","F d -3 m :1","F 4d 2 3 -1d","227","","","","- Cu2 Mg -","- Cu2 Mg -","- Cu16 Mg8 -","8","0.0416667","","Friauf, J.B.","The structure of two intermetallic compounds","Journal of the American Chemical Society","1927","49","","3107","3114","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""