> ## 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        | `filecoin.raw.blocks`                            |
| Table Status      | Beta 🌱                                          |
| Unique Key        | `tipset_timestamp`, `tipset_height`, `block_cid` |
| Clustering Key(s) | `to_date("tipset_timestamp")`                    |

### Table Columns

| Column Name                          | Data Type         | Description                                                                                                                 |
| ------------------------------------ | ----------------- | --------------------------------------------------------------------------------------------------------------------------- |
| tipset\_height                       | NUMBER(38,0)      | Filecoin tipset height (block height). A tipset is a set of blocks at the same height that form the canonical chain.        |
| tipset\_timestamp                    | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the Filecoin tipset.                                                                                     |
| block\_cid                           | VARCHAR(16777216) | Content identifier (CID) of this Filecoin block, used as the block's unique address in the content-addressed storage system |
| block\_index                         | NUMBER(38,0)      | Position of this block within the tipset's block array                                                                      |
| miner                                | VARCHAR(16777216) | The address of the beneficiary to whom the mining rewards were given.                                                       |
| bls\_aggregate                       | VARIANT           | Aggregated BLS signature covering all BLS-signed messages in this block                                                     |
| beacon\_entries                      | VARIANT           | Array of Drand randomness beacon entries included in this Filecoin block for verifiable randomness                          |
| block\_sig                           | VARIANT           | Block producer's BLS signature over this block                                                                              |
| election\_proof                      | VARIANT           | Winning proof-of-spacetime ticket that qualified this miner to produce a block in this epoch                                |
| fork\_signalling                     | NUMBER(38,0)      | Miner-signalled value for network upgrade voting                                                                            |
| messages\_root                       | VARIANT           | CID of the AMT (Array Mapped Trie) containing all messages in this block                                                    |
| parent\_base\_fee                    | NUMBER(38,0)      | Base fee of the parent tipset (attoFIL per gas unit), used to compute this tipset's base fee                                |
| parent\_weight                       | NUMBER(38,0)      | Cumulative chain weight at the parent tipset                                                                                |
| parent\_message\_receipts            | VARIANT           | CID of the parent message receipts AMT                                                                                      |
| parent\_state\_root                  | VARIANT           | CID of the state tree root after applying the parent tipset                                                                 |
| parent\_block\_cids                  | VARIANT           | Array of CIDs of the parent tipset's blocks                                                                                 |
| ticket                               | VARIANT           | Miner's randomness ticket used to determine leader election eligibility                                                     |
| winning\_proof\_of\_spacetime\_proof | VARIANT           | Winning proof-of-spacetime submitted by the miner to claim the block reward for this epoch                                  |
| block\_cid\_raw                      | VARCHAR(16777216) | Raw bytes of the block CID before CID encoding                                                                              |
| messages                             | VARIANT           | Array of messages emitted or received in this transaction.                                                                  |
| message\_count                       | NUMBER(38,0)      | Number of messages included in this Filecoin block or tipset                                                                |
| \_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.                                                               |