Ask HN: Is there a free download of countries and their major cities available?

Or this has the capital and cities larger than the capital: http://en.wikipedia.org/wiki/List_of_capitals_and_largest_ci...

I know you wanted cities, but maybe this could do

The database is pretty extensive, but you should only need to query it once to get what you need.

And then about eight hours' work to look up and type in the names of all the major cities in each country?

It would require you to do some parsing to filter what you need but the info is there.

http://en.wikipedia.org/wiki/List_of_capitals_and_larger_cit...