The geography table
The variable-grain geography registry: countries, subdivisions, cities, aggregates, macro regions and complements, each with a stable code.
Fields#
| field | type | required | example | meaning |
|---|---|---|---|---|
code |
text | yes | FR | 'FR','FR-34','FR-34-montpellier','EUROPE','EXIOBASE_ROW_EUROPE','GLOBAL' |
name |
text | yes | The full name, as the organisation writes it. | |
kind |
text | yes | country / subdivision / city / aggregate / complement / macro / global | |
parent_code |
text | The next level up, which is how a fine-grained code is reached from a coarse query. | ||
iso_level |
text | '3166-1' / '3166-2' / NULL (invented codes) | ||
member_resolution |
text | groups only: 'static' / 'per_activity'; NULL otherwise |
Referenced by#
emission_factor.region_code, fuel_chain_ratio.region_code, fx_annual.anchor_economy, generation_mix_share.region_code, geography.parent_code, geography_member.group_code, geography_member.member_code, geography_resolution.geography_code, grid_loss_share.region_code, price_index.economy, publisher.home_region, supplier.country_code.
Notes#
parent_code chains a fine code up to a coarse one, which is how a query for a country can still reach a region-level factor.