Finance Loan Default Prediction
This dataset provides comprehensive, flat-structured records of individual loans and borrower profiles, including demographic, financial, and credit information, as well as loan terms, status, and default indicators. It is ideal for building predictive models for loan default risk, optimizing lending portfolios, and conducting borrower risk analysis in financial services.
Sample rows
preview · 8 of 200 rows · all 29 columns| loan_idstring | loan_typestring | loan_term_monthsinteger | loan_defaultedboolean | borrower_address_countrystring | borrower_idstring | borrower_namestring | borrower_ageinteger | borrower_genderstring | borrower_employment_statusstring | borrower_annual_incomefloat | borrower_credit_scoreinteger | borrower_address_streetstring | borrower_address_citystring | borrower_address_statestring | borrower_address_postal_codestring | loan_amountfloat | loan_interest_ratefloat | loan_application_datedate | loan_approval_datedate | loan_statusstring | loan_default_datedate | loan_purposestring | number_of_previous_loansinteger | number_of_previous_defaultsinteger | borrower_employer_namestring | borrower_years_with_employerfloat | loan_collateral_typestring | loan_collateral_valuefloat |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A1C8D9FQ | auto | 48 | false | USA | B8ZT3H | Emma Rodriguez | 35 | female | employed | 54000.75 | 661 | 1245 Willow Ave | Denver | CO | 80204 | 25000 | 7.2 | 2023-03-14 | 2023-03-18 | active | blank | Purchase of new vehicle | 2 | 0 | Greenway Motors | 6.5 | vehicle | 27000 |
| K9E4L2RP | business | 60 | false | USA | C2MK7D | Noah Patel | 41 | male | self-employed | 88000 | 712 | 963 South Street | Austin | TX | 78701 | 50000 | 8.5 | 2022-09-10 | 2022-09-15 | approved | blank | Business expansion capital | 4 | 1 | Patel Consulting LLC | 10.8 | property | 65000 |
| Z5X8J7NQ | personal | 36 | false | USA | H4VP9E | Liam Kim | 28 | male | employed | 62000 | 678 | 7801 Oak Lane | San Jose | CA | 95123 | 15000 | 9.1 | 2023-01-20 | 2023-01-24 | active | blank | Medical expenses | 1 | 0 | TechNova Inc | 2.3 | none | 0 |
| R2G7S4WY | mortgage | 180 | false | USA | N1BF6L | Olivia Martin | 50 | female | retired | 25000 | 704 | 9052 Maple Dr | Orlando | FL | 32801 | 120000 | 5 | 2021-05-08 | 2021-05-13 | active | blank | Home purchase | 5 | 1 | blank | blank | property | 140000 |
| F6U2V5BJ | education | 60 | false | USA | S3QN4M | Lucas White | 23 | male | student | 12000 | 595 | 480 College Rd | Ann Arbor | MI | 48104 | 18000 | 6.9 | 2023-08-12 | 2023-08-17 | approved | blank | College tuition fees | 0 | 0 | blank | blank | guarantor | 20000 |
| P7T3B1XY | auto | 72 | false | USA | L8AR5Q | Sophia Brown | 30 | female | employed | 47000 | 642 | 284 Cedar St | Cincinnati | OH | 45202 | 28000 | 6.5 | 2022-06-19 | 2022-06-23 | active | blank | Car replacement | 2 | 0 | MediTech Solutions | 4.7 | vehicle | 31000 |
| E6W9U2MG | business | 120 | false | USA | K3XJ2C | Charlotte Nguyen | 45 | female | self-employed | 95000 | 755 | 1608 Pinecrest Blvd | Seattle | WA | 98115 | 90000 | 5.8 | 2021-11-04 | 2021-11-09 | active | blank | Store renovation | 6 | 2 | Nguyen Design Studio | 13.2 | property | 120000 |
| J5H7Z8NC | auto | 60 | false | USA | P6GL2F | Mason Clark | 32 | male | employed | 53000 | 633 | 4012 Birchwood Ave | Salt Lake City | UT | 84111 | 35000 | 7.3 | 2022-02-27 | 2022-03-02 | approved | blank | SUV purchase | 1 | 0 | Clark & Sons | 3.1 | vehicle | 37000 |
| V3T1D8QK | personal | 36 | false | USA | M7RE6D | Ava Scott | 27 | female | employed | 41000 | 665 | 6710 Walnut St | Raleigh | NC | 27601 | 22000 | 8.2 | 2023-02-11 | 2023-02-14 | active | blank | Debt consolidation | 1 | 0 | Scott Marketing | 1.9 | none | 0 |
| Q2P6E9YB | mortgage | 240 | false | USA | J1TW7N | Ethan Harris | 38 | male | employed | 85000 | 789 | 3241 Spruce Ct | Phoenix | AZ | 85018 | 215000 | 4.2 | 2020-12-04 | 2020-12-10 | active | blank | Primary residence purchase | 3 | 0 | Harris Realty | 7.5 | property | 260000 |
| Y9J5M3BR | personal | 24 | false | USA | G2VK8W | Mia Walker | 29 | female | employed | 72000 | 733 | 1397 Cherry Lane | Nashville | TN | 37203 | 18000 | 10 | 2023-05-19 | 2023-05-25 | approved | blank | Wedding expenses | 1 | 0 | Walker Design Studio | 2.6 | none | 0 |
| N8S2L7KY | mortgage | 180 | false | USA | E4RP3A | Benjamin Rivera | 64 | male | retired | 32000 | 735 | 7756 Ridgecrest Rd | Tucson | AZ | 85719 | 145000 | 4.8 | 2021-03-29 | 2021-04-02 | active | blank | Retirement home | 7 | 2 | blank | blank | property | 160000 |
| D3U6E8XF | education | 60 | false | USA | K5XM2T | Isabella Lee | 26 | female | student | 9000 | 575 | 4200 Elm St | Madison | WI | 53703 | 18000 | 7.4 | 2022-08-14 | 2022-08-19 | approved | blank | Graduate study program | 0 | 0 | blank | blank | guarantor | 15000 |
| W1G4Q7LK | mortgage | 120 | false | USA | U6JD9N | William Turner | 54 | male | retired | 29000 | 648 | 2005 Oak Grove Rd | Springfield | IL | 62704 | 95000 | 6.1 | 2022-04-13 | 2022-04-18 | active | blank | Condo purchase | 6 | 1 | blank | blank | property | 105000 |
| X7P1S6GJ | business | 72 | false | USA | Y2MC8V | Elijah Carter | 31 | male | self-employed | 69000 | 703 | 3257 Aspen Ct | Boise | ID | 83705 | 38000 | 6.7 | 2023-01-03 | 2023-01-09 | active | blank | Working capital | 3 | 0 | Carter Digital LLC | 4.2 | property | 42000 |
| B5J2T9HV | personal | 18 | false | USA | M2GK7P | Amelia Evans | 48 | female | employed | 105000 | 832 | 8906 Magnolia Rd | Dallas | TX | 75201 | 7000 | 12.2 | 2022-07-27 | 2022-07-29 | approved | blank | Travel expenses | 5 | 1 | Evans Medical Group | 14.3 | none | 0 |
| C4F8K3DP | personal | 36 | false | USA | P7JQ4T | James Murphy | 36 | male | employed | 69000 | 721 | 5432 Willow St | Charlotte | NC | 28202 | 14000 | 8.9 | 2023-03-21 | 2023-03-25 | active | blank | Moving expenses | 2 | 0 | Murphy Construction | 5.7 | none | 0 |
| G2V9L1ZT | business | 84 | false | USA | N5LR6J | Harper Davis | 44 | female | self-employed | 98000 | 760 | 7629 Parkside Ave | Portland | OR | 97201 | 32000 | 7 | 2021-10-30 | 2021-11-04 | active | blank | Equipment purchase | 4 | 0 | Davis Consulting Group | 8.6 | property | 36000 |
| L3C7Z9SM | mortgage | 180 | false | USA | T1WB8D | Alexander Hall | 59 | male | retired | 26000 | 720 | 1362 Sycamore Dr | Richmond | VA | 23220 | 78000 | 5.3 | 2022-03-07 | 2022-03-12 | active | blank | Home refinance | 6 | 2 | blank | blank | property | 90000 |
| S8M4K2BQ | personal | 24 | false | USA | A4HJ2V | Emily Adams | 34 | female | employed | 58000 | 695 | 7407 Ivy St | Boulder | CO | 80301 | 12000 | 11.6 | 2023-02-24 | 2023-02-28 | approved | blank | Vacation | 3 | 0 | Adams & Associates | 4.4 | none | 0 |
What the 200 rows show
from the 200-row sampleMortgage (loan type) stands out: mean loan_
- 2%loan_
defaulted = true - 39median loan_
term_ months - 3borrower genders
- 4borrower employment statuses
- 5loan statuses
- 5loan collateral types
Median 39, from 12 to 360.
- string 15
- integer 5
- float 5
- date 3
- boolean 1
Columns
29 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 15 columns | |||
loan_id | string | Unique identifier for each loan applicationunique | A1C8D9FQ |
borrower_id | string | Unique identifier for each borrower | B8ZT3H |
borrower_name | string | Full name of the borrower | Emma Rodriguez |
borrower_gender | string | Gender of the borrowermale · female · other · prefer_not_to_say · optional | female |
borrower_employment_status | string | Employment status of the borroweremployed · self-employed · unemployed · retired · student | employed |
borrower_address_street | string | Street address of the borroweroptional | 1245 Willow Ave |
borrower_address_city | string | City of the borroweroptional | Denver |
borrower_address_state | string | State or province of the borroweroptional | CO |
borrower_address_postal_code | string | Postal code of the borroweroptional | 80204 |
borrower_address_country | string | Country of the borroweroptional | USA |
loan_type | string | Type of loan issued6 values | auto |
loan_status | string | Current status of the loan6 values | active |
loan_purpose | string | Purpose for which the loan was takenoptional | Purchase of new vehicle |
borrower_employer_name | string | Name of the borrower's employer (if employed)optional | Greenway Motors |
loan_collateral_type | string | Type of collateral provided for the loan (if any)6 values · optional | vehicle |
| Numbers 10 columns | |||
borrower_age | integer | Age of the borrower at loan application18 to 100 | 35 |
borrower_annual_income | float | Annual income of the borrower in local currency0 or more | 54000.75 |
borrower_credit_score | integer | Credit score of the borrower at the time of loan application300 to 900 | 661 |
loan_amount | float | Total amount of the loan issued0 or more | 25000 |
loan_term_months | integer | Duration of the loan in months1 to 360 | 48 |
loan_interest_rate | float | Annual interest rate applied to the loan (percentage)0 to 100 | 7.2 |
number_of_previous_loans | integer | Number of previous loans taken by the borrower0 or more · optional | 2 |
number_of_previous_defaults | integer | Number of previous loans that were defaulted by the borrower0 or more · optional | 0 |
borrower_years_with_employer | float | Number of years borrower has been with current employer0 or more · optional | 6.5 |
loan_collateral_value | float | Estimated value of the collateral (if any)0 or more · optional | 27000 |
| Dates and times 3 columns | |||
loan_application_date | date | Date when the loan application was submitted | 2023-03-14 |
loan_approval_date | date | Date when the loan was approvedoptional | 2023-03-18 |
loan_default_date | date | Date when the loan was marked as defaulted (if applicable)optional | 2024-03-12 |
| True or false 1 column | |||
loan_defaulted | boolean | Indicates if the loan has defaulted (true/false) | false |
Use it for
A finance dashboard
The loan_
defaulted rate, loan_ term_ months by loan_ type and a breakdown of borrower_ address_ country. Excel, Power BI or Tableau. Why do the 22 mortgage rows have a mean loan_
term_ months of 199.1? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Loans200A1C8D9FQ48autoJ8F5T2EQ18personalB6T4Q8LK24personal
A software demo
Believable loans with borrower_
id, borrower_ name and borrower_ age to fill a screen in front of a buyer.
blueprint · finance-loan-default-prediction
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 29 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Loan type and purpose provided
- Borrower credit scores included
- Default status accurately flagged
- Payment histories complete
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- finance-loan-default-prediction