Investments

8 rows where Company_category_code = "web" and investor_permalink = "/person/esther-dyson"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Company, funding_round_type, funded_year, gristHelper_Display2

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
4789 4789 1116 /person/esther-dyson Esther Dyson       unknown   angel 1170288000 2007 900000 /company/outside-in web Esther Dyson https://www.crunchbase.com/person/esther-dyson
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
4792 4792 1755 /person/esther-dyson Esther Dyson       unknown   angel 1220227200 2008 270000 /company/wee-web web Esther Dyson https://www.crunchbase.com/person/esther-dyson
4793 4793 268 /person/esther-dyson Esther Dyson       unknown   angel 1246233600 2009 500000 /company/challengepost web Esther Dyson https://www.crunchbase.com/person/esther-dyson
4796 4796 332 /person/esther-dyson Esther Dyson       unknown   other 1311984000 2011 300000 /company/consumerbell web 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
4799 4799 1695 /person/esther-dyson Esther Dyson       unknown   angel 1326240000 2012 500000 /company/urtak web 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

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