474
edits
Changes
Jump to navigation
Jump to search
LoadFirms.sql DROP TABLE firmbase; CREATE TABLE firmbase ( firmname varchar(255), foundingdate date, --mm-dd-yyyy location varchar(100), nation varchar(100), nationcode varchar(10), datelastinv date, --mm-dd-yyyy datefirstinv date, --mm-dd-yyyy numportcos integer, numrounds integer, investedk money, areacode integer, bocity varchar(100), bonation varchar(100), bonationcode varchar(100), bostatecode varchar(100), boaddr1 varchar(100), boaddr2 varchar(100), bozip varchar(10), capitalundermgmt money, city varchar(100), county varchar(100), invstatus varchar(100), msacode varchar(10), geogpref varchar(100), indpref varchar(100), rolepref varchar(100), stagepref varchar(100), statecode varchar(2), addr1 varchar(100), addr2 varchar(100), type varchar(100), worldregion varchar(100), zip varchar(10) ); \COPY firmbase FROM 'VCFirms1980-present-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV LoadFirmsLoadFirms2.sql
);
DROP TABLE firmbase;
CREATE TABLE firmbase (
firmname varchar(255),
foundingdate date, --mm-dd-yyyy
location varchar(100),
nation varchar(100),
nationcode varchar(10),
datelastinv date, --mm-dd-yyyy
datefirstinv date, --mm-dd-yyyy
numportcos integer,
numrounds integer,
investedk money,
areacode integer,
bocity varchar(100),
bonation varchar(100),
bonationcode varchar(100),
bostatecode varchar(100),
boaddr1 varchar(100),
boaddr2 varchar(100),
bozip varchar(10),
capitalundermgmt money,
city varchar(100),
county varchar(100),
invstatus varchar(100),
msacode varchar(10),
geogpref varchar(100),
indpref varchar(100),
rolepref varchar(100),
stagepref varchar(100),
statecode varchar(2),
addr1 varchar(100),
addr2 varchar(100),
type varchar(100),
worldregion varchar(100),
zip varchar(10)
USVCFirmBranchOfficesUSVCFirmBranchOffices1980-Present.rpt USVCFirmBranchOfficesUSVCFirmBranchOffices1980-Present.ssh USVCFirmBranchOfficesUSVCFirmBranchOffices1980-Present.txt USVCFirmBranchOfficesUSVCFirmBranchOffices1980-Present-normal.txt
VI_CAPITAL_STATELONGVI_CAPITAL_STATE
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
FIRM_NAME
VI_CAPITAL_CITY
VI_CAPITAL_COUNTRY
VI_CAPITAL_NATION
VI_ADR_LINE1
VI_ADR_LINE2
LoadBranchOffices.sql
DROP TABLE branchoffices;
CREATE TABLE branchoffices (
firmname varchar(255),
bocity varchar(100),
bostate varchar(2),
bocountrycode varchar(2),
bonation varchar(100),
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==
