Venture Capital (Data)
| Venture Capital (Data) | |
|---|---|
| Project Information | |
| Project Title | Venture Capital (Data) |
| Owner | Jake Silberman |
| Start Date | |
| Deadline | |
| Primary Billing | |
| Notes | |
| Has project status | Active |
| 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
- number of deals (first investments) by state, industry, msa, city, year, quarter
- number of foundings (conditional on receiving vc later) by state, industry, msa, city, year, quarter
- deal amount (first investment) by stage, state, industry, msa, city, year, quarter
- invested amount (any round) by stage, state, industry, msa, city, year, quarter
- number of deals by stage state, industry, msa, city, year, quarter
- number of investments (any round) by stage, state, industry, msa, city, year, quarter
- 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
- SQL code found in E:\McNair\Projects\Houston\MarketNonMarket\SQL Script 1
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.
