rahopocket
Updated 2023-02-24
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
›
⌄
with named as (
select
case
when vote_option = ['1'] then 'Approve'
when vote_option = ['2'] then 'Reject'
when vote_option = ['3'] then 'Abstain'
when vote_option is null then 'Did Not Vote'
end as vote_choice,
*
from ethereum.core.ez_snapshot
where space_id = 'pokt-network'
),
all_votes as(
select
date(proposal_start_time) as proposal_started,
proposal_title,
replace(proposal_title,',','' ) as proposal_title1,
replace(proposal_title1,'-','' ) as proposal_title2,
voter,
vote_choice
from named
)
select
proposal_started as "Start Date",
proposal_title2 as "Proposal",
voter as "Voter",
vote_choice as "Vote Choice"
from all_votes
where "Proposal" = 'PEP48: Quarterly Reporting through Messari Protocol Services'
order by proposal_started desc
Run a query to Download Data