# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-17T11:46:29+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 'Physics and Chemistry of Minerals') AND volume = 47 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
"9017284","9.448","","18.3183","","17.9825","","90","","92.274","","90","","3109.8","","","","100","","","","","","","","the Monte Arsiccio mine, Apuan Alps, Tuscany, Italy","5","P 1 21/c 1","-P 2ybc","14","","","Giacovazzoite","- Fe3 H17 K5 O35 S6 -","- Fe3 H17 K5 O35 S6 -","- Fe12 H68 K20 O140 S24 -","4","1","","Biagioni, C.; Bindi, L.; Mauro, D.; Pasero, M.","Crystal-chemistry of sulfates from the Apuan Alps (Tuscany, Italy). IV. Giacovazzoite, K5Fe3+3O(SO4)6(H2O)9*H2O, the natural analogue of the ß-Maus's salt and its dehydration product Note: T = 100 K","Physics and Chemistry of Minerals","2020","47","","","7","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:53",""
"9017285","9.3434","","18.1838","","17.7702","","90","","96.381","","90","","3000.43","","","","","","","","","","","","the Monte Arsiccio mine, Apuan Alps, Tuscany, Italy","5","P 1 21/c 1","-P 2ybc","14","","","Giacovazzoite","- Fe3 H8 K5 O31.52 S6 -","- Fe3 H8 K5 O31.52 S6 -","- Fe12 H32 K20 O126.08 S24 -","4","1","","Biagioni, C.; Bindi, L.; Mauro, D.; Pasero, M.","Crystal-chemistry of sulfates from the Apuan Alps (Tuscany, Italy). IV. Giacovazzoite, K5Fe3+3O(SO4)6(H2O)9*H2O, the natural analogue of the beta-Maus's salt and its dehydration product Note: this is the dehydration product","Physics and Chemistry of Minerals","2020","47","","","7","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:53",""
"9017286","10.637","","22.797","","5.4136","","90","","90","","90","","1312.75","","","","","","","","","","","","Blue Bell mine, California, USA","3","P n m a","-P 2ac 2n","62","","","Pingguite","- Bi6 O15 Te2 -","- Bi24 O60 Te8 -","- Bi24 O60 Te8 -","","","","Nenert, G.; Missen, O. P.; Lian, H.; Weil, M.; Blake, G. R.; Kampf, A. R.; Mills, S. J.","Crystal structure and thermal behavior of Bi6Te2O15: investigation of synthetic and natural pingguite","Physics and Chemistry of Minerals","2020","47","","","53","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","07:57:52",""
"9017287","10.61155","","22.74458","","5.399038","","90","","90","","90","","1303.09","","","","","","","","","","","","Synthetic","3","P n m a","-P 2ac 2n","62","","","Pingguite","- Bi5 O16 Te -","- Bi24 O60 Te8 -","- Bi24 O60 Te8 -","","","","Nenert, G.; Missen, O. P.; Lian, H.; Weil, M.; Blake, G. R.; Kampf, A. R.; Mills, S. J.","Crystal structure and thermal behavior of Bi6Te2O15: investigation of synthetic and natural pingguite","Physics and Chemistry of Minerals","2020","47","","","53","","","","","","","","","","","","","","","","","","","","","","has coordinates","287967","2023-12-04","09:19:23",""