cypherGovernance Votes Differences between Orion.Money and Staking Fund
Updated 2022-01-15
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
›
⌄
with orion_votes as (select
block_timestamp,
tx_id,
cast(proposal_id as int) as int_proposal_id,
voter_address_label,
CASE
when option = 'VOTE_OPTION_NO' then 'no'
when option = 'VOTE_OPTION_YES' then 'yes'
when option = 'No' then 'no'
when option = 'Yes' then 'yes'
when option = 'Abstain' then 'abstain'
end as clean_choice
from terra.gov_vote
where voter = 'terra1259cmu5zyklsdkmgstxhwqpe0utfe5hhyygjdc'),
staking_fund_votes as (select
block_timestamp,
tx_id,
cast(proposal_id as int) as int_proposal_id,
voter_address_label,
CASE
when option = 'VOTE_OPTION_NO' then 'no'
when option = 'No' then 'no'
when option = 'NoWithVeto' then 'no_veto'
when option = 'VOTE_OPTION_YES' then 'yes'
when option = 'Yes' then 'yes'
when option = 'YesWithVeto' then 'yes_veto'
when option = 'VOTE_OPTION_ABSTAIN' then 'abstain'
when option = 'Abstain' then 'abstain'
end as clean_choice
from terra.gov_vote
where voter = 'terra123gn6j23lmexu0qx5qhmgxgunmjcqsx8g5ueq2'),
proposal_info as (
select proposal_id,
title,
Run a query to Download Data