Mondial
A geography dataset from University of Göttingen describes 114 Christian countries and 71 non-Christian countries.
Original source: www.dbis.informatik.uni-goettingen.de (BibTeX)
Versions
Mondial (by Jan Motl)
- Added foreign key constrains. I was looking at Mondial dataset (MySQL version) and I noticed that it is not possible to enforce foreign key constrains between:
- mountain & mountainOnIsland
- mountain & geo_mountain
- Since all the errors are caused by just a few records, it should be possible to fix them in a reasonable time. A possible resolution of the issue is to unify names for Snaefell mountain and add one record for Oraefajokull (with English spelling):
- mountainOnIsland.Mountain.Snoefell -> mountainOnIsland.Mountain.Snaefell
- mountainOnIsland.Mountain.Oeraefajoekull -> mountainOnIsland.Mountain.Oraefajokull
- geo_mountain.Mountain.Snoefell -> geo_mountain.Mountain.Snaefell
- geo_mountain.Mountain.Oeraefajoekull -> mountainOnIsland.Mountain.Oraefajokull
- A new record in Mountain table:
- Oraefajokull [null] 2110 volcano 64 16.39
Mondial_geo (by Oliver Schulte)
Mondial_Tutorial (by Oliver Schulte)
- A simplified version of the original
Dataset details
- Associated task:
- Classification
- Domain:
- Geography
- Data types:
- Size:
- 3.2 MB
- Count of tables:
- 40
- Count of rows:
- 21,497
- Count of columns:
- 167
- Missing values:
- Yes
- Compound keys:
- Yes
- Loops:
- Yes
- Type:
- Real
- Instance count:
- 204
- Target table:
- target
- Target column:
- Target
- Target ID:
- Country
- Target timestamp:
- ?
Algorithms
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 "Mondial" database (or other version of the dataset, if available) in your favourite format (e.g. CSV or SQL dump).