==Third Rebuild==
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 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*Turnover of the Top 10, 20, 50, 100, 200*Correlation between measures?*Cumulative Percentage of Growth VC
==Second (Complete) Rebuild==