BigQuery Fintech Dataset

Comprehensive fintech data for loan and customer analysis.

@kaggle.mustafakeser4_bigquery_fintech_dataset

Table List

6 tables(46.89 MB)

Loan

Customer

@kaggle.mustafakeser4_bigquery_fintech_dataset.customer

23.24 MB
270299 rows
11 columns

customer_id Customer Id	emp_title Emp Title	emp_length Emp Length	home_ownership Home Ownership	annual_inc Annual Inc	annual_inc_joint Annual Inc Joint	verification_status Verification Status	zip_code Zip Code	addr_state Addr State	avg_cur_bal Avg Cur Bal	tot_cur_bal Tot Cur Bal
b'\xa0\xe6\x1a\xc8H\xbd/(T]\x13[\xf5\x0fK\xd9\xc1Q\x9aMg\x9c?_\x06\xc7\x9c1\xcd\xbd\xe4j'	nan	nan	RENT	25000		Verified	010xx	MA	6864	34322
b'c\xe3S\xf0yY7\xba\xda\x16JF\xec\xbe\xc0mY\xd1\xf1\xf3\x94\xa9\xe0\xef\x11\xfeV\xdf\xda7\x0f-'	nan	nan	MORTGAGE	50000		Not Verified	010xx	MA	3418	23927
b'1\xe3uD\xe4\x13\x1f\x80\x1d\xb1\xa5\x14x\xac4\xe3\xcdX\x84f}\r\xd5Z\xf1Z\x05\xf4R\x82Y\xa2'	Care Giver	nan	OWN	46800		Verified	010xx	MA	48173	240865
b'bb\xf1Y\x00\xaf\x96\x85\x16\xaf\xb4z\x1c\xa0De\x8e\xd1s\xcb\x9b\xd3\xfd\x88\x00`\x99\xbb\xe0j\xc18'	nan	nan	OWN	65000		Verified	010xx	MA	2587	46567
b'\xaazF\x84\x93\xa0w\xb5G\xed0\xd0\xd4\xd4\xc0\x08\x9fh\xf5\xcc-jl<\xfd\x06\xf4\xaf8e\x86\xea'	nan	nan	OWN	49200		Source Verified	010xx	MA	738	5903
b'\x05u\x1c\x99\xaa\x04\xeb\x9f\x05-\xa7\x1c\x96\xa7Hc\xb2\xf0\xe5\xd6t\x01\x17\xdc\xa0\xab\x88\xc8\xbc[b5'	nan	nan	RENT	30000		Verified	010xx	MA	1844	14748
b'\x84\x1d@EZ\xca\xba\xe1\xee\x96\x01\x00\xad\xc9\xe0\x99\xb8\xe6b\xf8\x1b\x875\x91\x0f\x95\xb3\xd2 \x10t\x8c'	nan	nan	RENT	30000		Verified	010xx	MA	3721	29771
b'&\xb2\xe8\xe4\xf7\x891G\xac\x94i\xb4\xc1\xdb\xd2\xd9\xba\xd8^&/SDu?\xdb\xa5}\xae*c\\'	nan	nan	RENT	28128		Not Verified	010xx	MA	547	8211
b'\x10/\xca#\xb9\x03\xef\x1d\x82j\x167\xf3\xac\xea\x8c\xf3x\xe8\xbd\xa6X\xd8j\xe9Gyy\x00\xa8[\xf9'	nan	nan	OWN	30000	118000	Verified	010xx	MA	8	30
b'?\xf2Nh\x1a?\xb1\xe7\x80\xd7+q\x8d\xef\x9e*\xc6\xfd\x8c\x97g.Z\x9fQ\|\x1c\xb0\xd9\xb5m\t'	nan	nan	MORTGAGE	185000		Not Verified	010xx	MA	7930	150674


CREATE TABLE customer (
  "customer_id" VARCHAR,
  "emp_title" VARCHAR,
  "emp_length" VARCHAR,
  "home_ownership" VARCHAR,
  "annual_inc" DOUBLE,
  "annual_inc_joint" DOUBLE,
  "verification_status" VARCHAR,
  "zip_code" VARCHAR,
  "addr_state" VARCHAR,
  "avg_cur_bal" DOUBLE,
  "tot_cur_bal" DOUBLE
);