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'