7,649
edits
Changes
Jump to navigation
Jump to search
VC Database Rebuild (view source)
Revision as of 11:27, 27 September 2017
, 11:27, 27 September 2017→Build dead/alive flags
--42296
\COPY alivecount TO 'alivecount.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
'''NOTES FROM ED:'''
*There wasn't a full population deadalive portco level keyed table, so I made one
DROP TABLE PortCoDeadAliveMaster;
CREATE TABLE PortCoDeadAliveMaster as
SELECT coname, city, statecode, datefirstinv, datelastinv, deaddate, extract(year from datefirstinv) as aliveyear,
extract(year from deaddate) AS deadyear
FROM deadalive;
--44740
This code is in '''FixingVCDB2.sql''' in Z:\VentureCapitalData\SDCVCData\vcdb2
==Creating coleveloutput==
One of the output tables required by the other researchers is the coleveloutput table. It contains company, geo and ipo/ma details in the form of aliveyear, deadyear. Here's how you build it:
