For all of the venues that are in suburbs of cities I fudged them to the name of the city, but I think that you are right that I should be specific with the city that the venues are in. I'll then create a field for 'metropolitan area' so we can still group by that if we want to.
That way all of the little suburbs of London that I just called 'London' can get more accurate, but people will still be able to look up how many shows they played in the London Metropolitan area.
This show would say that it is in Richfield, and the Cleveland Metropolitan Area.
The best of both worlds.
