Prosper Loan Data

@kaggle.henryokam_prosper_loan_data

Table List

1 table(21.44 MB)

Prosperloandata

@kaggle.henryokam_prosper_loan_data.prosperloandata

21.44 MB
113937 rows
81 columns

listingkey ListingKey	listingnumber ListingNumber	listingcreationdate ListingCreationDate	creditgrade CreditGrade	term Term	loanstatus LoanStatus	closeddate ClosedDate	borrowerapr BorrowerAPR	borrowerrate BorrowerRate	lenderyield LenderYield	estimatedeffectiveyield EstimatedEffectiveYield	estimatedloss EstimatedLoss	estimatedreturn EstimatedReturn	prosperrating_numeric ProsperRating (numeric)	prosperrating_alpha ProsperRating (Alpha)	prosperscore ProsperScore	listingcategory_numeric ListingCategory (numeric)	borrowerstate BorrowerState	occupation Occupation	employmentstatus EmploymentStatus	employmentstatusduration EmploymentStatusDuration	isborrowerhomeowner IsBorrowerHomeowner	currentlyingroup CurrentlyInGroup	groupkey GroupKey	datecreditpulled DateCreditPulled	creditscorerangelower CreditScoreRangeLower	creditscorerangeupper CreditScoreRangeUpper	firstrecordedcreditline FirstRecordedCreditLine	currentcreditlines CurrentCreditLines	opencreditlines OpenCreditLines	totalcreditlinespast7years TotalCreditLinespast7years	openrevolvingaccounts OpenRevolvingAccounts	openrevolvingmonthlypayment OpenRevolvingMonthlyPayment	inquirieslast6months InquiriesLast6Months	totalinquiries TotalInquiries	currentdelinquencies CurrentDelinquencies	amountdelinquent AmountDelinquent	delinquencieslast7years DelinquenciesLast7Years	publicrecordslast10years PublicRecordsLast10Years	revolvingcreditbalance RevolvingCreditBalance	bankcardutilization BankcardUtilization	availablebankcardcredit AvailableBankcardCredit	totaltrades TotalTrades	tradesneverdelinquent_percentage TradesNeverDelinquent (percentage)	tradesopenedlast6months TradesOpenedLast6Months	debttoincomeratio DebtToIncomeRatio	incomerange IncomeRange	incomeverifiable IncomeVerifiable	statedmonthlyincome StatedMonthlyIncome	loankey LoanKey	totalprosperloans TotalProsperLoans	totalprosperpaymentsbilled TotalProsperPaymentsBilled	ontimeprosperpayments OnTimeProsperPayments	prosperprincipalborrowed ProsperPrincipalBorrowed	prosperprincipaloutstanding ProsperPrincipalOutstanding	loanmonthssinceorigination LoanMonthsSinceOrigination	loannumber LoanNumber	loanoriginalamount LoanOriginalAmount	loanoriginationdate LoanOriginationDate	loanoriginationquarter LoanOriginationQuarter	memberkey MemberKey	monthlyloanpayment MonthlyLoanPayment	lp_customerpayments LP CustomerPayments	lp_customerprincipalpayments LP CustomerPrincipalPayments	lp_interestandfees LP InterestandFees	lp_servicefees LP ServiceFees	percentfunded PercentFunded	investors Investors
1021339766868145413AB3B	193129	2007-08-26 19:09:29.263000000	C	36	Completed	2009-08-14 00:00:00	0.16516	0.158	0.138					nan			CO	Other	Self-employed	2	true	true	nan	2007-08-26 18:41:46.780000000	640	659	Thu Oct 11 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	5	4	12	1	24	3	3	2	472	4				1500	11	0.81		0.17	$25,000-49,999	true	3083.333333	E33A3400205839220442E84						78	19141	9425	Wed Sep 12 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Q3 2007	1F3E3376408759268057EDA	330.43	11396.14	9425	1971.14	-133.18	1	258
10273602499503308B223C1	1209647	2014-02-27 08:28:07.900000000	nan	36	Current	nan	0.12016	0.092	0.082	0.0796	0.0249	0.0547	6	A	7	2	CO	Professional	Employed	44			nan	2014-02-27 08:28:14	680	699	Mon Mar 18 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	14	14	29	13	389	3	5				1	3989	0.21	10266	29	1	2	0.18	$50,000-74,999	true	6125	9E3B37071505919926B1D82							134815	10000	Mon Mar 03 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Q1 2014	1D13370546739025387B2F4	318.93					1	1
0EE9337825851032864889A	81716	2007-01-05 15:00:47.090000000	HR	36	Completed	2009-12-17 00:00:00	0.28269	0.275	0.24					nan			GA	Other	Not available			true	783C3371218786870A73D20	2007-01-02 14:09:10.060000000	480	499	Sat Jul 27 2002 00:00:00 GMT+0000 (Coordinated Universal Time)			3				1	1										0.06	Not displayed	true	2083.333333	6954337960046817851BCB2						86	6466	3001	Wed Jan 17 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Q1 2007	5F7033715035555618FA612	123.32	4186.63	3001	1185.63	-24.2	1	41
0EF5356002482715299901A	658116	2012-10-22 11:02:35.010000000	nan	36	Current	nan	0.12528	0.0974	0.0874	0.0849	0.0249	0.06	6	A	9	16	GA	Skilled Labor	Employed	113	true		nan	2012-10-22 11:02:32	800	819	Mon Feb 28 1983 00:00:00 GMT+0000 (Coordinated Universal Time)	5	5	29	7	115		1	4	10056	14		1444	0.04	30754	26	0.76		0.15	$25,000-49,999	true	2875	A0393664465886295619C51						16	77296	10000	Thu Nov 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	Q4 2012	9ADE356069835475068C6D2	321.45	5143.2	4091.09	1052.11	-108.01	1	158
0F023589499656230C5E3E2	909464	2013-09-14 18:38:39.097000000	nan	36	Current	nan	0.24614	0.2085	0.1985	0.18316	0.0925	0.09066	3	D	4	2	MN	Executive	Employed	44	true		nan	2013-09-14 18:38:44	680	699	Fri Feb 20 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	19	19	49	6	220	1	9					6193	0.81	695	39	0.95	2	0.26	$100,000+	true	9583.333333	A180369302188889200689E	1	11	11	11000	9947.9	6	102670	15000	Fri Sep 20 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Q3 2013	36CE356043264555721F06C	563.97	2819.85	1563.22	1256.63	-60.27	1	20
0F05359734824199381F61D	1074836	2013-12-14 08:26:37.093000000	nan	60	Current	nan	0.15425	0.1314	0.1214	0.11567	0.0449	0.07077	5	B	10	1	NM	Professional	Employed	82	true		nan	2013-12-14 08:26:40	740	759	Thu Mar 01 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	21	17	49	13	1410		2					62999	0.39	86509	47	1		0.36	$100,000+	true	8333.333333	C3D63702273952547E79520						3	123257	15000	Tue Dec 24 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Q4 2013	874A3701157341738DE458F	342.37	679.34	351.89	327.45	-25.33	1	1
0F0A3576754255009D63151	750899	2013-04-12 09:52:56.147000000	nan	36	Current	nan	0.31032	0.2712	0.2612	0.2382	0.1275	0.1107	2	E	2	1	KS	Sales - Retail	Employed	172			nan	2013-04-12 09:52:53	680	699	Fri Sep 29 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	10	7	20	6	214							5812	0.72	1929	16	0.68		0.27	$25,000-49,999	true	2083.333333	CE963680102927767790520						11	88353	3000	Thu Apr 18 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Q2 2013	AA4535764146102879D5959	122.67	1226.7	604.25	622.45	-22.95	1	1
0F1035772717087366F9EA7	768193	2013-05-05 06:49:27.493000000	nan	36	Current	nan	0.23939	0.2019	0.1919	0.1783	0.0799	0.0984	4	C	4	2	CA	Laborer	Employed	103			nan	2013-05-05 06:49:25	700	719	Thu Feb 25 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	6	6	10	5	101	3	16				1	1260	0.13	2181	10	0.8		0.24	$25,000-49,999	true	3355.75	0C87368108902149313D53B						10	90051	10000	Mon May 13 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Q2 2013	737F347089545035681C074	372.6	3353.4	1955.89	1397.51	-69.21	1	1
0F043596202561788EA13D5	1023355	2013-12-02 10:43:39.117000000	nan	36	Current	nan	0.0762	0.0629	0.0529	0.05221	0.0099	0.04231	7	AA	9	7	IL	Food Service	Employed	269	true		nan	2013-12-02 10:43:39	820	839	Thu Apr 01 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	17	16	32	12	219	1	6					9906	0.11	77696	29	1	1	0.25	$25,000-49,999	true	3333.333333	02163700809231365A56A1C						3	121268	10000	Thu Dec 12 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Q4 2013	49A53699682291323D04D66	305.54	611.08	505.58	105.5	-16.77	1	1
0F043596202561788EA13D5	1023355	2013-12-02 10:43:39.117000000	nan	36	Current	nan	0.0762	0.0629	0.0529	0.05221	0.0099	0.04231	7	AA	11	7	IL	Food Service	Employed	269	true		nan	2013-12-02 10:43:39	820	839	Thu Apr 01 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	17	16	32	12	219	1	6					9906	0.11	77696	29	1	1	0.25	$25,000-49,999	true	3333.333333	02163700809231365A56A1C						3	121268	10000	Thu Dec 12 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Q4 2013	49A53699682291323D04D66	305.54	611.08	505.58	105.5	-16.77	1	1


CREATE TABLE prosperloandata (
  "listingkey" VARCHAR,
  "listingnumber" BIGINT,
  "listingcreationdate" VARCHAR,
  "creditgrade" VARCHAR,
  "term" BIGINT,
  "loanstatus" VARCHAR,
  "closeddate" VARCHAR,
  "borrowerapr" DOUBLE,
  "borrowerrate" DOUBLE,
  "lenderyield" DOUBLE,
  "estimatedeffectiveyield" DOUBLE,
  "estimatedloss" DOUBLE,
  "estimatedreturn" DOUBLE,
  "prosperrating_numeric" DOUBLE,
  "prosperrating_alpha" VARCHAR,
  "prosperscore" DOUBLE,
  "listingcategory_numeric" BIGINT,
  "borrowerstate" VARCHAR,
  "occupation" VARCHAR,
  "employmentstatus" VARCHAR,
  "employmentstatusduration" DOUBLE,
  "isborrowerhomeowner" BOOLEAN,
  "currentlyingroup" BOOLEAN,
  "groupkey" VARCHAR,
  "datecreditpulled" VARCHAR,
  "creditscorerangelower" DOUBLE,
  "creditscorerangeupper" DOUBLE,
  "firstrecordedcreditline" TIMESTAMP,
  "currentcreditlines" DOUBLE,
  "opencreditlines" DOUBLE,
  "totalcreditlinespast7years" DOUBLE,
  "openrevolvingaccounts" BIGINT,
  "openrevolvingmonthlypayment" DOUBLE,
  "inquirieslast6months" DOUBLE,
  "totalinquiries" DOUBLE,
  "currentdelinquencies" DOUBLE,
  "amountdelinquent" DOUBLE,
  "delinquencieslast7years" DOUBLE,
  "publicrecordslast10years" DOUBLE,
  "publicrecordslast12months" DOUBLE,
  "revolvingcreditbalance" DOUBLE,
  "bankcardutilization" DOUBLE,
  "availablebankcardcredit" DOUBLE,
  "totaltrades" DOUBLE,
  "tradesneverdelinquent_percentage" DOUBLE,
  "tradesopenedlast6months" DOUBLE,
  "debttoincomeratio" DOUBLE,
  "incomerange" VARCHAR,
  "incomeverifiable" BOOLEAN,
  "statedmonthlyincome" DOUBLE,
  "loankey" VARCHAR,
  "totalprosperloans" DOUBLE,
  "totalprosperpaymentsbilled" DOUBLE,
  "ontimeprosperpayments" DOUBLE,
  "prosperpaymentslessthanonemonthlate" DOUBLE,
  "prosperpaymentsonemonthpluslate" DOUBLE,
  "prosperprincipalborrowed" DOUBLE,
  "prosperprincipaloutstanding" DOUBLE,
  "scorexchangeattimeoflisting" DOUBLE,
  "loancurrentdaysdelinquent" BIGINT,
  "loanfirstdefaultedcyclenumber" DOUBLE,
  "loanmonthssinceorigination" BIGINT,
  "loannumber" BIGINT,
  "loanoriginalamount" BIGINT,
  "loanoriginationdate" TIMESTAMP,
  "loanoriginationquarter" VARCHAR,
  "memberkey" VARCHAR,
  "monthlyloanpayment" DOUBLE,
  "lp_customerpayments" DOUBLE,
  "lp_customerprincipalpayments" DOUBLE,
  "lp_interestandfees" DOUBLE,
  "lp_servicefees" DOUBLE,
  "lp_collectionfees" DOUBLE,
  "lp_grossprincipalloss" DOUBLE,
  "lp_netprincipalloss" DOUBLE,
  "lp_nonprincipalrecoverypayments" DOUBLE,
  "percentfunded" DOUBLE,
  "recommendations" BIGINT,
  "investmentfromfriendscount" BIGINT,
  "investmentfromfriendsamount" DOUBLE,
  "investors" BIGINT
);