labels.addresses

Comprehensive address labeling and attribution data — maps blockchain addresses to known entities, categories, and usage metrics across all supported chains

The labels.addresses table on Dune catalogs specific blockchain addresses, associating them with descriptive labels, categories, and usage metrics. This table is a superset of many other labels.<category> tables, providing a comprehensive overview of labeled addresses across various categories and blockchains. You can use the category column to filter labels for the specific type of address you are interested in.

The labels.addresses table serves as a central repository for all labeled addresses on Dune, offering a consolidated view of labeled entities across different categories and blockchains.

Available Categories

Here are all the distinct category values available in the labels.addresses table:

Table Schema

Column	Type	Description
blockchain	VARCHAR	Blockchain the address belongs to
address	VARBINARY	Labeled blockchain address
name	VARCHAR	Human-readable label name for the address
category	VARCHAR	Label category (e.g., dex, cex, bridge, dao)
contributor	VARCHAR	Contributor(s) who created the label
source	VARCHAR	How the label was generated (static or query-based)
created_at	DATE	When the label was created
updated_at	TIMESTAMP	When the label was last updated
model_name	VARCHAR	Name of the label model sourced from
label_type	VARCHAR	Type of label

Table Sample

Example Query

The following SQL query demonstrates how to find addresses categorized under ‘dex’ within the Binance blockchain:

SELECT
  address,
  name
FROM
  labels.addresses
WHERE
  category = 'dex' AND
  blockchain = 'bnb'