datasets real and made-up data to practise on

Datasets

Data for the Playground, Database Lab and Performance Lab. Pick one and open its files.

dataset

size

Two years of a fictional online shop: customers, products, orders, order lines, payments and reviews.

300 orders7 tablesJan 2024 – Dec 2025

what to watch for

Tricky rows

Emails with uppercase letters or surrounding spaces6 rows
City names with inconsistent case or stray spaces9 rows
The same person signed up twice: a second customer_id with the same email in different case2 rows
Exact duplicate order rows from a retried export6 rows

files

Open a file to see what one row means, its columns and a preview. Open in Playground starts a new file there with code that loads it.

customers150 rows · 9 columns · CSV

One row per customer account. Some customers never ordered.

In your code: data/customers.csv

customer_idtextkey
C + 5 digits
first_nametext
Invented first name
last_nametext
Invented last name
emailtext
Unique, lowercase in the clean table
citytext · can be empty
Profile city; empty when the customer never filled it in
statetext
Two-letter US state
segmenttext
consumer or business
signup_attimestamp
Account creation, UTC (YYYY-MM-DD HH:MM:SS). Some accounts predate 2024
marketing_opt_inboolean
Agreed to marketing email

sellers60 rows · 6 columns · CSV

Marketplace sellers who list products.

In your code: data/sellers.csv

products328 rows · 10 columns · CSV

The catalogue. Products can launch during the period or be discontinued.

In your code: data/products.csv

orders300 rows · 15 columns · CSV

One row per order. Totals are subtotal + shipping_fee + tax.

In your code: data/orders.csv

order_idtextkey
O + 6 digits. Increases day by day, but not by time within a day: sort by ordered_at for time order
customer_idtext→ customers
Who ordered
ordered_attimestamp
Order time, UTC
channeltext
web, app, phone or marketplace
statustext
processing, shipped, delivered, cancelled or returned (as of 2025-12-31)
promo_codetext · can be empty
Promotion applied, if any
subtotaldecimal
Sum of line totals after discount
shipping_feedecimal
0 at $50+ or with FREESHIP, else 5.99
taxdecimal
7% of subtotal
totaldecimal
Amount charged
ship_citytext
Delivery city
ship_statetext
Delivery state
shipped_attimestamp · can be empty
Empty for processing and cancelled orders
delivered_attimestamp · can be empty
Empty until delivered
estimated_deliverydate
Promised delivery date (order date + 6 days)

order_items454 rows · 7 columns · CSV

Order lines. unit_price is the price at order time, which can differ from today's list_price.

In your code: data/order_items.csv

payments334 rows · 7 columns · CSV

Payment events. An order can have a failed attempt, a split gift-card payment, a cancelled card hold or a refund (negative amount).

In your code: data/payments.csv

reviews119 rows · 9 columns · CSV

Product reviews written after delivery. Late deliveries and returns get lower ratings.

In your code: data/reviews.csv

relationships

How to join these tables. Left column matches the right column.