Skip to main content

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
  • Sample: Hugging Face Sample

Columns

ColumnTypeDescription
chain_idBIGINTEVM chain identifier; see Chain.
contract_idBYTEAUnique contract incarnation ID: 20 bytes (address) + 4 bytes (creation block, big-endian) + 2 bytes (tx_index, big-endian). Primary key.
contract_addressBYTEAThe deployed contract address (20 bytes). Separate column for efficient API lookups.
block_numberBIGINTBlock number where contract was deployed.
block_timeTIMESTAMPTZUTC timestamp of the block.
tx_indexINTEGERTransaction index within the block.
trace_addressTEXTPosition in call tree (e.g., “0”, “0.0”, “0.1.2”).
creator_addressBYTEAAddress that deployed the contract (msg.sender of CREATE/CREATE2).
creation_call_typeTEXTType of creation: CREATE or CREATE2.
_tracing_idBYTEAInternal tracing identifier for lineage tracking.
_created_atTIMESTAMPTZRecord creation timestamp.
_updated_atTIMESTAMPTZRecord last update timestamp.

Use Cases

  • Contract registry and address validation
  • Deployment tracking and contract lifecycle analysis
  • Factory pattern analysis and contract creation patterns
  • Security research and contract classification
  • Integration with contract metadata and ABI databases
  • Foundation for contract interaction analysis

Function Results

Read-call results from contract view functions.

Internal Transactions

Calls targeting these contract addresses.

Transactions

Deployment and interaction transactions.
Last modified on March 21, 2026