# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-26T12:20:35+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 'The Canadian Mineralogist') AND volume = 21 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
"1538651","13.422","","13.422","","7.165","","90","","90","","120","","1117.84","","","","","","","","","","","","","6","P -3 m 1","-P 3 2""","164","","Fe3 Mn13 (Si12 O30 (O H)17) Cl3","","- Cl3 Fe3 H17 Mn13 O47 Si12 -","- Cl3 Fe3.04 Mn12.96 O47 Si12 -","- Cl3 Fe3.04 Mn12.96 O47 Si12 -","1","0.0833333","","Kato, T.; Takeuchi, Y.","The pyrosmalite group of minerals I: Structure refinemet of manganopyrosmalite","Canadian Mineralogist","1983","21","","1","6","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"9004166","13.391","","13.391","","7.139","","90","","90","","120","","1108.65","","","","","","","","","","","","","6","P -3 m 1","-P 3 2""","164","","","Pyrosmalite-(Mn)","- Cl1.65 Fe3.7 H6.12 Mn4.48 O23.35 Si5.82 -","- Cl1.65 Fe3.7 H8.35 Mn4.48 O23.35 Si5.82 -","- Cl3.3 Fe7.4 H16.7 Mn8.96 O46.7 Si11.64 -","2","0.166667","","Kato T; Takeuchi Y","The pyrosmalite group of minerals I. Structure refinement of Manganpyrosmalite Sample 1: Iron-rich manganpyrosmalite, Kyurazawa mine, Japan","The Canadian Mineralogist","1983","21","","1","6","","","","","","","","","","","","","","","","","","","","","","has coordinates","293656","2024-08-03","07:57:20",""
"9004167","13.422","","13.422","","7.165","","90","","90","","120","","1117.84","","","","","","","","","","","","","6","P -3 m 1","-P 3 2""","164","","","Pyrosmalite-(Mn)","- Cl1.47 Fe1.6 H8.5 Mn6 O23.53 Si6 -","- Cl1.47 Fe1.6 H8.53 Mn6 O23.53 Si6 -","- Cl2.94 Fe3.2 H17.06 Mn12 O47.06 Si12 -","2","0.166667","","Kato T; Takeuchi Y","The pyrosmalite group of minerals I. Structure refinement of Manganpyrosmalite Note: sample 2 Note: z-coordinate for AlM4 changed Locality: Kyurazawa mine, Japan","The Canadian Mineralogist","1983","21","","1","6","","","","","","","","","","","","","","","","","","","","","","has coordinates","293656","2024-08-03","07:57:20",""
"9004168","8.877","","8.877","","8.877","","90","","90","","90","","699.518","","","","","","","","","","","","Mont St-Hilaire, Quebec, Canada","6","P -4 3 n","P -4n 2 3","218","","","Sodalite","- Al3 Cl Fe0.04 Na3.76 O12 Si3 -","- Al3 Cl Fe0.04 Na3.76 O12 Si3 -","- Al6 Cl2 Fe0.08 Na7.52 O24 Si6 -","2","0.0833333","","Peterson, R. C.","The structure of hackmanite, a variety of sodalite, from Mont St-Hilaire, Quebec","The Canadian Mineralogist","1983","21","","549","552","","","","","","","","","","","","","","","","","","","","","","has coordinates","291351","2024-04-25","15:50:41",""
"9004169","15.942","","10.821","","7.241","","90","","101.86","","90","","1222.47","","","","","","","","","","","","","6","C 1 2/m 1","-C 2y","12","","","Jarlite","- Al6 F32 Mg Na1.99 O2 Sr6.01 -","- Al6 F32 Mg Na1.99 O2 Sr6.01 -","- Al12 F64 Mg2 Na3.98 O4 Sr12.02 -","2","0.25","","Hawthorne, F. C.","The crystal structure of jarlite","The Canadian Mineralogist","1983","21","","553","560","","","","","","","","","","","","","","","","","","","","","","has coordinates","291351","2024-04-25","15:50:41",""
"9004170","12.117","","10.414","","15.68","","90","","90.37","","90","","1978.56","","","","","","","","","","","","","6","F 1 2/d 1","","","","","Pachnolite","- Al Ca F6 H2 Na O -","- Al Ca F6 H2 Na O -","- Al16 Ca16 F96 H32 Na16 O16 -","16","","","Hawthorne, F. C.; Ferguson, R. B.","The crystal structure of pachnolite","The Canadian Mineralogist","1983","21","","561","566","","","","","","","","","","","","","","","","","","","","","","has coordinates","282053","2023-03-24","19:00:32",""