474
edits
Changes
Jump to navigation
Jump to search
→Cleaning branchoffices
SELECT * FROM branchofficesbase WHERE undisclosedflag = 0;
--9452
DROP TABLE bocore; CREATE TABLE bocore AS SELECT * FROM branchofficecore WHERE firmname not like 'Amundi%'; --9450
SELECT COUNT(*) FROM (SELECT DISTINCT firmname, bozip FROM branchofficecore WHERE bocity IS NOT NULL) AS T;
--1964
SELECT COUNT(*) FROM (SELECT DISTINCT firmname, bocity FROM branchofficecore WHERE bocity IS NOT NULL) AS T;
--1963
There are no duplicates in firmbasecore. In firmbase, 'Amundi Private Equity Funds SA' was is the only duplicate, but we dropped the one with the earlier founding date when we cleaned firmbase. Amundi has 2 branch offices in the same city (Bucharest) but different zip codes, which is why there are different counts when we use firmname/firmname,bocity vs firmname, bozip as our key.
NOTE: We might drop have dropped "Amundi" from firmbasecore, as well as branchofficecore, in order to use firmname as a valid key for bocore.
==Cleaning fundbase==
