Difference between revisions of "Venture Capital (Data)"

From edegan.com
Jump to navigation Jump to search
Line 10: Line 10:
 
==Variables to Pull==
 
==Variables to Pull==
 
===Company Level===
 
===Company Level===
*coname
+
*coname - Company Name
*state
+
*state - Company State
*Industry
+
*Industry - Company VE Industry Class
*address
+
*address - Company Area Cd or Company North American Location
*date of founding
+
*date of founding - Company Founding Date
*date of first investment
+
*date of first investment - Date Company Rcvd its First Investment
*date of last investment
+
*date of last investment - Date Company Rcvd its Last Investment
*total amount invested
+
*total amount invested - Total Known Amount Invested in Company
*MSA, CMSA
+
*MSA, CMSA - Company MSA
*city
+
*city - Company City
*date of IPO
+
*date of IPO - Company IPO Date
  
 
===round level===
 
===round level===
 
====main round====
 
====main round====
*round date
+
*round date - Round Date
*round amount
+
*round amount - Round Amount, Disclosed ($ Thou) or Round Amount, Estimated ($ Thou)
*coname (or primary key)
+
*coname (or primary key) - Company Name
*round number
+
*round number - Round Number
*stage
+
*stage - STAGE1, STAGE2, STAGE3
 
====round on one line====
 
====round on one line====
 
*round on one line
 
*round on one line
Line 36: Line 36:
 
*coname (or primary key)
 
*coname (or primary key)
  
===Fund Level===
+
===Fund Level?===
 
*fund name  
 
*fund name  
 
*closing date  
 
*closing date  

Revision as of 12:58, 13 February 2017


McNair Project
Venture Capital (Data)
Project logo 02.png
Project Information
Project Title
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
    • round date
    • round amount
    • name of investor
  • coname (or primary key)

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

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.