A complete mapping of every recognized country to its continent and United Nations subregion. Whether you are building geographic filters, segmenting analytics data by region, or populating dropdown menus, this dataset gives you the hierarchy you need in one clean table.
Pro tip: Use the continent and subregion columns together to build multi-level geographic drill-downs in dashboards — continent for the top level, subregion for the detail view.
Select which columns to include in your download.
About the Countries by Continent Dataset
This dataset maps every internationally recognized country and territory to its parent continent and United Nations statistical subregion. The data follows the UN Statistics Division geoscheme (M49 standard), which provides a consistent framework for classifying countries into regions and sub-regions. Each entry includes the country name, its two-letter ISO 3166-1 alpha-2 code, the continent it belongs to, and the specific subregion designation. The dataset covers all 249 countries and territories tracked by international standards organizations.
Common Use Cases
Geographic segmentation is fundamental to many business and technical workflows. Here are some of the most practical applications for this dataset:
- Analytics and reporting: Group website visitors, customers, or transactions by continent and subregion to identify geographic trends without manually classifying each country.
- E-commerce shipping zones: Build region-based shipping rate tables by mapping your delivery countries to continents and subregions for zone-based pricing.
- CRM data enrichment: Append continent and subregion fields to customer records based on their country, enabling regional sales reports and territory management.
- Form and UI components: Populate cascading dropdown menus where users first select a continent, then a subregion, then a country for a cleaner user experience.
Column Reference
The dataset is structured to support both simple lookups and hierarchical grouping:
- country — The common English name of the country or territory as recognized by the United Nations.
- iso_alpha2 — The two-letter country code defined by ISO 3166-1 (e.g. "US", "GB", "JP"). Widely used in APIs, locale settings, and internationalization.
- continent — One of seven continents: Africa, Antarctica, Asia, Europe, North America, Oceania, or South America.
- subregion — The UN M49 subregion classification such as "Northern Europe", "South-Eastern Asia", or "Western Africa" for finer geographic grouping.
How Geographic Classification Works
The United Nations Statistics Division maintains the M49 standard, which divides the world into macro-regions (continents), sub-regions, and intermediate regions. This hierarchical system allows data to be aggregated at whatever geographic level is most useful. For example, "France" belongs to the continent "Europe" and the subregion "Western Europe". This classification is used by the UN, World Bank, and many national statistics agencies for consistent international comparisons. Some territories have special designations — for instance, overseas territories are typically classified under the geographic region where they are physically located rather than the region of their administering country.
Integration Tips
Download the JSON format if you need a lookup dictionary in your application. You can key the data by the ISO alpha-2 code for instant country-to-continent resolution in JavaScript, Python, or any backend language. For SQL-based workflows, import the dataset as a dimension table and JOIN it against your fact tables using the country code. The CSV format works well as a data source for business intelligence tools like Tableau, Power BI, or Looker where you want to add a geographic hierarchy to your data model without manual mapping.