# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-26T14:57:31+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 'Mineralogical Magazine') AND volume = 39 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
"9009447","9.8179","","18.106","","5.3314","","90","","105","","90","","915.432","","","","","","","","","","","","Frood Mine, Sudbury, Ontario, Canada","11","C 1 2/m 1","-C 2y","12","","","Ferrotschermakite","- Al3.3 Ca1.86 Fe2.4 H1.98 K0.14 Mg1.22 Mn0.02 Na0.23 O24 Si6 Ti0.1 -","- Al3.3 Ca1.86 Fe2.4 H1.98 K0.14 Mg1.22 Mn0.02 Na0.23 O24 Si6 Ti0.1 -","- Al6.6 Ca3.72 Fe4.8 H3.96 K0.28 Mg2.44 Mn0.04 Na0.46 O48 Si12 Ti0.2 -","2","0.25","","Hawthorne, F. C.; Grundy, H. D.","The crystal chemistry of the amphiboles. I: Refinement of the crystal structure of ferrotschermakite Locality: Frood Mine, Sudbury, Ontario, Canada","Mineralogical Magazine","1973","39","","36","48","10.1180/minmag.1973.039.301.05","","","","","","","","","","","","","","","","","","","","","has coordinates","294032","2024-08-07","19:11:21",""
"9009448","3.92","","3.92","","15.31","","90","","90","","90","","235.26","","","","","","","","","","","","Langban, Sweden","4","P 4 m m","P 4 -2","99","","","Hematophanite","- Cl Fe3 O8 Pb4 -","- Cl Fe3 O8 Pb4 -","- Cl Fe3 O8 Pb4 -","1","0.125","","Rouse, R. C.","Hematophanite, a derivative of the perovskite structure","Mineralogical Magazine","1973","39","","49","53","10.1180/minmag.1973.039.301.06","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9009449","2.855","","2.855","","8.805","","90","","90","","120","","62.154","","","","","","","","","","","","Mindigi, Shaba, Zaire","3","P 63/m m c","-P 6c 2c","194","","","Heterogenite","- Co H O2 -","- Co H O2 -","- Co2 H2 O4 -","2","0.0833333","","Deliens, M.; Goethals, H.","Polytypism of heterogenite Note: polytype known as Heterogenite-2H","Mineralogical Magazine","1973","39","","152","157","10.1180/minmag.1973.039.302.03","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9009450","15.75","","15.75","","9.161","","90","","90","","120","","1968.04","","","","","","","","","","","","Likasi, Congo","5","P 63/m m c","-P 6c 2c","194","","","Buttgenbachite","- Cl3.35 Cu18.3 H33 N1.3 O36.9 -","- Cl3.35 Cu18.3 H33 N1.3 O36.9 -","- Cl6.7 Cu36.6 H66 N2.6 O73.8 -","2","0.0833333","","Fanfani, L.; Nunzi, A.; Zanazzi, P. F.; Zanzari, A. R.","The crystal structure of buttgenbachite","Mineralogical Magazine","1973","39","","264","270","10.1180/minmag.1973.039.303.02","","","","","","","","","","","","","","","","","","","","","has coordinates","283850","2023-05-18","07:16:47",""
"9009451","8.922","","6.081","","19.432","","90","","97.6","","90","","1045.02","","","","","","","","","","","","Langban, Sweden","5","A 1 2/m 1","-A 2y","12","","","Julgoldite-(Fe3+)","- Ca2 Fe3 H2 O14 Si3 -","- Ca2 Fe3 H2 O14 Si3 -","- Ca8 Fe12 H8 O56 Si12 -","4","0.5","","Allmann, R.; Donnay, G.","The crystal structure of julgoldite","Mineralogical Magazine","1973","39","","271","281","10.1180/minmag.1973.039.303.03","","","","","","","","","","","","","","","","","","","","","has coordinates","288571","2023-12-31","01:07:00",""
"9009452","9.892","","18.064","","5.3116","","90","","105.388","","90","","915.1","","","","","","","","","","","","Kangerdluarsuq, Southern Greenland","10","C 1 2/m 1","-C 2y","12","","","Oxy-kaersutite","- Al2.49 Ca1.92 Fe1.053 K0.44 Mg3.133 Mn0.01 Na0.54 O24 Si5.88 Ti0.514 -","- Al2.49 Ca1.92 Fe1.053 K0.44 Mg3.133 Mn0.01 Na0.54 O24 Si5.88 Ti0.514 -","- Al4.98 Ca3.84 Fe2.106 K0.88 Mg6.266 Mn0.02 Na1.08 O48 Si11.76 Ti1.028 -","2","0.25","","Hawthorne, F. C.; Grundy, H. D.","The crystal chemistry of the amphiboles II. Refinement of the crystal structure of oxy-kaersutite Locality: Kangerdluarsuq, Southern Greenland","Mineralogical Magazine","1973","39","","390","400","10.1180/minmag.1973.039.304.02","","","","","","","","","","","","","","","","","","","","","has coordinates","283960","2023-05-23","08:42:08",""