474
edits
Changes
Jump to navigation
Jump to search
LoadFirmsLoadFirms2.sql
USVCFirmBranchOfficesUSVCFirmBranchOffices1980-Present.rpt USVCFirmBranchOfficesUSVCFirmBranchOffices1980-Present.ssh USVCFirmBranchOfficesUSVCFirmBranchOffices1980-Present.txt USVCFirmBranchOfficesUSVCFirmBranchOffices1980-Present-normal.txt
bonation varchar(100),
bonationcode bocountrycode varchar(2),
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===
Core Files
Created: 9/29/2017 3:54:32 PM
DROP TABLE branchoffices;
CREATE TABLE branchoffices (
firmname varchar(255),
bocity varchar(100),
bostate varchar(2),
bonation varchar(100),
bozip varchar(10),
boaddr1 varchar(100),
boaddr2 varchar(100),
);
\COPY firmbase branchoffices FROM 'VCFirms1980USVCFirmBranchOffices1980-presentPresent-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS CSV --9734
==Company Long Description==
