Venture Capital (Data)

McNair Project
Venture Capital (Data)
Project Information
Project Title	Venture Capital (Data)
Owner	Adrian Smart, Jake Silberman
Start Date
Deadline
Keywords	Data
Primary Billing
Notes
Has project status	Active
	Copyright © 2016 edegan.com. All Rights Reserved.

Project Objective

To create a master venture capital data set on which all other projects requiring venture capital data will be built.

Specifically, we will be building data to support the following:

Lists and counts by year as well as state, MSA, and city, zip code, etc.
Identify seed, early and later stage deals (first investment), dollars invested and rounds
Identify transactional VC dollars invested and rounds
Acquisitions and IPOs of VC backed firms
Identify when VC backed firms are "alive"
Geocode all portfolio companies
Geocode VC headquarters and branch offices
Compute distances between investors and their portfolio companies
Identify lead investors for portfolio companies
Identify top 100 VCs

Additional datafiles (in E:\McNair\Projects\VC Database):

GeocodedVCData.txt 43,724 records, tab-delimited with companynames but with "none" for some geocoords.

The SQL scripts need to do the following:

Extract company infomation from roundbase then process it
- Add variable for growth (1), transactional (2), or non-VC (3) (see below)
- Create clean 5-digit ZIP field
Extract firm information from firmbase, then:
- Add indicator variable for US
- Create clean 5-digit ZIP field
Build out BranchOffice (BO) table
Build lookups for:
- State Code
- raisestatus

Growth VC (1)
--------------
Seed
Early Stage
Later Stage

Tranactional VC (2)
--------------
Acq. for Expansion
Acquisition
Bridge Loan
Expansion
Pending Acq
Recap or Turnaround

Exclude (non-VC) (3)
--------------
LBO
MBO
Open Market Purchase
PIPE
Secondary Buyout