# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-26T20:29:30+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 'TMPM. Tschermaks Mineralogische und Petrographische Mitteilungen (1979-)') 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
"1001818","5.34","0.002","9.524","0.002","10.235","0.003","90","","100.07","0.02","90","","512.5","","","","","","","","","","","","from Franklin Furnace, New Jersey, USA","13","C 1 2/m 1","-C 2y","12","","Potassium sodium barium magnesium zinc manganese iron aluminium titanium chromium silicon oxide hydroxide *","Hendricksite 1M","- Al1.15 Ba0.04 Cr0.01 Fe0.25 H2 K0.89 Mg1.57 Mn0.4 Na0.1 O12 Si2.92 Ti0.07 Zn0.54 -","- Al1.1376 Ba0.04 Cr0.006 Fe0.252 H3 K0.89 Mg1.572 Mn0.4002 Na0.1 O12 Si2.92 Ti0.072 Zn0.54 -","- Al2.2752 Ba0.08 Cr0.012 Fe0.504 H6 K1.78 Mg3.144 Mn0.8004 Na0.2 O24 Si5.84 Ti0.144 Zn1.08 -","2","0.25","","Robert, J L; Gasperin, M","Crystal Structure Refinement of Hendricksite, a Zn- and Mn-rich Trioctahedral Potassium Mica: a Contribution to the Crystal Chemistry of Zinc-Bearing Minerals","TMPM. Tschermaks Mineralogische und Petrographische Mitteilungen (1979-)","1985","34","","1","14","10.1007/BF01082453","","","","","","0.072","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1541636","11.0149","","10.9409","","7.3534","","109.35","","109.879","","83.434","","786.298","","","","","","","","","","","","","9","P -1","-P 1","2","","(Na3.2 Ca0.8) Ca8 Zr2 (Zr0.67 Ti0.33 Ca0.33 Mn0.33 Fe0.33) (Si2 O7)4 O2.8 F5.2","","- Ca9.13 F5.2 Fe0.33 Mn0.33 Na3.2 O30.8 Si8 Ti0.33 Zr2.67 -","- Ca9.1332 F5.2 Fe0.3332 Mn0.3332 Na3.2 O30.8 Si8 Ti0.3332 Zr2.6666 -","- Ca9.1332 F5.2 Fe0.3332 Mn0.3332 Na3.2 O30.8 Si8 Ti0.3332 Zr2.6666 -","1","0.5","","Merlino, S.; Perchiazzi, N.","The crystal structure of hiortdahlite I","TMPM. Tschermaks Mineralogische und Petrographische Mitteilungen (1979-)","1985","34","","297","310","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1542239","5.34","","9.524","","10.235","","90","","100.07","","90","","512.514","","","","","","","","","","","","","2","C 1 2/m 1","-C 2y","12","","(K.89 Na.10 Ba.04) (Mg1.57 Zn.54 Mn.40 Fe.25 Al.07 Ti.07 Cr.01) (Si2.92 Al1.08) O10 (O H)2","","- K0.89 Na0.1 -","- K0.89 Na0.1 -","- K1.78 Na0.2 -","2","0.25","","Robert, J.L.; Gasperin, M.","Crystal Structure Refinement of Hendricksite, a Zn- and Mn-rich Trioctahedral Potassium Mica: a Contribution to the Crystal Chemistry of Zinc-Bearing Minerals","TMPM. Tschermaks Mineralogische und Petrographische Mitteilungen (1979-)","1985","34","","1","14","","","","","","","","","","","","","","","","","","","","","","has coordinates","174311","2020-10-21","18:00:00",""
"9009619","5.34","","9.254","","10.235","","90","","100.07","","90","","497.985","","","","","","","","","","","","Franklin Furnace, New Jersey, USA","13","C 1 2/m 1","-C 2y","12","","","Hendricksite","- Al1.138 Ba0.01 Cr0.006 Fe0.252 H0.41 K0.89 Mg1.572 Mn0.4 Na0.1 O12 Si2.92 Ti0.072 Zn0.54 -","- Al1.1376 Ba0.01 Cr0.006 Fe0.252 H2 K0.89 Mg1.572 Mn0.4002 Na0.1 O12 Si2.92 Ti0.072 Zn0.54 -","- Al2.2752 Ba0.02 Cr0.012 Fe0.504 H4 K1.78 Mg3.144 Mn0.8004 Na0.2 O24 Si5.84 Ti0.144 Zn1.08 -","2","0.25","","Robert J L; Gasperin M","Crystal structure refinement of hendricksite, a Zn- and Mn-rich trioctahedral potassium mica: a contribution to the crystal chemistry of zinc-bearing minerals Locality: Franklin Furnace, New Jersey, USA Note: polytype 1M","Tschermaks Mineralogische und Petrographische Mitteilungen","1985","34","","1","14","","","","","","","","","","","","","","","","","","","","","","has coordinates","283911","2023-05-21","08:37:45",""
"9009620","5.03","","16.135","","5.343","","90","","102.96","","90","","422.587","","","","","","","","","","","","Christmas mine, Pinal County, Arizona, USA","5","P 1 21/c 1","-P 2ybc","14","","","Stringhamite","- Ca Cu H2 O5 Si -","- Ca Cu H2 O5 Si -","- Ca4 Cu4 H8 O20 Si4 -","4","1","","Hawthorne, F. C.","The crystal structure of stringhamite","Tschermaks Mineralogische und Petrographische Mitteilungen","1985","34","","15","24","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9009621","18.93","","7.33","","11.35","","90","","112.44","","90","","1455.64","","","","","","","","","","","","Mammoth vein, Tiger, Arizona, USA","8","C 1 2/m 1","-C 2y","12","","","Mammothite","- Al Cl4 Cu4 H16 O26 Pb6 S2 Sb -","- Al Cl4 Cu4 H16 O26 Pb6 S2 Sb -","- Al2 Cl8 Cu8 H32 O52 Pb12 S4 Sb2 -","2","0.25","","Effenberger, H.","The crystal structure of mammothite, Pb6Cu4AlSbO2(OH)16Cl4(SO4)2","Tschermaks Mineralogische und Petrographische Mitteilungen","1985","34","","279","288","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:47",""
"9009622","4.505","","5.333","","6.405","","90","","106.24","","90","","147.741","","","","","","","","","","","","Susanna mine, Leadhills, Lanarkshire, Scotland","3","P 1 21/m 1","-P 2yb","11","","","Scotlandite","- O3 Pb S -","- O3 Pb S -","- O6 Pb2 S2 -","2","0.5","","Pertlik, F.; Zemann, J.","The crystal structure of scotlandite, PbSO3","Tschermaks Mineralogische und Petrographische Mitteilungen","1985","34","","289","295","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9009623","11.0149","","10.9409","","7.3534","","109.35","","109.879","","83.434","","786.298","","","","","","","","","","","","","10","P -1","-P 1","2","","","Hiortdahlite I","- Ca4.567 F2.6 Fe0.167 H0.4 Mn0.167 Na1.6 O15.4 Si4 Ti0.167 Zr1.333 -","- Ca4.56667 F2.6 Fe0.16667 Mn0.16667 Na1.6 O15.4 Si4 Ti0.16667 Zr1.33333 -","- Ca9.13334 F5.2 Fe0.33334 Mn0.33334 Na3.2 O30.8 Si8 Ti0.33334 Zr2.66666 -","2","1","","Merlino, S.; Perchiazzi, N.","The crystal structure of hiortdahlite I","Tschermaks Mineralogische und Petrographische Mitteilungen","1985","34","","297","310","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""