474
edits
Changes
Jump to navigation
Jump to search
→Cleaning branchoffices
--9450
SELECT COUNT(*) FROM (SELECT DISTINCT firmname, bozip FROM branchofficecore bocore WHERE bocity IS NOT NULL) AS T; --1964 SELECT COUNT(*) FROM (SELECT DISTINCT firmname FROM branchofficecore WHERE bocity IS NOT NULL) AS T; --19631962
There are no duplicates in firmbasecore. In firmbase, 'Amundi Private Equity Funds SA' 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.
