flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Algorand Governance
Papasot
Algorand Governance
Updated 2022-01-11
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
with
tot_gov
as
(
select
try_base64_decode_string
(
tx_message
:
txn
:
note
)
as
gov
,
sender
from
ALGORAND
.
PAYMENT_TRANSACTION
where
gov
like
'%gov%'
)
select
count
(
DISTINCT
sender
)
from
tot_gov
Results
Run a query to Download Data