Investments

60 rows where investor_state_code = "PA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: investor_permalink, investor_name, investor_category_code, investor_region, investor_city, funding_round_type, funded_year, Company_category_code, 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
31 31 1311 /company/bachmann-industries Bachmann Industries   USA PA Philadelphia Philadelphia series-b 1221523200 2008 5000000 /company/robotgalaxy games_video Bachmann Industries https://www.crunchbase.com/company/bachmann-industries
32 32 1311 /company/bachmann-industries Bachmann Industries   USA PA Philadelphia Philadelphia series-a 1167609600 2007 7000000 /company/robotgalaxy games_video Bachmann Industries https://www.crunchbase.com/company/bachmann-industries
275 275 1801 /company/qvc QVC other USA PA Pennsylvania - Other   series-c+ 924134400 1999 15000000 /company/xo-group web QVC https://www.crunchbase.com/company/qvc
291 291 930 /company/safeguard-scientifics Safeguard Scientifics finance USA PA Philadelphia Wayne venture 1249430400 2009 10000000 /company/mediamath advertising Safeguard Scientifics https://www.crunchbase.com/company/safeguard-scientifics
292 292 936 /company/safeguard-scientifics Safeguard Scientifics finance USA PA Philadelphia Wayne series-a 1321488000 2011 7000000 /company/medivo enterprise Safeguard Scientifics https://www.crunchbase.com/company/safeguard-scientifics
293 293 1464 /company/safeguard-scientifics Safeguard Scientifics finance USA PA Philadelphia Wayne series-b 1328572800 2012 10000000 /company/spongecell advertising Safeguard Scientifics https://www.crunchbase.com/company/safeguard-scientifics
294 294 88 /company/safeguard-scientifics Safeguard Scientifics finance USA PA Philadelphia Wayne series-b 1354752000 2012 8700000 /company/appfirst analytics Safeguard Scientifics https://www.crunchbase.com/company/safeguard-scientifics
295 295 936 /company/safeguard-scientifics Safeguard Scientifics finance USA PA Philadelphia Wayne series-b 1371427200 2013 15000000 /company/medivo enterprise Safeguard Scientifics https://www.crunchbase.com/company/safeguard-scientifics
959 959 1461 /financial-organization/bucknell-venture-plan-competition Bucknell Venture Plan Competition   USA PA Lewisburg Lewisburg angel 1296518400 2011 50000 /company/spling advertising Bucknell Venture Plan Competition https://www.crunchbase.com/financial-organization/bucknell-venture-plan-competition
1187 1187 1126 /financial-organization/cross-atlantic-capital-partners Cross Atlantic Capital Partners   USA PA Philadelphia Radnor series-a 1241740800 2009 21000000 /company/palyon-medical biotech Cross Atlantic Capital Partners https://www.crunchbase.com/financial-organization/cross-atlantic-capital-partners
1344 1344 1217 /financial-organization/dreamit-ventures DreamIt Ventures   USA PA Philadelphia Bryn Mawr angel 1249084800 2009   /company/postling messaging DreamIt Ventures https://www.crunchbase.com/financial-organization/dreamit-ventures
1345 1345 1603 /financial-organization/dreamit-ventures DreamIt Ventures   USA PA Philadelphia Bryn Mawr angel 1249084800 2009   /company/tidal web DreamIt Ventures https://www.crunchbase.com/financial-organization/dreamit-ventures
1346 1346 1347 /financial-organization/dreamit-ventures DreamIt Ventures   USA PA Philadelphia Bryn Mawr angel 1242950400 2009 20000 /company/seatgeek search DreamIt Ventures https://www.crunchbase.com/financial-organization/dreamit-ventures
1347 1347 1380 /financial-organization/dreamit-ventures DreamIt Ventures   USA PA Philadelphia Bryn Mawr angel 1272672000 2010 25000 /company/showme education DreamIt Ventures https://www.crunchbase.com/financial-organization/dreamit-ventures
1348 1348 308 /financial-organization/dreamit-ventures DreamIt Ventures   USA PA Philadelphia Bryn Mawr angel 1301616000 2011 25000 /company/cognection ecommerce DreamIt Ventures https://www.crunchbase.com/financial-organization/dreamit-ventures
1349 1349 1461 /financial-organization/dreamit-ventures DreamIt Ventures   USA PA Philadelphia Bryn Mawr angel 1314835200 2011 25000 /company/spling advertising DreamIt Ventures https://www.crunchbase.com/financial-organization/dreamit-ventures
1350 1350 300 /financial-organization/dreamit-ventures DreamIt Ventures   USA PA Philadelphia Bryn Mawr angel 1314835200 2011 20000 /company/clrtouch advertising DreamIt Ventures https://www.crunchbase.com/financial-organization/dreamit-ventures
1351 1351 1489 /financial-organization/dreamit-ventures DreamIt Ventures   USA PA Philadelphia Bryn Mawr angel 1358467200 2013 150000 /company/stereotypes music DreamIt Ventures https://www.crunchbase.com/financial-organization/dreamit-ventures
1385 1385 1537 /financial-organization/stage2-ventures Emerald Stage2 Ventures   USA PA Philadelphia Philadelphia series-a 1372118400 2013 1600000 /company/take-the-interview software Emerald Stage2 Ventures https://www.crunchbase.com/financial-organization/stage2-ventures
1395 1395 1118 /financial-organization/enertech-capital EnerTech Capital   USA PA Philadelphia Conshohocken venture 1223596800 2008   /company/ownenergy cleantech EnerTech Capital https://www.crunchbase.com/financial-organization/enertech-capital
2538 2538 763 /financial-organization/liberty-associated-partners Liberty Associated Partners   USA PA Bala Cynwyd Bala Cynwyd series-a 1133395200 2005 5000000 /company/jingle-networks mobile Liberty Associated Partners https://www.crunchbase.com/financial-organization/liberty-associated-partners
2539 2539 763 /financial-organization/liberty-associated-partners Liberty Associated Partners   USA PA Bala Cynwyd Bala Cynwyd series-b 1143849600 2006 26000000 /company/jingle-networks mobile Liberty Associated Partners https://www.crunchbase.com/financial-organization/liberty-associated-partners
2540 2540 763 /financial-organization/liberty-associated-partners Liberty Associated Partners   USA PA Bala Cynwyd Bala Cynwyd series-c+ 1199145600 2008 13000000 /company/jingle-networks mobile Liberty Associated Partners https://www.crunchbase.com/financial-organization/liberty-associated-partners
2541 2541 763 /financial-organization/liberty-associated-partners Liberty Associated Partners   USA PA Bala Cynwyd Bala Cynwyd series-c+ 1233705600 2009 7500000 /company/jingle-networks mobile Liberty Associated Partners https://www.crunchbase.com/financial-organization/liberty-associated-partners
2571 2571 850 /financial-organization/llr-partners LLR Partners   USA PA Philadelphia Philadelphia venture 1287619200 2010   /company/lightspeed-financial finance LLR Partners https://www.crunchbase.com/financial-organization/llr-partners
2660 2660 1026 /financial-organization/meakem-becker-venture-capital Meakem Becker Venture Capital   USA PA Pittsburg Sewickley angel 1270080000 2010 1000000 /company/nearcast mobile Meakem Becker Venture Capital https://www.crunchbase.com/financial-organization/meakem-becker-venture-capital
2661 2661 1335 /financial-organization/meakem-becker-venture-capital Meakem Becker Venture Capital   USA PA Pittsburg Sewickley series-a 1275868800 2010 1250000 /company/schoology education Meakem Becker Venture Capital https://www.crunchbase.com/financial-organization/meakem-becker-venture-capital
2662 2662 1335 /financial-organization/meakem-becker-venture-capital Meakem Becker Venture Capital   USA PA Pittsburg Sewickley series-b 1334534400 2012 6000000 /company/schoology education Meakem Becker Venture Capital https://www.crunchbase.com/financial-organization/meakem-becker-venture-capital
2676 2676 1811 /financial-organization/mentortech-ventures MentorTech Ventures   USA PA Philadelphia Philadelphia series-a 1162339200 2006 3000000 /company/yodle advertising MentorTech Ventures https://www.crunchbase.com/financial-organization/mentortech-ventures
2677 2677 1745 /financial-organization/mentortech-ventures MentorTech Ventures   USA PA Philadelphia Philadelphia series-a 1296518400 2011 1000000 /company/wanderfly travel MentorTech Ventures https://www.crunchbase.com/financial-organization/mentortech-ventures
2678 2678 1748 /financial-organization/mentortech-ventures MentorTech Ventures   USA PA Philadelphia Philadelphia series-a 1309910400 2011 1500000 /company/warby-parker ecommerce MentorTech Ventures https://www.crunchbase.com/financial-organization/mentortech-ventures
2679 2679 1748 /financial-organization/mentortech-ventures MentorTech Ventures   USA PA Philadelphia Philadelphia series-a 1309910400 2011 1500000 /company/warby-parker ecommerce MentorTech Ventures https://www.crunchbase.com/financial-organization/mentortech-ventures
2680 2680 936 /financial-organization/mentortech-ventures MentorTech Ventures   USA PA Philadelphia Philadelphia series-a 1321488000 2011 7000000 /company/medivo enterprise MentorTech Ventures https://www.crunchbase.com/financial-organization/mentortech-ventures
2681 2681 1748 /financial-organization/mentortech-ventures MentorTech Ventures   USA PA Philadelphia Philadelphia series-b 1356998400 2013 41500000 /company/warby-parker ecommerce MentorTech Ventures https://www.crunchbase.com/financial-organization/mentortech-ventures
2682 2682 1154 /financial-organization/mentortech-ventures MentorTech Ventures   USA PA Philadelphia Philadelphia series-a 1346457600 2012   /company/payperks finance MentorTech Ventures https://www.crunchbase.com/financial-organization/mentortech-ventures
2683 2683 936 /financial-organization/mentortech-ventures MentorTech Ventures   USA PA Philadelphia Philadelphia series-b 1371427200 2013 15000000 /company/medivo enterprise MentorTech Ventures https://www.crunchbase.com/financial-organization/mentortech-ventures
2889 2889 1572 /financial-organization/newspring-capital NewSpring Capital   USA PA Philadelphia Radnor venture 1215561600 2008 12000000 /company/the-feedroom public_relations NewSpring Capital https://www.crunchbase.com/financial-organization/newspring-capital
2890 2890 348 /financial-organization/newspring-capital NewSpring Capital   USA PA Philadelphia Radnor series-a 1212451200 2008 370000 /company/correctnet analytics NewSpring Capital https://www.crunchbase.com/financial-organization/newspring-capital
2891 2891 512 /financial-organization/newspring-capital NewSpring Capital   USA PA Philadelphia Radnor series-c+ 1348444800 2012 12000000 /company/exelate advertising NewSpring Capital https://www.crunchbase.com/financial-organization/newspring-capital
2892 2892 1095 /financial-organization/newspring-capital NewSpring Capital   USA PA Philadelphia Radnor series-c+ 1376870400 2013 11000000 /company/open-road-integrated-media advertising NewSpring Capital https://www.crunchbase.com/financial-organization/newspring-capital
2895 2895 897 /financial-organization/nextstage-capital Nextstage Capital   USA PA Philadelphia Audubon series-a 1170288000 2007 1200000 /company/magnify games_video Nextstage Capital https://www.crunchbase.com/financial-organization/nextstage-capital
2896 2896 897 /financial-organization/nextstage-capital Nextstage Capital   USA PA Philadelphia Audubon series-b 1204156800 2008 1000000 /company/magnify games_video Nextstage Capital https://www.crunchbase.com/financial-organization/nextstage-capital
2897 2897 897 /financial-organization/nextstage-capital Nextstage Capital   USA PA Philadelphia Audubon venture 1227571200 2008   /company/magnify games_video Nextstage Capital https://www.crunchbase.com/financial-organization/nextstage-capital
3015 3015 1303 /financial-organization/originate-ventures Originate Ventures   USA PA Bethlehem Bethlehem series-a 1251244800 2009 1500000 /company/rightsflow music Originate Ventures https://www.crunchbase.com/financial-organization/originate-ventures
3016 3016 301 /financial-organization/originate-ventures Originate Ventures   USA PA Bethlehem Bethlehem series-a 1338508800 2012 2400000 /company/cmp-ly social Originate Ventures https://www.crunchbase.com/financial-organization/originate-ventures
3017 3017 589 /financial-organization/originate-ventures Originate Ventures   USA PA Bethlehem Bethlehem series-b 1349740800 2012 2000000 /company/fsa-store ecommerce Originate Ventures https://www.crunchbase.com/financial-organization/originate-ventures
3018 3018 135 /financial-organization/originate-ventures Originate Ventures   USA PA Bethlehem Bethlehem venture 1364947200 2013 4500000 /company/ba-insight software Originate Ventures https://www.crunchbase.com/financial-organization/originate-ventures
3022 3022 135 /financial-organization/osage-ventures Osage Venture Partners   USA PA Bala Cynwyd Bala Cynwyd series-a 1284940800 2010 6000000 /company/ba-insight software Osage Venture Partners https://www.crunchbase.com/financial-organization/osage-ventures
3023 3023 135 /financial-organization/osage-ventures Osage Venture Partners   USA PA Bala Cynwyd Bala Cynwyd venture 1364947200 2013 4500000 /company/ba-insight software Osage Venture Partners https://www.crunchbase.com/financial-organization/osage-ventures
3299 3299 388 /financial-organization/robin-hood-ventures Robin Hood Ventures   USA PA Philadelphia Philadelphia venture 1299024000 2011 850000 /company/dailyworth finance Robin Hood Ventures https://www.crunchbase.com/financial-organization/robin-hood-ventures
3300 3300 388 /financial-organization/robin-hood-ventures Robin Hood Ventures   USA PA Philadelphia Philadelphia series-a 1366588800 2013 1000000 /company/dailyworth finance Robin Hood Ventures https://www.crunchbase.com/financial-organization/robin-hood-ventures
3472 3472 295 /financial-organization/schoffstall-ventures Schoffstall Ventures   USA PA Harrisburg Harrisburg series-a 1183248000 2007 3000000 /company/clickable advertising Schoffstall Ventures https://www.crunchbase.com/financial-organization/schoffstall-ventures
3488 3488 290 /financial-organization/scp-partners SCP Partners   USA PA Philadelphia Wayne venture 1106870400 2005 1100000 /company/clear-story software SCP Partners https://www.crunchbase.com/financial-organization/scp-partners
3519 3519 1111 /financial-organization/seventysix-capital SeventySix Captial   USA PA Philadelphia West Conshohocken series-a 1212278400 2008 2300000 /company/healthcare-health-human-powered-search other SeventySix Captial https://www.crunchbase.com/financial-organization/seventysix-capital
3520 3520 1803 /financial-organization/seventysix-capital SeventySix Captial   USA PA Philadelphia West Conshohocken series-a 1272672000 2010 3400000 /company/xtify mobile SeventySix Captial https://www.crunchbase.com/financial-organization/seventysix-capital
3521 3521 1344 /financial-organization/seventysix-capital SeventySix Captial   USA PA Philadelphia West Conshohocken series-a 976838400 2000 1000000 /company/seamless-north-america hospitality SeventySix Captial https://www.crunchbase.com/financial-organization/seventysix-capital
3522 3522 942 /financial-organization/seventysix-capital SeventySix Captial   USA PA Philadelphia West Conshohocken series-b 1214870400 2008 1500000 /company/meetmoi social SeventySix Captial https://www.crunchbase.com/financial-organization/seventysix-capital
3523 3523 942 /financial-organization/seventysix-capital SeventySix Captial   USA PA Philadelphia West Conshohocken series-c+ 1251763200 2009 2575000 /company/meetmoi social SeventySix Captial https://www.crunchbase.com/financial-organization/seventysix-capital
3754 3754 408 /financial-organization/susquehanna-growth-equity Susquehanna Growth Equity   USA PA Bala Cynwyd Bala Cynwyd series-a 1217376000 2008 6700000 /company/derivix software Susquehanna Growth Equity https://www.crunchbase.com/financial-organization/susquehanna-growth-equity
3941 3941 288 /financial-organization/tl-ventures TL Ventures   USA PA Philadelphia Wayne venture 1137456000 2006 3500000 /company/clarifi software TL Ventures https://www.crunchbase.com/financial-organization/tl-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 '');