Skip to content

Constantly updated lists of world countries and their associated alpha-2, alpha-3 and numeric codes as defined by the ISO 3166 standard, available in MySQL, JSON and CSV formats, in multiple languages and with national flags included

License

Notifications You must be signed in to change notification settings

JeanValJeann/world_countries

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

93 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

zebrajs

World countries  Tweet

available in multiple languages, in SQL, JSON and CSV formats, with associated codes as defined by the ISO 3166 standard, and with national flags included

License

Constantly updated lists of world countries and associated alpha-2, alpha-3 and numeric codes as defined by the ISO 3166 standard published and maintained 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 21 languages:

  • Arabic
  • Chinese
  • Czech
  • Dutch
  • English
  • 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'),
(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'),
...

Excerpt from the data/en/countries.csv 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
...

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

...
{"id":250,"name":"France","alpha2":"fr","alpha3":"fra"},
{"id":254,"name":"French Guiana","alpha2":"gf","alpha3":"guf"},
{"id":258,"name":"French Polynesia","alpha2":"pf","alpha3":"pyf"},
{"id":260,"name":"French Southern Territories","alpha2":"tf","alpha3":"atf"},
{"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"},
...

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.

Sources

Country names in all languages are taken from Wikipedia.

Support the development of this project

Donate

About

Constantly updated lists of world countries and their associated alpha-2, alpha-3 and numeric codes as defined by the ISO 3166 standard, available in MySQL, JSON and CSV formats, in multiple languages and with national flags included

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published