Table Description
Contains enriched delegated representative (DRep) voting power distribution data for the Cardano blockchain. Each row represents a DRep’s delegated stake for a given epoch, including their type, on-chain ID, activity status, and optional human-readable name sourced from anchor metadata. This table is central to analyzing Cardano’s on-chain governance participation under CIP-1694.Column Descriptions
| Column | Description | Type |
|---|---|---|
| drep_hash | The hash identifier of the DRep. | varchar |
| drep_type | The type of DRep (e.g., key hash, script hash, abstain, no confidence). | varchar |
| drep_id | The bech32-encoded DRep ID. | varchar |
| amount | The total voting power delegated to this DRep, in lovelace. | bigint |
| epoch | The epoch number for this distribution snapshot. | integer |
| active_until | The last epoch in which this DRep is considered active. | integer |
| expiry | The epoch at which this DRep’s registration expires if not renewed. | integer |
| anchor_url | The URL pointing to the DRep’s off-chain metadata. | varchar |
| drep_name | Human-readable name of the DRep, sourced from anchor metadata. | varchar |
| _updated_at | The time when this record was last updated. | timestamp |
| _ingested_at | The time when this record was ingested into Dune. | timestamp |