Changes

Jump to navigation Jump to search
1,186 bytes added ,  12:48, 6 February 2017
no edit summary
}}
==Arching Objective==
==Variables to Pull==
===Company Level===
*coname
*state
*Industry
*address
*date of founding
*date of first investment
*date of last investment
*total amount invested
*MSA, CMSA
*city
 
===round level===
====main round====
*round date
*round amount
*coname (or primary key)
*round number
*stage
====round on one line====
*round on one line
**round date
**round amount
**name of investor
*coname (or primary key)
 
==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
#funds (fund closing date, last investment, first investment, fund name, address, MSA, MSA code, Average investment, number companies invested (NoCos), known investment)
 
==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.
 
=Variables to Pull=
668

edits

Navigation menu