dune.shot.dataset_votes_view

Snapshot votes — individual voting records with choice, voting power, and timestamp.

Table description

The dune.shot.dataset_votes_view table provides insights into votes cast on proposals, highlighting voting patterns and outcomes.

Table Schema

Column Name	Type	Description
cb	bigint	Internal cursor/batch identifier
id	varbinary	Unique identifier of the vote
vp	double	Total voting power used for this vote
app	varchar	Application or client used to cast the vote
ipfs	varchar	IPFS hash of the vote data
space	varchar	Snapshot space (DAO) the vote was cast in
voter	varbinary	Address of the voter
choice	varchar	The choice(s) selected by the voter (JSON-encoded for weighted/ranked votes)
reason	varchar	Optional text reason provided by the voter
created	bigint	Unix timestamp when the vote was cast
metadata	varchar	Additional metadata associated with the vote
proposal	varbinary	Identifier of the proposal being voted on
vp_state	varchar	State of voting power calculation (e.g. final)
vp_by_strategy	varchar	Breakdown of voting power by each strategy (JSON-encoded)

Table Sample