Venture Capital (Data)

McNair Project

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

Arching Objective

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

Variables to Pull

Company Level

• coname - Company Name
• state - Company State
• Industry - Company VE Industry Class
• address - Company Area Cd or Company North American Location
• date of founding - Company Founding Date
• date of first investment - Date Company Rcvd its First Investment
• date of last investment - Date Company Rcvd its Last Investment
• total amount invested - Total Known Amount Invested in Company
• MSA, CMSA - Company MSA
• city - Company City
• date of IPO - Company IPO Date

round level

main round

• round date - Round Date
• round amount - Round Amount, Disclosed ($ Thou) or Round Amount, Estimated ($ Thou)
• coname (or primary key) - Company Name
• round number - Round Number
• stage - STAGE1, STAGE2, STAGE3

round on one line

• round on one line - COMBINED_ROUND_INFO
  • round date - Fund Portfolio Cos: Round Date
  • round amount - Fund Portfolio Cos: Round Amount, Disclosed ($ Thou) or Fund Portfolio Cos: Round Amount, Estimated (Thou)
  • name of investor - Fund Name
• fund type - Fund Type
• coname (or primary key) - Fund Portfolio Cos: Name

Fund Level?

• fund name
• closing date
• last investment
• first investment
• msa
• msa code
• average investment
• number of companies invested
• total known investment
• address
• fund size

Data sets to build

1. number of deals (first investments) by state, industry, msa, city, year, quarter
2. number of foundings (conditional on receiving vc later) by state, industry, msa, city, year, quarter
3. deal amount (first investment) by stage, state, industry, msa, city, year, quarter
4. invested amount (any round) by stage, state, industry, msa, city, year, quarter
5. number of deals by stage state, industry, msa, city, year, quarter
6. number of investments (any round) by stage, state, industry, msa, city, year, quarter
7. number of investors by stage, state, industry, msa, city, year, quarter

Houston/Galveston/Brazoria Pull/Work

• 5 Pulls, all under MSA Houston/Galveston/Brazoria filter
  • Firm Level
  • Fund Level
  • Company Level
  • Round Level
  • Round on One Line

Work Details

• SDC pulls at all 5 levels followed by normalization of data
• Data can be found in E:\McNair\Projects\Houston\MarketNonMarket (more details about which are specific to this project will be posted later) and files for import to SQL can be found in Z:\VentureCapitalData
• SQL tables are found in psql vcdata

Project Idea

Examine health of entrepreneurship ecosystem within an MSA or CMSA and how it is affected by the proximity of venture-backed companies to one another (measured by minimum circle area between firms within the MSA). The goal is to see whether MSA's with closer or further proximity between companies see greater growth in successive years.

In order to be considered "living," the companies must have not undergone IPO's, liquidations, or acquisitions and must have received venture funding within the last 5 years. If these requirements are not met, they are dropped from the data.