Investments

27 rows where Company_category_code = "news" and investor_city = "New York"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Company, investor_permalink, investor_name, funding_round_type, funded_at, funded_year, raised_amount_usd, gristHelper_Display2, Investor

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
1293 1293 1207 /financial-organization/digital-news-ventures Digital News Ventures   USA NY New York New York angel 1362096000 2013 1400000 /company/policymic news Digital News Ventures https://www.crunchbase.com/financial-organization/digital-news-ventures
1701 1701 231 /financial-organization/founder-collective Founder Collective   USA NY New York New York series-b 1273622400 2010 8000000 /company/buzzfeed news Founder Collective https://www.crunchbase.com/financial-organization/founder-collective
1964 1964 1573 /financial-organization/greycroft-partners Greycroft Partners   USA NY New York New York series-a 1154390400 2006 5000000 /company/huffingtonpost news Greycroft Partners https://www.crunchbase.com/financial-organization/greycroft-partners
1965 1965 1573 /financial-organization/greycroft-partners Greycroft Partners   USA NY New York New York series-b 1188604800 2007 5000000 /company/huffingtonpost news Greycroft Partners https://www.crunchbase.com/financial-organization/greycroft-partners
1972 1972 136 /financial-organization/greycroft-partners Greycroft Partners   USA NY New York New York series-a 1242086400 2009 1250000 /company/babble news Greycroft Partners https://www.crunchbase.com/financial-organization/greycroft-partners
1974 1974 136 /financial-organization/greycroft-partners Greycroft Partners   USA NY New York New York series-b 1274400000 2010 3000000 /company/babble news Greycroft Partners https://www.crunchbase.com/financial-organization/greycroft-partners
1988 1988 1782 /financial-organization/greycroft-partners Greycroft Partners   USA NY New York New York series-a 1368403200 2013 4750000 /company/whochit news Greycroft Partners https://www.crunchbase.com/financial-organization/greycroft-partners
2047 2047 231 /financial-organization/hearst-interactive-media Hearst Ventures   USA NY New York New York series-a 1215561600 2008 3500000 /company/buzzfeed news Hearst Ventures https://www.crunchbase.com/financial-organization/hearst-interactive-media
2050 2050 231 /financial-organization/hearst-interactive-media Hearst Ventures   USA NY New York New York series-b 1273622400 2010 8000000 /company/buzzfeed news Hearst Ventures https://www.crunchbase.com/financial-organization/hearst-interactive-media
2055 2055 231 /financial-organization/hearst-interactive-media Hearst Ventures   USA NY New York New York series-c+ 1326067200 2012 15500000 /company/buzzfeed news Hearst Ventures https://www.crunchbase.com/financial-organization/hearst-interactive-media
2467 2467 1212 /financial-organization/lerer-ventures Lerer Ventures   USA NY New York New York series-a 1296691200 2011 1000000 /company/popdust news Lerer Ventures https://www.crunchbase.com/financial-organization/lerer-ventures
2491 2491 231 /financial-organization/lerer-ventures Lerer Ventures   USA NY New York New York series-c+ 1326067200 2012 15500000 /company/buzzfeed news Lerer Ventures https://www.crunchbase.com/financial-organization/lerer-ventures
2506 2506 1595 /financial-organization/lerer-ventures Lerer Ventures   USA NY New York New York series-a 1345075200 2012 13100000 /company/thrillist-media-group news Lerer Ventures https://www.crunchbase.com/financial-organization/lerer-ventures
2507 2507 1596 /financial-organization/lerer-ventures Lerer Ventures   USA NY New York New York series-a 1345075200 2012 13000000 /company/thrillist-com news Lerer Ventures https://www.crunchbase.com/financial-organization/lerer-ventures
2514 2514 231 /financial-organization/lerer-ventures Lerer Ventures   USA NY New York New York series-c+ 1357171200 2013 19300000 /company/buzzfeed news Lerer Ventures https://www.crunchbase.com/financial-organization/lerer-ventures
2526 2526 1404 /financial-organization/lerer-ventures Lerer Ventures   USA NY New York New York angel 1368576000 2013 1100000 /company/skift news Lerer Ventures https://www.crunchbase.com/financial-organization/lerer-ventures
2698 2698 1404 /financial-organization/mesa MESA+   USA NY New York New York angel 1368576000 2013 1100000 /company/skift news MESA+ https://www.crunchbase.com/financial-organization/mesa
2934 2934 1225 /financial-organization/noson-lawen-partners Noson Lawen Partners   USA NY New York New York angel 1342656000 2012   /company/privcap news Noson Lawen Partners https://www.crunchbase.com/financial-organization/noson-lawen-partners
3077 3077 1595 /financial-organization/pilot-group Pilot Group   USA NY New York New York series-a 1345075200 2012 13100000 /company/thrillist-media-group news Pilot Group https://www.crunchbase.com/financial-organization/pilot-group
3078 3078 1596 /financial-organization/pilot-group Pilot Group   USA NY New York New York series-a 1345075200 2012 13000000 /company/thrillist-com news Pilot Group https://www.crunchbase.com/financial-organization/pilot-group
3108 3108 136 /financial-organization/plough-penny-partners Plough Penny Partners   USA NY New York New York series-b 1274400000 2010 3000000 /company/babble news Plough Penny Partners https://www.crunchbase.com/financial-organization/plough-penny-partners
3359 3359 231 /financial-organization/rre-ventures RRE Ventures   USA NY New York New York series-b 1273622400 2010 8000000 /company/buzzfeed news RRE Ventures https://www.crunchbase.com/financial-organization/rre-ventures
3373 3373 1212 /financial-organization/rre-ventures RRE Ventures   USA NY New York New York series-a 1296691200 2011 1000000 /company/popdust news RRE Ventures https://www.crunchbase.com/financial-organization/rre-ventures
3398 3398 231 /financial-organization/rre-ventures RRE Ventures   USA NY New York New York series-c+ 1326067200 2012 15500000 /company/buzzfeed news RRE Ventures https://www.crunchbase.com/financial-organization/rre-ventures
3405 3405 1212 /financial-organization/rre-ventures RRE Ventures   USA NY New York New York series-a 1338768000 2012 4500000 /company/popdust news RRE Ventures https://www.crunchbase.com/financial-organization/rre-ventures
3413 3413 231 /financial-organization/rre-ventures RRE Ventures   USA NY New York New York series-c+ 1357171200 2013 19300000 /company/buzzfeed news RRE Ventures https://www.crunchbase.com/financial-organization/rre-ventures
3430 3430 1573 /financial-organization/rre-ventures RRE Ventures   USA NY New York New York venture 1280620800 2010   /company/huffingtonpost news RRE Ventures https://www.crunchbase.com/financial-organization/rre-ventures

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