# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-24T16:29:21+01: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 Chemical Society') AND volume = 1947 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
"1537341","7.14","","7.65","","5.83","","90","","90","","90","","318.44","","","","","","","","","","","","","3","P b n m","-P 2c 2ab","62","","(N H4) (N O3)","","- H4 N2 O3 -","- H4 N2 O3 -","- H16 N8 O12 -","4","0.5","","Goodwin, T.H.; Whetstone, J.","The crystal structure of ammonium nitrate III, and atomic scattering factors in ionic crystals","Journal of the Chemical Society","1947","1947","","1455","1461","","","","","","","","","","","","","","","","","","","","","","has coordinates","186592","2020-10-21","18:00:00",""
"1539944","7.2","","7.2","","18","","90","","90","","120","","808.106","","","","","","","","","","","","","3","P 61 2 2","P 61 2 (0 0 5)","178","","Cs Cu Cl3","","- Cl3 Cs Cu -","- Cl3 Cs Cu -","- Cl18 Cs6 Cu6 -","6","0.5","","Wells, A.F.","The Crystal Structure of Cs Cu Cl3 and the Crystal Chemistry of Complex Halides A B X3","Journal of the Chemical Society","1947","1947","","1662","1670","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1539945","6.85","","3.3","","6.7","","90","","121","","90","","129.821","","","","","","","","","","","","","2","C 1 2/m 1","-C 2y","12","","Cu Cl2","","- Cl2 Cu -","- Cl2 Cu -","- Cl4 Cu2 -","2","0.25","","Wells, A.F.","The crystal structure of anhydrous cupric chloride, and the stereochemistry of the cupric atom","Journal of the Chemical Society","1947","1947","","1670","1675","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""