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

# Blocks

### Table Details

| Property            | Value                   |
| ------------------- | ----------------------- |
| Table Name          | `provenance.raw.blocks` |
| Table Status        | Production-Ready        |
| Unique Key          | `number`                |
| Clustering Key(s)   | `to_date("timestamp")`  |
| Search Optimization | `number`, `hash`        |

### Table Columns

| Column Name            | Data Type         | Description                                           |
| ---------------------- | ----------------- | ----------------------------------------------------- |
| number                 | NUMBER(38,0)      | The sequential number of the block in the blockchain. |
| timestamp              | TIMESTAMP\_NTZ(9) | The timestamp when the block was created.             |
| hash                   | VARCHAR(16777216) | The hash of the block.                                |
| parent\_hash           | VARCHAR(16777216) | The hash of the parent block.                         |
| proposer\_address      | VARCHAR(16777216) | The address of the proposer who created the block.    |
| transaction\_count     | NUMBER(38,0)      | The number of transactions included in the block.     |
| consensus\_hash        | VARCHAR(16777216) | The hash of the block's consensus state.              |
| app\_hash              | VARCHAR(16777216) | The hash of the application state.                    |
| block\_id              | VARIANT           | The block identifier as a JSON object.                |
| chain\_id              | VARCHAR(16777216) | The identifier of the blockchain.                     |
| data\_hash             | VARCHAR(16777216) | The hash of the block's data.                         |
| evidence               | VARIANT           | Evidence associated with the block as a JSON object.  |
| evidence\_hash         | VARCHAR(16777216) | The hash of the evidence associated with the block.   |
| last\_block\_id        | VARIANT           | The previous block identifier as a JSON object.       |
| last\_commit           | VARIANT           | The last commit information as a JSON object.         |
| last\_commit\_hash     | VARCHAR(16777216) | The hash of the last commit.                          |
| last\_results\_hash    | VARCHAR(16777216) | The hash of the last results.                         |
| next\_validators\_hash | VARCHAR(16777216) | The hash of the next set of validators.               |
| validators\_hash       | VARCHAR(16777216) | The hash of the current set of validators.            |
| version                | VARIANT           | The version information as a JSON object.             |
| \_created\_at          | TIMESTAMP\_NTZ(9) | The timestamp when the entry was created.             |
| \_updated\_at          | TIMESTAMP\_NTZ(9) | The timestamp when the entry was updated.             |

### Related Docs

* [COSMOS Raw Blocks](/historical-data/supported-blockchains/cosmos-ecosystem/core-schemas/raw/blocks)