> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# labels.addresses

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

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

export const DuneEmbed = ({qID, vID, height = '500px'}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/${qID}/${vID}?darkMode=true`} style={{
  width: '100%',
  height,
  border: 'none',
  marginTop: '10px'
}}></iframe>
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/${qID}/${vID}`} style={{
  width: '100%',
  height,
  border: 'none',
  marginTop: '10px'
}}></iframe>
    </div>
  </>;

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.

<Note>
  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.
</Note>

## Available Categories

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

<DuneEmbed qID={5488568} vID={8942954} height={400} />

## 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

<TableSample tableSchema="labels" tableName="addresses" />

## Example Query

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

```sql theme={null}
SELECT
  address,
  name
FROM
  labels.addresses
WHERE
  category = 'dex' AND
  blockchain = 'bnb'
```