Useful SQL scripts - all kinds of purposes
This is a jursidiction list of states/provinces/departments for countries based on ISO 3166-2, with the main source being taken from https://en.wikipedia.org/wiki/ISO_3166-2. The Excel file contains one page per country for use, whereas the SQL file contains a temporary table populated by country. Countries are collated by continental region, i.e. North America, Central America, etc.