Mondial

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)

    • add 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:
?

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 "Mondial" database (or other version of the dataset, if available) in your favourite format (e.g. CSV or SQL dump).