iso-3166-country-codes icon indicating copy to clipboard operation
iso-3166-country-codes copied to clipboard

MySQL tables for continent names, country names and their ISO-3166 codes.

ISO-3166 Countries and Continents as SQL

This is an SQL file with two tables of continents and countries, and their ISO-3166 codes.

"The Story"

Needed one a while ago, but the ones I found were either kind of lacking or kind of old. So I made one myself by converting a datafile on Wikipedia into the SQL format I wanted via some regular expressions and manual corrections.

Aso went through all the newsletters with Updates on ISO 3166 I found, and subscribed to their newsletter myself to try keep it up to date as well. Hopefully I've gotten it all right, and hopefully it can be useful for both future me and others.

If you find any mistakes or updates I've missed, please let me know 🙂👍