> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# dune.shot.dataset_proposals_view

> Snapshot governance proposals — proposal text, voting options, and results.

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

## Table description

The `dune.shot.dataset_proposals_view` table provides a comprehensive view of all governance proposals made on Snapshot.

## Table Schema

| Column Name | Type | Description |
| - | - | - |
| id | varbinary | Unique identifier of the proposal |
| app | varchar | Application or client used to create the proposal |
| end | bigint | Unix timestamp when voting ends |
| body | varchar | Full markdown body/description of the proposal |
| ipfs | varchar | IPFS hash of the proposal data |
| type | varchar | Voting type (e.g. `single-choice`, `weighted`, `ranked-choice`, `approval`) |
| space | varchar | Snapshot space (DAO) the proposal belongs to |
| start | bigint | Unix timestamp when voting begins |
| title | varchar | Title of the proposal |
| votes | bigint | Total number of votes cast on the proposal |
| author | varbinary | Address of the proposal creator |
| quorum | double | Minimum voting power required for the proposal to pass |
| scores | varchar | JSON-encoded final scores for each choice |
| symbol | varchar | Token symbol used for voting power display |
| choices | varchar | JSON-encoded array of available voting choices |
| created | bigint | Unix timestamp when the proposal was created |
| flagged | bigint | Flag indicating if the proposal has been flagged (1 = flagged) |
| network | varchar | Blockchain network ID used for strategy execution |
| plugins | varchar | JSON-encoded plugin configurations |
| privacy | varchar | Privacy mode for the vote (e.g. `shutter` for encrypted voting) |
| updated | bigint | Unix timestamp of the last update |
| snapshot | bigint | Block number snapshot used for voting power calculation |
| discussion | varchar | URL to an external discussion thread |
| strategies | varchar | JSON-encoded array of voting strategies |
| validation | varchar | JSON-encoded validation settings for proposal creation |
| scores\_state | varchar | State of score calculation (e.g. `final`) |
| scores\_total | double | Sum of all voting power across all choices |
| scores\_updated | bigint | Unix timestamp when scores were last updated |
| scores\_by\_strategy | varchar | JSON-encoded breakdown of scores by each strategy |

## Table Sample

<TableSample tableSchema="dune.shot" tableName="dataset_proposals_view" />


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.