> ## 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" />