labels.owner_details

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

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 associated with the account owners and custody owners in the labels.owner_addresses table.

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

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'