LinkDB: A complete dataset of public LinkedIn Profiles (and companies 😉)

Hello everyone!!!!!! It's been so long 🥲 (almost a year) since I wrote and I am back!! I'll be writing more i'll try my best to write once a week or two ❤️. Want more info on the caption? Continue reading! 😊

As a Javascript developer or a developer in general, we're always looking for new projects to bump up our resume. Something new, exciting and has never been implemented before (that might turn to a startup 😂😂). Something to make you stand out from the crowd while recruiters are looking through your resume, well if you just learnt about API's and are looking for awesome data to plug into your app, you're very lucky to be reading this post 😉.

LinkDB is an awesome platform that'll provide you with millions of public LinkedIn profiles and companies for a small fee. If you're looking for test data, they will provide you with 10,000 random Canadian, Israel, Singapore, US, Brazilian or Indian profiles. They would also give you (for free) 10,000 random US, Singapore or Swedish company profiles. So gather round my developer friends, I'm not done 😉. For a paid version, you'd get:

• Company Profile Endpoint
• Company Lookup Endpoint
• Company Lookup Endpoint
• Employee Count Endpoint
• Employee Listing Endpoint
• Work Email Lookup Endpoint
• Reverse Work Email Lookup Endpoint
• Personal Contact Number Lookup Endpoint
• Personal Email Lookup Endpoint
• Disposable Email Endpoint
• Jobs Listing Endpoint
• Job Profile Endpoint
• Personal Profile Endpoint
• Personal Lookup Endpoint

and more... Check here for the full pricing details. For my developer friends, the free version is okay for any app of your choice, 10,000 looks enough 🌝. If you need more(planning to turn your app to a startup 😂😂), you can upgrade and get access to millions of LinkedIn profiles around the world ✨.

Who is LinkDB for??

• Companies who has received Venture Capital of at least USD1M
• Companies with more than 50 US/EU employees
• Companies located in a country with a strong rule of law

Some queries you can perform with LinkDB:

• Get all software engineers in San Francisco

SELECT
    id,
    parsed_data->>'first_name' AS first_name,
    parsed_data->'last_name' AS last_name,
    jsonb_path_query_first(parsed_data, '$.experiences[*] ? (@.ends_at == null && @.title == "Software Engineer" && @.location == "San Francisco").title') AS title
FROM profile
WHERE to_tsvector('simple', parsed_data) @@ plainto_tsquery('simple', 'Software Engineer San Francisco') -- general full text search
  AND parsed_data @> '{"experiences": [{"ends_at": null, "title": "Software Engineer", "location": "San Francisco"}]}' -- confirm

• Find all employees working at Apple

SELECT
    id,
    parsed_data->>'first_name' AS first_name,
    parsed_data->'last_name' AS last_name,
    jsonb_path_query_first(parsed_data, '$.experiences[*] ? (@.ends_at == null && @.company_linkedin_profile_url == "https://www.linkedin.com/company/apple/").title') AS title
FROM profile
WHERE to_tsvector('simple', parsed_data) @@ plainto_tsquery('simple', 'https://www.linkedin.com/company/apple/')
  AND parsed_data @> '{"experiences": [{"ends_at": null, "company_linkedin_profile_url": "https://www.linkedin.com/company/apple/"}]}'

And many more! Click here for more info.

And that's it for today! I hope this article was helpful if it was not, I'm sorry to let you down but I'll try better next time. Until I write again, ❤️ Divine.