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 09/2829/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

VCFirmBranchOfficesCore Files USVCFirmBranchOffices1980-Present.rpt VCFirmBranchOffices USVCFirmBranchOffices1980-Present.ssh VCFirmBranchOffices USVCFirmBranchOffices1980-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