# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-12-22T09:55:12+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 'The Canadian Mineralogist') AND volume = 6 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 "9004056","5.61","","14.03","","5.4","","90","","98.38","","90","","420.487","","","","","","","","","","","","","4","P 1 21/n 1","-P 2yn","14","","","Lindgrenite","- Cu3 H2 Mo2 O10 -","- Cu3 H2 Mo2 O10 -","- Cu6 H4 Mo4 O20 -","2","0.5","","Calvert, L. D.; Barnes, W. H.","The structure of lindgrenite","The Canadian Mineralogist","1957","6","","31","51","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:36","" "9004057","10.331","","10.331","","7.343","","90","","90","","120","","678.717","","","","","","","","","","","","","4","P 63/m","-P 6c","176","","","Vanadinite","- Cl O12 Pb5 V3 -","- Cl O12 Pb5 V3 -","- Cl2 O24 Pb10 V6 -","2","0.166667","","Trotter, J.; Barnes, W. H.","The structure of vanadinite","The Canadian Mineralogist","1958","6","","161","173","","","","","","","","","","","","","","","","","","","","","","has coordinates","291351","2024-04-25","15:50:32","" "9004058","6.21","","7.06","","7.76","","92.97","","96.65","","105.78","","323.957","","","","","","","","","","","","Thompson's, Utah, USA","3","P -1","-P 1","2","","","Metarossite","- Ca O8 V2 -","- Ca O8 V2 -","- Ca2 O16 V4 -","2","1","","Kelsey, C. H.; Barnes, W. H.","The crystal structure of metarossite","The Canadian Mineralogist","1960","6","","448","466","","","","","","","","","","","","","","","","","","","","","","has coordinates","291351","2024-04-25","15:50:32","" "9010518","3.881","","3.881","","6.315","","90","","90","","120","","82.374","","","","","","","","","","","","Llallagua, Bolivia","4","P 63 m c","P 6c -2c","186","","","Wurtzite-2H","- Fe0.25 Mn0.25 S Zn0.5 -","- Fe0.25 Mn0.25 S Zn0.5 -","- Fe0.5 Mn0.5 S2 Zn -","2","0.166667","","Mloszewski, M. J.; Saha, A. K.; Nuffield, E. W.","Manganoan ferroan wurtzite from Llallagua, Bolivia (II)","The Canadian Mineralogist","1957","6","","136","139","","","","","","","","","","","","","","","","","","","","","","has coordinates","291792","2024-05-09","08:53:45","" "9013304","3.8754","","3.8754","","6.3276","","90","","90","","120","","82.301","","","","","","","","","","","","Llallagua, Bolivia","4","P 63 m c","P 6c -2c","186","","","Wurtzite-2H","- Fe0.26 Mn0.31 S Zn0.43 -","- Fe0.26 Mn0.31 S Zn0.43 -","- Fe0.52 Mn0.62 S2 Zn0.86 -","2","0.166667","","Mloszewski, M. J.; Saha, A. K.; Nuffield, E. W.","Manganoan ferroan wurtzite from Llallagua, Bolivia (II)","The Canadian Mineralogist","1957","6","","136","139","","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:49",""