135
edits
Changes
Jump to navigation
Jump to search
The name of the file is '''new_firm_nr_circles.sql'''
Urban Start-up Agglomeration and Venture Capital Investment (view source)
Revision as of 11:45, 1 August 2017
, 11:45, 1 August 2017→Data
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'''
Raw data is in:
Z:\VentureCapitalData\SDCVCData
The file is '''colevelsimple.txt'''
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'''. (It contains only 106 observations)
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
We use the cities with greater than 10 active VC backed firms. Data on the cities and number of active firms is in:
E:\McNair\Projects\Hubs\Summer 2017
The file is '''CitiesWithGT10Active.txt'''
The script for joining the final data with this file is located in
The final data is in
Z:\Hubs\2017\clean data
The file name is '''new_final_kerda.txt'''.
Also:
