# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2025-01-02T14:06:44+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 'European Journal of Mineralogy') AND volume = 36 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
"1571002","5.9131","0.0005","7.8478","0.0006","16.8158","0.0015","90","","90.007","0.006","90","","780.33","0.11","293","","293","","","","","","","","'from Grosses Chalttal, Glarus, Switzerland'","5","P 1 21/n 1","-P 2yn","14","","","","- As Cu2 H7 O9 Pb -","- As Cu2 H7 O9 Pb -","- As4 Cu8 H28 O36 Pb4 -","4","1","","Malcherek, Thomas; Mihailova, Boriana; Schlüter, Jochen; Roth, Philippe; Meisser, Nicolas","Heimite, PbCu2(AsO4)(OH)3 ⋅ 2H2O, a new mineral from the Grosses Chalttal deposit, Switzerland","European Journal of Mineralogy","2024","36","1","153","164","10.5194/ejm-36-153-2024","","x-ray","0.71069","MoKα","","0.0359","0.0275","","","0.0736","0.0784","","","","1.16","1.16","1.11","","","","has coordinates","295836","2024-11-08","15:59:21",""
"1572359","5.9131","0.0005","7.8478","0.0006","16.8158","0.0015","90","","90.007","0.006","90","","780.33","0.11","293","","293","","","","","","","","'from Grosses Chalttal, Glarus, Switzerland'","5","P 1 21/n 1","-P 2yn","14","Heimite","","","- As Cu2 H7 O9 Pb -","- As Cu2 H7 O9 Pb -","- As4 Cu8 H28 O36 Pb4 -","4","1","","Malcherek, Thomas; Mihailova, Boriana; Schlüter, Jochen; Roth, Philippe; Meisser, Nicolas","Heimite, PbCu2(AsO4)(OH)3 ⋅ 2H2O, a new mineral from the Grosses Chalttal deposit, Switzerland","European Journal of Mineralogy","2024","36","1","153","164","10.5194/ejm-36-153-2024","","x-ray","0.71069","MoKα","","0.0359","0.0275","","","0.0736","0.0784","","","","1.16","1.16","1.11","","","","has coordinates","295836","2024-11-08","15:59:30",""