MufasaBottom validators eclipsce score
    Updated 2023-02-08
    /*SQL CREDIT: https://app.flipsidecrypto.com/velocity/queries/cbf599a4-0b81-4d3c-aceb-733424ba3f5b */
    WITH
    votes as (
    SELECT
    voter as label,
    COUNT(distinct tx_id) as n_votes
    FROM terra.core.fact_governance_votes
    -- WHERE NOT delegator_address is NULL
    GROUP by 1
    ),
    blocks as (
    SELECT
    voter as label,
    max(block_id) - MIN(block_id) AS block_duration
    from terra.core.fact_governance_votes
    GROUP by 1
    ),
    -- thanks to jackguy for getting val_addresses
    validator_addresses as (
    SELECT *
    FROM values
    ('terravaloper188e99yz54744uhr8xjfxmmplhnuw75xea55zfp', 'terra188e99yz54744uhr8xjfxmmplhnuw75xeamclej'),
    ('terravaloper120ppepaj2lh5vreadx42wnjjznh55vvktp78wk', 'terra120ppepaj2lh5vreadx42wnjjznh55vvktwj679'),
    ('terravaloper1lelhxdzwn9ddecv6sv0kcxj5tguurxnzcfs5wf', 'terra1lelhxdzwn9ddecv6sv0kcxj5tguurxnzcxuf76'),
    ('terravaloper1kxyzu575tex8dv6d5uk26t4q8x5lusw082w3t8', 'terra1kxyzu575tex8dv6d5uk26t4q8x5lusw089zvm5'),
    ('terravaloper1rr2g4z2ch4cqwl8s70yj94a5l2vakg0v36nmjh', 'terra1rr2g4z2ch4cqwl8s70yj94a5l2vakg0v34lxzy'),
    ('terravaloper1gtw2uxdkdt3tvq790ckjz8jm8qgwkdw3uptstn', 'terra1gtw2uxdkdt3tvq790ckjz8jm8qgwkdw3uw8dmq'),
    ('terravaloper183kevvgrqvav9sa0lwzhr54jngxw6sac90jvs2', 'terra183kevvgrqvav9sa0lwzhr54jngxw6sac9q73qe'),
    ('terravaloper1ge3vqn6cjkk2xkfwpg5ussjwxvahs2f6at87yp', 'terra1ge3vqn6cjkk2xkfwpg5ussjwxvahs2f6aytr5j'),
    ('terravaloper14rw9dq3tj9y0k9pg2jquh922fdv5nupr0nn7k8', 'terra14rw9dq3tj9y0k9pg2jquh922fdv5nupr0ulrx5'),
    ('terravaloper1cqc26lnatzxvu0z5nd4yx8m4ecllkm7jlakwrw', 'terra1cqc26lnatzxvu0z5nd4yx8m4ecllkm7jlj6nna'),
    ('terravaloper18vnm040mwk0d6plc60v5m9h2376gkcphknuwzs', 'terra18vnm040mwk0d6plc60v5m9h2376gkcphkusnjr'),
    ('terravaloper1tz203ptlsfs8c63f2j0d0872pt5frjrvtfg0vd', 'terra1tz203ptlsfs8c63f2j0d0872pt5frjrvtxyju7'),
    ('terravaloper1ltegerwren4tcaxpwxpkgs94ztnrcu0sk9cajz', 'terra1ltegerwren4tcaxpwxpkgs94ztnrcu0sk25qz3'),
    ('terravaloper1jt8pcx4sesgztjkjsvjjqtvyfgcehqx09u4exq', 'terra1jt8pcx4sesgztjkjsvjjqtvyfgcehqx09neykn'),
    ('terravaloper17kh8ngu3s74epwympaxrp4ukahm5rvtf5zc8ma', 'terra17kh8ngu3s74epwympaxrp4ukahm5rvtf5d56tw'),
    Run a query to Download Data