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
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
Updating an object with setState in React

Is it at all possible to update object's properties with setState? Something like: this.state = { jasper: { name: 'jasper', age: 28 }, } I have tried: this.setState({jasper.name: 'someOtherName'}); and this: this.setState({jasper: {name: 'someothername'}}) The first results in a syntax …

Read More