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
bonation varchar(100),
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:
USVCFirms1980-presentPresent.rpt USVCFirms1980-presentPresent.ssh USVCFirms1980-presentPresent.txt USVCFirms1980-presentPresent-normal.txt
Created: 9/29/2017 3:46:06 PM
FIRM_TYPE_DESC
DROP TABLE firmbase;
CREATE TABLE firmbase ( firmname varchar(255), foundingdate date, --mm-dd-yyyy datefirstinv date, --mm-dd-yyyy datelastinv date, --mm-dd-yyyy addr1 varchar(100), addr2 varchar(100), location varchar(100), city varchar(100), zip varchar(10), areacode integer, county varchar(100), city varchar(100), state varchar(2), nationcode varchar(10), nation varchar(100), worldregion varchar(100), numportcos integer, numrounds integer, investedk money, capitalundermgmt money, invstatus varchar(100), msacode varchar(10), rolepref varchar(100), geogpref varchar(100), indpref varchar(100), stagepref varchar(100), type varchar(100),
);
\COPY firmbase FROM 'VCFirms1980USVCFirms1980-presentPresent-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV --9734
===Branch Offices===
DROP TABLE branchoffices;
CREATE TABLE branchoffices (
firmname varchar(100255),
bocity varchar(100),
bostate varchar(2),
bocountrycode varchar(2),
bozip varchar(10),
boaddr1 varchar(100),
boaddr2 varchar(100),
);
\COPY branchoffices FROM 'USVCFirmBranchOffices1980-Present-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS CSV
--9734
==Company Long Description==
