# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-17T13:36:46+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 'Minerals') AND volume = 9 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
"9017764","9.7583","","9.7583","","53.687","","90","","90","","120","","4427.39","","","","","","","","","","","","Monte Arsiccio mine, Apuan Alps, Italy","6","R -3 :H","-R 3","148","","","Scordariite","- Fe6.66 H34 K7.5 Na0.5 O67 S12 -","- Fe6.66 H34 K7.5002 Na0.5 O67 S12 -","- Fe19.98 H102 K22.5006 Na1.5 O201 S36 -","3","0.166667","","Biagioni, C.; Bindi, L.; Mauro, D.; Halenius; U","Crystal chemistry of sulfates from the Apuan Alps (Tuscany, Italy). V. Scordariite, K8(Fe3+0.67[]0.33)[Fe3+3O(SO4)6(H2O)3]2(H2O)11: A new metavoltine-related mineral","Minerals","2019","9","","","702","","","","","","","","","","","","","","","","","","","","","","has coordinates","285095","2023-07-08","07:48:16",""
"9017765","7.5491","","16.8652","","12.1574","","90","","94.064","","90","","1543.95","","","","","","","","","","","","Monte Arsiccio mine, Apuan Alps, Italy","6","C 1 2/c 1","-C 2yc","15","","","Magnanelliite","- Al0.156 Fe1.844 H5 K3 O19 S4 -","- Al0.156 Fe1.844 H5 K3 O19 S4 -","- Al0.624 Fe7.376 H20 K12 O76 S16 -","4","0.5","","Biagioni, C.; Bindi, L.; Kampf, A. R.","Crystal-chemistry of sulfates from the Apuan Alps (Tuscany, Italy). VII. Magnanelliite, K3Fe3+2(SO4)4 (OH)(H2O)2, a new sulfate from the Monte Arsiccio mine","Minerals","2019","9","","","779","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:53",""