Up-to-date SQL, JSON and CSV files with world countries and associated alpha-2, alpha-3 and numeric codes as defined by the ISO 3166 standard and published by the International Organization for Standardization, with national flags included and available in multiple languages
HTML
Switch branches/tags
Nothing to show
Latest commit 9ebb631 May 15, 2017 @stefangabos Copy update
Permalink
Failed to load latest commit information.
data Added Thai language May 14, 2017
flags Fixed #1 May 14, 2017
.gitignore Initial commit Jan 27, 2016
CHANGELOG.md Added changelog file May 13, 2017
README.md Copy update May 15, 2017
index.html Initial commit Jan 27, 2016
license.txt Initial commit Jan 27, 2016

README.md

World countries in SQL, JSON and CSV formats, available in 20 languages and with national flags

Up-to-date lists of world countries and associated alpha-2, alpha-3 and numeric codes as defined by the ISO 3166 standard and published by the International Organization for Standardization, available in MySQL, JSON and CSV formats, in multiple languages and with national flags included.

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 20 languages: Arabic, Chinese, Czech, Dutch, English, French, German, Greek, Hungarian, Italian, Japanese, Lithuanian, Norwegian, Polish, Portuguese, Russian, Slovak, Spanish, Thai and Ukrainian.

Excerpt from the data/en/countries.sql file:

...
(250, 'France', 'fr', 'fra'),
(254, 'French Guiana', 'gf', 'guf'),
(258, 'French Polynesia', 'pf', 'pyf'),
(260, 'French Southern Territories', 'tf', 'atf'),
(266, 'Gabon', 'ga', 'gab'),
(270, 'Gambia', 'gm', 'gmb'),
(268, 'Georgia', 'ge', 'geo'),
(276, 'Germany', 'de', 'deu'),
...

The package also contains the national flags of each country as a 16x16, 24x24, 32x32, 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.

Sources

All the data comes from Wikipedia.

Support this project

Donate