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

# Consolidations 🌱

### Table Details

| Property     | Value                             |
| ------------ | --------------------------------- |
| Table Name   | `beacon_hoodi.raw.consolidations` |
| Table Status | Beta 🌱                           |

### Table Columns

| Column Name              | Data Type         | Description                                                                              |
| ------------------------ | ----------------- | ---------------------------------------------------------------------------------------- |
| slot\_number             | NUMBER(38,0)      | Beacon Chain slot number.                                                                |
| slot\_timestamp          | TIMESTAMP\_NTZ(9) | Beacon Chain slot timestamp of slot.                                                     |
| array\_index             | NUMBER(38,0)      | Array index of the flatten consolidations field.                                         |
| source\_address          | VARCHAR(16777216) | The address of the source validator.                                                     |
| source\_pubkey           | VARCHAR(16777216) | The pubkey of the source validator.                                                      |
| source\_validator\_index | NUMBER(38,0)      | The index of the source validator in the validator registry.                             |
| target\_pubkey           | VARCHAR(16777216) | The pubkey of the target validator.                                                      |
| target\_validator\_index | NUMBER(38,0)      | The index of the target validator in the validator registry.                             |
| unique\_id               | VARCHAR(16777216) | Unique ID constructed with slot\_number, array\_index, source\_address & target\_pubkey. |
| \_created\_at            | TIMESTAMP\_NTZ(9) | Timestamp of the consolidation data creation.                                            |
| \_updated\_at            | TIMESTAMP\_NTZ(9) | Timestamp of the consolidation data update.                                              |

### Related Docs

* [Beacon Chain Raw Consolidations](/historical-data/supported-blockchains/evm/beacon-chain/raw/consolidations)