Changes

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

Core Files: VCFirmsOnly1980USVCFirms1980-presentPresent.rpt VCFirmsOnly1980USVCFirms1980-presentPresent.ssh VCFirmsOnly1980USVCFirms1980-presentPresent.txt VCFirmsOnlyUSVCFirms1980-presentPresent-normal.txt

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

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

VI_NATIONFIRM_WREG1_DESC

FIRM_MSA_DESCFIRM_MSA_CODE

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

VCFirmBranchOfficesUSVCFirmBranchOffices1980-Present.rpt VCFirmBranchOfficesUSVCFirmBranchOffices1980-Present.ssh VCFirmBranchOfficesUSVCFirmBranchOffices1980-Present.txt VCFirmBranchOfficesUSVCFirmBranchOffices1980-Present-normal.txt  Created: 9/29/2017 3:54:32 PM Session Contents: DATABASE: Private Equity Firms (VIFM) Venture Related Deals: Select All Venture Related Deals Firm Portfolio Cos: Round Date: 01/01/1980 to 09/29/2017 (Custom) (Calendar) Firm Portfolio Cos: Nation : US

 LoadBranchOffices.sql VI_ADR_LINE1DROP 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