ISO codes and names for countries and nations |
CREATE TABLE country ( iso char(2) NOT NULL, iso3 char(3) NOT NULL, numcode smallint(6) NOT NULL, PRIMARY KEY (iso) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE country_name ( iso char(2) NOT NULL, lang char(2) NOT NULL, name varchar(80) NOT NULL, PRIMARY KEY (iso,lang) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE nation ( iso char(2) NOT NULL, PRIMARY KEY (iso) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;were only two languages, dutch (nl) and english (en) are present in
country_name
.
It presumably contains the iso codes of all countries and nations (i.e. the subset of independent countries), as well as the names of the countries in both english and dutch.
The data have been scraped off the net (including wikipedia). To fill gaps, this site looks useful.
The format is a mysql dump, available in the file world.sql.