Changes

Jump to navigation Jump to search
no edit summary
{{Project|Has project output=Data|Has sponsor=McNair ProjectsCenter
|Has title=Merging Existing Data with Crunchbase
|Has owner=Connor Rothschild
==Getting Timing info for Companies Who Got VC==
SELECT COUNT(*) FROM CohortCoExtended WHERE year IS NOT NULL AND quarter IS NOT NULL AND gotvc=1;Line 136 of count E:\McNair\Software\Database Scripts\Crunchbase2\CompanyMatchScript.sql------- 661contains the code to find the companies which recieved VC but did not have timing info. There are 809 such companies. This table was exported into '''needtiminginfo.txt'''. (1 row)A list of distinct accelerators that we need timing data for was also created, which was given to [[Minh Le]]. There's 75 accelerators that need their timing doing.
vcdb2=# SELECT COUNTDoing training data - 2,600 pages and are a little bit more than 1/2 way (*~1500-1600) FROM CohortCoExtended WHERE year IS NOT NULL AND gotvc=1;count------- 684(1 row.

Navigation menu