Changes
Jump to navigation
Jump to search
→Primary Data Set
* populate data with count of companies (Deal flow) and estimated amount ($)
** data set in 181 hubs folder under summarycmsa.txt (38394)
'''Glossary of Tables''''
cleanco — used to remove duplicates from companies
cleanedcompanies — clean set of companies with no duplicates
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
cmsayears— empty merged table between year and cmsa
cmsayearstage — empty merged table between cmsa/years and stage
combinedrounds— raw sdc data for combined rounds
combinedroundswamt— used to join rounds and combined rounds for roundinfo2
companies- raw SDC company data
companyinfo — cleaned companies joined with state and CMSA information
companyinfo2— companyinfo1 with original industry categories
companyinfo3— companyinfo2 with updated industry categories and codes
companyinfo4
companyround
companyround2
companyround3
fundinfo— funds joined with CMSA info
fundinfo2 - clean version of fundinfo1
fundinfoclean - used in process to clean fundinfo2
fundinfoclean2- used in process to clean fundinfo2
fundinfocleanfinal- used in process to clean fundinfo2
fundinfocleannodups- final clean set of fundinfo
funds - raw SDC fund data
industry — new industry codes (4)— used for all future data sets
industrylist— lookup table for new industry codes (went from 6 to 4)
joined1
joined2
matchfund2
matchfunds
matchroundfund
matchroundfund2
msalist — lookup table for MSA to CMSA (used for all future data sets)
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
roundinfo2— roundinfo1 including name of investors/funds
roundinfo3— clean version of roundinfo2
roundinfoclean — final clean version of roundinfo3 (final roundinfo table)
rounds — raw SDC round data
stages — table for merging stage-year-CMSA
superinfo — ignore/drop
temp
years — table for merging stage-year-CMSA
===Hub Candidates Data Set===
