Investments
5 rows where funding_round_type = "series-c+" and gristHelper_Display2 = "/company/fancy" sorted by investor_category_code
This data as json, CSV (advanced)
Suggested facets: investor_category_code, investor_country_code, investor_region, funded_at, raised_amount_usd
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4663 | 4663 | 529 | /person/david-perry-2 | David Perry | unknown | series-c+ | 1378684800 | 2013 | 7000000 | /company/fancy | web | David Perry https://www.crunchbase.com/person/david-perry-2 | ||||
5267 | 5267 | 529 | /person/len-blavatnik | Len Blavatnik | unknown | series-c+ | 1373241600 | 2013 | 53000000 | /company/fancy | web | Len Blavatnik https://www.crunchbase.com/person/len-blavatnik | ||||
5565 | 5565 | 529 | /person/richard-c-perry | Richard C. Perry | unknown | series-c+ | 1378684800 | 2013 | 7000000 | /company/fancy | web | Richard C. Perry https://www.crunchbase.com/person/richard-c-perry | ||||
5860 | 5860 | 529 | /person/will-smith-7 | Will Smith | unknown | series-c+ | 1373241600 | 2013 | 53000000 | /company/fancy | web | Will Smith https://www.crunchbase.com/person/will-smith-7 | ||||
21 | 21 | 529 | /company/americanexpress | American Express | other | USA | TBD | series-c+ | 1373241600 | 2013 | 53000000 | /company/fancy | web | American Express https://www.crunchbase.com/company/americanexpress |
Advanced export
JSON shape: default, array, newline-delimited, object
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 '');