Changes

Retrieving US VC Data From SDC (view source)

59 bytes added , 16:25, 19 October 2017

\COPY branchoffices FROM 'USVCFirmBranchOffices1980-Present-normal.txt' WITH DELIMITER AS E'\t' HEADER NULL AS CSV

--9734

Firmname, bozip seems like a valid key for branchoffices.

SELECT COUNT(*) FROM (SELECT DISTINCT firmname, bozip FROM branchoffices WHERE bocity IS NOT NULL) AS T;

474

edits