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 |