json337.3 KB
E-commerce Orders (JSON, 2000 records)
The e-commerce orders table as a JSON array — the format twin of the CSV, for import and conversion testing.
Preview — first 50 linesjson
[
{
"order_id": 1,
"customer_id": 150,
"product_id": 171,
"quantity": 2,
"total": 705.98,
"status": "paid",
"order_date": "2025-10-19"
},
{
"order_id": 2,
"customer_id": 174,
"product_id": 36,
"quantity": 1,
"total": 25.59,
"status": "refunded",
"order_date": "2025-06-09"
},
{
"order_id": 3,
"customer_id": 31,
"product_id": 1,
"quantity": 2,
"total": 444.46,
"status": "shipped",
"order_date": "2025-04-27"
},
{
"order_id": 4,
"customer_id": 293,
"product_id": 51,
"quantity": 4,
"total": 881.44,
"status": "delivered",
"order_date": "2025-08-22"
},
{
"order_id": 5,
"customer_id": 431,
"product_id": 127,
"quantity": 3,
"total": 1105.89,
"status": "shipped",
"order_date": "2025-03-12"
},
{
"order_id": 6,
"customer_id": 295,
"product_id": 190,… 3433 lines total — download for the full file.
Specifications
- Records
- 2000
- Schema
- order_id, customer_id, product_id, quantity, total, status, order_date
- Domain
- e-commerce
What is a .json file?
JSON (JavaScript Object Notation) is a lightweight, text-based data-interchange format representing objects, arrays, strings, numbers, booleans, and null. It is language-independent, human-readable, and the dominant format for web APIs and configuration. It requires a single well-formed root value.
How to use this file
Use an example JSON file to test parsers and serializers, schema validation, Unicode and number-precision handling, and API request or response processing.
Related files
- csvE-commerce Customers (CSV, 500 rows)A realistic e-commerce customer directory (500 rows) — part of a relational dataset (products, customers, orders) with CSV, JSON, SQL, and Parquet twins for testing joins, imports, and conversion.
- jsonE-commerce Customers (JSON, 500 records)The e-commerce customers table as a JSON array — the format twin of the CSV, for import and conversion testing.
- sqlE-commerce Database Schema (SQL)A relational SQL schema (products, customers, orders with primary and foreign keys) plus sample INSERTs — the DDL twin of the e-commerce dataset, for testing schema import and migrations.
- csvE-commerce Products (CSV, 200 rows)A realistic e-commerce product catalogue (200 rows) — part of a relational dataset (products, customers, orders) with CSV, JSON, SQL, and Parquet twins for testing joins, imports, and conversion.
- jsonE-commerce Products (JSON, 200 records)The e-commerce products table as a JSON array — the format twin of the CSV, for import and conversion testing.
- csvFake Orders Dataset (CSV, 1000 rows)A 1000-row orders dataset whose user_id references the users dataset — a relational fixture for testing joins and import flows. Paired with a JSON twin.
Generated by generation/data_realworld.py. Free for any use, no attribution required — license.