An SQL dump of Countries with respective states and provinces.
Original source is in XML format from https://blueprints.launchpad.net/openobject-server/+spec/countries-states-and-provinces
I thought I'd make an SQL version. You normally use this for creating dependent drop downs, where you select a country and an option of states or provinces appears.
A simple query to list all countries would be like:
select *
from states_provinces left join countries
on states_provinces.country_id = countries.country_id
order by countries.name asc, states_provinces.name asc;
Have fun!