> ## 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 | `kava.raw.blocks` |
| Table Status | Beta 🌱 |
| Unique Key | `timestamp`, `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)