Lending Club Data

A large open set of data on the people who received loans through their platform

@kaggle.joebeachcapital_lending_club

Table List

1 table(741.64 KB)

Loans Full Schema

@kaggle.joebeachcapital_lending_club.loans_full_schema

741.64 KB
10000 rows
55 columns

emp_title Emp Title	emp_length Emp Length	state State	homeownership Homeownership	annual_income Annual Income	verified_income Verified Income	debt_to_income Debt To Income	annual_income_joint Annual Income Joint	verification_income_joint Verification Income Joint	debt_to_income_joint Debt To Income Joint	delinq_2y Delinq 2y	months_since_last_delinq Months Since Last Delinq	earliest_credit_line Earliest Credit Line	inquiries_last_12m Inquiries Last 12m	total_credit_lines Total Credit Lines	open_credit_lines Open Credit Lines	total_credit_limit Total Credit Limit	total_credit_utilized Total Credit Utilized	num_historical_failed_to_pay Num Historical Failed To Pay	months_since_90d_late Months Since 90d Late	total_collection_amount_ever Total Collection Amount Ever	current_installment_accounts Current Installment Accounts	accounts_opened_24m Accounts Opened 24m	months_since_last_credit_inquiry Months Since Last Credit Inquiry	num_satisfactory_accounts Num Satisfactory Accounts	num_active_debit_accounts Num Active Debit Accounts	total_debit_limit Total Debit Limit	num_total_cc_accounts Num Total Cc Accounts	num_open_cc_accounts Num Open Cc Accounts	num_cc_carrying_balance Num Cc Carrying Balance	num_mort_accounts Num Mort Accounts	account_never_delinq_percent Account Never Delinq Percent	tax_liens Tax Liens	public_record_bankrupt Public Record Bankrupt	loan_purpose Loan Purpose	application_type Application Type	loan_amount Loan Amount	term Term	interest_rate Interest Rate	installment Installment	grade Grade	sub_grade Sub Grade	issue_month Issue Month	loan_status Loan Status	initial_listing_status Initial Listing Status	disbursement_method Disbursement Method	balance Balance	paid_total Paid Total	paid_principal Paid Principal	paid_interest Paid Interest
global config engineer	3	NJ	MORTGAGE	90000	Verified	18.01		nan			38	2001	6	28	10	70795	38767		38	1250	2	5	5	10	2	11100	14	8	6	1	92.9			moving	individual	28000	60	14.07	652.53	C	C3	Mar-2018	Current	whole	Cash	27015.86	1999.33	984.14	1015.19
warehouse office clerk	10	HI	RENT	40000	Not Verified	5.04		nan				1996	1	30	14	28800	4321	1				11	8	14	3	16500	24	14	4		100		1	debt_consolidation	individual	5000	36	12.61	167.54	C	C1	Feb-2018	Current	whole	Cash	4651.37	499.12	348.63	150.49
assembly	3	WI	RENT	40000	Source Verified	21.15		nan			28	2006	4	31	10	24193	16000		28	432	1	13	7	10	3	4300	14	8	6		93.5			other	individual	2000	36	17.09	71.4	D	D1	Feb-2018	Current	fractional	Cash	1824.63	281.8	175.37	106.43
customer service	1	PA	RENT	30000	Not Verified	10.16		nan				2007		4	4	25400	4997	1			1	1	15	4	2	19400	3	3	2		100	1		debt_consolidation	individual	21600	36	6.72	664.19	A	A3	Jan-2018	Current	whole	Cash	18853.26	3312.89	2746.74	566.15
security supervisor	10	CA	RENT	35000	Verified	57.96	57000	Verified	37.66			2008	7	22	16	69839	52722				1	6	4	16	10	32700	20	15	13		100			credit_card	joint	23000	36	14.07	786.87	C	C3	Mar-2018	Current	whole	Cash	21430.15	2324.65	1569.85	754.8
nan		KY	OWN	34000	Not Verified	6.46		nan		1	3	1990	6	32	12	42100	3898		60			2	5	12	1	27200	27	12	5	3	78.1			other	individual	5000	36	6.72	153.75	A	A3	Jan-2018	Current	whole	Cash	4256.71	873.13	743.29	129.84
hr	10	MI	MORTGAGE	35000	Source Verified	23.66	155000	Not Verified	13.12			2004	1	12	10	291852	18916				2	1	9	10	3	9100	8	7	6	2	100			credit_card	joint	24000	60	13.59	553.35	C	C2	Jan-2018	Current	whole	Cash	22560	2730.51	1440	1290.51
police	10	AZ	MORTGAGE	110000	Source Verified	16.19		nan		1	19	2005	1	30	15	342336	60805		71		2	4	7	15	5	22250	16	12	10	7	93			debt_consolidation	individual	20000	60	11.99	444.79	B	B5	Jan-2018	Current	whole	Cash	19005.39	1765.84	994.61	771.23
parts	10	NV	MORTGAGE	65000	Source Verified	36.48		nan		1	18	1998	3	35	21	283190	69561		18		6	10	4	21	11	36700	19	14	14	2	97.1			home_improvement	individual	20000	36	13.59	679.58	C	C2	Feb-2018	Current	whole	Cash	18156.66	2703.22	1843.34	859.88
4th person	3	IL	RENT	30000	Not Verified	18.91		nan				2001		9	6	33114	17768				1	5	17	6	3	14700	7	5	3		100			credit_card	individual	6400	36	6.71	196.77	A	A3	Mar-2018	Current	fractional	Cash	6077.13	391.15	322.87	68.28


CREATE TABLE loans_full_schema (
  "emp_title" VARCHAR,
  "emp_length" DOUBLE,
  "state" VARCHAR,
  "homeownership" VARCHAR,
  "annual_income" DOUBLE,
  "verified_income" VARCHAR,
  "debt_to_income" DOUBLE,
  "annual_income_joint" DOUBLE,
  "verification_income_joint" VARCHAR,
  "debt_to_income_joint" DOUBLE,
  "delinq_2y" BIGINT,
  "months_since_last_delinq" DOUBLE,
  "earliest_credit_line" BIGINT,
  "inquiries_last_12m" BIGINT,
  "total_credit_lines" BIGINT,
  "open_credit_lines" BIGINT,
  "total_credit_limit" BIGINT,
  "total_credit_utilized" BIGINT,
  "num_collections_last_12m" BIGINT,
  "num_historical_failed_to_pay" BIGINT,
  "months_since_90d_late" DOUBLE,
  "current_accounts_delinq" BIGINT,
  "total_collection_amount_ever" BIGINT,
  "current_installment_accounts" BIGINT,
  "accounts_opened_24m" BIGINT,
  "months_since_last_credit_inquiry" DOUBLE,
  "num_satisfactory_accounts" BIGINT,
  "num_accounts_120d_past_due" DOUBLE,
  "num_accounts_30d_past_due" BIGINT,
  "num_active_debit_accounts" BIGINT,
  "total_debit_limit" BIGINT,
  "num_total_cc_accounts" BIGINT,
  "num_open_cc_accounts" BIGINT,
  "num_cc_carrying_balance" BIGINT,
  "num_mort_accounts" BIGINT,
  "account_never_delinq_percent" DOUBLE,
  "tax_liens" BIGINT,
  "public_record_bankrupt" BIGINT,
  "loan_purpose" VARCHAR,
  "application_type" VARCHAR,
  "loan_amount" BIGINT,
  "term" BIGINT,
  "interest_rate" DOUBLE,
  "installment" DOUBLE,
  "grade" VARCHAR,
  "sub_grade" VARCHAR,
  "issue_month" VARCHAR,
  "loan_status" VARCHAR,
  "initial_listing_status" VARCHAR,
  "disbursement_method" VARCHAR,
  "balance" DOUBLE,
  "paid_total" DOUBLE,
  "paid_principal" DOUBLE,
  "paid_interest" DOUBLE,
  "paid_late_fees" DOUBLE
);