Skip to content
Novus Examples
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.

Data importConversion 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.

How to use this file for testing

“E-commerce Customers (JSON, 500 records)” is a deterministic Novus Examples fixture for Data import, Conversion testing. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.

Documented properties for this file: 500 records · schema: customer_id, name, email, city, country, signup_date. Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.

Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such — expect parsers to fail loudly rather than silently accept them.

Data fixtures document their exact quirks — delimiters, encodings, null handling, schema, and row counts — in the spec table. Point your parser or importer at the file and assert it handles the documented edge cases; clean and deliberately-messy siblings make before/after diffs straightforward.

Code examples

import json

with open("customers.json") as f:
    data = json.load(f)
print(type(data), len(data))

Related files

Generated by generation/data_realworld.py. Free for any use, no attribution required — license.