Investments

40 rows where Company_category_code = "public_relations", investor_city = "New York" and investor_country_code = "USA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Company, investor_permalink, investor_name, funding_round_type, funded_at, funded_year, raised_amount_usd, gristHelper_Display2, Investor

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
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
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
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
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
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
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
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
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
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
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
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
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

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