Purpose of the city and country columns

[martj42]

Purpose of the city and country columns

[m-rossini]

Not sure if that question has been answered, here my thoughts on that:
London is in England and also UK. We have 2 political instances designations for the same place, which I do not know if happen in any other place besides UK. Given this is a football dataset and there is no UK team in the football (only England, Scotland, Northern Ireland and Wales) then I believe country should be kept as England, and more generally to a geographical/political designation where the match happened.

It is my understanding (I may be wrong) that geo databases dealing with historical databases in a very specific context (football) should handle these variations for non existing countries, for aggregated ones (UK and its components) as well for non existing countries, e.g., Yugoslavia. For countries/territories/geo area in the past that have just renamed, e.g. British Guyana to Guyana, I believe the country should also be kept in its original place, i.e. for above example British Guyana, meaning country should record the name of the place the match happened originally

Geo databases can be tweaked to handle historical names of the places or some middle way proxy translation can be used.