Skip to main content
All blocks, starting from Cosmos-hub 4 upgrade.

Table Details

PropertyValue
Table Namecosmos.raw.blocks
Table StatusProduction-Ready
Unique Keyheight
Clustering Key(s)to_date("timestamp")
Search Optimizationheight, hash

Table Columns

Column NameData TypeDescription
heightNUMBER(38,0)The sequential number of the block in the blockchain.
timestampTIMESTAMP_NTZ(9)The timestamp when the block was created.
hashVARCHAR(16777216)The hash of the block.
parent_hashVARCHAR(16777216)The hash of the parent block.
proposer_addressVARCHAR(16777216)The address of the proposer who created the block.
transaction_countNUMBER(38,0)The number of transactions included in the block.
consensus_hashVARCHAR(16777216)The hash of the block’s consensus state.
app_hashVARCHAR(16777216)The hash of the application state.
block_idVARIANTThe block identifier as a JSON object.
chain_idVARCHAR(16777216)The identifier of the blockchain.
dataVARIANTThe block data as a JSON object.
data_hashVARCHAR(16777216)The hash of the block’s data.
evidenceVARIANTEvidence associated with the block as a JSON object.
evidence_hashVARCHAR(16777216)The hash of the evidence associated with the block.
last_block_idVARIANTThe previous block identifier as a JSON object.
last_commitVARIANTThe last commit information as a JSON object.
last_commit_hashVARCHAR(16777216)The hash of the last commit.
last_results_hashVARCHAR(16777216)The hash of the last results.
next_validators_hashVARCHAR(16777216)The hash of the next set of validators.
validators_hashVARCHAR(16777216)The hash of the current set of validators.
versionVARIANTThe version information as a JSON object.
block_resultVARIANTThe block result as a JSON object.
block_event_countNUMBER(38,0)The number of block events in the block.
block_event_attribute_countNUMBER(38,0)The number of block event attributes in the block.
_created_atTIMESTAMP_NTZ(9)The timestamp when the entry was created.
_updated_atTIMESTAMP_NTZ(9)The timestamp when the entry was updated.