Investments

9 rows where investor_category_code = "news" sorted by investor_category_code descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Company, investor_permalink, investor_name, investor_state_code, investor_region, funded_year, raised_amount_usd, gristHelper_Display2, Company_category_code, Investor

funding_round_type 3 ✖

investor_city 2 ✖

investor_country_code 1 ✖

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
100 100 1571 /company/cbs CBS news USA CA California - Other   series-a 1172448000 2007 7000000 /company/the-electric-sheep advertising CBS https://www.crunchbase.com/company/cbs
200 200 46 /company/iac IAC news USA NY New York New York series-a 1329177600 2012 20500000 /company/aereo web IAC https://www.crunchbase.com/company/iac
251 251 97 /company/newyorktimes New York Times news USA NY New York New York series-a 1223337600 2008 3100000 /company/appssavvy advertising New York Times https://www.crunchbase.com/company/newyorktimes
252 252 159 /company/newyorktimes New York Times news USA NY New York New York series-b 1268265600 2010 20000000 /company/betaworks social New York Times https://www.crunchbase.com/company/newyorktimes
253 253 35 /company/newyorktimes New York Times news USA NY New York New York series-a 1284508800 2010 8000000 /company/ak-networks advertising New York Times https://www.crunchbase.com/company/newyorktimes
254 254 786 /company/newyorktimes New York Times news USA NY New York New York series-a 1283299200 2010 8000000 /company/keep-holdings fashion New York Times https://www.crunchbase.com/company/newyorktimes
255 255 1481 /company/newyorktimes New York Times news USA NY New York New York series-a 1343174400 2012 1500000 /company/stamped mobile New York Times https://www.crunchbase.com/company/newyorktimes
257 257 163 /company/newscorporation News Corp news USA NY New York New York series-b 1271894400 2010 10000000 /company/beyond-oblivion music News Corp https://www.crunchbase.com/company/newscorporation
258 258 163 /company/newscorporation News Corp news USA NY New York New York venture 1299456000 2011 77000000 /company/beyond-oblivion music News Corp https://www.crunchbase.com/company/newscorporation

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