7,612
edits
Changes
Jump to navigation
Jump to search
→Processing Steps
*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==
