Difference between revisions of "The Impact of Entrepreneurship Hubs on Urban Venture Capital Investment"
Jump to navigation
Jump to search
| Line 17: | Line 17: | ||
=Data= | =Data= | ||
| − | == | + | ==Venture Capital Transactions Data Set== |
The Hubs data set, from SDC Platinum, has been constructed in the server: | The Hubs data set, from SDC Platinum, has been constructed in the server: | ||
Data files are in 128.42.44.181/bulk/Hubs | Data files are in 128.42.44.181/bulk/Hubs | ||
| Line 25: | Line 25: | ||
The data set includes all United States Venture Capital transactions (moneytree) from the twenty-five year period of 1990 through 2015. Data has been aggregated at the portfolio company, fund, and round level. It will be analyzed at the combined MSA level. We will be looking at in terms of number of companies funded in number of funds active, and flow of investment in a given MSA. | The data set includes all United States Venture Capital transactions (moneytree) from the twenty-five year period of 1990 through 2015. Data has been aggregated at the portfolio company, fund, and round level. It will be analyzed at the combined MSA level. We will be looking at in terms of number of companies funded in number of funds active, and flow of investment in a given MSA. | ||
| − | + | ===Raw data tables=== | |
| − | ===Raw | ||
#Funds: fund name, first investment date, last investment date, fund closing date, address, known investment, average investment, number of companies invested, MSA, MSA code. | #Funds: fund name, first investment date, last investment date, fund closing date, address, known investment, average investment, number of companies invested, MSA, MSA code. | ||
#Rounds: round date, company name, state, round number, stage 1, stage 2, stage 3 | #Rounds: round date, company name, state, round number, stage 1, stage 2, stage 3 | ||
#Combined Rounds: company name, round date, disclosed amount, investor | #Combined Rounds: company name, round date, disclosed amount, investor | ||
| − | # | + | #Companies: company name, first investment, last investment, MSA, MSA code, address, state, date founded, known funding, industry |
#MSA list: MSA, MSA code, CMSA, CMSA code | #MSA list: MSA, MSA code, CMSA, CMSA code | ||
#Industry list: changes 6 industry categories to 4— ICT, Life Sciences, Semiconductors, Other | #Industry list: changes 6 industry categories to 4— ICT, Life Sciences, Semiconductors, Other | ||
| + | |||
| + | |||
| + | ===Grandeur Table (Fund-Round-Company)=== | ||
| + | The final table contains all venture capital transactions by disclosed funds and portfolio companies, together with their CMSAs. | ||
| + | To get the table, we processed the raw data sets in the following steps: | ||
| + | #Clean company data | ||
| + | ##Import raw data companies | ||
| + | ##Add variable 'CMSA' from data set MSA list, update variable 'industry' by joining data set industry list | ||
| + | ##Remove duplicates and remove undisclosed companies | ||
| + | #Clean fund data | ||
| + | ##Import raw data funds | ||
| + | ##Add variable 'CMSA' | ||
| + | ##Remove duplicates and remove undisclosed funds | ||
| + | ##Match fund names with itself using [The Matcher (TOOL)|The Matcher] to get the standard fund names | ||
| + | #Clean round data | ||
| + | ## | ||
| + | |||
| + | |||
===Process=== | ===Process=== | ||
==Supplementary Data Sets== | ==Supplementary Data Sets== | ||
| + | Supplementary data sets are cleaned and joined back to CMSAyear table on CMSA and year. | ||
*Number of STEM graduate student, by university and year(2005 to 2014). | *Number of STEM graduate student, by university and year(2005 to 2014). | ||
E:\McNair\Projects\Hubs\STEM grads for upload v2.xls | E:\McNair\Projects\Hubs\STEM grads for upload v2.xls | ||
| Line 43: | Line 61: | ||
*Income per capital, by MSA and year(2000 to 2012) | *Income per capital, by MSA and year(2000 to 2012) | ||
E:\McNair\Projects\Hubs\Income per capita upload.xls | E:\McNair\Projects\Hubs\Income per capita upload.xls | ||
| + | *Wages and salaries, by MSA and year(2000 to 2012) | ||
| + | E:\McNair\Projects\Hubs\Wage for upload v2.xls | ||
==Resources== | ==Resources== | ||
Revision as of 16:12, 30 June 2016
| The Impact of Entrepreneurship Hubs on Urban Venture Capital Investment | |
|---|---|
| Project Information | |
| Project Title | |
| Start Date | |
| Deadline | |
| Primary Billing | |
| Notes | |
| Has project status | |
| Copyright © 2016 edegan.com. All Rights Reserved. | |
Contents
Abstract
The Hubs Research Project is a full-length academic paper analyzing the effectiveness of "hubs", a component of the entrepreneurship ecosystem, in the advancement and growth of entrepreneurial success in a metropolitan area.
This research will primarily be focused on large and mid-sized Metropolitan Statistical Areas (MSAs), as that is where the greater majority of Venture Capital funding is located.
Data
Venture Capital Transactions Data Set
The Hubs data set, from SDC Platinum, has been constructed in the server:
Data files are in 128.42.44.181/bulk/Hubs All files are in 128.42.44.182/bulk/Projects/Hubs psql Hubs
The data set includes all United States Venture Capital transactions (moneytree) from the twenty-five year period of 1990 through 2015. Data has been aggregated at the portfolio company, fund, and round level. It will be analyzed at the combined MSA level. We will be looking at in terms of number of companies funded in number of funds active, and flow of investment in a given MSA.
Raw data tables
- Funds: fund name, first investment date, last investment date, fund closing date, address, known investment, average investment, number of companies invested, MSA, MSA code.
- Rounds: round date, company name, state, round number, stage 1, stage 2, stage 3
- Combined Rounds: company name, round date, disclosed amount, investor
- Companies: company name, first investment, last investment, MSA, MSA code, address, state, date founded, known funding, industry
- MSA list: MSA, MSA code, CMSA, CMSA code
- Industry list: changes 6 industry categories to 4— ICT, Life Sciences, Semiconductors, Other
Grandeur Table (Fund-Round-Company)
The final table contains all venture capital transactions by disclosed funds and portfolio companies, together with their CMSAs. To get the table, we processed the raw data sets in the following steps:
- Clean company data
- Import raw data companies
- Add variable 'CMSA' from data set MSA list, update variable 'industry' by joining data set industry list
- Remove duplicates and remove undisclosed companies
- Clean fund data
- Import raw data funds
- Add variable 'CMSA'
- Remove duplicates and remove undisclosed funds
- Match fund names with itself using [The Matcher (TOOL)|The Matcher] to get the standard fund names
- Clean round data
Process
Supplementary Data Sets
Supplementary data sets are cleaned and joined back to CMSAyear table on CMSA and year.
- Number of STEM graduate student, by university and year(2005 to 2014).
E:\McNair\Projects\Hubs\STEM grads for upload v2.xls
- University R&D spending, by university and year(2004 to 2014).
E:\McNair\Projects\Hubs\NSF spending for upload.xls
- Income per capital, by MSA and year(2000 to 2012)
E:\McNair\Projects\Hubs\Income per capita upload.xls
- Wages and salaries, by MSA and year(2000 to 2012)
E:\McNair\Projects\Hubs\Wage for upload v2.xls
