Countries Database

Question

How do you determine what is a "country"?

Answer 1

We rely on the determination of the United States' National Geospatial-Intelligence Agency and only include countries which are populated. This closely approximates the ISO 3166-1 standard. Each country has a unique two-digit id.

When available, the date for fields is provided at the end of the comprehensive CSV file with the _date suffix.

We've spent countless hours: downloading, merging, cleaning, formatting, and aggregating this data into an accurate and concise product.

This database was aggregated from authoritative sources and carefully processed by SimpleMaps. We've been developing and selling interactive maps to Fortune 500 companies and prominent international organizations for over 14 years. Over this time, we've learned a lot about geographic data. Our data products have been used in production by well-regarded organizations such as The Guardian. To get a sense of the expertise, check out some of the testimonials from our happy customers.

Yes. After updates expire, you can purchase 12 more months of updates for $49 (Comprehensive).

Databases	Basic	Comprehensive
Commercial use	Allowed	Allowed
File format	CSV, Excel	CSV, Excel, SQL
Number of entries	253 countries	253 countries
Number of fields	18	79
Future updates	Not guaranteed	Included for 12 months
Data last updated	2025	2025
License	Creative Commons Attribution 4.0	Permissive, no redistribution
Refund policy	N/A	30-day guarantee
One-time fee	Free	$99
		Buy Now!

country	id	population	gdp	area	language	median_age	life_expectancy	currency
United States	US	339665118	25744100	9833517	English	38.5	80.8	United States Dollar
China	CN	1413142846	17963170	9596960	Chinese	39.8	78.2	Chinese Yuan
Brazil	BR	218689757	1920095	8515770	Portuguese	34.7	76.1	Brazilian Real
Norway	NO	5597924	579422	323802	Norwegian	40.6	83	Norwegian Krone
Antarctica	AQ			14200000

fieldname	description	Basic	Comprehensive
`country`	The commonly used name of the country.
`demonym`	The name used to refer to natives or inhabitants of the country.
`id`	Unique identifier for the country used by the US government.
`iso2`	Two-letter country code (ISO 3166-1 alpha-2).
`iso3`	Three-letter country code (ISO 3166-1 alpha-3).
`iso_numeric`	Three-digit country code (ISO 3166-1 numeric).
`tld`	Country's top-level internet domain.
`currency`	Official currency of the country.
`currency_code`	Three-letter currency code (ISO 4217).
`population`	Census-based population estimate based on most recently available data..
`density`	Population density per square kilometer.
`area`	Total land and water areas delimited by international boundaries and coastlines.
`gdp`	Total value of all final goods and services produced within a nation.
`real_gdp_per_capita`	Real GDP divided by total population.
`labor_force`	Total labor force figure.
`median_age`	Age that divides a population into two numerically equal groups.
`unemployment_rate`	Percent of labor force without jobs.
`education_expenditures`	Public expenditure on education as a percent of GDP.
`life_expectancy`	Average years expected to be lived at time of birth.
`maternal_mortality_ratio`	Annual number of female deaths per 100,000 live births from pregnancy-related causes.
`infant_mortality_rate`	Deaths of infants under one year old per 1,000 live births.
`total_fertility_rate`	Average number of children born to women during their reproductive years.
`obesity_rate`	Percent of population with BMI greater than or equal to 30.0.
`alcohol_consumption_per_capita`	Recorded amount of alcohol consumed per person aged 15+ annually.
`tobacco_use`	Age standardized prevalence of tobacco use among persons 15+ years.
`children_underweight`	Percent of children under 5 with weight-for-age below WHO standards.
`net_migration_rate`	Difference between persons entering and leaving a country per 1,000 population.
`population_growth_rate`	Annual percent change in population, including migration.
`real_gdp_ppp`	GDP on purchasing power parity basis divided by population.
`real_gdp_growth_rate`	Annual percent increase in real GDP.
`inflation_rate`	Annual percent increase in consumer prices.
`youth_unemployment_rate`	Percent of total labor force ages 15-24 unemployed.
`gini_coefficient`	Measure of income inequality (0 = perfect equality, 100 = perfect inequality).
`budget_surplus_or_deficit`	Government budget balance as percent of GDP.
`taxes_and_revenues`	Sum of all government revenue as percent of GDP.
`current_account_balance`	Sum of net trade in goods and services, net earnings, and net transfer payments.
`birth_rate`	Annual births per 1,000 persons, main factor in population growth.
`exports`	Total value of goods and services sold to other countries.
`imports`	Total value of goods and services bought from other countries.
`reserves`	Total reserves of foreign exchange and gold.
`debt_external`	Total public and private debt owed to nonresidents repayable in foreign currency.
`railways`	Total length of railway network in kilometers.
`roadways`	Total length of road network in kilometers.
`waterways`	Total length of navigable waterways in kilometers.
`military_expenditures`	Annual military spending as a percent of GDP.
`electricity_installed`	Total installed electricity generating capacity in kilowatts.
`death_rate`	Annual deaths per 1,000 persons, indicating mortality impact.
`education_expenditures`	Public expenditure on education as percent of GDP.
`public_debt`	Total government borrowings less repayments in home currency.
`internet_users`	Number of individuals who can access Internet at home.
`airports`	Total number of active airports including civilian and military facilities.
`electricity_consumption`	Total electricity generated annually plus imports minus exports in kWh.
`electricity_exports`	Total amount of exported electricity in kWh.
`electricity_imports`	Total amount of imported electricity in kWh.
`energy_consumption_per_capita`	Total energy consumption per capita in British thermal Units per person.
`cellular_per_100`	Mobile cellular telephone subscriptions per 100 inhabitants.
`broadband_subscriptions`	Total number of fixed-broadband subscriptions.
`country_formal`	The formal name of the country.
`country_abbrev`	The abbreviated name of the country. Useful for maps.
`country_zh`	The country name in Chinese.
`country_es`	The country name in Spanish.
`country_ar`	The country name in Arabic.
`country_hi`	The country name in Hindi.
`country_bn`	The country name in Bengali.
`country_pt`	The country name in Portuguese.
`country_ru`	The country name in Russian.
`country_ja`	The country name in Japanese.
`country_ko`	The country name in Korean.
`country_de`	The country name in German.
`country_it`	The country name in Italian.
`country_fr`	The country name in French.
`language`	The primary language spoken in the country. First item in `language_all`.
`language_all`	The primary languages spoken in the country. Delimited by \|.
`language_code`	The ISO language code for `language`.
`language_code_all`	The ISO language code for `language_all`. Delimited by \|
`website`	The official government website of the country.
`calling_code`	The international calling code for the country.
`driving_side`	The side of the road on which vehicles drive (right or left).
`continent`	The continent where the country is located.
`un_member`	Whether the country is a member of the United Nations (TRUE or FALSE).
`religion`	The most practiced religions in the country in order. Delimted by \|. Limit of 3. Lower threshold 10%. "No Religion" included.

Countries Database

Databases

Sample Preview

Included Fields

Frequently Asked Questions

Included Countries