Changes

Jump to navigation Jump to search
no edit summary
#Work on the [[Crunchbase 2013 Snapshot]]
#Match cohort companies to VC -backed portfolio companies
#Refine our data to work out which cohort each cohort company was a member of, cohort start dates and locations, etc.
#Make a list of top accelerator lists (e.g., http://tech.co/top-startup-accelerators-ranked-2012-08) and check that we have those accelerators
=Data Collection Notes=
 
==MATCHING==
 
The files we used to match are located in the E drive. We used the matcher to match our portfolio company names from the cohort file located in E:\McNair\Projects\Accelerators.
*The files used to matching are located E:\McNair\Projects\Accelerators\Matcher
*Portco is the name of the companies pulled from the cohort file
*AccCo includes both the cohort company name, along with the name of the accelerator itself
*In the matcher, the inputs are the PortCo names, as well as the VC data from our pull in SDC
*The outputs include the AccCo_VC data located in E:\McNair\Projects\Accelerators which give a lot of information on the matches, including:
:*name of the match itself
:*number of investments
:*dates that the company received its investments
 
==SDC Pull==
 
We accessed SDC platinum and pulled information on round-based funding that all registered companies received from between the years 1999 to 2017.
 
The receipt is as follows:
 
Session Details
---------------
Request Hits Request Description
0 - DATABASE: Portfolio Companies (VIPC)
1 96155 Venture Related Deals: Select All Venture Related Deals
2 79572 Round Date: 1/1/1999 to 3/1/2017 (Custom) (Calendar)
3 Custom Report: VC Data (Columnar) - Save As:
E:\McNair\Projects\Accelerators\VC Data.txt
Billing Ref # : 2054025
Capture File : riceuniv.2054025
Session Name :
 
The VC data pull includes the following variables:
 
Company Name Date Company Date Company Company Company City Company Street Address, Line 1 Company Street Address, Line 2 Total Known Company Industry Sub-Group 3 Company Industry Major Group Round Company Stage Level 3 Round Amt, Round Amt,
 
==3 files==
216

edits

Navigation menu