Changes

namegender: -built from copeoplebase -identifies male/female/unknown

CoPeopleFull: -built from copeoplebase and namegender -builds more extensive information on executive including speficially what level of executive they are

CoPeopleKey: -built from CoPeopleFull -creates table where only executives with full primary keys are kept

CoPeopleSerial: -built from copeoplekey -keeps track of executives previous jobs at executive level

CoPoepleAgg: -built from copeoplekey and copeopleserial -gets extensive information on executives for each company

FundPeopleBae: -built from fundpeople -identifies male/female/doctor -hasperson column slightly weird because we can only have the lastname without prefix or first name and still have a 1 in column. Seems to be of little use/too broad

FundPeopleFull: -built from fundpeoplebase, namegender -adds in male/female

fundpeopleagg Fundpeopleagg: -built from fundpeoplefull -has aggregations of gender info for each fund

RoundLineJoinerLeanffWlistno: -built from rounlinejoinerleanff -adds listno to funds

RoundLineAggFunds: -built from roundlinejoinerleanffwlistno and rounlineaggfirms -if there are two funds from one firm that invest in same portco, we choose only one and leave the others behind

RoundLineAggWExit: -built from roundlineaggfirms, portcoexitupdated, roundlineaggfunds -adds in exit information for each company in roundlineaggfirms

FirmPerf: -built from roundlineaggwexit -adds in various performance measures for a given firm

PortCoFundDemo PortCoPeopleMaster: -built from roundlinejoinerleanffclean and fundpeopleaggPortCoMaster, PortCoIndustry, PortCoPatent, PortCoSBIR, copeoplagg, PortCoFundDemo, CPI, statelookupint -gives information on huge amount of data about companies and their executives of funds who invested in the portcos

PortCoPeopleMaster RoundAggDistBase: -built from PortCoMasterportcogeo, PortCoIndustryfirmbogeo, PortCoPatent, PortCoSBIR, copeoplagg, PortCoFundDemo, CPI, statelookupintroundlineaggwexit -huge amount of data about companies and their executivescreates geographic points using long, lat from geocoding

RoundAggDistBase RoundAggDist: -built Built from portcogeo, firmbogeo, roundlineaggwexitroundaggdistbase -creates geographic points using long, lat from geocodinggets actual distances between portcos and firms. if branch office exists and distance is less than distance to firm chooses that also generates random number

RoundAggDist FirmPeopleAgg: -Built built from roundaggdistbaseroundlineaggfunds, fundpeopleagg -gets actual distances between portcos and finds information on executives from different firms. if branch office exists and distance is less than distance to firm chooses that also generates random number

FirmPeopleAgg PortCoMatchmaster: -built from roundlineaggfundsportcopatent, fundpeopleaggporcoindustry, portcosbir, copeopleaggsimple, portcoid -finds gets all information on executives from different firmstogether about portcos

PortCoMatchmaster FirmMatchMaster: -built from portcopatentfirmperf, porcoindustryfirmvars, portcosbirfirmpeopleagg, copeopleaggsimple, portcoidfirmid -gets all information together about portcosfirms

FirmMatchMaster RoundLineMasterBase: -built from firmperfportcomatchmaster, firmvarsfirmmatchmaster, firmpeopleaggroundaggdist, firmidroundlineaggwexit -gets all builds large amount of information together about portcos and firmsspceifically info about exits and distances

RoundLineMasterBase MatchMostNumerous: -built from portcomatchmaster, firmmatchmaster, roundaggdist, roundlineaggwexitroundlinemasterbase -builds large amount finds max number of information about portcos and firms spceifically info about exits and distancesinvested in by a firm that also invested in the company grouping by

MatchMostNumerous MatchHighestRandom: -built from roundlinemasterbasematchmostnumerous -finds max number of portcos invested in by a firm if two firms that also invested in one company had the same number of max port cos this randomly chooses one company grouping by

MatchHighestRandom FirmActiveYearsCode20: -built from matchmostnumerousroundlinejoinerleanffclean, porcoindustry -if two firms that invested adds firmname to industry code not exactly sure why distinct is used in one company had the same number of max port cos this randomly chooses one companyquery

FirmActiveYearsCode20 RealMatchesCode20: -built from roundlinejoinerleanffcleanMatchHighestRandom, porcoindustryPortCoIndustry -adds firmname to industry code not exactly sure why distinct is used real matches between portcos and firms that invested in querythem including the code20

RealMatchesCode20 SyntheticFirmSetBaseCode20: -built from MatchHighestRandomrealmatchescode20, PortCoIndustryfirmactiveyarscode20 -real matches between crossproduct of firms and portcos and . finds firms that invested in them including the code20same year as portco received first inv, firms invested in same type of company, and makes sure matches are unique

SyntheticFirmSetBaseCode20 SynthRoundAggDistBaseCode20: -built from realmatchescode20allmatchkeys, firmactiveyarscode20portcogeo, firmbogeo -crossproduct of firms and portcos. finds firms that invested in same year as builds points for all portco received first inv, firms invested firm listings in same type of company, and makes sure matches are uniqueallmatch keys

AllMatchKeys SynthRoundAddDistCode20: -built from SyntheticFirmSetBaseCode20, RealMatchesCode20synthroundaggdistvasecode20 -combines synthetic finds actual distance between portcos and real matchesfirms using installed extensions chooses branch offices if distance between portco and bo less than firm

SynthRoundAggDistBaseCode20 SynthFirmnameInduBlowoutCode20: -built from allmatchkeys, portcogeo, firmbogeoroundlinemasterbase -builds points for all portco, gets every firm listings combination and checks whehter the companies that those firms invested in are in allmatch keysthe same general industry

SynthRoundAddDistCode20 SynthFirmNameroundInduHistCode20: -built from synthroundaggdistvasecode20SynthFirmnameInduBlowoutcode20 -finds actual distance between portcos and gets information by portco, firmname match about what the firms using installed extensions chooses branch offices if distance between portco and bo less than firmpast investment patterns are

SynthFirmnameInduBlowoutCode20 MasterWithSynthBaseCode20Portco: -built from allmatchkeysAllmatchkeys, roundlinemasterbasematchhighestrandom, synthroundaggdistcode20, sythnfirmnameroundinduhistcode20, synthfirmnameroundindutotalcode20, firmvars, copeopleaggsimple, portcomaster -gets every firm combination builds a bunch of information about synthetic and checks whehter the companies that those firms invested in are in the same general industryreal matches

SynthFirmNameroundInduHistCode20 SynthFirmnameRoundInduTotalCode20: -built from SynthFirmnameInduBlowoutcode20allmatchkeys, roundlinemasterbase -gets information finds number of portcos in certain industries by portco, firmname match about what the firms past investment patterns arefirmnames

MasterWithSynthBaseCode20Portco MasterWithSynthcode20: -built from Allmatchkeysmasterwithsynthbasecode20portco, matchhighestrandom, synthroundaggdistcode20, sythnfirmnameroundinduhistcode20, synthfirmnameroundindutotalcode20, firmvars, copeopleaggsimple, portcomastermasterwithsynthcode20firms -builds gets a bunch huge amount of information info together on real and synthetic matches about synthetic firms and real matchescompanies

SynthFirmnameRoundInduTotalCode20 MasterReals: -built from allmatchkeys, roundlinemasterbasemasterwithsynthcode20 -finds number of portcos in certain industries by firmnamesgets just real matches from code

MasterWithSynthCode20Firms MasterOneSynth: -built with firmmatchmaster, allmatchkeysfrom masterwithsynthcode20 -matching a bunch of information to all gets just one randomly chosen synthetic match between companies and firms

MasterWithSynthcode20:-built from masterwithsynthbasecode20portco, masterwithsynthcode20firms-gets a huge amount of info together on real and synthetic matches about firms and companies MasterReals:-built from masterwithsynthcode20-gets just real matches from code MasterOneSynth:-built from masterwithsynthcode20-gets just one randomly chosen synthetic match between companies and firms   MasterRealOneSynth: -built from masteronesynth, masterreals -combines the real and one synth table