Major cities of the world

Request access to view and download the premium version of this dataset.

Request →

FilesSizeFormatCreatedUpdatedLicenseSource
11.15 MBcsv7 days agoGeonames

List of the world's major cities (above 15,000 inhabitants)

Read more

Data Files

FileDescriptionSizeLast modifiedDownload
world-cities
1.15 MB7 days ago
world-cities

Data Previews

world-cities

Schema

nametypedescription
namestringEnglish name of the city
countrystringCommon name of the country, in english
subcountrystringName of the major administrative area
geonameidintegerid from geonames

badge

List of major cities in the world

Data

The data is extracted from geonames, a very exhaustive list of worldwide toponyms.

This datapackage only list cities above 15,000 inhabitants. Each city is associated with its country and subcountry to reduce the number of ambiguities. Subcountry can be the name of a state (eg in United Kingdom or the United States of America) or the major administrative section (eg ”region” in France”). See admin1 field on geonames website for further info about subcountry.

Notice that :

  • some cities like Vatican city or Singapore are a whole state so they don't belong to any subcountry. Therefore subcountry is N/A.
  • There is no guaranty that a city has a unique name in a country and subcountry (At the time of writing, there are about 60 ambiguities). But for each city, the source data primary key geonameid is provided.

Preparation

Preparation

Python 3.6 .github/workflows/actions.yml

This repository uses dataflows to process and normalize the data.

You first need to install the dependencies:

pip install -r scripts/requirements.txt

Then run the script

python scripts/process.py

License

All data is licensed under the Creative Common Attribution License as is the original data from geonames. This means you have to credit geonames when using the data. And while no credit is formally required a link back or credit to Lexman and the Open Knowledge Foundation is much appreciated.

All source code is licensed under the MIT licence.

© 2024 All rights reservedBuilt with DataHub Cloud