Dataset pack
Payments and account master
Payments that reference account numbers, some missing or unknown.
Fictional data · UTF-8 CSV, every value quoted so padding and leading zeros survive; empty fields are missing values · free for personal and classroom practice · practise it in Referential integrity with explicit exceptions.
payments 10 rows × 3 columns
Download payments.csvData dictionary
- id
- Unique payment ID.
- account
- Account number; may be padded, blank, missing or unknown.
- amount_cents
- Amount in cents as a whole number; negative values are reversals.
| id | account | amount_cents |
|---|---|---|
| "pay59hn" | "999" | "51974" |
| "payij5o" | "4" | "57923" |
| "payfhun" | "7" | "77641" |
| "paym2n8" | ∅ | "72752" |
| "paywa3o" | "999" | "-1746" |
| "pay7u1w" | " 7 " | "-1489" |
accounts 5 rows × 2 columns
Download accounts.csvData dictionary
- account
- Trimmed, unique account number.
- name
- Account holder name.
| account | name |
|---|---|
| "12" | "Bolt GmbH" |
| "7" | "Delta Co" |
| "4" | "Cedar SA" |
| "22" | "Acme Ltd" |
| "48" | "Echo LLC" |
Values are shown in quotes so leading and trailing spaces are visible. ∅ means the cell is missing. Exercises are also graded on hidden datasets that are never published.