LinkedIn Company Pages Data
LinkedIn Company Pages Data -Post content and other details
@kaggle.shreyasajal_linkedin_company_pages_data
Company Data
@kaggle.shreyasajal_linkedin_company_pages_data.company_data
- 3.94 MB
- 11654 rows
- 19 columns
unnamed_0Unnamed: 0 | nameName | headlineHeadline | locationLocation | followersFollowers | connectionsConnections | aboutAbout | time_spentTime Spent | contentContent | content_linksContent Links | media_typeMedia Type | media_urlsMedia Urls | num_hashtagsNum Hashtags | hashtag_followersHashtag Followers | hashtagsHashtags | reactionsReactions | commentsComments | viewsViews | votesVotes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Dell Technologies | Information Technology & Services | Round Rock, Texas | 3,597,845 followers | 194140 | Dell Technologies is a unique family of businesses that provides the essential infrastructure for organizations to build their digital future, transform IT and protect their most important asset, information. | 1 week ago | #ICYMI check out the keynote replay from the #DellTechExperience on Jan 26th, followed by a performance by renowned musician and comedian, Reggie Watts. Hear from experts on how the future of work is unfolding and the latest in client innovation. After the keynote, hop over and explore the inte… | [['https://www.linkedin.com/feed/hashtag/?keywords=icymi&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6762617534907727872', '#ICYMI'], ['https://www.linkedin.com/feed/hashtag/?keywords=delltechexperience&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6762617534907727872', '#DellTechExperience'], ['https… | video | ['blob:https://www.linkedin.com/4680e2eb-c683-47e3-ad8d-d704ed34537a'] | 2 | [['https://www.linkedin.com/feed/hashtag/?keywords=icymi&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6762617534907727872', '#ICYMI'], ['https://www.linkedin.com/feed/hashtag/?keywords=delltechexperience&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6762617534907727872', '#DellTechExperience']] | 1217 | 577 | ||||
| 1 | Dell Technologies | Information Technology & Services | Round Rock, Texas | 3,597,845 followers | 194140 | Dell Technologies is a unique family of businesses that provides the essential infrastructure for organizations to build their digital future, transform IT and protect their most important asset, information. | 20 hours ago | “We need to move faster to address the digital inequity we see around us today, especially when it comes to education & remote learning,” SVP of Corp. Affairs Jennifer "JJ" Davis on joining the Take On Race Coalition to close the #DigitalDivide for students💙 https://dell.to/2MMNRkB …see … | [['https://www.linkedin.com/in/ACoAAABpTIwBhTxWxTJyaLxLnzqcZ68hd1VCQp8', 'Jennifer "JJ" Davis'], ['https://www.linkedin.com/feed/hashtag/?keywords=digitaldivide&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6765686816776458240', '#DigitalDivide'], ['https://dell.to/2MMNRkB', 'https://dell.to/2MMNRkB']… | image | ['https://media-exp1.licdn.com/dms/image/C4D22AQFz06XNlSOa-Q/feedshare-shrink_800/0/1613065437490?e=1616025600&v=beta&t=RthWXWCA0bQTHD-yniJey-vPf7wwv70rATWXhAU7SLA'] | 1 | [['https://www.linkedin.com/feed/hashtag/?keywords=digitaldivide&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6765686816776458240', '#DigitalDivide']] | 76 | 2 | |||
| 2 | Dell Technologies | Information Technology & Services | Round Rock, Texas | 3,597,845 followers | 194140 | Dell Technologies is a unique family of businesses that provides the essential infrastructure for organizations to build their digital future, transform IT and protect their most important asset, information. | 20 hours ago | Meet our 2021 APJ Sales Graduates! Last week, we had a chance to welcome 25 new graduates across APJ and what a great welcome it was! Michael Dell personally kicked off the Sales Academy and the group got to chat to him on a range of different topics such as career advice and books he’s recently re… | [['https://www.linkedin.com/feed/hashtag/?keywords=graduatesatdell&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6765695790561165312', '#graduatesatDell'], ['https://www.linkedin.com/feed/hashtag/?keywords=diverseteams&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6765695790561165312', '#diverseteams']] | image | ['https://media-exp1.licdn.com/dms/image/C4D22AQFdbynO7HGmFg/feedshare-shrink_800/0/1613067577000?e=1616025600&v=beta&t=0Se1YcH8Q_62NzBB4xomO133QhVqjiYfqWLvzbTC0kk'] | 2 | [['https://www.linkedin.com/feed/hashtag/?keywords=graduatesatdell&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6765695790561165312', '#graduatesatDell'], ['https://www.linkedin.com/feed/hashtag/?keywords=diverseteams&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6765695790561165312', '#diverseteams']] | 35 | ||||
| 3 | Dell Technologies | Information Technology & Services | Round Rock, Texas | 3,597,845 followers | 194140 | Dell Technologies is a unique family of businesses that provides the essential infrastructure for organizations to build their digital future, transform IT and protect their most important asset, information. | 22 hours ago | From our family to yours, we wish you four seasons of happiness and a flourishing year. Happy Lunar New Year to all! 💙 | [] | video | ['https://dms.licdn.com/playlist/C5605AQGCmtEZRt2LVA/mp4-720p-30fp-crf28/0/1613057418307?e=1613228400&v=beta&t=FrKXnduVcceQ4qwAphErUiAeoISXpYltUuPIO7uWV88'] | [] | 195 | 2 | ||||
| 4 | Dell Technologies | Information Technology & Services | Round Rock, Texas | 3,597,845 followers | 194140 | Dell Technologies is a unique family of businesses that provides the essential infrastructure for organizations to build their digital future, transform IT and protect their most important asset, information. | 2 days ago | #5G will revolutionize food production — soil and water sensors, automated planting & harvesting, irritation management and more will increase yields and save time. We're pleased to partner with technology leaders and innovators to create the #5G Open #Innovation Lab, a project to showcase 5G-p… | [['https://www.linkedin.com/feed/hashtag/?keywords=5g&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6764928079635763201', '#5G'], ['https://www.linkedin.com/feed/hashtag/?keywords=5g&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6764928079635763201', '#5G'], ['https://www.linkedin.com/feed/hashtag/?keyw… | video | [] | 3 | [['https://www.linkedin.com/feed/hashtag/?keywords=5g&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6764928079635763201', '#5G'], ['https://www.linkedin.com/feed/hashtag/?keywords=5g&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6764928079635763201', '#5G'], ['https://www.linkedin.com/feed/hashtag/?keyw… | 250 | 6 | |||
| 5 | Dell Technologies | Information Technology & Services | Round Rock, Texas | 3,597,845 followers | 194140 | Dell Technologies is a unique family of businesses that provides the essential infrastructure for organizations to build their digital future, transform IT and protect their most important asset, information. | 2 days ago | Rapid change and unexpected circumstances are stressful — your business can take a breather knowing its tech is supported by high-quality services and experts. https://dell.to/3a1bM7x | [['https://dell.to/3a1bM7x', 'https://dell.to/3a1bM7x']] | image | ['https://media-exp1.licdn.com/dms/image/C4D22AQGsLcwk5K11JQ/feedshare-shrink_800/0/1612905480709?e=1616025600&v=beta&t=fbXjk-b2UkAaK_4OhM4NAYivJ2Dbj832sB4oy8ifcOg'] | [] | 144 | |||||
| 6 | Dell Technologies | Information Technology & Services | Round Rock, Texas | 3,597,845 followers | 194140 | Dell Technologies is a unique family of businesses that provides the essential infrastructure for organizations to build their digital future, transform IT and protect their most important asset, information. | 4 days ago | According to Gartner's 2020 CEO survey most businesses are planning to increase investment in digital capabilities (82%) and IT (78%), but the prerequisite to success is collaboration in the C-Suite. https://dell.to/3qeNkps #ConnectedExec | [['https://dell.to/3qeNkps', 'https://dell.to/3qeNkps'], ['https://www.linkedin.com/feed/hashtag/?keywords=connectedexec&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6764503282372091905', '#ConnectedExec']] | image | ['https://media-exp1.licdn.com/dms/image/C4D22AQHvb-l97QaQeA/feedshare-shrink_800/0/1612783262637?e=1616025600&v=beta&t=pecaHGPybYZ-2dHJuiuFuJOI1qefZ97yYGgq-AKoKWI'] | 1 | [['https://www.linkedin.com/feed/hashtag/?keywords=connectedexec&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6764503282372091905', '#ConnectedExec']] | 128 | ||||
| 7 | Dell Technologies | Information Technology & Services | Round Rock, Texas | 3,597,845 followers | 194140 | Dell Technologies is a unique family of businesses that provides the essential infrastructure for organizations to build their digital future, transform IT and protect their most important asset, information. | 5 days ago | A true All-in-One experience to empower your productivity in any workspace. Discover the OptiPlex Ultra at the #DellTechExperience https://dell.to/3rv4hNd | [['https://www.linkedin.com/feed/hashtag/?keywords=delltechexperience&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6763888984822181888', '#DellTechExperience'], ['https://dell.to/3rv4hNd', 'https://dell.to/3rv4hNd']] | image | ['https://media-exp1.licdn.com/dms/image/C4D22AQFq7lyS9Xbo6Q/feedshare-shrink_800/0/1612636800905?e=1616025600&v=beta&t=VfkfDSWx3ePKJautxAVUR6lKOC0TUf51nMHm70AUr2w'] | 1 | [['https://www.linkedin.com/feed/hashtag/?keywords=delltechexperience&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6763888984822181888', '#DellTechExperience']] | 410 | 5 | |||
| 8 | Dell Technologies | Information Technology & Services | Round Rock, Texas | 3,597,845 followers | 194140 | Dell Technologies is a unique family of businesses that provides the essential infrastructure for organizations to build their digital future, transform IT and protect their most important asset, information. | 1 day ago | Imagine the future of work as better connected, better for the environment, and perfectly tailored for remote experiences. That's the #DellTechExperience . And we're just getting started. Watch the replay now: https://dell.to/2Nc4K8b | [['https://www.linkedin.com/feed/hashtag/?keywords=delltechexperience&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6765400563682168832', '#DellTechExperience'], ['https://dell.to/2Nc4K8b', 'https://dell.to/2Nc4K8b']] | video | ['https://dms.licdn.com/playlist/C4D05AQHjzm4O1bfZyQ/mp4-720p-30fp-crf28/0/1612997188371?e=1613228400&v=beta&t=ZAE2442mP8TGAjM_RPmqjtKzNgsFCLfbrejvc7e0HDs'] | 1 | [['https://www.linkedin.com/feed/hashtag/?keywords=delltechexperience&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6765400563682168832', '#DellTechExperience']] | 167 | 3 | |||
| 9 | Dell Technologies | Information Technology & Services | Round Rock, Texas | 3,597,845 followers | 194140 | Dell Technologies is a unique family of businesses that provides the essential infrastructure for organizations to build their digital future, transform IT and protect their most important asset, information. | 1 day ago | Discover how intelligent devices are digitizing animal shelters and helping pets find new homes 🎧 Listen to the latest episode of Technology Powers X: https://dell.to/3rFng7z | [['https://dell.to/3rFng7z', 'https://dell.to/3rFng7z']] | video | ['https://dms.licdn.com/playlist/C4D05AQHkyWqc0ykw5w/mp4-720p-30fp-crf28/0/1613001249154?e=1613228400&v=beta&t=9BBBLSvXNsY64DewHMkm5UfE5lJgtsNqQ4sEYOGqe6E'] | [] | 178 |
CREATE TABLE company_data (
"unnamed_0" BIGINT,
"name" VARCHAR,
"headline" VARCHAR,
"location" VARCHAR,
"followers" VARCHAR,
"connections" BIGINT,
"about" VARCHAR,
"time_spent" VARCHAR,
"content" VARCHAR,
"content_links" VARCHAR,
"media_type" VARCHAR,
"media_urls" VARCHAR,
"num_hashtags" BIGINT,
"hashtag_followers" BIGINT,
"hashtags" VARCHAR,
"reactions" BIGINT,
"comments" BIGINT,
"views" VARCHAR,
"votes" DOUBLE
);