Common geographical dimension
- As a system we want to keep a common geographical dimension to let users narrow a search
- The exist ISO code with 2 letters, 3 letters and 3 digits. I suggest to use 3 digits (https://en.wikipedia.org/wiki/ISO_3166-1_numeric)
- We can use codes 900-999 to add geographical entities above countries (European Union, Euro area, ....)
- When a series refers to a sub-national entity (region), we code the common dimension with the country code
- We need to develop a separate utility to recognize country names and assign codes automatically when possible and report cases that need to be coded manually
- common geographical dimension name: dbnomics-geo or dbgeo