> ## 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.

# Tipsets 🌱

### Table Details

| Property          | Value                  |
| ----------------- | ---------------------- |
| Table Name        | `filecoin.raw.tipsets` |
| Table Status      | Beta 🌱                |
| Unique Key        | `timestamp`, `height`  |
| Clustering Key(s) | `to_date("timestamp")` |

### Table Columns

| Column Name                  | Data Type         | Description                                                                                                                                    |
| ---------------------------- | ----------------- | ---------------------------------------------------------------------------------------------------------------------------------------------- |
| height                       | NUMBER(38,0)      | The block number (height) in the blockchain.                                                                                                   |
| timestamp                    | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of this record. Alias for block\_timestamp used in tables where the column is named `timestamp` rather than `block_timestamp`. |
| 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                                                                                                   |
| block\_cids                  | VARIANT           | Array of CIDs of all blocks included in this tipset                                                                                            |
| parent\_block\_cids          | VARIANT           | Array of CIDs of the parent tipset's blocks                                                                                                    |
| beacon\_entries              | VARIANT           | Array of Drand randomness beacon entries included in this Filecoin block for verifiable randomness                                             |
| 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                                                                                    |
| block\_cids\_raw             | VARIANT           | Raw byte representation of the block CIDs array                                                                                                |
| parent\_block\_cids\_raw     | VARIANT           | Raw byte representations of the parent block CIDs                                                                                              |
| block\_count                 | NUMBER(38,0)      | Number of blocks in this Filecoin tipset                                                                                                       |
| miner\_count                 | NUMBER(38,0)      | Number of storage miners who produced blocks in this tipset                                                                                    |
| message\_count               | NUMBER(38,0)      | Number of messages included in this Filecoin block or tipset                                                                                   |
| event\_count                 | NUMBER(38,0)      | Number of events emitted by this transaction, block, or receipt.                                                                               |
| event\_attribute\_count      | NUMBER(38,0)      | Number of key-value attributes attached to all events in this transaction.                                                                     |
| \_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.                                                                                  |
| deal\_event\_count           | NUMBER(38,0)      | Number of deal state events recorded for this storage deal                                                                                     |
| fevm\_token\_transfer\_count | NUMBER(38,0)      | Number of EVM-compatible token transfers in this message                                                                                       |