VOC

VOC

VOC database provides a peephole view into the administrative system of an early multi-national company, the Vereenigde geoctrooieerde Oostindische Compagnie (VOC for short - The (Dutch) East Indian Company) established on March 20, 1602.

Original source: www.monetdb.org

Versions

  • Voc (by Jan Motl)

    • typos in dates were fixed because MySQL doesn't support so wide range of dates as MonetDB

Dataset details

Associated task:
Classification
Domain:
Retail
Data types:
Size:
4.7 MB
Count of tables:
8
Count of rows:
29,528
Count of columns:
89
Missing values:
Yes
Compound keys:
Yes
Loops:
No
Type:
Real
Instance count:
8,534
Target table:
voyages
Target column:
arrival_harbour
Target ID:
number, number_sup
Target timestamp:
arrival_date

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