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

> Entity profile data — operational details, categories, social presence, and technical profiles for known blockchain entities

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>
  </>;

The `labels.owner_details` table on Dune provides essential information about various entities within the ecosystem, detailing their operational, social, and technical profiles.

Data in this table is sourced from community contributions and official documentation, offering a comprehensive overview of the entities' activities, categories, and online presence. Analysts can leverage this data to track the latest developments, partnerships, and projects associated with specific entities.

<Tip>
  You can find addresses associated with the account owners and custody owners in the `labels.owner_addresses` table.
</Tip>

## Table Schema

| Column                  | Type             | Description                                              |
| ----------------------- | ---------------- | -------------------------------------------------------- |
| `name`                  | `VARCHAR`        | Entity name                                              |
| `owner_key`             | `VARCHAR`        | Unique key linking to owner\_addresses                   |
| `website`               | `VARCHAR`        | Entity website URL                                       |
| `dune_team`             | `VARCHAR`        | Associated Dune team                                     |
| `project_documentation` | `VARCHAR`        | Link to project documentation                            |
| `project_github_url`    | `VARCHAR`        | Link to project GitHub repository                        |
| `social`                | `VARCHAR`        | Social media links                                       |
| `primary_category`      | `VARCHAR`        | Primary business category (e.g., Decentralized Exchange) |
| `category_tags`         | `ARRAY(VARCHAR)` | Additional category tags                                 |
| `country_name`          | `VARCHAR`        | Country of incorporation or operation                    |
| `description`           | `VARCHAR`        | Brief entity description                                 |
| `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_details" />

## Example Query

The following SQL query demonstrates how to retrieve basic information about entities categorized as 'Decentralized Exchange':

```sql theme={null}
SELECT
  name,
  website,
  primary_category
FROM
  labels.owner_details
WHERE
  primary_category = 'Decentralized Exchange'
```