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

> Owner-to-address mapping data — associates blockchain addresses with known entities for tracking ownership, contract deployments, and operational scope

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.owner_addresses` table on Dune provides detailed data on blockchain addresses associated with various owners within the ecosystem, enhancing visibility into ownership distributions, contract deployments, and operational scopes. It’s a crucial tool for analysts to track ownership and custody of assets across blockchains.

<Tip>
  You can find more details on the account owners and custody owners in the `labels.owner_details` table.
</Tip>

## Table Schema

| Column                    | Type        | Description                              |
| ------------------------- | ----------- | ---------------------------------------- |
| `address`                 | `VARBINARY` | Blockchain address                       |
| `blockchain`              | `VARCHAR`   | Blockchain the address belongs to        |
| `owner_key`               | `VARCHAR`   | Unique key linking to owner\_details     |
| `custody_owner`           | `VARCHAR`   | Entity that has custody of the address   |
| `account_owner`           | `VARCHAR`   | Entity that owns the account             |
| `contract_name`           | `VARCHAR`   | Name of the deployed contract            |
| `contract_version`        | `VARCHAR`   | Version of the deployed contract         |
| `eoa`                     | `VARCHAR`   | Whether the address is an EOA            |
| `factory_contract`        | `VARCHAR`   | Factory contract used to deploy          |
| `source`                  | `VARCHAR`   | Source of the label data                 |
| `identifying_transaction` | `VARCHAR`   | Transaction used to identify the address |
| `algorithm_name`          | `VARCHAR`   | Algorithm used for identification        |
| `source_website`          | `VARCHAR`   | Website source for the label             |
| `source_evidence`         | `VARCHAR`   | Evidence supporting the label            |
| `created_at`              | `TIMESTAMP` | When the record was created              |
| `created_by`              | `VARCHAR`   | Who created the record                   |
| `updated_at`              | `TIMESTAMP` | When the record was last updated         |
| `updated_by`              | `VARCHAR`   | Who last updated the record              |

## Table Sample

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

## Example Query

The following SQL query demonstrates how to retrieve details about addresses owned by 'Coinbase':

```sql theme={null}
SELECT
  *
FROM
  labels.owner_addresses
 where custody_owner = 'Coinbase'
```

The other way around is also possible, to find the custody owner of specific addresses. Here we match entities that have deposited assets to the `0x00000000219ab540356cBB839Cbe05303d7705Fa` address, which is the ETH 2.0 deposit contract.

```sql theme={null}
Select
  "from",
  "to",
  value,
  block_date,
  hash,
  custody_owner
from
  ethereum.transactions
  inner join labels.owner_addresses on "from" = labels.owner_addresses.address
where
  "to" = 0x00000000219ab540356cBB839Cbe05303d7705Fa
```

<div>
  <DuneEmbed qID="3730682" vID="6274458" height={600} />
</div>