Difference between revisions of "Crunchbase Accelerator Equity"
Maxine.tao (talk | contribs) |
Maxine.tao (talk | contribs) |
||
| Line 6: | Line 6: | ||
}} | }} | ||
==Files and Comments== | ==Files and Comments== | ||
| + | The following does not result in useful data. | ||
| + | |||
E:\McNair\Software\Database Scripts\Crunchbase2\EquityAnalysis.sql | E:\McNair\Software\Database Scripts\Crunchbase2\EquityAnalysis.sql | ||
| Line 14: | Line 16: | ||
An excel workbook version of 'AccInvestComp.txt' can be found here: | An excel workbook version of 'AccInvestComp.txt' can be found here: | ||
| − | E:\McNair\Projects\Accelerators\Summer 2018\Accelerators and Investments | + | E:\McNair\Projects\Accelerators\Summer 2018\Accelerators and Investments.xlsx |
| + | |||
| + | In the second sheet of the file above, there is a list of investments that match the terms given on the accelerator website. These are filtered from the first sheet of all accelerator and investment matches. | ||
| − | + | There is a list of companies without cohort years in the Accelerator Master List. I matched these against the data in AccInvestComp and could only find 5 companies that matched. The results can be found in: | |
| + | E:\McNair\Projects\Accelerators\Summer 2018\accelerator match cohorts.xlsx | ||
==Related Pages== | ==Related Pages== | ||
[[Crunchbase Data]] | [[Crunchbase Data]] | ||
[[Crunchbase Accelerator Founders]] | [[Crunchbase Accelerator Founders]] | ||
Revision as of 16:06, 29 June 2018
| Crunchbase Accelerator Equity | |
|---|---|
| Project Information | |
| Project Title | Crunchbase Accelerator Equity |
| Owner | Maxine Tao |
| Start Date | Summer 2018 |
| Deadline | |
| Primary Billing | |
| Notes | |
| Has project status | Active |
| Copyright © 2016 edegan.com. All Rights Reserved. | |
Files and Comments
The following does not result in useful data.
E:\McNair\Software\Database Scripts\Crunchbase2\EquityAnalysis.sql
In the crunchbase2 folder of Z, 'AccInvestComp.txt' is a list of accelerator names, the companies they invest in, the date of investment, the company UUID, and the investor UUID. This file was made by matching accelerator UUIDs from the final list of accelerators against the a table called funding_rounds from crunchbase. Code can be found in EquityAnalysis.sql
Most of these investments are marked as seed investment types.
An excel workbook version of 'AccInvestComp.txt' can be found here:
E:\McNair\Projects\Accelerators\Summer 2018\Accelerators and Investments.xlsx
In the second sheet of the file above, there is a list of investments that match the terms given on the accelerator website. These are filtered from the first sheet of all accelerator and investment matches.
There is a list of companies without cohort years in the Accelerator Master List. I matched these against the data in AccInvestComp and could only find 5 companies that matched. The results can be found in:
E:\McNair\Projects\Accelerators\Summer 2018\accelerator match cohorts.xlsx
