Ali3NDistribution of Votes and Voters By Choice (Cosmos Osmosis Terra)
Updated 2023-02-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
select 'Cosmos' as chain,
case when vote_option = '3' then 'NO'
when vote_option = '4' then 'NO WITH VETO'
when vote_option = '2' then 'ABSTAIN'
when vote_option = '1' then 'YES' end as vote_description,
count (distinct tx_id) as Votes_Count,
count (distinct voter) as Voters_Count
from cosmos.core.fact_governance_votes
where tx_succeeded = 'TRUE'
group by 1,2
union ALL
select 'Osmosis' as chain,
case when vote_option = '3' then 'NO'
when vote_option = '4' then 'NO WITH VETO'
when vote_option = '2' then 'ABSTAIN'
when vote_option = '1' then 'YES' end as vote_description,
count (distinct tx_id) as Votes_Count,
count (distinct voter) as Voters_Count
from osmosis.core.fact_governance_votes
where tx_succeeded = 'TRUE'
group by 1,2
union ALL
select 'Terra' as chain,
case when vote_option = '3' then 'NO'
when vote_option = '4' then 'NO WITH VETO'
when vote_option = '2' then 'ABSTAIN'
when vote_option = '1' then 'YES' end as vote_description,
count (distinct tx_id) as Votes_Count,
count (distinct voter) as Voters_Count
from terra.core.fact_governance_votes
where tx_succeeded = 'TRUE'
group by 1,2
Run a query to Download Data