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

Question

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:

• http://www.maxmind.com/app/csv
• http://www.geodatasource.com/world-cities-database/free
• http://developer.yahoo.com/geo/geoplanet/data/

But all of them exclude the states.

Answer 1

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

Answer 2

geonames.org has an api and a data dump of worldwide geographical places.