# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-26T13:51:15+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 'European Journal of Mineralogy') AND volume = 28 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
"9017251","10.049","","10.205","","6.083","","91.79","","99.7","","98.02","","607.921","","","","100","","","","","","","","Foote Lithium Company mine, Kings Mountain district, North Carolina, USA","6","P -1","-P 1","2","","","Kayrobertsonite","- Al2 Ca0.03 H14 Mn0.97 O16 P2 -","- Al2 Ca0.03 H14 Mn0.97 O16 P2 -","- Al4 Ca0.06 H28 Mn1.94 O32 P4 -","2","1","","Mills, S. J.; Grey, I. E.; Kampf, A. R.; Birch, W. D.; Macrae, C. M.; Smith, J. B.; Keck, E.","Kayrobertsonite, MnAl2(PO4)2(OH)2*6H2O, a new phosphate mineral related to nordgauite Note: T = 100 K","European Journal of Mineralogy","2016","28","","649","654","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:53",""
"9017252","25.333","","6.299","","15.161","","90","","90.03","","90","","2419.28","","","","","","","","","","","","Foote Lithium Company mine, Kings Mountain district, North Carolina, USA","8","I 1 2/m 1","-I 2y","12","","","Ferraioloite","- Al1.76 Fe2.24 H44 Mg Mn4 O56 P8 Zn4 -","- Al1.76 Fe2.24 H44 Mg Mn4 O56 P8 Zn4 -","- Al3.52 Fe4.48 H88 Mg2 Mn8 O112 P16 Zn8 -","2","0.25","","Mills, S. J.; Grey, I. E.; Kampf, A. R.; Macrae, C. M.; Smith, J. B.; Davidson, C. J.; Glenn, A. M.","Ferraioloite, MgMn2+4(Fe2+0.5Al3+0.5)4Zn4(PO4)8(OH)4(H2O)20, a new secondary phosphate mineral from the Foote mine, USA","European Journal of Mineralogy","2016","28","","655","661","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:53",""
"9017253","24.199","","24.199","","7.6476","","90","","90","","120","","3878.38","","","","","","","","","","","","Saint Felix de Pailleres, France","4","R -3 :H","-R 3","148","","","Fibroferrite","- Fe H11 O10 S -","- Fe H11 O10 S -","- Fe18 H198 O180 S18 -","18","1","","Ventruti, G.; Ventura, G. D.; Bellatreccia, F.; Lacalamita, M.; Schingaro, E.","Hydrogen bond system and vibrational spectroscopy of the iron sulfate fibroferrite, Fe(OH)SO4*5H2O","European Journal of Mineralogy","2016","28","","943","952","","","","","","","","","","","","","","","","","","","","","","has coordinates","292100","2024-05-29","14:19:56",""
"9017254","14.975","","7.1645","","9.928","","90","","110.65","","90","","996.725","","","","","","","","","","","","Tom's quarry, South Australia, Australia","9","P 1 2/a 1","-P 2ya","13","","","Jahnsite-(CaFeMg)","- Al0.01 Ca0.7 Fe3.23 H18 Mg1.33 Mn0.59 Na0.17 O26 P4 -","- Al0.01 Ca0.7 Fe3.23 H18 Mg1.33 Mn0.59 Na0.17 O26 P4 -","- Al0.02 Ca1.4 Fe6.46 H36 Mg2.66 Mn1.18 Na0.34 O52 P8 -","2","0.5","","Elliott, P.","Jahnsite-(CaFeMg), a new mineral from Tom's quarry, South Australia: description and crystal structure","European Journal of Mineralogy","2016","28","","991","996","","","","","","","","","","","","","","","","","","","","","","has coordinates","294031","2024-08-07","17:26:35",""
"9017881","6.91","","7.634","","7.643","","90","","118","","90","","355.983","","","","","","","","","","","","Synthetic","4","C 1 2/c 1","-C 2yc","15","","","Kieserite","- H2 Mg O5 S -","- H2 Mg O5 S -","- H8 Mg4 O20 S4 -","4","0.5","","Bechtold, A.; Wildner, M.","Crystal chemistry of the kieserite-cobaltkieserite solid solution, Mg1-xCox(SO4)*H2O: well-behaved oddities","European Journal of Mineralogy","2016","28","","43","52","","","","","","","","","","","","","","","","","","","","","","has coordinates","292100","2024-05-29","14:19:57",""
"9017882","6.929","","7.623","","7.641","","90","","118.19","","90","","355.724","","","","","","","","","","","","Synthetic","5","C 1 2/c 1","-C 2yc","15","","","Kieserite","- Co0.279 H2 Mg0.721 O5 S -","- Co0.279 H2 Mg0.721 O5 S -","- Co1.116 H8 Mg2.884 O20 S4 -","4","0.5","","Bechtold, A.; Wildner, M.","Crystal chemistry of the kieserite-cobaltkieserite solid solution, Mg1-xCox(SO4)*H2O: well-behaved oddities Note: sample Mg0.76Co0.28","European Journal of Mineralogy","2016","28","","43","52","","","","","","","","","","","","","","","","","","","","","","has coordinates","292100","2024-05-29","14:19:57",""
"9017883","6.943","","7.614","","7.639","","90","","118.33","","90","","355.461","","","","","","","","","","","","Synthetic","5","C 1 2/c 1","-C 2yc","15","","","Cobaltkieserite","- Co0.509 H2 Mg0.491 O5 S -","- Co0.509 H2 Mg0.491 O5 S -","- Co2.036 H8 Mg1.964 O20 S4 -","4","0.5","","Bechtold, A.; Wildner, M.","Crystal chemistry of the kieserite-cobaltkieserite solid solution, Mg1-xCox(SO4)*H2O: well-behaved oddities Note: sample Mg0.49Co0.51","European Journal of Mineralogy","2016","28","","43","52","","","","","","","","","","","","","","","","","","","","","","has coordinates","292100","2024-05-29","14:19:57",""
"9017884","6.963","","7.601","","7.633","","90","","118.5","","90","","355.027","","","","","","","","","","","","Synthetic","5","C 1 2/c 1","-C 2yc","15","","","Cobaltkieserite","- Co0.858 H2 Mg0.142 O5 S -","- Co0.858 H2 Mg0.142 O5 S -","- Co3.432 H8 Mg0.568 O20 S4 -","4","0.5","","Bechtold, A.; Wildner, M.","Crystal chemistry of the kieserite-cobaltkieserite solid solution, Mg1-xCox(SO4)*H2O: well-behaved oddities Note: sample Mg0.14Co0.86","European Journal of Mineralogy","2016","28","","43","52","","","","","","","","","","","","","","","","","","","","","","has coordinates","292100","2024-05-29","14:19:57",""
"9017885","6.97","","7.595","","7.632","","90","","118.58","","90","","354.787","","","","","","","","","","","","Synthetic","4","C 1 2/c 1","-C 2yc","15","","","Cobaltkieserite","- Co H2 O5 S -","- Co H2 O5 S -","- Co4 H8 O20 S4 -","4","0.5","","Bechtold, A.; Wildner, M.","Crystal chemistry of the kieserite-cobaltkieserite solid solution, Mg1-xCox(SO4)*H2O: well-behaved oddities","European Journal of Mineralogy","2016","28","","43","52","","","","","","","","","","","","","","","","","","","","","","has coordinates","292100","2024-05-29","14:19:57",""