# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-26T15:24:02+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 (1969-)') AND volume = 67 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
"1532797","9.666","","17.799","","5.311","","90","","104.1","","90","","886.203","","","","","","","","","","","","","13","C 1 2/m 1","-C 2y","12","","(Na0.78 K0.06) (Na1.53 Ca0.47) (Fe1.21 Mg2.55 Mn0.01 Zn0.01 Al1.21 Ti0.01) ((Si7.14 Al0.86) O22 ((O H)0.84 F1.16))","","- Al2.07 Ca0.47 F1.16 Fe1.21 H0.84 K0.06 Mg2.55 Mn0.01 Na2.31 O22.84 Si7.14 Ti0.01 Zn0.01 -","- Al2.07 Ca0.47 F1.16 Fe1.21 H0.84 K0.059 Mg2.55 Mn0.01 Na2.31 O22.84 Si7.14 Ti0.01 Zn0.01 -","- Al4.14 Ca0.94 F2.32 Fe2.42 H1.68 K0.118 Mg5.1 Mn0.02 Na4.62 O45.68 Si14.28 Ti0.02 Zn0.02 -","2","0.25","","Oberti, R.; Boiocchi, M.; Smith, D.C.","Fluoronyboeite from Jianchang (Su-Lu, China) and nyboeite from Nyboe (Nordfjord, Norway): a petrological and crystal-chemical comparisonof these two high-pressure amphiboles","Mineralogical Magazine (1969-)","2003","67","","769","782","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1532801","9.665","","17.752","","5.303","","90","","104.11","","90","","882.401","","","","","","","","","","","","","11","C 1 2/m 1","-C 2y","12","","(Na0.79 K0.03) (Na1.65 Ca0.35) (Fe0.61 Mg2.99 Ni0.01 Al1.37 Ti0.02) ((Si7.22 Al0.78) O22 (O H)2)","","- Al2.15 Ca0.35 Fe0.61 H2 K0.03 Mg2.99 Na2.44 Ni0.01 O24 Si7.22 Ti0.02 -","- Al2.15 Ca0.35 Fe0.61 H2 K0.03 Mg2.99 Na2.44 Ni0.01 O24 Si7.22 Ti0.02 -","- Al4.3 Ca0.7 Fe1.22 H4 K0.06 Mg5.98 Na4.88 Ni0.02 O48 Si14.44 Ti0.04 -","2","0.25","","Oberti, R.; Boiocchi, M.; Smith, D.C.","Fluoronyboeite from Jianchang (Su-Lu, China) and nyboeite from Nyboe (Nordfjord, Norway): a petrological and crystal-chemical comparisonof these two high-pressure amphiboles","Mineralogical Magazine (1969-)","2003","67","","769","782","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1533829","8.8268","","8.3235","","11.0532","","90","","110.579","","90","","760.257","","","","","","","","","","","","","4","C 1 2/c 1","-C 2yc","15","","Ca (C O3) (D2 O)6","","- C Ca D12 O9 -","- C Ca D12 O9 -","- C4 Ca4 D48 O36 -","4","0.5","","Swainson, I.P.; Hammond, R.P.","Hydrogen bonding in ikaite, Ca C O3 * 6(H2 O)","Mineralogical Magazine (1969-)","2003","67","","555","562","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1533986","8.314","","8.545","","17.21","","90","","90","","90","","1222.65","","","","","","","","","","","","","4","I m m m","-I 2 2","71","","Pb2 (O H)3 (N O3)","","- H3 N O6 Pb2 -","- N O6 Pb2 -","- N8 O48 Pb16 -","8","0.5","","Kolitsch, U.; Tillmanns, E.","The crystal structure of anthropogenic Pb2 (O H)3 (N O3) and a review of Pb - (O, O H) clusters and lead nitrates","Mineralogical Magazine (1969-)","2003","67","","79","93","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"9011819","12.704","","22.576","","11.287","","90","","118.37","","90","","2848.38","","","","","","","","","","","","Langban, Sweden","4","C 1 2/c 1","-C 2yc","15","","","Sahlinite","- As2 Cl4 O17 Pb14 -","- As2 Cl4 O17 Pb14 -","- As8 Cl16 O68 Pb56 -","4","0.5","","Bonaccorsi, E.; Pasero, M.","Crystal structure refinement of sahlinite, Pb14(AsO4)2O9Cl4","Mineralogical Magazine","2003","67","","15","21","10.1180/0026461036710080","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:45",""
"9011820","4.625","","4.625","","3.059","","90","","90","","90","","65.434","","","","","","","","","","","","Tripuhy, Minas Gerais, Brazil","3","P 42/m n m","-P 4n 2n","136","","","Tripuhyite","- Fe0.47 O2 Sb0.53 -","- Fe0.47 O2 Sb0.53 -","- Fe0.94 O4 Sb1.06 -","2","0.125","","Berlepsch, P.; Armbruster, T.; Brugger, J.; Criddle, A. J.; Graeser, S.","Tripuhyte, FeSbO4, revisited","Mineralogical Magazine","2003","67","","31","46","10.1180/0026461036710082","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:45",""
"9011821","4.6433","","4.6433","","3.0815","","90","","90","","90","","66.438","","","","","","","","","","","","Falotta, Grisons, Switzerland","3","P 42/m n m","-P 4n 2n","136","","","Tripuhyite","- Fe0.53 O2 Sb0.47 -","- Fe0.53 O2 Sb0.47 -","- Fe1.06 O4 Sb0.94 -","2","0.125","","Berlepsch, P.; Armbruster, T.; Brugger, J.; Criddle, A. J.; Graeser, S.","Tripuhyte, FeSbO4, revisited","Mineralogical Magazine","2003","67","","31","46","10.1180/0026461036710082","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:45",""
"9011822","9.0127","","9.0127","","4.4473","","90","","90","","90","","361.249","","","","","","","","","","","","Synthetic","3","I -4","I -4","82","","","Nickelphosphide","- Fe1.33 Ni1.67 P -","- Fe1.33 Ni1.67 P -","- Fe10.64 Ni13.36 P8 -","8","1","","Skala, R.; Drabek, M.","Nickelphosphide from the Vicenice octahedrite: Rietveld crystal structure refinement of synthetic analogue Sample: P-44","Mineralogical Magazine","2003","67","","783","792","10.1180/0026461036740134","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:45",""
"9011823","8.9499","","8.9499","","4.385","","90","","90","","90","","351.242","","","","","","","","","","","","Synthetic","2","I -4","I -4","82","","","Nickelphosphide","- Ni3 P -","- Ni3 P -","- Ni24 P8 -","8","1","","Skala, R.; Drabek, M.","Nickelphosphide from the Vicenice octahedrite: Rietveld crystal structure refinement of synthetic analogue Sample: P-33/3","Mineralogical Magazine","2003","67","","783","792","10.1180/0026461036740134","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:45",""
"9011824","31.066","","17.303","","7.043","","90","","96.492","","90","","3761.58","","","","","","","","","","","","Michael Mine, Weiler, Lahr, Black Forest, Baden-Wurttemburg, Germany","5","P 1 21/m 1","-P 2yb","11","","","Hugelite","- As2 H10 O21 Pb2 U3 -","- As2 H10 O21 Pb2 U3 -","- As16 H80 O168 Pb16 U24 -","8","2","","Locock, A. J.; Burns, P. C.","The structure of hugelite, an arsenate of the phosphuranylite group, and its relationship to dumontite Locality: Michael Mine, Weiler, Lahr, Black Forest, Baden-Wurttemburg, Germany Note: x(O11) corrected","Mineralogical Magazine","2003","67","","1109","1120","10.1180/0026461036750146","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:49",""
"9014148","15.739","","15.739","","9.127","","90","","90","","120","","1958","","","","","","","","","","","","Likasi, Democratic Republic of Congo","6","P 63/m m c","-P 6c 2c","194","","","Buttgenbachite","- Cl3.9 Cu18 H34.32 N0.66 O36.36 S0.18 -","- Cl3.9 Cu18 H34.32 N0.66 O36.36 S0.18 -","- Cl7.8 Cu36 H68.64 N1.32 O72.72 S0.36 -","2","0.0833333","","Hibbs, D. E.; Leverett, P.; Williams, P. A.","A single crystal X-ray study of a sulphate-bearing buttgenbachite, Cu36Cl7.8(NO3)1.3(SO4)0.35(OH)62.2*5.2H2O, and a re-examination of the crystal chemistry of the buttgenbachite-connellite series Note: T = 100 K","Mineralogical Magazine","2003","67","","47","60","10.1180/0026461036710083","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:51",""
"9016375","15.739","","15.739","","9.127","","90","","90","","120","","1958","","","","","","","","","","","","Likasi, Democratic Republic of Congo","6","P 63/m m c","-P 6c 2c","194","","","Buttgenbachite","- Cl3.9 Cu18 H32.07 N0.66 O34.11 S0.18 -","- Cl3.9 Cu18 H32.07 N0.66 O34.11 S0.18 -","- Cl7.8 Cu36 H64.14 N1.32 O68.22 S0.36 -","2","0.0833333","","Hibbs, D. E.; Leverett, P.; Williams, P. A.","A single crystal X-ray study of a sulphate-bearing buttgenbachite, Cu36Cl7.8(NO3)1.3(SO4)0.35(OH)62.2.5.2H2O, and a re-examination of the crystal chemistry of the buttgenbachite-connellite series Note: T = 288 K","Mineralogical Magazine","2003","67","","47","60","10.1180/0026461036710083","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:52",""