Bondora P2P Loans Outdated
Loan Data of Bondora P2P Loans
@kaggle.marcobeyer_bondora_loans
Loan Data of Bondora P2P Loans
@kaggle.marcobeyer_bondora_loans
CREATE TABLE loandata (
"reportasofeod" TIMESTAMP,
"loanid" VARCHAR,
"loannumber" BIGINT,
"listedonutc" TIMESTAMP,
"biddingstartedon" TIMESTAMP,
"bidsportfoliomanager" BIGINT,
"bidsapi" DOUBLE,
"bidsmanual" DOUBLE,
"partyid" VARCHAR,
"newcreditcustomer" BOOLEAN,
"loanapplicationstarteddate" TIMESTAMP,
"loandate" TIMESTAMP,
"contractenddate" TIMESTAMP,
"firstpaymentdate" TIMESTAMP,
"maturitydate_original" TIMESTAMP,
"maturitydate_last" VARCHAR,
"applicationsignedhour" BIGINT,
"applicationsignedweekday" BIGINT,
"verificationtype" DOUBLE,
"languagecode" BIGINT,
"age" BIGINT,
"dateofbirth" VARCHAR,
"gender" DOUBLE,
"country" VARCHAR,
"appliedamount" DOUBLE,
"amount" DOUBLE,
"interest" DOUBLE,
"loanduration" BIGINT,
"monthlypayment" DOUBLE,
"county" VARCHAR,
"city" VARCHAR,
"useofloan" BIGINT,
"education" DOUBLE,
"maritalstatus" DOUBLE,
"nrofdependants" VARCHAR,
"employmentstatus" DOUBLE,
"employmentdurationcurrentemployer" VARCHAR,
"employmentposition" VARCHAR,
"workexperience" VARCHAR,
"occupationarea" DOUBLE,
"homeownershiptype" DOUBLE,
"incomefromprincipalemployer" DOUBLE,
"incomefrompension" DOUBLE,
"incomefromfamilyallowance" DOUBLE,
"incomefromsocialwelfare" DOUBLE,
"incomefromleavepay" DOUBLE,
"incomefromchildsupport" DOUBLE,
"incomeother" DOUBLE,
"incometotal" DOUBLE,
"existingliabilities" BIGINT,
"liabilitiestotal" DOUBLE,
"refinanceliabilities" BIGINT,
"debttoincome" DOUBLE,
"freecash" DOUBLE,
"monthlypaymentday" BIGINT,
"activeschedulefirstpaymentreached" BOOLEAN,
"plannedprincipaltilldate" DOUBLE,
"plannedinteresttilldate" DOUBLE,
"lastpaymenton" TIMESTAMP,
"currentdebtdaysprimary" DOUBLE,
"debtoccuredon" TIMESTAMP,
"currentdebtdayssecondary" DOUBLE,
"debtoccuredonforsecondary" TIMESTAMP,
"expectedloss" DOUBLE,
"lossgivendefault" DOUBLE,
"expectedreturn" DOUBLE,
"probabilityofdefault" DOUBLE,
"defaultdate" TIMESTAMP,
"principaloverduebyschedule" DOUBLE,
"plannedprincipalpostdefault" DOUBLE,
"plannedinterestpostdefault" DOUBLE,
"ead1" DOUBLE,
"ead2" DOUBLE,
"principalrecovery" DOUBLE,
"interestrecovery" DOUBLE,
"recoverystage" DOUBLE,
"stageactivesince" VARCHAR,
"modelversion" DOUBLE,
"rating" VARCHAR,
"el_v0" DOUBLE,
"rating_v0" VARCHAR,
"el_v1" DOUBLE,
"rating_v1" VARCHAR,
"rating_v2" VARCHAR,
"status" VARCHAR,
"restructured" BOOLEAN,
"activelatecategory" VARCHAR,
"worselatecategory" VARCHAR,
"creditscoreesmicrol" VARCHAR,
"creditscoreesequifaxrisk" VARCHAR,
"creditscorefiasiakastietoriskgrade" VARCHAR,
"creditscoreeemini" DOUBLE,
"principalpaymentsmade" DOUBLE,
"interestandpenaltypaymentsmade" DOUBLE,
"principalwriteoffs" DOUBLE,
"interestandpenaltywriteoffs" DOUBLE,
"principalbalance" DOUBLE,
"interestandpenaltybalance" DOUBLE,
"noofpreviousloansbeforeloan" DOUBLE,
"amountofpreviousloansbeforeloan" DOUBLE
);
Anyone who has the link will be able to view this.