# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2025-03-08T07:17:25+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 = 28 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
"1524918","10.83","","9.98","","7.174","","90","","108.1","","90","","737.021","","","","","","","","","","","","","7","P 1 21/a 1","-P 2yab","14","","Zr Fe Na1.5 Ca0.5 (Si2 O7) O F","","- Ca0.5 F Fe Na1.5 O8 Si2 Zr -","- Ca0.5 F Fe Na1.5 O8 Si2 Zr -","- Ca2 F4 Fe4 Na6 O32 Si8 Zr4 -","4","1","","Mellini, M.","Refinement of the crystal structure of Lavenite","TMPM. Tschermaks Mineralogische und Petrographische Mitteilungen (1979-)","1981","28","","99","112","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"9009604","11.1983","","11.1983","","6.5637","","90","","90","","90","","823.101","","","","","","","","","","","","","7","P 4/n m m :2","-P 4a 2a","129","","","Tunisite","- C4 H8 Al4 Ca2 Cl Na O20 -","- C4 H8 Al4 Ca2 Cl Na O20 -","- C8 H16 Al8 Ca4 Cl2 Na2 O40 -","2","0.125","","Effenberger, H.; Kluger, F.; Pertlik, F.; Zemann, J.","Tunisit: kristallstruktur und revision der chemischen formel","Tschermaks Mineralogische und Petrographische Mitteilungen","1981","28","","65","77","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9011956","24.17699","","24.17699","","7.656","","90","","90","","120","","3875.58","","","","","","","","","","","","","4","R -3 :H","-R 3","148","","","Fibroferrite","- Fe H11 O10 S -","- Fe O10 S -","- Fe18 O180 S18 -","18","1","","Scordari, F.","Fibroferrite: A mineral with a {Fe(OH)(H2O)2SO4} spiral chain and its relationship to Fe(OH)SO4, butlerite and parabutlerite Locality: Saint Felix de Pailleres, France","Tschermaks Mineralogische und Petrographische Mitteilungen","1981","28","","17","29","","","","","","","","","","","","","","","","","","","","","","has coordinates","200438","2020-10-21","18:00:00",""
"9011957","10.83","","9.98","","7.174","","90","","108.1","","90","","737.021","","","","","","","","","","","","Langesund, Norway","11","P 1 21/a 1","-P 2yab","14","","","Lavenite","- Ca0.74 F Fe0.22 Mg0.01 Mn0.32 Na1.5 Nb0.14 O8 Si2 Ti0.16 Zr0.91 -","- Ca0.74 F Fe0.22 Mg0.01 Mn0.32 Na1.5 Nb0.14 O8 Si2 Ti0.16 Zr0.91 -","- Ca2.96 F4 Fe0.88 Mg0.04 Mn1.28 Na6 Nb0.56 O32 Si8 Ti0.64 Zr3.64 -","4","1","","Mellini, M.","Refinement of the crystal structure of lavenite","Tschermaks Mineralogische und Petrographische Mitteilungen","1981","28","","99","112","","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:45",""