Country ISO 3166-1, ISO 4217 v2

Updated the SQL and CSV files to include the demonyms for each country, also removed all uninhabitable countries from the list.

SQL download countries.sql
CSV download countries.csv

Country ISO 3166-1, ISO 4217

Today I had to setup a database table of countries with their respective ISO 3166-1/4217 & international dialing code numbers, after beating Google with a stick and not finding the right import, I decided to compile one from information found all over. Guess sharing is caring so I’m sticking the csv and sql script up here for free use have fun!

ISO 3166-1 alpha-2 codes are two-letter country codes defined in ISO 3166-1, part of the ISO 3166 standard published by the International Organization for Standardization (ISO), to represent countries, dependent territories, and special areas of geographical interest. They are the most widely used of the country codes published by ISO, and are used most prominently for the Internet’s country code top-level domains (with a few exceptions). They were first included as part of the ISO 3166 standard in its first edition in 1974. -wikipedia

ISO 4217 is the international standard describing three-letter codes (also known as the currency code) to define the names of currencies established by the International Organization for Standardization (ISO). The ISO 4217 code list is the established norm in banking and business all over the world for defining different currencies, and in many countries the codes for the more common currencies are so well known publicly, that exchange rates published in newspapers or posted in banks use only these to define the different currencies, instead of translated currency names or ambiguous currency symbols. ISO 4217 codes are used on airline tickets and international train tickets to remove any ambiguity about the price.

SQL download countries.sql
CSV download countries.csv

The countries database has been updated here!