Investments

13 rows where Company_category_code = "public_relations" and funding_round_type = "venture" sorted by investor_category_code

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Company, investor_permalink, investor_name, investor_state_code, investor_region, funded_year, raised_amount_usd, gristHelper_Display2, Investor

investor_category_code 1 ✖

  • - 13

Company_category_code 1 ✖

  • public_relations · 13 ✖
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
893 893 1572 /financial-organization/bev-capital BEV Capital   USA CT New York Stamford venture 1215561600 2008 12000000 /company/the-feedroom public_relations BEV Capital https://www.crunchbase.com/financial-organization/bev-capital
896 896 1572 /financial-organization/bev-capital BEV Capital   USA CT New York Stamford venture 1154563200 2006 3300000 /company/the-feedroom public_relations BEV Capital https://www.crunchbase.com/financial-organization/bev-capital
913 913 1572 /financial-organization/bluecrest-capital-finance Bluecrest Capital Finance   GBR IL London London venture 1182729600 2007 5000000 /company/the-feedroom public_relations Bluecrest Capital Finance https://www.crunchbase.com/financial-organization/bluecrest-capital-finance
1042 1042 63 /financial-organization/cayuga-venture-fund Cayuga Venture Fund   USA NY Ithaca Ithaca venture 1150070400 2006 2500000 /company/allworx public_relations Cayuga Venture Fund https://www.crunchbase.com/financial-organization/cayuga-venture-fund
1086 1086 1572 /financial-organization/circle-t-partners Circle T Partners   USA NY New York New York venture 1154563200 2006 3300000 /company/the-feedroom public_relations Circle T Partners https://www.crunchbase.com/financial-organization/circle-t-partners
1103 1103 1555 /financial-organization/columbia-capital Columbia Capital   USA VA Washington DC Alexandria venture 1234137600 2009 11000000 /company/teliris public_relations Columbia Capital https://www.crunchbase.com/financial-organization/columbia-capital
1396 1396 63 /financial-organization/enhanced-capital-partners Enhanced Capital Partners       unknown   venture 1141084800 2006 2000000 /company/allworx public_relations Enhanced Capital Partners https://www.crunchbase.com/financial-organization/enhanced-capital-partners
1508 1508 1555 /financial-organization/fidelity-ventures Fidelity Ventures   USA MA Boston Boston venture 1234137600 2009 11000000 /company/teliris public_relations Fidelity Ventures https://www.crunchbase.com/financial-organization/fidelity-ventures
1784 1784 1572 /financial-organization/freedroom-investors FreedRoom investors       unknown   venture 1215561600 2008 12000000 /company/the-feedroom public_relations FreedRoom investors https://www.crunchbase.com/financial-organization/freedroom-investors
1968 1968 827 /financial-organization/greycroft-partners Greycroft Partners   USA NY New York New York venture 1212278400 2008   /company/ladies-who-launch public_relations Greycroft Partners https://www.crunchbase.com/financial-organization/greycroft-partners
2889 2889 1572 /financial-organization/newspring-capital NewSpring Capital   USA PA Philadelphia Radnor venture 1215561600 2008 12000000 /company/the-feedroom public_relations NewSpring Capital https://www.crunchbase.com/financial-organization/newspring-capital
4126 4126 1572 /financial-organization/velocity-capital Velocity Venture Capital   USA CA Sacramento El Dorado Hills venture 1215561600 2008 12000000 /company/the-feedroom public_relations Velocity Venture Capital https://www.crunchbase.com/financial-organization/velocity-capital
4127 4127 1572 /financial-organization/velocity-capital Velocity Venture Capital   USA CA Sacramento El Dorado Hills venture 1154563200 2006 3300000 /company/the-feedroom public_relations Velocity Venture Capital https://www.crunchbase.com/financial-organization/velocity-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 '');