Ran the CSV through our deduper first. Website URLs were populated for ~80% of rows, far better than the competition. Bought it to map koi auto parts locations density across United States. Wished a few smaller towns had been included.
Good to know what worked and what didn't, the points you raised are on the refresh checklist for the next pull. Drop a note via Help → Contact Support and we'll line up a fresh export for you.