# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2025-03-13T22:05:24+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 'Neues Jahrbuch fuer Mineralogie. Abhandlungen (Band-Nr) (1950-)') AND volume = 165 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
"1535352","9.519","","18.192","","5.316","","90","","102.04","","90","","900.319","","","","","","","","","","","","","6","C 1 2/m 1","-C 2y","12","","(Fe3.58 Mg3.36 Na.06) (Si8 O22 (O H)2)","","- Fe3.58 H2 Mg3.36 Na0.06 O24 Si8 -","- Fe3.58 H2 Mg3.36 Na0.06 O24 Si8 -","- Fe7.16 H4 Mg6.72 Na0.12 O48 Si16 -","2","0.25","","Tartarotti, P.; Caucia, F.","Coexisting cummingtonite - sodic amphibole pair in metaquartzites from the ophiolite's sedimentary cover (St. Marcel Valley, Italian Western Alps): A X-ray structure refinement and petrology study","Neues Jahrbuch fuer Mineralogie. Abhandlungen (Band-Nr) (1950-)","1993","165","","223","243","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1535356","9.503","","18.162","","5.314","","90","","101.99","","90","","897.153","","","","","","","","","","","","","5","C 1 2/m 1","-C 2y","12","","(Fe3.16 Mg3.84) (Si8 O22) (O H)2","","- Fe3.16 H2 Mg3.84 O24 Si8 -","- Fe3.16 H2 Mg3.84 O24 Si8 -","- Fe6.32 H4 Mg7.68 O48 Si16 -","2","0.25","","Tartarotti, P.; Caucia, F.","Coexisting cummingtonite - sodic amphibole pair in metaquartzites from the ophiolite's sedimentary cover (St. Marcel Valley, Italian Western Alps): A X-ray structure refinement and petrology study","Neues Jahrbuch fuer Mineralogie. Abhandlungen (Band-Nr) (1950-)","1993","165","","223","243","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1535359","9.571","","17.781","","5.303","","90","","103.6","","90","","877.17","","","","","","","","","","","","","8","C 1 2/m 1","-C 2y","12","","(Na1.96 Ca0.04 Fe1.5 Mg2.06 Al1.44) (Si8 O22) (O H)2","","- Al1.44 Ca0.04 Fe1.5 H2 Mg2.06 Na1.96 O24 Si8 -","- Al1.44 Ca0.04 Fe1.5 H2 Mg2.06 Na1.96 O24 Si8 -","- Al2.88 Ca0.08 Fe3 H4 Mg4.12 Na3.92 O48 Si16 -","2","0.25","","Tartarotti, P.; Caucia, F.","Coexisting cummingtonite - sodic amphibole pair in metaquartzites from the ophiolite's sedimentary cover (St. Marcel Valley, Italian Western Alps): A X-ray structure refinement and petrology study","Neues Jahrbuch fuer Mineralogie. Abhandlungen (Band-Nr) (1950-)","1993","165","","223","243","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"9014058","15.941","","15.941","","7.201","","90","","90","","120","","1584.73","","","","","","","","","","","","Yinnietharra, Western Australia","12","R 3 m :H","R 3 -2""","160","","","Dravite","- Al6.109 B3.08 Ca0.09 F0.17 Fe0.06 H3.58 Li0.002 Mg2.73 Na0.82 O30.83 Si5.9 Ti0.11 -","- Al6.1092 B3.0798 Ca0.09 F0.17 Fe0.06 H3.58 Li0.0021 Mg2.7297 Na0.82 O30.83 Si5.8998 Ti0.1098 -","- Al18.3276 B9.2394 Ca0.27 F0.51 Fe0.18 H10.74 Li0.0063 Mg8.1891 Na2.46 O92.49 Si17.6994 Ti0.3294 -","3","0.166667","","Grice, J. D.; Ercit, T. S.","Ordering of Fe and Mg in the tourmaline crystal structure: The correct formula Sample: Dravite 43230","Neues Jahrbuch fur Mineralogie, Abhandlungen","1993","165","","245","266","","","","","","","","","","","","","","","","","","","","","","has coordinates","285095","2023-07-08","07:47:59",""
"9014456","16","","16","","7.248","","90","","90","","120","","1606.9","","","","","","","","","","","","Cuvier Island, New Zealand","10","R 3 m :H","R 3 -2""","160","","","Feruvite","- Al4.8 B3.12 Ca0.62 Fe1.98 H3.6 Mg2.04 Na0.4 O31 Si5.77 Ti0.28 -","- Al4.8003 B3.12 Ca0.62 Fe1.9803 H3.6 Mg2.0403 Na0.4 O31 Si5.7702 Ti0.2802 -","- Al14.4009 B9.36 Ca1.86 Fe5.9409 H10.8 Mg6.1209 Na1.2 O93 Si17.3106 Ti0.8406 -","3","0.166667","","Grice, J. D.; Ercit, T. S.","Ordering of Fe and Mg in the tourmaline crystal structure: The correct formula Sample: Feruvite 53776","Neues Jahrbuch fur Mineralogie, Abhandlungen","1993","165","","245","266","","","","","","","","","","","","","","","","","","","","","","has coordinates","285095","2023-07-08","07:47:59",""
"9014467","15.874","","15.874","","7.196","","90","","90","","120","","1570.34","","","","","","","","","","","","Mapimi, Durango, Mexico","11","R 3 m :H","R 3 -2""","160","","","Fluor-buergerite","- Al6.41 B3.1 Ca0.04 F0.74 Fe2.53 H1.35 Mg0.06 Na0.88 O30.26 Si5.83 Ti0.07 -","- Al6.4101 B3.1002 Ca0.04 F0.74 Fe2.5299 H1.35 Mg0.06 Na0.88 O30.26 Si5.8302 Ti0.0702 -","- Al19.2303 B9.3006 Ca0.12 F2.22 Fe7.5897 H4.05 Mg0.18 Na2.64 O90.78 Si17.4906 Ti0.2106 -","3","0.166667","","Grice, J. D.; Ercit, T. S.","Ordering of Fe and Mg in the tourmaline crystal structure: The correct formula Sample: Buergerite 43293","Neues Jahrbuch fur Mineralogie, Abhandlungen","1993","165","","245","266","","","","","","","","","","","","","","","","","","","","","","has coordinates","285095","2023-07-08","07:47:59",""
"9015090","15.846","","15.846","","7.119","","90","","90","","120","","1548.06","","","","","","","","","","","","Minas Gerais, Brazil","11","R 3 m :H","R 3 -2""","160","","","Fluor-elbaite","- Al7.53 B3.18 Ca0.03 F0.63 Fe0.03 H3.33 Li1.02 Mn0.39 Na0.66 O30.36 Si5.82 -","- Al7.53 B3.18 Ca0.03 F0.63 Fe0.03 H3.33 Li1.02 Mn0.39 Na0.66 O30.36 Si5.82 -","- Al22.59 B9.54 Ca0.09 F1.89 Fe0.09 H9.99 Li3.06 Mn1.17 Na1.98 O91.08 Si17.46 -","3","0.166667","","Grice, J. D.; Ercit, T. S.","Ordering of Fe and Mg in the tourmaline crystal structure: The correct formula Sample: Elbaite 55224","Neues Jahrbuch fur Mineralogie, Abhandlungen","1993","165","","245","266","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:51",""
"9015134","15.973","","15.973","","7.213","","90","","90","","120","","1593.75","","","","","","","","","","","","Gouverneur, St. Lawrence Co., New York, USA","12","R 3 m :H","R 3 -2""","160","","","Fluor-uvite","- Al5.46 B3 Ca0.54 F0.62 Fe0.02 H3.33 Li0.006 Mg3.5 Na0.42 O30.38 Si5.99 Ti0.06 -","- Al5.46 B3 Ca0.54 F0.62 Fe0.0201 H3.33 Li0.006 Mg3.5088 Na0.42 O30.38 Si5.9898 Ti0.06 -","- Al16.38 B9 Ca1.62 F1.86 Fe0.0603 H9.99 Li0.018 Mg10.5264 Na1.26 O91.14 Si17.9694 Ti0.18 -","3","0.166667","","Grice, J. D.; Ercit, T. S.","Ordering of Fe and Mg in the tourmaline crystal structure: The correct formula Sample: Uvite 52210","Neues Jahrbuch fur Mineralogie, Abhandlungen","1993","165","","245","266","","","","","","","","","","","","","","","","","","","","","","has coordinates","283911","2023-05-21","08:37:46",""
"9015415","15.972","","15.972","","7.16","","90","","90","","120","","1581.84","","","","","","","","","","","","Cross Lake, Manitoba, Canada","11","R 3 m :H","R 3 -2""","160","","","Schorl","- Al6.393 B3.102 Fe2.106 H3.65 Li0.09 Mg0.171 Mn0.081 Na0.49 O31 Si5.898 Zn0.159 -","- Al6.393 B3.102 Fe2.106 H3.65 Li0.09 Mg0.171 Mn0.081 Na0.49 O31 Si5.898 Zn0.159 -","- Al19.179 B9.306 Fe6.318 H10.95 Li0.27 Mg0.513 Mn0.243 Na1.47 O93 Si17.694 Zn0.477 -","3","0.166667","","Grice, J. D.; Ercit, T. S.","Ordering of Fe and Mg in the tourmaline crystal structure: The correct formula Sample: Schorl CROSS","Neues Jahrbuch fur Mineralogie, Abhandlungen","1993","165","","245","266","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:51",""
"9015599","15.981","","15.981","","7.21","","90","","90","","120","","1594.68","","","","","","","","","","","","Bronson Station, Hastings Co., Ontario, Canada","12","R 3 m :H","R 3 -2""","160","","","Fluor-dravite","- Al5.47 B3 Ca0.35 F0.44 Fe1.1 H3.21 Li0.039 Mg2.35 Na0.55 O30.56 Si5.98 Ti0.05 -","- Al5.4702 B3 Ca0.35 F0.44 Fe1.1001 H3 Li0.039 Mg2.3502 Na0.55 O30.56 Si5.9802 Ti0.0498 -","- Al16.4106 B9 Ca1.05 F1.32 Fe3.3003 H9 Li0.117 Mg7.0506 Na1.65 O91.68 Si17.9406 Ti0.1494 -","3","0.166667","","Grice, J. D.; Ercit, T. S.","Ordering of Fe and Mg in the tourmaline crystal structure: The correct formula Sample: Dravite 32008","Neues Jahrbuch fur Mineralogie, Abhandlungen","1993","165","","245","266","","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:19",""
"9016083","15.96","","15.96","","7.238","","90","","90","","120","","1596.67","","","","","","","","","","","","Moctezuma, Sonora, Mexico","10","R 3 m :H","R 3 -2""","160","","","Dravite","- Al5.47 B3.17 Ca0.18 Fe1.67 H3.6 Mg1.86 Na0.77 O31 Si5.78 Ti0.05 -","- Al5.4702 B3.1698 Ca0.18 Fe1.6701 H3.6 Mg1.8603 Na0.77 O31 Si5.7798 Ti0.0498 -","- Al16.4106 B9.5094 Ca0.54 Fe5.0103 H10.8 Mg5.5809 Na2.31 O93 Si17.3394 Ti0.1494 -","3","0.166667","","Grice, J. D.; Ercit, T. S.","Ordering of Fe and Mg in the tourmaline crystal structure: The correct formula Sample: Dravite 43167","Neues Jahrbuch fur Mineralogie, Abhandlungen","1993","165","","245","266","","","","","","","","","","","","","","","","","","","","","","has coordinates","285095","2023-07-08","07:47:59",""
"9016174","16.073","","16.073","","7.306","","90","","90","","120","","1634.57","","","","","","","","","","","","Silver Crater, Hastings Co., Ontario, Canada","11","R 3 m :H","R 3 -2""","160","","","Schorl","- Al3.42 B3 Ca0.01 Fe3.828 H3.6 Mg1.269 Na0.99 O31 Si6 Ti0.402 V0.021 -","- Al3.42 B3 Ca0.01 Fe3.828 H3.6 Mg1.269 Na0.99 O31 Si6 Ti0.402 V0.021 -","- Al10.26 B9 Ca0.03 Fe11.484 H10.8 Mg3.807 Na2.97 O93 Si18 Ti1.206 V0.063 -","3","0.166667","","Grice, J. D.; Ercit, T. S.","Ordering of Fe and Mg in the tourmaline crystal structure: The correct formula Sample: Schorl 2672","Neues Jahrbuch fur Mineralogie, Abhandlungen","1993","165","","245","266","","","","","","","","","","","","","","","","","","","","","","has coordinates","283960","2023-05-23","08:42:10",""
"9016586","15.99","","15.99","","7.195","","90","","90","","120","","1593.16","","","","","","","","","","","","York River, Hastings Co., Ontario, Canada","11","R 3 m :H","R 3 -2""","160","","","Shorl","- Al6.24 B3.09 F0.19 Fe1.939 H3.41 Li0.021 Mg0.7 Na0.96 O30.81 Si5.802 Ti0.208 -","- Al6.24 B3.09 F0.19 Fe1.9392 H3.41 Li0.021 Mg0.6996 Na0.96 O30.81 Si5.802 Ti0.2082 -","- Al18.72 B9.27 F0.57 Fe5.8176 H10.23 Li0.063 Mg2.0988 Na2.88 O92.43 Si17.406 Ti0.6246 -","3","0.166667","","Grice, J. D.; Ercit, T. S.","Ordering of Fe and Mg in the tourmaline crystal structure: The correct formula Sample: Shorl 49356","Neues Jahrbuch fur Mineralogie, Abhandlungen","1993","165","","245","266","","","","","","","","","","","","","","","","","","","","","","has coordinates","283911","2023-05-21","08:37:46",""
"9016653","16.186","","16.186","","7.444","","90","","90","","120","","1688.95","","","","","","","","","","","","San Francisco mine, Villa Tu nari, Bolivia","10","R 3 m :H","R 3 -2""","160","","","Povondraite","- Al0.32 B3.06 Fe6.82 H3.3 K0.26 Mg1.85 Na0.79 O31 Si5.94 V0.01 -","- Al0.3198 B3.06 Fe6.8202 H3.3 K0.26 Mg1.8501 Na0.79 O31 Si5.94 V0.0099 -","- Al0.9594 B9.18 Fe20.4606 H9.9 K0.78 Mg5.5503 Na2.37 O93 Si17.82 V0.0297 -","3","0.166667","","Grice, J. D.; Ercit, T. S.","Ordering of Fe and Mg in the tourmaline crystal structure: The correct formula Sample: Povondraite 144478","Neues Jahrbuch fur Mineralogie, Abhandlungen","1993","165","","245","266","","","","","","","","","","","","","","","","","","","","","","has coordinates","285095","2023-07-08","07:47:59",""
"9016720","15.999","","15.999","","7.236","","90","","90","","120","","1604.04","","","","","","","","","","","","Pierrepont, St, Lawrence Co., New York, USA","11","R 3 m :H","R 3 -2""","160","","","Fluor-dravite","- Al5.29 B3 Ca0.301 F0.42 Fe H3.28 Mg2.7 Na0.713 O30.58 Si5.94 Ti0.06 -","- Al5.2902 B3 Ca0.301 F0.42 Fe1.0002 H3.28 Mg2.7 Na0.713 O30.58 Si5.94 Ti0.06 -","- Al15.8706 B9 Ca0.903 F1.26 Fe3.0006 H9.84 Mg8.1 Na2.139 O91.74 Si17.82 Ti0.18 -","3","0.166667","","Grice, J. D.; Ercit, T. S.","Ordering of Fe and Mg in the tourmaline crystal structure: The correct formula Sample: Dravite 43873","Neues Jahrbuch fur Mineralogie, Abhandlungen","1993","165","","245","266","","","","","","","","","","","","","","","","","","","","","","has coordinates","283911","2023-05-21","08:37:46",""