# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-30T18:34:12+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 'Tschermaks Mineralogische und Petrographische Mitteilungen') AND volume = 26 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
"1524665","5.092","","6.695","","5.304","","110.16","","112.09","","86.74","","156.729","","","","","","","","","","","","","4","P -1","-P 1","2","","Zn2 Cu (As O4)2","","- As2 Cu O8 Zn2 -","- As2 Cu O8 Zn2 -","- As2 Cu O8 Zn2 -","1","0.5","","Keller, P.; Hess, H.; Dunn, P.J.","Die Ladungsbilanz fuer eine verfeinerte Kristallstruktur von Stranskiit, Zn2 Cu (As O4)2","TMPM. Tschermaks Mineralogische und Petrographische Mitteilungen (1979-)","1979","26","","167","174","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1524921","12.513","","13.002","","8.373","","90","","90","","90","","1362.24","","","","","","","","","","","","","4","P n a m","-P 2c 2n","62","","(Pb6.56 (O H)1.12 (H2 O)2.88) ((U O2)8 O8 (O H)6)2","","- H18.88 O64 Pb6.56 U16 -","- O64 Pb6.56 U16 -","- O64 Pb6.56 U16 -","1","0.125","","Mereiter, K.","The crystal structure of curite, (Pb6.56 ((H2 O),(O H))4) ((U O2)8 O8 (O H)6)2","TMPM. Tschermaks Mineralogische und Petrographische Mitteilungen (1979-)","1979","26","","279","292","","","","","","","","","","","","","","","","","","","","","","has coordinates","176428","2020-10-21","18:00:00",""
"9009599","10.322","","10.322","","7.054","","90","","90","","120","","650.869","","","","","","","","","","","","Langban, Varmland, Sweden","4","P 63/m","-P 6c","176","","","Finnemanite","- As3 Cl O9 Pb5 -","- As3 Cl O9 Pb5 -","- As6 Cl2 O18 Pb10 -","2","0.166667","","Effenberger, H.; Pertlik, F.","Die kristallstruktur des finnemanits, Pb5Cl(AsO3)3, mit einem vergleich zum strukturtyp des chlorapatits, Ca5Cl(PO4)3","Tschermaks Mineralogische und Petrographische Mitteilungen","1979","26","","95","107","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9009600","10.823","","10.244","","7.29","","90","","109","","90","","764.214","","","","","","","","","","","","Brevig, Norway","7","P 1 21 1","P 2yb","4","","","Wohlerite","- Ca4 F Na2 Nb O17 Si4 Zr -","- Ca4 F Na2 Nb O17 Si4 Zr -","- Ca8 F2 Na4 Nb2 O34 Si8 Zr2 -","2","1","","Mellini, M.; Merlino, S.","Refinement of the crystal structure of wohlerite","Tschermaks Mineralogische und Petrographische Mitteilungen","1979","26","","109","123","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9009601","9.726","","8.907","","5.256","","90","","106.1","","90","","437.466","","","","","","","","","","","","manganese deposit of Praborna, St Marcel, Aosta Valley, Italy","6","C 1 2/c 1","-C 2yc","15","","","Diopside","- Ca0.94 Fe0.036 Mg0.964 Na0.06 O6 Si2 -","- Ca0.94 Fe0.036 Mg0.964 Na0.06 O6 Si2 -","- Ca3.76 Fe0.144 Mg3.856 Na0.24 O24 Si8 -","4","0.5","","Mottana, A.; Rossi, G.; Kracher, A.; Kurat, G.","Violan revisited: Mn-bearing Omphacite and Diopside","Tschermaks Mineralogische und Petrographische Mitteilungen","1979","26","","187","201","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9009602","9.578","","8.772","","5.253","","90","","106.89","","90","","422.31","","","","","","","","","","","","manganese deposit of Praborna, St Marcel, Aosta Valley, Italy","7","P 1 2/n 1","-P 2yac","13","","","Omphacite","- Al0.905 Ca0.952 Fe0.159 Mg0.936 Na1.048 O12 Si4 -","- Al0.905 Ca0.952 Fe0.159 Mg0.936 Na1.048 O12 Si4 -","- Al1.81 Ca1.904 Fe0.318 Mg1.872 Na2.096 O24 Si8 -","2","0.5","","Mottana, A.; Rossi, G.; Kracher, A.; Kurat, G.","Violan revisited: Mn-bearing omphacite and diopside","Tschermaks Mineralogische und Petrographische Mitteilungen","1979","26","","187","201","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9011954","8.496","","13.173","","17.214","","90","","96.65","","90","","1913.59","","","","","","","","","","","","North Carolina","5","P 1 21/c 1","-P 2ybc","14","","","Metaswitzerite","- Fe0.875 H8 Mn2 O12 P2 -","- Fe0.875 H8 Mn2 O12 P2 -","- Fe7 H64 Mn16 O96 P16 -","8","2","","Fanfani, L.; Zanazzi, P. F.","Switzerite: its chemical formula and crystal structure Note: could not reproduce Wat18 bond lengths Note: IMA official name of this phase changed from switzerite","Tschermaks Mineralogische und Petrographische Mitteilungen","1979","26","","255","269","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:49",""