Zoosk (2020)
Jan 12, 2020
Domain:
zoosk.com
Breach Count:
23,927,853
Region:
Global
Source:
File Size:
2.88 GB
Uncompressed File Size:
13.34 GB
File Count:
2
In February 2020, a massive data leak affected the online dating website Zoosk, exposing the personal information of millions of its users. The breach compromised a database containing over 239 million records, including names, email addresses, phone numbers, and sexual preferences.
The leaked data was uncovered by security researcher Bob Diachenko, who discovered it on an unprotected Amazon S3 bucket. The bucket was publicly accessible, allowing anyone with an internet connection to download the exposed information. Diachenko notified Zoosk of the breach, and the company secured the bucket and launched an investigation.
The Zoosk data leak raised concerns about the privacy and security of online dating platforms. It highlighted the need for companies to take appropriate measures to protect user data from unauthorized access and disclosure. Zoosk was criticized for failing to adequately secure its database and for the lack of transparency surrounding the breach. The company ultimately settled with the Federal Trade Commission (FTC) for $1.3 million over allegations that it violated consumer privacy laws.
Leaked Information:
Date Of Birth
Drinking habits
Education levels
Email
Ethnicities
Family structure
Gender
Address
Income levels
Full Name
Nicknames
Physical attributes
Political views
Relationship statuses
Religions
Sexual orientations
Smoking habits
We have loaded this breach into our database.
File List:
zoosk.sql
zooskpw.sql
File Content Sample:
CREATE TABLE `users` (
`id` bigint(20) unsigned NOT NULL,
`first_name` varchar(50) DEFAULT NULL,
`last_name` varchar(50) DEFAULT NULL,
`user_nicename` varchar(20) DEFAULT NULL,
`user_email` varchar(100) DEFAULT NULL,
`email_status` enum('new','validated','bounced','new-trusted','new-blocked') DEFAULT 'new',
`user_status` int(10) unsigned DEFAULT '2',
`widget_guid` varchar(32) NOT NULL DEFAULT '',
`sex` enum('male','female','unknown') NOT NULL DEFAULT 'unknown',
`interested_in` enum('men','women') DEFAULT NULL,
`relationship` int(10) unsigned DEFAULT '5',
`birthday` date DEFAULT NULL,
`location_id` int(11) DEFAULT NULL,
`latitude` int(11) DEFAULT NULL,
`longitude` int(11) DEFAULT NULL,
`zipcode` varchar(25) DEFAULT NULL,
`country` char(2) DEFAULT NULL,
`discoverable` tinyint(1) NOT NULL DEFAULT '1',
`user_activation_key` varchar(60) NOT NULL DEFAULT '',
`media_request_id` bigint(20) DEFAULT NULL,
`user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_login` datetime DEFAULT NULL,
`last_flirted` datetime DEFAULT NULL,
`last_available` datetime DEFAULT NULL,
`lastupdated` datetime DEFAULT NULL,
`migrated` tinyint(1) NOT NULL DEFAULT '1',
`height` tinyint(3) unsigned DEFAULT NULL,
`ethnicity` int(10) unsigned DEFAULT NULL,
`education` int(10) unsigned DEFAULT NULL,
`religion` int(10) unsigned DEFAULT NULL,
`politics` int(10) unsigned DEFAULT NULL,
`children` int(10) unsigned DEFAULT NULL,
`smoking` int(10) unsigned DEFAULT NULL,
`drinking` int(10) unsigned DEFAULT NULL,
`bodytype` int(10) unsigned DEFAULT NULL,
`income` int(10) unsigned DEFAULT NULL,
`pets` int(10) unsigned DEFAULT NULL,
`settings` bigint(20) NOT NULL DEFAULT '3111',
`currency_id` int(11) DEFAULT NULL,
`balance` int(11) NOT NULL DEFAULT '0',
`provider_map` int(11) NOT NULL DEFAULT '1',
`photo_source` int(11) DEFAULT '1',
`photo_count` int(11) NOT NULL DEFAULT '0',
`locale_id` int(11) DEFAULT NULL,
`timezone_id` int(11) DEFAULT NULL,
`source` varchar(255) DEFAULT NULL,
`is_remarketed_to` int(10) unsigned NOT NULL DEFAULT '0',
`dscore` int(11) DEFAULT NULL,
`rscore` int(11) DEFAULT NULL,
`sscore` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `location_id` (`location_id`),
KEY `lastupdated` (`lastupdated`),
KEY `user_email` (`user_email`),
KEY `widget_guid` (`widget_guid`),
KEY `source_country` (`source`,`country`),
KEY `search_g` (`country`,`discoverable`,`sex`,`interested_in`,`photo_count`,`birthday`,`latitude`,`longitude`,`last_login`,`last_flirted`),
KEY `search_o` (`country`,`discoverable`,`sex`,`interested_in`,`photo_count`,`birthday`,`last_available`),
KEY `search` (`country`,`discoverable`,`sex`,`interested_in`,`latitude`,`longitude`,`last_available`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,NULL,NULL,'Chief Pollster','[email protected]','new',4,'1ef762aa38c5cee920bca56aae275124','male','women',1,'1975-03-01',379,49280050,-123039550,'V5K 0A1','CA',0,'',91587322,'2007-08-04 05:08:15','2014-12-19 22:42:57','2014-12-16 14:54:19',NULL,'2014-12-19 23:48:32',0,183,7,6,4,NULL,1,1,2,2,NULL,NULL,9223372036786843648,0,72,8,1,0,1,NULL,'01234567890123456789012345678901234567890123456789012345678901234567890123456789',3,352,0,2),(2,NULL,NULL,'Sarshet','2','validated',4,'3fd0fb59a039dd2475a647f93891c059','male','women',1,'1979-01-12',1688,37798010,-122396965,'94111','US',0,'',48048298,'2007-08-04 18:21:52','2014-08-14 23:44:38','2014-11-15 12:29:51',NULL,'2016-10-25 16:40:55',0,180,7,5,2,NULL,1,1,2,3,NULL,NULL,9223372036854444032,0,508,8200,1,0,1,13,NULL,0,13,0,NULL),(3,NULL,NULL,'Alex23','3','new',4,'bbeee02c461ce5c81db5e0168774a602','male','women',1,'1978-09-21',1688,37798010,-122396965,'94111 ','US',0,'',18930749,'2007-12-28 10:42:09','2009-11-07 20:53:53','2009-11-07 20:53:38',NULL,'2014-12-18 23:35:52',1,175,7,5,8,NULL,1,0,0,NULL,NULL,NULL,8056832,1,550,0,1,0,1,NULL,NULL,0,NULL,NULL,NULL),(4,'John','Smart','Smarts','[email protected]','validated',1,'2ab34ad54d71bf2144ef8d3da668d920','male','women',1,'1982-11-11',581,51594390,-145690,'N10','GB',0,'',16860214,'2007-08-04 18:32:20','2009-08-01 03:45:33','2009-07-28 01:36:44',NULL,'2009-08-01 03:57:17',1,177,7,4,2,NULL,1,NULL,NULL,NULL,NULL,NULL,121,1,30,0,1,3,1,NULL,NULL,0,NULL,NULL,NULL),(5,NULL,NULL,'Anousheh','5','new',4,'c130d72fe196043a2b70c9821c8d55b0','female','men',5,'1975-05-08',1688,37777114,-122417326,'94101 ','US',0,'',3762073,'2007-08-04 22:44:54','2009-09-26 22:19:08','2009-09-23 13:51:36',NULL,'2014-12-18 23:43:22',1,170,7,4,9,NULL,1,NULL,NULL,NULL,NULL,NULL,8048640,5,0,0,1,0,1,NULL,NULL,0,NULL,NULL,NULL),(6,'Brad','Henrickson','Brad','[email protected]','validated',1,'792d7efe4c804e6bd8057ba139c4e20c','male','women',1,'1978-07-14',1688,37748224,-122415699,'94110','US',1,'76ea6525d00752450d539fd6a5200516',49836579,'2007-08-05 21:40:21','2015-03-03 01:05:46','2016-08-16 19:05:22',NULL,'2016-08-16 19:05:22',0,185,3,4,1,NULL,1,1,2,1,NULL,NULL,9223090561877233664,0,167,2829,1,2,1,30,NULL,0,30,0,NULL),(7,'Donna','Crawford','Donna','[email protected]','validated',1,'dfc0a2e95a0c84c19365e4332b650761','female','men',1,'1980-10-29',51693,50985500,-1384400,'SO53 2DW','GB',0,'5526',468198,'2007-08-05 22:06:50','2015-03-03 01:05:49',NULL,NULL,'2015-03-03 01:05:49',0,165,7,5,0,NULL,0,0,0,0,NULL,NULL,9223372036853878784,NULL,0,1,1,1,NULL,NULL,NULL,0,800,NULL,NULL),(8,'Freda','Mans','Freda','[email protected]','validated',1,'c0392fa74ab495dcd00e825926e2211f','female','men',5,'1976-12-10',111,43264560,-79847140,'L8L 5P9','CA',1,'',15289775,'2007-08-05 23:06:50','2015-03-08 14:19:35','2019-04-24 07:31:38',NULL,'2019-12-16 02:14:19',0,175,8,1,0,NULL,0,0,0,0,NULL,NULL,9223372036853944320,0,0,1,1,3,1,NULL,NULL,0,431,0,NULL),(9,'Steven','Doyle','Steven','[email protected]','new',1,'ae6846cfef75d1c59f874cf15a2430c2','male','women',5,'1990-11-24',115,42983333,-81250000,'','CA',0,'2117',NULL,'2007-08-06 02:17:05','2015-03-03 01:05:57',NULL,NULL,'2015-03-03 01:05:57',0,180,7,1,9,NULL,0,0,0,0,NULL,NULL,9223372036853878784,NULL,0,1,1,0,NULL,NULL,NULL,0,249,NULL,NULL),(10,'Lance','DAoust','Lance','[email protected]','new',1,'a66cb3dc5b7cb39279d6225ff02c8ab3','male','women',5,'1977-06-24',1346,43898008,-78865637,'L1G','CA',0,'3768',NULL,'2007-08-06 02:40:07','2015-03-03 01:06:04',NULL,NULL,'2015-03-03 01:06:04',0,178,7,6,1,NULL,0,0,0,0,NULL,NULL,9223372036853878784,NULL,0,1,1,0,NULL,NULL,NULL,0,249,NULL,NULL),(11,'Marie','McInnis','roxygirl','[email protected]','validated',1,'76e9dbee22a85e31025317ecb8a46d5e','female','men',5,'1980-05-21',3427,49158350,-122889460,'V4C 6R3','CA',0,'1490',NULL,'2007-08-06 09:25:48','2013-07-03 17:23:44',NULL,NULL,'2013-07-03 17:23:44',0,163,7,1,1,NULL,0,0,0,0,NULL,NULL,9223372036853878784,NULL,0,9,1,0,1,NULL,NULL,0,800,NULL,NULL),(12,'Stean','Van Tonder','Stean','[email protected]','validated',1,'7ae0c7df98260b97e998d9fcc1d7ce2c','male','women',1,'1983-03-12',362,-25725000,28184720,'0001','ZA',1,'',2825378,'2007-08-06 11:55:24','2014-03-09 07:09:21','2015-08-13 13:03:10',NULL,'2018-05-19 07:19:48',0,173,7,2,4,NULL,1,0,0,0,NULL,NULL,9223367638807441408,0,22,265,1,1,1,30,NULL,0,200,0,NULL),(13,'Maureen','Cesano','Mo','[email protected]','validated',1,'9f7d212e0d31dafed0614124dce10414','female','men',5,'1961-07-22',64521,51345260,-1187290,'RG26 5EG','GB',0,'',0,'2007-08-06 13:02:12','2010-09-20 15:22:11','2010-09-17 17:09:03',NULL,'2014-07-30 04:50:25',0,157,7,1,8,NULL,3,0,0,0,NULL,NULL,9223372036853878784,0,0,1,1,0,2,NULL,NULL,0,800,NULL,NULL),(14,'Ryan','Whitney','Ryan','[email protected]','validated',1,'831cffecfb2456f2064c796aba3593e1','male','women',1,'1977-12-26',1688,37748224,-122415699,'94110','US',0,'4915',59559965,'2007-08-06 13:16:52','2012-05-04 05:33:31','2012-04-26 14:14:26',NULL,'2013-02-14 21:19:22',0,178,7,4,9,NULL,1,1,2,3,NULL,NULL,9223367638729838592,NULL,16,521,1,5,1,NULL,NULL,0,800,NULL,NULL),(15,'Darrius','Martin-Francis','Darrius','[email protected]','bounced',1,'c906523c077a4a3bb1c4abbaad04e0ac','male','women',5,'1980-07-17',7808,53799637,-1549110,'','GB',0,'2759',NULL,'2007-08-06 14:01:56',NULL,NULL,NULL,'2018-05-16 18:12:30',0,0,0,0,0,NULL,0,0,0,0,NULL,NULL,9223372036854444032,NULL,0,1,1,0,NULL,NULL,NULL,0,249,NULL,NULL),(16,'Jacquelyn','Jinhong','Helena','[email protected]','validated',1,'62935fc264370b60e95e15fdad3df84f','female','men',1,'1986-03-29',1341,47564251,-122150636,'98006 ','US',0,'8051',658608,'2007-08-06 15:49:25','2010-06-15 17:06:28','2010-06-13 20:54:25',NULL,'2013-08-06 13:53:39',0,167,1,6,0,NULL,1,0,0,0,NULL,NULL,9223372036853878784,0,107,9,1,4,1,NULL,NULL,0,800,NULL,NULL),(17,'Sonnika','Pieterse','Sonnika','[email protected]','new',1,'c40628be9a94145c1e409f78aa813644','female','men',5,'1984-02-20',343,-26195100,28033900,'','ZA',0,'10980',NULL,'2007-08-06 15:50:03',NULL,NULL,NULL,'2013-02-14 21:19:22',0,0,0,0,0,NULL,0,0,0,0,NULL,NULL,9223372036854444032,NULL,0,1,1,0,NULL,NULL,NULL,0,800,NULL,NULL),(18,'Erich','Pizer','archon','[email protected]','validated',1,'12caaf2b7034cb42f829555433ce2c50','male','women',1,'1982-03-10',457,-33900000,18633333,'7530','ZA',0,'9750',2158420,'2007-08-06 17:07:29','2011-02-02 05:34:57','2008-10-19 14:46:14',NULL,'2013-02-14 21:19:22',0,176,7,4,4,NULL,0,0,0,0,NULL,NULL,9223372036853911552,NULL,4,9,1,6,1,NULL,NULL,0,800,NULL,NULL),(19,'Chris','Messer','Chris','[email protected]','new',1,'b1ff00b4cf1aacde1899314a9871dad3','male','women',1,'1983-02-18',1902,30345829,-97765628,'78731 ','US',0,'4811',NULL,'2007-08-06 17:40:38',NULL,NULL,NULL,'2010-10-04 19:29:47',1,193,7,4,4,NULL,0,NULL,NULL,NULL,NULL,NULL,9223372036853878784,NULL,0,0,1,0,NULL,NULL,NULL,0,NULL,NULL,NULL),(20,'Steven','Hughes','Steven','[email protected]','new',1,'06a53f05f4f85de9ace9bc84342494bc','male','women',5,'1983-04-28',7772,-2234376,53480712,'','GB',0,'3805',NULL,'2007-08-06 18:21:21',NULL,NULL,NULL,'2014-07-30 04:50:25',0,0,0,0,0,NULL,0,0,0,0,NULL,NULL,9223372036853878784,NULL,0,1,1,0,2,NULL,NULL,0,249,NULL,NULL),(21,'Artemis','Walden','Artemis','[email protected]','new',1,'0065edae473c4fe5563ca4eea2b90a10','female','men',5,'1987-06-21',180,39704601,-104931289,'80246','US',0,'3594',NULL,'2007-08-06 20:21:20',NULL,NULL,NULL,'2013-02-14 21:19:22',0,0,0,0,0,NULL,0,0,0,0,NULL,NULL,9223372036853878784,NULL,0,1,1,0,NULL,NULL,NULL,0,800,NULL,NULL),(22,'Frances','Tulpin','Franny','[email protected]','new',1,'4fd8163c22b04c7ae66cde280ab5192a','female','men',5,'1975-05-22',3039,42962200,-82388580,'N7T 3P6','CA',0,'5553',NULL,'2007-08-07 02:32:03',NULL,NULL,NULL,'2013-02-14 21:19:22',0,165,7,2,0,NULL,0,0,0,0,NULL,NULL,9223372036853878784,NULL,0,1,1,0,NULL,NULL,NULL,0,800,NULL,NULL),(24,'Amanda','Marino','Amanda','[email protected]','new',1,'1cbfe55837861554e47b72c6d2740d39','female','men',5,'1989-05-02',10850,44389294,-79690134,'','CA',0,'5986',NULL,'2007-08-07 03:04:08','2010-05-28 22:08:56','2011-08-24 16:53:45',NULL,'2011-10-12 21:29:54',1,163,7,1,9,NULL,0,0,0,NULL,NULL,NULL,9223372036854444032,NULL,0,0,1,0,1,NULL,NULL,0,740,NULL,NULL),(25,'Shanelle','Dymin','Shanelle','[email protected]','new',1,'ae9b6621e0119f4ac75f99fe6cfcabda','female','men',5,'1988-08-16',1201,43779371,-79728392,'L6P','CA',0,'2274',NULL,'2007-08-07 05:24:15',NULL,NULL,NULL,'2013-02-14 21:19:23',0,0,0,0,0,NULL,0,0,0,0,NULL,NULL,9223372036854444032,NULL,0,1,1,0,NULL,NULL,NULL,0,800,NULL,NULL),(27,'Marc','De Chalain','Marc','[email protected]','bounced',1,'48f954325728b687c8d1517b83c630a8','male','women',5,'1971-05-08',878,-26195100,28033900,'','ZA',1,'2408',NULL,'2007-08-07 12:16:20','2008-11-10 08:27:51','2009-02-14 20:06:53',NULL,'2017-08-20 07:52:27',0,183,7,5,0,NULL,1,0,0,0,NULL,NULL,9223372036854444032,NULL,0,9,1,0,1,NULL,NULL,0,800,NULL,NULL),(28,'Tony','Fisher','Tony','[email protected]','validated',1,'43182224a1b57eaaa28cda2330de7a93','male','women',1,'1975-01-30',50814,51399100,-107080,'CR7 8PT','GB',0,'4222',NULL,'2007-08-07 14:02:25','2016-10-04 05:44:06','2009-02-09 14:45:47',NULL,'2016-10-04 05:44:06',0,182,7,6,4,NULL,0,0,0,0,NULL,NULL,9223372036854444032,NULL,0,9,1,0,2,NULL,NULL,0,249,NULL,NULL),
`id` bigint(20) unsigned NOT NULL,
`first_name` varchar(50) DEFAULT NULL,
`last_name` varchar(50) DEFAULT NULL,
`user_nicename` varchar(20) DEFAULT NULL,
`user_email` varchar(100) DEFAULT NULL,
`email_status` enum('new','validated','bounced','new-trusted','new-blocked') DEFAULT 'new',
`user_status` int(10) unsigned DEFAULT '2',
`widget_guid` varchar(32) NOT NULL DEFAULT '',
`sex` enum('male','female','unknown') NOT NULL DEFAULT 'unknown',
`interested_in` enum('men','women') DEFAULT NULL,
`relationship` int(10) unsigned DEFAULT '5',
`birthday` date DEFAULT NULL,
`location_id` int(11) DEFAULT NULL,
`latitude` int(11) DEFAULT NULL,
`longitude` int(11) DEFAULT NULL,
`zipcode` varchar(25) DEFAULT NULL,
`country` char(2) DEFAULT NULL,
`discoverable` tinyint(1) NOT NULL DEFAULT '1',
`user_activation_key` varchar(60) NOT NULL DEFAULT '',
`media_request_id` bigint(20) DEFAULT NULL,
`user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`last_login` datetime DEFAULT NULL,
`last_flirted` datetime DEFAULT NULL,
`last_available` datetime DEFAULT NULL,
`lastupdated` datetime DEFAULT NULL,
`migrated` tinyint(1) NOT NULL DEFAULT '1',
`height` tinyint(3) unsigned DEFAULT NULL,
`ethnicity` int(10) unsigned DEFAULT NULL,
`education` int(10) unsigned DEFAULT NULL,
`religion` int(10) unsigned DEFAULT NULL,
`politics` int(10) unsigned DEFAULT NULL,
`children` int(10) unsigned DEFAULT NULL,
`smoking` int(10) unsigned DEFAULT NULL,
`drinking` int(10) unsigned DEFAULT NULL,
`bodytype` int(10) unsigned DEFAULT NULL,
`income` int(10) unsigned DEFAULT NULL,
`pets` int(10) unsigned DEFAULT NULL,
`settings` bigint(20) NOT NULL DEFAULT '3111',
`currency_id` int(11) DEFAULT NULL,
`balance` int(11) NOT NULL DEFAULT '0',
`provider_map` int(11) NOT NULL DEFAULT '1',
`photo_source` int(11) DEFAULT '1',
`photo_count` int(11) NOT NULL DEFAULT '0',
`locale_id` int(11) DEFAULT NULL,
`timezone_id` int(11) DEFAULT NULL,
`source` varchar(255) DEFAULT NULL,
`is_remarketed_to` int(10) unsigned NOT NULL DEFAULT '0',
`dscore` int(11) DEFAULT NULL,
`rscore` int(11) DEFAULT NULL,
`sscore` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `location_id` (`location_id`),
KEY `lastupdated` (`lastupdated`),
KEY `user_email` (`user_email`),
KEY `widget_guid` (`widget_guid`),
KEY `source_country` (`source`,`country`),
KEY `search_g` (`country`,`discoverable`,`sex`,`interested_in`,`photo_count`,`birthday`,`latitude`,`longitude`,`last_login`,`last_flirted`),
KEY `search_o` (`country`,`discoverable`,`sex`,`interested_in`,`photo_count`,`birthday`,`last_available`),
KEY `search` (`country`,`discoverable`,`sex`,`interested_in`,`latitude`,`longitude`,`last_available`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,NULL,NULL,'Chief Pollster','[email protected]','new',4,'1ef762aa38c5cee920bca56aae275124','male','women',1,'1975-03-01',379,49280050,-123039550,'V5K 0A1','CA',0,'',91587322,'2007-08-04 05:08:15','2014-12-19 22:42:57','2014-12-16 14:54:19',NULL,'2014-12-19 23:48:32',0,183,7,6,4,NULL,1,1,2,2,NULL,NULL,9223372036786843648,0,72,8,1,0,1,NULL,'01234567890123456789012345678901234567890123456789012345678901234567890123456789',3,352,0,2),(2,NULL,NULL,'Sarshet','2','validated',4,'3fd0fb59a039dd2475a647f93891c059','male','women',1,'1979-01-12',1688,37798010,-122396965,'94111','US',0,'',48048298,'2007-08-04 18:21:52','2014-08-14 23:44:38','2014-11-15 12:29:51',NULL,'2016-10-25 16:40:55',0,180,7,5,2,NULL,1,1,2,3,NULL,NULL,9223372036854444032,0,508,8200,1,0,1,13,NULL,0,13,0,NULL),(3,NULL,NULL,'Alex23','3','new',4,'bbeee02c461ce5c81db5e0168774a602','male','women',1,'1978-09-21',1688,37798010,-122396965,'94111 ','US',0,'',18930749,'2007-12-28 10:42:09','2009-11-07 20:53:53','2009-11-07 20:53:38',NULL,'2014-12-18 23:35:52',1,175,7,5,8,NULL,1,0,0,NULL,NULL,NULL,8056832,1,550,0,1,0,1,NULL,NULL,0,NULL,NULL,NULL),(4,'John','Smart','Smarts','[email protected]','validated',1,'2ab34ad54d71bf2144ef8d3da668d920','male','women',1,'1982-11-11',581,51594390,-145690,'N10','GB',0,'',16860214,'2007-08-04 18:32:20','2009-08-01 03:45:33','2009-07-28 01:36:44',NULL,'2009-08-01 03:57:17',1,177,7,4,2,NULL,1,NULL,NULL,NULL,NULL,NULL,121,1,30,0,1,3,1,NULL,NULL,0,NULL,NULL,NULL),(5,NULL,NULL,'Anousheh','5','new',4,'c130d72fe196043a2b70c9821c8d55b0','female','men',5,'1975-05-08',1688,37777114,-122417326,'94101 ','US',0,'',3762073,'2007-08-04 22:44:54','2009-09-26 22:19:08','2009-09-23 13:51:36',NULL,'2014-12-18 23:43:22',1,170,7,4,9,NULL,1,NULL,NULL,NULL,NULL,NULL,8048640,5,0,0,1,0,1,NULL,NULL,0,NULL,NULL,NULL),(6,'Brad','Henrickson','Brad','[email protected]','validated',1,'792d7efe4c804e6bd8057ba139c4e20c','male','women',1,'1978-07-14',1688,37748224,-122415699,'94110','US',1,'76ea6525d00752450d539fd6a5200516',49836579,'2007-08-05 21:40:21','2015-03-03 01:05:46','2016-08-16 19:05:22',NULL,'2016-08-16 19:05:22',0,185,3,4,1,NULL,1,1,2,1,NULL,NULL,9223090561877233664,0,167,2829,1,2,1,30,NULL,0,30,0,NULL),(7,'Donna','Crawford','Donna','[email protected]','validated',1,'dfc0a2e95a0c84c19365e4332b650761','female','men',1,'1980-10-29',51693,50985500,-1384400,'SO53 2DW','GB',0,'5526',468198,'2007-08-05 22:06:50','2015-03-03 01:05:49',NULL,NULL,'2015-03-03 01:05:49',0,165,7,5,0,NULL,0,0,0,0,NULL,NULL,9223372036853878784,NULL,0,1,1,1,NULL,NULL,NULL,0,800,NULL,NULL),(8,'Freda','Mans','Freda','[email protected]','validated',1,'c0392fa74ab495dcd00e825926e2211f','female','men',5,'1976-12-10',111,43264560,-79847140,'L8L 5P9','CA',1,'',15289775,'2007-08-05 23:06:50','2015-03-08 14:19:35','2019-04-24 07:31:38',NULL,'2019-12-16 02:14:19',0,175,8,1,0,NULL,0,0,0,0,NULL,NULL,9223372036853944320,0,0,1,1,3,1,NULL,NULL,0,431,0,NULL),(9,'Steven','Doyle','Steven','[email protected]','new',1,'ae6846cfef75d1c59f874cf15a2430c2','male','women',5,'1990-11-24',115,42983333,-81250000,'','CA',0,'2117',NULL,'2007-08-06 02:17:05','2015-03-03 01:05:57',NULL,NULL,'2015-03-03 01:05:57',0,180,7,1,9,NULL,0,0,0,0,NULL,NULL,9223372036853878784,NULL,0,1,1,0,NULL,NULL,NULL,0,249,NULL,NULL),(10,'Lance','DAoust','Lance','[email protected]','new',1,'a66cb3dc5b7cb39279d6225ff02c8ab3','male','women',5,'1977-06-24',1346,43898008,-78865637,'L1G','CA',0,'3768',NULL,'2007-08-06 02:40:07','2015-03-03 01:06:04',NULL,NULL,'2015-03-03 01:06:04',0,178,7,6,1,NULL,0,0,0,0,NULL,NULL,9223372036853878784,NULL,0,1,1,0,NULL,NULL,NULL,0,249,NULL,NULL),(11,'Marie','McInnis','roxygirl','[email protected]','validated',1,'76e9dbee22a85e31025317ecb8a46d5e','female','men',5,'1980-05-21',3427,49158350,-122889460,'V4C 6R3','CA',0,'1490',NULL,'2007-08-06 09:25:48','2013-07-03 17:23:44',NULL,NULL,'2013-07-03 17:23:44',0,163,7,1,1,NULL,0,0,0,0,NULL,NULL,9223372036853878784,NULL,0,9,1,0,1,NULL,NULL,0,800,NULL,NULL),(12,'Stean','Van Tonder','Stean','[email protected]','validated',1,'7ae0c7df98260b97e998d9fcc1d7ce2c','male','women',1,'1983-03-12',362,-25725000,28184720,'0001','ZA',1,'',2825378,'2007-08-06 11:55:24','2014-03-09 07:09:21','2015-08-13 13:03:10',NULL,'2018-05-19 07:19:48',0,173,7,2,4,NULL,1,0,0,0,NULL,NULL,9223367638807441408,0,22,265,1,1,1,30,NULL,0,200,0,NULL),(13,'Maureen','Cesano','Mo','[email protected]','validated',1,'9f7d212e0d31dafed0614124dce10414','female','men',5,'1961-07-22',64521,51345260,-1187290,'RG26 5EG','GB',0,'',0,'2007-08-06 13:02:12','2010-09-20 15:22:11','2010-09-17 17:09:03',NULL,'2014-07-30 04:50:25',0,157,7,1,8,NULL,3,0,0,0,NULL,NULL,9223372036853878784,0,0,1,1,0,2,NULL,NULL,0,800,NULL,NULL),(14,'Ryan','Whitney','Ryan','[email protected]','validated',1,'831cffecfb2456f2064c796aba3593e1','male','women',1,'1977-12-26',1688,37748224,-122415699,'94110','US',0,'4915',59559965,'2007-08-06 13:16:52','2012-05-04 05:33:31','2012-04-26 14:14:26',NULL,'2013-02-14 21:19:22',0,178,7,4,9,NULL,1,1,2,3,NULL,NULL,9223367638729838592,NULL,16,521,1,5,1,NULL,NULL,0,800,NULL,NULL),(15,'Darrius','Martin-Francis','Darrius','[email protected]','bounced',1,'c906523c077a4a3bb1c4abbaad04e0ac','male','women',5,'1980-07-17',7808,53799637,-1549110,'','GB',0,'2759',NULL,'2007-08-06 14:01:56',NULL,NULL,NULL,'2018-05-16 18:12:30',0,0,0,0,0,NULL,0,0,0,0,NULL,NULL,9223372036854444032,NULL,0,1,1,0,NULL,NULL,NULL,0,249,NULL,NULL),(16,'Jacquelyn','Jinhong','Helena','[email protected]','validated',1,'62935fc264370b60e95e15fdad3df84f','female','men',1,'1986-03-29',1341,47564251,-122150636,'98006 ','US',0,'8051',658608,'2007-08-06 15:49:25','2010-06-15 17:06:28','2010-06-13 20:54:25',NULL,'2013-08-06 13:53:39',0,167,1,6,0,NULL,1,0,0,0,NULL,NULL,9223372036853878784,0,107,9,1,4,1,NULL,NULL,0,800,NULL,NULL),(17,'Sonnika','Pieterse','Sonnika','[email protected]','new',1,'c40628be9a94145c1e409f78aa813644','female','men',5,'1984-02-20',343,-26195100,28033900,'','ZA',0,'10980',NULL,'2007-08-06 15:50:03',NULL,NULL,NULL,'2013-02-14 21:19:22',0,0,0,0,0,NULL,0,0,0,0,NULL,NULL,9223372036854444032,NULL,0,1,1,0,NULL,NULL,NULL,0,800,NULL,NULL),(18,'Erich','Pizer','archon','[email protected]','validated',1,'12caaf2b7034cb42f829555433ce2c50','male','women',1,'1982-03-10',457,-33900000,18633333,'7530','ZA',0,'9750',2158420,'2007-08-06 17:07:29','2011-02-02 05:34:57','2008-10-19 14:46:14',NULL,'2013-02-14 21:19:22',0,176,7,4,4,NULL,0,0,0,0,NULL,NULL,9223372036853911552,NULL,4,9,1,6,1,NULL,NULL,0,800,NULL,NULL),(19,'Chris','Messer','Chris','[email protected]','new',1,'b1ff00b4cf1aacde1899314a9871dad3','male','women',1,'1983-02-18',1902,30345829,-97765628,'78731 ','US',0,'4811',NULL,'2007-08-06 17:40:38',NULL,NULL,NULL,'2010-10-04 19:29:47',1,193,7,4,4,NULL,0,NULL,NULL,NULL,NULL,NULL,9223372036853878784,NULL,0,0,1,0,NULL,NULL,NULL,0,NULL,NULL,NULL),(20,'Steven','Hughes','Steven','[email protected]','new',1,'06a53f05f4f85de9ace9bc84342494bc','male','women',5,'1983-04-28',7772,-2234376,53480712,'','GB',0,'3805',NULL,'2007-08-06 18:21:21',NULL,NULL,NULL,'2014-07-30 04:50:25',0,0,0,0,0,NULL,0,0,0,0,NULL,NULL,9223372036853878784,NULL,0,1,1,0,2,NULL,NULL,0,249,NULL,NULL),(21,'Artemis','Walden','Artemis','[email protected]','new',1,'0065edae473c4fe5563ca4eea2b90a10','female','men',5,'1987-06-21',180,39704601,-104931289,'80246','US',0,'3594',NULL,'2007-08-06 20:21:20',NULL,NULL,NULL,'2013-02-14 21:19:22',0,0,0,0,0,NULL,0,0,0,0,NULL,NULL,9223372036853878784,NULL,0,1,1,0,NULL,NULL,NULL,0,800,NULL,NULL),(22,'Frances','Tulpin','Franny','[email protected]','new',1,'4fd8163c22b04c7ae66cde280ab5192a','female','men',5,'1975-05-22',3039,42962200,-82388580,'N7T 3P6','CA',0,'5553',NULL,'2007-08-07 02:32:03',NULL,NULL,NULL,'2013-02-14 21:19:22',0,165,7,2,0,NULL,0,0,0,0,NULL,NULL,9223372036853878784,NULL,0,1,1,0,NULL,NULL,NULL,0,800,NULL,NULL),(24,'Amanda','Marino','Amanda','[email protected]','new',1,'1cbfe55837861554e47b72c6d2740d39','female','men',5,'1989-05-02',10850,44389294,-79690134,'','CA',0,'5986',NULL,'2007-08-07 03:04:08','2010-05-28 22:08:56','2011-08-24 16:53:45',NULL,'2011-10-12 21:29:54',1,163,7,1,9,NULL,0,0,0,NULL,NULL,NULL,9223372036854444032,NULL,0,0,1,0,1,NULL,NULL,0,740,NULL,NULL),(25,'Shanelle','Dymin','Shanelle','[email protected]','new',1,'ae9b6621e0119f4ac75f99fe6cfcabda','female','men',5,'1988-08-16',1201,43779371,-79728392,'L6P','CA',0,'2274',NULL,'2007-08-07 05:24:15',NULL,NULL,NULL,'2013-02-14 21:19:23',0,0,0,0,0,NULL,0,0,0,0,NULL,NULL,9223372036854444032,NULL,0,1,1,0,NULL,NULL,NULL,0,800,NULL,NULL),(27,'Marc','De Chalain','Marc','[email protected]','bounced',1,'48f954325728b687c8d1517b83c630a8','male','women',5,'1971-05-08',878,-26195100,28033900,'','ZA',1,'2408',NULL,'2007-08-07 12:16:20','2008-11-10 08:27:51','2009-02-14 20:06:53',NULL,'2017-08-20 07:52:27',0,183,7,5,0,NULL,1,0,0,0,NULL,NULL,9223372036854444032,NULL,0,9,1,0,1,NULL,NULL,0,800,NULL,NULL),(28,'Tony','Fisher','Tony','[email protected]','validated',1,'43182224a1b57eaaa28cda2330de7a93','male','women',1,'1975-01-30',50814,51399100,-107080,'CR7 8PT','GB',0,'4222',NULL,'2007-08-07 14:02:25','2016-10-04 05:44:06','2009-02-09 14:45:47',NULL,'2016-10-04 05:44:06',0,182,7,6,4,NULL,0,0,0,0,NULL,NULL,9223372036854444032,NULL,0,9,1,0,2,NULL,NULL,0,249,NULL,NULL),