Payroll 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.
{
"period": "2026-01",
"currency": "USD",
"headcount": 30,
"annual_gross_total": 3886000,
"monthly_gross_total": 323833.33,
"by_department": [
{
"department": "Engineering",
"annual_gross": 768000,
"headcount": 6
},
{
"department": "Finance",
"annual_gross": 928000,
"headcount": 7
},
{
"department": "Marketing",
"annual_gross": 496000,
"headcount": 4
},
{
"department": "People",
"annual_gross": 293000,
"headcount": 3
},
{
"department": "Sales",
"annual_gross": 548000,
"headcount": 4
},
{
"department": "Support",
"annual_gross": 853000,
"headcount": 6
}
]
}
Specifications
- Period
- 2026-01
- Headcount
- 30
- Note
- derived from the employee directory
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("payroll-summary.json") as f:
data = json.load(f)
print(type(data), len(data))Related files
- csvEmployee Directory (CSV, 30 rows)An employee directory — 30 staff with department, title, hire date, salary, and manager reference. Synthetic HR data for testing org-chart builders, directory imports, and payroll pipelines.
- jsonEmployee Directory (JSON, 30 records)The employee directory as a JSON array — the format twin of the CSV, for HR import testing.
- 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.
Generated by generation/data_domains.py. Free for any use, no attribution required — license.