Countries, Regions, Cities

I want to share the base of countries, regions and cities in Russian. Perhaps someone will come in handy in their projects. In base of 106 countries , 922 regions and 10969 cities !



If someone does not understand what it is about, then remember, for example, how a city is indicated on VKontakte: a country is selected -> a list of regions is loaded -> a region is selected -> a list of cities is loaded



You can download the database in three formats:

1. CSV: csv.zip

2. MySQL: sql.zip

3. XML: xml.zip

')

Oh, I almost forgot! The idea of ​​putting the base put me to the post about ExtJS , where you can also drag out another version of the base of countries, regions, cities.



I hope that helped :) ( UPD0: by rating the post I see that helped many :-)



UPD: Link to CSV updated! Fill the correct archive, with divided countries, cities and regions (the 1st lines in each file are descriptions)



UPD2: Added link to the XML version;)