The Countries List

Welcome

Welcome to The Countries List, your complete resource for discovering all the countries of the world. Find detailed information about each country, including ISO codes, capitals, official languages, currencies, population, and more. Download this data in SQL format for easy integration into your projects.

Data details

  • Each country’s capital city, the political heart of the nation

  • Official languages spoken in each country, including ISO codes

  • Currency used in each country, with exchange rates and denominations

  • Discover the region of each country, including continent and sub-regions

  • Population estimates and historical trends for each country

  • Each country and its official name is available in 6 languages:

    • English
    • French
    • German
    • Italian
    • Spanish
    • Romansh (Romance)

  • Official ISO 3166-1 alpha-2 and alpha-3 codes

  • Continents with names translated into all 6 supported languages

  • Regions with names translated into all 6 supported languages

  • coordinates, size in progress...

Use Cases

  • Developers building mapping and data-visualization tools
  • Analysts studying demographic and economic trends
  • Localization teams translating country names and info
  • Educators teaching geography and cultural studies
  • Curious individuals exploring global country data

Downloads

Download the complete country data in SQL format for easy use in your projects.

Support

If you appreciate this project and find it useful, you can support it with a small donation. Every contribution is highly appreciated!

Donate (Buy Me A Coffee)

Found an error?

If you notice any mistakes or missing information, please let me know by emailing. If your correction is verified, we’ll happily acknowledge you as a contributor!