Joined: 17/06/2017 16:51:26
The allCountries.zip in /dump only contains countries and cities, but no states/provinces. (For example, the row for Sydney, Australia does not contain "New South Wales" anywhere.)
The allCountries.zip in /zip do contain countries, states/provinces, and cities (e.g. Sydney, New South Wales, Australia), but is limited to just countries that use Postal Codes (only about 80 or so).
So where can I find a COMPLETE database of ALL countries, states/provinces (full names), and cities in the world?
This database should show, for example, both "Sydney, New South Wales, AU" and "Kabul, Kabul, AF".