Banking & insurance
Orion Bank & Insurance
A fictional retail bank with an insurance arm: customers, accounts, card/current-account transactions (2025), consumer loans with default outcomes, insurance policies with renewal flags, and claims.
Log in to query this database in your browser.
Data dictionary
customers · 3,000 rows
Bank customers.
| Column | Type | Description |
|---|---|---|
| customer_id | INTEGER | |
| first_name | TEXT | |
| last_name | TEXT | |
| age | INTEGER | |
| city | TEXT | |
| monthly_income | REAL | Declared net monthly income (USD equivalent) |
| employment | TEXT | |
| customer_since | TEXT | Relationship start date |
accounts · 5,980 rows
Accounts held by customers.
| Column | Type | Description |
|---|---|---|
| account_id | INTEGER | |
| customer_id | INTEGER | |
| account_type | TEXT | current / savings / card |
| opened_date | TEXT (ISO date) | |
| currency | TEXT |
transactions · 178,878 rows
Account transactions during 2025. Negative = outflow.
| Column | Type | Description |
|---|---|---|
| txn_id | INTEGER | |
| account_id | INTEGER | |
| txn_date | TEXT (ISO date) | |
| category | TEXT | |
| amount | REAL | Signed amount (USD equivalent) |
| flagged_fraud | INTEGER | 1 if flagged by the fraud team |
loans · 1,100 rows
Consumer loans and outcomes.
| Column | Type | Description |
|---|---|---|
| loan_id | INTEGER | |
| customer_id | INTEGER | |
| issue_date | TEXT (ISO date) | |
| principal | REAL | Amount lent |
| term_months | INTEGER | |
| interest_rate | REAL | Annual nominal rate (0.18 = 18%) |
| purpose | TEXT | |
| defaulted | INTEGER | 1 if the loan defaulted |
policies · 2,405 rows
Insurance policies (12-month terms).
| Column | Type | Description |
|---|---|---|
| policy_id | INTEGER | |
| customer_id | INTEGER | |
| policy_type | TEXT | |
| start_date | TEXT (ISO date) | |
| end_date | TEXT (ISO date) | |
| annual_premium | REAL | Premium (USD) |
| sales_channel | TEXT | agent / online / bank_branch |
| renewed | INTEGER | 1 if renewed at end of term |
claims · 392 rows
Insurance claims.
| Column | Type | Description |
|---|---|---|
| claim_id | INTEGER | |
| policy_id | INTEGER | |
| claim_date | TEXT (ISO date) | |
| claim_amount | REAL | |
| claim_status | TEXT | paid / rejected / pending |