# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-13T12:55:33+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 = 52 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
"1000037","8.884","0.004","5.458","0.003","7.153","0.003","90","","90","","90","","346.8","","","","","","","","","","","","from Cow Green Mine, Teesdale, Durham, England","3","P n m a","-P 2ac 2n","62","","Barium sulfate","Barite","- Ba O4 S -","- Ba O4 S -","- Ba4 O16 S4 -","4","0.5","","Colville, A A; Staudhammer, K","A Refinement of the Structure of Barite","American Mineralogist","1967","52","","1877","1880","","","","","","","0.051","","","","","","","","","","","","","","","has coordinates","202022","2020-10-21","18:00:00",""
"1200006","9.794","0.005","8.906","0.005","5.319","0.003","90","","105.9","0.03","90","","446.2","","","","","","","","","","","","from Hessereau Hill, Oka, Quebec","6","C 1 2/c 1","-C 2yc","15","","Magnesium iron calcium aluminium silicate *","Augite","- Al0.7 Ca Fe0.2 Mg0.6 O6 Si1.5 -","- Al0.7 Ca Fe0.2 Mg0.6 O6 Si1.5 -","- Al2.8 Ca4 Fe0.8 Mg2.4 O24 Si6 -","4","0.5","","Peacor, D R","Refinement of the Crystal Structure of a Pyroxene of Formula M1 M2 (Si1.5 Al.5) O6","American Mineralogist","1967","52","","31","41","","","","","","","0.064","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1528742","5.67","","12.03","","4.863","","90","","90","","90","","331.706","","","","","","","","","","","","","8","P b a n :2","-P 2ab 2b","50","","(Mn1.8 Mg0.2) (Y0.72 Ce0.28) (O H)4 (As0.95 Si0.05 O4)","","- As0.95 Ce0.28 H4 Mg0.2 Mn1.8 O8 Si0.05 Y0.72 -","- As0.95 Ce0.28 Mg0.2 Mn1.8 O8 Si0.05 Y0.72 -","- As1.9 Ce0.56 Mg0.4 Mn3.6 O16 Si0.1 Y1.44 -","2","0.25","","Moore, P.B.","Crystal chemistry of the basic manganese arsenate minerals 1. The crystal structures of flinkite, Mn(II)2 Mn(III) (O H)4 (As O4) and retzian, Mn(II)2 Y(III) (O H)4 As O4","American Mineralogist","1967","52","","1603","1613","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1537304","6.717","","6.92","","6.434","","90","","103.83","","90","","290.393","","","","","","","","","","","","","6","P 1 21/n 1","-P 2yn","14","","Ca.3 Ce.15 La.12 Th.4 P O4","","- Ca0.3 Ce0.15 La0.12 O4 P Th0.4 -","- Ca0.3 Ce0.15 La0.12 O4 P Th0.4 -","- Ca1.2 Ce0.6 La0.48 O16 P4 Th1.6 -","4","1","","Finney, J.J.; Rao, N.N.","The Crystal Structure of Cheralite","American Mineralogist","1967","52","","13","19","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"9000148","6.717","","6.92","","6.434","","90","","103.83","","90","","290.393","","","","","","","","","","","","","9","P 1 21/n 1","-P 2yn","14","","","Cheralite","- Ca0.32 Ce0.15 La0.14 O4 P0.96 Pb0.01 Si0.04 Th0.33 U0.05 -","- Ca0.32 Ce0.15 La0.14 O4 P0.96 Pb0.01 Si0.04 Th0.33 U0.05 -","- Ca1.28 Ce0.6 La0.56 O16 P3.84 Pb0.04 Si0.16 Th1.32 U0.2 -","4","1","","Finney, J. J.; Rao, N. N.","The crystal structure of cheralite","American Mineralogist","1967","52","","13","19","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000149","9.794","","8.906","","5.319","","90","","105.9","","90","","446.202","","","","","","","","","","","","","9","C 1 2/c 1","-C 2yc","15","","","Clinopyroxene","- Al0.64 Ca0.98 Fe0.22 Mg0.57 Mn0.01 Na0.01 O6 Si1.5 Ti0.07 -","- Al0.64 Ca0.98 Fe0.22 Mg0.57 Mn0.01 Na0.01 O6 Si1.5 Ti0.07 -","- Al2.56 Ca3.92 Fe0.88 Mg2.28 Mn0.04 Na0.04 O24 Si6 Ti0.28 -","4","0.5","","Peacor, D. R.","Refinement of the crystal structure of a pyroxene of formula M1M2(Si1.5Al0.5)O6","American Mineralogist","1967","52","","31","41","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000150","17.73","","17.82","","7.43","","90","","116.33","","90","","2103.96","","","","","","","","","","","","","5","C 1 m 1","C -2y","8","","","Heulandite-Ca","- Al1.602 Ca H11.333 O16.002 Si4.398 -","- Al1.602 Ca H8.004 O16.002 Si4.398 -","- Al9.612 Ca6 H48.024 O96.012 Si26.388 -","6","1.5","","Merkle, A. B.; Slaughter, M.","The crystal structure of heulandite (Ca,Na2)[Al2Si7O18].6H2O","American Mineralogist","1967","52","","273","276","","","","","","","","","","","","","","","","","","","","","","has coordinates","283852","2023-05-18","08:32:12",""
"9000151","5.237","","9.07","","14.285","","90","","97.03","","90","","673.431","","","","","","","","","","","","","5","C 1 2/m 1","-C 2y","12","","","Sudoite","- Al3.37 H8 Mg2.31 O18 Si3.32 -","- Al3.37 H8 Mg2.31 O18 Si3.32 -","- Al6.74 H16 Mg4.62 O36 Si6.64 -","2","0.25","","Eggleton, R. A.; Bailey, S. W.","Structural aspects of dioctahedral chlorite","American Mineralogist","1967","52","","673","689","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:29",""
"9000152","9.978","","9.156","","5.293","","90","","105.48","","90","","466.019","","","","","","","","","","","","","4","C 1 2/c 1","-C 2yc","15","","","Johannsenite","- Ca Mn O6 Si2 -","- Ca Mn O6 Si2 -","- Ca4 Mn4 O24 Si8 -","4","0.5","","Freed, R. L.; Peacor, D. R.","Refinement of the crystal structure of johannsenite","American Mineralogist","1967","52","","709","720","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000153","4.646","","5.483","","18.486","","90","","90","","90","","470.913","","","","","","","","","","","","","5","P n c m","-P 2 2bc","53","","","Prehnite","- Al2 Ca2 H2 O12 Si3 -","- Al2 Ca2 H2 O12 Si3 -","- Al4 Ca4 H4 O24 Si6 -","2","0.25","","Papike, J. J.; Zoltai, T.","Ordering of tetrahedral aluminium in prehnite, Ca2(Al,Fe)[Si3AlO10](OH)2","American Mineralogist","1967","52","","974","984","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:29",""
"9000154","10.129","","8.306","","8.533","","90","","112.19","","90","","664.724","","","","","","","","","","","","Imperial County, California, USA","4","C 1 2/c 1","-C 2yc","15","","","Glauberite","- Ca Na2 O8 S2 -","- Ca Na2 O8 S2 -","- Ca4 Na8 O32 S8 -","4","0.5","","Araki, T.; Zoltai, T.","Refinement of the crystal structure of a glauberite","American Mineralogist","1967","52","","1272","1277","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000155","13.682","","13.682","","13.682","","90","","90","","90","","2561.23","","","","","","","","","","","","","5","I a -3 d","-I 4bd 2c 3","230","","","Pollucite","- Al0.99 Cs0.7 Na0.3 O6 Si2.01 -","- Al0.99 Cs0.7 Na0.3 O6 Si2.01 -","- Al15.84 Cs11.2 Na4.8 O96 Si32.16 -","16","0.166667","","Newnham, R. E.","Crystal structure and optical properties of pollucite","American Mineralogist","1967","52","","1515","1518","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000156","9.55","","13.11","","5.25","","90","","90","","90","","657.303","","","","","","","","","","","","","4","P n m a","-P 2ac 2n","62","","","Flinkite","- As H4 Mn3 O8 -","- As H4 Mn3 O8 -","- As4 H16 Mn12 O32 -","4","0.5","","Moore, P. B.","Crystal chemistry of the basic manganese arsenate minerals 1. The crystal structures of flinkite, Mn2Mn(OH)4(AsO4) and retzian, Mn2Y(OH)4(AsO4)","American Mineralogist","1967","52","","1603","1613","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:29",""
"9000157","5.67","","12.03","","4.863","","90","","90","","90","","331.706","","","","","","","","","","","","","5","P b a n :2","-P 2ab 2b","50","","","Retzian","- As H4 Mn2 O8 Y -","- As H4 Mn2 O8 Y -","- As2 H8 Mn4 O16 Y2 -","2","0.25","","Moore, P. B.","Crystal chemistry of the basic manganese arsenate minerals 1. The crystal structures of flinkite, Mn2Mn(OH)4(AsO4) and retzian, Mn2Y(OH)4(AsO4)","American Mineralogist","1967","52","","1603","1613","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:29",""
"9000158","5.335","","9.24","","28.735","","90","","90","","90","","1416.5","","","","","","","","","","","","","4","C 1","C 1","1","","","Chlorite","- H4 Mg3 O9 Si2 -","- H4 Mg3 O9 Si2 -","- H32 Mg24 O72 Si16 -","8","","","Lister, J. S.; Bailey, S. W.","Chlorite polytypism: IV. Regular two-layer structures refined structure","American Mineralogist","1967","52","","1614","1631","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:29",""