> ## 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.

# polkadot.events

> Substrate runtime events across Polkadot, Kusama, and parachain networks.

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 `events` table (e.g. `polkadot.events`) holds all events that occur on the chain, including their pallet `section` and `method`, as well as the decoded data involved in the event.

Common queries on the `events` table will typically filter on `block_time`, `section` and `method` and extract JSON encoded information in
`data` or `decoded_data`.

## Table Schema

| Column           | Type        | Description                                                                   |
| ---------------- | ----------- | ----------------------------------------------------------------------------- |
| `year`           | `INTEGER`   | Calendar year of the block (partition column)                                 |
| `month`          | `INTEGER`   | Calendar month of the block (partition column)                                |
| `section`        | `VARCHAR`   | The pallet (module) that emitted this event (e.g. `Balances`, `System`)       |
| `method`         | `VARCHAR`   | The event method name within the pallet (e.g. `Transfer`, `ExtrinsicSuccess`) |
| `block_time`     | `TIMESTAMP` | The timestamp of the block containing this event                              |
| `block_number`   | `BIGINT`    | The sequential number of the block containing this event                      |
| `extrinsic_id`   | `VARCHAR`   | Identifier of the extrinsic that triggered this event                         |
| `event_id`       | `VARCHAR`   | Unique identifier for this event (format: `blockNumber-eventIndex`)           |
| `data`           | `VARCHAR`   | JSON-encoded event data                                                       |
| `extrinsic_hash` | `VARBINARY` | Hash of the extrinsic that triggered this event                               |
| `block_hash`     | `VARBINARY` | Hash of the block containing this event                                       |
| `data_decoded`   | `VARCHAR`   | Human-readable decoded event data                                             |
| `updated_at`     | `TIMESTAMP` | When this record was last updated in the database                             |
| `ingested_at`    | `TIMESTAMP` | When this record was first ingested into the database                         |

## Table Sample

<TableSample tableSchema="polkadot" tableName="events" />