[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.

[jacklom423]

i need to see this, thanks for share