Skip to content

List of all countries in different formats (ISO, tld, capital, language, population)

Notifications You must be signed in to change notification settings

lorey/list-of-countries

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

a list of all countries worldwide in json and csv

List of all countries worldwide

This is a repository containing lists of all countries worldwide in several formats. The data is taken from GeoNames and thus under CC BY license. I use it for Programmer Map which lists the best programmers in all countries and many cities worldwide.

Formats

There are currently three file formats: JSON, CSV, and PHP.

JSON

The JSON files are located in json/. There are two versions A readable version with indentation: json/countries-readable.json

[
    {
        "alpha_2": "AD",
        "alpha_3": "AND",
        "area": "468",
        "capital": "Andorra la Vella",
        "continent": "EU",
        "currency_code": "EUR",
        "currency_name": "Euro",
        "eqivalent_fips_code": "",
        "fips": "AN",
        "geoname_id": "3041565",
        "languages": "ca",
        "name": "Andorra",
        "neighbours": "ES,FR",
        "numeric": "020",
        "phone": "376",
        "population": "84000",
        "postal_code_format": "AD###",
        "postal_code_regex": "^(?:AD)*(\\d{3})$",
        "tld": ".ad"
    },
    // ...

And a compact version: json/countries.json

[{"alpha_2": "AD", "alpha_3": "AND", "area": "468", "capital": "Andorra la Vella", "continent": "EU", //...

CSV

The CSV file is located under csv/countries.csv. It uses semicolons as separators as there are commas in the country names. You can open CSV files in almost any spreadsheet software, e.g. Microsoft Excel, Libre Office Calc, etc.

phone;currency_name;geoname_id;alpha_2;currency_code;neighbours;area;numeric;capital;tld;eqivalent_fips_code;languages;postal_code_format;fips;postal_code_regex;alpha_3;continent;name;population
376;Euro;3041565;AD;EUR;ES,FR;468;020;Andorra la Vella;.ad;;ca;AD###;AN;^(?:AD)*(\d{3})$;AND;EU;Andorra;84000
971;Dirham;290557;AE;AED;SA,OM;82880;784;Abu Dhabi;.ae;;ar-AE,fa,en,hi,ur;;AE;;ARE;AS;United Arab Emirates;4975593
93;Afghani;1149361;AF;AFN;TM,CN,IR,TJ,PK,UZ;647500;004;Kabul;.af;;fa-AF,ps,uz-AF,tk;;AF;;AFG;AS;Afghanistan;29121286
...

PHP

The PHP file is located under php/array.php and contains the list of all countries in array notation.

<?php
$countries = [
    [
        "alpha_2" => "AD",
        "alpha_3" => "AND",
        "area" => "468",
        "capital" => "Andorra la Vella",
        "continent" => "EU",
        "currency_code" => "EUR",
        "currency_name" => "Euro",
        "eqivalent_fips_code" => null,
        "fips" => "AN",
        "geoname_id" => "3041565",
        "languages" => "ca",
        "name" => "Andorra",
        "neighbours" => "ES,FR",
        "numeric" => "020",
        "phone" => "376",
        "population" => "84000",
        "postal_code_format" => "AD###",
        "postal_code_regex" => "^(?:AD)*(\d{3})$",
        "tld" => ".ad",
    ],
    // ...

Similar projects

There are several similar projects you should also check out. Feel free to add yours.

  • unicode-cldr/cldr-core: Lots of JSON data but hard to query and without geoname ids
  • mledoze/countries: PHP generator, various formats and a lot of data but no geoname ids and weird ISO 639-3 codes that are hard to resolve (Austria has "bar" as language which is basically a German dialect)
  • umpirsky/country-list: focused on localized versions and ISO only, no generator
  • fayder/restcountries: Country data provided by a restful API (JSON)
  • datasets/country-codes: CSV data with lots of codes for country representations (stuff like FIFA, IOC, etc.)

Misc

Picture licensed under CC0 by Lena Bell.

About

List of all countries in different formats (ISO, tld, capital, language, population)

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published