Financial Risk V2
This synthetic dataset comprises 20,000 records of personal and financial data.
@kaggle.willianoliveiragibin_financial_risk_v2
This synthetic dataset comprises 20,000 records of personal and financial data.
@kaggle.willianoliveiragibin_financial_risk_v2
The dataset includes a variety of features such as demographic information, credit history, employment status, income levels, existing debt, and other relevant financial metrics, providing a comprehensive foundation for sophisticated data-driven analysis and decision-making. Below are the columns included in the dataset:
ApplicationDate: Loan application date, essential for tracking the history of loan requests.
Age: The applicant's age, an indicator of financial stability.
AnnualIncome: Annual income, representing the individual's financial capacity.
CreditScore: Credit score that measures the applicant's ability to repay.
EmploymentStatus: Employment status, reflecting income stability.
EducationLevel: Education level, which can influence income prospects.
Experience: Years of work experience, indicating consistency in the labor market.
LoanAmount: The requested loan amount.
LoanDuration: The repayment period of the loan.
MaritalStatus: The applicant's marital status, which can affect financial obligations.
NumberOfDependents: The number of dependents the applicant supports.
HomeOwnershipStatus: Type of homeownership (owned or rented), related to financial security.
MonthlyDebtPayments: Monthly debt payments, showing the level of indebtedness.
CreditCardUtilizationRate: Credit utilization percentage, an important factor in risk assessment.
NumberOfOpenCreditLines: The number of active credit lines.
NumberOfCreditInquiries: The number of credit inquiries, a potential signal of financial need.
DebtToIncomeRatio: The ratio of total debt to income, representing the level of debt relative to salary.
BankruptcyHistory: History of bankruptcies, a strong indicator of risk.
LoanPurpose: The reason for the loan (e.g., personal use, mortgage, education).
PreviousLoanDefaults: Records of defaults on previous loans.
PaymentHistory: Payment history, reflecting the applicant's financial behavior.
LengthOfCreditHistory: The duration of the credit history, indicating how long credit has been used.
SavingsAccountBalance: The balance in the savings account, showing financial reserves.
CheckingAccountBalance: The balance in the checking account, representing immediate liquidity.
TotalAssets: Total assets owned by the applicant, such as real estate and investments.
TotalLiabilities: The applicant’s total debt, a key measure of financial health.
MonthlyIncome: Monthly income, directly affecting the ability to make payments.
UtilityBillsPaymentHistory: Payment history for utility bills, indicating financial responsibility.
CREATE TABLE loan_new_datset (
"applicationdate" TIMESTAMP,
"age" BIGINT,
"annualincome" BIGINT,
"creditscore" BIGINT,
"employmentstatus" VARCHAR,
"educationlevel" VARCHAR,
"experience" BIGINT,
"loanamount" BIGINT,
"loanduration" BIGINT,
"maritalstatus" VARCHAR,
"numberofdependents" BIGINT,
"homeownershipstatus" VARCHAR,
"monthlydebtpayments" BIGINT,
"creditcardutilizationrate" VARCHAR,
"numberofopencreditlines" BIGINT,
"numberofcreditinquiries" BIGINT,
"debttoincomeratio" VARCHAR,
"bankruptcyhistory" BIGINT,
"loanpurpose" VARCHAR,
"previousloandefaults" BIGINT,
"paymenthistory" BIGINT,
"lengthofcredithistory" BIGINT,
"savingsaccountbalance" BIGINT,
"checkingaccountbalance" BIGINT,
"totalassets" BIGINT,
"totalliabilities" BIGINT,
"monthlyincome" VARCHAR,
"utilitybillspaymenthistory" VARCHAR,
"jobtenure" BIGINT,
"networth" BIGINT,
"baseinterestrate" VARCHAR,
"interestrate" VARCHAR,
"monthlyloanpayment" VARCHAR,
"totaldebttoincomeratio" VARCHAR,
"loanapproved" BIGINT,
"riskscore" VARCHAR
);Anyone who has the link will be able to view this.