flipside

    Table 1: Voting on Optimism Proposals by Voter Address or Proposal Id
    0xHaM-dTable 1: Voting on Optimism Proposals by Voter Address or Proposal Id
    Updated 2022-08-20
    with Op_voting_table as (
    SELECT
    VOTE_TIMESTAMP,
    PROPOSAL_ID,
    voter,
    VOTING_POWER,
    PROPOSAL_TITLE as "PROPOSAL TITLE",
    CASE WHEN VOTE_OPTION[0] = '1' then 'Yes' WHEN VOTE_OPTION[0] = '2' then 'No' ELSE 'Abstain' END as vote_type,
    PROPOSAL_TEXT
    from ethereum.core.ez_snapshot
    WHERE NETWORK = 'Optimism Mainnet'
    )
    select *
    from Op_voting_table
    where voter = '{{Voter}}' or PROPOSAL_ID = '{{Proposal_ID}}'
    Run a query to Download Data