# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-23T11:03:40+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 Journal of the Mineralogical Society (1876- 1968)') 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
"1010863","5.49","","5.49","","5.49","","90","","90","","90","","165.5","","","","","","","","","","","","from Mill Close Mine, Derbyshire","3","","","","","Iron nickel sulfide (0.65/0.35/2)","Bravoite","- Fe0.65 Ni0.35 S2 -","","","","","","Bannister, F A; Hey, M H","Bravoite from Mill Close mine, Derbyshire.","Mineralogical Magazine and Journal of the Mineralogical Society (1876- 1968)","1940","25","","609","615","10.1180/minmag.1940.025.170.05","","","","","","","","","","","","","","","","","","","","","","278158","2022-09-26","15:28:11",""
"1010864","44.06","","76.31","","8.6","","90","","90","","120","","25041.2","","","","","","","","","","","","from the British Museum","3","","","","","Hexalead 14-antimony 27-sulfide","Zinckenite","- Pb6 S27 Sb14 -","","","12","","","Vaux, G; Bannister, F A","The identity of Zinckenite and Keeleyite.","Mineralogical Magazine and Journal of the Mineralogical Society (1876- 1968)","1938","25","","221","227","10.1180/minmag.1938.025.163.06","","","","","","","","","","","","","","","","","","","","","","120071","2020-10-21","18:00:00",""
"1010865","4.38","","4.38","","2.86","","90","","90","","90","","54.9","","","","","","","","","","","","from Elgersburg, Thuringia","3","","","","","Tetrahydrogen dimanganese octamanganese(IV) oxide","Pyrolusite","- H4 Mn10 O20 -","","","","","","Vaux, G; Bennett, H","X-ray studies on Pyrolusite (including Polianite) and Psilomelane.","Mineralogical Magazine and Journal of the Mineralogical Society (1876- 1968)","1937","24","","521","526","10.1180/minmag.1937.024.157.02","","","","","","","","","","","","","","","","","","","","","","120071","2020-10-21","18:00:00",""
"1010866","7.86","","16.62","","5.65","","90","","90","","90","","738.1","","","","","","","","","","","","from Northern Rhodesia.","10","C m c m","-C 2c 2","63","","Aluminium cobalt iron hydrogen manganese magnesium nickel titanium silicate *","Staurolite cobaltiferous","- Al17.01 Co1.93 Fe1.87 H2.26 Mg1.09 Mn0.02 Ni0.2 O47.3 Si7.75 Ti0.11 -","","","8","0.5","","Skerl, A C; Bannister, F A; Groves, A W","Lusakite, a cobalt-bearing silicate from Northern Rhodesia.","Mineralogical Magazine and Journal of the Mineralogical Society (1876- 1968)","1934","23","","598","606","10.1180/minmag.1934.023.146.03","","","","","","","","","","","","","","","","","","","","","","278158","2022-09-26","15:28:11",""
"1010867","18.48","","18.95","","6.54","","90","","89.35","","90","","2290.1","","","","","","","","","","","","","5","","","","","Calcium alumosilicate hydrate *","Scolecite","- Al2 Ca H6 O13 Si3 -","","","8","","","Hey, M H; Bannister, F A","Studies on the Zeolites. Part IX. Scolecite and Metascolecite.","Mineralogical Magazine and Journal of the Mineralogical Society (1876- 1968)","1936","24","","227","253","10.1180/minmag.1936.024.152.02","","","","","","","","","","","","","","","","","","","","","","278158","2022-09-26","15:28:11",""
"1010868","56.7","0.1","6.54","0.02","18.44","0.04","90","","90","0.3","90","","6837.9","","","","","","","","","","","","","6","C 1 2 1","C 2y","5","","Calcium sodium alumosilicate hydrate * e","Mesolite","- Al6 Ca2 H16 Na2 O38 Si9 -","","","8","2","","Hey, M H; Bannister, F A","Studies on the Zeolites. Part V. Mesolite.","Mineralogical Magazine and Journal of the Mineralogical Society (1876- 1968)","1933","23","","421","447","10.1180/minmag.1933.023.143.01","","","","","","","","","","","","","","","","","","","","","","278158","2022-09-26","15:28:11",""
"1010972","19.34","","23.06","","4.95","","90","","90","","90","","2207.6","","","","","","","","","","","","from Switzerland","6","","","","","Calcium silicon aluminium beryllium oxide hydroxide (4/9/2/1/24/4)","Bavenite","- Al2 Be Ca4 H4 O28 Si9 -","","","4","","","Claringbull, G F","Occurences of Bavenite in Switzerland.","Mineralogical Magazine and Journal of the Mineralogical Society (1876- 1968)","1940","25","","495","497","10.1180/minmag.1940.025.168.04","","","","","","","","","","","","","","","","","","","","","","278158","2022-09-26","15:28:11",""
"1010973","34.03999","0.05","34.03999","0.05","17.48999","0.05","90","","90","","90","","20266","","","","","","","","","","","","from the British Museum","9","P 42/m n m","-P 4n 2n","136","","Sodium potassium calcium magnesium manganese aluminium silicate hydrate *","Ashcroftine","- Al4 Ca H16 K Mg Mn Na O26 Si5 -","","","40","2.5","","Hey, M H; Bannister, F A","Studies on the Zeolites. Part IV. Ashcroftine (Kalithomsonite of S. G. Gordon).","Mineralogical Magazine and Journal of the Mineralogical Society (1876- 1968)","1933","23","","305","308","10.1180/minmag.1933.023.140.02","","","","","","","","","","","","","","","","","","","","","","278158","2022-09-26","15:28:11",""
"1011059","10","","10","","6.65","","90","","90","","90","","665","","","","","","","","","","","","artificial","5","P -4 21 m","P -4 2ab","113","","Thallium tecto-20-oxotetraalumohexasilicate pentahydrate","Edingtonite (Tl)","- Al4 H10 O25 Si6 Tl4 -","- Al4 H5 O21.25 Si6 Tl4.0002 -","- Al4 H5 O21.25 Si6 Tl4.0002 -","1","0.125","","Taylor, W H","An X-ray examination of substituted Edingtonites.","Mineralogical Magazine and Journal of the Mineralogical Society (1876- 1968)","1935","24","","208","240","10.1180/minmag.1935.024.151.03","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1011205","8.6","","13.02","","7.22","","90","","116.05","","90","","726.3","","","","","","","","","","","","from Mogok, Upper Burma, (Spencer C)","4","C 1 2/m 1","-C 2y","12","","Potassium tecto-alumotrisilicate","Orthoclase","- Al K O8 Si3 -","- Al K O8 Si3 -","- Al4 K4 O32 Si12 -","4","0.5","","Chao, S H; Hargreaves, A; Taylor, W H","The structure of orthoclase.","Mineralogical Magazine and Journal of the Mineralogical Society (1876- 1968)","1940","25","","498","512","10.1180/minmag.1940.025.168.05","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011215","5.42","0.03","5.42","0.03","11.3","0.3","90","","90","","90","","332","","","","","","","","","","","","from Dinas Castle tungsten mine, Cornwall and synthetic","3","I 41/a m d :1","I 4bw 2bw -1bw","141","","Bismuth tungsten oxide *","Russellite","- Bi4.5 O16 W1.6 -","- Bi4.5 O16 W1.6 -","- Bi4.5 O16 W1.6 -","1","0.03125","","Hey, M H; Bannister, F A","Russellite, a new British mineral","Mineralogical Magazine and Journal of the Mineralogical Society (1876- 1968)","1938","25","","41","55","10.1180/minmag.1938.25.161.01","","","","","","","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00",""
"1011265","6.58","","6.58","","5.93","","90","","90","","90","","256.7","","","","","","","","","","","","from Ural, USSR","3","I 41/a m d :1","I 4bw 2bw -1bw","141","","Zirconium silicate","Zircon","- O4 Si Zr -","- O4 Si Zr -","- O16 Si4 Zr4 -","4","0.125","","Binks, W","The crystalline structure of zircon.","Mineralogical Magazine and Journal of the Mineralogical Society (1876- 1968)","1926","21","","176","187","10.1180/minmag.1926.021.115.06","","","","","","","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00",""
"1011274","9.6","","11.4","","16.84","","90","","69","","90","","1720.6","","","","","","","","","","","","from Scawt Hill, Co. Antrim","4","P 1 21 1","P 2yb","4","","Tetracalcium dialuminium oxide dodecahydrate","Hydrocalumite","- Al2 Ca4 H24 O19 -","","","4","2","","Tilley, C E; Megaw, H D; Hey, M H","Hydrocalumite ((Ca O)4 (Al2 O3) (H2 O)12), a new mineral from Scawt Hill, Co. Antrim.","Mineralogical Magazine and Journal of the Mineralogical Society (1876- 1968)","1934","23","","607","615","10.1180/minmag.1934.023.146.04","","","","","","","","","","","","","","","","","","","","","","278158","2022-09-26","15:28:11",""
"1011334","3.47","","3.47","","6.1","","90","","90","","90","","73.4","","","","","","","","","","","","from Transvaal","2","P 42/m m c","-P 4c 2","131","","Platinum sulfide","Cooperite","- Pt S -","- Pt S -","- Pt2 S2 -","2","0.125","","Bannister, F A; Hey, M H","Determination of minerals in platinum concentrates from the transvall by x-ray methods.","Mineralogical Magazine and Journal of the Mineralogical Society (1876- 1968)","1932","23","","188","206","10.1180/minmag.1932.023.138.05","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011369","4.16","","4.16","","9.54","","90","","90","","120","","143","","","","","","","","","","","","","2","P 31 2 1","P 31 2""","152","","Mercury sulfide","Cinnabar","- Hg S -","- Hg S -","- Hg3 S3 -","3","0.5","","Buckley, H E; Vernon, W S","The cyrstal-structures of the sulphides of mercury.","Mineralogical Magazine and Journal of the Mineralogical Society (1876- 1968)","1925","20","","382","392","10.1180/minmag.1925.020.110.02","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1100010","5.194","","8.996","0.006","20.09599","0.002","90","","95.18","","90","","935.2","","","","","","","","","","","","","6","C 1 2/c 1","-C 2yc","15","","Potassium alumosilicate hydrate *","Muscovite 2M1","- Al2.88 Fe0.12 H2 K O12 Si3 -","- Al2.88 Fe0.12 H3 K O12 Si3 -","- Al11.52 Fe0.48 H12 K4 O48 Si12 -","4","0.5","","Birle, J D; Tettenhorst, R","Refined Muscovite structure","Mineralogical Magazine and Journal of the Mineralogical Society (1876- 1968)","1968","36","","883","886","10.1180/minmag.1968.036.282.24","","","","","","0.12","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""