# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-21T12:59:35+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 = 30 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
"9009607","8.903","","9.499","","6.812","","109.87","","112.01","","100.4","","469.944","","","","","","","","","","","","Joachimsthal, Czech Republic","5","P -1","-P 1","2","","","Johannite","- Cu H18 O22 S2 U2 -","- Cu H18 O22 S2 U2 -","- Cu H18 O22 S2 U2 -","1","0.5","","Mereiter, K.","Die kristallstruktur des johannits, Cu(UO2)2(OH)2(SO4)2*8H2O","Tschermaks Mineralogische und Petrographische Mitteilungen","1982","30","","47","57","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:47",""
"9009608","20.168","","9.847","","19.719","","90","","110.71","","90","","3663.03","","","","","","","","","","","","","5","C 1 2/c 1","-C 2yc","15","","","Threadgoldite","- Al H17 O21 P2 U2 -","- Al H17 O21 P2 U2 -","- Al8 H136 O168 P16 U16 -","8","1","","Khosrawan-Sazedj F","On the space group of threadgoldite","Tschermaks Mineralogische und Petrographische Mitteilungen","1982","30","","111","115","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:47",""
"9009609","7.135","","10.426","","5.494","","101.47","","110.82","","88.2","","374.036","","","","","","","","","","","","Schneeberg, Germany","5","P -1","-P 1","2","","","Walpurgite","- As2 Bi4 H4 O16 U -","- As2 Bi4 H4 O16 U -","- As2 Bi4 H4 O16 U -","1","0.5","","Mereiter, K.","The crystal structure of walpurgite,(UO2)Bi4O4(AsO4)2*2H2O","Tschermaks Mineralogische und Petrographische Mitteilungen","1982","30","","129","139","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:47",""
"9009610","15.127","","15.127","","22.471","","90","","90","","120","","4453.06","","","","","","","","","","","","""Grube Anton"" Heubachtal, Schiltach, Black Forest, Germany","5","R 3 c :H","R 3 -2""c","161","","","Machatschkiite","- As4 Ca6 H33 O35 P -","- As4 Ca6 H33 O35 P -","- As24 Ca36 H198 O210 P6 -","6","0.333333","","Effenberger, H.; Mereiter, K.; Pimminger, M.; Zemann, J.","Machatschkiite: Crystal structure and revision of the chemical formula","Tschermaks Mineralogische und Petrographische Mitteilungen","1982","30","","145","155","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:47",""
"9009611","4.871","","15.098","","5.433","","90","","98.86","","90","","394.788","","","","","","","","","","","","Moschellandsberg, Palatinate, Germany","4","I 1 m 1","I -2y","8","","","Shakhovite","- H3 Hg4 O6 Sb -","- H3 Hg4 O6 Sb -","- H6 Hg8 O12 Sb2 -","2","0.5","","Tillmanns, E.; Krupp, R.; Abraham, K.","New data on the mercury antimony mineral shakhovite: Chemical composition, unit cell and crystal structure","Tschermaks Mineralogische und Petrographische Mitteilungen","1982","30","","227","235","","","","","","","","","","","","","","","","","","","","","","has coordinates","293658","2024-08-03","10:24:26",""
"9009612","10.863","","10.431","","7.37","","90","","110.1","","90","","784.246","","","","","","","","","","","","Oka, Quebec, Canada","5","P 1 a 1","P -2ya","7","","","Niocalite","- Ca7 F Nb O17 Si4 -","- Ca7 F Nb O17 Si4 -","- Ca14 F2 Nb2 O34 Si8 -","2","1","","Mellini, M.","Niocalite revised: Twinning and crystal structure Note: cuspidine structure","Tschermaks Mineralogische und Petrographische Mitteilungen","1982","30","","249","266","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9009613","16.699","","17.557","","13.697","","90","","90","","90","","4015.75","","","","","","","","","","","","","5","B b a 2","B 2 -2ab","41","","","Liebigite","- C3 H22 Ca2 O22 U -","- C3 H22 Ca2 O22 U -","- C24 H176 Ca16 O176 U8 -","8","","","Mereiter, K.","The crystal structure of liebigite, Ca2UO2(CO3)3*~11H2O Locality: Joachimsthal, Bohmen","Tschermaks Mineralogische und Petrographische Mitteilungen","1982","30","","277","288","","","","","","","","","","","","","","","","","","","","","","has coordinates","294031","2024-08-07","17:26:34",""