edegan.com - User contributions [en]

Jake Silberman (Work Log)

2017-04-25T19:54:22Z

JakeSilberman:

[[Jake Silberman]] [[Work Logs]] [[Jake Silberman (Work Log)|(log page)]]

06/01/2016 15:52 - Introduction/Wiki building

06/02/2016 14:22 - Project refinement & reorganization

06/03/2016 13:30 - Public wiki page development

06/06/2016 13:51 - Further public wiki development

06/07/2016 13:22 - Carried interest debate wiki page writing

06/08/2016 14:54 - Finishing Carried interest debate wiki page, beginning research on history of leveraged buyouts for wiki/blog post

06/09/2016 15:53 - Transfer of wiki pages from private to public

06/10/2016 15:42 - Finished Carried Interest Blog Post

06/13/2016 15:09 - Working on LBO data to match it with patent data

06/14/2016 15:22 - More work on LBO data

06/15/2016 15:20 - Finished work on LBO Data

06/16/2016 15:12 - Beginning of research for LBO academic paper, looking at other scholarly papers

06/20/2016 15:38 - Finding more scholarly papers and writing litreviews, then examining potential variables for the LBO paper

07/15/2016 11:00 - Creating research plan page, updating work log, finalizing hazard models, see [[Leveraged Buyout Innovation (Academic Paper)]] for general summary of work since 06/16/2016

07/18/2016 15:00 - Pulling extra SDC data on LBO's, adjusting work on project to [[Brian Ayash|Brian's]] specs

07/19/2016 12:01 - Repulling SDC data with new variables, normalizing SDC data, then matching SDC data and private to private LBO data from the original LBO data to the working set in order to get more LBO matches.

07/20/2016 14:00 - Joining new LBO deals in the 5000s to working data set

07/26/2016 15:52 - finished incorporating 5000s lbo deals into data set, now beginning reorganization of scripts and past work to make it simpler/easier to follow and execute

07/27/2016 11:25 - Reorganizing scripts and helping Ed/James Brander with [[Winner's Curse]].

07/28/2016 12:00 - Cleaning LBO SQL scripts

07/29/2016 13:45 - Cleaning LBO SQL scripts and helping Ed/James Brander a bit more with [[Winner's Curse]]

08/01/2016 13:57 - Examining corporate governance databases to solidify measures for [[Winner's Curse]]

09/06/2016 13:00 - Getting reacquainted with the LBO Project

09/08/2016 13:10 - Continuing research into data for [[Winner's Curse]]

09/15/2016 15:04 - Finding variables/data sources for [[Winner's Curse]]

02/13/2017 10:30 - Locating variables for [[Venture Capital (Data)]] in SDC

02/15/2017 10:08 - Trying to locate several more variables for [[Venture Capital (Data)]] in SDC, then begin work to make data sets in SQL

02/17/2017 12:18 - Running SDC pulls for Company Level, Main Round, and Round on One Line (if Main Round finishes up).

02/20/2017 10:22 - Normalizing Main Round, organizing data in folders

02/22/2017 10:00 - Pulling Round on One Line (and normalizing, as long as it doesn't crash), and creating database in SQL to import them into

03/06/2017 11:12 - Beginning work for Venture Capital Data Issue Brief

03/08/2017 11:42 - Did first SDC Pull for VC Data and began cleaning data/making graphs
[[Category:Work Log]]

03/22/2017 11:15 - Redid SDC Pulls with final variables, wrote research plan

03/27/2017 10:00 - Normalizing SDC data, cleaning data/making graphs, work in E:\McNair\Projects\VentureCapitalData\VCData Pull 2 Normalized

04/05/2017 11:30 - Normalized and loaded SDC pulls into 'vcdata' database

04/19/2017 11:20 - Completed SEL deal, investment, rounds, and IPO tables. Code found in E:\McNair\Projects\VentureCapitalData\SQL Scripts and tables in 'vcdata' database

04/25/2017 14:55 - Worked on adding extra IPO data to old IPO table, seemed that there were no new IPOs in the data.
Final tables so far found in 'vcdata' database. Names of final tables so far are sel3, investments3, rounds2,
and ipo2. Merger and acquistion data in table MA.

Jake Silberman (Work Log)

2017-04-19T16:19:15Z

JakeSilberman:

Venture Capital (Data)

2017-04-12T15:56:26Z

JakeSilberman: /* Jake Project */

{{McNair Projects
|Has title=Venture Capital (Data)
|Has owner=Jake Silberman
|Has notes=
|Is dependent on=
|Depends upon it=
|Has project status=Active
|Has keywords=Data
}}

==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
*E:\McNair\Software\Scripts contains normalizing script for round on one line. HubsCapture.pl

===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

==Jake Project==
*1
Rank top 20 cities in the USA for venture capital. Rank by:
# # of deals (1st investments - deal number = 1 or rounddate=datefirstinv)
# amount invested per year (sum of round dollars)
# number of rounds made per year (count of rounds)
# number of IPOs per year (VC backed)
# number of acquisitions per year (VC backed)
# number of alive venture backed firms in a year (had a round within last 5 years and haven't exited)
*Alive - 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.

Throw out duplicate names for companies (take only the most recent one when duplicates and match on name and first inv).

===Work Details===
*See SQL database 'vcdata' for tables
*SDC data imported into 'vcdata' found in Z:\VentureCapitalData
*Code found in E:\McNair\Projects\VentureCapitalData\SQL Scripts

==SDC Pull==

===Restrictions===
*Nation: U.S. State: TX MSA: Houston, Texas City-Galveston, Brazoria Year: 1980-2017. Venture Related: Yes
*Definition of Houston: MSA Codes for Galveston, Texas City, Brazoria, and Houston, and at state=TX

===Variables Pulled===
Pull round based info (through portfolio company perspective):
*Company Name
*Round Number
*Round Date
*Round Amount Disclosed (thou)
*Date Company Received Last Investment
*Date Company Received First Investment
*Company City
*Total Known Amount Invested in Company (thou)
*Company IPO Date
*Company Found Date
*Company Stage Level 3 at Round Date
*Company Industry Minor Group
*Company Industry Sub Group 3
*Company State (Code)
*Compnay MSA (Code)
*Company Street Address, Line 1
*Company Street Address, Line 2
*Company Zip Cd

===Exclusions and Classifications===

Seed/Early/Later (Real VC)
Seed
Early Stage
Later Stage

Other VC
Acq. for Expansion
Acquisition
Bridge Loan
Expansion
Pending Acq
Recap or Turnaround

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

Venture Capital (Data)

2017-04-12T15:56:02Z

JakeSilberman: /* Jake Project */

{{McNair Projects
|Has title=Venture Capital (Data)
|Has owner=Jake Silberman
|Has notes=
|Is dependent on=
|Depends upon it=
|Has project status=Active
|Has keywords=Data
}}

==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
*E:\McNair\Software\Scripts contains normalizing script for round on one line. HubsCapture.pl

===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

==Jake Project==
*1
Rank top 20 cities in the USA for venture capital. Rank by:
# # of deals (1st investments - deal number = 1 or rounddate=datefirstinv)
# amount invested per year (sum of round dollars)
# number of rounds made per year (count of rounds)
# number of IPOs per year (VC backed)
# number of acquisitions per year (VC backed)
# number of alive venture backed firms in a year (had a round within last 5 years and haven't exited)
*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.

Throw out duplicate names for companies (take only the most recent one when duplicates and match on name and first inv).

===Work Details===
*See SQL database 'vcdata' for tables
*SDC data imported into 'vcdata' found in Z:\VentureCapitalData
*Code found in E:\McNair\Projects\VentureCapitalData\SQL Scripts

==SDC Pull==

===Restrictions===
*Nation: U.S. State: TX MSA: Houston, Texas City-Galveston, Brazoria Year: 1980-2017. Venture Related: Yes
*Definition of Houston: MSA Codes for Galveston, Texas City, Brazoria, and Houston, and at state=TX

===Variables Pulled===
Pull round based info (through portfolio company perspective):
*Company Name
*Round Number
*Round Date
*Round Amount Disclosed (thou)
*Date Company Received Last Investment
*Date Company Received First Investment
*Company City
*Total Known Amount Invested in Company (thou)
*Company IPO Date
*Company Found Date
*Company Stage Level 3 at Round Date
*Company Industry Minor Group
*Company Industry Sub Group 3
*Company State (Code)
*Compnay MSA (Code)
*Company Street Address, Line 1
*Company Street Address, Line 2
*Company Zip Cd

===Exclusions and Classifications===

Seed/Early/Later (Real VC)
Seed
Early Stage
Later Stage

Other VC
Acq. for Expansion
Acquisition
Bridge Loan
Expansion
Pending Acq
Recap or Turnaround

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

Venture Capital (Data)

2017-04-12T15:54:39Z

JakeSilberman: /* Jake Project */

{{McNair Projects
|Has title=Venture Capital (Data)
|Has owner=Jake Silberman
|Has notes=
|Is dependent on=
|Depends upon it=
|Has project status=Active
|Has keywords=Data
}}

==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
*E:\McNair\Software\Scripts contains normalizing script for round on one line. HubsCapture.pl

===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

==Jake Project==
*1
Rank top 20 cities in the USA for venture capital. Rank by:
# # of deals (1st investments - deal number = 1 or rounddate=datefirstinv)
# amount invested per year (sum of round dollars)
# number of rounds made per year (count of rounds)
# number of IPOs per year (VC backed)
# number of acquisitions per year (VC backed)
# number of alive venture backed firms in a year (had a round within last 5 years and haven't exited)
##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.

Throw out duplicate names for companies (take only the most recent one when duplicates and match on name and first inv).

===Work Details===
*See SQL database 'vcdata' for tables
*SDC data imported into 'vcdata' found in Z:\VentureCapitalData
*Code found in E:\McNair\Projects\VentureCapitalData\SQL Scripts

==SDC Pull==

===Restrictions===
*Nation: U.S. State: TX MSA: Houston, Texas City-Galveston, Brazoria Year: 1980-2017. Venture Related: Yes
*Definition of Houston: MSA Codes for Galveston, Texas City, Brazoria, and Houston, and at state=TX

===Variables Pulled===
Pull round based info (through portfolio company perspective):
*Company Name
*Round Number
*Round Date
*Round Amount Disclosed (thou)
*Date Company Received Last Investment
*Date Company Received First Investment
*Company City
*Total Known Amount Invested in Company (thou)
*Company IPO Date
*Company Found Date
*Company Stage Level 3 at Round Date
*Company Industry Minor Group
*Company Industry Sub Group 3
*Company State (Code)
*Compnay MSA (Code)
*Company Street Address, Line 1
*Company Street Address, Line 2
*Company Zip Cd

===Exclusions and Classifications===

Seed/Early/Later (Real VC)
Seed
Early Stage
Later Stage

Other VC
Acq. for Expansion
Acquisition
Bridge Loan
Expansion
Pending Acq
Recap or Turnaround

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

Venture Capital (Data)

2017-04-12T14:55:10Z

JakeSilberman: /* round on one line */

{{McNair Projects
|Has title=Venture Capital (Data)
|Has owner=Jake Silberman
|Has notes=
|Is dependent on=
|Depends upon it=
|Has project status=Active
|Has keywords=Data
}}

==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
*E:\McNair\Software\Scripts contains normalizing script for round on one line. HubsCapture.pl

===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

==Jake Project==
*1
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.

*2
Rank top 20 cities in the USA for venture capital. Rank by:
# # of deals (1st investments - deal number = 1 or rounddate=datefirstinv)
# amount invested per year (sum of round dollars)
# number of rounds made per year (count of rounds)
# number of IPOs per year (VC backed)
# number of acquisitions per year (VC backed)
# number of alive venture backed firms in a year (had a round within last 5 years and haven't exited)

Throw out duplicate names for companies (take only the most recent one when duplicates and match on name and first inv).

===Work Details===
*See SQL database 'vcdata' for tables
*SDC data imported into 'vcdata' found in Z:\VentureCapitalData
*Code found in E:\McNair\Projects\VentureCapitalData\SQL Scripts

==SDC Pull==

===Restrictions===
*Nation: U.S. State: TX MSA: Houston, Texas City-Galveston, Brazoria Year: 1980-2017. Venture Related: Yes
*Definition of Houston: MSA Codes for Galveston, Texas City, Brazoria, and Houston, and at state=TX

===Variables Pulled===
Pull round based info (through portfolio company perspective):
*Company Name
*Round Number
*Round Date
*Round Amount Disclosed (thou)
*Date Company Received Last Investment
*Date Company Received First Investment
*Company City
*Total Known Amount Invested in Company (thou)
*Company IPO Date
*Company Found Date
*Company Stage Level 3 at Round Date
*Company Industry Minor Group
*Company Industry Sub Group 3
*Company State (Code)
*Compnay MSA (Code)
*Company Street Address, Line 1
*Company Street Address, Line 2
*Company Zip Cd

===Exclusions and Classifications===

Seed/Early/Later (Real VC)
Seed
Early Stage
Later Stage

Other VC
Acq. for Expansion
Acquisition
Bridge Loan
Expansion
Pending Acq
Recap or Turnaround

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

Jake Silberman (Work Log)

2017-04-05T16:28:48Z

JakeSilberman:

Venture Capital (Data)

2017-04-05T16:27:36Z

JakeSilberman: /* Project Idea */

{{McNair Projects
|Has title=Venture Capital (Data)
|Has owner=Jake Silberman
|Has notes=
|Is dependent on=
|Depends upon it=
|Has project status=Active
|Has keywords=Data
}}

==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

==Jake Project==
*1
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.

*2
Rank top 20 cities in the USA for venture capital. Rank by:
# # of deals (1st investments - deal number = 1 or rounddate=datefirstinv)
# amount invested per year (sum of round dollars)
# number of rounds made per year (count of rounds)
# number of IPOs per year (VC backed)
# number of acquisitions per year (VC backed)
# number of alive venture backed firms in a year (had a round within last 5 years and haven't exited)

Throw out duplicate names for companies (take only the most recent one when duplicates and match on name and first inv).

===Work Details===
*See SQL database 'vcdata' for tables
*SDC data imported into 'vcdata' found in Z:\VentureCapitalData
*Code found in E:\McNair\Projects\VentureCapitalData\SQL Scripts

==SDC Pull==

===Restrictions===
*Nation: U.S. State: TX MSA: Houston, Texas City-Galveston, Brazoria Year: 1980-2017. Venture Related: Yes
*Definition of Houston: MSA Codes for Galveston, Texas City, Brazoria, and Houston, and at state=TX

===Variables Pulled===
Pull round based info (through portfolio company perspective):
*Company Name
*Round Number
*Round Date
*Round Amount Disclosed (thou)
*Date Company Received Last Investment
*Date Company Received First Investment
*Company City
*Total Known Amount Invested in Company (thou)
*Company IPO Date
*Company Found Date
*Company Stage Level 3 at Round Date
*Company Industry Minor Group
*Company Industry Sub Group 3
*Company State (Code)
*Compnay MSA (Code)
*Company Street Address, Line 1
*Company Street Address, Line 2
*Company Zip Cd

===Exclusions and Classifications===

Seed/Early/Later (Real VC)
Seed
Early Stage
Later Stage

Other VC
Acq. for Expansion
Acquisition
Bridge Loan
Expansion
Pending Acq
Recap or Turnaround

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

Venture Capital (Data)

2017-04-05T16:24:36Z

JakeSilberman: /* Work Details */

{{McNair Projects
|Has title=Venture Capital (Data)
|Has owner=Jake Silberman
|Has notes=
|Is dependent on=
|Depends upon it=
|Has project status=Active
|Has keywords=Data
}}

==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==
*1
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.

*2
Rank top 20 cities in the USA for venture capital. Rank by:
# # of deals (1st investments - deal number = 1 or rounddate=datefirstinv)
# amount invested per year (sum of round dollars)
# number of rounds made per year (count of rounds)
# number of IPOs per year (VC backed)
# number of acquisitions per year (VC backed)
# number of alive venture backed firms in a year (had a round within last 5 years and haven't exited)

Throw out duplicate names for companies (take only the most recent one when duplicates and match on name and first inv).

===Work Details===
*See SQL database 'vcdata' for tables
*SDC data imported into 'vcdata' found in Z:\VentureCapitalData
*Code found in E:\McNair\Projects\VentureCapitalData\SQL Scripts

==SDC Pull==

===Restrictions===
*Nation: U.S. State: TX MSA: Houston, Texas City-Galveston, Brazoria Year: 1980-2017. Venture Related: Yes
*Definition of Houston: MSA Codes for Galveston, Texas City, Brazoria, and Houston, and at state=TX

===Variables Pulled===
Pull round based info (through portfolio company perspective):
*Company Name
*Round Number
*Round Date
*Round Amount Disclosed (thou)
*Date Company Received Last Investment
*Date Company Received First Investment
*Company City
*Total Known Amount Invested in Company (thou)
*Company IPO Date
*Company Found Date
*Company Stage Level 3 at Round Date
*Company Industry Minor Group
*Company Industry Sub Group 3
*Company State (Code)
*Compnay MSA (Code)
*Company Street Address, Line 1
*Company Street Address, Line 2
*Company Zip Cd

===Exclusions and Classifications===

Seed/Early/Later (Real VC)
Seed
Early Stage
Later Stage

Other VC
Acq. for Expansion
Acquisition
Bridge Loan
Expansion
Pending Acq
Recap or Turnaround

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

Venture Capital (Data)

2017-04-03T15:33:16Z

JakeSilberman: /* Project Idea */

{{McNair Projects
|Has title=Venture Capital (Data)
|Has owner=Jake Silberman
|Has notes=
|Is dependent on=
|Depends upon it=
|Has project status=Active
|Has keywords=Data
}}

==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==
*1
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.

*2
Rank top 20 cities in the USA for venture capital. Rank by:
# # of deals (1st investments - deal number = 1 or rounddate=datefirstinv)
# amount invested per year (sum of round dollars)
# number of rounds made per year (count of rounds)
# number of IPOs per year (VC backed)
# number of acquisitions per year (VC backed)
# number of alive venture backed firms in a year (had a round within last 5 years and haven't exited)

Throw out duplicate names for companies (take only the most recent one when duplicates and match on name and first inv).

===Work Details===
*See Excel Spreadsheet E:\McNair\Projects\VentureCapitalData\VCData Pull 2 Normalized

==SDC Pull==

===Restrictions===
*Nation: U.S. State: TX MSA: Houston, Texas City-Galveston, Brazoria Year: 1980-2017. Venture Related: Yes
*Definition of Houston: MSA Codes for Galveston, Texas City, Brazoria, and Houston, and at state=TX

===Variables Pulled===
Pull round based info (through portfolio company perspective):
*Company Name
*Round Number
*Round Date
*Round Amount Disclosed (thou)
*Date Company Received Last Investment
*Date Company Received First Investment
*Company City
*Total Known Amount Invested in Company (thou)
*Company IPO Date
*Company Found Date
*Company Stage Level 3 at Round Date
*Company Industry Minor Group
*Company Industry Sub Group 3
*Company State (Code)
*Compnay MSA (Code)
*Company Street Address, Line 1
*Company Street Address, Line 2
*Company Zip Cd

===Exclusions and Classifications===

Seed/Early/Later (Real VC)
Seed
Early Stage
Later Stage

Other VC
Acq. for Expansion
Acquisition
Bridge Loan
Expansion
Pending Acq
Recap or Turnaround

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

Jake Silberman (Work Log)

2017-03-27T16:12:44Z

JakeSilberman:

Jake Silberman (Work Log)

2017-03-27T14:59:15Z

JakeSilberman:

Venture Capital (Data)

2017-03-22T15:20:08Z

JakeSilberman: /* Project Idea */

{{McNair Projects
|Has title=Venture Capital (Data)
|Has owner=Jake Silberman
|Has notes=
|Is dependent on=
|Depends upon it=
|Has project status=Active
}}

==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==
*1
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.

*2
Rank top 20 cities in the USA for venture capital. Rank by:
# # of deals (1st investments - deal number = 1 or rounddate=datefirstinv)
# amount invested per year (sum of round dollars)
# number of rounds made per year (count of rounds)
# number of IPOs per year (VC backed)
# number of acquisitions per year (VC backed)
# number of alive venture backed firms in a year (had a round within last 5 years and haven't exited)

Throw out duplicate names for companies (take only the most recent one when duplicates and match on name and first inv).

==SDC Pull==

===Restrictions===
*Nation: U.S. State: TX MSA: Houston, Texas City-Galveston, Brazoria Year: 1980-2017. Venture Related: Yes
*Definition of Houston: MSA Codes for Galveston, Texas City, Brazoria, and Houston, and at state=TX

===Variables Pulled===
Pull round based info (through portfolio company perspective):
*Company Name
*Round Number
*Round Date
*Round Amount Disclosed (thou)
*Date Company Received Last Investment
*Date Company Received First Investment
*Company City
*Total Known Amount Invested in Company (thou)
*Company IPO Date
*Company Found Date
*Company Stage Level 3 at Round Date
*Company Industry Minor Group
*Company Industry Sub Group 3
*Company State (Code)
*Compnay MSA (Code)
*Company Street Address, Line 1
*Company Street Address, Line 2
*Company Zip Cd

===Exclusions and Classifications===

Seed/Early/Later (Real VC)
Seed
Early Stage
Later Stage

Other VC
Acq. for Expansion
Acquisition
Bridge Loan
Expansion
Pending Acq
Recap or Turnaround

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

Jake Silberman (Research Plan)

2017-03-22T15:08:08Z

JakeSilberman:

[[Jake Silberman]] [[Research Plans]] [[Jake Silberman (Research Plan) | Plan Page]]

[[Leveraged Buyout Innovation (Academic Paper)]]
*Finalize Hazard Model
**Determine best regression model (Cox or something else that makes more assumptions)
**Determine finalized variable set
**Predict based on model
*Match LBO and non LBO companies based on hazard model predictions
**Generate buckets, i.e. break down by industry, decade, etc...
**Determine metric for matching
*Integrate new patent data
**Create stocks of patents
**Add in patent assignment data
*Analysis of control group and study group for first results
**Refine matching if necessary
**Test for endogeneity/other issues
*Lit review for variables
**Revise preexisting regression variable write-up and reformat it to appropriate academic paper form

[[Venture Capital (Data)]]
*Do final correct pull of SDC Data (just include IPOS)
*Clean data, throwing out duplicate names and only take most recently invested one
*Rank cities by venture capital on different metrics, either in SQL or Excel
*Write up issue brief

[[Category:Work Log]]

Jake Silberman (Research Plan)

2017-03-22T15:07:44Z

JakeSilberman:

[[Jake Silberman]] [[Research Plans]] [[Jake Silberman (Research Plan) | Plan Page]]

[[Leveraged Buyout Innovation (Academic Paper)]]
*Finalize Hazard Model
**Determine best regression model (Cox or something else that makes more assumptions)
**Determine finalized variable set
**Predict based on model
*Match LBO and non LBO companies based on hazard model predictions
**Generate buckets, i.e. break down by industry, decade, etc...
**Determine metric for matching
*Integrate new patent data
**Create stocks of patents
**Add in patent assignment data
*Analysis of control group and study group for first results
**Refine matching if necessary
**Test for endogeneity/other issues
*Lit review for variables
**Revise preexisting regression variable write-up and reformat it to appropriate academic paper form
[[Category:Work Log]]

[[Venture Capital (Data)]]
*Do final correct pull of SDC Data (just include IPOS)
*Clean data, throwing out duplicate names and only take most recently invested one
*Rank cities by venture capital on different metrics, either in SQL or Excel
*Write up issue brief

Jake Silberman (Work Log)

2017-03-08T17:41:06Z

JakeSilberman:

[[Category:Work Log]]
[[Category:Internal]]

[[Jake Silberman]] [[Work Logs]] [[Jake Silberman (Work Log)|(log page)]]

06/01/2016 15:52 - Introduction/Wiki building

06/02/2016 14:22 - Project refinement & reorganization

06/03/2016 13:30 - Public wiki page development

06/06/2016 13:51 - Further public wiki development

06/07/2016 13:22 - Carried interest debate wiki page writing

06/08/2016 14:54 - Finishing Carried interest debate wiki page, beginning research on history of leveraged buyouts for wiki/blog post

06/09/2016 15:53 - Transfer of wiki pages from private to public

06/10/2016 15:42 - Finished Carried Interest Blog Post

06/13/2016 15:09 - Working on LBO data to match it with patent data

06/14/2016 15:22 - More work on LBO data

06/15/2016 15:20 - Finished work on LBO Data

06/16/2016 15:12 - Beginning of research for LBO academic paper, looking at other scholarly papers

06/20/2016 15:38 - Finding more scholarly papers and writing litreviews, then examining potential variables for the LBO paper

07/15/2016 11:00 - Creating research plan page, updating work log, finalizing hazard models, see [[Leveraged Buyout Innovation (Academic Paper)]] for general summary of work since 06/16/2016

07/18/2016 15:00 - Pulling extra SDC data on LBO's, adjusting work on project to [[Brian Ayash|Brian's]] specs

07/19/2016 12:01 - Repulling SDC data with new variables, normalizing SDC data, then matching SDC data and private to private LBO data from the original LBO data to the working set in order to get more LBO matches.

07/20/2016 14:00 - Joining new LBO deals in the 5000s to working data set

07/26/2016 15:52 - finished incorporating 5000s lbo deals into data set, now beginning reorganization of scripts and past work to make it simpler/easier to follow and execute

07/27/2016 11:25 - Reorganizing scripts and helping Ed/James Brander with [[Winner's Curse]].

07/28/2016 12:00 - Cleaning LBO SQL scripts

07/29/2016 13:45 - Cleaning LBO SQL scripts and helping Ed/James Brander a bit more with [[Winner's Curse]]

08/01/2016 13:57 - Examining corporate governance databases to solidify measures for [[Winner's Curse]]

09/06/2016 13:00 - Getting reacquainted with the LBO Project

09/08/2016 13:10 - Continuing research into data for [[Winner's Curse]]

09/15/2016 15:04 - Finding variables/data sources for [[Winner's Curse]]

02/13/2017 10:30 - Locating variables for [[Venture Capital (Data)]] in SDC

02/15/2017 10:08 - Trying to locate several more variables for [[Venture Capital (Data)]] in SDC, then begin work to make data sets in SQL

02/17/2017 12:18 - Running SDC pulls for Company Level, Main Round, and Round on One Line (if Main Round finishes up).

02/20/2017 10:22 - Normalizing Main Round, organizing data in folders

02/22/2017 10:00 - Pulling Round on One Line (and normalizing, as long as it doesn't crash), and creating database in SQL to import them into

03/06/2017 11:12 - Beginning work for Venture Capital Data Issue Brief

03/08/2017 11:42 - Did first SDC Pull for VC Data and began cleaning data/making graphs

Venture Capital (Data)

2017-03-06T17:07:23Z

JakeSilberman: /* Project Idea */

Venture Capital (Data)

2017-03-06T17:02:52Z

JakeSilberman: /* Project Idea */

{{McNair Projects
|Has title=Venture Capital (Data)
|Has owner=Jake Silberman
|Has notes=
|Is dependent on=
|Depends upon it=
|Has project status=Active
}}

==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==
*1
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.

*2
Rank top 20 cities in the USA for venture capital. Rank by # of deals, amount invested per year, any other measures that come up. Throw out duplicate names for companies and take only the most recent one.

Venture Capital (Data)

2017-03-03T19:58:30Z

JakeSilberman: /* Work Details */

Venture Capital (Data)

2017-02-27T16:44:02Z

JakeSilberman:

{{McNair Projects
|Project Title=Venture Capital (Data),
|Owner=Jake Silberman,
|Status=Active
}}

==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

==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.

Venture Capital (Data)

2017-02-22T17:22:47Z

JakeSilberman: /* Experimental Pull */

{{McNair Projects
|Project Title=Venture Capital (Data),
|Owner=Jake Silberman,
|Status=Active
}}

==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

==Experimental Pull==
*5 Pulls, all under MSA Houston/Galveston/Brazoria filter
**Firm Level
***portco name
***
**Fund Level
**Company Level
**Round Level
**Round on One Line

==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.

Venture Capital (Data)

2017-02-22T17:21:20Z

JakeSilberman:

{{McNair Projects
|Project Title=Venture Capital (Data),
|Owner=Jake Silberman,
|Status=Active
}}

==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

==Experimental Pull==
*Firm Level
*Fund Level
*Company Level
*Round Level
*Round on One Line

==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.

Jake Silberman (Work Log)

2017-02-22T15:59:30Z

JakeSilberman:

Jake Silberman (Work Log)

2017-02-17T18:18:34Z

JakeSilberman:

Venture Capital (Data)

2017-02-15T17:07:28Z

JakeSilberman: /* round on one line */

{{McNair Projects
|Project Title=Venture Capital (Data),
|Owner=Jake Silberman,
|Status=Active
}}

==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

==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.

Venture Capital (Data)

2017-02-15T16:43:41Z

JakeSilberman: /* round on one line */

{{McNair Projects
|Project Title=Venture Capital (Data),
|Owner=Jake Silberman,
|Status=Active
}}

==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 - 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

==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.

Venture Capital (Data)

2017-02-15T16:37:06Z

JakeSilberman: /* round on one line */

{{McNair Projects
|Project Title=Venture Capital (Data),
|Owner=Jake Silberman,
|Status=Active
}}

==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 - 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
*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

==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.

Jake Silberman (Work Log)

2017-02-15T16:09:07Z

JakeSilberman:

Venture Capital (Data)

2017-02-13T16:58:31Z

JakeSilberman: /* Variables to Pull */

{{McNair Projects
|Project Title=Venture Capital (Data),
|Owner=Jake Silberman,
|Status=Active
}}

==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==
#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

==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.

Venture Capital (Data)

2017-02-13T16:18:48Z

JakeSilberman: /* Data sets to build */

Venture Capital (Data)

2017-02-13T16:18:22Z

JakeSilberman: /* Fund Level */

Venture Capital (Data)

2017-02-13T16:17:31Z

JakeSilberman: /* Company Level */

Venture Capital (Data)

2017-02-13T16:08:21Z

JakeSilberman: /* Company Level */

Venture Capital (Data)

2017-02-13T16:07:07Z

JakeSilberman: /* Company Level */

Venture Capital (Data)

2017-02-13T16:03:14Z

JakeSilberman: /* Data sets to build */

Venture Capital (Data)

2017-02-08T16:56:35Z

JakeSilberman: /* Variables to Pull */

Venture Capital (Data)

2017-02-08T16:54:53Z

JakeSilberman: /* Data sets to build */

Venture Capital (Data)

2017-02-08T16:54:34Z

JakeSilberman: /* Fund Level */

Venture Capital (Data)

2017-02-08T16:45:49Z

JakeSilberman: /* Variables to Pull */

Venture Capital (Data)

2017-02-08T16:16:07Z

JakeSilberman: /* Data sets to build */

Venture Capital (Data)

2017-02-08T16:05:47Z

JakeSilberman: /* Arching Objective */

Venture Capital (Data)

2017-02-06T17:48:24Z

JakeSilberman:

{{McNair Projects
|Project Title=Venture Capital (Data),
|Owner=Jake Silberman,
|Status=Active
}}

==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.

Venture Capital (Data)

2017-02-06T17:16:56Z

JakeSilberman: /* Arching Objective */

{{McNair Projects
|Project Title=Venture Capital (Data),
|Owner=Jake Silberman,
|Status=Active
}}

=Arching Objective=

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=

Venture Capital (Data)

2017-02-06T17:10:32Z

JakeSilberman:

Venture Capital (Data)

2017-02-06T17:10:04Z

JakeSilberman:

1st and Future

2017-02-03T22:15:25Z

JakeSilberman: /* Startups */

1st and Future

2017-02-03T22:13:43Z

JakeSilberman: /* Revenue & Funding Table */

=Startups=

==Revenue & Funding Table==
{|
| || Revenue || Rev Descr. || Funding || F. Type
|-
| Elevety || $140k || purchase orders - launch :jan26 || $1 million || Seed
|-
| Gorout || $750-850k || projected 2017 || $1 million || Seed
|-
| LinkPro || Pre-rev || || £505k || Seed
|-
| The Iron Neck || $200k || 2016 || $500k || Friends/Family
|-
| LVL || $1.3 million || total || $5 million || Seed
|-
| Mobile Virtual Player || $8.3k || Started sales August 2016 || $1.4 million || Seed
|-
| 2ND Skull || $500k - $1 mil || projected 2017 || $2 million || Seed
|-
| Prevent Biometrics || ~$100k || 2016 || $2.5 million || Series A
|-
| Windpact || $20k || Started sales Nov. 2016 || $1.9 million || Seed
|}

==Communicating with the Athlete==

===Elevety===
Funding - $1 million (seed funding)

Revenue - $140k (purchase orders - launch: Jan. 26)

'''Sebastian Koper (Co-Founder)'''
*First Startup Experience
*Background in strategy consulting and engineering
'''Bart Lipski (Co-Founder)'''
*Second Startup Experience after Stylehopper: high end retail website for designer brands. Doesn't seem to exist anymore.
*Background in Management Consulting, Digital marketing

===Gorout===
Funding - $1 million (seed funding)

Revenue - $750-850k (projected revenue - 2017)

'''MikeRolih (CEO)'''
*Seems to be his second time expanding an early stage company

===LinkPro===
Funding - £505,000 (seed funding)

Revenue - Pre-revenue

==Training the athlete==

===The Iron Neck===
Funding - $500k (friends & family)

Revenue - $200k (2016)

===LVL===
Funding - $5 million (seed funding )

Revenue - $1.3 million (total)

===Mobile Virtual Player===
Funding - $1.4 million (seed funding)

Revenue - $8.3k (2016 - started sales in August 2016)

==Materials to Protect the Athlete==

===2ND Skull===
Funding - $2 million (seed funding)

Revenue - $500k - $1 million (projected revenue - 2017)

===Prevent Biometrics===
Funding - $2.5 million (Series A)

Revenue - ~ $100k (2016)

===Windpact===
Funding - $1.9 million (seed funding)

Revenue - $20k (revenue to date - began sales in Nov. 2016)

1st and Future

2017-02-03T22:10:23Z

JakeSilberman: /* Startups */

=Startups=

==Revenue & Funding Table==
{|
| || Revenue || Rev Descr. || Funding || F. Type
|-
| Elevety || $1 million || purchase orders - launch :jan26 || $1 million || Seed
|-
| Gorout || $750-850k || projected 2017 || $1 million || Seed
|-
| LinkPro || Pre-rev || || £505k || Seed
|-
| The Iron Neck || $200k || 2016 || $500k || Friends/Family
|-
| LVL || $1.3 million || total || $5 million || Seed
|-
| Mobile Virtual Player || $8.3k || Started sales August 2016 || $1.4 million || Seed
|-
| 2ND Skull || $500k - $1 mil || projected 2017 || $2 million || Seed
|-
| Prevent Biometrics || $100k || 2016 || $2.5 million || Series A
|-
| Windpact || $20k || Started sales Nov. 2016 || $1.9 million || Seed
|}

==Communicating with the Athlete==

===Elevety===
Funding - $1 million (seed funding)

Revenue - $140k (purchase orders - launch: Jan. 26)

'''Sebastian Koper (Co-Founder)'''
*First Startup Experience
*Background in strategy consulting and engineering
'''Bart Lipski (Co-Founder)'''
*Second Startup Experience after Stylehopper: high end retail website for designer brands. Doesn't seem to exist anymore.
*Background in Management Consulting, Digital marketing

===Gorout===
Funding - $1 million (seed funding)

Revenue - $750-850k (projected revenue - 2017)

'''MikeRolih (CEO)'''
*Seems to be his second time expanding an early stage company

===LinkPro===
Funding - £505,000 (seed funding)

Revenue - Pre-revenue

==Training the athlete==

===The Iron Neck===
Funding - $500k (friends & family)

Revenue - $200k (2016)

===LVL===
Funding - $5 million (seed funding )

Revenue - $1.3 million (total)

===Mobile Virtual Player===
Funding - $1.4 million (seed funding)

Revenue - $8.3k (2016 - started sales in August 2016)

==Materials to Protect the Athlete==

===2ND Skull===
Funding - $2 million (seed funding)

Revenue - $500k - $1 million (projected revenue - 2017)

===Prevent Biometrics===
Funding - $2.5 million (Series A)

Revenue - ~ $100k (2016)

===Windpact===
Funding - $1.9 million (seed funding)

Revenue - $20k (revenue to date - began sales in Nov. 2016)

1st and Future

2017-02-03T22:09:57Z

JakeSilberman: /* Startups */

=Startups=

Revenue & Funding Table
{|
| || Revenue || Rev Descr. || Funding || F. Type
|-
| Elevety || $1 million || purchase orders - launch :jan26 || $1 million || Seed
|-
| Gorout || $750-850k || projected 2017 || $1 million || Seed
|-
| LinkPro || Pre-rev || || £505k || Seed
|-
| The Iron Neck || $200k || 2016 || $500k || Friends/Family
|-
| LVL || $1.3 million || total || $5 million || Seed
|-
| Mobile Virtual Player || $8.3k || Started sales August 2016 || $1.4 million || Seed
|-
| 2ND Skull || $500k - $1 mil || projected 2017 || $2 million || Seed
|-
| Prevent Biometrics || $100k || 2016 || $2.5 million || Series A
|-
| Windpact || $20k || Started sales Nov. 2016 || $1.9 million || Seed
|}

==Communicating with the Athlete==

===Elevety===
Funding - $1 million (seed funding)

Revenue - $140k (purchase orders - launch: Jan. 26)

'''Sebastian Koper (Co-Founder)'''
*First Startup Experience
*Background in strategy consulting and engineering
'''Bart Lipski (Co-Founder)'''
*Second Startup Experience after Stylehopper: high end retail website for designer brands. Doesn't seem to exist anymore.
*Background in Management Consulting, Digital marketing

===Gorout===
Funding - $1 million (seed funding)

Revenue - $750-850k (projected revenue - 2017)

'''MikeRolih (CEO)'''
*Seems to be his second time expanding an early stage company

===LinkPro===
Funding - £505,000 (seed funding)

Revenue - Pre-revenue

==Training the athlete==

===The Iron Neck===
Funding - $500k (friends & family)

Revenue - $200k (2016)

===LVL===
Funding - $5 million (seed funding )

Revenue - $1.3 million (total)

===Mobile Virtual Player===
Funding - $1.4 million (seed funding)

Revenue - $8.3k (2016 - started sales in August 2016)

==Materials to Protect the Athlete==

===2ND Skull===
Funding - $2 million (seed funding)

Revenue - $500k - $1 million (projected revenue - 2017)

===Prevent Biometrics===
Funding - $2.5 million (Series A)

Revenue - ~ $100k (2016)

===Windpact===
Funding - $1.9 million (seed funding)

Revenue - $20k (revenue to date - began sales in Nov. 2016)

How to Start a Company in Texas

2017-02-03T21:37:24Z

JakeSilberman: /* Step 1: Business Structure and Name */

This page is a part of the McNair Center's [[Guide to Small Business in Houston]].

This is an overview on how to create a business in Texas. For more comprehensive guidance and assistance, consult the [https://texaswideopenforbusiness.com/sites/default/files/pdfs/smallbusinesshandbook.pdf Texas Small Business Handbook].

==Basic Process==
==='''Step 1: Business Structure and Name'''===

'''Determine the legal structure of the business and properly file the business name with the state and/or county.'''

*Search for existing [http://www.uspto.gov/trademarks-application-process/search-trademark-database trademarks] - Free

*Reserve a name for 120 days:
**Complete [http://www.sos.state.tx.us/corp/forms/501_boc.pdf Form 501] located at - $40
**Or reserve a name online at [http://www.sos.state.tx.us/corp/sosda/index.shtml SOSDirect] - $50 per [https://direct.sos.state.tx.us/help/help-corp.asp?pg=fee class]

*Prepare a certificate of formation:
**Download the [http://www.sos.state.tx.us/corp/forms/201_boc.pdf form] - $300
**Or file online at [http://www.sos.state.tx.us/corp/sosda/index.shtml SOSDirect] ($300) and prepare the following necessary information:
***The name and type of entity being formed;
*** The names and addresses of directors and registered agents;
*** The number and value of initial authorized shares;
*** The business purpose for which the entity is being formed;
*** The name and address of the organizer (i.e., the person responsible for incorporating the company);
*** The effectiveness of the filing, which means when you want the document and the entity to become effective; and
***The signature of the organizer.

{| class="wikitable sortable" style="border: 1px solid darkgray; bgcolor: #f9f9f9"
|+ align="center" size="14px"|'''Business Filing Fees'''
| align="center" style="background:#f0f0f0;"|'''Business Type'''
| align="center" style="background:#f0f0f0;"|'''Filing Fee ($)'''
| align="center" style="background:#f0f0f0;"|'''State Franchise Tax'''
|-
| Sole Proprietorship||0||Yes
|-
| For-Profit Corporation||300||Yes
|-
| Professional Corporation||300||Yes
|-
| Professional Association||0||Yes
|-
| General Partnership||0||No
|-
| Limited Partnership||750||Yes
|-
| Limited Liability Partnership||200||Yes
|-
| Limited Liability Company||300||Yes
|}

==='''Step 2: Tax Responsibilities'''===

'''Determine the potential tax responsibilities of the new business on the federal, state, and local level.'''

*[https://www.irs.gov/businesses/small-businesses-self-employed/how-to-apply-for-an-ein Apply] for a Employer Identification Number (EIN) (alternatively called Federal Tax Identification Number)
**Texas requires that an EIN for businesses, which is used for tax purposes.

*'''Federal Taxes'''
**The Internal Revenue Service will identify and determine your tax liability.

*'''State Taxes'''
**The state of Texas imposes a state sales tax on "all retail sales, leases and rentals of goods, and services that are expressly enumerated as taxable under the Texas Tax Code." Additionally, any taxable business chartered, organized, or doing business is subject to a state franchise tax. That said, most small businesses are exempt from this kind of tax.

*'''Local Taxes'''
**Business Inventory Taxes will be collected at the local level, although many municipalities do not tax items that fall under “Goods in Transit Exemption” or the “Freeport Exemption.”

*'''Other Taxes'''
**The Texas Workforce Commission will collect Unemployment Insurance tax from most businesses.

==='''Step 3: Licensing and Permits'''===

'''Determine necessary licenses, permits, certifications, registrations, and/or authorizations for a specific business on the federal, state, and local level.'''

*Create bylaws. While Texas does not set out any concrete requirements for a corporation's bylaws, the bylaws usually contain information about internal rules and procedures, responsibilities of officers, the size of the board, how shareholder meetings will be held.[http://www.dmlp.org/legal-guide/forming-corporation-texas]
** You don't have to file these bylaws with the Secretary of State. However, Texas law requires you keep this document at your main office.[http://www.statutes.legis.state.tx.us/DocViewer.aspx?DocKey=BO%2fBO.21&Phrases=%22Bylaws%22&HighlightType=1&ExactPhrase=True&QueryText=%22Bylaws%22]
** You can also look up [http://business.utsa.edu/cite/files/spring15/12083328_2_Bylaws%20(Texas%20Corporation).pdf sample] Texas bylaws in order to get an idea of what should be included.

*There is no general "business" license in the state of Texas.
*There are different licensing procedures for various professions.
**The Texas Department of Licensing and Registration has a full [http://www.tdi.texas.gov/forms/fincolicense/fin325retalreqs.pdf list] of the specific professions that need additional accreditation.
*You should also contact the local government of the city you are choosing to operate in to find out if there are any specific licensing needed to conduct business.

==='''Step 4: Federal and State Employer Requirements'''===

'''Determine federal and state employer requirements. There are various laws relating to employment of personnel.'''

Small business owners must fulfill requirements related to:
*Americans with Disabilities Act requirements
*Equal Employment requirements
*Safety requirements
*Wage and Labor requirements
*New Hire Reporting
*Workers' Compensation Insurance reporting
*Labor Posters placement
*Other relevant requirements

==Common Forms and Fees for Texas Small Businesses==

{| class="wikitable sortable" style="border: 1px solid darkgray; bgcolor: #f9f9f9"
|+ align="center" size="14px"|'''Common Forms and Fees'''
| align="center" style="background:#f0f0f0;"|'''Filing Type'''
| align="center" style="background:#f0f0f0;"|'''Additional Form(s)'''
| align="center" style="background:#f0f0f0;"|'''Filing Fee ($)'''
|-
| Certificate of fact||||15
|-
| Expedited processing of a request for a certified copy or certificate of status or fact||||10
|-
| Certificate of formation for an entity (except nonprofit corporation, cooperative association, PA or LP).||[http://www.sos.state.tx.us/corp/forms/201_boc.pdf 201],[http://www.sos.state.tx.us/corp/forms/203_boc.pdf 203], [http://www.sos.state.tx.us/corp/forms/205_boc.pdf 205], [http://www.sos.state.tx.us/corp/forms/206_boc.pdf 206]||300
|-
| Certificate of formation for a nonprofit corporation||[http://www.sos.state.tx.us/corp/forms/202_boc.pdf 202]||25
|-
| Certificate of formation for a cooperative association corporation||||25
|-
| Certificate of formation for a limited liability partnership or LLLP||[http://www.sos.state.tx.us/corp/forms/701_boc.pdf 701], [http://formfiles.justia.com/pdf/texas/0285/52.pdf 703]||750
|-
| Name reservation (120 days) or renewal||[http://www.sos.state.tx.us/corp/forms/501_boc.pdf 501]||40
|-
| Registration of trademark||[http://www.sos.state.tx.us/corp/forms/901.pdf 901]||50 (per class)
|-
| Expedited processing of a document submitted for filing (except trademark documents)||||25
|}

For a comprehensive list of all forms used to register a business or nonprofit, please see [http://www.sos.state.tx.us/corp/forms_boc.shtml the SoS's compiled list].

For a comprehensive list of all forms used to trademark corporations, please see [http://www.sos.state.tx.us/corp/trademark.shtml the SoS's compilation of trademark forms].

For a comprehensive list of report forms, please see [http://www.sos.state.tx.us/corp/forms_reports.shtml the SoS's compiled list].

The SoS has also created a [http://www.sos.state.tx.us/corp/formationfaqs.shtml Business Formation FAQ].
===Payment Methods===

Fees may be paid by:
*Check (personal or firm checks accepted) or money order payable to the Secretary of State through a U.S. Bank or financial institution
*Credit card (Credit card payments are subject to an additional statutory convenience fee of 2.7% of amount charged.)
*LegalEaseSM debit card
*Prefunded SOS client account
*Cash (for in-person submissions only)

[[Category: SBDE]]
[[category:Public]]