Investments

7 rows where investor_city = "New York" and investor_name = "PKS Capital"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Company, funding_round_type, 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
3100 3100 268 /financial-organization/pks-capital PKS Capital   USA NY New York New York angel 1246233600 2009 500000 /company/challengepost web PKS Capital https://www.crunchbase.com/financial-organization/pks-capital
3101 3101 835 /financial-organization/pks-capital PKS Capital   USA NY New York New York angel 1251676800 2009 1100000 /company/learnvest finance PKS Capital https://www.crunchbase.com/financial-organization/pks-capital
3102 3102 1688 /financial-organization/pks-capital PKS Capital   USA NY New York New York angel 1300060800 2011 500000 /company/upnext mobile PKS Capital https://www.crunchbase.com/financial-organization/pks-capital
3103 3103 1347 /financial-organization/pks-capital PKS Capital   USA NY New York New York angel 1262908800 2010 550000 /company/seatgeek search PKS Capital https://www.crunchbase.com/financial-organization/pks-capital
3104 3104 1347 /financial-organization/pks-capital PKS Capital   USA NY New York New York series-a 1286928000 2010 550000 /company/seatgeek search PKS Capital https://www.crunchbase.com/financial-organization/pks-capital
3105 3105 835 /financial-organization/pks-capital PKS Capital   USA NY New York New York series-b 1310428800 2011 19000000 /company/learnvest finance PKS Capital https://www.crunchbase.com/financial-organization/pks-capital
3106 3106 110 /financial-organization/pks-capital PKS Capital   USA NY New York New York angel 1320192000 2011 390000 /company/artsicle ecommerce PKS Capital https://www.crunchbase.com/financial-organization/pks-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 '');