Download Crustdata’s full
B2B dataset for bulk analysis

Don't want to work with APIs? Access data as a CSV flat file or AWS S3.

Don't want to work with APIs?
Access data as a CSV flat file or AWS S3.

SELECT
   c.company_id,
   c.company_website,
   c.total_investment_usd,
   c.linkedin_profile_url,
   g.headcount,
   g.headcount_qoq_pct,
   c.days_since_last_fundraise,
   t.monthly_visitor_qoq_pct
FROM
   crustdata_companies c
JOIN
   companies_linkedin_growth g ON c.company_id = g.company_id
JOIN
   companies_monthly_web_traffic_growth t ON c.company_id = t.company_id
WHERE
   g.headcount > 50
   AND g.headcount_qoq_pct > 20
   AND c.days_since_last_fundraise >= 730
   AND c.total_funding_raised_usd > 5000000
   AND c.largest_headcount_country = "USA";
   AND t.monthly_visitor_qoq_pct > 5

SELECT
   c.company_id,
   c.company_website,
   c.total_investment_usd,
   c.linkedin_profile_url,
   g.headcount,
   g.headcount_qoq_pct,
   c.days_since_last_fundraise,
   t.monthly_visitor_qoq_pct
FROM
   crustdata_companies c
JOIN
   companies_linkedin_growth g ON c.company_id = g.company_id
JOIN
   companies_monthly_web_traffic_growth t ON c.company_id = t.company_id
WHERE
   g.headcount > 50
   AND g.headcount_qoq_pct > 20
   AND c.days_since_last_fundraise >= 730
   AND c.total_funding_raised_usd > 5000000
   AND c.largest_headcount_country = "USA";
   AND t.monthly_visitor_qoq_pct > 5

SELECT
   c.company_id,
   c.company_website,
   c.total_investment_usd,
   c.linkedin_profile_url,
   g.headcount,
   g.headcount_qoq_pct,
   c.days_since_last_fundraise,
   t.monthly_visitor_qoq_pct
FROM
   crustdata_companies c
JOIN
   companies_linkedin_growth g ON c.company_id = g.company_id
JOIN
   companies_monthly_web_traffic_growth t ON c.company_id = t.company_id
WHERE
   g.headcount > 50
   AND g.headcount_qoq_pct > 20
   AND c.days_since_last_fundraise >= 730
   AND c.total_funding_raised_usd > 5000000
   AND c.largest_headcount_country = "USA";
   AND t.monthly_visitor_qoq_pct > 5