Loan Data

This dataset includes customers who have paid off their loans or not

@kaggle.zhijinzhai_loandata

Table List

1 table(15.99 KB)

Loan Payments Data

@kaggle.zhijinzhai_loandata.loan_payments_data

15.99 KB
500 rows
11 columns

loan_id Loan ID	loan_status Loan Status	principal Principal	terms Terms	effective_date Effective Date	due_date Due Date	paid_off_time Paid Off Time	age Age	education Education	gender Gender
xqd20166231	PAIDOFF	1000	30	Thu Sep 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Sep 14 2016 19:31:00 GMT+0000 (Coordinated Universal Time)	45	High School or Below	male
xqd20168902	PAIDOFF	1000	30	Thu Sep 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 07 2016 09:00:00 GMT+0000 (Coordinated Universal Time)	50	Bechalor	female
xqd20160003	PAIDOFF	1000	30	Thu Sep 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Sep 25 2016 16:58:00 GMT+0000 (Coordinated Universal Time)	33	Bechalor	female
xqd20160004	PAIDOFF	1000	15	Thu Sep 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Sep 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Sep 22 2016 20:00:00 GMT+0000 (Coordinated Universal Time)	27	college	male
xqd20160005	PAIDOFF	1000	30	Fri Sep 09 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Oct 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 23 2016 21:36:00 GMT+0000 (Coordinated Universal Time)	28	college	female
xqd20160706	PAIDOFF	300	7	Fri Sep 09 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Sep 15 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Sep 09 2016 13:45:00 GMT+0000 (Coordinated Universal Time)	35	Master or Above	male
xqd20160007	PAIDOFF	1000	30	Fri Sep 09 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Oct 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 07 2016 23:07:00 GMT+0000 (Coordinated Universal Time)	29	college	male
xqd20160008	PAIDOFF	1000	30	Fri Sep 09 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Oct 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 05 2016 20:33:00 GMT+0000 (Coordinated Universal Time)	36	college	male
xqd20160909	PAIDOFF	1000	30	Fri Sep 09 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Oct 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Oct 08 2016 16:00:00 GMT+0000 (Coordinated Universal Time)	28	college	male
xqd20160010	PAIDOFF	800	15	Sat Sep 10 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Sep 24 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Sep 24 2016 13:00:00 GMT+0000 (Coordinated Universal Time)	26	college	male


CREATE TABLE loan_payments_data (
  "loan_id" VARCHAR,
  "loan_status" VARCHAR,
  "principal" BIGINT,
  "terms" BIGINT,
  "effective_date" TIMESTAMP,
  "due_date" TIMESTAMP,
  "paid_off_time" TIMESTAMP,
  "past_due_days" DOUBLE,
  "age" BIGINT,
  "education" VARCHAR,
  "gender" VARCHAR
);