Attested country - Token Terminal Docs

One row per wallet holding a live Coinbase Verified Country attestation: the country of residence Coinbase recorded when it verified the holder. The attestation is issued on Base, opt-in and revocable, and revoked or expired attestations are dropped.

Columns

Column	Type	Description
`address`	STRING	The wallet the attestation was issued to, lowercase. The key this table is clustered on.
`chain_family`	STRING	Always `evm`: the country applies to the address on every EVM chain, so join on `address` and the chain’s `chain_family` from Chains ▸ Registry.
`attested_chain_id`	STRING	Chain the attestation was issued on, always `base`.
`attested_country`	STRING	ISO 3166-1 alpha-2 country of residence recorded in the attestation.
`attested_at`	TIMESTAMP	Timestamp the attestation was issued. A wallet with several live attestations keeps the latest.
`attestation_uid`	STRING	Unique id of the attestation.
`attester`	STRING	Address of the issuer, lowercase.

Sample queries

The table is clustered on address, one row per wallet. Filter on the address where you have it; a query that filters on anything else reads the whole table.

One wallet's attested country
Attested wallets by country
Attested country by funding venue

address is the cluster key, so filtering it is the cheapest lookup.

select
    attested_country,
    attested_at
from `facts_accounts.attested_country`
where address = '0x0000000000000000000000000000000000000001'

Wallets per country of residence.

select
    attested_country,
    count(*) as wallets
from `facts_accounts.attested_country`
group by attested_country
order by wallets desc
limit 20

A wallet joins on address and the chain’s chain_family, which reaches its funded rows on every EVM chain. dimensions.chains maps each chain_id to its chain_family.

select
    funding.funding_venue_project_id,
    attested.attested_country,
    count(*) as wallets
from `facts_accounts.funding` as funding
join `dimensions.chains` as chains
    on funding.chain_id = chains.chain_id
join `facts_accounts.attested_country` as attested
    on funding.address = attested.address
    and chains.chain_family = attested.chain_family
where funding.chain_id = 'ethereum'
  and funding.funding_venue_project_id is not null
group by funding.funding_venue_project_id, attested.attested_country
order by wallets desc
limit 20