Changes

Jump to navigation Jump to search
==Data==
 
===Making the circle input data===
Ed's additional datawork is in
We need to:
#Winsorize CoLevelBlowout
#Compute the circles!
#Make the Bay Area (over time) data
#Plot the Bay Area data (with colors per Bay Area city) for 1985 to present
#Combine the plots to make an animated gif
===Main Sources=== The primary sources of data for this project are:*SDC VentureXpert- from [[VC Database Rebuild]], the key table is '''
*GIS City Data
*Data on NSF, NIH, population, income, clinical trials, employment, schooling, R&D expenditures and revenue of firms can be found in [[Hubs]].
*===VC 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'''.
The differences are taken in excel. The file containing the differences is in
Z:\Hubs\2017 and the file name is '''new_colevel.txt'''.
 
*Data on the circle area in each city and year is in:
The file name is '''new_final_kerda.txt'''.
Also:===Accelerator data=== *Accelerators data is in
Z:\Hubs\2017\clean data
The file name is accelerators.txt
It also predicts the hazard rates, matches on the hazard rate in order to create synthetic control and treatment groups.
What is left to do is to add 2 lagged and 3 forward observations for the cities which do have a match. Remove the overlapping observations for the years that get a treatment but which at the same time serve as a control.
 
===See also===
Also:
===Unbiased measure===
The number of startups affects the total area of the circles according to some function. The task is to find an unbiased measure of the area, which is not affected by the number of the startups, given the size and their distribution.
For the unbiased calculation of a measure in a different context see: http://users.nber.org/~edegan/w/images/d/d0/Hall_(2005)_-_A_Note_On_The_Bias_In_Herfindahl_Type_Measures_Based_On_Count_Data.pdf
===GIS Resources=== 
*https://www.census.gov/geo/maps-data/data/tiger-line.html
*https://www.census.gov/geo/maps-data/data/tiger.html
*http://postgis.net/features/
*https://en.wikipedia.org/wiki/GIS_file_formats

Navigation menu