Where can I download a list of world cities and towns by ISO 3166-2 state code? [closed]

Question

World countries and their standard codes are listed in ISO 3166-1. States (whatever are they called in different countries ("lands" in Germany, "federation subjects" in Russia etc.)) of the countries and their codes are defined in ISO 3166-2. But I couldn't find anything like this for cities.

What I need is a table listing of world cities where it would be also shown in what particular state are they situated and the state would be designated by an ISO 3166-2 code.

I have managed to find such a table listing USA cities (here) but I also need other countries data.

Answer 1

I was searching for information on the same issue and I've just discovered the UN LOCODE standard:

Currently, UN/LOCODE includes over 97,114 locations in 249 countries and installations in international waters. It is used by most major shipping companies, by freight forwarders and in the manufacturing industry around the world. It is also applied by national governments and in trade related activities, such as statistics where it is used by the European Union, by the UPU for certain postal services, etc

You can download for free the full LOCODE list in MS Access .mdb, .csv and .txt formats.

Hope this will help you. :)

Regards, -- Wayfarer

Answer 2

A search on GitHub leads some dataset https://github.com/search?q=iso%203166%202

Here you find it in CSV for instance https://github.com/fran-diaz/ISO-3166