Changes

VC Database Rebuild (view source)

783 bytes added , 13:06, 24 July 2017

--43662

We still have 11 keys that are not distinct. We'll need to clean those up.

SELECT *, COUNT(*)

FROM (SELECT city, coname, startyear FROM geo1)a

GROUP BY city, coname, startyear

HAVING COUNT(*) > 1;

--8

city | coname | startyear | count

--------------+-----------------------------+-----------+-------

New York | New York Digital Health LLC | 2015 | 2

Portland | Undisclosed Company | 2016 | 2

Hauppauge | Mdeverywhere Inc | 1999 | 2

North Mankato | Angie's Artisan Treats LLC | 2011 | 2

Cincinnati | Undisclosed Company | 2016 | 4

New York | Undisclosed Company | 2015 | 2

San Francisco | Undisclosed Company | 2016 | 2

San Francisco | Undisclosed Company | 2015 | 3

==Name Based Matching geo keys to companybase keys==

220

edits