# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-16T13:56:13+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 = 36 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 "9009436","5.6885","","5.6885","","5.6885","","90","","90","","90","","184.074","","","","","","","","","","","","Wolfsberg, Harz, Germany","3","P 21 3","P 2ac 2ab 3","198","","","Gersdorffite-P213","- As0.82 Ni S1.18 -","- As0.82 Ni S1.18 -","- As3.28 Ni4 S4.72 -","4","0.333333","","Bayliss, P.; Stephenson, N. C.","The crystal structure of gersdorffite","Mineralogical Magazine","1967","36","","38","42","10.1180/minmag.1967.036.277.05","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31","" "9009437","10.96","","10.01","","8.53","","90","","100.4","","90","","920.449","","","","","","","","","","","","","4","C 1 2/c 1","-C 2yc","15","","","Vlasovite","- Na2 O11 Si4 Zr -","- Na2 O11 Si4 Zr -","- Na8 O44 Si16 Zr4 -","4","0.5","","Fleet, S. G.; Cann, J. R.","Vlasovite: a second occurrence and a triclinic to monoclinic inversion","Mineralogical Magazine","1967","36","","233","241","10.1180/minmag.1967.036.278.06","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31","" "9009438","3.13","","3.13","","15.66","","90","","90","","120","","132.865","","","","","","","","","","","","Sweden","5","P 63/m m c","-P 6c 2c","194","","","Sjogrenite","- C0.125 H8 Fe0.25 Mg0.75 O2.875 -","- C0.125 H3.00002 Fe0.25 Mg0.75 O2.87501 -","- C0.25 H6.00004 Fe0.5 Mg1.5 O5.75002 -","2","0.0833333","","Ingram, L.; Taylor, H. F. W.","The crystal structures of sjoegrenite and pyroaurite","Mineralogical Magazine","1967","36","","465","479","10.1180/minmag.1967.036.280.01","","","","","","","","","","","","","","","","","","","","","has coordinates","283911","2023-05-21","08:37:45","" "9009439","3.13","","3.13","","23.49","","90","","90","","120","","199.298","","","","","","","","","","","","Sweden","5","R 3 m :H","R 3 -2""","160","","","Pyroaurite","- C0.125 H8 Fe0.25 Mg0.75 O2.875 -","- C0.125 H3.00002 Fe0.25 Mg0.75 O2.87501 -","- C0.375 H9.00006 Fe0.75 Mg2.25 O8.62503 -","3","0.166667","","Ingram, L.; Taylor, H. F. W.","The crystal structures of sjoegrenite and pyroaurite","Mineralogical Magazine","1967","36","","465","479","10.1180/minmag.1967.036.280.01","","","","","","","","","","","","","","","","","","","","","has coordinates","283911","2023-05-21","08:37:45","" "9009440","9.08","","17.74","","10.25","","90","","124.54","","90","","1360.03","","","","","","","","","","","","","7","C 1 2/m 1","-C 2y","12","","","Epistilbite","- Al3.144 Ca1.296 H18 K0.05 Na0.53 O31.87 Si8.856 -","- Al3.144 Ca1.296 H15.7392 K0.05 Na0.53 O31.8696 Si8.856 -","- Al6.288 Ca2.592 H31.4784 K0.1 Na1.06 O63.7392 Si17.712 -","2","0.25","","Perrotta A J","The crystal structure of epistilbite Locality: Teigarhorn, Iceland","Mineralogical Magazine","1967","36","","480","490","10.1180/minmag.1967.036.280.02","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31","" "9011789","7.85","","5.8","","8.7","","90","","111","","90","","369.801","","","","","","","","","","","","Tsumeb, South West Africa","6","P 1 21/m 1","-P 2yb","11","","","Tsumebite","- Cu2 H O9 P Pb2 S -","- Cu2 H O9 P Pb2 S -","- Cu4 H2 O18 P2 Pb4 S2 -","2","0.5","","Fanfani, L.; Zanazzi, P. F.","Structural similarities of some secondary lead minerals Note: coordinates of O atoms are from arsentsumebite","Mineralogical Magazine","1967","36","","522","529","10.1180/minmag.1967.036.280.06","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:49",""