Northwind

The Northwind database contains the sales data for a fictitious company called Northwind Traders, which imports and exports specialty foods from around the world.

Original source: code.google.com

Versions

  • Northwind (by Jan Motl)

Dataset details

Associated task:
Regression
Domain:
Retail
Data types:
Size:
1.1 MB
Count of tables:
29
Count of rows:
3,308
Count of columns:
191
Missing values:
Yes
Compound keys:
No
Loops:
No
Type:
Synthetic
Instance count:
830
Target table:
Orders
Target column:
Freight
Target ID:
OrderID
Target timestamp:
OrderId

How to download the dataset

The datasets are publicly available directly from MariaDB database.

  1. Open your favourite MariaDB client (MySQL Workbench works, but see FAQ)
  2. Use following credentials:
    • hostname: db.relational-data.org
    • port: 3306
    • username: guest
    • password: relational
  3. Export "northwind" database (or other version of the dataset, if available) in your favourite format (e.g. CSV or SQL dump).