Changes

The third rebuild uses [[VCDB20]] and covers up until the end of 2020. It combines Geocoding with city information when geocoding is unavailable.The code is in: E:\projects\vcdb20\Ranking.sql The outputs, including the xlsx file that puts everything together, are in: E:\projects\ranking The build implements the following decisions:*Placenames are from geocoding where possible and city names where not. ACS and Tigergeog are joined using Geoid where possible.*The ranking uses only growth VC (i.e., growthflag==1 on '''round''').*Places must have non-zero VC in at least one year between 1980 and 2020, inclusive, to be included. ===Artifacts and Facts=== The main artifacts are:*The Top 100 (and 200) for 2020*A graph of total US growth VC investment 1980-2020 Other artifacts/facts:*Fraction of data that is geocodable or has a valid placename*Fraction of data with disclosed amounts*Turnover of the Top 10, 20, 50, 100*Correlations between the three component measures*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.