World cities database

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

World city database World city database

I compiled this Word file starting from 2003, initially sourcing data from Encarta Encyclopedia 2002 that I got from a friend. 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 improved the Word file using Encarta 2006 and 2009, completing all countries. Since 2016 I offer an Excel version beside Word file, and also updated all countries to Encarta 2009.

As an original product “Made by Teoalida”, you will NOT find this database elsewhere on internet.

This city database classify cities based by icon used by Encarta Encyclopedia according city population so number of cities in each country is nearly proportional with country urban population. This city database does NOT pay attention to 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”, there is no “city” or “town” designation.

As 2017, the world city database contains:

  • 294 cities over 1,000,000 people from all countries.
  • 305 cities over 500,000 people from all countries.
  • 3085 cities over 100,000 people from all countries.
  • 4000+ cities over 20,000 people from selected countries that do not have too many cities: Eastern Europe, former U.S.S.R countries, Middle East, South-East Asia, Africa.

Depending by how many people purchase the database, I may add 20,000-100,000 cities from North and South America, Western Europe, South Asia, East Asia, Australia, etc, which may bring number of cities in database to about 15,000-20,000.

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 and United States if you want.

100,000+ cities represented on map

Cyan – 1,000,000+, Green 500,000+, Yellow 100,000+
Map coordinates are added automatically by Google Fusion Tables, some cities may be in wrong location due to having same name with another city or alternate spellings. The database does NOT contain GPS coordinates.

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 FULL one, and put them for sale so people can buy directly (instead of contacting me to get complete database). Also expanded the page to get more traffic from Google.

The city database is NOT FINISHED and will never be 100% complete, but may be sufficient for your needs, if not, I can do additional work if required, such as adding cities between 20,000 and 100,000 people from countries that I have not added yet, or do changes in data structure to make it more suitable for your project. Contact me and tell me your requirements!

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

Note: city classification is done based on the icon shown in Encarta Encyclopedia 2009, and it do not always reflect the actual 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.

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 76799 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 43299 cities from US compared with 33500 cities from rest of world. Price: 1 dollar per 1000 cities.

Download FREE sample

WorldCitiesDatabase-SAMPLE.xlsx

Buy FULL database

Buy & download

City database per country

Romania city population .XLS – I made 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. 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 GIS coordinates, latitude and longitude.

If you want for other countries, please ask!

Note: list of cities from certain countries can be also found on government census pages, for example http://censusindia.gov.in/Tables_Published/Admin_Units/admin.html – List of Towns in India – 5161 towns. If you can’t find a ready-available list of cities, contact me and I will see what I can compile from Wikipedia.

I think that I can also make a worldwide database of cities, sorted by country and administrative divisions, preferably without population because require too much effort and each country have different census year. But before starting this megalithic work I need to know who would need such database. Please tell how do you intend to use city data and what info / columns the database should contain!

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.

8 comments

2 pings

Skip to comment form

    • Hubert on October 2, 2016 at 10:15 am
    • Reply

    Hello you have a database with all the world’s countries
    Regions villages towns
    Thank you
    Hubert

    1. What do I have is what do you see on this page.
      What do you ask require a hell lot of work. May I know your budget and how do you intend to use the database?
      Definition of city, town and village vary from one country to another, how do you suggest to deal with this issue?
      You need only names, no population, latitude/longitude, or other details?

  1. My spouse and I stumbled over here coming from a
    different page and thought I may as well check things out.
    I like what I see so now i am following you.
    Look forward to finding out about your web page yet again.

  2. 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.

    Regards!

  3. What does authentic personal power appear like for you?

    • Maximalnii on September 3, 2018 at 11:05 am
    • Reply

    Selling Cell phone numbers for cold calls and SMS mailings of individuals in different countries: 35 million contacts are available, base in CSV format = 2018!
    list of countries: List of operators
    1-Belarus-1-Life-Velcom
    2-Armenia 2- Beeline
    3-Cameroon 3-Nextel
    4-Georgia 4-Beeline-Geocell
    5-Côte d’Ivoire 5-MTN
    6-Jordan 6-Zain
    7-Kyrgyzstan 7-Beeline
    8-Mozambique 8-Movitel
    9-Palestine 9-Jawal-Watania
    10-Tajikistan 10-Babilon, Beeline, Megafone
    11-East Timor 11- Telemor
    12-Uzbekistan 12-Beeline, Ucell, UMS
    All data fresh in 2018, will help you and your business! Our database numbers are simply vital to you if:
    1: You are a call center that deals with sales to customers
    2: You are a small and medium business owner with your sales team
    3: Do you send SMS to customers
    4: Do you plan to send SMS with your services for yourself
    About the purchase you can access via: email: phonenumbersforsell@gmail.com skype: phonenumbersforsell@gmail.com

    1. I have no idea why did you posted this spammy comment with phone numbers on a page about GEOGRAPHY, however you contacted me via live chat afterwards and made me to understand for first time that mobile app developers collect phone numbers and may sell them.

      In the past I got MANY people asking me for phone numbers database for telemarketing and I answered to all that there is not possible to get such things. These people are idiots that do not understand that I am selling a database of mobile phone DEVICES and NOT NUMBERS. In the future I will try to tell them to contact you.

  4. 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: https://it.wikipedia.org/wiki/Suddivisioni_dell%27Italia 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. […] World cities […]

  2. […] mobile app developers sell phone numbers database: in September 2018 someone has posted this spammy comment and talking with him I realized that he is mobile app developer and have phone numbers of people […]

Leave a Reply

Your email address will not be published.