668
edits
Changes
Jump to navigation
Jump to search
→Project Idea
Throw out duplicate names for companies (take only the most recent one when duplicates and match on name and first inv).
==SDC Pull==
===Restrictions===
*Nation: U.S. State: TX MSA: Houston, Texas City-Galveston, Brazoria Year: 1980-2017. Venture Related: Yes
*Definition of Houston: MSA Codes for Galveston, Texas City, Brazoria, and Houston, and at state=TX
===Variables Pulled===
Pull round based info (through portfolio company perspective):
*Company Name
*Round Number
*Round Date
*Round Amount Disclosed (thou)
*Date Company Received Last Investment
*Date Company Received First Investment
*Company City
*Total Known Amount Invested in Company (thou)
*Company IPO Date
*Company Found Date
*Company Stage Level 3 at Round Date
*Company Industry Minor Group
*Company Industry Sub Group 3
*Company State (Code)
*Compnay MSA (Code)
*Company Street Address, Line 1
*Company Street Address, Line 2
*Company Zip Cd
===Exclusions and Classifications===
Seed/Early/Later (Real VC)
Seed
Early Stage
Later Stage
Other VC
Acq. for Expansion
Acquisition
Bridge Loan
Expansion
Pending Acq
Recap or Turnaround
Exclude (non-VC)
LBO
MBO
Open Market Purchase
PIPE
Secondary Buyout
