Investments

16 rows where Company_category_code = "public_relations" and funding_round_type = "series-a" sorted by Company

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Company, investor_permalink, investor_country_code, investor_state_code, funded_at, raised_amount_usd, gristHelper_Display2, Investor

investor_region 7 ✖

investor_city 6 ✖

funded_year 5 ✖

funding_round_type 1 ✖

  • series-a · 16 ✖

Company_category_code 1 ✖

  • public_relations · 16 ✖
id manualSort Company ▼ investor_permalink investor_name investor_category_code investor_country_code investor_state_code investor_region investor_city funding_round_type funded_at funded_year raised_amount_usd gristHelper_Display2 Company_category_code Investor
577 577 63 /financial-organization/advantage-capital-partners Advantage Capital Partners   USA AL Huntsville Huntsville series-a 1122854400 2005 4000000 /company/allworx public_relations Advantage Capital Partners https://www.crunchbase.com/financial-organization/advantage-capital-partners
2083 2083 63 /financial-organization/high-peaks-venture-partners High Peaks Venture Partners   USA NY New York New York series-a 1122854400 2005 4000000 /company/allworx public_relations High Peaks Venture Partners https://www.crunchbase.com/financial-organization/high-peaks-venture-partners
848 848 545 /financial-organization/bergstein Bergstein   USA   TBD   series-a 1162339200 2006 5250000 /company/fifthgenerationsystems public_relations Bergstein https://www.crunchbase.com/financial-organization/bergstein
2026 2026 545 /financial-organization/gund-investment-llc Gund Investment, LLC   USA NJ Princeton Princeton series-a 1162339200 2006 5250000 /company/fifthgenerationsystems public_relations Gund Investment, LLC https://www.crunchbase.com/financial-organization/gund-investment-llc
5049 5049 545 /person/jim-mcniel Jim McNiel       unknown   series-a 1162339200 2006 5250000 /company/fifthgenerationsystems public_relations Jim McNiel https://www.crunchbase.com/person/jim-mcniel
1016 1016 640 /financial-organization/carmel-ventures Carmel Ventures   ISR   Herzeliya Herzeliya series-a 1275350400 2010 8000000 /company/group-commerce public_relations Carmel Ventures https://www.crunchbase.com/financial-organization/carmel-ventures
2468 2468 640 /financial-organization/lerer-ventures Lerer Ventures   USA NY New York New York series-a 1275350400 2010 8000000 /company/group-commerce public_relations Lerer Ventures https://www.crunchbase.com/financial-organization/lerer-ventures
3678 3678 640 /financial-organization/spark-capital Spark Capital   USA MA Boston Boston series-a 1275350400 2010 8000000 /company/group-commerce public_relations Spark Capital https://www.crunchbase.com/financial-organization/spark-capital
4448 4448 640 /person/bob-pittman Bob Pittman       unknown   series-a 1275350400 2010 8000000 /company/group-commerce public_relations Bob Pittman https://www.crunchbase.com/person/bob-pittman
1633 1633 746 /financial-organization/firstmark-capital FirstMark Capital   USA NY New York New York series-a 1329868800 2012 1500000 /company/invision-2 public_relations FirstMark Capital https://www.crunchbase.com/financial-organization/firstmark-capital
647 647 1324 /financial-organization/aol-ventures AOL Ventures   USA NY New York New York series-a 1314835200 2011 8000000 /company/sailthru public_relations AOL Ventures https://www.crunchbase.com/financial-organization/aol-ventures
1277 1277 1324 /financial-organization/dfj-gotham-ventures DFJ Gotham Ventures   USA NY New York New York series-a 1314835200 2011 8000000 /company/sailthru public_relations DFJ Gotham Ventures https://www.crunchbase.com/financial-organization/dfj-gotham-ventures
2483 2483 1324 /financial-organization/lerer-ventures Lerer Ventures   USA NY New York New York series-a 1314835200 2011 8000000 /company/sailthru public_relations Lerer Ventures https://www.crunchbase.com/financial-organization/lerer-ventures
3214 3214 1324 /financial-organization/rap-investments RAP Investments       unknown   series-a 1314835200 2011 8000000 /company/sailthru public_relations RAP Investments https://www.crunchbase.com/financial-organization/rap-investments
3392 3392 1324 /financial-organization/rre-ventures RRE Ventures   USA NY New York New York series-a 1314835200 2011 8000000 /company/sailthru public_relations RRE Ventures https://www.crunchbase.com/financial-organization/rre-ventures
3910 3910 1324 /financial-organization/thrive-capital Thrive Capital   USA NY New York New York series-a 1314835200 2011 8000000 /company/sailthru public_relations Thrive Capital https://www.crunchbase.com/financial-organization/thrive-capital

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "Investments" (id INTEGER PRIMARY KEY, "manualSort" BLOB DEFAULT 1e999, "Company" BLOB DEFAULT 0, "investor_permalink" BLOB DEFAULT '', "investor_name" BLOB DEFAULT '', "investor_category_code" BLOB DEFAULT '', "investor_country_code" BLOB DEFAULT '', "investor_state_code" BLOB DEFAULT '', "investor_region" BLOB DEFAULT '', "investor_city" BLOB DEFAULT '', "funding_round_type" BLOB DEFAULT '', "funded_at" BLOB DEFAULT NULL, "funded_year" BLOB DEFAULT 0, "raised_amount_usd" BLOB DEFAULT 0, "gristHelper_Display2" BLOB DEFAULT NULL, "Company_category_code" BLOB DEFAULT NULL, "Investor" BLOB DEFAULT '');