Changes
Jump to navigation
Jump to search
no edit summary
There may be a second dataset that has Hub-Industry-Year (where industry is semiconductor/non-semiconductor?).
===Final Primary Data Set===
Table name: finaldataset
*cmsa
*year
*total amount invested (totalamountinv)
*amount invested from local funds (nearamountinv)
*amount invested from funds outside CMSA (faramountinv)
*amount invested in early stage companies (earlyinv)
*amount invested in later stage companies (laterinv)
*amount invested in seed or startup stage companies (startupseedinv)
*amount invested in Acquisition/Buy-outs/Other stage companies (otherstageinv)
*distinct funds that are investing in that CMSA-year (investingfund)
*distinct funds from that CMSA that invested in that CMSA-year (investingfundnear)
*distinct funds from outside that CMSA that invested in that CMSA-year (investingfundfar)
*number of deals (deals)
*number of deals inside a CMSA (near deals)
*number of deals from outside a CMSA
** some of these deals might count in both categories, because of syndicate members being both inside and outside the CMSA
*deals with earlystage companies (earlystagedeals)
*deals with later stage companies (laterstagedeals)
*deals with startup/seed companies (startupseeddeals)
*deals with companies in other stages (otehrstagedeals)
*number of portfolio companies to receive their first investment in that year (newportcosfunded)
