labels.owner_details
Description of the labels.owner_details table on Dune
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.
You can find addresses assocaited with the account owners and custody owners in the labels.owner_addresses table.
Column Descriptions
| Column Name | Description |
|---|---|
name | The name of the entity. |
owner_key | A unique identifier for the owner. |
website | Official website URL of the entity. |
dune_team | Indicates if the entity is part of the Dune team (deprecated/not widely used, often null). |
project_documentation | Link to the official documentation of the project. |
project_github_url | GitHub URL if the project is open-source. |
social | Social media or other online presence links. |
primary_category | The primary category under which the entity operates (e.g., DEX, Oracle). |
category_tags | Additional tags related to the category such as functionalities or special features. |
country_name | The country in which the entity is based. |
description | A brief description of the entity and its operations. |
created_at | Timestamp of when the record was first created. |
created_by | Identifier of the contributor who created the record. |
updated_at | Timestamp of the last update to the record. |
updated_by | Identifier of the contributor who last updated the record. |
Table Sample
Example Query
The following SQL query demonstrates how to retrieve basic information about entities categorized as ‘Decentralized Exchange’:
SELECT
name,
website,
primary_category
FROM
labels.owner_details
WHERE
primary_category = 'Decentralized Exchange'
Was this page helpful?