6

Is there any quick guide/reference to list all the countries and its states/provinces?

Like when I click US, it will list: Alabama, alaska etc

6 Answers6

8

pycountry is the most complete free reference I was ever able to find:

pycountry provides the ISO databases for the standards:

639 Languages
3166 Countries
3166-2 Subdivisions of countries
4217 Currencies
15924 Scripts

The databases are imported from Debian's pkg-isocodes, packaged into pycountry and made accessible through a Python API.

Translation files for the various strings are included as well.
Alix Axel
  • 151,645
  • 95
  • 393
  • 500
  • 1
    You wouldn't believe how long I looked for something like this. It contains a XML file with all the different first and sometimes second level subdivisions of countries, which is just what I needed. Everyone else just says to use Geonames which doesn't contain this information. Thanks! – David R. Nov 04 '14 at 16:42
4

Grabbing data from Geonames would be an option. It is kept relatively up to date, and is under a CC license.

EternalHour
  • 8,308
  • 6
  • 38
  • 57
squeeks
  • 1,269
  • 11
  • 14
  • [This Geonames file](http://download.geonames.org/export/dump/admin1CodesASCII.txt) contains all of the subdivisions for each country code. It is tab-separated. – jdhildeb Aug 21 '14 at 19:12
3

I don't have code to do it, but if you want a good (free) list of administrative districts for most of the world you can use this Wikipedia page.

beggs
  • 4,185
  • 2
  • 30
  • 30
  • Should I copy the list from others website? Is it consider stealing? I know, I should not do that, but, I am stuck in listing countries.. –  Sep 15 '09 at 03:49
  • 1
    copying the information from Wikipedia is not stealing. As stated in the Wikipedia TOS: "You can re-use content from Wikimedia projects freely, with the exception of content that is used under "fair use" exemptions, or similar exemptions of copyright law" (see: http://wikimediafoundation.org/wiki/Terms_of_Use for more info) As for randy melder's answer, the user is posting it for others to use and it was generated from ISO data which is freely distributed for all to use. – beggs Sep 15 '09 at 03:54
2

As Squeeks says you can use GeoNames.

I did a tool ( https://github.com/yosoyadri/GeoNames-XML-Builder ) that downloads and saves GeoNames response as a XML file based on the library at http://geonamesdotorgdotnet.codeplex.com/.

You can also download a complete file of countries and states/provinces at https://raw.github.com/yosoyadri/GeoNames-XML-Builder/master/continents-countries-statesprovinces.xml

Yosoyadri
  • 551
  • 5
  • 8
  • It's a bit messy tho, at least for my country. The `2742026` is also a district like the rest (so either one of them is not consistent). Plus, there are only 2 entries for the local name, one of them is in English and the other one in Spanish, but `2735941` only lists one (Spanish) and the it's English in reality. The `2267056` only lists the Portuguese name under the `LocalNameES` tag. – Alix Axel Nov 21 '12 at 00:15
1

In case you don't want to use sql, here is just a javascript with region country's province/state, i found it a while ago. Maybe its of good use....

http://www.sitepoint.com/forums/showthread.php?350291-Country-State-City-Dropdown-list

Esocoder
  • 1,032
  • 1
  • 19
  • 40
  • `city_states['Portugal'] = '|Lisbon||Aveiro|Acores (Azores)|Beja|Braga|Braganca|Castelo Branco|Coimbra|Evora|Faro|Guarda|Leiria|Lisboa|Madeira|Portalegre|Porto|Santarem|Setubal|Viana do Castelo|Vila Real|Viseu';` has Lisbon repeated twice - doesn't seem very reliable. – Alix Axel Nov 09 '12 at 02:43
-1

This is as close as it gets. http://27.org/isocountrylist/

This list is rather old, however it does offer a great deal of value for those wanting a country list, with codes and abbreviations. Also, there is a link to US States and provinces there too. This has been a good resource over the years.

With this table data, it's possible for someone to create some normalized data between countries, states, provinces, counties or whatever political jurisdictions.

I thought this would be a huge time saver for this task.

randomx
  • 2,357
  • 1
  • 21
  • 30