cardano.gov_action_vote

Description of the gov_action_vote table on Dune

Table Description

Contains votes cast on Cardano governance action proposals. Under CIP-1694, three groups can vote: Delegated Representatives (DReps), Stake Pool Operators (SPOs), and the Constitutional Committee. Each row represents a single vote, including the voter role, the governance action being voted on, and the vote cast (yes, no, or abstain).

Column Descriptions

Column	Description	Type
tx_hash	The hash of the transaction containing this vote.	varchar
vote_index	The index of the vote within the transaction.	integer
tx_index	The index of the transaction within the block.	integer
slot	The absolute slot number when the vote was cast.	bigint
voter_role	The role of the voter (e.g., DRep, SPO, ConstitutionalCommittee).	varchar
voter_hash	The hash identifying the voter (DRep credential, pool hash, or CC member hash).	varchar
gov_action_tx_hash	The hash of the transaction that submitted the governance proposal being voted on.	varchar
gov_action_index	The index of the governance proposal within its submission transaction.	integer
vote	The vote cast (e.g., Yes, No, Abstain).	varchar
anchor_url	The URL pointing to off-chain rationale for the vote.	varchar
anchor_hash	The hash of the content at the anchor URL.	varchar
epoch	The epoch in which the vote was cast.	integer
block_number	The sequential number of the block containing this vote.	bigint
block_time	The timestamp of the block containing this vote.	timestamp
_updated_at	The time when this record was last updated.	timestamp
_ingested_at	The time when this record was ingested into Dune.	timestamp

Table Sample