flipside

    ProposalID_14_Count
    ramojoProposalID_14_Count
    Updated 2022-06-23
    with voters as(select DISTINCT ORIGIN_FROM_ADDRESS, ORIGIN_TO_ADDRESS, event_name,
    CAST(EVENT_INPUTS:votes AS INT) as votes_power,
    CAST(EVENT_INPUTS:proposalId AS INT) as ProposalID,
    CAST(EVENT_INPUTS:support as int) as Support
    from ethereum.core.fact_event_logs
    where origin_to_address = '0x5d2c31ce16924c2a71d317e5bbfd5ce387854039'
    and event_name = 'VoteCast'
    order by ProposalID asc)
    select count (votes_power) as Total_Votes, votes_power from voters
    where ProposalID = 14
    group by votes_power
    order by votes_power DESC
    Run a query to Download Data