Investments
9 rows where Company_category_code = "advertising" and investor_city = "La Jolla" sorted by Company_category_code
This data as json, CSV (advanced)
Suggested facets: Company, funded_year, gristHelper_Display2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
712 | 712 | 1182 | /financial-organization/avalon-ventures | Avalon Ventures | USA | CA | San Diego | La Jolla | series-a | 1231200000 | 2009 | 1250000 | /company/pictela | advertising | Avalon Ventures https://www.crunchbase.com/financial-organization/avalon-ventures | |
713 | 713 | 1393 | /financial-organization/avalon-ventures | Avalon Ventures | USA | CA | San Diego | La Jolla | series-a | 1236297600 | 2009 | 4000000 | /company/simulmedia | advertising | Avalon Ventures https://www.crunchbase.com/financial-organization/avalon-ventures | |
714 | 714 | 1182 | /financial-organization/avalon-ventures | Avalon Ventures | USA | CA | San Diego | La Jolla | venture | 1264118400 | 2010 | 1499999 | /company/pictela | advertising | Avalon Ventures https://www.crunchbase.com/financial-organization/avalon-ventures | |
715 | 715 | 1393 | /financial-organization/avalon-ventures | Avalon Ventures | USA | CA | San Diego | La Jolla | series-b | 1271808000 | 2010 | 8000000 | /company/simulmedia | advertising | Avalon Ventures https://www.crunchbase.com/financial-organization/avalon-ventures | |
717 | 717 | 1543 | /financial-organization/avalon-ventures | Avalon Ventures | USA | CA | San Diego | La Jolla | series-a | 1299110400 | 2011 | 1800000 | /company/tapad | advertising | Avalon Ventures https://www.crunchbase.com/financial-organization/avalon-ventures | |
719 | 719 | 1393 | /financial-organization/avalon-ventures | Avalon Ventures | USA | CA | San Diego | La Jolla | series-c+ | 1335744000 | 2012 | 6000000 | /company/simulmedia | advertising | Avalon Ventures https://www.crunchbase.com/financial-organization/avalon-ventures | |
721 | 721 | 1357 | /financial-organization/avalon-ventures | Avalon Ventures | USA | CA | San Diego | La Jolla | series-a | 1350604800 | 2012 | 2000000 | /company/selectable-media | advertising | Avalon Ventures https://www.crunchbase.com/financial-organization/avalon-ventures | |
723 | 723 | 1393 | /financial-organization/avalon-ventures | Avalon Ventures | USA | CA | San Diego | La Jolla | series-c+ | 1360540800 | 2013 | 5000000 | /company/simulmedia | advertising | Avalon Ventures https://www.crunchbase.com/financial-organization/avalon-ventures | |
724 | 724 | 1543 | /financial-organization/avalon-ventures | Avalon Ventures | USA | CA | San Diego | La Jolla | series-b | 1363824000 | 2013 | 6500000 | /company/tapad | advertising | Avalon Ventures https://www.crunchbase.com/financial-organization/avalon-ventures |
Advanced export
JSON shape: default, array, newline-delimited, object
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 '');