Skip to main content
The FRED® Blog

Posts tagged with: "RSFSDP"

View this series on FRED

Eating out or staying in? FRED says bon appétit

The FRED Blog has used data from the Census Bureau’s advance retail sales release table to compare the choice of spending outlets over time and to plot the relationship between gasoline prices and sales at gasoline stations. Today we use the “advance retail sales” data available for March 2020 to show another dimension of the social distancing required to manage the spread of COVID-19.

In the FRED graph above, the data show fairly steady growth of retail sales at restaurants and bars (the black line) catching up to retail sales at food and beverage stores (the red line) in August 2018. Note that to be able to compare sales figures over time, those figures are adjusted for the cost of living. The very last observations look like vertical lines because social distancing has dramatically switched consumer demand for restaurants and bars—almost dollar for dollar—to food and beverage stores. Keep in mind that the reported sales at restaurants and bars include the food prepared there for take-out.

If you look closely, you’ll notice the decrease in retail sales at restaurants and bars during 2009, as the Great Recession peaked and economic activity started to recover. During that time, there was no uptick in retail sales at food and beverage stores, though. Finally, although this FRED Blog post describes advance retail sales, an earlier post has compared those with retail sales and found them to be identical.

How this graph was created: Search for “Advance Retail Sales: Food Services and Drinking Places.” From the “Edit Graph” panel, open the “Add Line” tab and search for “Advance Retail Sales: Food and Beverage Stores.” Next, to adjust the sales figures for the cost of living, customize each line by searching for “Consumer Price Index for All Urban Consumers: All Items in U.S. City Average (CPIAUCSL)” and clicking on “Add.” Then, further customize the lines applying the formula (a/b)*100. Edit the graph colors and salt to taste.

Suggested by Diego Mendez-Carbajo.

View on FRED, series used in this post: CPIAUCSL, RSDBS, RSFSDP

Shopping lines: The evolution of retail in the U.S.

When it comes to shopping, Americans have many options: the corner store, the supermarket, the specialty store, the “big box,” online, and more. Above, we committed a graphing sin by displaying 12 different series in a single graph to show how retail trade has evolved across various categories.

Signs can be seen over the past two and a half decades: First, while food and beverage stores (supermarkets, convenience stores) were major destinations in the past, they have been joined by general merchandise stores, typically large suburban big box stores. A very volatile bunch are the gasoline stations, which sell mostly one commodity with a very variable price. Finally, one category seems to be steadily overtaking the others: mail-order and online shops (the line in black).

How this graph was created: Search for the Advance Monthly Sales for Retail and Food Services release and select the series you want to display. The release offers more series than the 12 we chose, but 12 is the maximum that can be shown on one FRED graph. In fact, with so many series, you need to make the graph larger by dragging the red marker in the bottom right corner of the graph. We chose the seasonally adjusted series and made the nonstore retail series black.

Suggested by Christian Zimmermann


Subscribe to the FRED newsletter

Follow us

Back to Top