Changes

The key I chose after trying firmbase table contains undisclosed firms. Add a few different combinations is flag and remove them. Then use firmname, statecode, addr1foundingdate as the key for this table.Check that is valid and make your core table. CREATE TABLE firmbase1 AS SELECT COUNT(*) , CASE WHEN firmname LIKE '%Undisclosed Firm%' THEN 1::int ELSE 0::int END AS undisclosedflag FROM firmbase;

  SELECT COUNT(*) FROM firmbase1 WHERE undisclosedflag = 0; --14145  SELECT COUNT(*) FROM (SELECT DISTINCT firmname, statecode, addr1 foundingdate FROM firmbasefirmbase1 WHERE undisclosedflag = 0)a; --1425014145 CREATE TABLE firmbasecore AS SELECT * FROM firmbase1 WHERE undisclosedflag = 0;We'll need to investigate the 317 duplicate keys. --14145