Steven, the Linkedin API you guys offer is excellent. But how do I begin to use the API if I do not even have the profiles?

I get this question so often, so we decided to crawl every profile and put it into a Postgresql database. We call this product LinkDB, and this is what you can do with it.

What is LinkDB

LinkDB is a Postgresql database preloaded with Linkedin profiles segregated by region. For example, LinkDB for the US is a PostgreSQL database populated with has 165M Linkedin profiles of Americans.

We store each profile as a row under a JSONB column, and this is the shape of the profile's structured data.

Integrating LinkDB into your product

Suppose you run a recruitment platform that pairs software engineers with big tech firms in Singapore. And your growth team is seeking more users on your platform! Specifically, software engineers. LinkDB is a PostgreSQL database. So we will send this SQL query to LinkDB for Singapore that says:

Find all software engineers in Singapore

To fetch the list of professionals who are currently employed as software engineers

SELECT id
FROM PROFILE
WHERE EXISTS
    (SELECT
     FROM jsonb_array_elements(parsed_data->'experiences') exp
     WHERE (exp->>'title' ilike '%Software Engineer%' OR
     exp->>'title' ilike '%Software Developer%') AND 
     exp->>'ends_at' is null
     )

And 10055 software engineers were found along with their Linkedin profile ID.

Software Engineers in Singapore

Find software engineers working at Grab

Grab, the Uber of Southeast Asia has frozen hiring and is looking to downsize its software engineering team no thanks to the COVID19 pandemic. This downsizing event presents a brilliant opportunity to onboard software engineers from Grab into our imaginary recruitment platform!

So let's ask LinkDB for a list of software engineers working at Grab. And we do so by sending this SQL query::

SELECT id
FROM PROFILE
WHERE EXISTS
    (SELECT
     FROM jsonb_array_elements(parsed_data->'experiences') exp
     WHERE exp->>'company_linkedin_profile_url' ILIKE '%linkedin.com/company/grabapp%' )
  AND EXISTS
    (SELECT
     FROM jsonb_array_elements(parsed_data->'experiences') exp
     WHERE (exp->>'title' ILIKE '%Software Engineer%'
            OR exp->>'title' ILIKE '%Software Developer%')
       AND exp->>'ends_at' IS NULL )

In an instant, we have a list of 227 Linkedin profiles of every software engineer working in Grab. This is a headhunter's dream.

Linkedin Profile IDs of software engineers currently working in Grab

Find undergrads who have just matriculated in 2020, majoring in Computer Science with the National University of Singapore

In this imaginary recruitment platform that you are building, you have an internship section for big tech firms because big tech firms want to secure the best undergrads before they graduate. These software engineer internship roles are a perfect fit for Computer Science undergrads. Let's get a list of undergrads who are majoring in Computer science at the National University of Singapore (NUS).

And this is the SQL query to fetch this data:

SELECT id
FROM PROFILE
WHERE EXISTS
    (SELECT
     FROM jsonb_array_elements(parsed_data->'education') exp
     WHERE ( exp->>'degree_name' ILIKE '%Computer Science%'
            OR exp->>'degree_name' ILIKE '%Comp%Sci%')
       AND exp->>'school' ILIKE 'National University of Singapore' )
       and EXISTS
    (SELECT
     FROM jsonb_array_elements(parsed_data->'education') exp
     WHERE exp->>'starts_at' IS NOT NULL
       AND exp#>>'{starts_at,year}' = '2020' )

Here, we have 61 undergrads who have just matriculated, and they are majoring in Computer Science with the National University of Singapore. Perfect candidates for internship positions.

Linkedin Profile IDs of NUS undergrads who matriculated in 2020, majoring in Computer Science

Find CEOs in Singapore

With LinkDB, you have built a brilliant recruitment product pre-populated with perfect candidates that your growth team has helped onboarded. But that is only one side of the equation in a marketplace product that is a recruitment platform. You make money when companies pay you for sourcing perfect candidates for them. And your sales department needs leads. They want to talk to decision-makers -- CEOs.

And this is the SQL query to fetch a list of active CEOs in Singapore

SELECT id
FROM PROFILE
WHERE EXISTS
    (SELECT
     FROM jsonb_array_elements(parsed_data->'experiences') exp
     WHERE (exp->>'title' ilike '%CEO%' OR
     exp->>'title' ilike '%Chief executive officer%') AND 
     exp->>'ends_at' is null
     )

And LinkDB tells us that there are 9633 active CEOs in Singapore.

Profile IDs of active CEOs in Singapore

Plug LinkDB Postgresql instance into your product for $166.50 / mo

So, you want to build your own awesome recruitment platform? You can, for $166.50 / month, you can access LinkDB and plug it into your product.

These are our pricing plans. Our pricing plan for access to LinkDB starts from $166.50 / mo.

Lite Startup (without LinkDB) Startup (with LinkDB) Pro XL
$9.90 / mo $199 / mo $166.5 / mo (paid annually) $1500/mo (payment terms of 3 months) $7999/mo
1000 credits / month 20,000 / month 20,000 / month 200,000 credits / month 1,250,000 credits / mo
$0.01 / credit $0.01 / credit $0.0083 / credit $0.0075 / credit $0.0063 / credit
(No access to LinkDB) (No access to LinkDB) Access to LinkDB Access to LinkDB Access to LinkDB
  • It costs 2 credits per "row of result" queried from LinkDB. Usage is metered by bytes. Cost per bytes is an average byte size of a row of profile.
  • It costs 1 credits for each request made via our Linkedin API

LinkDB will go live in December 2020

LinkDB will go live in December 2020 for databases of US and Singapore. But our subscription plans are available today and they are a better value than our current top up system.

Subscribe now, enjoy deep discounts, and get credits added into your account within 1 business day for use with Proxycurl's Linkedin API. And be the first to integrate LinkDB come December!









Questions and a live demo

As of today, we have a live LinkDB database for 1.4M Singapore profiles. I will be happy to get on a video call with you and write some SQL queries and show you how it can work for you. Just shoot me an email to [email protected].