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

### Table Columns

| Column Name        | Data Type         | Description                                                                                                                      |
| ------------------ | ----------------- | -------------------------------------------------------------------------------------------------------------------------------- |
| height             | NUMBER(38,0)      | The block number (height) in the chain.                                                                                          |
| timestamp          | TIMESTAMP\_NTZ(9) | The time when the block was produced.                                                                                            |
| hash               | VARCHAR(16777216) | Unique identifier (BLAKE2b-256 hash) of the block.                                                                               |
| previous\_block    | VARCHAR(16777216) | Hash of the preceding block in the chain.                                                                                        |
| next\_block        | VARCHAR(16777216) | Hash of the following block in the chain.                                                                                        |
| epoch              | NUMBER(38,0)      | The epoch number (a 5-day period of 432,000 slots) in which the block was produced.                                              |
| slot               | NUMBER(38,0)      | The absolute slot number in which the block was produced.                                                                        |
| epoch\_slot        | NUMBER(38,0)      | The position of the slot within its epoch, ranging from 0 to 431,999.                                                            |
| slot\_leader       | VARCHAR(16777216) | The stake pool or genesis key hash of the node that produced this block.                                                         |
| block\_vrf         | VARCHAR(16777216) | The verifiable random function (VRF) key hash used to verify the slot leader's authority to produce this block.                  |
| op\_cert           | VARCHAR(16777216) | The operational certificate proving the stake pool operator's authority to produce blocks, signed by the pool's cold key.        |
| op\_cert\_counter  | NUMBER(38,0)      | The issue counter for the operational certificate, used to invalidate compromised KES keys (higher values supersede lower ones). |
| size               | NUMBER(38,0)      | The size of the block in bytes.                                                                                                  |
| fees               | NUMBER(38,0)      | Total transaction fees collected in this block, in lovelace.                                                                     |
| output             | VARCHAR(16777216) | Total output value of all transactions in this block, in lovelace.                                                               |
| confirmations      | NUMBER(38,0)      | Number of blocks that have been produced after this block.                                                                       |
| transactions       | VARIANT           | Array of transaction hashes included in this block.                                                                              |
| transaction\_count | NUMBER(38,0)      | Number of transactions included in this block.                                                                                   |
| \_created\_at      | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database.                                                                         |
| \_updated\_at      | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database.                                                                    |