216
edits
Changes
Jump to navigation
Jump to search
Shrey Agarwal (Work Log) (view source)
Revision as of 18:17, 7 November 2017
, 18:17, 7 November 2017→Fall 2017
9/29/17 15:00 - 17:00
*Spoke with Ed about incubators project, will begin as soon as we can time the accelerator startup investments. Ed is expecting us to begin sometime in the next two months, using a similar process as we did for incubators. The process should be handled by a new worker.
10/02/17 15:00 - 17:00
*Talked to Ed about next steps for the project. Practiced accessing the CrunchBase database on SQL and brushed up on SQL code.
10/03/17 15:00 - 17:00
*Sifted through the database for Crunchbase investment information.
10/04/17 15:00 - 17:00
*Pulled the funding rounds table from SQL and matched it with the companies that have received VC funding in order to gather round dates.
10/06/17 15:00 - 17:00
*Went through the matched data. Brainstormed ways to get the dates for cohort companies going through accelerators.
10/11/17 15:00 - 17:00
*Looked into using the WhoIs Parser in order to find when the companies went through their accelerators.
10/12/17 15:00 - 17:00
*Discovered that the Wayback Machine will not be a good option for identifying the time when a company went through the accelerator. Created a list of VC Companies and their earliest round date. Included a column for the date they went through their accelerators and will fill it in when we find a good method of finding this date.
10/16/17 15:00 - 17:00
*Continued working on sorting VCCompanies by their earliest round date.
10/17/17 15:00 - 17:00
*Worked with Ben to find a solution to our problem of data acquisition. Finalized earliest round date for VCCompanies.
10/18/17 15:00 - 17:00
*Updated our VC data with Ed's help in order to increase the accuracy and completion of our data.
10/19/17 15:00 - 17:00
*Organized all of our matched data and updated it in order to reflect the most recent SDC pull with Ed. Matched Crunchbase data with our cohort companies.
10/20/17 15:00 - 17:00
*Generated the new list of VCCompanies as well as their earliest round dates.
10/23/17 15:00 - 17:00
*Worked on sorting out the discrepancies in our matched data.
10/24/17 15:00 - 17:00
*Went through list of VCCompanies and began adding respective accelerators in order to proceed with VCPercentage table.
10/25/17 15:00 - 17:00
*Continued going through list of VCCompanies and adding accelerators.
10/26/17 15:00 - 17:00
*Continued going through list of VCCompanies and adding accelerators. Will have this completed on Monday.
10/30/17 15:00 - 17:00
*Finished adding all of the accelerators to the list of VCCompanies. Added a column indicating whether or not the company went through two or more accelerators.
10/31/17 15:00 - 17:00
*Began compiling data in the column for the dates that a specific company went through an Accelerator.
11/01/17 15:00 - 17:00
*Finalized entering dates for Y Combinator cohort companies.
11/02/17 15:00 - 17:00
*Continued entering cohort company dates into Excel file.
11/06/17 15:00 - 17:00
*Began looking at keywords for identifying the cohort class dates for each company
11/07/17 15:00 - 17:00
*Received list from Peter with the accelerator founders matched from the Crunchbase LinkedIn URLs and proceeded to find the links for those founders without a match on Crunchbase. Data found in "Unfound Founders List" in the Fall 2017 folder
</onlyinclude>
