# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-24T19:21:43+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 'Clays and Clay Minerals') AND volume = 34 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
"9014159","5.316","","9.221","","10.282","","90","","99.9","","90","","496.507","","","","","","","","","","","","Langban, Sweden","12","C 1 2/m 1","-C 2y","12","","","Phlogopite","- Al1.32 Ba0.02 F0.1 Fe0.18 H1.9 K0.84 Mg2.52 Mn0.12 Na0.07 O11.9 Si2.8 Ti0.03 -","- Al1.32 Ba0.02 F0.1 Fe0.18 H1.9 K0.84 Mg2.52 Mn0.12 Na0.07 O11.9 Si2.8 Ti0.03 -","- Al2.64 Ba0.04 F0.2 Fe0.36 H3.8 K1.68 Mg5.04 Mn0.24 Na0.14 O23.8 Si5.6 Ti0.06 -","2","0.25","","Knurr, R. A.; Bailey, S. W.","Refinement of Mn-substituted muscovite and phlogopite Sample: manganophyllite, type 1M","Clays and Clay Minerals","1986","34","","7","16","10.1346/CCMN.1986.0340102","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:17",""
"9016477","5.2044","","9.018","","20.073","","90","","95.82","","90","","937.236","","","","","","","","","","","","Minas Gerais, Brazil","11","C 1 2/c 1","-C 2yc","15","","","Muscovite","- Al2.68 Ba0.01 Fe0.14 H2 K0.93 Mg0.1 Mn0.02 Na0.05 O12 Si3.04 Ti0.02 -","- Al2.68 Ba0.01 Fe0.14 H2 K0.93 Mg0.1 Mn0.02 Na0.05 O12 Si3.04 Ti0.02 -","- Al10.72 Ba0.04 Fe0.56 H8 K3.72 Mg0.4 Mn0.08 Na0.2 O48 Si12.16 Ti0.08 -","4","0.5","","Knurr, R. A.; Bailey, S. W.","Refinement of Mn-substituted muscovite and phlogopite Sample: alurgite, type 2M1","Clays and Clay Minerals","1986","34","","7","16","10.1346/CCMN.1986.0340102","","","","","","","","","","","","","","","","","","","","","has coordinates","292100","2024-05-29","14:19:54",""