474
edits
Changes
Jump to navigation
Jump to search
Retrieving US VC Data From SDC (view source)
Revision as of 15:08, 18 October 2017
, 15:08, 18 October 2017ââVC Firms
===VC Firms===
NOTE: USVCFirms1980-Present-normal.txt has been loaded as "firms" for now. Will drop and recreate table as "firmbase" after Ed checks offin vcdb2.
LoadFirms.sql
DROP TABLE firmsfirmbase; CREATE TABLE firmsfirmbase(
firmname varchar(255),
foundingdate date, --mm-dd-yyyy
);
\COPY firms firmbase FROM 'USVCFirms1980-Present-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--9734
