binhachon4. Governance Period 1 Breakdown - Filter answer
    Updated 2022-01-08
    with vote as (
    select
    block_id,
    sender,
    base64_decode_string(tx_message:txn:note::string) as note,
    substr(note, position('[', note, 1)) as vote,
    row_number() over (partition by sender order by block_id desc) as rownumber
    from algorand.payment_transaction
    where receiver = 'GULDQIEZ2CUPBSHKXRWUW7X3LCYL44AI5GGSHHOQDGKJAZ2OANZJ43S72U'
    and amount is null
    and note like '%af/gov1:j[3,%'
    qualify rownumber = 1
    )
    select distinct vote, position(',', vote, 1), substr(vote, position(',', vote, 1) + 2, 1) from vote

    Run a query to Download Data