json88.7 KB
E-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.
Preview — first 50 linesjson
[
{
"customer_id": 1,
"name": "Edward Smith",
"email": "reyespatricia@example.org",
"city": "North Josephhaven",
"country": "CU",
"signup_date": "2024-02-16"
},
{
"customer_id": 2,
"name": "Ryan Rogers",
"email": "michael85@example.net",
"city": "Lake Michelleberg",
"country": "BH",
"signup_date": "2023-10-25"
},
{
"customer_id": 3,
"name": "Maria Brooks",
"email": "michele55@example.com",
"city": "South Katherinefurt",
"country": "GQ",
"signup_date": "2024-10-31"
},
{
"customer_id": 4,
"name": "Paul Smith",
"email": "fcummings@example.net",
"city": "North Grace",
"country": "CO",
"signup_date": "2023-02-20"
},
{
"customer_id": 5,
"name": "Casey Miller",
"email": "peter28@example.org",
"city": "Weaverfurt",
"country": "BY",
"signup_date": "2024-06-09"
},
{
"customer_id": 6,
"name": "William Ewing",
"email": "moorewilliam@example.net",
"city": "Webbmouth",
"country": "FJ",
"signup_date": "2025-01-02"
},
{… 2884 lines total — download for the full file.
Specifications
- Records
- 500
- Schema
- customer_id, name, email, city, country, signup_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
- 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 Orders (CSV, 2000 rows)A realistic e-commerce order lines (customer_id → customers, product_id → products) (2000 rows) — part of a relational dataset (products, customers, orders) with CSV, JSON, SQL, and Parquet twins for testing joins, imports, and conversion.
- jsonE-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.
- 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.