freemartianValidator Votes in Recent Proposals
    Updated 2022-11-23
    with validators as (
    select
    label,
    raw_metadata[0]['account_address']::string as validator
    from osmosis.core.dim_labels
    where label_subtype = 'validator'
    )
    select
    count(distinct tx_id) as vote_count,
    count(distinct voter) as voter_count,
    proposal_id
    from osmosis.core.fact_governance_votes
    where proposal_id > 350
    and TX_STATUS = 'SUCCEEDED'
    and voter in (select validator from validators)
    group by proposal_id

    Run a query to Download Data