Sample data · CC0 / public domain

Sample e-commerce orders CSV.

An order-header table: order ID, customer reference, date, status, item count, subtotal, shipping and total. Pairs with the Customers and Product Catalog datasets for join demos.

Download

Grab a file — or generate a big one.

The small files are static downloads. The large ones are generated in your browser from the same fixed seed, so every copy of orders-100000.csv on earth is byte-identical — reproducible test data with no 60 MB download.

100 rows · 6 KB 1,000 rows · 59 KB

→ Open this dataset in the dashboard builder  ·  → Open in the CSV editor

Preview

First rows.

order_idcustomer_idorder_datestatusitemssubtotalshippingtotal
ORD-700001C-100012024-01-01delivered4473.074.95478.02
ORD-700002C-100022024-04-01cancelled1374.799.95384.74
ORD-700003C-100032024-07-01processing6511.274.95516.22
ORD-700004C-100042024-09-30delivered788.920.0088.92
ORD-700005C-100052024-12-31delivered4627.854.95632.80
ORD-700006C-100062025-04-01delivered396.990.0096.99
ORD-700007C-100072025-07-01delivered6421.900.00421.90
ORD-700008C-100082025-09-30shipped9518.854.95523.80
Schema

Columns.

columndescription
order_idOrder number
customer_idJoins to the Customers dataset
order_dateOrder date across two years
statusFulfilment status
itemsLine-item count
subtotalGoods total (USD)
shippingShipping charge
totalsubtotal + shipping
About this dataset

What it models.

customer_id values overlap the Customers dataset's ID range, so you can demonstrate inner and left joins with realistic match rates.

Total is exactly subtotal + shipping; statuses follow a believable funnel (mostly delivered, some shipped, a few cancelled or refunded).

Good for: Multi-file JOIN demos with Customers · Order-funnel and status charts · Testing money-column parsing.

License: CC0 / public domain — use it anywhere, no attribution needed.

Common questions
  • ·

    Do customer_ids match the Customers dataset?

    The ID format and range line up (C-10001 …), but each row's reference is its own sequence — so joins demo cleanly at small sizes; at 1M orders most IDs exceed a 1k customer file, which is realistic too.

  • ·

    What license is this under?

    CC0 (public domain). Use it in tutorials, tests, courses, screenshots and products — no attribution required.

  • ·

    Is the data deterministic?

    Yes — every size is generated from a fixed seed, so the same file is byte-identical for everyone, forever. Reproducible tests, stable teaching materials.

More sample data