[SPARK]

Download:

Hidden Content

You must register or login to view this content.

Leak contains companies information in SQL

[hakacc]

What information?

[JayEvans121365]

Is this extracted data from the leak from last year?

[blkmrkt]

This is some amateur garbage: only 4.8M records (out of 50M+ companies on LinkedIn), only basic info, and everything's mangled into lowercase. Here's a sample because OP could not bother:

DROP TABLE IF EXISTS `companies`;
/*!40101 SET @saved_cs_client    = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `companies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_url_domain` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company_name` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `industry` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `linkedin_url` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `locality` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `total_employee_estimate` int(11) DEFAULT NULL,
  `year_founded` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4824223 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

***

INSERT INTO `companies` VALUES
(1,'https://www.seniorplanningadvisors.com','senior planning advisors','united states','military','https://www.linkedin.com/company/senior-planning-advisors','victorville',1,NULL),
(2,'https://www.seniorplanningadvisors.com','senior planning advisors','united states','military','https://www.linkedin.com/company/senior-planning-advisors','victorville',1,NULL),
(3,'https://www.seniorplanningadvisors.com','senior planning advisors','united states','military','https://www.linkedin.com/company/senior-planning-advisors','victorville',1,NULL),
(4,'https://www.kbenefitgroup.com','k benefit group, inc.','united states','insurance','https://www.linkedin.com/company/k-benefit-group-inc.','ludlow',1,NULL),
(5,'https://www.aarkenterprises.com','aark enterprises, inc.','united states','hospitality','https://www.linkedin.com/company/aark-enterprises-inc.','vernon',1,NULL),
(6,'https://www.workmethods-training.com','workmethods training institute','india','education management','https://www.linkedin.com/company/workmethods-training-institute','pune',1,NULL),
(7,'https://www.tedeschoconsultoria.com.br','tedescho consulting','brazil','management consulting','https://www.linkedin.com/company/tedescho-consulting','vargem grande do sul',1,2009)

[annylynn2]

blkmrkt Thanks for that!
I have the 1.8TB from linkedin scrapping, those are garbage.

This forum account is currently banned. Ban Length: Permanent (N/A Remaining)
Ban Reason: Multi-Accounting | Contact us via https://breachforums.ai/contact if you feel this is incorrect.

[jacklom423]

i need to see this, thanks for share