Containing all of the cities, towns and other populated places (without duplicated records) from all countries and territories, this is the best world cities database for your websites and other applications.

If you’ve ever asked users to type in their country, state and city in a form, you probably found out that your database was quickly filled with many name variants (for instance, “Washington”, “washington, d.c.”, “WASHINGTON D.C.”, “Wash., DC”, etc…) as well as misspelled names.
All you need is to pre-populate dropdown lists with the countries, states and cities from worldCities and your users will always select the correct names. It is very easy to import our data into MySQL or any other database!

Select your worldCities version:

SKU: N/A Category:

Product Description

Our worldCities geographical database is normalized, which makes it very efficient, as well as easy to use. Indeed, the tables containing different types of data (names, hierarchy, data description, etc…) can all be linked using a single ID.

Besides the main worldCities database, which contains continents, countries, administrative divisions and populated places (cities, towns, villages, etc…), other pieces of data are available in external modules. The currently available worldCities Extensions are GPS Coordinates, Language Pack, Standard Codes and Importance. You can thus pick and choose what you need without having to purchase data you won’t use.

Main features

  • Populated places classified in up-to 4 levels of administrative divisions (states, provinces, etc…)
  • Continents, regions and subregions
  • Hierarchy in both parent-child and pre-ordered tree traversal
  • Names in local language (in their romanized form when the local language uses a non-latin writing system)
  • English names (not available for all cities and states records)
  • All names both with and without diacritics and special characters
  • Free unlimited e-mail support
  • Additional features in worldCities Extensions (optional):
    • 319,000 translations and local names in non-latin writing systems. Available in the Language Pack worldCities Extension
    • Latitude and longitude (in decimal degrees) of all of populated places. Available in the GPS Coordinates worldCities Extension
    • Standard FIPS and ISO codes for all 7,700 continents/macro-regions, countries/territories and administrative divisions. Available in the Standard Codes worldCities Extension
    • Relative importance (on a 1-5 scale) of each of the populated places (cities, towns, villages,…). Available in the Importance worldCities Extension

↓ Sample data ↓

To give you the ability to properly evaluate our data, we offer extensive worldCities sample data for free, containing data about 480,000 places.

Useful links:

Contact us

Feel free to contact us if you have any questions about the use of our worldCities database or multiple-licenses/redistribution terms and conditions, and we will be pleased to help you.

Additional Information