![[Image: bigbasket.png]](https://cdn.breachforums.st/logo/bigbasket.png "[Image: bigbasket.png]"){kind=logo}
In October 2020, the Indian grocery platform bigbasket suffered a data breach that exposed over 20 million customer records. The data was originally sold before being leaked publicly in April the following year and included email, IP and physical addresses, names, phones numbers, dates of birth passwords stored as Django(SHA-1) hashes.
Compromised data: Dates of birth, Email addresses, IP addresses, Names, Passwords, Phone numbers, Physical addresses
Sample:
DROP TABLE IF EXISTS `member_member`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `member_member` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created_on` datetime NOT NULL,
`updated_on` datetime NOT NULL,
`created_by_id` int(11) DEFAULT NULL,
`updated_by_id` int(11) DEFAULT NULL,
`email` varchar(75) NOT NULL,
`password` varchar(128) NOT NULL,
`first_name` varchar(30) NOT NULL,
`last_name` varchar(30) NOT NULL,
`dob` date DEFAULT NULL,
`photo` varchar(100) DEFAULT NULL,
`is_staff` tinyint(1) NOT NULL,
`is_active` tinyint(1) NOT NULL,
`is_superuser` tinyint(1) NOT NULL,
`last_login` datetime NOT NULL,
`registered_ip` varchar(30) DEFAULT NULL,
`last_logged_ip` varchar(30) NOT NULL,
`date_joined` datetime DEFAULT NULL,
`hub_id` int(11) DEFAULT NULL,
`address2` varchar(250) DEFAULT NULL,
`zipcode` int(11) NOT NULL,
`location` point NOT NULL,
`mobile_no` varchar(30) NOT NULL,
`phone_no` varchar(30) DEFAULT NULL,
`activation_key` varchar(40) NOT NULL,
`oac_code` varchar(40) DEFAULT NULL,
`news_status` tinyint(1) DEFAULT NULL,
`about_us` varchar(50) DEFAULT NULL,
`address1` varchar(250) NOT NULL,
`city` varchar(25) DEFAULT NULL,
`is_mapped` tinyint(1) NOT NULL,
`is_validated` tinyint(1) NOT NULL,
`area` varchar(250) NOT NULL,
`is_cashback_eligible` tinyint(1) NOT NULL,
`apin` int(11) NOT NULL,
`pin` varchar(4) NOT NULL,
`validated_email` varchar(80) DEFAULT NULL,
`validated_mobile_no` varchar(20) DEFAULT NULL,
`validated_address` longtext,
`manual_override_hub` tinyint(1) NOT NULL,
`member_type_id` int(11) DEFAULT NULL,
`cookie_value` varchar(100) DEFAULT NULL,
`week_id` int(11) DEFAULT NULL,
`mapped_on` datetime DEFAULT NULL,
`residential_complex` varchar(100) DEFAULT NULL,
`mapped_by_id` int(11) DEFAULT NULL,
`landmark` varchar(100) DEFAULT NULL,
`city_id` int(11) NOT NULL DEFAULT '1',
`last_order_id` varchar(20) DEFAULT NULL,
`date_of_first_order` date DEFAULT NULL,
`date_of_last_order` date DEFAULT NULL,
`num_of_orders` int(11) DEFAULT NULL,
`first_order_id` varchar(20) DEFAULT NULL,
`maximum_order_delivered_value` decimal(11,2) DEFAULT NULL,
`total_order_orig_value` decimal(11,2) DEFAULT NULL,
`total_order_orig_num_items` int(11) DEFAULT NULL,
`total_order_delivered_num_items` int(11) DEFAULT NULL,
`total_order_invoice_value` decimal(11,2) DEFAULT NULL,
`total_order_delivered_value` decimal(11,2) DEFAULT NULL,
`maximum_order_invoice_value` decimal(11,2) DEFAULT NULL,
`total_order_delivered_num_qty` int(11) DEFAULT NULL,
`total_order_orig_num_qty` int(11) DEFAULT NULL,
`email_domain` varchar(30) DEFAULT NULL,
`credit` decimal(8,2) NOT NULL,
`total_store_brand_order_value` decimal(11,2) DEFAULT NULL,
`channel` varchar(50) DEFAULT NULL,
`total_fv_order_value` decimal(11,2) DEFAULT NULL,
`last_fv_order_date` date DEFAULT NULL,
`last_meat_order_date` date DEFAULT NULL,
`last_store_brand_order_date` date DEFAULT NULL,
`total_meat_order_value` decimal(11,2) DEFAULT NULL,
`source_id` int(11) DEFAULT '1',
`ref_id` varchar(36) DEFAULT NULL,
`email2` varchar(75) DEFAULT NULL,
`phone_no2` varchar(30) DEFAULT NULL,
`password_changed_time` datetime DEFAULT NULL,
`is_mobile_no_validated` tinyint(1) DEFAULT NULL,
`is_email_validated` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `member_member_source_email2_unique` (`source_id`,`email2`),
UNIQUE KEY `member_member_source_phone_no2_unique` (`source_id`,`phone_no2`),
KEY `member_member_4a21cf42` (`created_by_id`),
KEY `member_member_6f403c1` (`updated_by_id`),
KEY `member_member_4366aa6e` (`hub_id`),
KEY `member_member_540c73a` (`member_type_id`),
KEY `member_member_451608bc` (`week_id`),
KEY `member_member_314d5eaa` (`mapped_by_id`),
KEY `member_member_157feced` (`total_order_invoice_value`),
KEY `idx_member_email` (`email`),
KEY `idx_city_id_is_cashback_eligible` (`city_id`,`is_cashback_eligible`),
KEY `idx_city_id_id` (`city_id`,`id`),
KEY `idx_member_mobile` (`mobile_no`),
KEY `validated_mobile_no` (`validated_mobile_no`(10)),
KEY `validated_email_idx` (`validated_email`),
KEY `created_on` (`created_on`),
KEY `updated_on` (`updated_on`),
KEY `member_memb_source__c2d263_idx` (`source_id`,`ref_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21515837 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `member_member`
--
LOCK TABLES `member_member` WRITE;
/*!40000 ALTER TABLE `member_member` DISABLE KEYS */;
INSERT INTO `member_member` VALUES (1,'2011-11-02 17:54:40','2020-02-06 16:00:19',NULL,5508,'prshanth.py@gmail.com','sha1$b6f84$1b2b6a277dff95df33a5176fcc2faab419589d1f','Prashanth','Vijayendra','1985-02-25','',0,0,0,'2019-08-01 13:46:49','127.0.0.1','49.206.14.56','2011-11-02 17:54:40',11,'Shamanna Lane,Church road',560017,_binary '\0\0\0\0\0\0\0\?俓叙iS@#偏鳿?@','',NULL,'ALREADY_ACTIVATED1','83592',0,NULL,'No:33,Flat No:006,Arrcons Agna Indraprasta','bangalore',1,1,'Murugeshpalya',0,612,'612','prshanthpy@gmail.com','','no33flatno006arrconsagnaindraprastashamannalanechurchroad',0,1,'MzE0OTkyNTYxNQ==',45,NULL,'',NULL,'',1,'A-DX-XBO-95998165-14','2012-09-05','2019-10-14',51,'BBO-52794-030912',5323.43,80349.96,807,793,76213.00,79361.40,5323.00,2420,2435,'gmail.com',59.97,9506.56,NULL,5634.33,'2019-10-02',NULL,'2014-04-13',0.00,1,NULL,'prshanth.py@gmail.com',NULL,NULL,NULL,NULL),(2,'2011-11-03 16:46:46','2020-10-13 04:52:13',NULL,25130,'raj.emailme@gmail.com','sha1$fd16a$dc2f227972f8d478532be813aa0b5ae26ebfa9ca','raj','ganesh',NULL,'',0,1,0,'2020-10-12 15:08:21','127.0.0.1','172.16.65.141','2011-11-03 16:46:46',1579,'',560062,_binary '\0\0\0\0\0\0\0寻\逳\靋S@q01?@','9902858708','','178b420dbecaa21a5166efde5056ba96d2de3b21','72150',NULL,'','gf-09, c block ','bangalore',1,1,'Anjanapura Township',0,2579,'2579','rajemailme@gmail.com','9902858708','3whitefield',0,1,'MzE0OTkyNTYxMg==',45,'2020-05-04 21:45:32','real home stylish apartment',154710,'',1,'DX-WBO-146033467-121','2017-01-05','2020-10-12',30,'BBFO-20707627-040117',2080.20,26587.79,269,268,24011.75,26604.82,2029.00,400,402,'gmail.com',1.00,2665.00,NULL,7342.29,'2020-10-12','2020-10-12','2020-10-05',7338.84,1,NULL,'raj.emailme@gmail.com','9902858708',NULL,NULL,NULL),(6,'2011-11-11 13:15:38','2020-02-07 13:06:56',NULL,NULL,'abhinay@shopasulike.com','sha1$519be$6de3991422dc08769cfd433ff4e202ac5bf26a64','Abhinay','c',NULL,'',0,1,0,'2011-11-11 13:15:36','127.0.0.1','127.0.0.1','2011-11-11 13:15:36',2,'',560054,_binary '\0\0\0\0\0\0\05貂妶mS@鰐鼳\辄)@','','','a7a5b03cc9374b9f4d3029ff5e4bc07038623253','61638',NULL,'','whitefield','bangalore',0,1,'',0,6261,'6261','abhinay@shopasulike.com','','whitefieldbangalore560054',0,1,'MzE0OTkyNTYwOA==',46,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'shopasulike.com',0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,'abhinay@shopasulike.com',NULL,NULL,NULL,NULL),(8,'2011-11-21 21:15:19','2020-01-16 14:27:16',NULL,NULL,'nmpattar@gmail.com','sha1$37bc7$0804e4a162d4549885bff68142f6acb2d658991c','daffy','D','1941-01-01','',0,0,0,'2011-12-08 21:54:32','127.0.0.1','127.0.0.1','2011-11-21 21:15:18',3,'',560011,_binary '\0\0\0\0\0\0\0\?NT\0cS@蜁A盗\?@','','','','77306',NULL,'','77','bangalore',0,0,'bangalore',0,7234,'7234','nmpattar@gmail.com','','77',0,1,'MzE0OTkyNTYwNg==',48,NULL,'',NULL,'',1,'',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'gmail.com',0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL),(9,'2011-11-23 14:23:08','2020-02-07 13:06:57',NULL,NULL,'abhinaychoudhari@yahoo.com','sha1$48733$3b6b1bd0721cd00c4e989d4af5ed9f589ae4e6b7','Abhinay','Choudhari',NULL,'',0,1,0,'2016-09-30 15:37:40','127.0.0.1','124.30.189.42','2011-11-23 14:23:08',691,'WHITEFIELD MAIN ROAD',560066,_binary '\0\0\0\0\0\0\0??pS@?漒?\?@','','','','83492',NULL,'','A601, VASWANI PINNACLE','bangalore',1,1,'',0,989,'989','abhinaychoudhari@yahoo.com','','a601vaswanipinnaclewhitefieldmainroadbangalore560066',0,1,'MzE0OTkyNTYwNw==',48,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'yahoo.com',0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,'abhinaychoudhari@yahoo.com',NULL,NULL,NULL,NULL),(10,'2011-11-24 19:05:20','2020-05-20 10:10:22',NULL,25130,'vipul1000@gmail.com','sha1$7a218$fcb246eb84f5ddd04044c923d2773b1d2dd98ab4','Vipul','Parekh',NULL,'',0,1,0,'2020-05-20 10:10:22','127.0.0.1','172.16.67.225',NULL,1228,'',411004,_binary '\0\0\0\0\0\0\0鴂\?紆R@峔???@','9845030014','919845030014','','63106',NULL,NULL,'759/102','bangalore',0,1,'Deccan Gymkhana',0,116,'116','vipul1000@gmail.com','9845030014','c68diamonddistrictoldairportroadbangalore560008',0,1,'MzE0OTkyNTYwNA==',48,NULL,'',NULL,'Opp PYC Tennis Courts',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'gmail.com',0.00,NULL,NULL,NULL,NULL,NULL,N