# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-20T12:52:10+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 = 54 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
"1527190","10.155","","10.155","","14.284","","90","","90","","120","","1275.68","","","","","","","","","","","","","9","P 6/m c c","-P 6 2c","192","","(K0.78 Na0.22) (Mg0.92 Fe0.92 Mn0.16) (Al2.63 Fe0.37) ((Si10.2 Al1.8) O30) (H2 O)","","- Al4.43 Fe1.29 H2 K0.78 Mg0.92 Mn0.16 Na0.22 O31 Si10.2 -","- Al4.44 Fe1.28 K0.78 Mg0.92 Mn0.16 Na0.22 O31.002 Si10.2 -","- Al8.88 Fe2.56 K1.56 Mg1.84 Mn0.32 Na0.44 O62.004 Si20.4 -","2","0.0833333","","Brown, G.E.; Gibbs, G.V.","Refinement of the crystal structure of osumilite","American Mineralogist","1969","54","","101","114","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1535814","8.878","","5.692","","10.201","","90","","115.4","","90","","465.663","","","","","","","","","","","","","6","P 1 21/m 1","-P 2yb","11","","Ca2 Al2 Mn (Si3 O12) (O H)","","- Al2 Ca2 H Mn O13 Si3 -","- Al2 Ca2 H Mn O13 Si3 -","- Al4 Ca4 H2 Mn2 O26 Si6 -","2","0.5","","Dollase, W.A.","Crystal structure and cation ordering of piemontite","American Mineralogist","1969","54","","710","717","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"9000181","7.353","","25.225","","6.097","","90","","95.2","","90","","1126.21","","","","","","","","","","","","","5","P 1 21/a 1","-P 2yab","14","","","Tamarugite","- Al H12 Na O14 S2 -","- Al H12 Na O14 S2 -","- Al4 H48 Na4 O56 S8 -","4","1","","Robinson, P. D.; Fang, J. H.","Crystal structures and mineral chemistry of double-salt hydrates: I. Direct determination of the crystal structure of tamarugite","American Mineralogist","1969","54","","19","30","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:29",""
"9000182","11.266","","14.401","","9.929","","90","","125.46","","90","","1312.11","","","","","","","","","","","","","4","P 1 21/a 1","-P 2yab","14","","","Sapphirine","- Al9 Mg3.5 O20 Si1.5 -","- Al9 Mg3.5 O20 Si1.5 -","- Al36 Mg14 O80 Si6 -","4","1","","Moore, P. B.","The crystal structure of sapphirine","American Mineralogist","1969","54","","31","49","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000183","10.155","","10.155","","14.284","","90","","90","","120","","1275.68","","","","","","","","","","","","","10","P 6/m c c","-P 6 2c","192","","","Osumilite","- Al4.44 Ca0.01 Fe1.28 H1.992 K0.71 Mg0.92 Mn0.16 Na0.28 O30.996 Si10.2 -","- Al4.44 Ca0.01 Fe1.28 H1.992 K0.71 Mg0.92 Mn0.16 Na0.28 O30.996 Si10.2 -","- Al8.88 Ca0.02 Fe2.56 H3.984 K1.42 Mg1.84 Mn0.32 Na0.56 O61.992 Si20.4 -","2","0.0833333","","Brown, G. E.; Gibbs, G. V.","Refinement of the crystal structure of osumilite","American Mineralogist","1969","54","","101","116","","","","","","","","","","","","","","","","","","","","","","has coordinates","287555","2023-11-12","10:38:26",""
"9000184","3.119","","3.119","","24.52","","90","","90","","120","","206.577","","","","","","","","","","","","","5","R -3 m :H","-R 3 2""","166","","","Iowaite","- Cl0.2 Fe0.2 H2.6 Mg0.8 O2.6 -","- Cl0.2 Fe0.2 H2.6 Mg0.8 O2.6 -","- Cl0.6 Fe0.6 H7.8 Mg2.4 O7.8 -","3","0.0833333","","Allmann, R.; Donnay, J. D. H.","About the structure of iowaite","American Mineralogist","1969","54","","296","299","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:29",""
"9000185","4.7104","","10.2718","","8.7476","","90","","90","","90","","423.246","","","","","","","","","","","","","5","P b n m","-P 2c 2ab","62","","","Norbergite","- F1.8 H0.2 Mg3 O4.2 Si -","- F1.8 H0.2 Mg3 O4.2 Si -","- F7.2 H0.8 Mg12 O16.8 Si4 -","4","0.5","","Gibbs, G. V.; Ribbe, P. H.","The crystal structures of the humite minerals: I. Norbergite","American Mineralogist","1969","54","","376","390","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:29",""
"9000186","8.878","","5.692","","10.201","","90","","115.4","","90","","465.663","","","","","","","","","","","","","8","P 1 21/m 1","-P 2yb","11","","","Piemontite","- Al1.97 Ca1.87 Fe0.31 H Mn0.72 O13 Si3 Sr0.13 -","- Al1.97 Ca1.87 Fe0.31 H Mn0.72 O13 Si3 Sr0.13 -","- Al3.94 Ca3.74 Fe0.62 H2 Mn1.44 O26 Si6 Sr0.26 -","2","0.5","","Dollase, W. A.","Crystal structure and cation ordering of piemontite","American Mineralogist","1969","54","","710","717","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000187","13.79","","13.68","","3.279","","90","","90","","90","","618.574","","","","","","","","","","","","","5","P n n m","-P 2 2n","58","","","Gageite","- H10 Mg2.01 Mn4.99 O15 Si2 -","- H10 Mg2.01 Mn4.99 O15 Si2 -","- H20 Mg4.02 Mn9.98 O30 Si4 -","2","0.25","","Moore, P. B.","A novel octahedral framework structure: gageite","American Mineralogist","1969","54","","1005","1017","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:29",""
"9000188","9.647","","7.428","","10.194","","90","","104.63","","90","","706.796","","","","","","","","","","","","","5","P 1 21/a 1","-P 2yab","14","","","Pseudolaueite","- Fe2 H18 Mn O18 P2 -","- Fe2 H18 Mn O18 P2 -","- Fe4 H36 Mn2 O36 P4 -","2","0.5","","Baur, W. H.","A comparison of the crystal structures of pseudolaueite and laueite","American Mineralogist","1969","54","","1312","1323","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:29",""
"9000189","8.5784","","12.96","","7.2112","","90.3","","116.03","","89.125","","720.306","","","","","","","","","","","","","4","C -1","-P 1 (1/2*x+1/2*y,1/2*x-1/2*y,-z)","2","","","Microcline","- Al0.93 K O8 Si3.07 -","- Al0.93 K O8 Si3.07 -","- Al3.72 K4 O32 Si12.28 -","4","","","Bailey, S. W.","Refinement of an intermediate microcline structure","American Mineralogist","1969","54","","1540","1545","","","","","","","","","","","","","","","","","","","","","","has coordinates","283960","2023-05-23","08:41:56",""