alleriaVotings Participated
    Updated 2022-03-13
    WITH
    validators as (
    SELECT
    block_timestamp,
    address,
    voting_power,
    CASE
    WHEN label is not NULL THEN label
    WHEN address = 'terravalcons15t3y60h8ksl3tv092ckadwnd9w5hma3wcmr763' THEN 'Aardvark'
    WHEN address = 'terravalcons1zsvyx9rdh00rv36sztq08myd4stq7ffz23hzar' THEN 'Centauri Alpha'
    WHEN address = 'terravalcons1enftlk6mfdavh8dxhg8xy90x3zwwhk9ze4qqvg' THEN 'BinanceStaking'
    WHEN address = 'terravalcons1rgpc7r52x0h32cy9zv4nggwk58qfpr25pvfh80' THEN 'ISS'
    WHEN address = 'terravalcons1x2fhvphvydds7kmjszz3dc47rjgxy2cme9zng7' THEN 'InfStones'
    WHEN address = 'terravalcons18aay4ef20xqf299ke3dz20ftu53l6c3y84uc2l' THEN 'Galactic Lounge 🥃 🍸 🍹'
    WHEN address = 'terravalcons1p8ud38clwmrrwh5rcfnm34j854ekkdr0n5tatp' THEN 'Neptune Finance'
    WHEN address = 'terravalcons18cjwzj2vm59yqhhr5fhylmt2cn447hkwqye5mu' THEN 'Marte Cloud'
    WHEN address = 'terravalcons1e0u2vrnwas4mmgjtg0w09a74zzsetl4l6rs3ln' THEN 'Rockaway Blockchain Fund'
    WHEN address = 'terravalcons1fu0qzdlpk5rmu2pekgnfsrwj3kk6v7qdcch3hn' THEN 'Sarah Kerrigan'
    WHEN address = 'terravalcons1m6cn7wf79pdkqkw9ttwxx4xfgnr7rpgpzpns29' THEN 'Cives lunares - lunarcitizens.io'
    WHEN address = 'terravalcons1hgp8qnkgee5smv3zqspxemqmnt4zv0w6yyayqq' THEN 'Legend.X'
    WHEN address = 'terravalcons1gp9457xap846zmrnmerh8z9gfcm6uknh2n92fk' THEN 'Craig'
    WHEN address = 'terravalcons1jx3klnpj2vzq34c5mgm7ugjrv2pqck6w3flyue' THEN 'BlockStake.xyz'
    WHEN address = 'terravalcons104dzrr3dn3lsaafa0lnwnn9jdgxyq2lz6tpxyf' THEN 'Un Fuego'
    WHEN address = 'terravalcons197mer307sfmfvtym0lqh04vcysn6w5u2u87xzc' THEN 'Autism Staking 🧩'
    WHEN address = 'terravalcons1ycvcdgxjsfpyprqfvje2kmc74x878xsedvh9jt' THEN 'NITAWA'
    WHEN address = 'terravalcons1h6mjh732mknf7jc2u735d7z9fvrym73k4x6ymk' THEN 'Interdimensional Cable'
    WHEN address = 'terravalcons1dt37n84utdt5xlfpsr39pahwlr725lr46he80d' THEN 'Top Shelf'
    WHEN address = 'terravalcons18vq8kv3ufq6j4pnsas54k4s35nwsmytygukd7d' THEN 'Nexus Event'
    WHEN address = 'terravalcons1eas9520nj257fuhkvvgtn93p8yen7yugs6gyuw' THEN 'Leviathan'
    WHEN address = 'terravalcons1rdrrw755skfvsaxwkkd0e66uvljp3qjq2vefpe' THEN 'Uranus'
    WHEN address = 'terravalcons1c2u65fanzgzem9mrrf7pd47tcpvhu5v6jjdwh9' THEN 'GT Capital'
    WHEN address = 'terravalcons1jg4dcxtevwrz29lfwwpjp5zjnldxxv97c2mlrx' THEN 'Allnodes ⚡️'
    WHEN address = 'terravalcons1hwr4gdh32rmql9dswef6srrh2q6etfq0u4mwek' THEN 'Hypersphere Digital'
    WHEN address = 'terravalcons1lyac8mq6qfyu33wdr9d4lrqgqj5mz970pvsf2g' THEN 'StakeBowl'
    WHEN address = 'terravalcons1lk4v34tuy5lcdnkae8etezlhw8kfv9esmefn98' THEN 'THORchain.BULL & 0xVentures.org'
    WHEN address = 'terravalcons1f4cwud47nqwjc22cfyspdptg2trd5wxwu8scqn' THEN 'The Valhalla Express'
    Run a query to Download Data