rahoSpartan Council: Burt Rock Votes
Updated 2023-04-13
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
›
⌄
-- 344 proposals total as of 10/3/2022
with all_votes as(
select
date(proposal_start_time) as Proposal_Start_Date,
proposal_id as ID,
proposal_title as Title,
voter as Voter,
vote_option as Choice,
voting_power as Power,
choices as Options
from ethereum.core.ez_snapshot
where (space_id = 'snxgov.eth')
order by Proposal_Start_Date desc, Title
),
total_proposals as(
select
count(distinct Title)
from all_votes
),
participation as(
select
Proposal_Start_Date,
Title,
Voter,
Choice
from all_votes
where Voter = lower('0x1f2B0633BB0623dCCebE57932d6731Ae93f5213E')
),
votes_cast as(
select
1 as index,
Run a query to Download Data