Country Dimension - Sources

Initial:

The initial source data for this dimension is the UniCode Country Codes: ISO 3166, Microsoft, and Macintosh; here.

This page contains an 8 column table containing the target data.

Source - HTML Table:

Column	Datatype	Description
Country	CHAR	Name of the country.
ISO Alpha 2	CHAR(2)	2 character ISO code.
ISO Alpha 3	CHAR(3)	3 character ISO code.
UN Numeric 3	CHAR(3)	3 digit numeric UN code.
Windows Country Region	CHAR	Windows Country Region.
Windows Code	CHAR(3)	Windows Code.
Mac Name	CHAR	Mac Name.
Mac Code	CHAR	Mac Code.

Ongoing:

This source is very slowly changing - in the order of magnitude that the web page itself may well change. Therefore, any future updating of the dimension is seen as a special one-off exercise. If the structure of the source web page has changed in the interim, this will be addressed at the time.