World cities database

News May 2020: the original Encarta-based 8000-city database got 22 sales (first sale April 2017) while 3-million city database did not got a single sale (published October 2019) giving me impression that offering databases with more cities does NOT mean more sales.

The number of people visiting this page increased significantly in 2020 compared with 2019 so I decided to offer an update, for the 3-million city database I provide colorful Excel instead of a plain CSV, while for Encarta-based database I made a POLL in March and seeing what people voted here plus what some people told me via chat, I decided to add 3 more columns in database: country capital, region capital, top 5/10 cities (to allow easy filtering if you need only capitals or biggest cities by country), I am also thinking to add more smaller cities but this will take some time… If you have more suggestions, please tell!

World city database World city database

This is a handmade database that I started in 2003, sourcing data from Encarta Encyclopedia 2002 that I got from a friend and writing it in Microsoft Word. It was the ONLY recent geography encyclopedia I had in my hands, all others being world atlas books from my parents childhood (1970s). I did not had connection to internet until 2005 to get other sources of data. Over next years I added more countries using Encarta 2006, and in 2016 updated all countries to Encarta 2009 and offer Excel version beside Word file.

Being an original product “Made by Teoalida”, you will NOT find this database elsewhere on internet. Having all data from a single source guarantee a harmonized database of all countries.

Don’t forget to check other databases made by me (100+ databases).

Download FREE samples:
World Cities Database simple version .DOC
World Cities Database detailed version .DOC
World Cities Database detailed version .XLS

Buy FULL city database:

Buy & download

As 2017, the world city database contains:

  • 294 cities with over 1,000,000 people from all countries.
  • 305 cities with 500,000 – 1,000,000 people from all countries.
  • 3085 cities with 100,000 – 500,000 people from all countries.
  • 4000+ with 20,000 – 100,000 people from selected countries that do not have too many cities: North Europe, Eastern Europe (east of Germany), former U.S.S.R countries, all Middle East, all Africa, Japan, North and South Korea, South-East Asia.

Based on feedback from customers, I realized that most purchased city database for web development, making drop-down boxes for country, state/province, city, thus city population was not required, but classifying cities by population helped them to shortlist database to major cities only.

Sales of city database been far lower than other databases made by me, but if more people continue to buy it AND require more cities, I can add also 20,000-100,000 cities from North and South America, Western Europe, South Asia, Japan, China, Australia, etc, which may raise number of cities in database to about 15,000-20,000.

How many cities do you need?

Country capitals only
Country capitals and state/region capitals
All cities/towns/places over 100,000 people, regardless of legal status
All cities/towns/places over 20,000 people, regardless of legal status
Top 5-10 most populous cities/towns/places from each country, regardless of population group
All and only cities that have legal status of “city”, regardless of population group (note: Italy do not have any “city”, instead it have 7954 “communes”)
As many places is possible regardless of their legal status (cities, towns, neighborhoods, communes, villages, etc)
Please Specify:
Created with Poll Maker

Note for city classification

Cities are classified according icons used by Encarta Encyclopedia 2009, the icons do not always reflect population indicated in city article. For example there are cities with icon of 1,000,000+ but having population around 900,000, as well as cities with icon of 500,000+ but having population over 1 million. Most cities under 100,000 do not even have article to indicate exact population. This was Encarta Encyclopedia, the only resource of information available for me before connecting to internet.

Database does not indicate cities administrative status, which vary from country to country so making a single worldwide database of official “cities” excluding towns, communes, villages and other places pose major troubles, especially since few countries does not have any “city”.

For example: Romania have officially 103 municipalities and 217 towns, but my database include 116 cities that have icon of 20,000+ population in Encarta Encyclopedia. Germany have 2058 “towns”, Italy have 7954 “communes”, Spain have 8122 “municipalities”. Italy and Spain do not have “city” or “town” designation. If I would source data from census websites of each country, or Wikipedia, harmonizing all countries into a single database would be a HELL.

Classifying cities according Encarta Encyclopedia helped me to make a harmonized database all over the world. Consequently, number of cities in each country is nearly proportional with country urban population, in average for every 800,000 country population living in urban areas, there is 1 city over 100,000 people.

Countries included

191 independent countries: Afghanistan, Albania, Algeria, Andorra, Angola, Antigua and Barbuda, Argentina, Armenia, Australia, Austria, Azerbaijan, Bahrain, Bangladesh, Barbados, Belarus, Belgium, Belize, Benin, Bhutan, Bolivia, Bosnia, Botswana, Brazil, Brunei, Bulgaria, Burkina Faso, Burundi, Cambodia, Cameroon, Canada, Cape Verde, Central African Republic, Chad, Chile, China, Colombia, Comoros, Congo, Costa Rica, Côte d’Ivoire, Croatia, Cuba, Cyprus, Czech, Democratic Republic of the Congo, Denmark, Djibouti, Dominica, Dominican Republic, Ecuador, Egypt, El Salvador, Equatorial Guinea, Eritrea, Estonia, Ethiopia, Federal Republic of Yugoslavia, Federated States of Micronesia, Federation of Saint Kitts and Nevis, Fiji Islands, Finland, Former Yugoslav Republic of Macedonia, France, Gabon, Georgia, Germany, Ghana, Greece, Grenada, Guatemala, Guinea, Guinea-Bissau, Guyana, Haiti, Honduras, Hungary, Iceland, India, Indonesia, Iran, Iraq, Ireland, Israel, Italy, Jamaica, Japan, Jordan, Kazakhstan, Kenya, Kiribati, Kuwait, Kyrgyzstan, Laos, Latvia, Lebanon, Lesotho, Liberia, Libya, Liechtenstein, Lithuania, Luxembourg, Madagascar, Malawi, Malaysia, Maldives, Mali, Malta, Marshall Islands, Mauritania, Mauritius, Mexico, Moldova, Monaco, Mongolia, Morocco, Mozambique, Myanmar, Namibia, Nauru, Nepal, Netherlands, New Zealand, Nicaragua, Niger, Nigeria, North Korea, Norway, Oman, Pakistan, Palau, Panama, Papua New Guinea, Paraguay, Peru, Philippines, Poland, Portugal, Qatar, Romania, Russia, Rwanda, Saint Lucia, Saint Vincent and The Grenadines, Samoa, San Marino, Sao Tomé and Príncipe, Saudi Arabia, Senegal, Seychelles, Sierra Leone, Singapore, Syria, Slovakia, Slovenia, Solomon Islands, Somalia, South Africa, South Korea, Spain, Sri Lanka, Sudan, Suriname, Swaziland, Sweden, Switzerland, Tajikistan, Tanzania, Thailand, The Bahamas, The Gambia, Togo, Tonga, Trinidad Tobago, Tunisia, Turkey, Turkmenistan, Tuvalu, Uganda, Ukraine, United Arab Emirates, United Kingdom, United States, Uruguay, Uzbekistan, Vanuatu, Vatican City, Venezuela, Vietnam, Yemen, Zambia, Zimbabwe.

Plus dependent territories.

Administrative divisions (states, regions, provinces, etc) are included for 30 most major countries, second-level administrative divisions are included only for Italy at this moment, but I am able to add them also for United Kingdom, France, Spain, Greece and United States if you want.

City database history

Geography is my oldest hobby, starting around 6 years old I was studying geographic atlases and already learned all the countries and capitals. Between 1998 and 2005 I done few works in Word / Excel based on World atlas books or digital encyclopedias, updated them and published on website for first time in 2015.

2003-2005 – I compiled list of cities of Europe, former USSR countries, Middle East and Africa. Using Encarta 2002, which have a limited amount  of cities shown on map so I was planning to include ALL cities shown on map, meaning cities over 20.000 people, but for biggest countries of Europe would have been too many so I have included only cities over 100.000 people.

2005 – my family installed internet connection. I discovered Wikipedia and no longer saw a purpose of making my own world cities database, the internet provided already up-to-date population numbers and updating my table constantly is a waste of effort. I left geography and migrated to other hobbies such as architecture, without finishing the list of World Cities as intended (to include all cities over 20,000 people from EVERY country).

2006-2007 – I included few more countries: China, Japan, Mexico, etc, using Encarta 2006, this one having a lot more cities shown on map, would take a lifetime to include all, so I decided to include only cities over 100,000+ people. Then I let the city database abandoned.

2015 – given by the success of one of my other hobbies, Car Database, which turned into a business by selling Excel databases to companies and web developers, I started questioning whenever the World Cities hobby, if converted to Excel, may be useful for web developers for CSV and MySQL databases. I published for the first time the incomplete city database on my website, one-country SAMPLE, inviting people to contact me if they wants the Word file for free, or Excel conversion as paid service.

Over next months I completed remaining countries from Asia, North and South America, including cities over 100,000 people, using Encarta 2009 (last Encarta). I created 2 Word files, one for all countries including cities over 100,000 (60 pages) and one for 20 biggest countries, including cities by province over 20,000 or 100,000 depending by case (70 pages).

2016 August – first person contact me to ask for city database. An Indian wanted list of cities in Excel, I offered him to convert the Word to Excel but he was not patient and asked me to give what I currently have (the Word file). However, I started converting it to Excel to be ready for sale when next customer is coming. I created 2 Word files, both containing all countries, LITE one containing cities over 100,000 and BIG one contain cities over 20,000 by province, plus the Excel file similar with Word BIG file, and put them for sale so people can buy directly (instead of contacting me to get complete database). Also expanded the article to get more traffic from Google.

By November 2017, 5 people purchased it, reason for which I decided to offer an update adding more cities from specific countries.

3 million cities, towns and villages, all with latitude and longitude

One of my programmer partners has shared with me a HUGE world city database with over 3 million rows in CSV format, with permission to sell via my website.

The database include 3,173,958 lines from 234 countries. Each row include GPS coordinates. 47980 lines include also city population. The remaining lines we can assume that are towns, villages or other insignificant places so that is why population is not known.

There is a column “Region” that shows a number, I believe that this was relational with another file Region ID + Region Name but my programmer don’t have that other file. How he obtained this file without other file remains a mystery. I counted about 3700 countries / region combinations, in theory I can region IDs with actual names myself, is just a matter of time.

Excel can display max 1,048,576 rows, consequently I had to split CSV file into 4 sheets to be displayed in Excel, where I added borders and colors to match the style of other databases “Made by Teoalida” and made a statistics sheet with formulas to count number of cities by country. Feel free to combine them, or I can give original CSV file if you want to import in a SQL database or whatever…

Download FREE sample:

3 million cities, towns, villages SAMPLE.xlsx.

Buy FULL database:

Buy & download

Another world city database

In November 2017 one customer gave me his world city database in exchange of a database made by me, with permission to resell it on my website.

This world city database contains 76,799 cities, sorted by 212 countries, 51 US states, 13 Canadian provinces, 4 UK countries. For other countries it do not contain administrative divisions. The database focus primarily on United States, as it contains 43,299 cities from US compared with 33,500 cities from rest of world. Price: 1 dollar per 1000 cities.

Download FREE sample:


Buy FULL database:

Buy & download

Other geography stuff

In 1998-2003 I also wrote lists of natural features, seas, rivers, etc, and astronomy-related stuff…. all in Word. I started using Excel more than Word in 2003. Today I consider them useless because such info exist for FREE on Wikipedia and is not necessary to make my own databases.

Romania city population .XLS – I made this originally in 1999 in Word sourcing data from books then remade in 2006 in Excel format sourcing data from Wikipedia pages of each city (hours of work!). It does contains all 320 cities of Romania with their population at every census from 1912 to 2011 (next census probably in 2020) except when they did not had city status at the census year. I offered it for free download until 2018 when I updated-expanded file to include 2861 communes beside cities, but without population, and GPS coordinates for both cities and communes, now selling at 20 euro for this effort. Why Romania? Because here I was born.

United States city population .XLS – including 304 cities with over 100.000 inhabitants. Source of data: Wikipedia, copy-pasted in Excel and enhanced visually. Contains population at 2010 census, 2015 estimate, as well as area, density and GPS coordinates, latitude and longitude.

Does anyone know where I can find a complete list of US counties and cities? I do not really need download-able format, you can tell me a website where I can extract data from using an automated script.

Free data from government

Most countries provide open data for free download on their government / census websites, example: – list of communes in Italy. Deutchland Städte nach Fläche, Bevölkerung – list of 2058 cities in Germany. – List of Towns in India – 5161 towns.

Now, my plan is to take open data from government websites (or scrap from Wikipedia for countries where there is no data available from government), compile all countries into a single database and offer it as paid download for efforts of compiling. With ~200 countries in the world, this may be a huge effort. Census year vary from country to country so I will probably not include city population. Next problem is that, if I stick database to cities only, Romania would have 320 cities but Italy will have 0. If I include 7954 communes of Italy, I will probably need to include also the 2861 communes of Romania and not just 320 cities. If anyone is interested in this project, or have suggestions how to make it better, please contact me!

8 thoughts on “World cities database

  1. Do you mind if I quote a few of your articles as long as I provide credit and sources
    back to your website? My blog site is in the exact same
    niche as yours and my visitors would certainly benefit from
    some of the information you present here. Please let me know if this ok with you.


  2. Chat started on Monday, October 08, 2018 2:17:07 PM

    (2:17:07 PM) *** Visitor 91355061 has joined the chat ***
    (2:17:09 PM) Teoalida (site owner): Hi there… are you looking for a specific database? you are welcome for a chat!
    (2:27:33 PM) Visitor 91355061: Yes i need a complete list of cities
    (2:28:32 PM) *** Teoalida has joined the chat ***
    (2:28:36 PM) Teoalida: is my database complete enough?
    (2:28:38 PM) Teoalida: 8000+ cities
    (2:28:55 PM) Visitor 91355061: it has unwanted list.
    (2:29:07 PM) Teoalida: too many cities?
    (2:30:16 PM) Teoalida: how many cities do you need?
    (2:30:31 PM) Teoalida: do you need cities over certain population or…?
    (2:30:39 PM) Visitor 91355061: for example in italy it states that there are 460 cities
    (2:30:48 PM) Visitor 91355061: however, actually there are 160 cities only
    (2:32:17 PM) Teoalida: where did you got 160 cities figure?
    (2:32:27 PM) Teoalida: in Romania are 103 municipalities and 217 cities
    (2:32:36 PM) Teoalida: maybe similar situation is in Italy
    (2:33:08 PM) Teoalida: my database include all cities with 20.000+ icon in Encarta Encyclopedia regardless of administrative status (because status vary from country to country)
    (2:34:18 PM) Teoalida: I am thinking to make another database having only places that are officially designated as city, but because definition of city vary from country to country, it’s a hell of troubles
    (2:42:45 PM) Teoalida: Alla data del 1º marzo 2017 i comuni italiani sono 7.982
    (2:54:12 PM) *** Visitor 91355061 has left ***

    I want your proofs that Italy have 160 cities because I googled and can’t find any evidence of this!

    1. Jackson is included under Mississippi, proof:

      The original idea was to add 20,000 – 100,000 cities too for all countries from Encarta 2009, but the low sales of city database (compared with other databases made by me) discourage me from spending more time on this project to add more cities.

      I also don’t see any purchase on your email address, when did you purchased it? Or do you want me to create a new database just for United States by scraping data from ?

  3. Chat started on Wednesday, September 18, 2019 3:27:53 PM

    (3:27:53 PM) *** Visitor 89571760 has joined the chat ***
    (3:27:55 PM) Teoalida (site owner): Hello visitor from India, are you looking for a specific database? Let me know if I can help you!
    (3:29:26 PM) Visitor 89571760: List of world countries, state, city database
    (3:29:39 PM) *** Teoalida has joined the chat ***
    (3:29:42 PM) Teoalida: how many cities do you need?
    (3:30:36 PM) Visitor 89571760: Europw, US, Canada till cities, rest of the world till state
    (3:31:27 PM) Teoalida: as you can see I have 2 databases, one with ~8000 cities that include states/provinces too and one with 76799 that do not include state/provinces
    (3:32:49 PM) Visitor 89571760: EUROPE, US, CANADA TILL CITIES (COutry, state, city) and rest of the world country, state
    (3:34:28 PM) Teoalida: can you check my samples to see if my databases suit your needs?
    (3:35:24 PM) Teoalida:
    (3:35:59 PM) Visitor 89571760: You do not have pincode
    (3:36:35 PM) *** Visitor 89571760 has left ***

    You quit too fast before allowing me to reply that pin code is ONLY in India and is provided FREE in and

  4. Index Search Villas and lofts for rent, search by region, find during first minutes a villa for
    rental by city, a range of rooms lofts and villas. Be impressed by
    the photos and knowledge that the site has to make available you.
    The website is a center for everybody the ads inside the field, bachelorette
    party? Have fun with somebody who leaves Israel?
    Whatever the main reason you need to rent a villa for a potential event or just an organization recreation suitable
    for any age. The site is also the middle of rooms with the hour, which is definitely another subject, for lovers who are seeking a luxurious room equipped for discreet entertainment
    having a spouse or lover. Whatever you are looking for, the 0LOFT
    website constitutes a hunt for you to find rentals for
    loft villas and rooms throughout Israel, North South
    and Gush Dan.

  5. Welcome to Israel. In this escort directory section, you find
    Israel escorts. Euro Girls Escort is probably the
    most trusted escort directory and one of many biggest
    21girlz directory. All content and photos are regularly
    checked and updated with real photos. This makes certain, that most escort
    Ads are usually current and provides you the very best experience.

    This section of the catalogue features luxury companions providing escort services.
    Israel escorts works in elite escort agencies, as an independent escorts or in local strip clubs, dancing clubs, brothels, lap-dance bars and cabarets.
    A lot of the high class ladies do travel worldwide.
    You may even want to utilize call girl services – these escort
    girls can either work incall or outcall. Such elite escorts
    may be invited to a college accommodation or you can visit them in their place.

Leave a Reply

Your email address will not be published. Required fields are marked *