474
edits
Changes
Jump to navigation
Jump to search
Retrieving US VC Data From SDC (view source)
Revision as of 17:28, 29 September 2017
, 17:28, 29 September 2017ââVC Firms
LoadFirms.sql
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),
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),
);
DROP TABLE firmbase;
CREATE TABLE firmbase (
