# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-03T03:00:39+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 volume = 25 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",""
"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",""
"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",""