Context

The Monthly State Retail Sales (MSRS) is the Census Bureau's new experimental data product featuring modeled state-level retail sales. This is a blended data product using Monthly Retail Trade Survey data, administrative data, and third-party data. Year-over-year percentage changes are available for Total Retail Sales excluding Non-store Retailers as well as 11 retail North American Industry Classification System (NAICS) retail subsectors. These data are provided by state and NAICS codes beginning with January 2019.

Content

Geography: US

Time period: 2019 - 2022

Unit of analysis: US Census Bureau's Monthly State Retail Sales Data

Variables

Acknowledgements

Datasource: United States Census Bureau's Monthly State Retail Sales

https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F18335022%2F51529449c5ea6477431748f5c1b8a83f%2Fpic1.png?generation=1720540453192512&alt=media" alt="">

https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F18335022%2F831d14b5312bdda036b66793c4ed6944%2Fpic2.png?generation=1720540466019416&alt=media" alt="">

The U.S. Census Bureau.s economic indicator surveys provide monthly and quarterly data that are timely, reliable, and offer comprehensive measures of the U.S. economy. These surveys produce a variety of statistics covering construction, housing, international trade, retail trade, wholesale trade, services and manufacturing. The survey data provide measures of economic activity that allow analysis of economic performance and inform business investment and policy decisions. Other data included, which are not considered principal economic indicators, are the Quarterly Summary of State & Local Taxes, Quarterly Survey of Public Pensions, and the Manufactured Homes Survey. For information on the reliability and use of the data, including important notes on estimation and sampling variance, seasonal adjustment, measures of sampling variability, and other information pertinent to the economic indicators, visit the individual programs' webpages - http://www.census.gov/cgi-bin/briefroom/BriefRm.

View monthly updates and historical trends for US Retail Sales. from United States. Source: Census Bureau. Track economic data with YCharts analytics.

This dataset, identified by the series ID RSXFS, is sourced from the U.S. Census Bureau and is available through the Federal Reserve Economic Data (FRED) system of the St. Louis Fed. It provides a monthly measure of retail sales across the United States. The data represents the total value of sales at retail and food services stores, measured in millions of dollars and adjusted for seasonal variations. It is important to note that the most recent month's value is an advance estimate, which is subject to revision in subsequent months as more comprehensive data becomes available. As a key economic indicator, this series is widely used by economists and analysts to gauge consumer spending and assess the overall health of the U.S. economy.

Suggested Use Cases: - This dataset is highly valuable for economic analysis and can be used to: - Conduct time series analysis and modeling. - Track consumer spending patterns. - Forecast future retail sales. - Analyze the impact of economic events on the retail sector.

License The RSXFS dataset is sourced from the U.S. Census Bureau and is considered Public Domain: Citation Requested. This means the data is freely available for use, but you must cite the source and acknowledge that the data was obtained from FRED. If you plan on using any copyrighted series from other data providers on FRED for commercial purposes, you would need to contact the original data owner for permission.

Data Fields: The dataset primarily contains two columns: - observation_date: The date of the monthly data point, recorded as the first day of each month from January 1992 to July 2025. - RSXFS: The value of advance retail sales in millions of dollars.

Citation and Provenance:
Source: U.S. Census Bureau
Release: Advance Monthly Sales for Retail and Food Services
FRED Link: https://fred.stlouisfed.org/series/RSXFS
Citation: U.S. Census Bureau, Advance Retail Sales: Retail Trade [RSXFS], retrieved from FRED, Federal Reserve Bank of St. Louis; https://fred.stlouisfed.org/series/RSXFS, September 8, 2025.

Retail Sales in the United States increased 0.20 percent in September of 2025 over the previous month. This dataset provides - U.S. December Retail Sales Increased More Than Forecast - actual values, historical data, forecast, chart, statistics, economic calendar and news.

Graph and download economic data for Monthly State Retail Sales: Total Retail Sales Excluding Nonstore Retailers in California (MSRSCATOTAL) from Jan 2019 to Jun 2025 about retail trade, CA, sales, retail, and USA.

Graph and download economic data for Advance Retail Sales: Retail Trade (RSXFS) from Jan 1992 to Aug 2025 about retail trade, sales, retail, services, and USA.

Graph and download economic data for E-Commerce Retail Sales as a Percent of Total Sales (ECOMPCTSA) from Q4 1999 to Q2 2025 about e-commerce, retail trade, percent, sales, retail, and USA.

View monthly updates and historical trends for US Real Retail Sales. from United States. Source: Census Bureau. Track economic data with YCharts analytics.

This dataset presents statistics for Retail Trade: Floor Space by Selected Industry for the U.S. and States

United States Retail Sales: Furniture and Home Furnishings Stores (FH) data was reported at 10.166 USD bn in Oct 2018. This records an increase from the previous number of 9.928 USD bn for Sep 2018. United States Retail Sales: Furniture and Home Furnishings Stores (FH) data is updated monthly, averaging 7.615 USD bn from Jan 1992 (Median) to Oct 2018, with 322 observations. The data reached an all-time high of 11.636 USD bn in Dec 2017 and a record low of 3.846 USD bn in Jan 1992. United States Retail Sales: Furniture and Home Furnishings Stores (FH) data remains active status in CEIC and is reported by US Census Bureau. The data is categorized under Global Database’s USA – Table US.H001: Retail Sales: By NAIC System.

View monthly updates and historical trends for US Retail Sales YoY. from United States. Source: Census Bureau. Track economic data with YCharts analytics.

United States Retail Sales: Shoe Stores data was reported at 3.072 USD bn in May 2018. This records an increase from the previous number of 2.829 USD bn for Apr 2018. United States Retail Sales: Shoe Stores data is updated monthly, averaging 2.053 USD bn from Jan 1992 (Median) to May 2018, with 317 observations. The data reached an all-time high of 4.268 USD bn in Dec 2016 and a record low of 1.161 USD bn in Feb 1993. United States Retail Sales: Shoe Stores data remains active status in CEIC and is reported by US Census Bureau. The data is categorized under Global Database’s USA – Table US.H001: Retail Sales: By NAIC System.

Data Overview

• Scale: All sales figures are reported in millions of dollars.
• Size: The dataset contains 40,479 rows and 5 columns.
• Time Frame: January 1992 - September 2024.
• Industries Covered: Over 60 industries, including food, clothing, footwear, office supplies, automobiles, electronics, books, beverages, furniture, grocery and many more.
• Attributes:
  • naics_code
  • kind_of_business
  • sales_month
  • sales
  • estimate_type
• Source: This dataset was sourced from the publicly available U.S. Census Bureau retail sales data.

Cleaning & Preprocessing

• Missing Values:
  Some entries contained (NA) and (S) values, which were converted to null values.
  • (S): Estimate does not meet publication standards due to high sampling variability (coefficient of variation greater than 30%) or poor response quality (low total quantity response rate).
• Formatting:
  The downloaded data included headings, subheadings, and notes embedded within the tables. These extraneous elements were removed to ensure a clean and consistent dataset.
• Data Compilation:
  The original dataset was spread across multiple sheets, with each sheet containing data for a specific year. These sheets were consolidated into a single, unified table.
• Feature Engineering:
  A new column was created to provide both seasonally adjusted and non-seasonally adjusted sales values, enabling more nuanced analysis. Estimates are adjusted for seasonal variations, as well as holiday and trading-day differences, but not for price changes.

Use Cases

This dataset can be applied to a variety of analytical and machine learning tasks, including:

• Data Cleaning: Practice handling missing values, stray entries, and working with datetime data.
• Time Series Analysis: Perform trend analysis, seasonality detection, and forecasting.
• Exploratory Data Analysis (EDA): Gain insights into industry-specific trends and patterns.
• Machine Learning: Use it for predictive modeling and classification tasks.
• Market Research: Analyze industry performance to inform business strategies.

Release: Advance Monthly Sales for Retail and Food Services
Units: Millions of Dollars, Not Seasonally Adjusted

Frequency: Monthly

The value for the most recent month is an advance estimate that is based on data from a subsample of firms from the larger Monthly Retail Trade Survey. The advance estimate will be superseded in following months by revised estimates derived from the larger Monthly Retail Trade Survey. The associated series from the Monthly Retail Trade Survey is available at https://fred.stlouisfed.org/series/MRTSSM448USN

Information about the Advance Monthly Retail Sales Survey can be found on the Census website at https://www.census.gov/retail/marts/about_the_surveys.html

Suggested Citation: U.S. Census Bureau, Advance Retail Sales: Clothing and Clothing Accessory Stores [RSCCASN], retrieved from FRED, Federal Reserve Bank of St. Louis; https://fred.stlouisfed.org/series/RSCCASN, August 14, 2022.

United States Retail Sales: E Commerce data was reported at 121.460 USD bn in Sep 2018. This records an increase from the previous number of 120.479 USD bn for Jun 2018. United States Retail Sales: E Commerce data is updated quarterly, averaging 36.097 USD bn from Dec 1999 (Median) to Sep 2018, with 76 observations. The data reached an all-time high of 141.719 USD bn in Dec 2017 and a record low of 5.241 USD bn in Dec 1999. United States Retail Sales: E Commerce data remains active status in CEIC and is reported by US Census Bureau. The data is categorized under Global Database’s United States – Table US.H002: Retail Sales: By NAIC System: Quarterly.

The U.S. Census Bureau.s economic indicator surveys provide monthly and quarterly data that are timely, reliable, and offer comprehensive measures of the U.S. economy. These surveys produce a variety of statistics covering construction, housing, international trade, retail trade, wholesale trade, services and manufacturing. The survey data provide measures of economic activity that allow analysis of economic performance and inform business investment and policy decisions. Other data included, which are not considered principal economic indicators, are the Quarterly Summary of State & Local Taxes, Quarterly Survey of Public Pensions, and the Manufactured Homes Survey. For information on the reliability and use of the data, including important notes on estimation and sampling variance, seasonal adjustment, measures of sampling variability, and other information pertinent to the economic indicators, visit the individual programs' webpages - http://www.census.gov/cgi-bin/briefroom/BriefRm.

Graph and download economic data for Monthly State Retail Sales: Health and Personal Care Stores in the United States (MSRSUSA446) from Jan 2019 to Jun 2025 about hygiene, health, retail trade, sales, retail, and USA.

Content

More details about each file are in the individual file descriptions.

Context

This is a dataset from the U.S. Census Bureau hosted by the Federal Reserve Economic Database (FRED). FRED has a data platform found here and they update their information according the amount of data that is brought in. Explore the U.S. Census Bureau using Kaggle and all of the data sources available through the U.S. Census Bureau organization page!

• Update Frequency: This dataset is updated daily.

Acknowledgements

This dataset is maintained using FRED's API and Kaggle's API.

Graph and download economic data for Retail Sales: Food and Beverage Stores (MRTSSM445USS) from Jan 1992 to Jul 2025 about beverages, retail trade, food, sales, retail, and USA.