Credit Card Fraud
Consists of 20 important and diverse metrics and 8000 records of transactions
@kaggle.teamincribo_credit_card_fraud
Credit Card Fraud
@kaggle.teamincribo_credit_card_fraud.credit_card_fraud
- 1.85 MB
- 8000 rows
- 20 columns
transaction_date_and_timeTransaction Date And Time | transaction_amountTransaction Amount | cardholder_nameCardholder Name | card_number_hashed_or_encryptedCard Number (Hashed Or Encrypted) | merchant_nameMerchant Name | merchant_category_code_mccMerchant Category Code (MCC) | transaction_location_city_or_zip_codeTransaction Location (City Or ZIP Code) | transaction_currencyTransaction Currency | card_typeCard Type | card_expiration_dateCard Expiration Date | cvv_code_hashed_or_encryptedCVV Code (Hashed Or Encrypted) | transaction_response_codeTransaction Response Code | transaction_idTransaction ID | fraud_flag_or_labelFraud Flag Or Label | previous_transactionsPrevious Transactions | transaction_sourceTransaction Source | ip_addressIP Address | device_informationDevice Information | user_account_informationUser Account Information | transaction_notesTransaction Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sat Sep 24 2022 13:54:27 GMT+0000 (Coordinated Universal Time) | 285.88 | Shray Soman | daca51bffe0fc4eaaa7c430917f94b75fd8937124922549632bcd15afd89dc00 | Rajagopalan, Ghose and Kant | 3590 | Khammam | INR | MasterCard | 04/29 | 01299ac65733b5a3d774265fbfe8396b8611e5e3321855dbc541cd301e71fe5e | 5 | b7f69cbc-a03d-41f8-adca-75920b0242c3 | 1 | nan | Online | 18.106.240.6 | Tablet | nan | Consequatur corporis minima ad vero deserunt nostrum. Laborum laudantium voluptatum porro dolorum. Itaque ut quibusdam eius. Impedit at itaque assumenda ullam eaque. |
| Fri Jul 24 2020 11:20:13 GMT+0000 (Coordinated Universal Time) | 1777.32 | Lakshit Bakshi | d5366dd9be3a0266c0252baceaa6332210ed4dbd0ef252a4e2f45707c290f4b4 | Sule PLC | 7277 | Vasai-Virar | EUR | American Express | 03/26 | ad8fa913d25b3970c6efa8ca504da8ba670ce2a9cf012d399b71924deb483d3f | 12 | ad53cc8e-8412-422e-8cad-4176daac8387 | 1 | nan | Online | 212.48.185.128 | Mobile | jloyal | Dolore repellendus odio deleniti. Eaque quibusdam nobis similique aperiam perferendis. Illo numquam earum at quidem rem est. Quis explicabo quasi quod sit accusamus. |
| Sat Mar 18 2023 01:05:36 GMT+0000 (Coordinated Universal Time) | 3939.01 | Riya Bobal | 4737a6384aa1c3c31f7768b86633d6a8401dd6ab4a8ff1f3c876a82830a98e57 | Badal PLC | 9297 | Nangloi Jat | USD | Visa | 11/29 | eb3be230bbd2844b1f5d8f2e4fab9ffba8ab22cfeeb69c4c1361993ba4f377b9 | 5 | f09cecd6-0d74-4551-8089-a31d64e6b9c5 | 1 | 3 or more | In-Person | 17.190.112.46 | Mobile | nan | Unde beatae perspiciatis sapiente. Voluptates magnam debitis facere officiis assumenda. Dolorum nisi consequatur delectus sint dolor dolorum. Quae ullam nihil ullam. |
| Thu Jan 07 2021 21:53:04 GMT+0000 (Coordinated Universal Time) | 376.44 | Mohanlal Balakrishnan | 4721806eed8f2663bb597ff13e79a294de318358fbb54bcd4d282ef617d1fc67 | Konda-Sodhi | 5686 | Ramagundam | USD | Visa | 09/25 | 891d46993a36d78392247c642138cede01d9841daab1d945709755b5194597c4 | 5 | b208ae0b-4c4f-428f-b6b9-5360b288b947 | 2 | In-Person | 153.136.24.104 | Tablet | nan | Cupiditate repellendus necessitatibus quo occaecati. Maiores cupiditate doloribus. Eos voluptatum accusantium repellat. Fuga iste dolorum possimus cupiditate. Ex quaerat unde quo velit alias animi. | |
| Thu Dec 16 2021 06:22:24 GMT+0000 (Coordinated Universal Time) | 1687.33 | Mannat Rout | 9deacc3a9efd6e382826d400620aca5f23ed94327578e5cee370ce1278a99919 | Dua Ltd | 2940 | Adoni | INR | MasterCard | 03/31 | 48a1a756f2d83f1dc57bbf14052b70a6f40d0fceed6662812e34903a9fe90924 | 5 | 6b4e4e43-5b73-4906-9973-299a1b2a5e71 | 1 | 2 | Online | 196.153.28.131 | Desktop | nan | Molestias assumenda consectetur itaque veritatis non vero. Sequi ipsa aliquam fugiat dolorem. Occaecati cum qui debitis nemo qui. |
| Tue Jan 14 2020 21:03:12 GMT+0000 (Coordinated Universal Time) | 3341.97 | Lagan Dutt | 15bbdcdc198266c9c17633ffb7bf59ef1d48ad76db226773291e5da19d47383d | Ramesh Inc | 9661 | Farrukhabad | USD | American Express | 05/27 | 33512007840ced1bb0aab68f47cb5f702abd494a15f26bcbe26a1e47af03d841 | 5 | 92a7490d-89cc-43db-81a9-d152895813aa | 1 | 2 | In-Person | 112.90.206.208 | Mobile | hrishita37 | Voluptatem voluptatem officiis alias eius beatae. Cumque incidunt non laboriosam sunt libero in. Repellat sunt qui optio animi eos. Laboriosam neque aperiam. Neque quisquam quos et debitis quo. |
| Sun Jul 25 2021 18:24:30 GMT+0000 (Coordinated Universal Time) | 1212.14 | Neelofar Sangha | 661297314dafe0945aca76d1463f27d404f4e535323217444777ed74d0270ef6 | Sachar, Gera and Deol | 8036 | Agartala | USD | MasterCard | 02/30 | 367461e6dd07bdb57342cb64b2a8d8e0fa13c53842a95ec20a90d35bdd6eb77f | 6eab203f-abdc-442d-91c9-e4b4e64d2719 | 1 | In-Person | 218.154.139.160 | Desktop | nan | Nemo molestiae provident necessitatibus. Sapiente natus dignissimos similique id. Commodi similique sequi labore deleniti. | ||
| Sun May 08 2022 10:49:06 GMT+0000 (Coordinated Universal Time) | 1117.52 | Samiha Ravi | b4f56d425e0ce79c2c27153c2daf9de1a73b1d3be5b6e78d075003f76e4ce89f | Bhasin, Jain and Chada | 5678 | Dehri | EUR | Visa | 09/26 | 084917af148384c1e8396addcec2fca2a9f2c3918cad9676e12cdaad7dc7dfb2 | 12 | 5849755c-2f70-4f9c-95cc-0092d79d43eb | 2 | Online | 150.7.29.164 | Mobile | aarna85 | Qui quo velit officia tenetur nemo. Quisquam harum ullam qui laudantium labore. Quidem consequatur harum praesentium illo doloribus officia. | |
| Fri Aug 19 2022 23:40:26 GMT+0000 (Coordinated Universal Time) | 388.16 | Vihaan Walla | bd9821d2d86a049aad49919da593e15344bc7604442d9e4a478500b525687ed2 | Sha Inc | 5772 | Gangtok | EUR | Visa | 12/25 | 6165d33e490f91dbf808b194904d4f07c550d5e3a19c9e776e0c895136ec9fa2 | 12 | 7f971cb1-6bd3-48f2-8fa5-2bef220ab4a4 | 1 | In-Person | 219.61.43.198 | Desktop | fatehgupta | Distinctio ex expedita perspiciatis dicta dolorum. Blanditiis laboriosam eligendi corrupti. Dolores asperiores reprehenderit corporis necessitatibus magni dicta. | |
| Sat Sep 10 2022 05:59:18 GMT+0000 (Coordinated Universal Time) | 4514.53 | Ivan Loyal | 8d7967ba4a7d372708eca312d518026dd2d83d42e5f0be0e60ea4d033ab62236 | Sant, Chawla and Wali | 8521 | Aizawl | USD | Visa | 08/29 | e6f095e985e6762f1538b47ff1abda58dbe8ce088b16d8a5744fc179e9a2fc16 | df575129-3416-4c59-b282-d57267515ce1 | 1 | 3 or more | In-Person | 39.33.247.78 | Tablet | ydey | Architecto natus neque fuga. Voluptate dolor illo laboriosam quo harum. Id error ex iusto dolores hic fuga autem. Adipisci ea quo. Aspernatur recusandae mollitia ratione doloremque inventore. |
CREATE TABLE credit_card_fraud (
"transaction_date_and_time" TIMESTAMP,
"transaction_amount" DOUBLE,
"cardholder_name" VARCHAR,
"card_number_hashed_or_encrypted" VARCHAR,
"merchant_name" VARCHAR,
"merchant_category_code_mcc" BIGINT,
"transaction_location_city_or_zip_code" VARCHAR,
"transaction_currency" VARCHAR,
"card_type" VARCHAR,
"card_expiration_date" VARCHAR,
"cvv_code_hashed_or_encrypted" VARCHAR,
"transaction_response_code" BIGINT,
"transaction_id" VARCHAR,
"fraud_flag_or_label" BIGINT,
"previous_transactions" VARCHAR,
"transaction_source" VARCHAR,
"ip_address" VARCHAR,
"device_information" VARCHAR,
"user_account_information" VARCHAR,
"transaction_notes" VARCHAR
);