Reference datasets and test data for developers and analysts
Ready-to-use data
for apps, demos
and reports.
Download documented reference data, build reports from a prepared sample store, or generate customers and orders that link. Spend less time preparing files and more time building.
Includes every collection and dataset in full, and larger test data files. 365 days of access. No automatic renewal. Keep using your downloads after your pass ends.
Test data generatorSample rows from a real run
Make 1,000 customers with orders and products as CSV
Four linked tables. Matching IDs. Totals that add up.
Customers
| CustomerID | FirstName | LastName | City | State | OrderCount | TotalSpent |
|---|---|---|---|---|---|---|
| CUST-00001 | Christopher | Hunt | Houston | TX | 5 | 456.74 |
| CUST-00002 | Craig | Chapman | Los Angeles | CA | 0 | 0 |
| CUST-00003 | Brandon | Wood | Collinsville | OK | 3 | 921.91 |
| CUST-00004 | Todd | Graves | Pittsburgh | PA | 1 | 59.96 |
| CUST-00005 | Mark | Hayes | Forest Acres | SC | 4 | 1291.66 |
One row per customer. CustomerID is the key the orders point to.
Orders
| OrderID | CustomerID | OrderDate | Status | LineCount | OrderTotal |
|---|---|---|---|---|---|
| ORD-00001 | CUST-00001 | 2026-05-11 | Delivered | 1 | 39.9 |
| ORD-00002 | CUST-00001 | 2025-07-17 | Shipped | 2 | 119.94 |
| ORD-00003 | CUST-00001 | 2025-12-13 | Delivered | 2 | 181.97 |
| ORD-00004 | CUST-00001 | 2025-09-25 | Delivered | 1 | 87.96 |
| ORD-00005 | CUST-00001 | 2025-10-09 | Delivered | 1 | 26.97 |
| ORD-00006 | CUST-00003 | 2026-05-22 | Processing | 2 | 337.95 |
Each order carries its customer’s CustomerID. The five for CUST-00001 add up to 456.74, that customer’s TotalSpent.
Order lines
| OrderID | LineNumber | SKU | ProductName | Quantity | UnitPrice | LineTotal |
|---|---|---|---|---|---|---|
| ORD-00001 | 1 | OS-DE-01100 | Bramblewood Cable Organizer | 2 | 19.95 | 39.9 |
| ORD-00002 | 1 | AP-TS-00670 | Redfern V-Neck T-Shirt | 1 | 21.95 | 21.95 |
| ORD-00002 | 2 | AP-OU-00760 | Halcyon & Co. Rain Jacket | 1 | 97.99 | 97.99 |
| ORD-00003 | 1 | OS-BA-01120 | Brightwater Laptop Backpack | 1 | 109.99 | 109.99 |
| ORD-00003 | 2 | EL-HE-00060 | Copperline Over-Ear Headphones | 2 | 35.99 | 71.98 |
| ORD-00004 | 1 | OD-HI-00510 | Bluejay Trekking Poles | 4 | 21.99 | 87.96 |
Each line carries its order’s OrderID and a product’s SKU. The two lines of ORD-00002 add up to its OrderTotal of 119.94.
Products
| SKU | ProductName | Brand | Category | UnitPrice |
|---|---|---|---|---|
| AP-TS-00660 | Pinehaven V-Neck T-Shirt | Pinehaven | Apparel | 14.49 |
| BC-BA-01350 | Copperline Body Lotion | Copperline | Beauty & Personal Care | 23.95 |
| AP-TS-00680 | Ironbark Crew Neck T-Shirt | Ironbark | Apparel | 25.99 |
| EL-HE-00010 | Halcyon & Co. Over-Ear Headphones | Halcyon & Co. | Electronics | 114.99 |
| AP-HO-00700 | Fieldstone Fleece Quarter-Zip | Fieldstone | Apparel | 49.99 |
One row per product. SKU is the key the order lines point to.
Free up to 1,000 customers, plus their orders and products. 250,000 rows per table with a Data Pass.Try this linked dataset free
Start with the job
What are you building?
Each path opens something you can use today, with a free sample before you pay.
Build a report
Start with prepared business data and a reporting calendar. Follow a worked sales report, and check your totals against ours.
Open the sales report exampleCreate a demo
Generate customers with related orders and products, then choose an output format for your project.
Try the test data generatorAdd reference data
Find documented lookup and reference files for your app or analysis. Check the fields, source dates and coverage first.
Browse reference dataA worked example
A sales report you can reproduce.
The sample store is a made-up business in five files: orders, order lines, products, customers and a calendar. Open the free Excel workbook to explore the sales report and check its totals.
- Free samples
- 133 orders that join across all five files. Enough to prove your joins.
- With the Data Pass
- 168,314 orders over four years, with growth, holiday peaks, promo codes and returns.
The workbook holds the free sample data and a Report sheet that works out each answer and checks it. No account needed. Prefer SQL? The worked report uses the same five files: download them as CSV.
These totals are from the complete data, which comes with the Data Pass. The free samples give smaller totals, listed with the expected results.
Included with the Data Pass
Reference data, ready to load.
Documented files built from public sources, with a field guide and source notes. See the fields and a sample before you buy.
U.S. ZIP codes
Residential ZIP codes with city, county, coordinates and Census population.
33,642 rows 15 columnsCSV, JSON, XML
View fields and sampleOccupations and pay
Occupation definitions, employment and pay ranges from the BLS.
1,452 rows 17 columnsCSV, JSON, XML
View fields and sampleU.S. public schools
Public schools with district, grades, enrollment and teacher counts.
99,088 rows 26 columnsCSV, JSON, XML
View fields and sampleStock tickers
Stock symbols with company names, exchanges, SEC identifiers and industries.
10,443 rows 15 columnsCSV, JSON, XML
View fields and sampleThe Data Pass
Get the complete data for your next project.
Download full reference files, work from a prepared business example, and generate larger sets of linked test records, all with one pass.
- Know a file before you build on it. Fields, coverage and source dates are documented for every collection. The pass downloads all 33 collections and every record in 402 datasets, more than 4 million rows in all. Free gives a sample of each.
- Build a demo without wiring up the tables. Customers, orders and products arrive already linked. Up to 250,000 rows per table. Free makes 1,000 customers with their related rows.
- Check a report against known results. The sample store comes with its reporting rules and the totals you should get. 168,314 orders over four years. The free sample has 133.
- Pull the data from your own code. Every file is also an API request. 2,500 downloads or requests a day on your own key. Free is 50, shared with everyone on your connection.
$69365 days of access
Get a Data PassOne payment. No subscription. Commercial use is allowed, and your downloads stay usable after the pass ends.What’s already done
The preparation is already done.
You can check all of it on the page before you pay.
Documented
Every collection has a field guide, its source and the date the data is from, and a README in the download.
Made to join
ZIP codes join to ZIP code demographics on ZipCode. Sample store orders join to People on PersonID. Generated orders carry their customer’s ID.
Coverage stated
Each collection page says what the file covers and what to watch for, so you can judge the fit first.
Free to try
Every collection has a free sample and every dataset a free preview. No account is needed.
- What arrives after I pay?
- A pass key, by email, right after payment. Paste it into any download section, or send it with an API request.
- Can I use the data in my work?
- Yes. Apps, client work, reports and products you sell are all allowed. You can’t resell or republish the files themselves.
- What happens after 365 days?
- You’re back to free access, and you keep using everything you downloaded. Nothing renews by itself.
- Will it cover what I need?
- Each page lists its fields, source and coverage, with a free sample. Check those first, since all sales are final. If a download is broken or doesn’t match its description, tell us and we’ll correct the file.
Free to use
Free tools, guides and datasets.
Tools for the next step
Inspect, convert and prepare your files with free browser tools. Your files stay on your device.
Free in full
These datasets need no account or pass key. Free request limits apply.
Project guides
Worked examples for apps, spreadsheets and the classroom.
Looking for file formats, API examples or access details? Read the API and docs.