winnie-fs🧈x👻 Snapshot candidate distribution copy copy
Updated 2023-04-26
999
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
›
⌄
-- forked from Owentell / 🧈x👻 Snapshot candidate distribution copy @ https://flipsidecrypto.xyz/Owentell/q/🧈-x-👻-snapshot-candidate-distribution-GJRpyq
-- forked from lajarre / 🧈x👻 Snapshot candidate distribution @ https://flipsidecrypto.xyz/lajarre/q/🧈-x-👻-snapshot-voter-distribution-LJQjX6
with
candidate (number, name) as (
select
*
FROM
VALUES
(1, 'Blockworks Research'),
(2, 'ConsenSys'),
(3, 'Curia'),
(4, 'DAOStewards'),
(5, 'Fire Eyes'),
(6, 'Flipside Crypto'),
(7, 'FranklinDAO'),
(8, 'OnChainCoop'),
(9, 'Oxytocin'),
(10, 'Saludiego201.eth'),
(11, 'StableLab'),
(12, 'TokenLogic'),
(13, 'Wallfacer Labs')
),
vote as (
with
ranked_vote as (
select
proposal_author,
quorum,
vote_option,
vote_timestamp,
voter,
voting_period,
voting_power,
voting_type,
Run a query to Download Data