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
);
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)
Retrieving US VC Data From SDC (view source)
Revision as of 16:29, 29 September 2017
, 16:29, 29 September 2017ââVC Firms
FIRM_STAGE_PREF_DESC
FIRM_TYPE_DESC
LoadFirms.sql
type varchar(100),
);
