json13.4 KB
Bank Transactions (JSON, 60 records)
The bank transactions as a JSON array — the format twin of the CSV, for import and reconciliation testing.
Preview — first 50 linesjson
[
{
"txn_id": "T00051",
"date": "2025-11-01",
"account": "****1043",
"description": "Salary deposit",
"category": "income",
"amount": 1926.98,
"currency": "USD",
"balance": 10851.98
},
{
"txn_id": "T00057",
"date": "2025-11-01",
"account": "****1043",
"description": "Book Nook",
"category": "retail",
"amount": -39.24,
"currency": "USD",
"balance": 10647.94
},
{
"txn_id": "T00024",
"date": "2025-11-02",
"account": "****1043",
"description": "Bright Pharmacy",
"category": "health",
"amount": -12.81,
"currency": "USD",
"balance": 7920.74
},
{
"txn_id": "T00056",
"date": "2025-11-03",
"account": "****4021",
"description": "City Transit",
"category": "transport",
"amount": -153.79,
"currency": "USD",
"balance": 7661.32
},
{
"txn_id": "T00041",
"date": "2025-11-04",
"account": "****4021",
"description": "Fuel Stop 24",
"category": "fuel",
"amount": -153.54,
"currency": "USD",
"balance": 5940.88… 603 lines total — download for the full file.
Specifications
- Records
- 60
- Schema
- txn_id, date, account, description, category, amount, currency, balance
- Domain
- banking
- Note
- synthetic; account numbers masked
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("transactions.json") as f:
data = json.load(f)
print(type(data), len(data))Related files
- xmlISO 20022 Credit Transfer — pain.001 (XML)A sample ISO 20022 customer credit-transfer initiation (pain.001.001.09) — a single payment with debtor/creditor parties, IBANs, BICs, amount, and remittance info. IBANs are published documentation examples; a fixture for testing payment-message parsers and bank integrations.
- 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 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.
Generated by generation/data_domains.py. Free for any use, no attribution required — license.