158
edits
Changes
Jump to navigation
Jump to search
no edit summary
I encountered no errors while loading this data.
DROP TABLE roundline;
CREATE TABLE roundline (
coname varchar(255),
statecode varchar(2),
datelastinv date,
datefirstinv date,
rounddate date,
disclosedamt money,
investor varchar(255)
);
\COPY roundline FROM 'USVCRound1980-2018q2-NoFoot-normal-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--403189
I encountered no errors while loading this data.
DROP TABLE fundbase;
CREATE TABLE fundbase (
fundname varchar(255),
closedate date, --mm-dd-yyyy
lastinvdate date, --mm-dd-yyyy
firstinvdate date, --mm-dd-yyyy
numportcos integer,
investedk real,
city varchar(100),
fundyear varchar(4), --yyyy
zip varchar(10),
statecode varchar(2),
fundsizem real,
fundstage varchar(100),
firmname varchar(255),
dateinfoupdate date,
invtype varchar(100),
msacode varchar(10),
nationcode varchar(10),
raisestatus varchar(100),
seqnum integer,
targetsizefund real,
fundtype varchar(100)
);
\COPY fundbase FROM 'VCFund1980-2018q2-NoFoot-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--29397
