# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-26T11:35:03+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 'Mineralogical Magazine') AND volume = 71 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
"9011832","9.249","","9.076","","10.342","","90","","90","","90","","868.148","","","","","","","","","","","","N'Chwaning II mine, Republic of South Africa","6","P b c a","-P 2ac 2ab","61","","","Olmiite","- Ca1.14 Fe0.01 H2 Mn0.84 O5 Si -","- Ca1.14 Fe0.01 H2 Mn0.84 O5 Si -","- Ca9.12 Fe0.08 H16 Mn6.72 O40 Si8 -","8","1","","Bonazzi, P.; Bindi, L.; Medenbach, O.; Pagano, R.; Lampronti, G. I.; Menchetti, S.","Olmiite, CaMn[SiO3(OH)](OH), the Mn-dominant analogue of poldervaartite, a new mineral species from Kalahari manganese fields (Republic of South Africa)","Mineralogical Magazine","2007","71","","193","201","10.1180/minmag.2007.071.2.193","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:45",""
"9011833","7.3177","","7.3177","","17.534","","90","","90","","120","","813.132","","","","","","","","","","","","Synthetic","5","R -3 m :H","-R 3 2""","166","","","Ammoniojarosite","- Fe3 H10 N O14 S2 -","- Fe3 H7 N O14 S2 -","- Fe9 H21 N3 O42 S6 -","3","0.0833333","","Basciano, L. C.; Peterson, R. C.","The crystal structure of ammoniojarosite, (NH4)Fe3(SO4)2(OH)6 and the crystal chemistry of the ammoniojarosite-hydronium jarosite solid-solution series","Mineralogical Magazine","2007","71","","427","441","10.1180/minmag.2007.071.4.427","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:45",""
"9013428","7.3277","","7.3277","","11.7752","","90","","90","","120","","547.563","","","","","","","","","","","","Premier mine, Stewart, British Columbia, Canada","5","P -3 m 1","-P 3 2""","164","","","Cupropolybasite","- Ag11.706 As0.618 Cu4.294 S11 Sb1.382 -","- Ag11.706 As0.618 Cu4.294 S11 Sb1.382 -","- Ag11.706 As0.618 Cu4.294 S11 Sb1.382 -","1","0.0833333","","Bindi, L.; Evain, M.; Spry, P. G.; Tait, K. T.; Menchetti, S.","Structural role of copper in the minerals of the pearceite-polybasite group: the case of the new minerals cupropearceite and cupropolybasite","Mineralogical Magazine","2007","71","","641","650","10.1180/minmag.2007.071.6.641","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:49",""
"9013945","7.971","","7.976","","27.341","","90","","90","","90","","1738.25","","","","","","","","","","","","San Rafael mine, Sierra Gorda, Chile","4","C m m 2","C 2 -2","35","","","Seeligerite","- Cl3 I O4 Pb3 -","- Cl3 I O4 Pb3 -","- Cl24 I8 O32 Pb24 -","8","1","","Bindi, L.; Welch, M. D.; Bonazzi, P.; Pratesi, G.; Menchetti, S.","The crystal structure of seeligerite, Pb3IO4Cl3, a rare Pb-I-oxychloride from the San Rafael mine, Sierra Gorda, Chile Locality: San Rafael mine, Sierra Gorda, Chile","Mineralogical Magazine","2008","71","","771","783","","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:17",""
"9015940","10.675","","10.675","","27.02","","90","","90","","120","","2666.56","","","","","","","","","","","","Hundholmen, Tysfjord, Nordland County, Norway","13","R 3 m :H","R 3 -2""","160","","","Hundholmenite-(Y)","- Al0.66 As0.48 B3 Ca3.15 F11.16 Fe0.27 Mn0.03 Na0.27 O39.64 P0.05 Si6.69 Sm7.71 Y4.38 -","- Al0.66 As0.48 B3 Ca3.15 F11.16 Fe0.27 Mn0.03 Na0.27 O36.64 P0.05 Si6.69 Sm7.71 Y4.38 -","- Al1.98 As1.44 B9 Ca9.45 F33.48 Fe0.81 Mn0.09 Na0.81 O109.92 P0.15 Si20.07 Sm23.13 Y13.14 -","3","0.166667","","Raade, G.; Johnsen, O.; Erambert, M.; Petersen, O. V.","Hundholmenite-(Y) from Norway - a new mineral species in the vicanite group: descriptive data and crystal structure","Mineralogical Magazine","2007","71","","179","192","10.1180/minmag.2007.071.2.179","","","","","","","","","","","","","","","","","","","","","has coordinates","285096","2023-07-08","08:53:35",""