Changes
Jump to navigation
Jump to search
no edit summary
cleanco — used to remove duplicates from companies
cleanedcompanies — clean set of companies with no duplicates
cmsafunds-
cmsas— list of all CMSAs in final data set (for merging)
cmsastats- statistics not including empty years (pre-merge)
cmsastats2 - statistics separated by year-MSA
cmsastats3— statistics separated by year-MSA-stage
cmsastats4
cmsayears— empty merged table between year and cmsa
cmsayearstage — empty merged table between cmsa/years and stage
companyround2- combined company information with round information, cleaned up from companyround2
companyround3- combined company information with round information, cleaned up from companyround3
'''finaldataset'''- final statistics by CMSA-year, see section Final Primary Data Set for more information
fundinfo— funds joined with CMSA info
fundinfo2 - clean version of fundinfo1
fundinfocleannodups- final clean set of fundinfo
funds - raw SDC fund data
Houston - analysis for Houston ecosystem team
Houston2- analysis for Houston ecosystem team
houston3- analysis for Houston ecosystem team
industry — new industry codes (4)— used for all future data sets
industrylist— lookup table for new industry codes (went from 6 to 4)
matchroundfund2- used for matching process
msalist — lookup table for MSA to CMSA (used for all future data sets)
nearfar1-- beginning set before adding nearfar/stage variables
nearfar2 -- added binomial variables for near/far and for each of the stages, used to build final dataset
roundfund— not used— joined round to fund; drop/ignore
roundinfo— round info cleaned up to include number of investors in a syndicate and estimated investment per member of syndicate
