MeridianMERIDIAN

Country Name

geography.location.country

Country name in English or local language. Locale-specific due to name representation (e.g., "Germany" in English vs "Deutschland" in German).

Casts to
VARCHAR
Scope
Locale-specific
Standard
Locales
EN, EN_AU, EN_GB, EN_CA, EN_US, DE, FR, ES, IT, NL, PL, RU, JA, ZH, KO, AR

Background

Origin

ISO 3166-1 is a standard defining codes for the names of countries, dependent territories and special areas of geographical interest.[1] The country codes have been published as ISO 3166-1 since 1997, when ISO 3166 was expanded into three parts.[1] Each ISO 3166-1 entry carries an English or French short name in upper case, a short name in title case and a full name, alongside its codes.[1]

Some country names used by the UN, and accordingly by ISO, are disputed.[1]

Use

In the Unicode CLDR locale data, the region code DE is named Germany in English and Deutschland in German.[2][3] The CLDR English data names the region US as United States, with US as a short alternative.[2] The CLDR English data names CZ as Czechia, with Czech Republic as a variant.[2] The CLDR English data names TR as Türkiye, with Turkey as a variant.[2] The CLDR English data names CI as Côte d’Ivoire, with Ivory Coast as a variant.[2]

Where you'll meet it

The UN Statistics Division's M49 page publishes its list of countries or areas in English, Chinese, Russian, French, Spanish and Arabic.[4]

Sources

  1. [1]ISO 3166-1secondary source
  2. [2]territories.jsondataset
  3. [3]territories.jsondataset
  4. [4]UNSD — Methodologyorganisation

Detection notes

v1 migration: Was address.country. Locale-specific for country name representation across languages. Consider ISO 3166-1 for standardization.

Use it

CLI · DuckDB
$ finetype infer -i "United States" --mode column
→ geography.location.country

SELECT ft_infer('United States');
-- → 'geography.location.country'
Cast expression
CAST({col} AS VARCHAR)

Schema

https://meridian.online/schemas/geography.location.country · Frictionless type string

finetype taxonomy geography.location.country -o json-schema

Aliases

country_name

Type Registry