# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2026-02-03T16:51:19+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 'American Mineralogist') 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
"9000110","10.7269","","10.7269","","7.9476","","90","","90","","90","","914.502","","","","","","","","","","","","","4","I 4/m","-I 4","87","","","Narsarsukite","- Na4 O22 Si8 Ti2 -","- Na4 O22 Si8 Ti2 -","- Na8 O44 Si16 Ti4 -","2","0.125","","Peacor, D. R.; Buerger, M. J.","The determination and refinement of the structure of narsarsukite, Na2TiOSi4O10","American Mineralogist","1962","47","","539","556","","","","","","","","","","","","","","","","","","","","","","has coordinates","303136","2025-11-01","12:31:41",""
"9000111","5.36","","9.29","","10.41","","90","","100","","90","","510.485","","","","","","","","","","","","","7","C 1 2/m 1","-C 2y","12","","","Phlogopite","- Fe H2 K0.9 Mg3 Mn0.1 O12 Si3 -","- Fe H2 K0.9 Mg3 Mn0.1 O12 Si3 -","- Fe2 H4 K1.8 Mg6 Mn0.2 O24 Si6 -","2","0.25","","Steinfink, H.","Crystal structure of a trioctahedral mica: Phlogopite","American Mineralogist","1962","47","","886","889","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:29",""
"9000112","3.585","","3.585","","4.871","","90","","90","","120","","54.216","","","","83.15","","","","","","","","","3","P -3 m 1","-P 3 2""","164","","","Portlandite","- Ca H2 O2 -","- Ca H2 O2 -","- Ca H2 O2 -","1","0.0833333","","Henderson, D. M.; Gutowsky, H. S.","A nuclear magnetic resonance determination of the hydrogen positions in Ca(OH)2 T = -190 C","American Mineralogist","1962","47","","1231","1251","","","","","","","","","","","","","","","","","","","","","","has coordinates","301881","2025-08-23","00:12:08",""
"9000113","3.5925","","3.5925","","4.905","","90","","90","","120","","54.823","","","","298.15","","","","","","","","","3","P -3 m 1","-P 3 2""","164","","","Portlandite","- Ca H2 O2 -","- Ca H2 O2 -","- Ca H2 O2 -","1","0.0833333","","Henderson, D. M.; Gutowsky, H. S.","A nuclear magnetic resonance determination of the hydrogen positions in Ca(OH)2 T = 25 C","American Mineralogist","1962","47","","1231","1251","","","","","","","","","","","","","","","","","","","","","","has coordinates","301881","2025-08-23","00:12:08",""
"9013162","3.812","","3.812","","18.68999","","90","","90","","120","","235.204","","","","","","","","","","","","Thomaston Dam, Connecticut","2","P 63 m c","P 6c -2c","186","","","Wurtzite-6H","- S Zn -","- S Zn -","- S6 Zn6 -","6","0.5","","Myer, G. H.","Hydrothermal wurtzite at Thomaston Dam, Connecticut","American Mineralogist","1962","47","","977","979","","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:48",""