Credit Card Transactions Fraud Detection Dataset

Simulated Credit Card Transactions generated using Sparkov

@kaggle.kartik2112_fraud_detection

Table List

2 tables(160.97 MB)

Fraudtest

@kaggle.kartik2112_fraud_detection.fraudtest

48.3 MB
555719 rows
23 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
	Sun Jun 21 2020 12:14:25 GMT+0000 (Coordinated Universal Time)	2291163933867244	fraud_Kirlin and Sons	personal_care	2.86	Jeff	Elliott	M	351 Darlene Green	Columbia	SC	29209	33.9659	-80.9355	333497	Mechanical engineer	Tue Mar 19 1968 00:00:00 GMT+0000 (Coordinated Universal Time)	2da90c7d74bd46a0caf3777415b3ebd3	1371816865	33.986391	-81.200714
1	Sun Jun 21 2020 12:14:33 GMT+0000 (Coordinated Universal Time)	3573030041201292	fraud_Sporer-Keebler	personal_care	29.84	Joanne	Williams	F	3638 Marsh Union	Altonah	UT	84002	40.3207	-110.436	302	Sales professional, IT	Wed Jan 17 1990 00:00:00 GMT+0000 (Coordinated Universal Time)	324cc204407e99f51b0d6ca0055005e7	1371816873	39.450498	-109.960431
2	Sun Jun 21 2020 12:14:53 GMT+0000 (Coordinated Universal Time)	3598215285024754	fraud_Swaniawski, Nitzsche and Welch	health_fitness	41.28	Ashley	Lopez	F	9333 Valentine Point	Bellmore	NY	11710	40.6729	-73.5365	34496	Librarian, public	Wed Oct 21 1970 00:00:00 GMT+0000 (Coordinated Universal Time)	c81755dbbbea9d5c77f094348a7579be	1371816893	40.49581	-74.196111
3	Sun Jun 21 2020 12:15:15 GMT+0000 (Coordinated Universal Time)	3591919803438423	fraud_Haley Group	misc_pos	60.05	Brian	Williams	M	32941 Krystal Mill Apt. 552	Titusville	FL	32780	28.5697	-80.8191	54767	Set designer	Sat Jul 25 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	2159175b9efe66dc301f149d3d5abf8c	1371816915	28.812398	-80.883061
4	Sun Jun 21 2020 12:15:17 GMT+0000 (Coordinated Universal Time)	3526826139003047	fraud_Johnston-Casper	travel	3.19	Nathan	Massey	M	5783 Evan Roads Apt. 465	Falmouth	MI	49632	44.2529	-85.01700000000001	1126	Furniture designer	Wed Jul 06 1955 00:00:00 GMT+0000 (Coordinated Universal Time)	57ff021bd3f328f8738bb535c302a31b	1371816917	44.959148	-85.884734
5	Sun Jun 21 2020 12:15:37 GMT+0000 (Coordinated Universal Time)	30407675418785	fraud_Daugherty LLC	kids_pets	19.55	Danielle	Evans	F	76752 David Lodge Apt. 064	Breesport	NY	14816	42.1939	-76.7361	520	Psychotherapist	Sun Oct 13 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	798db04aaceb4febd084f1a7c404da93	1371816937	41.747157	-77.584197
6	Sun Jun 21 2020 12:15:44 GMT+0000 (Coordinated Universal Time)	213180742685905	fraud_Romaguera Ltd	health_fitness	133.93	Kayla	Sutton	F	010 Weaver Land	Carlotta	CA	95528	40.507	-123.9743	1139	Therapist, occupational	Mon Jan 15 1951 00:00:00 GMT+0000 (Coordinated Universal Time)	17003d7ce534440eadb10c4750e020e5	1371816944	41.499458	-124.888729
7	Sun Jun 21 2020 12:15:50 GMT+0000 (Coordinated Universal Time)	3589289942931264	fraud_Reichel LLC	personal_care	10.37	Paula	Estrada	F	350 Stacy Glens	Spencer	SD	57374	43.7557	-97.5936	343	Development worker, international aid	Sun Mar 05 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	8be473af4f05fc6146ea55ace73e7ca2	1371816950	44.495498	-97.728453
8	Sun Jun 21 2020 12:16:10 GMT+0000 (Coordinated Universal Time)	3596357274378601	fraud_Goyette, Howell and Collier	shopping_pos	4.37	David	Everett	M	4138 David Fall	Morrisdale	PA	16858	41.0001	-78.2357	3688	Advice worker	Sun May 27 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	71a1da150d1ce510193d7622e08e784e	1371816970	41.546067	-78.120238
9	Sun Jun 21 2020 12:16:11 GMT+0000 (Coordinated Universal Time)	3546897637165774	fraud_Kilback Group	food_dining	66.54	Kayla	Obrien	F	7921 Robert Port Suite 343	Prairie Hill	TX	76678	31.6591	-96.8094	263	Barrister	Wed May 30 1956 00:00:00 GMT+0000 (Coordinated Universal Time)	a7915132c7c4240996ba03a47f81e3bd	1371816971	31.782919	-96.366185


CREATE TABLE fraudtest (
  "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
);