Voted Account | |
|---|---|
1 | 173023 |
SocioAnalyticanumber of delegator voted
Updated 2024-02-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with json as (
SELECT livequery.live.udf_api ('https://api.flipsidecrypto.com/api/v2/queries/92d28ac2-933b-44e6-98c1-c61bac6eebc3/data/latest') as resp
)
,
account as (
SELECT value:ADDRESS as address,
value:ACCOUNT_ADDRESS as account_address
FROM json,
LATERAL FLATTEN(input => resp:data)
)
SELECT
count(DISTINCT voter) as "Voted Account"
FROM cosmos.gov.fact_governance_votes
WHERE voter not in (SELECT account_address FROM account)
AND proposal_id = 848
Last run: about 1 year agoAuto-refreshes every 3 hours
1
10B
3s