Skip to content

Instantly share code, notes, and snippets.

I took a list of ISO countries https://github.com/stefangabos/world_countries
and filtered out some entities that weren't part of the UN (http://www.un.org/en/member-states/)
though I did keep some members in.
I wanted a list of countries / nations that wasn't filled up with irrelevant places like Antarctica or British Overseas Territory (which is strictly a military base.)
or other island overseas territories. I also shortened some names.
SET NAMES utf8;