Bitcoin Dataset
This is the Bitcoin chain dataset provided by Nodit Datashare. You can review the table structure of the loaded data along with the primary key and columns for each table. This information lets you understand the types and structure of data you can extract using Datashare.
Dataset
This is the Bitcoin chain dataset available in Nodit Datashare. Select the dataset you need to extract data, and refer to Data Schema for the schema of each dataset.
| Table | Description |
|---|---|
blocks | Block data |
transactions | Transaction data |
vins | Transaction input data |
vouts | Transaction output data |
Data Schema
The data schema for each table is listed below. You can check the type and description of each column, the Unique Key for each table, and the filterable columns available for filtering.
blocks
Unique Key: block_height
Filterable Columns: None
| Column | Type | Description |
|---|---|---|
hash | VARCHAR | The unique identifying hash of the block. |
block_height | BIGINT | The height value representing the position of the current block from the genesis block. |
version | BIGINT | The protocol version that the block conforms to. |
block_timestamp | TIMESTAMP(6) | The time at which the block was created. |
bits | VARCHAR | The compressed representation of the target difficulty applied when mining the block. |
nonce | BIGINT | A 32-bit integer value that miners repeatedly modify to find a valid block hash. |
difficulty | VARCHAR | The difficulty level applied to mining the current block. |
merkle_root | VARCHAR | The root hash formed by combining the hashes of all transactions in the block in a tree structure. |
transaction_count | BIGINT | The total number of transactions included in the block. |
transactions | ARRAY(VARCHAR) | A list of transaction IDs included in the block. |
size | BIGINT | The total size of the block data in bytes. |
weight | BIGINT | The weight of the block in weight units, calculated according to the SegWit specification. |
previous_block_hash | VARCHAR | The hash of the previous block, forming the chain linkage structure of the blockchain. |
median_time | BIGINT | The median of the timestamps of the previous 11 blocks, used as the network reference time. |
stripped_size | BIGINT | The size of the block in bytes, excluding Witness data. |
transactions
Unique Key: transaction_index, block_height
Filterable Columns: None
| Column | Type | Description |
|---|---|---|
transaction_id | VARCHAR | The unique identifying hash of the transaction. |
transaction_index | BIGINT | The sequential position of the transaction within the block. |
version | BIGINT | The protocol version that the transaction conforms to. |
lock_time | BIGINT | The minimum block height or Unix timestamp at which the transaction can be included in a block. |
size | BIGINT | The total size of the transaction data in bytes. |
weight | BIGINT | The weight of the transaction in weight units, calculated according to the SegWit specification. |
vin_count | BIGINT | The number of inputs included in the transaction. |
vout_count | BIGINT | The number of outputs included in the transaction. |
block_height | BIGINT | The height of the block that contains this transaction. |
block_hash | VARCHAR | The hash of the block that contains this transaction. |
block_timestamp | TIMESTAMP(6) | The time at which the block containing this transaction was created. |
hash | VARCHAR | The hash of the transaction. |
vsize | BIGINT | The virtual size of the transaction in bytes, calculated based on the SegWit weight. |
fee | VARCHAR | The miner fee for processing the transaction. |
vins
Unique Key: vin_index, transaction_index, block_height
Filterable Columns: address
| Column | Type | Description |
|---|---|---|
vin_index | BIGINT | The sequential position of this input within the transaction. |
transaction_index | BIGINT | The sequential position of this transaction within the block. |
transaction_id | VARCHAR | The ID of the transaction to which this input belongs. |
address | VARCHAR | The address that signed this input. |
addresses | ARRAY(VARCHAR) | A list of addresses associated with this input. |
value | VARCHAR | The amount of the UTXO consumed by this input. |
coinbase | VARCHAR | Arbitrary data written by the miner in the case of a coinbase transaction. |
is_coinbase | BOOLEAN | Whether this input is a coinbase input that generates the block reward. |
vout_transaction_id | VARCHAR | The transaction ID of the previous output referenced by this input. |
vout_index | BIGINT | The index of the previous output referenced by this input. |
script_sig | VARCHAR | The raw byte value of the input signature script. |
script_sig_asm | VARCHAR | The human-readable ASM representation of the input signature script. |
script_sig_type | VARCHAR | The type of the input signature script. |
sequence | BIGINT | The sequence value used for BIP-68 relative timelocks. |
witness | ARRAY(VARCHAR) | A list of Witness data for SegWit transactions. |
block_height | BIGINT | The height of the block containing the transaction to which this input belongs. |
block_timestamp | TIMESTAMP(6) | The creation time of the block containing the transaction to which this input belongs. |
vout_block_height | BIGINT | The height of the block in which the output referenced by this input was created. |
vout_transaction_index | BIGINT | The sequential position within the block of the transaction that contains the output referenced by this input. |
vouts
Unique Key: vout_index, transaction_index, block_height
Filterable Columns: address
| Column | Type | Description |
|---|---|---|
vout_index | BIGINT | The sequential position of this output within the transaction. |
transaction_index | BIGINT | The sequential position of this transaction within the block. |
transaction_id | VARCHAR | The ID of the transaction to which this output belongs. |
script_pub_key | VARCHAR | The raw byte value of the output locking script. |
script_pub_key_asm | VARCHAR | The human-readable ASM representation of the output locking script. |
script_pub_key_type | VARCHAR | The type of the output locking script. |
address | VARCHAR | The address that can spend this output. |
addresses | ARRAY(VARCHAR) | A list of addresses that can spend this output. |
value | VARCHAR | The amount of BTC assigned to this output. |
req_sigs | BIGINT | The minimum number of signatures required to spend this output. |
block_height | BIGINT | The height of the block containing the transaction to which this output belongs. |
block_timestamp | TIMESTAMP(6) | The creation time of the block containing the transaction to which this output belongs. |