flipside

    Comparison of Proposal 362 vs Other Recent Osmosis Proposals (Voters Count) Comparison of Proposal 362 vs Other Recent Osmosis Proposals (Votes Count)
    superflyComparison of Proposal 362 vs Other Recent Osmosis Proposals (Voters Count) Comparison of Proposal 362 vs Other Recent Osmosis Proposals (Votes Count)
    Updated 2022-11-23
    select proposal_id,
    case when proposal_id = '362' then 'Proposal #362' else 'Other Recent Proposals' end as proposalID,
    count (distinct tx_id) as Votes_Count,
    count (distinct voter) as Voters_Count
    from osmosis.core.fact_governance_votes
    where proposal_id::numeric >= '300' and proposal_id::numeric <= '365'
    and tx_status = 'SUCCEEDED'
    group by 1,2
    order by 3 desc
    Run a query to Download Data