llama_snapshot AS (

SELECT

date(proposal_start_time) AS Proposal_StartDate,

ss.voter,

proposal_author,

vote_option,

voting_power,

proposal_title,

replace(proposal_title, ',', '') AS prop_title,

space_id,

llamavoters.llama_voters

FROM

ethereum.core.ez_snapshot ss

LEFT JOIN (

SELECT

voter,

CASE

WHEN voter = '0x64cc60a9f6f97ddcb8ac1378da9390b85be6da37' THEN 'Balancer Delegate Addy'

WHEN voter = '0x10d6d2e343281d388291a3e02f3293aaeda67178' THEN 'Shreyas personal'

WHEN voter = '0xc290cfb8d020c0615e9c63036f4319cc41717e68' THEN 'Matthew Graham Personal'

WHEN voter = '0x5b3bffc0bcf8d4caec873fdcf719f60725767c98' THEN 'llamagov.eth'

WHEN voter = '0xa519a7ce7b24333055781133b13532aeabfac81b' THEN 'llamacommunity.eth'

WHEN voter = '0x16645967f660ac05ea542d3de2f46e41b86436d9' THEN 'Llama (Balancer Delegated VP)'

WHEN voter = '0x82cd339fa7d6f22242b31d5f7ea37c1b721db9c3' THEN 'governancehouse.eth'

WHEN voter = '0x38dd92603544881ff92d6236c1d257886e249dbb' THEN 'delegate2.governancehouse.eth'

WHEN voter = '0x3079434502949d1bd06f82b76417769cd73382be' THEN 'delegate3.governancehouse.eth'

WHEN voter = '0x066bd6fde8685b1a69109ea512fa58a1f07700cb' THEN 'delegate4.governancehouse.eth'

WHEN voter = '0x55b16934c3661e1990939bc57322554d9b09f262' THEN 'delegate.indexcoop (Aave)'

WHEN voter = '0xe0e7ee036a7ed4a7699f8e137b5de5eff15e1801' THEN 'nouns.llamagov.eth'

END AS llama_voters

FROM

ethereum.core.ez_snapshot

) llamavoters ON ss.voter = llamavoters.voter

WHERE

llama_voters IS NOT NULL