Investments

7 rows where Company_category_code = "design", 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, investor_category_code, 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
7 7 113 /company/alt-option-return Alt Option Return   USA NY New York New York angel 1290556800 2010 1250000 /company/art-sy design Alt Option Return https://www.crunchbase.com/company/alt-option-return
67 67 828 /company/betaworks betaworks social USA NY New York New York angel 1311120000 2011 600000 /company/lascaux-co design betaworks https://www.crunchbase.com/company/betaworks
1712 1712 113 /financial-organization/founder-collective Founder Collective   USA NY New York New York angel 1290556800 2010 1250000 /company/art-sy design Founder Collective https://www.crunchbase.com/financial-organization/founder-collective
1740 1740 1351 /financial-organization/founder-collective Founder Collective   USA NY New York New York series-a 1329696000 2012 1500000 /company/see-me-group design Founder Collective https://www.crunchbase.com/financial-organization/founder-collective
1747 1747 113 /financial-organization/founder-collective Founder Collective   USA NY New York New York angel 1262304000 2010 50000 /company/art-sy design Founder Collective https://www.crunchbase.com/financial-organization/founder-collective
3904 3904 113 /financial-organization/thrive-capital Thrive Capital   USA NY New York New York angel 1290556800 2010 1250000 /company/art-sy design Thrive Capital https://www.crunchbase.com/financial-organization/thrive-capital
3913 3913 113 /financial-organization/thrive-capital Thrive Capital   USA NY New York New York series-a 1320278400 2011 6000000 /company/art-sy design Thrive Capital https://www.crunchbase.com/financial-organization/thrive-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 '');