Investments

9 rows where Company_category_code = "advertising" and gristHelper_Display2 = "/company/adstruc"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: investor_category_code, investor_country_code, investor_state_code, investor_region, 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
322 322 41 /company/techstars Techstars finance USA CO Denver Boulder angel 1280966400 2010 18000 /company/adstruc advertising Techstars https://www.crunchbase.com/company/techstars
1265 1265 41 /financial-organization/dfj-gotham-ventures DFJ Gotham Ventures   USA NY New York New York angel 1285632000 2010 1100000 /company/adstruc advertising DFJ Gotham Ventures https://www.crunchbase.com/financial-organization/dfj-gotham-ventures
1708 1708 41 /financial-organization/founder-collective Founder Collective   USA NY New York New York angel 1285632000 2010 1100000 /company/adstruc advertising Founder Collective https://www.crunchbase.com/financial-organization/founder-collective
3365 3365 41 /financial-organization/rre-ventures RRE Ventures   USA NY New York New York angel 1285632000 2010 1100000 /company/adstruc advertising RRE Ventures https://www.crunchbase.com/financial-organization/rre-ventures
3577 3577 41 /financial-organization/social-leverage Social Leverage   USA AZ Phoenix Phoenix angel 1285632000 2010 1100000 /company/adstruc advertising Social Leverage https://www.crunchbase.com/financial-organization/social-leverage
3634 3634 41 /financial-organization/softtech-vc SoftTech VC   USA CA SF Bay Palo Alto angel 1285632000 2010 1100000 /company/adstruc advertising SoftTech VC https://www.crunchbase.com/financial-organization/softtech-vc
4632 4632 41 /person/david-cohen David Cohen       unknown   angel 1285632000 2010 1100000 /company/adstruc advertising David Cohen https://www.crunchbase.com/person/david-cohen
4678 4678 41 /person/david-tisch David Tisch       unknown   angel 1285632000 2010 1100000 /company/adstruc advertising David Tisch https://www.crunchbase.com/person/david-tisch
5192 5192 41 /person/kal-vepuri Kal Vepuri       unknown   angel 1285632000 2010 1100000 /company/adstruc advertising Kal Vepuri https://www.crunchbase.com/person/kal-vepuri

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