Largest UK Cities

Delivered February 8, 2020. Contributor: Pamela E.

Goals

To identify cities in the UK and compile the following information: population, number of restaurants, average cost of a meal, average cost of a weekend hotel stay, average hotel rating, average cost of a pint of beer, number of free attractions, and average rating of free attractions to be used to determine the cost of a weekend stay in various UK cities.

Early Findings

The UK is made up of four countries: England, Wales, Scotland, and Northern Ireland.

London is the only city in the UK with a population of over 1 million people.

According to World Population Review, one city in the UK, London, that has a population of over one million residents, 96 cities have populations ranging over 100,000 residents and an additional 951 cities that have populations between 10,000 and 99,999,999 residents.

We have entered the names and populations of the 97 largest cities in the UK into the attached spreadsheet. If you would like additional cities with lower populations included, let us know.

The average was triangulated using information that was provided by Google maps. Google maps provided the number of two, three, four, and five-star hotels. The number of one-star hotels was provided by LondonNet.

Proposed next steps:

We'll start by populating the next 8 rows of the spreadsheet with the required information, calculating averages when needed. We will complete two cities per request.

Additionally, we suggest research to identify 5-7 popular paid attractions in the UK, with the understanding that at this list will include at least one attraction from each country in the UK: England, Wales, Scotland, and Northern Ireland. For each attraction we will provide the name, the location (city and country, the price, and a description of the attraction.