Changes

Jump to navigation Jump to search
==Third Rebuild==
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:
E:\projects\vcdb20\Ranking.sql
The build implements the following decisions:
*'''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)
===Artifacts and Facts===
*Fraction of data with disclosed amounts
*Turnover of the Top 10, 20, 50, 100
*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

Navigation menu