List of Countries, Nationalities and ISO codes in SQL
Working on adding regionalization and localization to T1EOS, I needed a solid list of countries. Poking around on google led me to sabbour's awesome SQL list of Countries and their respective nationalities (e.g. United States – American). I added them to my database and then went through and updated each record with its ISO 3166-1-alpha-2 code. I've provided the resulting SQL dump below (simple table with index and unique on the country slug). Some of the nationalities and country names may be out of date, so take a glance before using in any official capacity.
December 22nd, 2010 | Permalink