135
edits
Changes
Jump to navigation
Jump to search
Urban Start-up Agglomeration and Venture Capital Investment (view source)
Revision as of 12:27, 31 July 2017
, 12:27, 31 July 2017→Data
Data on NSF, NIH, population, income, clinical trials, employment, schooling, R&D expenditures and revenue of firms can be found in [[Hubs]].
Data on the number of new vc backed firms in each city and year is in:
Z:\Hubs\2017\clean data
The name of the file is '''firm_nr.txt'''.
Database is cities
SQL script is: nr_firms.sql
Data on the circle area in each city and year is in:
Z:\Hubs\2017\clean data
The name of the file is '''circles.txt'''.
Database is cities
SQL script is: circles.sql
The script for joining the two tables on the VC table is in:
Z:\Hubs\2017\sql scripts
The name of the file is '''new_firm_nr_circles.sql'''
Also:
