Investments

7 rows where gristHelper_Display2 = "/company/mypublisher"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: investor_country_code, investor_state_code, investor_region, investor_city

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
2775 2775 1016 /financial-organization/mousse-partners Mousse Partners   USA NY New York New York series-b 1188604800 2007 8900000 /company/mypublisher web Mousse Partners https://www.crunchbase.com/financial-organization/mousse-partners
2937 2937 1016 /financial-organization/novestra Novestra   SWE   Stockholm Stockholm series-b 1188604800 2007 8900000 /company/mypublisher web Novestra https://www.crunchbase.com/financial-organization/novestra
4488 4488 1016 /person/carl-navarre Carl Navarre       unknown   series-b 1188604800 2007 8900000 /company/mypublisher web Carl Navarre https://www.crunchbase.com/person/carl-navarre
5039 5039 1016 /person/jerome-york Jerome York       unknown   series-b 1188604800 2007 8900000 /company/mypublisher web Jerome York https://www.crunchbase.com/person/jerome-york
5791 5791 1016 /person/thorpe-mckenzie Thorpe McKenzie       unknown   series-b 1188604800 2007 8900000 /company/mypublisher web Thorpe McKenzie https://www.crunchbase.com/person/thorpe-mckenzie
5849 5849 1016 /person/w-b-avery W.B. Avery       unknown   series-b 1188604800 2007 8900000 /company/mypublisher web W.B. Avery https://www.crunchbase.com/person/w-b-avery
5851 5851 1016 /person/ward-woods Ward Woods       unknown   series-b 1188604800 2007 8900000 /company/mypublisher web Ward Woods https://www.crunchbase.com/person/ward-woods

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