json5.9 KB
Employee Directory (JSON, 30 records)
The employee directory as a JSON array — the format twin of the CSV, for HR import testing.
Preview — first 50 linesjson
[
{
"emp_id": "E0001",
"name": "Sami Sato",
"department": "Sales",
"title": "Sales Manager",
"hire_date": "2024-02-04",
"salary": 73000,
"manager_id": ""
},
{
"emp_id": "E0002",
"name": "Hana Menon",
"department": "Marketing",
"title": "Marketer",
"hire_date": "2023-08-30",
"salary": 185000,
"manager_id": ""
},
{
"emp_id": "E0003",
"name": "Priya Diallo",
"department": "Engineering",
"title": "Eng Manager",
"hire_date": "2025-07-03",
"salary": 181000,
"manager_id": ""
},
{
"emp_id": "E0004",
"name": "Mira Ivanov",
"department": "Finance",
"title": "Controller",
"hire_date": "2019-10-07",
"salary": 125000,
"manager_id": "E0002"
},
{
"emp_id": "E0005",
"name": "Gus Okafor",
"department": "People",
"title": "Recruiter",
"hire_date": "2024-05-22",
"salary": 92000,
"manager_id": "E0001"
},
{
"emp_id": "E0006",
"name": "Juno Nguyen",
"department": "Finance",… 273 lines total — download for the full file.
Specifications
- Records
- 30
- Schema
- emp_id, name, department, title, hire_date, salary, manager_id
- Domain
- HR
- Note
- synthetic; not real people
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.
Code examples
import json
with open("employees.json") as f:
data = json.load(f)
print(type(data), len(data))Related files
- jsonPayroll Summary (JSON)A monthly payroll summary derived from the employee directory — headcount, annual and monthly gross totals, and a per-department breakdown. A fixture for testing finance/HR dashboards and JSON aggregation.
- csvBank Transactions (CSV, 60 rows)A bank-transaction statement — 60 debits and credits across three accounts (masked numbers) with running balances, categories, and merchants. Synthetic data for testing statement parsers, categorisation, and reconciliation.
- jsonBank Transactions (JSON, 60 records)The bank transactions as a JSON array — the format twin of the CSV, for import and reconciliation testing.
- 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.
Generated by generation/data_domains.py. Free for any use, no attribution required — license.