Skip to main content
Allium’s Geographic Intelligence schema provides country-level attribution and timezone inference for blockchain addresses, plus weekly USDC/USDT flow analysis by entity and country — enabling compliance monitoring, regional analysis, and cross-border flow insights. master_list classifies 80M+ addresses across 12 chains; ~20M of those (~25%) receive a country attribution in addresses_geography.
Geographic attribution uses flow-based wallet relatedness propagation and multi-signal inference. A conviction level indicates attribution quality. Not every address can be attributed — see Geo-Measurability.

​
Schema Location

All tables are in the allium_identity.geo schema in Snowflake, across three groups:
  • Core classification — master_list, addresses_geography, addresses_timezones, coverage_summary
  • Exchange attribution — exchange_country_attribution (local/regional exchanges), exchange_gravity_weekly (global exchanges)
  • Flow analysis (USDC/USDT) — entity_flows_weekly, country_corridors_weekly, country_corridors_distributed_weekly
Chain coverage. master_list and coverage_summary carry per-chain rows for all 12 supported chains (ethereum, polygon, arbitrum, base, optimism, bsc, avalanche, linea, scroll, blast, tron, solana). addresses_geography and addresses_timezones collapse EVM chains into a single evm value, so their chain column is one of evm, solana, or tron (see the join caveat).

​
Data Flow Architecture

​
Tables

See the Table Reference for full column-level schemas and example queries.
TablePurpose
master_listGeo-measurability + wallet-type classification for every address
addresses_geographyCountry-level attribution with conviction levels
addresses_timezonesTimezone inference from transaction timing
coverage_summaryMeasurability statistics by chain and wallet type
exchange_country_attributionOperating-country attribution for local/regional exchanges
exchange_gravity_weeklyWeekly country distribution of flows for global exchanges
entity_flows_weeklyWeekly USDC/USDT entity-to-entity flow matrix
country_corridors_weeklyWeekly USDC/USDT country-to-country flows (exact attribution)
country_corridors_distributed_weeklyCountry corridors with global-exchange legs distributed by gravity

​
Next Steps

Geo-Measurability

Why hosted and unhosted wallets differ, and what makes an address measurable

Table Reference

Full column-level schema for every table

Example Queries

Compliance, regional analysis, exchange gravity, and cross-border flow recipes

Field Values Reference

Data dictionary, data quality, and best practices