*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