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.