Skip to content


The bitcoin.blocks table provides indexed views of all blocks.


Name Type Description
bits text The value of the nBits field in the block header.
block_hash text The hash of the block.
block_number integer The block number.
chainwork text The chainwork of the block.
difficulty numeric The estimated amount of work done to find this block relative to block 0.
median_timestamp timestamp The median timestamp of the block (in ISO-8601 format).
merkleroot text The Merkle root of the block.
nonce float The number adjusted by miners to find a block hash that meets the network's specified difficulty target.
parent_blockhash text The hash of the parent block.
size integer The size of the block.
stripped_size integer The size of the block excluding witness data.
timestamp timestamp The timestamp of the block (in ISO-8601 format).
transaction_count integer The number of transactions in the block.
version integer The version of the block.
version_hex text The version in hex format.
weight integer The weight of the block as defined in BIP-141.
__confirmed boolean Flag indicating whether the block has been confirmed.


__confirmed WHERE __confirmed = false

Got questions? Join our Discord

Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.