| BLOCK_NUMBER | NUMBER | Also known as block height. The block number, which indicates the length of the blockchain, increases after the addition of each new block. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block was produced. |
| NETWORK | TEXT | The network on the blockchain used by a transaction. |
| BLOCKCHAIN | TEXT | The blockchain on which transactions are being confirmed. |
| TX_COUNT | NUMBER | Total number of transactions within a block. |
| DIFFICULTY | NUMBER | The effort required to mine the block. |
| TOTAL_DIFFICULTY | NUMBER | Total difficulty of the chain at a given block. |
| EXTRA_DATA | TEXT | Any data included by the miner for a given block. |
| GAS_LIMIT | NUMBER | Total gas limit provided by all transactions in the block. |
| GAS_USED | NUMBER | Total gas used in the block or transaction. |
| Note: this may be null for the transactions that are reverted, as described in the docs landing page. | | |
| MINER | TEXT | Miner who successfully added a given block to the blockchain. |
| NONCE | NUMBER | Block nonce is a value used during mining to demonstrate proof of work for a given block. |
| PARENT_HASH | TEXT | The hash of the block from which a given block is generated. Also known as the parent block. |
| HASH | TEXT | Block hash is a unique 66-character identifier that is generate when a block is produced. |
| RECEIPTS_ROOT | TEXT | The root of the state trie. |
| SHA3_UNCLES | TEXT | The mechanism which Aurora encodes an empty string. |
| SIZE | NUMBER | Block size, which is determined by a given block’s gas limit. |
| UNCLE_BLOCKS | VARIANT | Uncle blocks occur when two blocks are mined and broadcasted at the same time, with the same block number. The block validated across the most nodes will be added to the primary chain, and the other one becomes an uncle block. Miners do receive rewards for uncle blocks. |
| BLOCK_HEADER_JSON | OBJECT | This JSON column contains the block header details. |
| FACT_BLOCKS_ID | TEXT | A uniquely generated identifier assigned by a surrogate key |
| INSERTED_TIMESTAMP | TIMESTAMP_LTZ | The timestamp at which the record was initially created and inserted into this table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_LTZ | The timestamp at which this record was last modified by an internal process. |
