voter,

CASE

WHEN voter = '0xc4e9e087a811be812f85e49f2a41603d9a0991a9' then 'Kain Warwick?'

WHEN voter = '0xc8c2b727d864cc75199f5118f0943d2087fb543b' then 'QCP Capital'

WHEN voter = '0x27cc4d6bc95b55a3a981bf1f1c7261cda7bb0931' then 'Kain Wariwick?'

when voter = '0x83ffa883ce6cc63be4b7535fdb9ef4e9130f1dda' then 'Snapshot Delegate for 0xE7178Db9e123f053AAbfd2C28520bf6b63cB4A47'

WHEN voter = '0xcf7a68127285c7c6c8546ce51b89d7e820f6d294' then 'Celsius Network'

WHEN voter = '0x6e3aa85db95bba36276a37ed93b12b7ab0782afb' then 'weed.eth'

when voter = '0xc34a7c65aa08cb36744bda8eeec7b8e9891e147c' then 'petemitchell.eth?'

when voter = '0x6db65261a4fc3f88e60b7470e9b38db0b22e785c' then 'First Funded by Coinbase'

when voter = '0x2bde3b9c0129be4689e245ba689b9b0ae4ac666d' then 'therealgodwhale.eth | massive HEX holder'

else null end as label,

sum(voting_power) as voting_power_sum,

count(distinct id) as total_votes,

array_agg(distinct proposal_title) as proposals_voted_on

from external.snapshot.ez_snapshot

where space_id in (

'snxgov.eth',

'spartancouncil.eth',

'synthetix-stakers-poll.eth',

'snxccc.eth',