and it uses the countrycode index to match the city rows to the country table