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

All blocks, starting from genesis.

### Table Details

| Property            | Value                  |
| ------------------- | ---------------------- |
| Table Name          | `dogecoin.raw.blocks`  |
| Table Status        | Production-Ready       |
| Unique Key          | `number`               |
| Clustering Key(s)   | `to_date("timestamp")` |
| Search Optimization | `hash`                 |

All blocks, starting from genesis.

### Table Columns

| Column Name           | Data Type         | Description                                                                                                |
| --------------------- | ----------------- | ---------------------------------------------------------------------------------------------------------- |
| timestamp             | TIMESTAMP\_NTZ(9) | Timestamp indicating when this block was mined.                                                            |
| number                | NUMBER(38,0)      | The number of the block in the blockchain.                                                                 |
| hash                  | VARCHAR(66)       | The unique identifier or hash of the block.                                                                |
| confirmations         | NUMBER(38,0)      | Number of blocks that have been mined after this block, indicating how deeply it is embedded in the chain. |
| version               | NUMBER(38,0)      | The block version number.                                                                                  |
| merkle\_root          | VARCHAR(66)       | The root of the Merkle tree of all transactions in the block, used to verify transaction integrity.        |
| median\_time          | NUMBER(38,0)      | The median timestamp of the last 11 blocks, used for time-lock transactions.                               |
| nonce                 | NUMBER(38,0)      | A 32-bit number that miners change to try to get a valid block hash.                                       |
| bits                  | VARCHAR(16777216) | The encoded difficulty target for this block.                                                              |
| difficulty            | FLOAT             | The difficulty target for this block, indicating how hard it was to mine.                                  |
| chainwork             | VARCHAR(16777216) | The total amount of work that has been done to mine all blocks up to and including this one.               |
| transaction\_count    | NUMBER(38,0)      | The number of transactions included in this block.                                                         |
| previous\_block\_hash | VARCHAR(66)       | The hash of the previous block in the chain.                                                               |
| next\_block\_hash     | VARCHAR(66)       | The hash of the next block in the chain.                                                                   |
| stripped\_size        | NUMBER(38,0)      | The size of the block in bytes, excluding witness data.                                                    |
| size                  | NUMBER(38,0)      | The total size of the block in bytes, including all transaction data.                                      |
| weight                | NUMBER(38,0)      | The block weight, used to measure block size limits in the network.                                        |
| auxpow                | VARIANT           | Auxiliary Proof of Work data, used in merged mining with other cryptocurrencies.                           |
| \_created\_at         | TIMESTAMP\_NTZ(9) | Timestamp of when this record was created in the database.                                                 |
| \_updated\_at         | TIMESTAMP\_NTZ(9) | Timestamp of when this record was last updated in the database.                                            |