Smart Contracts Registry | Ethereum EVM Blockchain Data

Overview

Dataset ID: 0121
Table: blockdb_evm.b0121_contracts_v1
Description: Smart contracts discovered via CREATE/CREATE2 internal transactions. Uses contract_id (26 bytes = address + creation_block + tx_index) as primary key to support metamorphic contracts (e.g. CREATE-SELFDESTRUCT-CREATE2 in the same block).
Primary key: contract_id
Foreign Key: (block_number, tx_index) → blockdb_evm.b0102_transactions_v1
API: POST /evm/raw/contracts
CSV Sample: Download
JSON Sample: Download

Column	Type	Description
`contract_id`	`BYTEA`	Unique contract incarnation ID: 20 bytes (address) + 4 bytes (creation block, big-endian) + 2 bytes (tx_index, big-endian). Primary key.
`contract_address`	`BYTEA`	The deployed contract address (20 bytes). Separate column for efficient API lookups.
`block_number`	`BIGINT`	Block number where contract was deployed.
`block_time`	`TIMESTAMPTZ`	UTC timestamp of the block.
`tx_index`	`INTEGER`	Transaction index within the block.
`trace_address`	`TEXT`	Position in call tree (e.g., “0”, “0.0”, “0.1.2”).
`creator_address`	`BYTEA`	Address that deployed the contract (msg.sender of CREATE/CREATE2).
`creation_call_type`	`TEXT`	Type of creation: CREATE or CREATE2.
`_tracing_id`	`BYTEA`	Internal tracing identifier for lineage tracking.
`_created_at`	`TIMESTAMPTZ`	Record creation timestamp.
`_updated_at`	`TIMESTAMPTZ`	Record last update timestamp.

Read-call results from contract view functions.

Calls targeting these contract addresses.

Deployment and interaction transactions.