Jump to content

Data Platform/Mysql/Utility Datasets

From Wikitech

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.