# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-17T11:49:19+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 'European Journal of Mineralogy') AND volume = 31 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
"9017256","26.188","","7.36","","10.367","","90","","90","","90","","1998.17","","","","","","","","","","","","White Elephant mine, Pringle, South Dakota, USA","6","I m m a","-I 2b 2","74","","","Walentaite","- As2.86 Ca0.708 Fe3 Mn0.652 O19.928 P1.684 -","- As2.86 Ca0.708 Fe3 Mn0.652 O19.928 P1.684 -","- As11.44 Ca2.832 Fe12 Mn2.608 O79.712 P6.736 -","4","0.25","","Grey, I. E.; Mumme, W. G.; Hochleitner, R.","Trimeric As3+3O6 clusters in walentaite: crystal structure and revised formula","European Journal of Mineralogy","2019","31","","111","116","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:53",""
"9017257","6.307","","11.074","","13.085","","90","","99.62","","90","","901.054","","","","100","","","","","","","","Hagendorf-Sud pegmatite, Oberpfalz, Bavaria, Germany","8","P 1 21/m 1","-P 2yb","11","","","Manganflurlite","- Al0.04 Fe2.07 H19 Mg0.06 Mn1.53 O23 P3 Zn1.3 -","- Al0.04 Fe2.07 H19 Mg0.06 Mn1.53 O23 P3 Zn1.3 -","- Al0.08 Fe4.14 H38 Mg0.12 Mn3.06 O46 P6 Zn2.6 -","2","0.5","","Kampf, A. R.; Grey, I. E.; MacRae, C. M.; Keck, E.","Manganflurlite, ZnMn32+Fe3+(PO4)3(OH)2(H2O)7·2H2O, a new schoonerite-related mineral from the Hagendorf-Sud pegmatite Note: T = 100 K","European Journal of Mineralogy","2019","31","","127","134","","","","","","","","","","","","","","","","","","","","","","has coordinates","283850","2023-05-18","07:16:48",""
"9017258","14.0016","","16.8593","","5.1831","","90","","90","","90","","1223.51","","","","","","","","","","","","Hagendorf Sud pegmatite, Oberpfalz, Bavaria","6","B b m m","-B 2 2b","63","","","Ferrorockbridgeite","- Fe4.44 H5.88 Mn0.52 O17 P3 Zn0.04 -","- Fe17.76 H23.52 Mn2.08 O68 P12 Zn0.16 -","- Fe17.76 H23.52 Mn2.08 O68 P12 Zn0.16 -","","","","Grey, I. E.; Kampf, A. R.; Keck, E.; Cashion, J. D.; MacRae, C. M.; Gozukara, Y.; Peterson, V. K.; Shanks, F. L.","The rockbridgeite group approved and a new member, ferrorockbridgeite, (Fe2+,Mn2+)2(Fe3+)3(PO4)3(OH)4(H2O), described from the Hagendorf Sud pegmatite, Oberpfalz, Bavaria Note: neutron powder on sample IGC90","European Journal of Mineralogy","2019","31","","389","397","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","07:57:50",""
"9017259","13.995","","16.884","","5.1866","","90","","90","","90","","1225.55","","","","100","","","","","","","","Hagendorf Sud pegmatite, Oberpfalz, Bavaria","6","B b m m","-B 2 2b","63","","","Ferrorockbridgeite","- Fe4.17 H5.78 Mn0.77 O17 P3 Zn0.06 -","- Fe4.17 H5.78 Mn0.77 O17 P3 Zn0.06 -","- Fe16.68 H23.12 Mn3.08 O68 P12 Zn0.24 -","4","0.25","","Grey, I. E.; Kampf, A. R.; Keck, E.; Cashion, J. D.; MacRae, C. M.; Gozukara, Y.; Peterson, V. K.; Shanks, F. L.","The rockbridgeite group approved and a new member, ferrorockbridgeite, (Fe2+,Mn2+)2(Fe3+)3(PO4)3(OH)4(H2O), described from the Hagendorf Sud pegmatite, Oberpfalz, Bavaria Note: X-ray single crystal on sample IGC29 Note: T = 100 K","European Journal of Mineralogy","2019","31","","389","397","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:53",""
"9017260","9.183","","12.349","","5.0081","","90","","100.23","","90","","558.894","","","","","","","","","","","","Spring Creek mine, South Australia, Australia","10","P 1 21/m 1","-P 2yb","11","","","Strontioperloffite","- Al0.02 Ba0.38 Ca0.04 Fe2.08 H3 Mn1.86 Na0.02 O15 P3 Sr0.6 -","- Al0.04 Ba0.76 Ca0.08 Fe4.16 H6 Mn3.72 Na0.04 O30 P6 Sr1.2 -","- Al0.04 Ba0.76 Ca0.08 Fe4.16 H6 Mn3.72 Na0.04 O30 P6 Sr1.2 -","","","","Elliott, P.","Strontioperloffite, SrMn22+Fe32+PO43+OH3, a new bjarebyite-group mineral from the Spring Creek mine, South Australia, Australia","European Journal of Mineralogy","2019","31","","549","555","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","07:57:51",""
"9017261","13.909","","5.186","","12.159","","90","","98.88","","90","","866.541","","","","","","","","","","","","Krasno near Horni Slavkov, Czech Republic","5","P 1 2/a 1","-P 2ya","13","","","Kenngottite","- Fe3.85 H8.74 Mn3 O24.08 P4 -","- Fe3.85 H8.74 Mn3 O24.08 P4 -","- Fe7.7 H17.48 Mn6 O48.16 P8 -","2","0.5","","Sejkora, J.; Grey, I. E.; Kampf, A. R.","Kenngottite, Mn32+Fe43+(PO4)4(OH)6(H2O)2: a new phosphate mineral from Krasno near Horni Slavkov, Czech Republic Note: water and hydroxyl groups are not well located","European Journal of Mineralogy","2019","31","","629","636","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:53",""
"9017262","10.021","","24.137","","6.226","","90","","91.54","","90","","1505.38","","","","","","","","","","","","Foote spodumene mine, North Carolina, USA","8","C 1 2/c 1","-C 2yc","15","","","Fanfaniite","- Al1.96 Ca2 Fe0.1 H10 Mg0.06 Mn0.38 O20 P3 -","- Al1.96 Ca2 Fe0.1 H10 Mg0.06 Mn0.38 O20 P3 -","- Al7.84 Ca8 Fe0.4 H40 Mg0.24 Mn1.52 O80 P12 -","4","0.5","","Grey, I. E.; Kampf, A. R.; Smith, J. B.; MacRae, C. M.; Keck, E.","Fanfaniite, Ca4Mn2+Al4(PO4)6(OH,F)4*12H2O, a new mineral with a montgomeryite-type structure","European Journal of Mineralogy","2019","31","","647","652","","","","","","","","","","","","","","","","","","","","","","has coordinates","283850","2023-05-18","07:16:48",""
"9017263","20.067","","13.197","","6.255","","89.35","","91.21","","112.2","","1533.33","","","","100","","","","","","","","Foote mine, Kings Mountain Mining District, North Carolina, USA","7","P -1","-P 1","2","","","Kingsmountite","- Al4 Ca3.091 Fe0.568 Mg0.14 Mn1.178 O40 P6 -","- Al4.002 Ca3.091 Fe0.568 Mg0.14 Mn1.178 O40 P6 -","- Al8.004 Ca6.182 Fe1.136 Mg0.28 Mn2.356 O80 P12 -","2","1","","Grey, I. E.; Kampf, A. R.; Smith, J. B.; Williams, T.; MacRae, C. M.","The calcioferrite group approved and kingsmountite redefined Note: sample K5, T = 100 K","European Journal of Mineralogy","2019","31","","1007","1014","","","","","","","","","","","","","","","","","","","","","","has coordinates","283911","2023-05-21","08:37:46",""