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.
Proxycurl is almost three years old, and we are marching towards 5 million (USD) in annual recurring revenue (ARR). In this post, I will tell you exactly how we got here. Proxycurl is a Software-as-a-Service (SaaS), and we sell data enrichment services on people and businesses to other businesses looking
7 MIN READ
What do you think of when you first hear "early-stage" startup? A startup with an idea? An MVP? Some revenue, maybe? The answer is, it depends. For instance, YC (YCombinator) invests in "early-stage" startups with some of them post-revenue while some of them being nothing more
11 MIN READ
