7,612
edits
Changes
Jump to navigation
Jump to search
no edit summary
{{Project|Has project output=Data|Has sponsor=McNair ProjectsCenter
|Has title=Hubs
|Has owner=Hira Farooqi,
|Has keywords=Data
|Has project status=Active
|Does subsume=Hubs Analysis 2017,
}}
'''Important Notice: The last update to the hubs data was done manually by Ed and is in E:\projects\MeasuringHGHTEcosystems\HubsData-RevisedSimplified.xlsx'''
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. It focuses on cities in the United States as the primary unit of analysis.
Raw Data is in:
Z:\VentureCapitalData\SDCVCData\vcdb2 The file name is roundcitystateyearroundleveloutput2.txt
It contains:
*numlater
*numsel
*numdeals
*numalive
Date from 19531948-2017
The table is in db '''cities''' titled '''vcnew_vc'''.
It includes:
*numlater
*numsel
*numdeals
*numalive
*year
==Final Joined Data set ==
The final data set is in file '''final.txt''' and is located here:
Z:\Hubs\2017
It includes:
*city
*state
*city_state_year - (ID that data is merged on)
*year
*seedamtm - Seed Amount
*earlyamtm - Early Investment Amount
*lateramtm - Late Investment Amount
*selamtm - Seed early or late amount
*numseeds - Number of seed investments
*numearly - Number of early investments
*numlater - Number of late investments
*numsel
*numdeals - Number of deals (first contracts)
*numalive - Number of start ups alive
*income - Income per capita in each city-year
*sbir_nogrants - Number of SBIR grants
*sbir_valuegrant - Value of SBIR grants
*emp - Employment stats of each city-year
*unemp - Rate of unemployment
*popestimate - Population estimate of each city-year
*private - Enrollment in private schools
*public - Enrollment in public schools
*total -
*numfirms - Number of publicly traded firms
*randd - R&D expenditure of publicly traded firms
*revenue - Revenue of PTF
*totalassets
*nsf_nogrants - Number of NSF grants
*valuegrant - Value of NSF grants
*nih_nogrants - Number of NIH grants
*nih_valuegrant - Value of NIH grants
*noctrials - NUmber of clinical trials
== Defining Hubs ==
'''Summer 2016''' - Last year a master list of 125 "potential" hubs was used. A scorecard was developed which filtered these 125 candidate hubs to determine which of these should be included in the study sample. This method resulted in a sample size of ~ 30. The master list and the final hubs list is titled '''Hubs Data v2_'16'''. It is located here:
Z:\Hubs\2017\hubs_data
'''Summer 2017''' - In order to obtain a more statistically significant sample of hubs, we developed 5 criteria which produce a more relaxed definition of hubs than last year. These include
*Availability of co-working space
*Coding classes or tech events
*Some focus on the tech sector (this is important as our dependent variable is VC funding)
*Presence of an accelerator
*Availability of mentorship for members.
We will review the 125 candidate hubs and select those which satisfy a subset or all of these characteristics.
[[category:Internal]]
