# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-10-04T06:30:28+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 'Mineralogy and Petrology') AND volume = 37 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
"1514115","5.765","0.001","5.765","0.001","9.442","0.002","90","","90","","90","","313.81","0.1","","","","","","","","","","","","2","I 41/a m d :2","-I 4bd 2","141","","Dimanganese(III) Manganese Oxide","Hausmannite","- Mn3 O4 -","- Mn3 O4 -","- Mn12 O16 -","4","0.125","","Jarosch, D.","Crystal structure refinement and reflectance measurements of hausmannite, Mn3 O4","Mineralogy and Petrology","1987","37","","15","23","10.1007/BF01163155","","","","","","0.036","","","","","","","","","","","","","","","has coordinates","176808","2020-10-21","18:00:00",""
"9009825","7.313","","7.313","","19.315","","90","","90","","90","","1032.97","","","","","","","","","","","","Bosa, Sardinia, Italy","5","P 41 21 2","P 4abw 2nw","92","","","Cyrilovite","- Fe3 H8 Na O14 P2 -","- Fe3 H8 Na O14 P2 -","- Fe12 H32 Na4 O56 P8 -","4","0.5","","Cozzupoli, D.; Grubessi, O.; Mottana, A.; Zanazzi, P. F.","Cyrilovite from Italy: structure and crystal chemistry","Mineralogy and Petrology","1987","37","","1","14","10.1007/BF01163154","","","","","","","","","","","","","","","","","","","","","has coordinates","293658","2024-08-03","10:24:27",""
"9009826","11.012","","10.342","","7.359","","89.92","","109.21","","90.06","","791.421","","","","","","","","","","","","Kipawa River, Canada","7","P -1","-P 1","2","","","Hiortdahlite I","- Ca4.74 F2.5 Na1.38 O15.5 Si4 Y0.88 Zr -","- Ca4.74 F2.5 Na1.38 O15.5 Si4 Y0.88 Zr -","- Ca9.48 F5 Na2.76 O31 Si8 Y1.76 Zr2 -","2","1","","Merlino, S.; Perchiazzi, N.","The crystal structure of hiortdahlite II Note: this is a polytype of Hiortdahlite I","Mineralogy and Petrology","1987","37","","25","35","10.1007/BF01163156","","","","","","","","","","","","","","","","","","","","","has coordinates","283960","2023-05-23","08:42:08",""
"9009827","12.926","","11.496","","4.696","","90","","100.81","","90","","685.43","","","","","","","","","","","","Ajo, Pima County, Arizona, USA","5","C 1 2/m 1","-C 2y","12","","","Papagoite","- Al Ca Cu O9 Si2 -","- Al Ca Cu O9 Si2 -","- Al4 Ca4 Cu4 O36 Si8 -","4","0.5","","Groat, L. A.; Hawthorne, F. C.","Refinement of the structure of papagoite, CaCuAlSi2O6(OH)3 Note: U(1,1)(O3) changed from .0068 to match reported Uiso","Mineralogy and Petrology","1987","37","","89","96","10.1007/BF01164184","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:32",""
"9014294","11.012","","10.342","","7.359","","89.92","","109.21","","90.06","","791.421","","","","","","","","","","","","Kipawa river, Canada","7","P -1","-P 1","2","","","Hiortdahlite","- Ca4 F3 Na2 O15 Si4 Y Zr -","- Ca4 F3 Na2 O15 Si4 Y Zr -","- Ca8 F6 Na4 O30 Si8 Y2 Zr2 -","2","1","","Merlino, S.; Perchiazzi, N.","The crystal structure of hiortdahlite II","Mineralogy and Petrology","2010","37","","25","35","","","","","","","","","","","","","","","","","","","","","","has coordinates","283960","2023-05-23","08:42:10",""