# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-21T18:11:31+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 = 21 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
"9009571","8.8","","13.019","","5.852","","90","","90","","90","","670.447","","","","","","","","","","","","","5","P b n m","-P 2c 2ab","62","","","Ilvaite","- Ca Fe3 H O9 Si2 -","- Ca Fe3 H O9 Si2 -","- Ca4 Fe12 H4 O36 Si8 -","4","0.5","","Beran, A.; Bittner, H.","Untersuchungen zur kristallchemie des ilvaits","Tschermaks Mineralogische und Petrographische Mitteilungen","1974","21","","11","29","","","","","","","","","","","","","","","","","","","","","","has coordinates","293658","2024-08-03","10:24:26",""
"9009572","8.827","","8.827","","3.085","","90","","90","","120","","208.167","","","","","","","","","","","","Nocera, Italy","4","P 63/m","-P 6c","176","","","Fluoborite","- B F3 Mg3 O3 -","- B F3 Mg3 O3 -","- B2 F6 Mg6 O6 -","2","0.166667","","Dal Negro, A.; Tadini, C.","Refinement of the crystal structure of fluoborite, Mg3(F,OH)3(BO3)","Tschermaks Mineralogische und Petrographische Mitteilungen","1974","21","","94","100","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9009573","8.16","","8.16","","8.883","","90","","90","","90","","591.48","","","","","","","","","","","","Monteponi Mine, Iglesias, Iglesiente district, Cagliari Province, Sardinia, Italy","4","P 4/m b m","-P 4 2ab","127","","","Phosgenite","- C Cl2 O3 Pb2 -","- C Cl2 O3 Pb2 -","- C4 Cl8 O12 Pb8 -","4","0.25","","Giuseppetti, G.; Tadini, C.","Reexamination of the crystal structure of phosgenite, Pb2Cl2(CO3) Locality: Monteponi Mine, Iglesias, Iglesiente district, Cagliari Province, Sardinia, Italy","Tschermaks Mineralogische und Petrographische Mitteilungen","1974","21","","101","109","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9009574","7.425","","26.975","","6.0608","","90.03","","97.66","","91.94","","1202.38","","","","","","","","","","","","","4","P -1","-P 1","2","","","Alunogen","- Al2 H34 O28.4 S3 -","- Al2 H32 O28.4 S3 -","- Al4 H64 O56.8 S6 -","2","1","","Menchetti, S.; Sabelli, C.","Alunogen. Its structure and twinning Locality: grotta dell'allume, Vulcano Island, Italy","Tschermaks Mineralogische und Petrographische Mitteilungen","1974","21","","164","178","","","","","","","","","","","","","","","","","","","","","","has coordinates","200438","2020-10-21","18:00:00",""
"9009575","12.1164","","12.1164","","7.581","","90","","90","","90","","1112.94","","","","","","","","","","","","Tsarasaotra, Madagascar","9","P 42/n :1","P 4n -1n","86","","","Meionite","- C0.435 Al4.344 Ca2.088 Cl0.365 K0.232 Na1.656 O25.312 S0.185 Si7.5 -","- C0.435 Al4.344 Ca2.088 Cl0.365 K0.232 Na1.656 O25.312 S0.185 Si7.5 -","- C0.87 Al8.688 Ca4.176 Cl0.73 K0.464 Na3.312 O50.624 S0.37 Si15 -","2","0.25","","Lin, S. B.; Burley, B. J.","The crystal structure of an intermediate scapolite - wernerite","Tschermaks Mineralogische und Petrographische Mitteilungen","1974","21","","196","215","10.1007/BF01081031","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9009576","9.724","","18.333","","5.421","","90","","90","","90","","966.402","","","","","","","","","","","","Synthetic","4","P n m a","-P 2ac 2n","62","","","Rhomboclase","- Fe H9 O12 S2 -","- Fe H7.62 O12 S2 -","- Fe4 H30.48 O48 S8 -","4","0.5","","Mereiter, K.","Die kristallstruktur von rhomboklas, H5O2+{Fe[SO4]2*2H2O}- Note: synthetic crystal","Tschermaks Mineralogische und Petrographische Mitteilungen","1974","21","","216","232","","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:24:51",""
"9009577","12.779","","13.596","","10.208","","90","","108.88","","90","","1678.15","","","","","","","","","","","","","4","P 1 21/a 1","-P 2yab","14","","","Sarkinite","- As H Mn2 O5 -","- As H Mn2 O5 -","- As16 H16 Mn32 O80 -","16","4","","Dal Negro, A.; Giuseppetti, G.; Pozas, J. M. M.","The crystal structure of sarkinite, Mn2AsO4(OH)","Tschermaks Mineralogische und Petrographische Mitteilungen","1974","21","","246","260","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:47",""
"9017832","7.425","","26.975","","6.0608","","90.03","","97.66","","91.94","","1202.38","","","","","","","","","","","","grotta dell'allume, Vulcano Island, Italy","4","P -1","-P 1","2","","","Alunogen","- Al2 H32.8 O28.4 S3 -","- Al2 H32.8 O28.4 S3 -","- Al4 H65.6 O56.8 S6 -","2","1","","Menchetti, S.; Sabelli, C.","Alunogen. Its structure and twinning","Tschermaks Mineralogische und Petrographische Mitteilungen","1974","21","","164","178","","","","","","","","","","","","","","","","","","","","","","has coordinates","283962","2023-05-23","09:03:56",""