Investments

12 rows where Company_category_code = "biotech", 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
587 587 171 /financial-organization/aisling-capital Aisling Capital   USA NY New York New York venture 1177891200 2007 7410000 /company/bioenvision biotech Aisling Capital https://www.crunchbase.com/financial-organization/aisling-capital
609 609 990 /financial-organization/amphion-innovations Amphion Innovations   USA NY New York New York series-c+ 1175731200 2007 1000000 /company/motif-biosciences biotech Amphion Innovations https://www.crunchbase.com/financial-organization/amphion-innovations
610 610 990 /financial-organization/amphion-innovations Amphion Innovations   USA NY New York New York venture 1141257600 2006 1870000 /company/motif-biosciences biotech Amphion Innovations https://www.crunchbase.com/financial-organization/amphion-innovations
693 693 306 /financial-organization/ascent-biomedical-ventures Ascent Biomedical Ventures   USA NY New York New York series-b 1342396800 2012 12000000 /company/coferon biotech Ascent Biomedical Ventures https://www.crunchbase.com/financial-organization/ascent-biomedical-ventures
1389 1389 840 /financial-organization/emigrant-capital Emigrant Capital   USA NY New York New York venture 1161561600 2006 21000000 /company/lev-pharmaceuticals biotech Emigrant Capital https://www.crunchbase.com/financial-organization/emigrant-capital
1651 1651 170 /financial-organization/firstmark-capital FirstMark Capital   USA NY New York New York series-a 1379980800 2013 4000000 /company/biodigital biotech FirstMark Capital https://www.crunchbase.com/financial-organization/firstmark-capital
2655 2655 339 /financial-organization/maxim-group Maxim Group   USA NY New York New York series-b 1288051200 2010 12000000 /company/contrafect biotech Maxim Group https://www.crunchbase.com/financial-organization/maxim-group
2913 2913 514 /financial-organization/ngn-capital NGN Capital   USA NY New York New York series-a 1273536000 2010 20000000 /company/exosome-diagnostics biotech NGN Capital https://www.crunchbase.com/financial-organization/ngn-capital
2959 2959 170 /financial-organization/nyu-innovation-venture-fund NYU Innovation Venture Fund   USA NY New York New York series-a 1379980800 2013 4000000 /company/biodigital biotech NYU Innovation Venture Fund https://www.crunchbase.com/financial-organization/nyu-innovation-venture-fund
3014 3014 734 /financial-organization/orbimed-advisors OrbiMed Advisors   USA NY New York New York series-c+ 1344556800 2012 30000000 /company/intercept-pharmaceuticals biotech OrbiMed Advisors https://www.crunchbase.com/financial-organization/orbimed-advisors
3473 3473 171 /financial-organization/sco-capital-partners SCO Capital Partners   USA NY New York New York venture 1177891200 2007 7410000 /company/bioenvision biotech SCO Capital Partners https://www.crunchbase.com/financial-organization/sco-capital-partners
4243 4243 708 /financial-organization/wfd-ventures WFD Ventures   USA NY New York New York series-a 1235174400 2009 5450000 /company/imacor biotech WFD Ventures https://www.crunchbase.com/financial-organization/wfd-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 '');