220
edits
Changes
Jump to navigation
Jump to search
→Cleaning geo table
--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==
