Changes

Created: 69/1628/2017 3:2816:23 59 PM

Core Files: VCFirms1980USVCFirms1980-presentPresent.rpt VCFirms1980USVCFirms1980-presentPresent.ssh VCFirms1980USVCFirms1980-presentPresent.txt VCFirms1980USVCFirms1980-present.txt.org VCFirms1980-presentPresent-normal.txt

Created: 69/1629/2017 23:4446:42 06 PM

Firm Portfolio Cos: 1Round Date: 01/101/1980 to 0609/1629/2017 (Custom) (Calendar) Firm Portfolio Cos: Nation : US

FIRM_FIRST_INV_DATEVI_STREET1 VI_STREET2

VI_STREET2VI_CITY VI_STREET1VI_ZIP FIRM_AREA_CODE FIRM_COUNTY VI_STATE VI_NATION

VI_NATIONFIRM_WREG1_DESC

FIRM_MSA_DESCFIRM_MSA_CODE FIRM_ROLE_DESC

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) ); \COPY firmbase FROM 'VCFirms1980-present-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV

CREATE TABLE firmbase ( firmname varchar(255), foundingdate date, --mm-dd-yyyy location varchar(100), nation varchar(100), nationcode varchar(10), datelastinv datefirstinv date, --mm-dd-yyyy datefirstinv datelastinv date, --mm-dd-yyyy numportcos integer, numrounds integer, investedk money, areacode integer, bocity addr1 varchar(100), bonation addr2 varchar(100), bonationcode location varchar(100), bostatecode city varchar(100), boaddr1 zip varchar(10010), boaddr2 areacode integer, county varchar(100), bozip state varchar(102), capitalundermgmt money, city nationcode varchar(10010), county nation varchar(100), invstatus worldregion varchar(100), msacode varchar(10) numportcos integer, geogpref varchar(100) numrounds integer, indpref varchar(100) investedk money, rolepref varchar(100) capitalundermgmt money, stagepref invstatus varchar(100), statecode msacode varchar(210), addr1 rolepref varchar(100), addr2 geogpref varchar(100), type indpref varchar(100), worldregion stagepref varchar(100), zip type varchar(10100)

\COPY firmbase FROM 'VCFirms1980USVCFirms1980-presentPresent-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV --9734

VI_CAPITAL_COUNTRY VI_CAPITAL_STATEVI_POSTAL_CODE

 LoadBranchOffices.sql FIRM_NAMEDROP TABLE branchoffices; VI_YEARFOUNDCREATE TABLE branchoffices ( VI_STREET3 firmname varchar(255), VI_NATION_LONG bocity varchar(100), VI_NATION bostate varchar(2), FIRM_LAST_INV_DATE bocountrycode varchar(2), FIRM_FIRST_INV_DATE bonation varchar(100), FIRM_NUM_COMPANIES bozip varchar(10), FIRM_NUM_ROUNDS boaddr1 varchar(100), FIRM_TOTIN boaddr2 varchar(100) FIRM_AREA_CODE FIRM_CAP_MGT VI_CITY FIRM_COUNTY FIRM_STATUS_DESC); FIRM_MSA_CODE FIRM_GEOGRAPHY_PREF_DESC FIRM_INDUSTRY_PREF_DESC FIRM_ROLE_DESC FIRM_STAGE_PREF_DESC VI_STATE VI_STREET1 VI_STREET2 FIRM_TYPE_DESC\COPY branchoffices FROM 'USVCFirmBranchOffices1980-Present-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS FIRM_WREG1_DESCCSV VI_ZIP--9734