# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-20T16:49:02+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 'Mineralogical Society of America: Special Papers') AND volume = 2 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
"1000035","9.699","0.001","8.844","0.001","5.272","0.001","90","","106.97","0.02","90","","432.5","","","","","","","","","","","","from Kakanui, New Zealand","7","C 1 2/c 1","-C 2yc","15","","Sodium calcium magnesium iron titanium alumosilicate *","Augite","- Al0.34 Ca0.6 Fe0.2 Mg0.9 Na0.1 O6 Si1.82 -","- Al0.342 Ca0.616 Fe0.21 Mg0.902 Na0.09 O6 Si1.82 Ti0.02 -","- Al1.368 Ca2.464 Fe0.84 Mg3.608 Na0.36 O24 Si7.28 Ti0.08 -","4","0.5","","Clark, J R; Appleman, D E; Papike, J J","Crystal-Chemical Characterization of Clinopyroxenes based on Eight New Structure Refinements","Mineralogical Society of America: Special Papers","1969","2","","31","50","","","","","","","0.049","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1531195","9.55","","8.712","","5.272","","90","","107.44","","90","","418.465","","","","","","","","","","","","","4","C 1 2/c 1","-C 2yc","15","","Na Cr Si2 O6","","- Cr Na O6 Si2 -","- Cr Na O6 Si2 -","- Cr4 Na4 O24 Si8 -","4","0.5","","Clark, J.R.; Appleman, D.E.; Papike, J.J.","Crystal-Chemical Characterization of Clinopyroxenes based on Eight New Structure Refinements","Mineralogical Society of America: Special Papers","1969","2","","31","50","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1531198","9.551","","8.751","","5.254","","90","","106.87","","90","","420.236","","","","","","","","","","","","","7","P 1 2 1","P 2y","3","","(Na0.5 Ca0.5) (Mg0.43 Fe0.07 Al0.5) (Si2 O6)","","- Al0.5 Ca0.5 Fe0.07 Mg0.43 Na0.5 O6 Si2 -","- Al0.5 Ca0.5 Fe0.07 Mg0.43 Na0.5 O6 Si2 -","- Al2 Ca2 Fe0.28 Mg1.72 Na2 O24 Si8 -","4","2","","Clark, J.R.; Papike, J.J.; Appleman, D.E.","Crystal-chemical characterization of clinopyroxenes based on eight new structure refinements","Mineralogical Society of America: Special Papers","1969","2","","31","50","","","","","","","","","","","","","","","","","","","","","","has coordinates","156550","2020-10-21","18:00:00",""
"1531200","9.646","","8.824","","5.27","","90","","106.598","","90","","429.872","","","","","","","","","","","","","7","C 1 2/c 1","-C 2yc","15","","Na.32 Ca.59 Mg.60 Fe.25 Al.24 (Si2 O6)","","- Al0.24 Ca0.59 Fe0.25 Mg0.6 Na0.32 O6 Si2 -","- Al0.24 Ca0.59 Fe0.25 Mg0.6 Na0.32 O6 Si2 -","- Al0.96 Ca2.36 Fe Mg2.4 Na1.28 O24 Si8 -","4","0.5","","Clark, J.R.; Papike, J.J.; Appleman, D.E.","Crystal-chemical characterization of clinopyroxenes based on eight new structure refinements","Mineralogical Society of America: Special Papers","1969","2","","31","50","","","","","","","","","","","","","","","","","","","","","","has coordinates","156553","2020-10-21","18:00:00",""
"1532023","9.818","","18.047","","5.275","","90","","104.65","","90","","904.267","","","","","","","","","","","","","5","C 1 2/m 1","-C 2y","12","","Ca2 Mg5 (O H)2 (Si8 O22)","","- Ca2 H2 Mg5 O24 Si8 -","- Ca2 H2 Mg5 O24 Si8 -","- Ca4 H4 Mg10 O48 Si16 -","2","0.25","","Papike, J.J.; Ross, M.; Clark, J.R.","Crystal-chemical characterization of clinoamphiboles based on five new structure refinements","Mineralogical Society of America: Special Papers","1969","2","","117","136","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1532025","9.583","","18.091","","5.315","","90","","102.633","","90","","899.133","","","","","","","","","","","","","8","C 1 2/m 1","-C 2y","12","","Ca0.2 Mg4.2 Fe0.55 Mn2.05 Si8 O22 (O H) F","","- Ca0.2 F Fe0.55 H Mg4.2 Mn2.05 O23 Si8 -","- Ca0.2 F Fe0.55 Mg4.2 Mn2.05 O23 Si8 -","- Ca0.4 F2 Fe1.1 Mg8.4 Mn4.1 O46 Si16 -","2","0.25","","Papike, J.J.; Clark, J.R.; Ross, M.","Crystal-chemical characterization of clinoamphiboles based on five new structure refinements","Mineralogical Society of America: Special Papers","1969","2","","117","136","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1532027","10.019","","18.036","","5.286","","90","","104.983","","90","","922.72","","","","","","","","","","","","","10","C 1 2/m 1","-C 2y","12","","K (Na Ca) (Mg4.5 Fe0.3 Ti0.1 Ca0.1) (Si7.4 Al0.3 Ti0.3 O22) (O H)2","","- Al0.3 Ca1.1 Fe0.3 H2 K Mg4.5 Na O24 Si7.4 Ti0.4 -","- Al0.3 Ca1.1 Fe0.3 K Mg4.5 Na O24 Si7.4 Ti0.4 -","- Al0.6 Ca2.2 Fe0.6 K2 Mg9 Na2 O48 Si14.8 Ti0.8 -","2","0.25","","Papike, J.J.; Ross, M.; Clark, J.R.","Crystal-chemical characterization of clinoamphiboles based on five new structure refinements","Mineralogical Society of America: Special Papers","1969","2","","117","136","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1532029","9.55","","18.007","","5.298","","90","","102.65","","90","","888.965","","","","","","","","","","","","","7","P 1 21/m 1","-P 2yb","11","","(Na0.06 Ca0.38 Mg0.56 Mn) Mg5 (Si8 O22 (O H)2)","","- Ca0.38 H2 Mg5.56 Mn Na0.06 O24 Si8 -","- Ca0.38 Mg5.56 Mn Na0.06 O24 Si8 -","- Ca0.76 Mg11.12 Mn2 Na0.12 O48 Si16 -","2","0.5","","Papike, J.J.; Clark, J.R.; Ross, M.","Crystal-chemical characterization of clinoamphiboles based on five new structure refinements","Mineralogical Society of America: Special Papers","1969","2","","117","136","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"9000000","9.5642","","18.393","","5.3388","","90","","101.892","","90","","919.015","","","","","","","","","","","","Wabush iron formation, Labrador, Canada","6","C 1 2/m 1","-C 2y","12","","","Grunerite","- F0.5 Fe6.1 H1.5 Mg0.9 O23.5 Si8 -","- F0.5 Fe6.1 H1.5 Mg0.9 O23.5 Si8 -","- F Fe12.2 H3 Mg1.8 O47 Si16 -","2","0.25","","Finger, L. W.","The crystal structure and cation distribution of a grunerite","Mineralogical Society of America Special Paper","1969","2","","95","100","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:27",""