DATE(block_timestamp) as dayz,

event_inputs:proposalId as proposal,

event_inputs:voter::string as voters,

event_inputs:votes::float as vote_counts,

CASE

when event_inputs:support = '0' then 'against'

when event_inputs:support = '1' then 'support'

when event_inputs:support = '2' then 'abstain'

end as choice

from ethereum.core.fact_event_logs

where contract_address = lower('0x6f3e6272a167e8accb32072d08e0957f9c79223d')

and event_name = 'VoteCast'

and tx_status = 'SUCCESS'),

T2 AS ( select

event_inputs:id as id,

regexp_substr(event_inputs:description, '#{1}.+?(\n\n)',1, 1) as title

from ethereum.core.fact_event_logs

where contract_address = lower('0x6f3e6272a167e8accb32072d08e0957f9c79223d') -- NounDAOProxy, the rest is just Gnosis Safe Multisig using a `delegate_call`

and event_name = 'ProposalCreated'

and tx_status = 'SUCCESS')

select

T1.proposal,

case

when T1.proposal = '1' then '#Donate 5 ETH each to 6 Charities'

when T1.proposal = '2' then '#3D Nouns Generator'

when T1.proposal = '4' then '#Verbs Prop #1: NOUN O CLOCK AUTOMATION APP'

when T1.proposal = '5' then '#Set Proposal Threshold to 100 bps (1%)'

when T1.proposal = '7' then '#NOUNS x NOIR'

when T1.proposal = '8' then '#FOMO Nouns'

when T1.proposal = '12' then '#Perpetual Glasses to Kids In Need V2'

else T2.title end as titles,

choice,

count(distinct T1.voters) as voter,