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 version | Target | Algorithm | Author text | Measure | Value |
|---|---|---|---|---|---|
| world | Continent | Predictor Factory | Predictor Factory | Accuracy | 0.7699 |
How to download the dataset
The datasets are publicly available directly from MariaDB database.
- Open your favourite MariaDB client (MySQL Workbench works, but see FAQ)
- Use following credentials:
- hostname: db.relational-data.org
- port: 3306
- username: guest
- password: relational
- Export "world" database (or other version of the dataset, if available) in your favourite format (e.g. CSV or SQL dump).