Capital cities of the world
The capital city of every sovereign state, with population, area, elevation, coordinates and year founded; countries with more than one capital (such as South Africa or Bolivia) have one row per capital with its role. One row per country and capital.
Columns
Stable keys — use them in the API, SQL and code
| Key | Name | Type | Description |
|---|---|---|---|
| id | ID | string | Country and capital Wikidata ids. |
| capital | Capital | string | — |
| capital_wikidata | Capital (Wikidata) | entity | — |
| country_name | Country | string | — |
| country | ISO3 | country | ISO 3166-1 alpha-3 code of the country. |
| country_wikidata | Country (Wikidata) | entity | — |
| role | Role | string | For countries with several capitals: what this one is the capital for. |
| population | Population | integer | Most recent population figure of the city in Wikidata. |
| population_year | Population year | year | — |
| area_km2 | Area | number · km² | Area of the city as recorded in Wikidata. |
| elevation_m | Elevation | number · m | Elevation above sea level in metres. |
| founded | Founded | year | Year of the city's inception (negative = BCE). |
| lat | Latitude | number | — |
| lon | Longitude | number | — |
More in Countries & Places
Tallest buildings in the world
Completed buildings and skyscrapers with an architectural height of at least 250 metres, as recorded in Wikidata. One row per building.
Countries of the world: key economic and social indicators
Every country with its region, income group and capital, plus the latest available value and year of 20 World Bank indicators from population and GDP to life expectancy, CO₂ per person and inequality. One row per country.
Countries of the world
Every present-day sovereign state with its ISO codes, capital, continent, area, population, official languages, currency, head of state and government, founding date, calling code, internet domain and flag. One row per country.
World population, 1960 to present
Total population of the world each year since 1960, with the annual growth rate. One row per year.
Largest chains and brands in each country by number of locations
For every country, the store chains, restaurant chains, banks, fuel brands and other branded businesses with at least 10 mapped locations there in Overture Maps, ranked by number of locations. One row per brand per country.
Median age by country, 1950–2100
The median age of each country's population — half the people are younger, half older — from 1950, with UN medium-scenario projections to 2100. One row is one country in one year.