ISO codes and names for countries and nations
This is a dump of a mysql database with the following tables:
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.


Dirk Vermeir (dvermeir@vub.ac.be) [Last modified: Wed Apr 8 10:48:47 CEST 2009 ]