BigQuery Fintech Dataset

Comprehensive fintech data for loan and customer analysis.

@kaggle.mustafakeser4_bigquery_fintech_dataset

Table List

6 tables(46.89 MB)

Loan

Loan

@kaggle.mustafakeser4_bigquery_fintech_dataset.loan

22.29 MB
270299 rows
18 columns

loan_id Loan Id	customer_id Customer Id	loan_status Loan Status	loan_amount Loan Amount	state State	funded_amount Funded Amount	term Term	int_rate Int Rate	installment Installment	grade Grade	issue_d Issue D	issue_date Issue Date	issue_year Issue Year	type Type	purpose Purpose	description Description	notes Notes
1079	b'\x8d\x1es\xf1\xfep\xba\xfb/\x18,i\xbd\xd5 L4\xf3\xeds(\x13z\xe82\x81h\xad\xbb\xa6\xa9Z'	Fully Paid	1000	MI	1000	36 months	0.2295	38.689999	F	Jun-13	June 2013	2013	INDIVIDUAL	moving	Moving loan	desc
1613	b"-3\xd4(\x15\xe4@\x08\xab\x11\|\xf7\x01\xe8\x86\\me\xd6\x0f\x80\xf1Bd\xa2\xdc\xfe\xd9\x15{'\x1c"	Fully Paid	1200	AZ	1200	36 months	0.1629	42.369999	D	Sep-14	September 2014	2014	INDIVIDUAL	moving	Moving and relocation	desc
1865	b'\x87\xa7\xb6\x9aW\n(P\x08\xbb?@~\x8c\xe1\x04i\x98\x1b\x94\xc1\np\xff\xc24\xfc\xdd\xcdF\x1a\x0f'	Fully Paid	1400	NV	1400	36 months	0.1114	45.93	B	Oct-12	October 2012	2012	INDIVIDUAL	medical	medical expenses	desc
3575	b'\xc5\xf4\xfe\xd8k\xced_*uq\x9a\xd6\x8c?t\x18\xad\x1c\x8a\xff\xd8\xe1/\x1eD\xfaD\xef\x8a\xba\xd0'	Current	1975	NY	1975	36 months	0.1049	64.190002	B	Dec-14	December 2014	2014	INDIVIDUAL	major_purchase	Major purchase	desc
5259	b"\x13\xe7@\xa2F\xe7S\xf9'\rlv<i*\x04\xd0uQ\xe5\x89U\xb4\t\x19\xf2\xa3G\x80\x89\xb60"	Fully Paid	2000	GA	2000	36 months	0.1875	73.059998	D	Jan-13	January 2013	2013	INDIVIDUAL	major_purchase	Major purchase	desc
5943	b"\xa4w\xfdm\xc7Ud\xa6\xdd_\xaeS_\xcbe\xcc\xa6\xf7O\x08\xda\xd1\xdc\xac\xaa\xbb\xf95\x12\x07'-"	Charged Off	2200	LA	2200	36 months	0.2115	83.059998	E	Aug-13	August 2013	2013	INDIVIDUAL	other	Consolidating	desc
6025	b'r\xdc\x19[\xfdL\xb2?Q\xd2\xe2\xe89\x95\x85\|\n\x8a\x8eBu\x9d\x85\xf8\x1d\xe9\x1d\x1a\x059w~'	Fully Paid	2300	FL	2300	36 months	0.0662	70.620003	A	Apr-13	April 2013	2013	INDIVIDUAL	major_purchase	AR15 Purchase	desc
6205	b'\xcf\x1aL3\xdf%\xb8\x94B\xa5\x1ds\xe3\x08\x01\xc2\x9f\xa4\xdd\xfc\xc8>\xf3x\x01,\xba\x14\x81\xe6\x8d#'	Fully Paid	2400	OR	2400	36 months	0.079	75.099998	A	Oct-12	October 2012	2012	INDIVIDUAL	debt_consolidation	Debt consolidation	desc
7365	b'\xa0EH\x17y\x03P\xe7v"\x9f\x12w\x19\xd7\xd3\xfet\x8au\xe8\xdcs\xdd\xb7C=\ng\x08c\xd6'	Charged Off	2500	TN	2500	36 months	0.1212	83.18	B	Mar-13	March 2013	2013	INDIVIDUAL	debt_consolidation	payoff bill	desc
7464	b'\x0cR\xb0K\x06K\xc8\x9c\xff\x8a\xa3\xc5\x86sU\x91\x12\x17\xce\xfa\x1f\xe1\xff\xfb\xbc\x10M\x97:^\xf6\x91'	Current	2500	IN	2500	36 months	0.1299	84.230003	C	Sep-14	September 2014	2014	INDIVIDUAL	home_improvement	Home improvement	desc


CREATE TABLE loan (
  "loan_id" BIGINT,
  "customer_id" VARCHAR,
  "loan_status" VARCHAR,
  "loan_amount" DOUBLE,
  "state" VARCHAR,
  "funded_amount" DOUBLE,
  "term" VARCHAR,
  "int_rate" DOUBLE,
  "installment" DOUBLE,
  "grade" VARCHAR,
  "issue_d" VARCHAR,
  "issue_date" VARCHAR,
  "issue_year" DOUBLE,
  "pymnt_plan" BOOLEAN,
  "type" VARCHAR,
  "purpose" VARCHAR,
  "description" VARCHAR,
  "notes" VARCHAR
);