LinkDB BETA is a Postgresql database of 117M public Linkedin profiles

LinkDB is a fully managed and updated database of public Linkedin profiles

Read the Docs

An entire country's people database in your application

map

These countries are also available:

Canada

Israel

United States

Singapore

Other countries are per request only

Read the Docs
PostgreSQL

LinkedinDB is a PostgresSQL database

complex queries

Run complex queries with SQL

Read the Docs

Perform these queries with LinkDB

"Find me 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 me all employees working in 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/"}]}'
                        
                    

"Find me everyone who studied Computer Science in Stanford"

                        
                            
SELECT
    id,
    parsed_data->>'first_name' AS first_name,
    parsed_data->'last_name' AS last_name,
    jsonb_path_query_first(parsed_data, '$.education[*] ? (@.field_of_study == "Computer Science" && @.school == "Standford University").degree_name') AS degree_name
FROM profile
WHERE to_tsvector('simple', parsed_data) @@ plainto_tsquery('simple', 'Standford University Computer Science') -- general full text search
  AND parsed_data @> '{"education": [{"school": "Standford University", "field_of_study": "Computer Science"}]}' -- confirm
                        
                    

"Employees of a company by name (Example: Electronic Arts)"

                        
                            
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 == "Electronic Arts (EA)").title') AS title
FROM profile
WHERE to_tsvector('simple', parsed_data) @@ plainto_tsquery('simple', 'Electronic Arts (EA)') -- general full text search
  AND parsed_data @> '{"experiences": [{"ends_at": null, "company": "Electronic Arts (EA)"}]}' -- confirm
                        
                    

Pricing

US$ 0.01

per credit

3 credits per profile

* We charge 3 credits for every 5053 bytes of data returned. The median profile is 5053 bytes in size.

Access to LinkDB is free

Get your connection string in the dashboard now