Buy LinkDB People Profile Dataset and implement talent searches on the dataset.
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
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
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
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
Reach out with personal emails
After finding the right people, you can reach out to them via:
We built Proxycurl to empower data-driven products. Talk to Steven, the product manager of Proxycurl today
Here's what we've been up to recently.
Let's kick off this article with a demo. Run the following command to see what an enriched LinkedIn profile looks like when accessed through a 3rd-party LinkedIn API: $ curl \ -G \ -H "Authorization: Bearer demo-bearer-token" \ 'https://nubela.co/proxycurl/api/v2/linkedin' \ --data-urlencode 'linkedin_profile_url=https://www.linkedin.com/in/
13 MIN READ
We get it - flexibility is key when it comes to managing your subscription. Whether you're looking to upgrade, downgrade, or even cancel your plan, we've streamlined the process to be as painless as smooth as possible. Here’s a quick guide to help you with each of these options.
1 MIN READ