available in multiple languages, in CSV, JSON and SQL formats, with associated codes as defined by the ISO 3166 standard, and with national flags included
Constantly updated lists of world countries, territories and areas of geographical interest, with associated alpha-2, alpha-3 and numeric codes as defined by the ISO 3166-1 standard, published and maintained by the International Organization for Standardization, available in CSV, JSON and SQL formats, in multiple languages and with national flags included.
In the language folders you will find files named in two different ways. Here's what you will find in each of them:
| File names | Content |
|---|---|
| world.* | Files named like this contain all the 249 countries, territories, and areas of geographical interest that have an officially assigned ISO 3166-1 code. |
| countries.* | Files named like this contain 195 entries made up from the 193 sovereign states (commonly refered to as countries) that are members of the United Nations (UN) plus the 2 observer states of Palestine and the Vatican City State. |
Note that there are 206 sovereign states in the world, the 11 states that are missing from the countries list being the ones having their sovereignty disputed. See the list of sovereign states with information on their status and recognition of their sovereignty.
The files contain:
- the ISO 3166-1 numeric country codes
- the ISO 3166 official short names in English1
- the ISO 3166-1 alpha-2 two-letter country codes
- the ISO 3166-1 alpha-3 three-letter country codes
1 for other languages the country names are in that particular language
The lists are currently available in 22 languages:
- Arabic
- Chinese
- Czech
- Dutch
- English
- Estonian
- French
- German
- Greek
- Hungarian
- Italian
- Japanese
- Lithuanian
- Norwegian
- Polish
- Portuguese
- Romanian
- Russian
- Slovak
- Spanish
- Thai
- Ukrainian
Excerpt from the data/en/countries.sql file:
...
(250,'France','fr','fra'),
(266,'Gabon','ga','gab'),
(270,'Gambia','gm','gmb'),
(268,'Georgia','ge','geo'),
(276,'Germany','de','deu'),
(288,'Ghana','gh','gha'),
(300,'Greece','gr','grc'),
(308,'Grenada','gd','grd'),
...Excerpt from the data/en/countries.csv file:
...
250,France,fr,fra
266,Gabon,ga,gab
270,Gambia,gm,gmb
268,Georgia,ge,geo
276,Germany,de,deu
288,Ghana,gh,gha
300,Greece,gr,grc
308,Grenada,gd,grd
...
Excerpt from the data/en/countries.json file:
...
{"id":250,"name":"France","alpha2":"fr","alpha3":"fra"},
{"id":266,"name":"Gabon","alpha2":"ga","alpha3":"gab"},
{"id":270,"name":"Gambia","alpha2":"gm","alpha3":"gmb"},
{"id":268,"name":"Georgia","alpha2":"ge","alpha3":"geo"},
{"id":276,"name":"Germany","alpha2":"de","alpha3":"deu"},
{"id":288,"name":"Ghana","alpha2":"gh","alpha3":"gha"},
{"id":300,"name":"Greece","alpha2":"gr","alpha3":"grc"},
{"id":308,"name":"Grenada","alpha2":"gd","alpha3":"grd"},
...You probably don't want to download the lists in all languages so go ahead and download your customized build.
The package also contains the national flags of each country as a 16x16, 24x24, 32x32, 48x48, 64x64 and 128x128 PNG images, courtesy of IconDrawer. The image files are named using the ISO 3166-1-alpha-2 code of the country they represent, for easily pairing flags with countries.
Country names in all languages are taken from Wikipedia.
