Hello 0DayForums Community,
Today I have uploaded the StarTribune Database for you to download, thanks for reading and enjoy!
In October 2019, the Minnesota-based news service StarTribune suffered a data breach which was subsequently sold on the dark web. The breach exposed over 2 million unique email addresses alongside names, usernames, physical addresses, dates of birth, genders and passwords stored as bcrypt hashes.
Compromised data: Dates of birth, Email addresses, Genders, Names, Passwords, Physical addresses, Usernames
Sample:
Code:
CREATE TABLE `cheetahmail_accounts` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`new_id` int(10) unsigned DEFAULT NULL,
`email_address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`email_address_crc` int(10) unsigned DEFAULT NULL,
`behavior_1` tinyint(4) NOT NULL DEFAULT '0',
`behavior_2` tinyint(4) NOT NULL DEFAULT '0',
`behavior_3` tinyint(4) NOT NULL DEFAULT '0',
`html` int(11) NOT NULL DEFAULT '1',
`birth_date` date DEFAULT NULL,
`clickability_account_id` int(10) unsigned NOT NULL,
`encoded_clickability_account_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`gender` enum('M','F') COLLATE utf8_unicode_ci DEFAULT NULL,
`subscriptions` int(10) unsigned NOT NULL DEFAULT '0',
`zip_code` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`zip_zone` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
`demographic_crc` int(10) unsigned DEFAULT NULL,
`pushed` tinyint(4) NOT NULL DEFAULT '0',
`pushed_to_emma` tinyint(1) NOT NULL DEFAULT '0',
`cheetah_created_at` timestamp NULL DEFAULT NULL,
`cheetah_updated_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `cheetahmail_accounts_email_address_crc_index` (`email_address_crc`),
KEY `cheetahmail_accounts_pushed_index` (`pushed`),
KEY `clickability_account_id` (`clickability_account_id`),
KEY `c_a_pushed_to_emma_index` (`pushed_to_emma`),
KEY `cheetahmail_accounts_new_id_index` (`new_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
LOCK TABLES `cheetahmail_accounts` WRITE;
/*!40000 ALTER TABLE `cheetahmail_accounts` DISABLE KEYS */;
INSERT INTO `cheetahmail_accounts` (`id`, `new_id`, `email_address`, `email_address_crc`, `behavior_1`, `behavior_2`, `behavior_3`, `html`, `birth_date`, `clickability_account_id`, `encoded_clickability_account_id`, `gender`, `subscriptions`, `zip_code`, `zip_zone`, `demographic_crc`, `pushed`, `pushed_to_emma`, `cheetah_created_at`, `cheetah_updated_at`, `created_at`, `updated_at`)
VALUES
(1,NULL,'[email protected]',433984816,0,0,0,1,NULL,9246021,'CxmO2QwoxO0%3D',NULL,0,NULL,NULL,2822182934,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-22 16:06:52'),
(2,NULL,'[email protected]',1846184736,0,0,0,1,NULL,9447977,'PbpVWMZ6H1g%3D',NULL,0,NULL,NULL,1800791304,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-22 16:06:52'),
(3,NULL,'[email protected]',4235224253,0,0,0,1,'1989-03-14',9495741,'HPqkGIfZYLA%3D','F',0,'94104',NULL,3358773044,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-21 13:29:24'),
(4,NULL,'[email protected]',4247887850,0,0,0,1,NULL,10511666,'sJYp3Wzi9go%3D','F',0,'94110',NULL,4258081543,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-22 16:06:52'),
(5,NULL,'[email protected]',3405631320,0,0,0,1,NULL,10635967,'YI816wdj7Zs%3D','F',0,'94111',NULL,785807707,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-29 18:51:27'),
(6,NULL,'[email protected]',2284638344,0,0,0,1,'1975-06-06',10636087,'rnupm21L1Q0%3D','F',0,'41213113',NULL,1544121164,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-29 18:51:28'),
(7,NULL,'[email protected]',2351004711,0,0,0,1,'1972-09-01',10663736,'Ge3NMq%2B%2Fa5w%3D','F',0,'55488',NULL,2834964188,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-29 18:51:28'),
(8,NULL,'[email protected]',1722261829,0,0,0,1,'1965-04-16',10663741,'PsR%2BcGLgcpo%3D','F',0,'48317',NULL,1123070420,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-21 13:29:24'),
(9,NULL,'[email protected]',44951182,0,0,0,1,'1964-05-05',10663746,'FoE%2BvilBKTA%3D','M',0,'55405','sw',445417606,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-23 12:09:40'),
(10,NULL,'[email protected]',1759190464,0,0,0,1,'1970-12-16',10663751,'zIab56%2Bs%2F5k%3D','F',0,'55412','nw',2710883492,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-29 18:51:28'),
(11,NULL,'[email protected]',2273946401,0,0,0,1,'1965-09-25',10663756,'4Gx52Gw0aew%3D','F',0,'55014','no',3727954203,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-29 18:51:28'),
(12,NULL,'[email protected]',1829729859,0,0,0,1,'1972-09-01',10665356,'8AzYhnPLpYI%3D','F',0,'55488',NULL,2999006452,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-29 18:51:28'),
(13,NULL,'[email protected]',2187182242,0,0,0,1,'1965-04-16',10665361,'GXMPruJSN%2Fg%3D','F',0,'48317',NULL,3784238243,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-21 13:29:25'),
(14,NULL,'[email protected]',1948411082,0,0,0,1,'1964-05-05',10665366,'xsjQtQ7uQGA%3D','M',0,'55405','sw',2976938835,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-23 12:09:40'),
(15,NULL,'[email protected]',2607862315,0,0,0,1,'1970-12-16',10665371,'tm5Wj%2BUBiqQ%3D','F',0,'55412','nw',456248920,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-29 18:51:28'),
(16,NULL,'[email protected]',775656383,0,0,0,1,'1965-09-25',10665376,'sDoGyDD0JXw%3D','F',0,'55014','no',2437322484,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-29 18:51:29'),
(17,NULL,'[email protected]',3244893534,0,0,0,1,'1972-09-02',10665871,'gcKp6aXwtQI%3D','F',0,'55488',NULL,3729986088,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-29 18:51:29'),
(18,NULL,'[email protected]',737146940,0,0,0,1,'1965-04-17',10665876,'lkmxrG%2FpYPQ%3D','F',0,'48317',NULL,2956317063,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-21 13:29:25'),
(19,NULL,'[email protected]',3300740829,0,0,0,1,'1964-05-06',10665881,'YZ%2BWcB5LHHg%3D','M',0,'55405','sw',2634215300,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-23 12:09:40'),
(20,NULL,'[email protected]',630408377,0,0,0,1,'1970-12-17',10665886,'s1m6RB3etjg%3D','F',0,'55412','nw',346838708,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-29 18:51:29'),
(21,NULL,'[email protected]',3401708120,0,0,0,1,'1965-09-26',10665891,'q%2BvUNyjS89k%3D','F',0,'55014','no',571746417,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-29 18:51:29'),
(22,NULL,'[email protected]',2594866985,0,0,0,1,'1960-05-25',10669791,'uxP3kCjGCbk%3D','M',0,'55419','sw',570649682,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-23 12:09:40'),
(23,NULL,'[email protected]',541536058,0,0,0,1,'1972-09-02',10670741,'fe4VMIjM%2BJQ%3D','F',0,'55488',NULL,2322029889,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-29 18:51:29'),
(24,NULL,'[email protected]',3474299355,0,0,0,1,'1965-04-17',10670746,'EMCSLIHKki4%3D','F',0,'48317',NULL,2031323580,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:45','2013-03-21 13:29:25'),
(25,NULL,'[email protected]',963263923,0,0,0,1,'1964-05-06',10670751,'KrcicbS2C9o%3D','M',0,'55405','sw',1626715446,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-23 12:09:40'),
(26,NULL,'[email protected]',3594029906,0,0,0,1,'1970-12-17',10670756,'UAl1MO6GSag%3D','F',0,'55412','nw',2501653425,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-29 18:51:30'),
(27,NULL,'[email protected]',2372736278,0,0,0,1,'1965-09-26',10670761,'DE9tl8G5wZ0%3D','F',0,'55014','no',1110555837,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-29 18:51:30'),
(28,NULL,'[email protected]',1519359310,0,0,0,1,'1972-09-02',10671606,'ALkDbg8GFmw%3D','F',0,'55488',NULL,464088219,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-29 18:51:30'),
(29,NULL,'[email protected]',3051168687,0,0,0,1,'1964-05-06',10671611,'gOwywM1OWB0%3D','M',0,'55405','sw',2116232129,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-23 12:09:40'),
(30,NULL,'[email protected]',294573904,0,0,0,1,'1969-03-01',10672101,'oFi38cZTW%2Bc%3D','M',0,'33441',NULL,3049187126,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-21 13:29:25'),
(31,NULL,'[email protected]',2683281865,0,0,0,1,'1949-02-02',10672106,'OheryQaReXo%3D','M',0,'55901',NULL,3268168916,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-21 13:29:25'),
(32,NULL,'[email protected]',246140668,0,0,0,1,'1984-01-01',10672111,'XGnd8skcTuE%3D','F',0,'55304','no',2935771902,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-29 18:51:30'),
(33,NULL,'[email protected]',1815160753,0,0,0,1,'1973-09-08',10672236,'d1hD3F5EElk%3D','F',0,'55401','nw',2200791784,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-23 12:09:40'),
(34,NULL,'[email protected]',2649375684,0,0,0,1,'1944-03-26',10672241,'6cLCWE8PLbM%3D','M',0,'55447','nw',1713695413,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-23 12:09:40'),
(35,NULL,'[email protected]',1755591913,0,0,0,1,'1954-11-06',10672246,'j62QvW2299A%3D','M',0,'55045','ea',2658302975,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-29 18:51:31'),
(36,NULL,'[email protected]',58903547,0,0,0,1,'1951-09-10',10672251,'1MoPQaQWNfw%3D','M',0,'55303','no',3519368134,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-29 18:51:31'),
(37,NULL,'[email protected]',2100599026,0,0,0,1,'1965-07-15',10672256,'%2BZlHPPm8ps0%3D','M',0,'55422','nw',3462918509,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-23 12:09:40'),
(38,NULL,'[email protected]',779580691,0,0,0,1,'1970-12-20',10672261,'ybtJmEUFrjg%3D','M',0,'55405','sw',2006394910,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-23 12:09:40'),
(39,NULL,'[email protected]',1511831795,0,0,0,1,'1953-01-04',10672266,'YR%2BQbHmT6o0%3D','F',0,'55406','sw',1239445110,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-23 12:09:40'),
(40,NULL,'[email protected]',374748155,0,0,0,1,'1953-01-14',10672281,'Ldw5SvDuAJY%3D','M',0,'55423','sw',3434275036,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-29 18:51:31'),
(41,NULL,'[email protected]',2536998357,0,0,0,1,'1965-04-13',10672286,'M19rr6LHdUE%3D','F',0,'55303','no',2765024592,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-23 12:09:40'),
(42,NULL,'[email protected]',2462753123,0,0,0,1,'1951-12-05',10672291,'kAru0NVSsu4%3D','F',0,'55488',NULL,4109696848,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-21 13:29:25'),
(43,NULL,'[email protected]',589195853,0,0,0,1,'1974-02-23',10672296,'79TQw1BFlaM%3D','M',0,'55414','sw',719515292,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-29 18:51:31'),
(44,NULL,'[email protected]',1932558087,0,0,0,1,'1937-03-24',10672301,'y4FhwN4UXhg%3D','M',0,'56258',NULL,3305073396,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-21 13:29:25'),
(45,NULL,'[email protected]',3070256973,0,0,0,1,'1960-12-20',10672306,'9lAqsVGk9Yo%3D','M',0,'55375','sw',3097288345,1,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','2013-03-19 18:14:46','2013-03-29 18:51:31'),