The geography_resolution table
The append-only record of how each raw region string a source shipped was resolved to a registry code, and on what evidence.
Fields#
| field | type | required | example | meaning |
|---|---|---|---|---|
publisher_code |
text | yes | The publisher's short handle, where a scheme or registry entry belongs to one publisher rather than being shared. | |
raw_text |
text | yes | as shipped: '34, MONTPELLIER, MUSE', 'Espagne', 'WE' | |
geography_code |
text | yes | The registry code the raw string resolved to. | |
resolved_by |
text | yes | rule / gazetteer / llm / human | |
evidence |
text | the log line justifying the mapping | ||
created_at |
timestamp | yes | When the row was first written. |
Notes#
Append-only on purpose: a re-reading adds a row, so the reason a factor sits in a given region is always recoverable.