Data Platform/Mysql/Utility Datasets

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

The analytics MySQL server on analytics-store.eqiad.wmnet contains a datasets database. This is intended to serve as a repository of useful, fixed datasets of general information - examples would be conversions between ISO country codes and the actual country names, or

country_info

A dataset of information about various countries. Useful for geolocation, particularly around grouping countries together or rendering the output of our geolocation software human-readable. Contains:

mysql:research@analytics-store.eqiad.wmnet [datasets]> DESCRIBE country_info;
+----------------+------+------+-----+---------+-------+
| Field          | Type | Null | Key | Default | Extra |
+----------------+------+------+-----+---------+-------+
| country_code   | blob | YES  |     | NULL    |       |
| continent_code | blob | YES  |     | NULL    |       |
| country_name   | blob | YES  |     | NULL    |       |
+----------------+------+------+-----+---------+-------+
3 rows in set (0.01 sec)

country_code is the ISO country code of a particular nation;
continent_code is the corresponding ISO continent code;
country_name is the corresponding human-readable, English-language name for that country.