Skip to main content
Schema: bitcoin.core Table: dim_labels Type: View

​
Description

This table contains comprehensive address labels for Bitcoin addresses, providing categorized identification and classification of known entities, contracts, and addresses across the Bitcoin ecosystem. Each row represents a single address with its associated label information including type, subtype, project name, and creator details. The labels are sourced from both automatic algorithms and manual curation, enabling rich categorization of Bitcoin addresses for enhanced analytics and entity identification.

​
Key Use Cases

  • Address categorization and entity identification across the Bitcoin network
  • Exchange and service provider wallet identification and monitoring
  • Contract and protocol address tracking and analysis
  • Risk assessment and compliance monitoring for specific address types
  • Entity-based transaction filtering and analysis
  • Community-driven address labeling and verification
  • Cross-protocol address relationship mapping

​
Important Relationships

  • Primary dimension table for address categorization across the Bitcoin ecosystem
  • Referenced by core.fact_transactions for labeled transaction analysis
  • Used by core.fact_inputs and core.fact_outputs for labeled UTXO analysis
  • Supports core.fact_clustered_transfers for entity-level transfer categorization
  • Enables integration with core.dim_entity_clusters for enhanced entity analysis
  • Provides categorization context for stats.ez_core_metrics_hourly aggregated metrics

​
Commonly-used Fields

  • address: Essential for joining with transaction and UTXO tables
  • label_type: Core field for high-level address categorization
  • label_subtype: Important for detailed address classification
  • project_name: Key for protocol and service provider identification
  • address_name: Critical for human-readable address identification
  • Label fields enable rich categorization and filtering across all Bitcoin data

​
Columns

Column NameData TypeDescription
BLOCKCHAINTEXTThe name of the blockchain.
CREATORTEXTCreator or source of the label.
ADDRESSTEXTA Bitcoin address associated with the transaction, output, label, etc.
LABEL_TYPETEXTA high-level category describing the addresses main function or ownership.
LABEL_SUBTYPETEXTA sub-category nested within label type providing further detail.
ADDRESS_NAMETEXTAn entity name associated with the address. The most granular label for this address.
PROJECT_NAMETEXTThe primary project group for this address. For example, if address name is XYZ Hotwallet, then the project name is XYZ,
LABELTEXTThe label for this address.
DIM_LABELS_IDTEXTA unique identifier (STRING or NUMBER) for the record, used as a primary key for this table. Not a blockchain-native field.
Example: 123456789 | | INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp (TIMESTAMP_NTZ, UTC) when this record was initially created and inserted into the table. Example: 2024-06-01 12:34:56.000 | | MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp (TIMESTAMP_NTZ, UTC) when this record was last modified by an internal process. Example: 2024-06-01 12:35:00.000 |