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


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.