rajs# of Voters and Proposals Voted On
Updated 2023-01-12
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 blockchain,
count(distinct voter) as no_of_voters,
count(distinct proposal_id) as no_of_proposals,
round(count(distinct voter) / count(distinct proposal_id),0) as avg_voters_per_proposal
from cosmos.core.fact_governance_votes
where tx_succeeded
and block_timestamp >= '2022-06-01'
UNION
SELECT
'Osmosis' as blockchain,
count(distinct voter) as no_of_voters,
count(distinct proposal_id) as no_of_proposals,
round(count(distinct voter) / count(distinct proposal_id),0) as avg_voters_per_proposal
from osmosis.core.fact_governance_votes
where tx_succeeded
and block_timestamp >= '2022-06-01'
UNION
SELECT
'Terra' as blockchain,
count(distinct voter) as no_of_voters,
count(distinct proposal_id) as no_of_proposals,
round(count(distinct voter) / count(distinct proposal_id),0) as avg_voters_per_proposal
from terra.core.fact_governance_votes
where tx_succeeded
and block_timestamp >= '2022-06-01'
-- union
-- SELECT
-- 'Terra Classic' as blockchain,
-- count(distinct voter) as no_of_voters,
Run a query to Download Data