select

voter,

min(block_timestamp) as min_date

from osmosis.core.fact_governance_votes

group by 1

),

validators_address as (

SELECT address AS validator_address

, label AS validator_name

, raw_metadata[0]['account_address']::string AS account_address

, raw_metadata[0]['rank']::string AS rank

, raw_metadata[0]['uptime']['address']::string AS proposer_address

FROM osmosis.core.dim_labels

WHERE label_subtype = 'validator'

select

date_trunc('week', min_date) as weekly,

case

when weekly = '2021-12-27' THEN 'Prop #114'

when weekly = '2022-04-04' THEN 'Prop #196'

when weekly = '2022-09-26' THEN 'Prop #337'

else ' '

end as dis,

count(distinct voter) as unique_voter

from first_vote_date join validators_address on account_address = voter

group by 1, 2