Investments

26 rows where Company_category_code = "cleantech" and investor_state_code = "NY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Company, investor_permalink, investor_name, investor_country_code, investor_region, investor_city, 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
313 313 1540 /company/tamra-tacoma-capital-partners Tamra-Tacoma Capital Partners cleantech USA NY New York New York venture 1328054400 2012 2250000 /company/tamra-tacoma-capital-partners cleantech Tamra-Tacoma Capital Partners https://www.crunchbase.com/company/tamra-tacoma-capital-partners
314 314 1691 /company/tamra-tacoma-capital-partners Tamra-Tacoma Capital Partners cleantech USA NY New York New York venture 1375833600 2013 20000000 /company/urban-green-energy cleantech Tamra-Tacoma Capital Partners https://www.crunchbase.com/company/tamra-tacoma-capital-partners
453 453 1554 /financial-organization/21ventures 21Ventures   USA NY New York New York series-a 1209254400 2008 8000000 /company/technospin cleantech 21Ventures https://www.crunchbase.com/financial-organization/21ventures
454 454 48 /financial-organization/21ventures 21Ventures   USA NY New York New York angel 1265587200 2010 500000 /company/aerofarms cleantech 21Ventures https://www.crunchbase.com/financial-organization/21ventures
505 505 487 /financial-organization/acadia-woods-partners Acadia Woods Partners   USA NY New York - Other   series-b 1314230400 2011 14500000 /company/energyhub cleantech Acadia Woods Partners https://www.crunchbase.com/financial-organization/acadia-woods-partners
945 945 749 /financial-organization/braemar-energy-ventures Braemar Energy Ventures   USA NY New York New York series-b 1302652800 2011 21000000 /company/ioxus cleantech Braemar Energy Ventures https://www.crunchbase.com/financial-organization/braemar-energy-ventures
1039 1039 456 /financial-organization/cayuga-venture-fund Cayuga Venture Fund   USA NY Ithaca Ithaca series-a 1264204800 2010 3400000 /company/e2e-materials cleantech Cayuga Venture Fund https://www.crunchbase.com/financial-organization/cayuga-venture-fund
1092 1092 1118 /financial-organization/clearpoint-ventures Clearpoint Ventures   USA NY New York New York series-a 1242950400 2009 20000000 /company/ownenergy cleantech Clearpoint Ventures https://www.crunchbase.com/financial-organization/clearpoint-ventures
1142 1142 1118 /financial-organization/contour-ventures Contour Venture Partners   USA NY New York New York venture 1223596800 2008   /company/ownenergy cleantech Contour Venture Partners https://www.crunchbase.com/financial-organization/contour-ventures
1442 1442 456 /financial-organization/excell-partners Excell Partners   USA NY Rochester Rochester series-a 1264204800 2010 3400000 /company/e2e-materials cleantech Excell Partners https://www.crunchbase.com/financial-organization/excell-partners
1445 1445 355 /financial-organization/expansion-capital-partners Expansion Capital Partners   USA NY New York New York series-b 1240790400 2009 10680000 /company/cpower cleantech Expansion Capital Partners https://www.crunchbase.com/financial-organization/expansion-capital-partners
1446 1446 355 /financial-organization/expansion-capital-partners Expansion Capital Partners   USA NY New York New York series-a 1190851200 2007 17000000 /company/cpower cleantech Expansion Capital Partners https://www.crunchbase.com/financial-organization/expansion-capital-partners
1914 1914 505 /financial-organization/good-energies Good Energies   USA NY New York New York venture 1251244800 2009 55000000 /company/everpower cleantech Good Energies https://www.crunchbase.com/financial-organization/good-energies
2101 2101 125 /financial-organization/high-peaks-venture-partners High Peaks Venture Partners   USA NY New York New York venture 1139184000 2006   /company/auterra cleantech High Peaks Venture Partners https://www.crunchbase.com/financial-organization/high-peaks-venture-partners
2160 2160 1224 /financial-organization/i2bf I2BF Venture Capital   GBR NY New York New York venture 1322784000 2011 4400000 /company/prism-solar-technologies cleantech I2BF Venture Capital https://www.crunchbase.com/financial-organization/i2bf
2875 2875 355 /financial-organization/new-york-city-investment-fund New York City Investment Fund   USA NY New York New York series-b 1240790400 2009 10680000 /company/cpower cleantech New York City Investment Fund https://www.crunchbase.com/financial-organization/new-york-city-investment-fund
2877 2877 1118 /financial-organization/new-york-city-investment-fund New York City Investment Fund   USA NY New York New York venture 1223596800 2008   /company/ownenergy cleantech New York City Investment Fund https://www.crunchbase.com/financial-organization/new-york-city-investment-fund
2879 2879 355 /financial-organization/new-york-city-investment-fund New York City Investment Fund   USA NY New York New York series-a 1190851200 2007 17000000 /company/cpower cleantech New York City Investment Fund https://www.crunchbase.com/financial-organization/new-york-city-investment-fund
2882 2882 487 /financial-organization/new-york-city-investment-fund New York City Investment Fund   USA NY New York New York series-b 1314230400 2011 14500000 /company/energyhub cleantech New York City Investment Fund https://www.crunchbase.com/financial-organization/new-york-city-investment-fund
3007 3007 946 /financial-organization/oppenheimer-co-inc Oppenheimer & Co., Inc.   USA NY New York New York venture 1218499200 2008   /company/mercury-solar-systems cleantech Oppenheimer & Co., Inc. https://www.crunchbase.com/financial-organization/oppenheimer-co-inc
3202 3202 1437 /financial-organization/rand-capital Rand Capital   USA NY Buffalo Buffalo series-b 1228262400 2008 250000 /company/soms-technologies cleantech Rand Capital https://www.crunchbase.com/financial-organization/rand-capital
3301 3301 456 /financial-organization/rochester-angel-network Rochester Angel Network   USA NY West Henrietta West Henrietta series-a 1264204800 2010 3400000 /company/e2e-materials cleantech Rochester Angel Network https://www.crunchbase.com/financial-organization/rochester-angel-network
3347 3347 1276 /financial-organization/rre-ventures RRE Ventures   USA NY New York New York series-b 1204329600 2008 30000000 /company/recyclebank cleantech RRE Ventures https://www.crunchbase.com/financial-organization/rre-ventures
3349 3349 1276 /financial-organization/rre-ventures RRE Ventures   USA NY New York New York series-a 1178668800 2007 13100000 /company/recyclebank cleantech RRE Ventures https://www.crunchbase.com/financial-organization/rre-ventures
3351 3351 1276 /financial-organization/rre-ventures RRE Ventures   USA NY New York New York venture 1257033600 2009 28000000 /company/recyclebank cleantech RRE Ventures https://www.crunchbase.com/financial-organization/rre-ventures
3376 3376 1276 /financial-organization/rre-ventures RRE Ventures   USA NY New York New York series-c+ 1298332800 2011 14000000 /company/recyclebank cleantech RRE Ventures https://www.crunchbase.com/financial-organization/rre-ventures

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