Changes

The third rebuild uses [[VCDB20]] and covers up until the end of 2020. It combines Geocoding geocoding with city information when geocoding is unavailable. The code is in:

*'''Placenames ''' are from geocoding where possible and '''city ''' names where not. *The '''ACS ''' and '''Tigergeog ''' tables are joined in using Geoid '''geoid''', which is determined from '''placenames''' (where possible).*A startup received growth VC if it one of its round stages was seed, early or later.*The ranking uses only growth VC (i.e., '''growthflag'''==1 on '''round''')and '''rounddate''' < '2021-01-01'.*Places must have non-zero VC in at least one year between 1980 and 2020, inclusive.*'''numalive''' calculates dead as exit==1 or date>=(datelastinv+5 years), to be includedand alive as date>=datefirstinv and dead==0.*'''newdeal''' is a first investment (i.e., irrespective of stage and one per startup)*Undisclosed amounts are treated as zeros. Amounts are in millions (unless otherwise stated). ===Datasets=== *PlaceYearRankingFull.txt (covers all places and years 1980-2020)*PlaceYearRanking200.txt (top 200 places for years 1980-2020)*StateYearRanking.txt (50 states + DC and PR for years 1980-2020) *PlaceYearRanking2020.txt (all places for 2020)*PlaceYearRanking200-2020.txt (top 200 places for 2020)*StateYearRanking2020.txt (50 states + DC and PR for 2020)

*The Top 100 (and 200 ) for 2020

*Fraction of data with disclosed amounts*Turnover of the Top 10, 20, 50, 100, 200*Correlation Correlations between the three component measures(top 200?)*Cumulative Percentage of Growth VC, new deals, and alive by city (top 10, 20, 50, and 100) over time*Average Growth rate of Growth VC, new deals, and alive by city (top 10, 20, 50, and 100) over time*Focus on select cities: Rankings over time for Houston, St. Louis, Cincinnati, Boulder, Waltham, Palo Alto

Note that if we exclude 2000 (i.e. consider 2001 to 2017 inclusive), the overall average growth rate drops to 0.2812, and some cities, like Houston, have materially lower growth rates. It is worth noting that Houston had one big up year in 2013, where growth VC investment levels where 2.168 times the previous year, but then suffered a about a 50% mean reversion in the following years. Without 2013, Houston's average 2001 to 2017 growth rate is - -0.0197349989630022.