327
edits
Changes
Jump to navigation
Jump to search
The Impact of Entrepreneurship Hubs on Urban Venture Capital Investment (view source)
Revision as of 11:12, 1 July 2016
, 11:12, 1 July 2016→Venture Capital Transactions Data Set
=Data=
==Venture Capital Transactions Data Set==
The main goal of the data set is to aggregrate aggregate company, fund, and round level data to be analyzed at a combined MSA and year level. The data set is compromised of two major parts: a granular company/fund/round and an aggregrated aggregated CMSA-Year. The data includes all United States Venture Capital transactions (moneytree) from the twenty-five year period of 1990 through 2015.
The Hubs data set, from SDC Platinum, has been constructed in the server:
===General Procedure- Granular Table===#TestStart with separate raw datasets for Companies, Funds, and Rounds #Add Data to Each Individual dataset (e.g. add MSA code)#Clean and standardize names (e.g. company or fund name) for each dataset#Join the Datasets (here we need to exclude undisclosed companies)
===General Procedure - Granular Table===
#Create a consistent CMSA-Year table to be used later
#Using the tables from the granular table, parse out the right data
#Join the parsed out data with the CMSA-Year Table
#Join these Tables
==Tables Used==
===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.
