Dataset pack
Sales, products and categories
Sales linked to a product list, which is linked to a category list that lost some codes.
Fictional data · UTF-8 CSV, every value quoted so padding and leading zeros survive; empty fields are missing values · free for personal and classroom practice · practise it in Two-level referential integrity.
sales 15 rows × 2 columns
Download sales.csv (Pro)Data dictionary
- id
- Unique sale ID.
- sku
- SKU as typed.
products 6 rows × 2 columns
Download products.csv (Pro)Data dictionary
- sku
- Product SKU (upper case, unique).
- category_code
- Category code; may be missing or retired.
categories 3 rows × 2 columns
Download categories.csv (Pro)Data dictionary
- code
- Category code (unique).
- department
- Department the category belongs to.
Values are shown in quotes so leading and trailing spaces are visible. ∅ means the cell is missing. Exercises are also graded on hidden datasets that are never published.