Unemployment in America, Mapped Over Time

Watch the regional changes across the country from 1990 to 2016.

We often hear about shifting unemployment rate at the national scale. It went up. It went down. It changes month-to-month. But unemployment is very regional, more common in some areas of the country than others. In many areas, unemployment rates remain relatively high despite the decreases in the national average.

The Bureau of Labor Statistics estimates county-level unemployment on a monthly basis. You can also get annual averages that go back to 1990. In the animated map above, I used the datasets to show the shifts over the past few decades.

Watch out for the big shift between 2008 and 2011 — and then the decrease in unemployment leading up to the present.

Of course, this rise and fall is obvious through the national average, shown in the chart below.
 

Unemployment Rate, National Average
 

While the line chart is more succinct, the map shows more complexity and feels more real.

Mapping Irregular Data with Interpolation in R

This is how to make this kind of map with your own data.

Nerd Notes

  • This was largely an excuse to try out the steps that David Sparks outlined to make his election map. BLS provides county estimates, so I interpolate to fill in the gaps and use basic linear transitions between years. As with all smoothing, this method has its advantages and disadvantages.
  • I made the bulk of this video in R.

Become a member. Support an independent site. Make great charts.

See What You Get

Learn to Visualize Data See All →

How to Make and Use Bar Charts in R

The chart type seems simple enough, but there sure are a lot of bad ones out there. Get yourself out of default mode.

How to Make Small Multiples in Excel

Also known as trellis charts, lattice chart, or whatever you want to call them, the technique lets you compare several categories in one view.

Interactive Time Series Chart with Filters

Time series charts can easily turn to spaghetti when you have multiple categories. By highlighting the ones of interest, you can direct focus and allow comparisons.

Loading Data and Basic Formatting in R

It might not be sexy, but you have to load your data and get it in the right format before you can visualize it. Here are the basics, which might be all you need.

Favorites

Cuisine Ingredients

What are the ingredients that make each cuisine? I looked at 40,000 recipes spanning 20 cuisines and 6,714 ingredients to see what makes food taste different.

Counting Happiness and Where it Comes From

Researchers asked 10,000 participants to list ten things that recently made them happy. I counted and connected the dots.

The Best Data Visualization Projects of 2011

I almost didn’t make a best-of list this year, but …

A Day in the Life: Women and Men

Using the past couple of years of data from the American Time Use Survey, I simulated a working day for men and women to see how schedules differ. Watch it play out in this animation.