Proxycurl Search May 2023 - Results Now 67% Cheaper & More Learn more
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.
There is not a maximum length for individual parameters of a search query; rather, there is a maximum length for the entire query. This length is 4094 characters. You may allocate the characters between the fields any way you like, so the fewer parameters you have, and the shorter most
6 MIN READ
When we first announced Proxycurl Search last month, we told you we were just getting started. Now we're making good on that promise with a huge update, including: Search is now over 67% cheaper per result returned! Enrichment is now live You can now search companies by funding
5 MIN READ
Our Employee/Student Listing API endpoint relies on LinkDB, a database that exclusively gathers public LinkedIn profiles. Consequently, the data we can provide is only as comprehensive as the content available in LinkDB.LinkedIn's specific heuristics for associating an individual with their employer are not transparent to us.
1 MIN READ