select
parse_json(ARGS):id as proposal_id,
parse_json(ARGS):vote as result,
count(DISTINCT tx_hash) as voting_count
from
near.core.fact_actions_events_function_call
-- where tx_hash='6jvmPhVXN1pKsF2zxCieQHWWUJnhgS2nMo9LQfrRs3fn'
where
METHOD_NAME = 'vote'
and ARGS ilike '%vote%'
group by
1,
2