Registry

The identity table behind an address: the chain it sits on and, where somebody has attributed it, the project that runs it, its type and its label, next to the region, funding and attested country held for it. Accounts introduces the grain, and Contracts has the deployment behind a contract account. We publish where a wallet is active, where it was funded and, for holders who opted in, the country Coinbase attested for it. Region of activity, unchanged from v1, is a UTC-offset band derived from public transaction timing. Funding source is new. Where we can trace a wallet’s incoming transfers to an exchange, custodian, or fiat ramp, we publish which venue funded it, the venue’s type, whether that venue address was curated by a person or detected from wallet behavior, a confidence tier of high, medium, or low, how many funding transactions back the tag, and when the funding relationship was first observed. Funding jurisdiction is the country the venue that funded the wallet is registered in and serves, published only where the venue serves a single country. A wallet funded through a regional or global exchange gets a null jurisdiction, because that value describes the venue, not the person who holds the wallet. Neither region nor funding reads a partner’s KYC records, and no country is derived from how or when an address transacts, only from where the venue that funded it is registered. Attested country is different in kind: it is the country of residence Coinbase recorded when it verified the account holder, issued as an opt-in attestation the holder can revoke, and we republish it as issued without deriving anything from it. Region is a property of the address key across its whole chain_family, not of one chain, and its evidence comes only from the chains activity hours covers: ethereum, base, robinhoodchain and solana. No country is ever derived from region: a country comes only from a funding venue’s registration, gated to venues that serve a single country, or from an attestation. Every confidence tier describes the strength of one signal, the address’s daily rhythm. Region and funding are published per account_id for every row, attributed or not, and the region distribution report holds region as a distribution across every sender on the chain. region is derived from activity hours:

Sum the address’s hourly transaction counts over the trailing 90 complete UTC days, across every chain in its chain_family; n is the total. Addresses with n below 300 get a null region_confidence.
The trough is the 6-hour window with the smallest share of n; its centre hour is t. The UTC offset is round(3.5 - t), wrapped to -11..+12, taking 03:30 as the local sleep centre.
The band is the one of seven that contains the offset.
Depth d = 1 - (trough share / 0.25); night share is the share in the 12 hours centred on the trough.
high needs n >= 3000, d >= 0.70, night <= 0.25; medium needs n >= 1000, d >= 0.50, night <= 0.30; low needs n >= 300, d >= 0.30, night <= 0.35; otherwise region and region_confidence are null. A second trough within 10% of the first caps confidence at low.

An address has a region once its trailing activity clears the evidence floor. On a labelled row that describes where a venue or operator runs, and on an unlabelled wallet where that wallet is active. A global venue’s wallets move on its users’ hours across every band, so its region reflects where its users are, aggregated, and its region_confidence often stays null. The hit rate is read against venues whose operations sit in one band. Activity coverage publishes the share of each day’s active senders that are attributed. funding_venue_project_id on Funding is derived from venue edges: the venue is the earliest edge’s venue, and a wallet whose edges split evenly across venues gets a null venue instead. Confidence is set by how many venues a wallet has edges with, and how those edges were found. high is one venue, funded through a curated deposit anchor. medium is one venue funded through a detected deposit address only, or two venues where the earliest edge was curated. low is two venues where the earliest edge was detected. Three or more venues, or two of comparable weight, get a null tier. funding_jurisdiction on Venues is set only where a venue clears three facts together: its operating_scope is single_country, its onboarding_scope is residents_only, and its licence countries and entity countries agree on that one country, with no licence row and no funding wallet left without a country. gate_reason on Venues names which of the three failed, or qualifies.

Tables

Accounts
Venues

One row per address the label registry attributes or any accounts fact holds a row for. The label columns are null where nobody has attributed the address. Join on account_id, or on address and chain_id; attested_country fills on every EVM chain of an attested address.

Column	Type	Description
`account_id`	`STRING`	Account as one key: `{address}-{chain_id}`. The key that joins `dimensions.contracts` and `dimensions.tokens` directly.
`chain_id`	`STRING`	Chain the address is on. The same address on two chains is two different accounts, so an address identifies a row only with this beside it.
`address`	`STRING`	The address, spelled the way its chain spells it: lowercase on EVM and Starknet, base58 and case-sensitive on Solana and Tron. Lowercase an EVM address copied from an explorer before matching it here; the balance functions lowercase the address they are handed.
`project_id`	`STRING`	Project the address is attributed to. Joins `dimensions.projects` for the name and market sector.
`contract_name`	`STRING`	Label for the address as the attributing project names it, such as `Factory` or `USDC-WETH pool`.
`account_type`	`STRING`	`eoa` or `smartcontract`, and null where nobody has determined it, so test it with `is null` rather than `= ”`. Says nothing about whether the owner holds the address custodially.
`parent_address`	`STRING`	For a factory-emitted address, the factory that emitted it.
`label_source`	`STRING`	`curated` for an attribution a person authored, `factory_derived` for an address a known factory emitted. Null where nobody has attributed the address. Of the attributed rows most are factory derived; filter to `curated` for the addresses someone has looked at.
`region`	`STRING`	One of seven UTC-offset bands: `utc-11..-9`, `utc-8..-5`, `utc-4..-2`, `utc-1..+2`, `utc+3..+6`, `utc+7..+9`, `utc+10..+12`. Null when `region_confidence` is null.
`region_confidence`	`STRING`	`high`, `medium` or `low`, from the thresholds behind `region`, and null where `region` is null.
`region_evidence_txs`	`INT64`	Transactions behind the band: `n`, the trailing 90-day total the `region` calculation summed across the address’s chain family.
`funding_venue_project_id`	`STRING`	Venue that funded the account, from Funding. Null where the account has no funding edge, or where its edges split across venues.
`funding_venue_type`	`STRING`	`cex` or `fiat-ramps`, from the Venues tab above. Null iff `funding_venue_project_id` is null.
`funding_venue_source`	`STRING`	`curated` for an edge to a registry anchor, `detected` for an edge through a detected deposit address. Null iff `funding_venue_project_id` is null.
`funding_confidence`	`STRING`	`high`, `medium` or `low`, from the same tiers as Funding. Null iff `funding_venue_project_id` is null.
`funding_evidence_edges`	`INT64`	First-contact edges behind the tag. `0` where the account has no funding row, like `region_evidence_txs`.
`funding_first_edge_at`	`TIMESTAMP`	Earliest funding edge, from Funding. Null where the account has no funding row.
`funding_jurisdiction`	`STRING`	ISO 3166-1 alpha-2 of the funding venue, from the Venues tab above. Null unless the venue passes the jurisdiction gate.
`attested_country`	`STRING`	ISO 3166-1 alpha-2 country of residence Coinbase attested for the address, from Attested country. Filled on every row whose chain is EVM, since the attestation applies to the address on every EVM chain, and null elsewhere and where the holder has no live attestation.
`attested_at`	`TIMESTAMP`	Timestamp the attestation was issued. Null iff `attested_country` is null.

One row per project tagged as a venue a wallet can be funded from: an exchange, a custodian or a fiat ramp. funding_jurisdiction is set only where the venue passes the jurisdiction gate above.

Column	Type	Description
`venue_project_id`	`STRING`	The venue, as a `dimensions.projects` key.
`name`	`STRING`	Venue’s display name.
`venue_type`	`STRING`	`cex` or `fiat-ramps`, read from the venue’s registry tags.
`legal_entity_name`	`STRING`	The venue’s authored operating legal entity name.
`legal_domicile`	`STRING`	ISO 3166-1 alpha-2 of the legal entity’s domicile, as authored.
`operating_scope`	`STRING`	The venue’s authored operating footprint: `single_country`, `regional` or `global`. Null where the registry has not recorded it. `single_country` is one of the three facts the jurisdiction gate above requires.
`onboarding_scope`	`STRING`	Who the venue admits as a customer, as authored: `residents_only`, `open` or `fiat_rail_only`. Null where the registry has not recorded it. `residents_only` is one of the three facts the gate requires.
`service_jurisdictions`	`ARRAY<STRING>`	Countries the venue is authored as actively serving.
`restricted_jurisdictions`	`ARRAY<STRING>`	Countries the venue is authored as restricting.
`licence_count`	`INT64`	Count of the venue’s licence rows.
`licences_without_country`	`INT64`	Of those, licence rows recorded with no country. The gate fails while this count is above zero.
`licence_countries`	`ARRAY<STRING>`	Countries those licences are held in. The gate requires exactly one; more than one, or zero, fails it.
`licence_status`	`STRING`	Comma-joined distinct status values across the venue’s licences.
`funding_wallet_count`	`INT64`	Funding wallets attributed to this venue.
`funding_wallets_without_country`	`INT64`	Of those, wallets whose registry row names no country. The gate fails while this count is above zero.
`entities`	`ARRAY<STRING>`	Distinct legal entity names across the venue’s funding wallets.
`entity_countries`	`ARRAY<STRING>`	Distinct countries those entities resolve to. The gate requires exactly one, matching `licence_countries`’ single country.
`funding_jurisdiction`	`STRING`	ISO 3166-1 alpha-2, set only where `gate_reason` reads `qualifies`. Null on every other venue.
`funding_jurisdiction_name`	`STRING`	Display name of `funding_jurisdiction`, on the same terms.
`gate_reason`	`STRING`	The first of the gate’s checks this venue fails, in the order named above, or `qualifies` when none does: `operating_scope_not_single_country`, `onboarding_not_residents_only`, `licence_country_missing_or_multiple`, `entity_country_missing_or_mismatched`, `jurisdiction_unknown`, or `qualifies`.

Sample queries

Look up an account
An account's attested country
What one project operates
Addresses per project on one chain
Venues with a funding jurisdiction

The table is clustered on chain_id and address, so filtering on both is the cheapest lookup. Lowercase an EVM address copied from an explorer before you paste it in.

select
    chain_id,
    address,
    project_id,
    contract_name,
    account_type,
    label_source
from `dimensions.accounts`
where chain_id = 'ethereum'
    and address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'

The attested country sits on the account row, so the same chain_id and address lookup returns it beside the region and the funding venue. It is filled on every EVM chain of an attested address.

select
    chain_id,
    address,
    attested_country,
    attested_at,
    region,
    funding_venue_project_id
from `dimensions.accounts`
where chain_id = 'base'
    and address = '0x0000000000000000000000000000000000000001'

label_source splits how an address was attributed: curated is the set a person authored, and the rest is factory output. A null label_source is an address nobody has attributed.

select
    chain_id,
    address,
    contract_name,
    account_type
from `dimensions.accounts`
where project_id = 'uniswap'
  and label_source = 'curated'
order by chain_id, contract_name
limit 100

project_id joins dimensions.projects for the display name and the market sector, which is how a chain’s labeled addresses group into sectors.

select
    projects.name,
    projects.primary_market_sector,
    count(*) as addresses
from `dimensions.accounts` as accounts
join `dimensions.projects` as projects
    using (project_id)
where accounts.chain_id = 'ethereum'
  and accounts.label_source = 'curated'
group by projects.name, projects.primary_market_sector
order by addresses desc
limit 50

gate_reason reads qualifies only where the venue’s operating scope, onboarding scope, and licence and entity countries all agree on one country.

select
    venue_project_id,
    name,
    venue_type,
    funding_jurisdiction
from `dimensions.venues`
where gate_reason = 'qualifies'
order by name

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Tables

Sample queries

​Tables

​Sample queries

Tables

Sample queries