$19 one-time, plus applicable tax
Buy now: $19Test dataset · digital download (9.6 MB ZIP)
Please note. This is a digital download: after you pay on Stripe you are taken to a private download page, with no account needed. Links last 72 hours and the page can be re-opened for 30 days.
About this test dataset
A year of shipments from four fictional warehouses through four fictional carriers: seven related tables with consistent keys. Each shipment has one or more packages with dimensions, actual weight, dimensional weight and billable weight; a shipping cost computed from the service level's rates; a promised date; and a time-ordered trail of tracking events (label created, picked up, hub scans, delays, out for delivery, delivered, failed attempts and returns). Shipment status always matches the latest event, and the data is frozen at an as-of time, so some shipments are still in flight. It's useful for building tracking pages, ops dashboards, on-time-delivery reports, rate calculators and SQL exercises. 22 consistency checks run on every build.
- 7 tables in CSV, NDJSON and SQL (schema with keys and data)
- Small set (400 shipments) and full set (20,000 shipments, 130,000+ tracking events)
- 22 consistency checks run automatically on both sets (weights, costs, dates, event order, statuses)
- Fictional carriers and towns; emails at example.com, phones in 555-0100–0199
Free table samples
Download the first rows of a few tables to check the format: shipments.csv — first 25 rows · tracking_events.csv — first 25 rows · packages.csv — first 25 rows
A look at the data
First rows of a few tables from the small set.
shipments (400 rows in the small set, 20,000 in the full set)
| shipment_id | tracking_number | customer_id | warehouse_id | service_id | ship_to_line1 | ship_to_city | ship_to_state | ship_to_postal_code |
|---|---|---|---|---|---|---|---|---|
| 1 | NP832043047663 | 84 | 2 | 5 | 2616 Chestnut Street | Millmoor | NE | 79512 |
| 2 | NP961410607214 | 11 | 2 | 4 | 4492 Harbor Street | Ironhollow | ID | 93372 |
| 3 | SW560863993932 | 22 | 2 | 1 | 8612 Bramble Way | Copperbrook | NV | 90894 |
| 4 | SW323017930336 | 35 | 3 | 2 | 2568 Amber Terrace | Maplewood | TX | 59978 |
| 5 | SW893513132544 | 55 | 2 | 1 | 4602 Wren Drive | Hazelport | TX | 54442 |
| 6 | NP156230173728 | 4 | 1 | 4 | 3759 Falcon Way | Pinemoor | WA | 86628 |
| 7 | SW998331554560 | 91 | 4 | 1 | 5791 Holly Lane | Millbrook | AL | 12393 |
| 8 | SW327607331733 | 86 | 3 | 2 | 9820 Garnet Court | Cedarport | PA | 17238 |
tracking_events (2,662 rows in the small set, 134,348 in the full set)
| event_id | shipment_id | event_time | event_code | description | city | state |
|---|---|---|---|---|---|---|
| 1 | 1 | 2025-10-01 06:52:04 | LABEL_CREATED | Shipping label created | Alderbrook | CO |
| 2 | 1 | 2025-10-01 10:36:48 | PICKED_UP | Picked up by Northpoint Freight | Alderbrook | CO |
| 3 | 1 | 2025-10-01 12:51:58 | DEPARTED_FACILITY | Departed origin facility | Alderbrook | CO |
| 4 | 1 | 2025-10-02 17:54:38 | ARRIVED_AT_HUB | Arrived at carrier hub | Lakemere | IL |
| 5 | 1 | 2025-10-03 22:57:19 | ARRIVED_AT_HUB | Arrived at carrier hub | Copperford | OH |
| 6 | 1 | 2025-10-05 06:09:00 | OUT_FOR_DELIVERY | Out for delivery | Millmoor | NE |
| 7 | 1 | 2025-10-05 09:12:00 | DELIVERED | Delivered, handed to resident | Millmoor | NE |
| 8 | 2 | 2025-10-02 07:53:21 | LABEL_CREATED | Shipping label created | Alderbrook | CO |
packages (504 rows in the small set, 26,114 in the full set)
| package_id | shipment_id | package_number | length_in | width_in | height_in | weight_lb | dim_weight_lb | billable_weight_lb |
|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 1 | 12 | 9 | 4 | 4.6 | 3.1 | 5.0 |
| 2 | 2 | 1 | 18 | 12 | 8 | 8.0 | 12.4 | 13.0 |
| 3 | 3 | 1 | 6 | 4 | 2 | 0.8 | 0.3 | 1.0 |
| 4 | 4 | 1 | 14 | 10 | 6 | 8.6 | 6.0 | 9.0 |
| 5 | 5 | 1 | 14 | 10 | 6 | 10.6 | 6.0 | 11.0 |
| 6 | 6 | 1 | 24 | 18 | 14 | 34.6 | 43.5 | 44.0 |
| 7 | 6 | 2 | 9 | 6 | 3 | 2.5 | 1.2 | 3.0 |
| 8 | 6 | 3 | 20 | 16 | 12 | 18.8 | 27.6 | 28.0 |
In the download
- small/ and full/ sets
- csv/ (one file per table)
- json/ (NDJSON)
- schema.sql + data.sql
- SCHEMA.md
- License.txt
$19 one-time, plus applicable tax
Buy now: $19Free guide: Testing Shipping and Order-Tracking Software with Realistic Data
Questions
Are the carriers and rates real?
No. The carriers, service levels, rates, warehouses and hub towns are invented, and the 139 dimensional-weight divisor is a common industry-style figure used for illustration. Don't use this data to quote real shipping costs.
Is any of this real customer data?
No. Names are random first/last combinations, addresses use made-up street and town names, emails use the reserved example.com domain and phones use the fictional 555-01xx range.
What does "adds up" mean?
Package counts and weights roll up to the shipment; billable weight is the greater of actual and dimensional weight, rounded up; cost equals base rate plus rate per pound times billable weight; promised dates follow the service level; the status matches the latest tracking event; pickup and delivery times match their events; delivery events happen in the ship-to city. The full list is in SCHEMA.md.
Which databases does the SQL work with?
The schema and inserts use portable SQL types (INTEGER, TEXT, NUMERIC, BOOLEAN, DATE, TIMESTAMP). They load as-is into SQLite and PostgreSQL. For anything else, use the CSV files with your database's import tool.
Can I use it in a course or a product demo?
Yes, including commercial courses, demos and seed data inside your app. You just can't resell the dataset itself as a dataset.
Is this a subscription?
No. One payment of $19 and the files are yours to keep.
What if it does not work for me?
Ask within 14 days of purchase for a full refund. See the refund policy.
Sold by Quietcog. Support: gb1@mail.grokbot.com. See also the terms, refund policy and privacy policy.