# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2026-05-03T12:36:32+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 'Mineralogical Magazine') AND volume = 68 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
"9011825","20.117","","5.185","","13.978","","90","","107.07","","90","","1393.77","","","","","","","","","","","","Clara mine, Black Forest, Germany","7","P 1 2/c 1","-P 2yc","13","","","Kidwellite","- As0.476 Cu0.356 Fe9 H19 Na O38 P5.524 -","- As0.476 Cu0.356 Fe9 H17 Na O38 P5.524 -","- As0.952 Cu0.712 Fe18 H34 Na2 O76 P11.048 -","2","0.5","","Kolitsch, U.","The crystal structures of kidwellite and 'laubmannite', two complex fibrous iron phosphates","Mineralogical Magazine","2004","68","","147","165","10.1180/0026461046810177","","","","","","","","","","","","","","","","","","","","","has coordinates","303136","2025-11-01","12:31:45",""
"9011826","33.256","","8.482","","14.191","","90","","104.145","","90","","3881.59","","","","","","","","","","","","Johanngeorgenstadt, Saxony, Germany","5","C 1 2 1","C 2y","5","","","Petewilliamsite","- As10 Co4.5 Cu0.8 Ni4.7 O35 -","- As10 Co4.5 Cu0.8 Ni4.7 O35 -","- As60 Co27 Cu4.8 Ni28.2 O210 -","6","1.5","","Roberts, A. C.; Burns, P. C.; Gault, R. A.; Criddle, A. J.; Feinglos, M. N.","Petewilliamsite, (Ni,Co)30(As2O7)15, a new mineral from Johanngeorgenstadt, Saxony, Germany: description and crystal structure","Mineralogical Magazine","2004","68","","231","240","10.1180/0026461046820183","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:45",""
"9011827","3.8932","","3.8932","","22.803","","90","","90","","90","","345.625","","","","","","","","","","","","Kombat mine, Namibia","4","I 4/m m m","-I 4 2","139","","","Asisite","- Cl O4 Pb3.5 Si0.5 -","- Cl O4 Pb3.5 Si0.5 -","- Cl2 O8 Pb7 Si -","2","0.0625","","Welch, M. D.","Pb-Si ordering in sheet-oxychloride minerals: the super-structure of asisite, nominally Pb7SiO8Cl2 Locality: Kombat mine, Namibia","Mineralogical Magazine","2004","68","","247","254","10.1180/0026461046820185","","","","","","","","","","","","","","","","","","","","","has coordinates","303136","2025-11-01","12:31:45",""
"9013943","6.834","0.001","6.834","0.001","14.075","0.002","90","","90","","120","","569.284","","","","","","","","","","","","Mina Los Tres Presidentes, Sierra Gorda, Chile","5","R -3 m :H","-R 3 2""","166","","","Herbertsmithite","- Cl2 Cu3 H6 O6 Zn -","- Cl2 Cu3 H6 O6 Zn -","- Cl6 Cu9 H18 O18 Zn3 -","3","0.0833333","","Braithwaite, R. S. W.; Mereiter, K.; Paar, W. H.; Clark, A. M.","Herbertsmithite, Cu3Zn(OH)6Cl2, a new species and the definition of paratacamite Locality: Generosa mine, Sierra Gorda, Chile","Mineralogical Magazine","2004","68","","527","539","10.1180/0026461046830204","","","","","","","","","","","","","","","","","","","","","has coordinates","288043","2023-12-05","16:05:09",""
"9013944","6.834","","6.834","","14.075","","90","","90","","120","","569.284","","","","","","","","","","","","","5","R -3 :H","-R 3","148","","","Herbertsmithite","- Cl2 Cu3 H6 O6 Zn -","- Cl2 Cu3 H6 O6 Zn -","- Cl6 Cu9 H18 O18 Zn3 -","3","0.166667","","Braithwaite, R. S. W.; Mereiter, K.; Paar, W. H.; Clark, A. M.","Herbertsmithite, Cu3Zn(OH)6Cl2, a new species and the definition of paratacamite Locality: Mina Los Tres Presidentes, Sierra Gorda, Chile","Mineralogical Magazine","2004","68","","527","539","10.1180/0026461046830204","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:17",""