474
edits
Changes
Jump to navigation
Jump to search
NOTE: USVCFirms1980-Present-normal.txt has been loaded as "firms" for now. Will drop and recreate table as "firmbase" after Ed checks off.
LoadFirmsLoadFirms2.sql
Retrieving US VC Data From SDC (view source)
Revision as of 17:42, 24 October 2017
, 17:42, 24 October 2017→Branch Offices
VCFunds1980-present.rpt
Created: 69/1628/2017 3:2816:23 59 PM
Session Contents:
===VC Firms===
Core Files:
FIRM_TYPE_DESC
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
