> ## 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          | `celestia.raw.blocks`  |
| Table Status        | Production-Ready       |
| Unique Key          | `height`               |
| Clustering Key(s)   | `to_date("timestamp")` |
| Search Optimization | `height`, `hash`       |

### Table Columns

| Column Name                    | Data Type         | Description                                           |
| ------------------------------ | ----------------- | ----------------------------------------------------- |
| height                         | 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                           | VARIANT           | The block data as a JSON object.                      |
| 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.             |
| block\_result                  | VARIANT           | The block result as a JSON object.                    |
| block\_event\_count            | NUMBER(38,0)      | The number of block events in the block.              |
| block\_event\_attribute\_count | NUMBER(38,0)      | The number of block event attributes in the block.    |
| \_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)