# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-07T08:14:27+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 'Schweizerische Mineralogische und Petrographische Mitteilungen') AND volume = 80 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
"1525586","15.569","","15.569","","11.841","","90","","90","","90","","2870.19","","","","","","","","","","","","","7","P 4 n c","P 4 -2n","104","","Ca19 Al10.144 Mg Fe1.821 Si18 O69 (O H)9","","- Al10.144 Ca19 Fe1.821 H9 Mg O78 Si18 -","- Al10.144 Ca19 Fe1.821 H9 Mg O78 Si18 -","- Al20.288 Ca38 Fe3.642 H18 Mg2 O156 Si36 -","2","0.25","","Armbruster, T.; Gnos, E.","""Rod"" polytypism in vesuvianite: crystal structure of a low-temperature P4nc vesuvianite with pronounced octahderal cation ordering","Schweizerische Mineralogische und Petrographische Mitteilungen","2000","80","","109","116","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"9014105","7.48","","12.159","","6.678","","86.1","","93.92","","112.08","","560.91","","","","","","","","","","","","Arvigo, Val Calanca, Grisons, Switzerland","8","P -1","-P 1","2","","","Babingtonite","- Al0.03 Ca2 Fe1.366 H Mg0.344 Mn0.26 O15 Si5 -","- Al0.03 Ca2 Fe1.366 H Mg0.344 Mn0.26 O15 Si5 -","- Al0.06 Ca4 Fe2.732 H2 Mg0.688 Mn0.52 O30 Si10 -","2","1","","Armbruster, T.","Cation distribution in Mg, Mn-bearing babingtonite from Arvigo, Val Calanca, Grisons, Switzerland Note: Sample NMBE 34974","Schweizerische Mineralogische und Petrographische Mitteilungen","2000","80","","279","284","","","","","","","","","","","","","","","","","","","","","","has coordinates","283850","2023-05-18","07:16:48",""
"9015732","7.458","","12.168","","6.675","","86.12","","93.86","","112.27","","558.71","","","","","","","","","","","","Westfield, Massachusetts, USA","8","P -1","-P 1","2","","","Babingtonite","- Al0.05 Ca2 Fe1.703 H Mg0.187 Mn0.06 O15 Si5 -","- Al0.05 Ca2 Fe1.703 H Mg0.187 Mn0.06 O15 Si5 -","- Al0.1 Ca4 Fe3.406 H2 Mg0.374 Mn0.12 O30 Si10 -","2","1","","Armbruster, T.","Cation distribution in Mg, Mn-bearing babingtonite from Arvigo, Val Calanca, Grisons, Switzerland","Schweizerische Mineralogische und Petrographische Mitteilungen","2000","80","","279","284","","","","","","","","","","","","","","","","","","","","","","has coordinates","292100","2024-05-29","14:19:53",""
"9015884","7.469","","12.161","","6.675","","86.09","","93.94","","112.21","","559.398","","","","","","","","","","","","Arvigo, Val Calanca, Grisons, Switzerland","8","P -1","-P 1","2","","","Babingtonite","- Al0.08 Ca2 Fe1.513 H Mg0.197 Mn0.21 O15 Si5 -","- Al0.08 Ca2 Fe1.513 H Mg0.197 Mn0.21 O15 Si5 -","- Al0.16 Ca4 Fe3.026 H2 Mg0.394 Mn0.42 O30 Si10 -","2","1","","Armbruster, T.","Cation distribution in Mg, Mn-bearing babingtonite from Arvigo, Val Calanca, Grisons, Switzerland Note: Sample Arvigo 1, NMBE 34973","Schweizerische Mineralogische und Petrographische Mitteilungen","2000","80","","279","284","","","","","","","","","","","","","","","","","","","","","","has coordinates","292100","2024-05-29","14:19:54",""