Registry - Token Terminal Docs

The identity table behind every project figure. Every fact and metric joins to it, and Coverage introduces the grain.

Columns

Column	Type	Description
`project_id`	`STRING`	Identifier of the project. Every table that mentions a project joins on this.
`name`	`STRING`	Display name.
`symbol`	`STRING`	Ticker of the project’s token, where one exists.
`market_sectors`	`ARRAY<STRING>`	Every market sector tag on the project.
`primary_market_sector`	`STRING`	The first element of `market_sectors`. One value per row.

Sample queries

Project identity
Projects by sector
Projects with several apps

project_id is the key every project table joins on, and market_sectors holds every tag on the project.

select
    project_id,
    name,
    symbol,
    primary_market_sector,
    market_sectors
from `dimensions.projects`
where project_id = 'uniswap'

primary_market_sector keeps one row per project however the tagging changes later. market_sectors is a list, so joining through unnest(market_sectors) yields one row per tag and any total taken off it comes out too high.

select
    primary_market_sector,
    count(*) as projects
from `dimensions.projects`
group by primary_market_sector
order by projects desc

A project with several apps has one row here and several in dimensions.apps, so the count comes from a join.

select
    projects.project_id,
    projects.name,
    count(*) as apps
from `dimensions.projects` as projects
join `dimensions.apps` as apps
    using (project_id)
group by projects.project_id, projects.name
having count(*) > 1
order by apps desc, projects.project_id