Geographic Dimension Dataset

Geographic Dimension DatasetThe PMDCI Geographic Dimension Dataset includes a list of codes for all countries, dependent territories, and special areas of geographical interest specified in the ISO 3166-1 standard, along with their coordinates (latitude, longitude) and names in multiple languages.

This dataset is ideal for those looking to add country support for systems such as CRM, ERP and e-commerce websites, as well as data marts, data warehouses and analytical systems such as Tableau and Power BI.

Purchase and Download

The dataset is available for purchase at Scribd for US$29.95.

Included Fields

This data set contains the following information:

  • ISO 3166-1 Alpha-2 Code: Character field with the ISO 3166-1 Alpha-2 code for the country or region. Two characters in length.
  • ISO 3166-1 Alpha-3 Code: Character field with the ISO 3166-1 Alpha-3 code for the country or region. Three characters in length.
  • ISO 3166-1 Numeric Code: Integer field with the ISO 3166-1 Numeric code for the country or region.
  • ISO 3166-1 Official Short Name (en): Character field with the official ISO 3166-1 short name for the country or region.
  • Latitude: Decimal field with the latitude of the country or region.
  • Longitude: Decimal field with the longitude of the country or region.
  • Name (en): Character field with the friendly name of the country or region in English.
  • Name (de): Character field with the friendly name of the country or region in German.
  • Name (es): Character field with the friendly name of the country or region in Spanish.
  • Name (fr): Character field with the friendly name of the country or region in French.
  • Name (it): Character field with the friendly name of the country or region in Italian.
  • Name (jp): Character field with the friendly name of the country or region in Japanese.
  • Name (lt): Character field with the friendly name of the country or region in Lithuanian.
  • Name (pl): Character field with the friendly name of the country or region in Polish.
  • Name (pt_BR): Character field with the friendly name of the country or region in Brazilian Portuguese.
  • Name (ru): Character field with the friendly name of the country or region in Russian.
  • Name (uk): Character field with the friendly name of the country or region in Ukrainian.
  • Microsoft Outlook 2010 Name (en): Character field with the name of the country or region in English used in Outlook 2010.
  • Microsoft Outlook 2013 Name (en): Character field with the name of the country or region in English used in Outlook 2013.
  • Africa (UNSD): Boolean field denoting whether the country or region is part of Africa, according to the UN Statistics Division.
  • Eastern Africa (UNSD): Boolean field denoting whether the country or region is part of Eastern Africa, according to the UN Statistics Division.
  • Middle Africa (UNSD): Boolean field denoting whether the country or region is part of Middle Africa, according to the UN Statistics Division.
  • Northern Africa (UNSD): Boolean field denoting whether the country or region is part of Northern Africa, according to the UN Statistics Division.
  • Southern Africa (UNSD): Boolean field denoting whether the country or region is part of Southern Africa, according to the UN Statistics Division.
  • Western Africa (UNSD): Boolean field denoting whether the country or region is part of Western Africa, according to the UN Statistics Division.
  • Americas (UNSD): Boolean field denoting whether the country or region is part of Americas, according to the UN Statistics Division.
  • North America (UNSD): Boolean field denoting whether the country or region is part of North America, according to the UN Statistics Division.
  • Northern America (UNSD): Boolean field denoting whether the country or region is part of Northern America, according to the UN Statistics Division.
  • Central America (UNSD): Boolean field denoting whether the country or region is part of Central America, according to the UN Statistics Division.
  • Caribbean (UNSD): Boolean field denoting whether the country or region is part of the Caribbean, according to the UN Statistics Division.
  • South America (UNSD): Boolean field denoting whether the country or region is part of South America, according to the UN Statistics Division.
  • Latin America and the Caribbean (UNSD): Boolean field denoting whether the country or region is part of Latin America and the Caribbean, according to the UN Statistics Division.
  • Anglo-America: Boolean field denoting whether the country is part of Anglo-America (English speaking).
  • Ibero-America: Boolean field denoting whether the country is part of Ibero-America (Spanish and Portuguese speaking).
  • Hispanic-America: Boolean field denoting whether the country is part of Hispanic-America (Spanish speaking).
  • French America: Boolean field denoting whether the country is part of French America (French speaking).
  • Asia (UNSD): Boolean field denoting whether the country or region is part of Asia, according to the UN Statistics Division.
  • Central Asia (UNSD): Boolean field denoting whether the country or region is part of Central Asia, according to the UN Statistics Division.
  • Estern Asia (UNSD): Boolean field denoting whether the country or region is part of Eastern Asia, according to the UN Statistics Division.
  • Southern Asia (UNSD): Boolean field denoting whether the country or region is part of Southern Asia, according to the UN Statistics Division.
  • South-Eastern Asia (UNSD): Boolean field denoting whether the country or region is part of South-Eastern Asia, according to the UN Statistics Division.
  • Western Asia (UNSD): Boolean field denoting whether the country or region is part of Western Asia, according to the UN Statistics Division.
  • Europe (UNSD): Boolean field denoting whether the country or region is part of Europe, according to the UN Statistics Division.
  • Eastern Europe (UNSD): Boolean field denoting whether the country or region is part of Eastern Europe, according to the UN Statistics Division.
  • Northern Europe (UNSD): Boolean field denoting whether the country or region is part of Northern Europe, according to the UN Statistics Division.
  • Southern Europe (UNSD): Boolean field denoting whether the country or region is part of Southern Europe, according to the UN Statistics Division.
  • Western Europe (UNSD): Boolean field denoting whether the country or region is part of  Western Europe, according to the UN Statistics Division.
  • Europe (UNSD): Boolean field denoting whether the country or region is part of Europe, according to the UN Statistics Division.
  • Oceania (UNSD): Boolean field denoting whether the country or region is part of Oceania, according to the UN Statistics Division.
  • Australia and New Zealand (UNSD): Boolean field denoting whether the country or region is part of Australia and New Zealand, according to the UN Statistics Division.
  • Melanesia (UNSD): Boolean field denoting whether the country or region is part of Melanesia, according to the UN Statistics Division.
  • Micronesia (UNSD): Boolean field denoting whether the country or region is part of Micronesia, according to the UN Statistics Division.
  • Polynesia (UNSD): Boolean field denoting whether the country or region is part of Oceania, according to the UN Statistics Division.