Category: mapping

In a few years, the 55th American football championship, also known as the Super Bowl, will be played. While some Super Bowl fans are fervently identifying their ideal fantasy league for 2024, we’re more curious about the locations of Super Bowls past, present, and future.

We’ll take a look at some popular Super Bowl locations (some stadiums have hosted the Super Bowl over five times!), along with the highest-attended Super Bowls in history. Plus, we’ll note the locations of future Super Bowls and the three states that make up over 70% of Super Bowl locations.

View Super Bowl Locations in a full screen map

The map is based on this list of Super Bowl champions and their locations. You can sort the map by the most popular venues or by Super Bowl attendance and then keep on reading for more Super Bowl location trends. Let’s kick-off!

Popular Super Bowl Locations

Several stadiums have hosted the Super Bowl on more than one occasion. For example, New Orleans’ Superdome has welcomed NFL fans six times. The first Super Bowl located at the Superdome was the 1978 Super Bowl XII. Most recently, though, the 2002 Super Bowl XXXVI was held there.

The Rose Bowl, located in Pasadena, California, has also hosted the Super Bowl multiple times, the first taking place in 1977. In total, the Rose Bowl has hosted the Super Bowl five times, most recently in 1993. Perhaps we’ll see the sixth soon. Like the Rose Bowl, the Miami Orange Bowl has also hosted the Super Bowl five times, all of which occurred between 1968-1979. The following venues have also hosted the Super Bowl at least twice:

• Tulane Stadium (New Orleans)
• Raymond James Stadium (Tampa)
• University of Phoenix Stadium (Glendale)
• Tampa Stadium (Tampa)
• Qualcomm Stadium (San Diego)
• Mercedes-Benz Superdome (New Orleans)
• Los Angeles Memorial Coliseum (L.A.)
• Joe Robbie Stadium (Miami Gardens)
• Georgia Dome (Atlanta)

Cities selected to host Super Bowls need to have moderate weather in February — or at least stadiums covered by a dome so that the players (and fans) don’t freeze. But we’re sure more than 10 states fit the bill. Yes, only 34 different stadiums across 10 U.S. states have hosted the Super Bowl.

The majority of the Super Bowls (41 out of 58, or over 70%) were located in either Florida, California, or Louisiana. The entire extended midwest and much of the northern U.S. has been passed over for a chance at hosting. This may coincide with strict weather stipulations, but it may not. Check out our map of extreme temperatures if you’re curious.

History’s Highest-Attended Super Bowl Locations

Perhaps just 34 stadiums across 10 states have hosted the Super Bowl due to the states’ extreme NFL fan dedication. For example, California has hosted the Super Bowl 13 times, and maybe rightfully so. Super Bowls held in stadiums throughout Californa are some of the most-attended in NFL history.

The #1 highest-attended Super Bowl ever was Super Bowl XIV held at the Rose Bowl in 1980. About 103,985 American football fans packed themselves into the Rose Bowl to see the Pittsburgh Steelers play the Los Angeles Rams. The second highest-attended Super Bowl (103,667 fans attended) was Super Bowl XVII, also held at the Rose Bowl in 1983. Any guesses where the third highest-attended Super Bowl was located? The Rose Bowl in 1977. What is it about Pasadena, Califonia or its stadium that draws the largest Super Bowl crowds? Perhaps it’s the large stadium capacity. As it happens, the Rose Bowl is the 15th largest stadium in the world with a capacity: 90,888. Note the other large stadiums on this map.

2011’s Super Bowl XLV broke the Rose Bowl’s trend when the Cowboys Stadium in Arlington, Texas, saw 103,219 fans in attendance. It was the fourth best-attended Super Bowl. As for the fifth and sixth most well-attended? Super Bowls XXI and XXVII were both once again located at the Rose Bowl in Pasadena, California. Notably, the seventh and eighth best-attended Super Bowls also took place in California, but not at the Rose Bowl. Super Bowls VII and XIX were held at the Los Angeles Memorial Coliseum and the Stanford Stadium, respectively.

Future Super Bowl Locations

Since the Super Bowl’s location is chosen three to four years ahead of time, we already know the locations of Super Bowls LIV-LVIII.

Super Bowl Game	Date & Season	Venue	City	State	Attendance	Winning team	Losing team	Score
LIV	February 2, 2020 2019	Hard Rock Stadium	Miami Gardens	Florida	TBD	2019–20 NFC champion	To be determined	—
LV	February 7, 2021 2020	Raymond James Stadium	Tampa	Florida	TBD	2020–21 AFC champion	To be determined	—
LVI	February 6, 2022 2021	SoFi Stadium	Inglewood	California	TBD	2021–22 NFC champion	To be determined	—
LVII	February 5, 2023 2022	State Farm Stadium	Glendale	Arizona	TBD	2022–23 AFC champion	To be determined	—
LVIII	February 4, 2024 2023	Mercedes-Benz Superdome	New Orleans	Louisiana	TBD	2023–24 NFC champion	To be determined	—

Super Bowl LIV will be Hard Rock Stadium’s first, although it won’t be the first for the city of Miami Gardens. The city’s Joe Robbie Stadium has hosted two previous Super Bowls while Miami Gardens’ Dolphin Stadium, Pro Player Stadium, and Sun Life Stadium have hosted one Super Bowl each. Super Bowl LV will be the third hosted at the Raymond James Stadium in Tampa, but it will be the fifth for the city itself. The other two Super Bowls located in Tampa were played at the Tampa Stadium.

The SoFi Stadium and its city of Inglewood will have its first chance at hosting a Super Bowl in 2022, and it will also be the State Farm Stadium’s first Super Bowl the following year. However, it won’t be the first for the city of Glendale. 2024 will see the Mercedes-Benz Superdome’s second Super Bowl. However, New Orleans, where the Superdome is located, is not inexperienced in hosting Super Bowls. Six Super Bowls have been held at the city’s other Superdome, the Louisiana Superdome, along with the three Super Bowls held at the Tulane Stadium.

---

Hopefully, the Super Bowl can expand it’s location preferences so that more football fans can watch a live game. What team would you love to see live? Pick from the Super Bowl winners and losers.

So, you have data and you need a quick way to make sense of it. A PivotTable is a great option and it is one of Excel’s most powerful tools. We’ll walk you through what a PivotTable is, preparing your data for a PivotTable, quickly performing analytics using a PivotTable to Count and Sum your data, and finally, overlaying your PivotTable data onto a map using sum clustering.

What is a PivotTable?

First, let’s establish what a PivotTable is and what it can do. A PivotTable is a quick and easy tool within Excel that allows users to easily summarize data. Now, most regular tables have summary rows at the bottom such as a Sum to show the total sales of all products in all states or a Count of all of the entries included within the table.

However, a PivotTable takes those summaries a step further by allowing users to quickly answer more specific questions such as the total sales broken down by each product, state, or even city with just a few mouse clicks.

Preparing Your Data

Now that we know what a Pivot Table is and what it can do, the first step to create one is to prepare your data by organizing it into a single worksheet, preferably into a Defined Table.

Organizing Data into a Single Worksheet

It’s common to have data stored in multiple places, like separate tabs for various time periods or products. In order to view all of this data within your PivotTable, you’ll need to combine it into a single worksheet. The simplest way to do this is to identify the difference between each data source and create a new corresponding column within your combined worksheet to store that differentiator. For example, perhaps a different salesperson manages each business segment resulting in a separate workbook for each segment as pictured below.

To combine this data, we can create a new column called “Segment” anywhere within the data set and populate the rows with the corresponding segment name as we copy and paste all the data into a single table.

Pro Tip! – If your data already includes a date field, there is no need to add an additional column for the time period identifier. The date field can be used to break the data back out into the applicable time periods once we create our PivotTable.

Creating a Defined Table

Now that you’ve organized your data into a single worksheet, you can save yourself time down the road by identifying the data as a Defined Table. Do this by clicking anywhere within your data and choosing the “Format as Table” option on the “Home” ribbon. A major advantage of creating a Defined Table upfront is that your PivotTable can be kept current over time even as the underlying data is updated. All you have to do is toggle the “Refresh Data” option within your PivotTable to pull in any new or modified data.

Create a PivotTable to Count

If your goal is to determine how many times a specific event occurred, such as how many distinct customers made a purchase or how many sales were generated within each city, a PivotTable configured to Count records is exactly what you need. To start, if you already have your data within a Defined Table, simply click anywhere on your table and choose “Summarize with PivotTable” from the “Table” ribbon.

Alternatively, if your data has not already been organized into a Defined Table, you can select your data manually by clicking the top leftmost cell within your dataset and then dragging down to the bottom rightmost cell. At this point, you can click “PivotTable” from the “Insert” ribbon.

From there you’ll be able to choose which data point you want to count by selecting the checkbox next to the data in the right-hand PivotTable Fields settings that automatically open when creating a new PivotTable.

By default, Excel will sum the data as it sees that we have chosen a numerical field. We can change this by left-clicking on the “i” button on the far right corner of the “Sum of Sales” value. This will give you several formula options to choose from. We’ll choose “Count” which results in a count of all sales record instances.

Pro Tip! – Save time by formatting your data columns with the correct field type from the start such as Date, Number, or Text. Excel will automatically sort by Date data, Sum numerical data, and Count text or mixed data.

Now, let’s let Excel do the heavy lifting! Simply drag the “City” column from the list of fields to the “Rows” box within the PivotTable settings to break down the number of sales by city. You can also increase the depth of the PivotTable by dragging in an additional field, such as the “State” field, to the Filter selector in order to drill down into the data you are most interested in.

Create a PivotTable to Sum Values

There are other instances in which using the Sum of the data rather than the Count is more useful. In order to sum the data, go back to the “i” on the right-hand side of the “Count of Sales” field and choose “Sum”. Now we can see the total sales revenue broken down by each city.

Depending on your goal, it is often helpful to stack different fields within the Rows or Columns selectors. For instance, placing the “State” field above “City” in the below example allows us to quickly see not only the highest-grossing states but also the individual city contributions within each state.

One of the most beneficial aspects of a PivotTable is that they are dynamic. You can move the fields around between Rows, Columns, Filters, and Values boxes on the fly to gain perspective and play with different analyses. Spend a moment moving the fields you are interested in between the boxes to get a better feel for how the PivotTable works. You may be surprised how quickly you can discover new insights!

Create a Map of Sales Data

Now, if you have geographic data such as addresses, cities, or states as in the sales examples above, you can take your data analysis to the next level by visualizing the data on a map with sum clustering. Just like when we summed up our data in a PivotTable, BatchGeo’s mapping service has an advanced clustering feature. When enabled, this feature allows you to sum up the values of a specific field as a label for each cluster.

Pro Tip! – To enable sum clustering:

View Example Sales Data in a full screen map

Here you can see sum clustering data analysis on sales data broken out by city or state. Regions are clustered together and the cities and states are averaged. As you zoom in or even click on a cluster, you’ll see smaller clusters that demonstrate how the smaller areas contribute to the overall sum.

As another year comes to an end, we took a look back to see which stores competing for business did the best. Thanks to company reports of retail sales (all of which are in the billions, by the way), we know the top 100 stores of the year. The retailers that made the most include Walmart and Amazon (unsurprisingly), though one wholesale warehouse ranked in the top ten with just under 530 stores. To put it in perspective, the majority of the top ten companies of 2019, and the top 100 for that matter made their billions of dollars in sales by owning at least 1,700 stores throughout the country. This just goes to show that more stores don’t mean more sales. Or maybe the stores that didn’t make the cut aren’t in the right market because there are categories of stores that make more cash than others, like supermarkets and fast food places. There are also states and cities where more successful stores operate their headquarters. Find out where in the U.S. the most top stores are based and more as you continue reading about the top 100 stores of 2019.

View Top 100 Stores of 2019 in a full screen map

The map above depicts Kantar’s data for the top stores of the year in grouping columns, the most useful of which are the 2018 retail sales (billions), the store category, and the number of stores.

Billion-Dollar Stores

Of the 100 top stores of 2019, ten stand out the most in retail sales.

Rank	Company	Category	2018 retail sales (billions)	2018 stores	Headquarters City	Headquarters State
1	Walmart	General Retailer	$387.66	5,263	Bentonville	AR
2	Amazon.com	E-commerce	$120.93	490	Seattle	WA
3	The Kroger Co.	Supermarket	$119.70	3,035	Cincinnati	OH
4	Costco	Membership-Only Warehouse Club	$101.43	523	Issaquah	WA
5	Walgreens Boots Alliance	Drug Store	$98.39	9,451	Deerfield	IL
6	The Home Depot	Home Improvement	$97.27	1,969	Atlanta	GA
7	CVS Health Corporation	Drug Store	$83.79	9,954	Woonsocket	RI
8	Target	General Retailer	$74.48	1,844	Minneapolis	MN
9	Lowe’s Companies	Home Improvement	$64.09	1,723	Mooresville	NC
10	Albertsons Companies	Supermarket	$59.71	2,249	Boise	ID

The #1 top store of 2019 is Walmart. The general retailer made $387.66 billion in sales throughout its 5,263 stores this year. Walmart is headquartered in Bentonville, Arkansas. The only other Arkansas-based stores to make the overall list of the 100 top stores are Dillards (#71) and Discount Tire (#91) but the #1 Walmart outearned them both by at least 63%. As for #2: it’s Amazon. The e-commerce giant brought in 120.93 billion dollars in 2019. The H.Q. is located in Seattle, Washington, and is only one of four top 100 companies to conduct business from the Evergreen State. Amazon’s 490 brick-and-mortar stores may come as a surpsie as we tend to think of the company as solely e-commerce. However, Amazon’s physical stores include Whole Foods, Amazon Books, Amazon Go, AmazonFresh Pickup, Amazon Pop-Up stores, and all their package pickup locations.

Following Amazon is the U.S.’s largest supermarket chain: the Kroger Co. It’s one of eight Ohio-based retailers serving up top sales this year. Based out of Cincinnati, you may not immediately recognize the stores associated with The Kroger Co. As of 2019, The Kroger Co. owns Dillons, Food 4 Less, Fred Meyer, Fred Meyer Jewelers, Fry’s, Harris Teeter, Home Chef, King Soopers, the Little Clinic, Mariano’s QFC, Ralphs, Roundy’s, Ruler Foods, Smith’s, and Vitacost. All that to say, the Kroger Co. and its 3,035 stores made $119.70 billion in retail sales — just 1.23 billion less than Amazon.

Costco is next. The wholesale warehouse best known for its free samples made $101.43 billion in sales last year. With just 523 stores, Costco is the only retailer other than Amazon (though Amazon makes most of its sales online, not in-store) to rank in the top ten with less than 1,500 stores. Costco is similar to Amazon in that its headquarters are located in Washington, though in a city called Issaquah. Costco is also the last retailer to hit over 100 billion dollars in sales on the list.

Walgreens Boots Alliance comes in at #5. The drugstore’s 9,451 stores made just under $99 billion throughout the year. One of eight top retailers based in Illinois, Walgreens (H.Q. in Deerfield) owns the most stores of the top ten up until this point. The Home Depot, CVS Health Corporation, Target, Lowe’s Companies, and Albertsons Companies round out the top ten retailers of the year. Each of these successful stores earned at least $59 billion and they own over 1,000 stores across the country.

More Stores Don’t Mean More Sales

We noted both Amazon and Costco made over 100 billion dollars with only 490 and 523 stores respectively. This just goes to show that more stores don’t mean more sales. Other examples include Ikea. With just 49 stores, Ikea still ranks at #72. It beat GameStop, which has over 3,800 stores throughout the U.S. and the furniture emporium is also neck-in-neck with Dillards’ 5,371 stores. Additionally, Apple Stores/iTunes managed to rank at #11 despite only having 271 stores. Both Macy’s and H.E. Butt Grocery also have well-under 900 stores yet they still make it in the top 20.

On the other hand, we have Subway. The sandwich shop has the largest amount of stores out of all 100 companies: 26,932. Yet, it’s only ranked at #43. The lowest-ranked company with the most stores appears to be the Shell Oil Company. Even with 4,406 stores, Shell only ranks at #99.

Common Cash Categories

We sorted the top stores of 2019 into 12 distinct categories. The category of store that appears most frequently appears on the map is apparel. Seventeen apparel stores are ranked within the top 100 stores of 2019. The second most common category is restaurants. There are fifteen of these throughout the map. McDonald’s is the highest-ranking restaurant on the list at #14, which is not bad for a business dedicated to fast and cheap food. Yum! Brands ranks second in fast food (#24) followed by Starbucks, and Subway, and 11 others.

Supermarkets also make a lot of sales. There are 14 on the map, including the Kroger Co. and Albertsons Companies, which are the two supermarkets making the most. While there weren’t enough dollar stores and related companies on the map to merit a mention above, we thought it was notable that these companies where everything is usually $1 or less appear on this list twice and quite high in the ranks. Dollar General, for example, is ranked at #18 and made $25.63 billion throughout the year. Not far behind was the Dollar Tree. As the #21 top store of 2019, the Dollar Tree brought in about $22.48 billion. Absent from the top 100 is the 99 Cent Store.

Successful States & Cities

A number of top stores are headquartered in Texas: 11 to be exact. The ranks of these Texas-based companies range from #20 (H.E. Butt Grocery) to #99 (Shell Oil Company). Dallas, Texas is the only city in the U.S. where four top stores have headquarters. 7-Eleven, AT&T, Army & Air Force Exchange Service, and Neiman Marcus are all successful companies based in Dallas.

In addition to Texas, many top retailers are based in California (nine), most of which are located in San Francisco. There are also eight top stores working out of both Ohio and Illinois, and six in Pensylvania, though no city in Ohio, Illinois, nor Pensylvania is home to more than two top companies. Seattle is home to three of Washington’s four top companies. That puts the Emerald City second to Dallas for the number of companies in the top 100. San Francisco and New York also have three companies each.

---

In addition to company reports of retail sales, the end of a calendar year also brings fun events for the family, like holiday light displays around the snow globe and the ability to map your holiday cards list. But the end of the year also means getting organized for the new year. If you have a bunch of business data you need to dive into, let BatchGeo help you use an Excel pivot table to count and sum values or teach you about Excel data visualization examples to make sure you start the year off right.