World

World

A database of 239 states and their cities.

Original source: dev.mysql.com

Versions

  • World (by Jan Motl)

Dataset details

Associated task:
Classification
Domain:
Geography
Data types:
Size:
700 KB
Count of tables:
3
Count of rows:
5,411
Count of columns:
24
Missing values:
Yes
Compound keys:
No
Loops:
No
Type:
Real
Instance count:
239
Target table:
Country
Target column:
Continent
Target ID:
Code
Target timestamp:
?

Algorithms

Dataset versionTargetAlgorithmAuthor textMeasureValue
worldContinentPredictor FactoryPredictor FactoryAccuracy0.7699

How to download the dataset

The datasets are publicly available directly from MySQL database.

  1. Open your favourite MySQL client (for example MySQL Workbench)
  2. Use following credentials:
    • hostname: relational.fit.cvut.cz
    • port: 3306
    • username: guest
    • password: relational
  3. Export "world" database (or other version of the dataset, if available) in your favourite format (e.g. CSV or SQL dump).