# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-29T13:09:41+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 = 25 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
"9009594","5.755","","5.755","","25.12","","90","","90","","120","","720.512","","","","","","","","","","","","Campomorto, Montalto di Castro","5","P 63/m","-P 6c","176","","","Vertumnite","- Al2.126 Ca2 H22 O15.72 Si1.434 -","- Al2.126 Ca2 H13.42 O15.72 Si1.434 -","- Al4.252 Ca4 H26.84 O31.44 Si2.868 -","2","0.166667","","Galli, E.; Passaglia, E.","Vertumnite: its crystal structure and relationship with natural and synthetic phases Locality: Campomorto, Montalto di Castro","Tschermaks Mineralogische und Petrographische Mitteilungen","1978","25","","33","46","","","","","","","","","","","","","","","","","","","","","","has coordinates","283866","2023-05-18","12:54:10",""
"9009595","7.06","","10","","7.303","","90","","90","","90","","515.592","","","","","","","","","","","","Ivigtut, Greenland","4","I m m a","-I 2b 2","74","","","Weberite","- Al F7 Mg Na2 -","- Al F7 Mg Na2 -","- Al4 F28 Mg4 Na8 -","4","0.25","","Giuseppetti, G.; Tadini, C.","Re-examination of the crystal structure of weberite","Tschermaks Mineralogische und Petrographische Mitteilungen","1978","25","","57","62","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9009596","10.228","","9.837","","7.284","","90.17","","98.44","","117.44","","641.284","","","","","","","","","","","","Big Chief mine, Glendale, South Dakota","5","P -1","-P 1","2","","","Strunzite","- Fe2 H14 Mn O16 P2 -","- Fe2 H14 Mn O16 P2 -","- Fe4 H28 Mn2 O32 P4 -","2","1","","Fanfani, L.; Tomassini, M.; Zanazzi, P. F.; Zanzari, A. R.","The crystal structure of strunzite, a contribution to the crystal chemistry of basic ferric-manganous hydrated phosphates","Tschermaks Mineralogische und Petrographische Mitteilungen","1978","25","","77","87","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:47",""
"9009597","7.26","","6.78","","11.09","","90","","91.5","","90","","545.694","","","","","","","","","","","","Langban, Varmland, Sweden","5","P 1 n 1","P -2yac","7","","","Trigonite","- As3 H Mn O9 Pb3 -","- As3 H Mn O9 Pb3 -","- As6 H2 Mn2 O18 Pb6 -","2","1","","Pertlik, F.","The crystal structure of trigonite, Pb3Mn(AsO3)2(AsO2(OH))","Tschermaks Mineralogische und Petrographische Mitteilungen","1978","25","","95","105","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:47",""
"9009598","7.763","","6.046","","9.022","","90","","112.5","","90","","391.215","","","","","","","","","","","","Tsumeb, Namibia","6","P 1 21/m 1","-P 2yb","11","","","Arsenbrackebuschite","- As2 Fe0.65 H2.65 O9 Pb2 Zn0.35 -","- As2 Fe0.65 H1.35 O9 Pb2 Zn0.35 -","- As4 Fe1.3 H2.7 O18 Pb4 Zn0.7 -","2","0.5","","Hofmeister, W.; Tillmanns, E.","Strukturelle untersuchungen an arsenbrackebuschit","Tschermaks Mineralogische und Petrographische Mitteilungen","1978","25","","153","163","","","","","","","","","","","","","","","","","","","","","","has coordinates","283866","2023-05-18","12:54:10",""