7,613
edits
Changes
Jump to navigation
Jump to search
no edit summary
Likewise, we have to key off of firmname for all firm tables. It isn't that we don't have other identifying information in firmbase (all records have founding date) but we only have firmname as a foreign key in the fund table and branch office table.
===Possible Additions===
We might need to add:
*The population table (see Population.sql)
*Tigerplaces (see MiscTasks.SQL or Agglomeration.sql in E:\vcdb3\OriginalSQL)
*Accelerator data? (See CohortPortCoMatch.sql for doing the portco matching)
*GSP (see Adding GDP.sql)
*Industry, Firm type, Firm stage and other lookups (see MatchingEntreps.sql)
*Titlelookup (see MatchingEntreps.sql)
*PortCoSBIR and PortCoPatents (see MatchingEntreps.sql)
==Building Datasets==
We need to collect code from:
*Ranking.sql
*MatchingEntreps.sql, which builds:
**Women
**Some of matching VC-Entreps? (much might now be redundant)
*RevisedDBaseCode.sql, which builds:
**Matching VC-Entreps
**Some base tables and the super tables: PortCoSuper, FirmSuper, etc.
*Agglomeration.sql (the latest version is in E:\projects\agglomeration), which builds:
**Agglomeration!
**Note: Needs updating to reflect latest decisions
