474
edits
Changes
Jump to navigation
Jump to search
Retrieving US VC Data From SDC (view source)
Revision as of 16:37, 11 October 2017
, 16:37, 11 October 2017→VC Firms
===VC Firms===
NOTE: USVCFirms1980-present-normal.txt and USVCFirmBranchOffices1980-present-normal.txt are already saved in vcdb2 in Venture Capital Data (and in E drive). They have not been loaded into tables yet. (Correct SQL code to load them firm and branch office data is below , but the SQL codes are not saved as sql files yetin the database. USVCFirms1980-Present-normal.txt has been loaded as "firms" for now. Will update to "firmbase" after Ed checks off.
Core Files:
\COPY firmbase FROM 'USVCFirms1980-Present-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
-9734
===Branch Offices===
