# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-28T03:01:55+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 'Tschermaks Mineralogische und Petrographische Mitteilungen') AND volume = 23 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
"9009586","5.2","","9.01","","10.09","","90","","99.38","","90","","466.416","","","","","","","","","","","","Elba, Tuscany, Italy","10","C 1 2/m 1","-C 2y","12","","","Lepidolite 1M","- Al2.07 Ca0.01 F1.53 H0.47 K0.88 Li1.57 Na0.06 O10.47 Rb0.05 Si3.36 -","- Al2.07 Ca0.01 F1.53 H0.47 K0.88 Li1.57 Na0.06 O10.47 Rb0.05 Si3.36 -","- Al4.14 Ca0.02 F3.06 H0.94 K1.76 Li3.14 Na0.12 O20.94 Rb0.1 Si6.72 -","2","0.25","","Sartori, F.","The crystal structure of a 1M lepidolite","Tschermaks Mineralogische und Petrographische Mitteilungen","1976","23","","65","75","10.1007/BF01081870","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:47",""
"9009587","16.036","","16.036","","16.036","","90","","90","","90","","4123.71","","","","","","","","","","","","","3","I a -3 d","-I 4bd 2c 3","230","","","Eglestonite","- Cl3 Hg6 O2 -","- Cl3 Hg6 O2 -","- Cl48 Hg96 O32 -","16","0.166667","","Mereiter, K.; Zemann, J.","Neubearbeitung des quecksilberminerals eglestonit: kristallstruktur, chemische zusammensetzung und synthese Note: Synthetic sample.","Tschermaks Mineralogische und Petrographische Mitteilungen","1976","23","","105","115","10.1007/BF01081478","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9011952","9.575","","9.575","","18.17","","90","","90","","120","","1442.66","","","","","","","","","","","","Sierra Gorda, Chile","8","P 3","P 3","143","","","Metavoltine","- Cu0.3 Fe6.6 H36 K2 Na6 O68 S12 Zn0.1 -","- Cu0.3 Fe6.6 H36 K2 Na6 O68 S12 Zn0.1 -","- Cu0.3 Fe6.6 H36 K2 Na6 O68 S12 Zn0.1 -","1","0.333333","","Giacovazzo, C.; Scordari, F.; Todisco, A.; Menchetti, S.","Crystal structure model for metavoltine from Sierra Gorda","Tschermaks Mineralogische und Petrographische Mitteilungen","1976","23","","155","166","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:49",""