*Year
*Code from the state code and Fips code
==VC Data==
Raw Data is in:
Z:\VentureCapitalData\SDCVCData
The file name is roundcitystateyear.txt
It contains:
*city
*state
*year
*seedamtm - seed, amount in millions
*earlyamtm - early, amount in millions
*lateramtm - late, amount in millions
*selamtm - seed early late, amount in millions
*numseeds - number of seeds
*numearly
*numlater
*numsel
Date from 1953-2017
The SQL file that merges VC data with the MSA-City file is titled '''vc.sql'''.
The file is located in:
Z:\Hubs\2017
The final table is in db '''cities''' titled '''vc_city_state_year'''.
It includes:
*city
*state
*city_state_id
*city_state_year
*seedamtm
*earlyamtm
*lateramtm
*selamtm
*numseeds
*numearly
*numlater
*numsel
*year