labels.addresses

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'

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

Available Categories

Table Schema

Table Sample

Example Query

​Available Categories

​Table Schema

​Table Sample

​Example Query

Available Categories

Table Schema

Table Sample

Example Query