Raw
Blocks
Table Columns
Unique Key: height
| Column Name | Data Type | Description |
|---|---|---|
| height | BIGINT | The sequential number of the block in the blockchain. |
| timestamp | TIMESTAMP_NTZ(9) | The timestamp when the block was created. |
| hash | VARCHAR | The hash of the block. |
| parent_hash | VARCHAR | The hash of the parent block. |
| proposer_address | VARCHAR | The address of the proposer who created the block. |
| transaction_count | BIGINT | The number of transactions included in the block. |
| consensus_hash | VARCHAR | The hash of the block’s consensus state. |
| app_hash | VARCHAR | The hash of the application state. |
| block_id | VARIANT | The block identifier as a JSON object. |
| chain_id | VARCHAR | The identifier of the blockchain. |
| data | VARIANT | The block data as a JSON object. |
| data_hash | VARCHAR | The hash of the block’s data. |
| evidence | VARIANT | Evidence associated with the block as a JSON object. |
| evidence_hash | VARCHAR | The hash of the evidence associated with the block. |
| last_block_id | VARIANT | The previous block identifier as a JSON object. |
| last_commit | VARIANT | The last commit information as a JSON object. |
| last_commit_hash | VARCHAR | The hash of the last commit. |
| last_results_hash | VARCHAR | The hash of the last results. |
| next_validators_hash | VARCHAR | The hash of the next set of validators. |
| validators_hash | VARCHAR | The hash of the current set of validators. |
| version | VARIANT | The version information as a JSON object. |
| block_result | VARIANT | The block result as a JSON object. |
| block_event_count | BIGINT | The number of block events in the block. |
| block_event_attribute_count | BIGINT | The number of block event attributes in the block. |
| _created_at | TIMESTAMP_NTZ(9) | The timestamp when the entry was created. |
| _updated_at | TIMESTAMP_NTZ(9) | The timestamp when the entry was updated. |