Changes

VC Database Rebuild (view source)

183 bytes added , 17:11, 27 July 2017

==Cleaning firmbase==

The key I chose after trying a few different combinations is firmname, statecode, addr1.

SELECT COUNT(*) FROM firmbase;

--14567

SELECT COUNT(*) FROM (SELECT DISTINCT firmname, statecode, addr1 FROM firmbase)a;

--14250

We'll need to investigate the 317 duplicate keys.

==Cleaning fundbase==

==Cleaning roundline==

220

edits