Investments

10 rows where funding_round_type = "series-a" and investor_name = "Esther Dyson"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Company, funded_at, funded_year, raised_amount_usd, gristHelper_Display2, Company_category_code

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
4790 4790 1116 /person/esther-dyson Esther Dyson       unknown   series-a 1191196800 2007 1500000 /company/outside-in web Esther Dyson https://www.crunchbase.com/person/esther-dyson
4791 4791 1111 /person/esther-dyson Esther Dyson       unknown   series-a 1212278400 2008 2300000 /company/healthcare-health-human-powered-search other Esther Dyson https://www.crunchbase.com/person/esther-dyson
4795 4795 569 /person/esther-dyson Esther Dyson       unknown   series-a 1274659200 2010 800000 /company/fluidinfo enterprise Esther Dyson https://www.crunchbase.com/person/esther-dyson
4797 4797 268 /person/esther-dyson Esther Dyson       unknown   series-a 1312848000 2011 4100000 /company/challengepost web Esther Dyson https://www.crunchbase.com/person/esther-dyson
4800 4800 1465 /person/esther-dyson Esther Dyson       unknown   series-a 1323302400 2011   /company/sponsorhub finance Esther Dyson https://www.crunchbase.com/person/esther-dyson
4801 4801 1465 /person/esther-dyson Esther Dyson       unknown   series-a 1323302400 2011   /company/sponsorhub finance Esther Dyson https://www.crunchbase.com/person/esther-dyson
4802 4802 1824 /person/esther-dyson Esther Dyson       unknown   series-a 1326067200 2012 1500000 /company/zeel health Esther Dyson https://www.crunchbase.com/person/esther-dyson
4803 4803 529 /person/esther-dyson Esther Dyson       unknown   series-a 1243814400 2009 2000000 /company/fancy web Esther Dyson https://www.crunchbase.com/person/esther-dyson
4806 4806 73 /person/esther-dyson Esther Dyson       unknown   series-a 1352764800 2012 3200000 /company/amicus nonprofit Esther Dyson https://www.crunchbase.com/person/esther-dyson
4807 4807 1154 /person/esther-dyson Esther Dyson       unknown   series-a 1346457600 2012   /company/payperks finance Esther Dyson https://www.crunchbase.com/person/esther-dyson

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