Credit Card Transactions Dataset

Using Transactional Data for Financial Analysis and Fraud Detection

@kaggle.priyamchoksi_credit_card_transactions_dataset

Table List

1 table(115.89 MB)

Credit Card Transactions

@kaggle.priyamchoksi_credit_card_transactions_dataset.credit_card_transactions

115.89 MB
1296675 rows
24 columns

unnamed_0 Unnamed: 0	trans_date_trans_time Trans Date Trans Time	cc_num Cc Num	merchant Merchant	category Category	amt Amt	first First	last Last	gender Gender	street Street	city City	state State	zip Zip	lat Lat	long Long	city_pop City Pop	job Job	dob Dob	trans_num Trans Num	unix_time Unix Time	merch_lat Merch Lat	merch_long Merch Long	merch_zipcode Merch Zipcode
	Tue Jan 01 2019 00:00:18 GMT+0000 (Coordinated Universal Time)	2703186189652095	fraud_Rippin, Kub and Mann	misc_net	4.97	Jennifer	Banks	F	561 Perry Cove	Moravian Falls	NC	28654	36.0788	-81.1781	3495	Psychologist, counselling	Wed Mar 09 1988 00:00:00 GMT+0000 (Coordinated Universal Time)	0b242abb623afc578575680df30655b9	1325376018	36.011293	-82.048315	28705
1	Tue Jan 01 2019 00:00:44 GMT+0000 (Coordinated Universal Time)	630423337322	fraud_Heller, Gutmann and Zieme	grocery_pos	107.23	Stephanie	Gill	F	43039 Riley Greens Suite 393	Orient	WA	99160	48.8878	-118.2105	149	Special educational needs teacher	Wed Jun 21 1978 00:00:00 GMT+0000 (Coordinated Universal Time)	1f76529f8574734946361c461b024d99	1325376044	49.159047	-118.186462
2	Tue Jan 01 2019 00:00:51 GMT+0000 (Coordinated Universal Time)	38859492057661	fraud_Lind-Buckridge	entertainment	220.11	Edward	Sanchez	M	594 White Dale Suite 530	Malad City	ID	83252	42.1808	-112.262	4154	Nature conservation officer	Fri Jan 19 1962 00:00:00 GMT+0000 (Coordinated Universal Time)	a1a22d70485983eac12b5b88dad1cf95	1325376051	43.150704	-112.154481	83236
3	Tue Jan 01 2019 00:01:16 GMT+0000 (Coordinated Universal Time)	3534093764340240	fraud_Kutch, Hermiston and Farrell	gas_transport	45	Jeremy	White	M	9443 Cynthia Court Apt. 038	Boulder	MT	59632	46.2306	-112.1138	1939	Patent attorney	Thu Jan 12 1967 00:00:00 GMT+0000 (Coordinated Universal Time)	6b849c168bdad6f867558c3793159a81	1325376076	47.034331	-112.561071
4	Tue Jan 01 2019 00:03:06 GMT+0000 (Coordinated Universal Time)	375534208663984	fraud_Keeling-Crist	misc_pos	41.96	Tyler	Garcia	M	408 Bradley Rest	Doe Hill	VA	24433	38.4207	-79.4629	99	Dance movement psychotherapist	Fri Mar 28 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	a41d7549acf90789359a9aa5346dcb46	1325376186	38.674999	-78.632459	22844
5	Tue Jan 01 2019 00:04:08 GMT+0000 (Coordinated Universal Time)	4767265376804500	fraud_Stroman, Hudson and Erdman	gas_transport	94.63	Jennifer	Conner	F	4655 David Island	Dublin	PA	18917	40.375	-75.2045	2158	Transport planner	Mon Jun 19 1961 00:00:00 GMT+0000 (Coordinated Universal Time)	189a841a0a8ba03058526bcfe566aab5	1325376248	40.653382	-76.15266700000001	17972
6	Tue Jan 01 2019 00:04:42 GMT+0000 (Coordinated Universal Time)	30074693890476	fraud_Rowe-Vandervort	grocery_net	44.54	Kelsey	Richards	F	889 Sarah Station Suite 624	Holcomb	KS	67851	37.9931	-100.9893	2691	Arboriculturist	Mon Aug 16 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	83ec1cc84142af6e2acf10c44949e720	1325376282	37.162705	-100.15337
7	Tue Jan 01 2019 00:05:08 GMT+0000 (Coordinated Universal Time)	6011360759745864	fraud_Corwin-Collins	gas_transport	71.65	Steven	Williams	M	231 Flores Pass Suite 720	Edinburg	VA	22824	38.8432	-78.6003	6018	Designer, multimedia	Thu Aug 21 1947 00:00:00 GMT+0000 (Coordinated Universal Time)	6d294ed2cc447d2c71c7171a3d54967c	1325376308	38.948089	-78.540296	22644
8	Tue Jan 01 2019 00:05:18 GMT+0000 (Coordinated Universal Time)	4922710831011201	fraud_Herzog Ltd	misc_pos	4.27	Heather	Chase	F	6888 Hicks Stream Suite 954	Manor	PA	15665	40.3359	-79.6607	1472	Public affairs consultant	Fri Mar 07 1941 00:00:00 GMT+0000 (Coordinated Universal Time)	fc28024ce480f8ef21a32d64c93a29f5	1325376318	40.351813	-79.958146	15236
9	Tue Jan 01 2019 00:06:01 GMT+0000 (Coordinated Universal Time)	2720830304681674	fraud_Schoen, Kuphal and Nitzsche	grocery_pos	198.39	Melissa	Aguilar	F	21326 Taylor Squares Suite 708	Clarksville	TN	37040	36.522	-87.34899999999999	151785	Pathologist	Thu Mar 28 1974 00:00:00 GMT+0000 (Coordinated Universal Time)	3b9014ea8fb80bd65de0b1463b00b00e	1325376361	37.179198	-87.485381	42442


CREATE TABLE credit_card_transactions (
  "unnamed_0" BIGINT,
  "trans_date_trans_time" TIMESTAMP,
  "cc_num" BIGINT,
  "merchant" VARCHAR,
  "category" VARCHAR,
  "amt" DOUBLE,
  "first" VARCHAR,
  "last" VARCHAR,
  "gender" VARCHAR,
  "street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "lat" DOUBLE,
  "long" DOUBLE,
  "city_pop" BIGINT,
  "job" VARCHAR,
  "dob" TIMESTAMP,
  "trans_num" VARCHAR,
  "unix_time" BIGINT,
  "merch_lat" DOUBLE,
  "merch_long" DOUBLE,
  "is_fraud" BIGINT,
  "merch_zipcode" DOUBLE
);