474
edits
Changes
Jump to navigation
Jump to search
NOTE: USVCFirms1980-present-normal.txt and USVCFirmBranchOffices1980-present-normal.txt are already saved in vcdb2 in Venture Capital Data (and in E drive). They have not been loaded into tables yet. (Correct SQL code to load them is below but the codes are not saved as sql files yet.
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 firmbase;
CREATE TABLE firmbase (
firmname varchar(255),
foundingdate date, --mm-dd-yyyy
\COPY firmbase FROM 'USVCFirms1980-Present-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--9734
===Branch Offices===
);
\COPY branchoffices FROM 'USVCFirmBranchOffices1980-Present-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS CSV --9734
==Company Long Description==
