Investments

76 rows where Company_category_code = "public_relations" and investor_country_code = "USA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Company, investor_category_code, investor_state_code, investor_region, investor_city, funding_round_type, funded_at, funded_year, raised_amount_usd, gristHelper_Display2

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
170 170 959 /company/foley-lardner Foley & Lardner   USA MA Boston Boston angel 1372723200 2013 500000 /company/mingyian public_relations Foley & Lardner https://www.crunchbase.com/company/foley-lardner
249 249 1572 /company/nbcuniversal NBC Universal web USA   United States - Other   series-b 966902400 2000 30000000 /company/the-feedroom public_relations NBC Universal https://www.crunchbase.com/company/nbcuniversal
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
641 641 1324 /financial-organization/aol-ventures AOL Ventures   USA NY New York New York angel 1280102400 2010 1000000 /company/sailthru public_relations AOL Ventures https://www.crunchbase.com/financial-organization/aol-ventures
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
650 650 1324 /financial-organization/aol-ventures AOL Ventures   USA NY New York New York series-b 1360540800 2013 19000000 /company/sailthru public_relations AOL Ventures https://www.crunchbase.com/financial-organization/aol-ventures
656 656 1532 /financial-organization/apax-partners Apax Partners   USA NY New York New York series-c+ 1128988800 2005 5000000 /company/synaptic-digital public_relations Apax Partners https://www.crunchbase.com/financial-organization/apax-partners
687 687 1360 /financial-organization/ascend-venture-group Ascend Venture Group   USA NY New York New York series-c+ 1222646400 2008 14000000 /company/sendwordnow public_relations Ascend Venture Group https://www.crunchbase.com/financial-organization/ascend-venture-group
689 689 1360 /financial-organization/ascend-venture-group Ascend Venture Group   USA NY New York New York series-c+ 1191888000 2007 8500000 /company/sendwordnow public_relations Ascend Venture Group https://www.crunchbase.com/financial-organization/ascend-venture-group
690 690 1360 /financial-organization/ascend-venture-group Ascend Venture Group   USA NY New York New York series-b 1154908800 2006 10500000 /company/sendwordnow public_relations Ascend Venture Group https://www.crunchbase.com/financial-organization/ascend-venture-group
769 769 299 /financial-organization/bancboston-ventures BancBoston Ventures   USA MA Boston Boston series-c+ 1119916800 2005 11000000 /company/cloverleaf-communications public_relations BancBoston Ventures https://www.crunchbase.com/financial-organization/bancboston-ventures
794 794 1532 /financial-organization/battery-ventures Battery Ventures   USA CA SF Bay Menlo Park series-c+ 1128988800 2005 5000000 /company/synaptic-digital public_relations Battery Ventures https://www.crunchbase.com/financial-organization/battery-ventures
827 827 1572 /financial-organization/bear-stearns Bear Stearns   USA GA Atlanta Atlanta series-b 966902400 2000 30000000 /company/the-feedroom public_relations Bear Stearns https://www.crunchbase.com/financial-organization/bear-stearns
840 840 1324 /financial-organization/benchmark Benchmark   USA CA SF Bay Menlo Park series-b 1360540800 2013 19000000 /company/sailthru public_relations Benchmark https://www.crunchbase.com/financial-organization/benchmark
847 847 545 /financial-organization/bergstein Bergstein   USA   TBD   series-b 1199145600 2008 5300000 /company/fifthgenerationsystems public_relations Bergstein https://www.crunchbase.com/financial-organization/bergstein
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
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
894 894 1572 /financial-organization/bev-capital BEV Capital   USA CT New York Stamford series-c+ 1083024000 2004 5000000 /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
940 940 1324 /financial-organization/bowery-capital Bowery Capital   USA NY New York New York angel 1280102400 2010 1000000 /company/sailthru public_relations Bowery Capital https://www.crunchbase.com/financial-organization/bowery-capital
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
1084 1084 1572 /financial-organization/circle-t-partners Circle T Partners   USA NY New York New York series-c+ 1032048000 2002 5000000 /company/the-feedroom public_relations Circle T Partners https://www.crunchbase.com/financial-organization/circle-t-partners
1085 1085 1572 /financial-organization/circle-t-partners Circle T Partners   USA NY New York New York series-c+ 1083024000 2004 5000000 /company/the-feedroom public_relations Circle T Partners https://www.crunchbase.com/financial-organization/circle-t-partners
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
1134 1134 1572 /financial-organization/constellation-ventures Constellation Ventures   USA NY New York New York series-c+ 1032048000 2002 5000000 /company/the-feedroom public_relations Constellation Ventures https://www.crunchbase.com/financial-organization/constellation-ventures
1135 1135 1572 /financial-organization/constellation-ventures Constellation Ventures   USA NY New York New York series-c+ 1083024000 2004 5000000 /company/the-feedroom public_relations Constellation Ventures https://www.crunchbase.com/financial-organization/constellation-ventures
1263 1263 1324 /financial-organization/dfj-gotham-ventures DFJ Gotham Ventures   USA NY New York New York angel 1280102400 2010 1000000 /company/sailthru public_relations DFJ Gotham Ventures https://www.crunchbase.com/financial-organization/dfj-gotham-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
1282 1282 1324 /financial-organization/dfj-gotham-ventures DFJ Gotham Ventures   USA NY New York New York series-b 1360540800 2013 19000000 /company/sailthru public_relations DFJ Gotham Ventures https://www.crunchbase.com/financial-organization/dfj-gotham-ventures
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
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
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
2025 2025 545 /financial-organization/gund-investment-llc Gund Investment, LLC   USA NJ Princeton Princeton series-b 1199145600 2008 5300000 /company/fifthgenerationsystems public_relations Gund Investment, LLC https://www.crunchbase.com/financial-organization/gund-investment-llc
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
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
2088 2088 1532 /financial-organization/high-peaks-venture-partners High Peaks Venture Partners   USA NY New York New York series-c+ 1128988800 2005 5000000 /company/synaptic-digital public_relations High Peaks Venture Partners https://www.crunchbase.com/financial-organization/high-peaks-venture-partners
2157 2157 1572 /financial-organization/i-hatch-ventures i-Hatch Ventures   USA NY New York New York series-b 966902400 2000 30000000 /company/the-feedroom public_relations i-Hatch Ventures https://www.crunchbase.com/financial-organization/i-hatch-ventures
2158 2158 1572 /financial-organization/i-hatch-ventures i-Hatch Ventures   USA NY New York New York series-c+ 1032048000 2002 5000000 /company/the-feedroom public_relations i-Hatch Ventures https://www.crunchbase.com/financial-organization/i-hatch-ventures
2276 2276 1572 /financial-organization/intel-capital Intel Capital   USA CA SF Bay Santa Clara series-c+ 1032048000 2002 5000000 /company/the-feedroom public_relations Intel Capital https://www.crunchbase.com/financial-organization/intel-capital
2329 2329 640 /financial-organization/jafco-ventures Jafco Ventures   USA CA SF Bay Palo Alto series-c+ 1338249600 2012 21000000 /company/group-commerce public_relations Jafco Ventures https://www.crunchbase.com/financial-organization/jafco-ventures
2456 2456 1324 /financial-organization/lerer-ventures Lerer Ventures   USA NY New York New York angel 1280102400 2010 1000000 /company/sailthru public_relations Lerer Ventures https://www.crunchbase.com/financial-organization/lerer-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
2471 2471 640 /financial-organization/lerer-ventures Lerer Ventures   USA NY New York New York series-b 1305158400 2011 10000000 /company/group-commerce public_relations Lerer Ventures https://www.crunchbase.com/financial-organization/lerer-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
2499 2499 640 /financial-organization/lerer-ventures Lerer Ventures   USA NY New York New York series-c+ 1338249600 2012 21000000 /company/group-commerce public_relations Lerer Ventures https://www.crunchbase.com/financial-organization/lerer-ventures
2708 2708 1324 /financial-organization/metamorphic-ventures-llc Metamorphic Ventures   USA NY New York New York City angel 1280102400 2010 1000000 /company/sailthru public_relations Metamorphic Ventures https://www.crunchbase.com/financial-organization/metamorphic-ventures-llc
2871 2871 1572 /financial-organization/new-york-city-investment-fund New York City Investment Fund   USA NY New York New York series-b 966902400 2000 30000000 /company/the-feedroom public_relations New York City Investment Fund https://www.crunchbase.com/financial-organization/new-york-city-investment-fund
2872 2872 1572 /financial-organization/new-york-city-investment-fund New York City Investment Fund   USA NY New York New York series-c+ 1032048000 2002 5000000 /company/the-feedroom public_relations New York City Investment Fund https://www.crunchbase.com/financial-organization/new-york-city-investment-fund
2873 2873 1572 /financial-organization/new-york-city-investment-fund New York City Investment Fund   USA NY New York New York series-c+ 1083024000 2004 5000000 /company/the-feedroom public_relations New York City Investment Fund https://www.crunchbase.com/financial-organization/new-york-city-investment-fund
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
3040 3040 1360 /financial-organization/palisade-capital-management Palisade Capital Management   USA NJ New York Fort Lee series-c+ 1222646400 2008 14000000 /company/sendwordnow public_relations Palisade Capital Management https://www.crunchbase.com/financial-organization/palisade-capital-management
3062 3062 545 /financial-organization/persistency-capital Persistency Capital   USA NY New York New York series-b 1199145600 2008 5300000 /company/fifthgenerationsystems public_relations Persistency Capital https://www.crunchbase.com/financial-organization/persistency-capital
3076 3076 1324 /financial-organization/pilot-group Pilot Group   USA NY New York New York angel 1280102400 2010 1000000 /company/sailthru public_relations Pilot Group https://www.crunchbase.com/financial-organization/pilot-group
3293 3293 1572 /financial-organization/ridgewood-capital Ridgewood Capital   USA NJ Montvale Montvale series-b 966902400 2000 30000000 /company/the-feedroom public_relations Ridgewood Capital https://www.crunchbase.com/financial-organization/ridgewood-capital
3294 3294 1572 /financial-organization/ridgewood-capital Ridgewood Capital   USA NJ Montvale Montvale series-c+ 1032048000 2002 5000000 /company/the-feedroom public_relations Ridgewood Capital https://www.crunchbase.com/financial-organization/ridgewood-capital
3295 3295 1572 /financial-organization/ridgewood-capital Ridgewood Capital   USA NJ Montvale Montvale series-c+ 1083024000 2004 5000000 /company/the-feedroom public_relations Ridgewood Capital https://www.crunchbase.com/financial-organization/ridgewood-capital
3363 3363 1324 /financial-organization/rre-ventures RRE Ventures   USA NY New York New York angel 1280102400 2010 1000000 /company/sailthru public_relations RRE Ventures https://www.crunchbase.com/financial-organization/rre-ventures
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
3417 3417 1324 /financial-organization/rre-ventures RRE Ventures   USA NY New York New York series-b 1360540800 2013 19000000 /company/sailthru public_relations RRE Ventures https://www.crunchbase.com/financial-organization/rre-ventures
3437 3437 959 /financial-organization/rre-ventures RRE Ventures   USA NY New York New York angel 1372723200 2013 500000 /company/mingyian public_relations RRE Ventures https://www.crunchbase.com/financial-organization/rre-ventures
3647 3647 1360 /financial-organization/southpaw-asset-management Southpaw Asset Management   USA CT New York Greenwich series-c+ 1222646400 2008 14000000 /company/sendwordnow public_relations Southpaw Asset Management https://www.crunchbase.com/financial-organization/southpaw-asset-management
3648 3648 1360 /financial-organization/southpaw-asset-management Southpaw Asset Management   USA CT New York Greenwich series-c+ 1191888000 2007 8500000 /company/sendwordnow public_relations Southpaw Asset Management https://www.crunchbase.com/financial-organization/southpaw-asset-management
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
3682 3682 640 /financial-organization/spark-capital Spark Capital   USA MA Boston Boston series-b 1305158400 2011 10000000 /company/group-commerce public_relations Spark Capital https://www.crunchbase.com/financial-organization/spark-capital
3690 3690 640 /financial-organization/spark-capital Spark Capital   USA MA Boston Boston series-c+ 1338249600 2012 21000000 /company/group-commerce public_relations Spark Capital https://www.crunchbase.com/financial-organization/spark-capital
3873 3873 1572 /financial-organization/telesoft-partners TeleSoft Partners   USA CA SF Bay Foster City series-b 966902400 2000 30000000 /company/the-feedroom public_relations TeleSoft Partners https://www.crunchbase.com/financial-organization/telesoft-partners
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
3981 3981 1572 /financial-organization/tribune-ventures Tribune Strategic Investments   USA IL Chicago Chicago series-b 966902400 2000 30000000 /company/the-feedroom public_relations Tribune Strategic Investments https://www.crunchbase.com/financial-organization/tribune-ventures
4113 4113 399 /financial-organization/vantagepoint-capital-partners VantagePoint Capital Partners   USA CA SF Bay San Bruno series-c+ 1109635200 2005 60000000 /company/datranmedia public_relations VantagePoint Capital Partners https://www.crunchbase.com/financial-organization/vantagepoint-capital-partners
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
4219 4219 1572 /financial-organization/warburg-pincus Warburg Pincus   USA NY New York New York series-b 966902400 2000 30000000 /company/the-feedroom public_relations Warburg Pincus https://www.crunchbase.com/financial-organization/warburg-pincus
4220 4220 1572 /financial-organization/warburg-pincus Warburg Pincus   USA NY New York New York series-c+ 1032048000 2002 5000000 /company/the-feedroom public_relations Warburg Pincus https://www.crunchbase.com/financial-organization/warburg-pincus
4221 4221 1572 /financial-organization/warburg-pincus Warburg Pincus   USA NY New York New York series-c+ 1083024000 2004 5000000 /company/the-feedroom public_relations Warburg Pincus https://www.crunchbase.com/financial-organization/warburg-pincus
4249 4249 545 /financial-organization/wheatley-partners Wheatley Partners   USA NY New York Great Neck series-b 1199145600 2008 5300000 /company/fifthgenerationsystems public_relations Wheatley Partners https://www.crunchbase.com/financial-organization/wheatley-partners

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 '');