158
edits
Changes
Jump to navigation
Jump to search
SELECT COUNT(*) FROM CohortCoExtended WHERE year IS NOT NULL AND quarter IS NOT NULL AND gotvc=1;Line 136 of count------- 661(1 row) E:\McNair\Software\Database Scripts\Crunchbase2\CompanyMatchScript.sql
vcdb2=# SELECT COUNT(*) FROM CohortCoExtended WHERE year IS NOT NULL AND gotvc=1;contains 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'''. count------- 684(1 rowA list of distinct accelerators was also created, which was given to [[Minh Le]]
Merging Existing Data with Crunchbase (view source)
Revision as of 11:29, 20 July 2018
, 11:29, 20 July 2018no edit summary
==Getting Timing info for Companies Who Got VC==
