A Map of Name Changes Due to George Floyd Protests

2020 was full of deadly surprises: COVID-19, unprecedented wildfires, and a nationwide racial reckoning. The latter led to rebrands for various university halls, snack cakes, and Grammy-winning bands. The Washington Redskins’ name change may be the most well-known, but more than 115 others are in the process of updating their names—or have already done so.

From education to food, drink, and sports, companies in nearly every industry are saying out with the old and offensive and in with new names on the map below.

View Reported Name Changes Due to George Floyd Protests in a full screen map

The map’s name changes come from Wikipedia’s List of name changes due to the George Floyd protests. There are nine categories to group by, the majority of which are education-related. Check out the regions of the world with the most changes, or read on for more information.

Nine Categories of Changes

The George Flloyd name changes span over 115+ buildings, products, and companies from countries around the world. However, there are some commonalities. The changes can be broken down into the nine categories below:

  • Education – 55 name changes
  • Geography – 21
  • Food and drink – 15
  • Industry – 11
  • Lodging – 4
  • Music – 4
  • Government – 3
  • Healthcare – 3
  • Sports – 3

Let’s take a more in-depth look at a few of these categories, starting with that with the most: education.

Education

The 55 name changes related to education (most of which are buildings: halls, gyms, and the like) include eight from the United Kingdom and 47 in the U.S. Specifically, England makes up seven of the eight, leaving Scotland with the remaining single change. The U.S. state with the most is North Carolina with the following seven changes:

  • Hoey Hall Lovill Hall → TBD
  • Helms Center → Hawks Athletic Center
  • Daniels MS → Oberlin MS
  • Burwell Hall → Queens Hall
  • Zebulon B. Vance HS → TBD
  • Parkwood HS Rebels → TBD
  • Hoey Auditorium → University Auditorium

North Carolina isn’t the only Southeastern state with multiple education-related changes. In fact, 21 of the U.S.’s 47 changes (nearly 45%) take place in Southeastern states, which frequently reference Confederates and segregationists. North Carolina is joined by Virginia (with 5 changes), Florida (3), West Virginia (2), Louisiana (2), South Carolina (1), and Alabama’s (1) as you can see on the map when you group by a category like ‘Education.’

Food & Drink

Fans of Uncle Ben’s rice should note it’s move towards a new name of Ben’s Original. Consumers who avoided the brand due to the pejorative “uncle” and the packaging’s display of a white-haired Black man in a black bow tie, which is reminiscent of servitude, may now be more inclined to make a purchase. Along with Uncle Ben’s rice, Aunt Jemima breakfast food and 13 other food and drink products are undergoing name changes, including:

  • Arabian Joe’s, Baker Josef’s, Josephsbrau, Pilgrim Joe’s, Thai Joe’s, Trader Giotto’s, Trader Jacques’, Trader Joe San, Trader José’s, Trader Ming’s, and various others → Trader Joe’s
  • Beso de Negra confectionery → TBD
  • Bully Hayes Restaurant → TBD
  • Colston Arms pub → Ye olde Pubby Mcdrunkface (temporarily)
  • Coon cheese → TBD
  • Crazy Horse Beer and Burgers → Lucky Horse Beer and Burgers
  • Dixie Brewing Company → TBD
  • Eskimo ice lolly → O’Payo
  • Eskimo Pie ice cream bar → TBD
  • Geechie Boy Mill → TBD
  • Redskins and Chicos lollies → TBD
  • Sambo’s restaurant → Chad’s
  • Zigeunersauce condiment → Paprikasauce Ungarische Art

Notably, the Trader Joe’s change is the only one regardless of category reported before the 2020 racial unrest. Trader Joe’s first announced they would make these changes in July of 2019, though the brand recently changed its stance. Read about it in detail when you sort the map by ‘Food and drink’ on the map. For now, let’s hike the ball into sports territory.

Sports: Washington Redskins Are No More

Three name changes are coming to the sports world, the most widely-recognized being the NFL’s Washington Redskins name change.

The American football team has gone by the name since 1933, though attempts to remove what various groups like the National Congress of American Indians consider a racial slur to Native Americans have been underway for decades.

When the George Floyd protests renewed attention to racial justice, a group of 87 shareholders and investors worth $620 billion signed and sent letters to Nike, FedEx, and Pepsi. In the letters, they urged the major sponsors to cut ties with the team and the NFL unless the name was changed. At the same time, retail companies removed team merchandise from stores. In response, on July 23, the Washington Football Team became the new, temporary name. Team rebranding usually takes over a year, so an official replacement will be chosen later.

In addition to the newly dubbed Washington Football Team, Canada’s Edmonton Eskimos football team is now the Edmonton Football Team (temporarily). Finally, the Baseball Writers Association of America’s Kenesaw Mountain Landis Award will no longer reflect the MLB’s first commissioner, Landis, who resisted efforts to integrate both the major and minor leagues.

Make sure to check out the other categories of name changes on the map, like geography. For now, let’s move on to the name changes that have already been completed.

Completed Name Changes

While education, food, and sports name upgrades are all in the works, several have already been enacted. Of course, that means there are still those that are reported but not yet executed (which represents the least progress made) or have a decision pending. Some are supported by one or more officials and are closer to being partially or fully changed. So before you search for Lady A in place of the band Lady Antebellum or The Chicks instead of the Dixie Chicks on Spotify, let’s see which name changes are totally official by sorting the map by the “Date Executed.”

First Finalized in June 2020

The first protests were reported at the end of May. By the end of the following month, 28 out of the 60 completed changes were complete, the first occurring on June 3rd when Nicholls State University announced P. G. T. Beauregard Hall and Leonidas K. Polk Hall will forevermore be the College of Science and Technology and the College of Education and Behavioral Sciences.

July’s First Finalizations

The first change enacted in July took place on the 1st when the Watson School of Biological Sciences was renamed as the Cold Spring Harbor Laboratory School of Biological Sciences and the King Leopold Ranges were newly dubbed the Wunaamin Miliwundi Ranges.

August & Beyond

Name changes slowed after July, though a few did take place in August. On August 1st, Colorado official’s announced the Stapleton neighborhood will now be called Central Park.

All-in-all, there are 59 TBD name changes to keep an eye out for. Still, there’s plenty you can do while you wait, including making a map of what’s important to you.

Map What’s Important to You

Knowing the 60 name changes that were already made and those that are TBD is important for more than navigating maps, supermarket shopping, or buying sports jerseys. This mass rebranding was the result of the 2020 United States racial unrest.

Store information that you find important on a map for easier visualization of trends. For more ways you can utilize BatchGeo to learn about history, see Flashcard Maps: Learn US State Capitals, Flowers, and Birds. Otherwise, to get started making your own map, head to batchgeo.com.

Google Maps vs Mapbox vs BatchGeo on Pricing and Features

The very best way to display location data is on a map. You can see patterns visually before you’d ever understand them in data. The human brain is built for spatial relation, so we can use geographic visualization to help people understand proximity, plan routes, and make decisions. It’s no wonder that web and mobile maps have gained in popularity and usage in recent years. Customers have come to expect a map-based interface for location results.

Making maps for your website or mobile app does not need to be difficult, nor expensive. Among the platforms you can use to create maps are Google Maps, Mapbox, and BatchGeo. Based on your needs and volume of usage, the pricing can range from free to hundreds or even thousands per month,

In this article, we’ll look at Google Maps pricing compared to Mapbox and BatchGeo across various levels of usage. We’ll also break the price down by the two most common ways to use location data: to display maps and to perform address geocoding.

You’ll see that, despite some “free” usage at low levels, Google Maps and Mapbox quickly become expensive with their usage-based pricing. The simple pricing of BatchGeo, plus its additional features like Excel integration and code-free implementation, make it preferable to these geographic juggernauts. 

Map Display Pricing by Volume

For many years, the standard Google Maps API was completely free. Developers could create and display as many maps as they wanted. And many did, which led to an uproar when the company began charging in 2011. Around the same time, Mapbox was founded to provide an alternative to Google Maps based on OpenStreetMap data.

The table below shows the cost to display maps on a web page or in a mobile app (per 1,000 views) at various numbers of views per month.

50,000 250,000 500,000
Google Maps $3 $6 $7
MapBox $0 $3 $3
BatchGeo Pro $4 $4 $4
Cost per 1,000 views based on total views per month

Each provider has a defined amount of free usage:

  • Google Maps offers $200 per month across its Maps Platform, which translates to about 25,000 map views without charge. The $200 discount is included in the numbers in the table.
  • Mapbox includes about double the amount of free usage, not charging for the first 50,000 map views.
  • BatchGeo is free for maps up to 250 locations with limited views

To create a Google Maps or Mapbox map, you’ll likely need to write some code. Both provide SDKs for JavaScript, which can be used to embed the map into a web page. You’ll either need a programming background yourself or will have to hire a web developer to add Google Maps or Mapbox to your website.

BatchGeo provides an easier way to embed maps on the web without writing any code. Using a simple Excel spreadsheet or comma-separated values (CSV) file, you can copy-paste or upload location data. Then, after declaring a few options, BatchGeo builds embeddable maps automatically.

Regardless of the map platform you use, you’ll need to use a geocoder in addition to display maps. Google Maps and Mapbox charge for it separately, as shown in the next section.

Geocoder Pricing by Volume

Displaying a map is only half of the equation if you have addresses that need to be added to a map. Google Maps, Mapbox, and BatchGeo all offer geocoding to convert human-readable locations into coordinates to plot on a map. As with display maps, there is free usage and some other terms to consider.

The table below shows the cost to geocode (per 1,000 geocodes) at various numbers of geocodes per month.

50000 250000 500000
Google Maps $1 $4 $5
MapBox $5 $5 $5
BatchGeo Pro $0.30 $0.40 $0.39
Cost per 1,000 geocodes based on total geocodes per month

Something to consider with geocoding APIs is that you may come up against rate limits. Both Google Maps and Mapbox restrict the number of geocode requests that can happen during a period of time. Google Maps usage limits are 50 per second. Mapbox is more restrictive, with only 600 per minute allowed. BatchGeo allows up 25,000 geocodes per map and will automatically run them 100 geocodes at a time.

In addition to writing the code to access the Google Maps or Mapbox geocoding APIs, you’ll need to make sure your code handles caching and rate limiting. As with display maps, BatchGeo handles every aspect of geocoding when you upload or copy your location data to our mapping and geocoding tool.

Finally, a note on combined pricing: there is some potential undercounting for Google Maps and over-counting for BatchGeo. Google Maps $200 free usage also applies to geocoding, but it can only be used once per month. The two tables in this article each count the discount. Depending on your usage, the actual cost of Google Maps may be slightly (or substantially) more.

BatchGeo pricing is inclusive of both map views and geocodes, with the larger usage determining the price. That can make the already-inexpensive BatchGeo look even more affordable. In the next section, you’ll see what else is included in the BatchGeo Pro monthly pricing.

BatchGeo: Easy Maps with Advanced Features

For many map projects, BatchGeo is easier to create and cheaper to operate. Depending on your usage level of display maps and geocoding, you could save hundreds or thousands of dollars by using BatchGeo. In addition, your maps will automatically include handy tools you’d otherwise need to code yourself.

Each BatchGeo map can include additional data about each location, so you can visualize other data in your spreadsheet. Display the name in a box when each marker is clicked, and filter which markers are displayed with built-in data grouping.

To achieve a similar approach with the Google Maps or Mapbox display APIs, you’d need to write a lot of additional code. And this is only one of several BatchGeo features, which includes custom colors, different map styles, and mobile access for your entire team.

If you wish to provide a store locator map (to discover your multiple locations or retailers who carry your product), you’ll save a bunch of time with BatchGeo. A location finder and full text search can be included with every BatchGeo map. Simply enable the store locator, with either a left-side or below-map list of locations, when you create or edit your map.

Finally, you can embed any map seamlessly into your own site. Similar to sharing a YouTube video, you just copy some simple HTML code and paste it where you want the map to be displayed. The embedded map is fully functional and completely interactive, with a much richer “out of the box” experience than Google Maps or Mapbox. And all without coding, for a much lower price.

Try BatchGeo for free and add your data to create a map today. We’ll do all the mapping and geocoding for you (no code, rate limits, or coordinate refreshes). Then pay one monthly price that stays affordable as you grow.

How to Find Duplicates in Excel

Spreadsheets are often the best place to store and manipulate data. Most spreadsheet tools, like Excel, have many ways to analyze, filter, and transform said data. One common task is to identify duplicate data, like the same pizza place listed twice in a list of your favorite places. Once you’ve found any duplicates, you can either remove them or count them.

In this article, you’ll learn:

  1. How to highlight duplicates in Excel
  2. How to find duplicate values in Excel by using formula like COUNTIF or VLOOKUP

The popular methods of finding duplicates in Excel are ordered from easiest to most difficult. Let’s begin by taking a look at the first (and easiest!) method.

How to Highlight Duplicates in Excel

One of the most popular ways to identify duplicate data is to highlight them. Highlighting also happens to be the easiest of the three approaches to find duplicates in Excel and it provides a visual aspect other duplication identification methods lack. So, for all the visual learners out there, let’s get started e-highlighting with the simple steps outlined below.

  1. Select the cell range in which you want to highlight duplicates
  2. Ensure you’re in the Home tab (on the upper left), then select the Conditional Formatting dropdown
  3. Opt for Highlight Cells Rules and click on Duplicate Values…

As shown above, the default settings include a Classic Style while 2 and 3-Color Scale, Data Bar, or Icon Sets are additional options. You may opt to keep the default Format only unique or duplicate values and subsequent duplicate when it comes to choosing which values in the selected range you want.

Light Red Fill with Dark Red Text is the default Format with setting. This is where you determine the text and fill color for your highlighting. There are other suggested options, and Excel also allows for a Custom Format… Once you’re satisfied with the settings, click OK and you’re done!

A similar method of highlighting duplicates in Excel is available in Google Sheets and other spreadsheet tools. And, though a well-liked method, there are advantages to instead using an Excel formula to identify duplicates.

How to Find Duplicate Values in Excel Using Formulas

Another way data analysts can check for duplicates is via Excel formula. While the thought of a page-long formula including various spreadsheet cells and mathematical symbols is daunting, the formulas used to check for duplicates in Excel are actually quite simple. In fact, they’re a great way to dip your toe into other Excel formulas, such as =CONCATENATE, which we describe in Advanced Excel Skills and Formulas to Impress Your Boss.

COUNTIF to Find Duplicates

The duplicate-checking formula uses =COUNTIF to “count” which cells contain data that appears more than once throughout the spreadsheet. Resulting values can either be “TRUE” (indicating duplicate data) or “FALSE” (showing non-duplicate data).

You may wish to begin by adding a heading like “Count” (or something similar) to a blank column, though this is optional. Then, do the following:

  1. Copy and paste this formula into the first cell of a blank column: =COUNTIF(A:A,A1)>1
  2. Change the A in the formula to coincide with the letter of the cell column you wish to find duplicates
  3. Drag the cell’s contents down to the cells below

That’s it; any duplicate data will be identified in the new column as “TRUE” while non-duplicate data is indicated as “FALSE.” Next, you can sort by your count column and see all of the duplicates (or non-dupes) bunched together. In contrast to the visual method, this is a quick way to not only identify but remove, duplicates.

There are tweaks you can make to this general formula if you wish to customize the value results. For instance, you may want duplicate data to be identified as “Duplicate” instead of the default “TRUE” or “Unique” instead of “FALSE.” Or, remove the >1 and you’ll see the number of copies, which could be more than two.

Those customizations aside, we still haven’t covered all the ways you can find duplicates in Excel.

How to Find Duplicate Values in Excel Using VLOOKUP

The final manner of finding duplicates in Excel applies if you have two data columns. Another formula, the method uses =VLOOKUP to compare two separate columns for shared data and displays the commonalities in a third column.

In a third, blank column, add some sort of heading such as “Vlookup.” Then, get started with the following steps:

  1. Copy and paste =VLOOKUP(B2,$A$2:$A$14 ,1,FALSE) into the second cell of the third, blank column
  2. Adjust the cell letters and numbers to fit your data
  3. Drag the original cell down to the rest of the rows

With the VLOOKUP formula, data unique to columns A and B are shown as “#N/A” while duplicates appear as themselves. And this concludes the most popular ways to find duplicates in Excel. What you do next is up to you, though we have a few suggestions. First, you may want to remove any duplicate data. Then, if your data contains location information, you can always map it for better visualization.

Make A Map with Your Data

Finally, make use of our Excel mapping tool to copy and paste your data from your spreadsheet directly to a custom interactive map like the one below, no coding required.

View Make a Map of My Location and Favorite Places in a full screen map

You can change the map’s base style and markers, group by multiple data columns, and more. Get started today.