7,612
edits
Changes
Jump to navigation
Jump to search
→Base Tables
The base tables are built using BuildBaseTables.sql. These provide common foundations for:
*PortCo Geography
*Other PortCo tables, including industry, id, patents & SBIR/STTR grants (note that these need updating)
*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]]
