USA Philadelphia's Food Bitescourt 11K - (2022)
USA Philadelphia's Food Bitescourt 11K - (2022)
In 2022, Bitescourt, a food ordering app, experienced a significant data breach, resulting in the exposure of sensitive information related to 11,000 users. The compromised database, presented in SQL format, includes detailed transactional data and user information.Key Data Fields Compromised
The exposed database contains a variety of sensitive data fields. Below are the main fields that were compromised:Table 1: braintree_transaction
- id: Unique identifier for the transaction.
- transaction_id: Unique identifier for the Braintree transaction.
- transaction_type: Type of transaction (e.g., sale).
- amount: Transaction amount.
- status: Status of the transaction (e.g., settling).
- created_at: Timestamp of when the transaction was created.
- updated_at: Timestamp of the last update to the transaction.
- card_type: Type of credit card used.
- card_last_four: Last four digits of the card number.
- email: User's email address.
- payer_id: Unique identifier for the payer.
- first_name: User's first name.
- last_name: User's last name.
- verification_status: Status of the verification.
- currency: Currency used in the transaction.
- id: Unique identifier for the user.
- first_name: First name of the user.
- last_name: Last name of the user.
- email: User's email address.
- phone_number: User's phone number.
- password_hash: Hashed password.
- created_at: Timestamp of account creation.
- updated_at: Timestamp of last account update.
Sample Data
INSERT INTO `braintree_transaction` VALUES (1,18076,'n6yjce2p','sale','24.95','submitted_for_settlement','2018-09-17 19:34:24','2018-09-17 19:34:24',NULL,'378282','0005','American Express','08/2020',NULL,'US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,18077,'2dgvw6f4','sale','21.59','settling','2018-09-17 19:42:15','2018-09-17 19:42:19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'jhonnatan@bitescourt.com','PAYID-LOQAHGI0K1890152U0608159','4WC97534G0711501U','4MPFBSHMPZ35A','Jhonnatan','Linares','VERIFIED','ELIGIBLE','4WC97534G0711501U','0.93','USD'),(3,18078,'1yeh1vv8','sale','29.52','submitted_for_settlement','2018-09-17 20:21:28','2018-09-17 20:21:28',NULL,'601111','1117','Discover','08/2020',NULL,'US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,18079,'ae9anhr6','sale','16.49','settling','2018-09-17 20:24:13','2018-09-17 20:24:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'jhonnatan@bitescourt.com','PAYID-LOQA23Q39X06541XG135512U','2VP38330CM679482T','4MPFBSHMPZ35A','Jhonnatan','Linares','VERIFIED','ELIGIBLE','2VP38330CM679482T','0.78','USD'),(5,18153,'9fc1gkbb','sale','0.65','settling','2018-10-01 19:23:58','2018-10-01 19:24:01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'jhonnatan.linares@gmail.com','PAYID-LOZHIUA4YH41773EF689702Y','57U7181209220894R','G97P7VVPMT9RY','Jhonnatan','Jhonnatan Linares Lee','VERIFIED','INELIGIBLE','57U7181209220894R','0.32','USD'),(6,18154,'5erzpcf2','sale','0.65','submitted_for_settlement','2018-10-01 19:30:13','2018-10-01 19:30:13',NULL,'473702','7640','Visa','08/2020',NULL,'US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,18155,'bhqyagpv','sale','0.65','settling','2018-10-01 20:19:33','2018-10-01 20:19:36',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'jhonnatan.linares@gmail.com','PAYID-LOZICVQ4KS84362640456218','62D65870F5468574N','G97P7VVPMT9RY','Jhonnatan','Jhonnatan Linares Lee','VERIFIED','INELIGIBLE','62D65870F5468574N','0.32','USD'),(8,18156,'mtmfyvnw','sale','0.65','submitted_for_settlement','2018-10-01 20:23:32','2018-10-01 20:23:33',NULL,'473702','7640','Visa','08/2020',NULL,'US',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,18157,'m5a0jm0n','sale','10.69','settling','2018-10-01 22:07:39','2018-10-01 22:07:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rna41492@gmail.com','PAYID-LOZJVLI0SL62795H1022602L','886763261T3517244','VP8ZV38PWEM22','Ricardo','Nunez','VERIFIED','INELIGIBLE','886763261T3517244','0.61','USD'),(10,18167,'4x2fkcpp','sale','19.97','settling','2018-10-03 00:33:45','2018-10-03 00:33:49',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'normandavid11@comcast.net','PAYID-LO2A42Q4GH1719069794211M','66716061HT2308548','G9AR9UW9SN69S','Norman','David','VERIFIED','INELIGIBLE','66716061HT2308548','0.88','USD'),(11,18178,'5tvxx7hg','sale','29.25','submitted_for_settlement','2018-10-04 22:15:54','2018-10-04
Jr.',NULL,'radtekgrad09@gmail.com','2676228054','4649bcaf33e8ff8c66db4bd7b872dd99',NULL,0,NULL,0,'2017-05-15 13:19:06',0,NULL,1,'cmFkdGVrZ3JhZDA5QGdtYWlsLmNvbQ==',4,1,NULL,'TYRONE4896',0,1,1,1),(4897,'Chillin','Pizzeria & Restaurant',NULL,'chillinpizzeria@bitescourt.com','2153651300','c46c332eff5c46159db7922fdc886d4b',NULL,0,NULL,0,'2017-05-15 17:56:48',0,NULL,1,NULL,7,1,NULL,NULL,0,1,1,1),(4898,'gilberto','vazquez',NULL,'gilnuel0607@gmail.com','2673486342','df93c3e13692c61d3383cfce3f242651',NULL,0,NULL,0,'2017-05-15 19:08:57',1,NULL,1,'Z2lsbnVlbDA2MDdAZ21haWwuY29t',4,1,NULL,'GILBER4898',0,1,1,1),(4899,'Makueda','Cayona',NULL,'mcayona33@gmail.com','3475997341','4b327eb166ab19507b08599a8deb5c65',NULL,0,NULL,0,'2017-05-15 20:26:21',0,NULL,1,'bWNheW9uYTMzQGdtYWlsLmNvbQ==',4,1,NULL,'MAKUED4899',0,1,1,1),(4900,'tyanna','connor',NULL,'tyannaconnor800@gmail.com','7176550277','40aa13c3343306ded0ab50d4aa3c2adf',NULL,0,NULL,0,'2017-05-16 00:59:55',0,NULL,1,'dHlhbm5hY29ubm9yODAwQGdtYWlsLmNvbQ==',4,1,NULL,'TYANNA4900',0,1,1,1),(4901,'marcus ','brock','kysier','kysier2442@gmail.com','2672969117','ae4dc84b632c8e0bcd23bfa0e8637bfb',NULL,0,NULL,0,'2017-05-16 19:44:05',0,NULL,1,'a3lzaWVyMjQ0MkBnbWFpbC5jb20=',4,1,NULL,'MARCUS4901',0,1,1,1),(4902,'Malia','Glover',NULL,'malia.glover@aol.com','2152391792','aa935db987dc85810cb6fc37f52ad435',NULL,0,NULL,0,'2017-05-16 21:42:54',0,NULL,1,'bWFsaWEuZ2xvdmVyQGFvbC5jb20=',4,1,NULL,'MALIAG4902',0,1,1,1),(4903,'Alex','Salvat',NULL,'alexsalvatsr@gmail.com','2679754129','56033be1bc28d4472ea54253656ebf5c',NULL,0,NULL,0,'2017-05-17 10:50:24',1,NULL,1,'YWxleHNhbHZhdHNyQGdtYWlsLmNvbQ==',4,1,NULL,'ALEXSA4903',0,1,1,1),(4904,'Silly ','Johnny',NULL,'sillyjohnny@gmail.com','2533804490','bbe1eff0f88a4a2fef98f7432bd3e207',NULL,0,NULL,0,'2017-05-17 16:18:26',0,NULL,1,'c2lsbHlqb2hubnlAZ21haWwuY29t',4,1,NULL,'SILLYJ4904',0,1,1,1),(4905,'amatullah','dorsett',NULL,'amatullahdorsett@ymail.com','2674419053','496c88235193fbd6bff7f729ec93051e',NULL,0,NULL,0,'2017-05-17 19:19:04',0,NULL,1,'YW1hdHVsbGFoZG9yc2V0dEB5bWFpbC5jb20=',4,1,NULL,'AMATUL4905',0,1,1,1),(4906,'nini','claudio','nini6996','niniclaudio@yahoo.com','2672350337','2082cac92d890296e2c4f66aa0a1d312',NULL,0,NULL,0,'2017-05-17 19:34:41',1,NULL,1,'bmluaWNsYXVkaW9AeWFob28uY29t',4,1,NULL,'NINICL4906',0,1,1,1),(4907,'Tanisha','Graham ',NULL,'tanishapickett1983@gmail.com','2673335095','0020203e48412ee555b77151a83bc074',NULL,0,NULL,0,'2017-05-18 18:22:49',1,NULL,1,'dGFuaXNoYXBpY2tldHQxOTgzQGdtYWlsLmNvbQ==',4,1,NULL,'TANISH4907',0,1,1,1),(4908,'James','evans',NULL,'samesense@gmail.com','2152790262','c7453ded5e18740d7ecc936961571e50',NULL,0,NULL,0,'2017-05-18 19:27:02',0,NULL,1,'c2FtZXNlbnNlQGdtYWlsLmNvbQ==',4,1,NULL,'JAMESE4908',0,1,1,1),(4909,'kamri','grose',NULL,'kamri.grose@yahoo.com','9732214089','eede2cddcbdbb5ab02b02a645cbfb530',NULL,0,NULL,0,'2017-05-18