7,612
edits
Changes
Jump to navigation
Jump to search
→Base Tables
*Industry, Firm type, Firm stage, Title, statecode, and other lookup tables.
*PortCoSBIR and PortCoPatent -- These are now out of date and don't appear to have build notes.
===Join in the exit data===
Bring in and clean up the IPO and MA (private target) data, match it to the PortCos, and reconcile the conflicts. This creates two core tables, one key table, and two PortCo results tables:
*IpoCleanNoDups
*MACleanNoDups
*ExitKeys (IPO and MA only, not PortCo)
*PortCoExit
*PortCoAliveDead
'''PortCoAliveDead''' follows the academic convention of marking a startup as alive if it has begun receiving investment and hasn't exited and if its last investment occurred less than five years ago.
==Base Tables==
The base tables are built using BuildBaseTables.sql. These provide common foundations for:
*PortCo Geography
*Other PortCo tables, including industry, id, cpi adjustments, geoids.
**Exit, Alive/dead and patents & SBIR/STTR grant (note that these need updating) information is also included.
*Firm variables (note that the full build is only done for firms that make growth investments).
*Round Line Joiner (RLJoiner) tables.
*PortCo People, including gender, dr., titles, serials.
*Fund People: gender and dr.
*The Master tables:
**PortCoMaster
**PortCoPeopleMaster
**FirmGrowthMaster (the Firm master table, for growth investments)
**RLMaster
Finally, this code also builds: MatchMostNumerous and MatchHighestRandom, which are used in [[Estimating Unobserved Complementarities between Entrepreneurs and Venture Capitalists]]
