# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-20T08:26:16+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 'American Mineralogist') AND volume = 46 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
"1525302","5.4272","","5.4272","","5.4272","","90","","90","","90","","159.855","","","","","","","","","","","","","4","F -4 3 m","F -4 2 3","216","","(Fe0.2 Mn0.05 Zn0.75) S","","- Fe0.2 Mn0.05 S Zn0.75 -","- Fe0.2 Mn0.05 S Zn0.75 -","- Fe0.8 Mn0.2 S4 Zn3 -","4","0.0416667","","Skinner, B.J.","Unit-cell edges of natural and synthetic sphalerites","American Mineralogist","1961","46","","1399","1411","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"9000094","7.11","","7.11","","6.2","","90","","90","","90","","313.423","","","","","","","","","","","","Franklin, New Jersey, USA","5","I -4","I -4","82","","","Cahnite","- As B Ca2 H4 O8 -","- As B Ca2 H4 O8 -","- As2 B2 Ca4 H8 O16 -","2","0.25","","Prewitt, C. T.; Buerger, M. J.","The crystal structure of cahnite, Ca2BAsO4(OH)4","American Mineralogist","1961","46","","1077","1085","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:29",""
"9000095","4.99","","4.99","","17.0615","","90","","90","","120","","367.916","","","","","","","","","","","","","3","R -3 c :H","-R 3 2""c","167","","","Calcite","- C Ca O3 -","- C Ca O3 -","- C6 Ca6 O18 -","6","0.166667","","Graf, D. L.","Crystallographic tables for the rhombohedral carbonates","American Mineralogist","1961","46","","1283","1316","","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:12:40",""
"9000096","4.633","","4.633","","15.016","","90","","90","","120","","279.132","","","","","","","","","","","","","3","R -3 c :H","-R 3 2""c","167","","","Magnesite","- C Mg O3 -","- C Mg O3 -","- C6 Mg6 O18 -","6","0.166667","","Graf, D. L.","Crystallographic tables for the rhombohedral carbonates","American Mineralogist","1961","46","","1283","1316","","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:12:40",""
"9000097","4.7771","","4.7771","","15.664","","90","","90","","120","","309.572","","","","","","","","","","","","","3","R -3 c :H","-R 3 2""c","167","","","Rhodochrosite","- C Mn O3 -","- C Mn O3 -","- C6 Mn6 O18 -","6","0.166667","","Graf, D. L.","Crystallographic tables for the rhombohedral carbonates","American Mineralogist","1961","46","","1283","1316","","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:12:40",""
"9000098","4.6887","","4.6887","","15.373","","90","","90","","120","","292.681","","","","","","","","","","","","","3","R -3 c :H","-R 3 2""c","167","","","Siderite","- C Fe O3 -","- C Fe O3 -","- C6 Fe6 O18 -","6","0.166667","","Graf, D. L.","Crystallographic tables for the rhombohedral carbonates","American Mineralogist","1961","46","","1283","1316","","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:12:40",""
"9000099","4.6528","","4.6528","","15.025","","90","","90","","120","","281.692","","","","","","","","","","","","","3","R -3 c :H","-R 3 2""c","167","","","Smithsonite","- C O3 Zn -","- C O3 Zn -","- C6 O18 Zn6 -","6","0.166667","","Graf, D. L.","Crystallographic tables for the rhombohedral carbonates","American Mineralogist","1961","46","","1283","1316","","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:12:40",""
"9000100","4.9204","","4.9204","","16.298","","90","","90","","120","","341.716","","","","","","","","","","","","","3","R -3 c :H","-R 3 2""c","167","","","Otavite","- C Cd O3 -","- C Cd O3 -","- C6 Cd6 O18 -","6","0.166667","","Graf, D. L.","Crystallographic tables for the rhombohedral carbonates","American Mineralogist","1961","46","","1283","1316","","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:12:40",""
"9000101","4.6581","","4.6581","","14.958","","90","","90","","120","","281.075","","","","","","","","","","","","","3","R -3 c :H","-R 3 2""c","167","","","Spherocobaltite","- C Co O3 -","- C Co O3 -","- C6 Co6 O18 -","6","0.166667","","Graf, D. L.","Crystallographic tables for the rhombohedral carbonates","American Mineralogist","1961","46","","1283","1316","","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:12:40",""
"9000102","4.5975","","4.5975","","14.723","","90","","90","","120","","269.507","","","","","","","","","","","","","3","R -3 c :H","-R 3 2""c","167","","","Gaspeite","- C Ni O3 -","- C Ni O3 -","- C6 Ni6 O18 -","6","0.166667","","Graf, D. L.","Crystallographic tables for the rhombohedral carbonates","American Mineralogist","1961","46","","1283","1316","","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:12:40",""
"9000103","4.8797","","4.8797","","16.367","","90","","90","","120","","337.509","","","","","","","","","","","","","4","R -3 c :H","-R 3 2""c","167","","","Kutnohorite","- C Ca0.5 Mn0.5 O3 -","- C Ca0.5 Mn0.5 O3 -","- C6 Ca3 Mn3 O18 -","6","0.166667","","Graf, D. L.","Crystallographic tables for the rhombohedral carbonates Note: Disordered model","American Mineralogist","1961","46","","1283","1316","","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:12:40",""
"9000104","4.796","","4.796","","15.48","","90","","90","","120","","308.361","","","","","","","","","","","","","3","R -3 c :H","-R 3 2""c","167","","","","- C Cu O3 -","- C Cu O3 -","- C6 Cu6 O18 -","6","0.166667","","Graf, D. L.","Crystallographic tables for the rhombohedral carbonates","American Mineralogist","1961","46","","1283","1316","","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:12:40",""
"9000105","4.8079","","4.8079","","16.01","","90","","90","","120","","320.504","","","","","","","","","","","","","4","R -3 :H","-R 3","148","","","Dolomite","- C2 Ca Mg O6 -","- C2 Ca Mg O6 -","- C6 Ca3 Mg3 O18 -","3","0.166667","","Graf, D. L.","Crystallographic tables for the rhombohedral carbonates","American Mineralogist","1961","46","","1283","1316","","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:12:40",""
"9000106","4.777","","4.777","","15.641","","90","","90","","120","","309.105","","","","","","","","","","","","","4","R -3 :H","-R 3","148","","","","- C2 Cd Mg O6 -","- C2 Cd Mg O6 -","- C6 Cd3 Mg3 O18 -","3","0.166667","","Graf, D. L.","Crystallographic tables for the rhombohedral carbonates","American Mineralogist","1961","46","","1283","1316","","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:12:40",""
"9000107","5.4093","","5.4093","","5.4093","","90","","90","","90","","158.279","","","","","","","","","","","","Synthetic","2","F -4 3 m","F -4 2 3","216","","","Sphalerite","- S Zn -","- S Zn -","- S4 Zn4 -","4","0.0416667","","Skinner, B. J.","Unit-cell edges of natural and synthetic sphalerites","American Mineralogist","1961","46","","1399","1411","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000108","5.833","","5.833","","5.833","","90","","90","","90","","198.461","","","","","","","","","","","","Synthetic","2","F -4 3 m","F -4 2 3","216","","","Hawleyite","- Cd S -","- Cd S -","- Cd4 S4 -","4","0.0416667","","Skinner, B. J.","Unit-cell edges of natural and synthetic sphalerites","American Mineralogist","1961","46","","1399","1411","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000109","5.744","","5.675","","5.785","","90","","112.28","","90","","174.496","","","","","","","","","","","","","3","P -1","-P 1","2","","","Arsenopyrite","- As Fe S -","- As Fe S -","- As4 Fe4 S4 -","4","2","","Morimoto, N.; Clark, L. A.","Arsenopyrite crystal-chemical relations From Freiberg, Germany","American Mineralogist","1961","46","","1448","1469","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""