Blocks
The bitcoin.blocks table provides indexed views of all blocks.
Columns
| 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. |
Indexes
| Index |
|---|
| block_number |
| timestamp |
| __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.