# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-17T13:17:46+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 = 47 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
"1010088","5.481","","5.481","","5.481","","38.72","","38.72","","38.72","","57.9","","","","","","","","","","","","","2","R -3 m :R","-P 3* 2","166","","Sodium azide","","- N3 Na -","- N3 Na -","- N3 Na -","1","0.0833333","","Hendricks, S B; Pauling, L","The Crystal Structures of Sodium and Potassium Trinitrides and Potassium Cyanate and the Nature of the Trinitride Group","Journal of the American Chemical Society","1925","47","","2904","2920","10.1021/ja01689a008","","","","","","","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00",""
"1010089","6.094","","6.094","","7.056","","90","","90","","90","","262","","","","","","","","","","","","","2","I 4/m c m","-I 4 2c","140","","Potassium azide","","- K N3 -","- K N3 -","- K4 N12 -","4","0.125","","Hendricks, S B; Pauling, L","The Crystal Structures of Sodium and Potassium Trinitrides and Potassium Cyanate and the Nature of the Trinitride Group","Journal of the American Chemical Society","1925","47","","2904","2920","10.1021/ja01689a008","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010090","6.07","","6.07","","7.03","","90","","90","","90","","259","","","","","","","","","","","","","4","I 4/m c m","-I 4 2c","140","","Potassium cyanate","","- C K N O -","- C K N O -","- C4 K4 N4 O4 -","4","0.125","","Hendricks, S B; Pauling, L","The Crystal Structures of Sodium and Potassium Trinitrides and Potassium Cyanate and the Nature of the Trinitride Group","Journal of the American Chemical Society","1925","47","","2904","2920","10.1021/ja01689a008","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1010914","5.12","0.01","5.12","0.01","5.12","0.01","55.28","","55.28","","55.28","","84.5","","","","","","","","","","","","Ceylon","2","R -3 c :R","-P 3* 2n","167","","Aluminium oxide","Corundum","- Al2 O3 -","- Al2 O3 -","- Al4 O6 -","2","0.166667","","Pauling, L; Hendricks, S B","Crystal Structures of Hematite and Corundum","Journal of the American Chemical Society","1925","47","","781","790","10.1021/ja01680a027","","","","","","","","","","","","","","","","","","","","","has coordinates","282053","2023-03-24","19:00:08",""
"1011240","5.43","","5.43","","5.43","","55.28","","55.28","","55.28","","100.8","","","","","","","","","","","","","2","R -3 c :R","-P 3* 2n","167","","Iron(III) oxide","Hematite","- Fe2 O3 -","- Fe2 O3 -","- Fe4 O6 -","2","0.166667","","Pauling, L; Hendricks, S B","The Structure of Hematite","Journal of the American Chemical Society","1925","47","","781","790","10.1021/ja01680a027","","","","","","","","","","","","","","","","","","","","","has coordinates","201954","2020-10-21","18:00:00",""
"9009782","5.42","","5.42","","5.42","","55.28","","55.28","","55.28","","100.236","","","","","","","","","","","","","2","R -3 c :R","-P 3* 2n","167","","","Hematite","- Fe2 O3 -","- Fe2 O3 -","- Fe4 O6 -","2","0.166667","","Pauling, L.; Hendricks, S. B.","Crystal structures of hematite and corundum","Journal of the American Chemical Society","1925","47","","781","790","10.1021/ja01680a027","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:32",""
"9017518","5.43","","5.43","","5.43","","55.28","","55.28","","55.28","","100.792","","","","","","","","","","","","","2","R 3 c :R","P 3* -2n","161","","","Hematite","- Fe O3 -","- Fe2 O6 -","- Fe2 O6 -","","","","Pauling, L.; Hendricks, S.","The Structure of Hematite","Journal of the American Chemical Society","1925","47","","781","790","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","07:59:03",""