Where can I get a list of Countries, States and Cities?

state country city datafeed
Jonathan picture Jonathan · Mar 9, 2012 · Viewed 165.4k times · Source

This probably seems like a duplicate, since there are identical questions out there.

Unfortunately all of the answers to all of these questions are missing one detail: the states.

Where can I get a list of countries, states and cities?

For example, I want this:

| Sydney  |  New South Wales  |  Australia  |

or

|  Miami  |  Florida          |  United States  |

I don't want something like this, which excludes the state:

|  Miami  |  United States  |

Is there any place where I can get this kind of data?

I've already tried the following data sources:

But all of them exclude the states.

Answer

Eric picture Eric · Dec 18, 2013

The UN maintains a list of countries and "states" / regions for economic trade. That DB is available here: http://www.unece.org/cefact/locode/welcome.html

Related questions

Django - Country -> State-> City Dropdown list

I have been trying to create a 3 column drop-down list as Country, State, City. The list of state will be shown based on which country is selected. and the same thing happens to city depends on which State is selected. …

Read More
Is there any API for getting all countries and passing country get all States/Region and again passing State/Region get all cities in it

I am creating a web page in asp.net where I have to populate all countries in a dropdown. On selecting one country I need to populate all States/Region in that country to another dropdown. finally on selecting the …

Read More
React: how to update state.item[1] in state using setState?

I'm creating an app where the user can design his own form. E.g. specify name of the field and details of which other columns that should be included. The component is available as a JSFiddle here. My initial state …

Read More