Dataset: US Census Bureau's Monthly State Retail Sales Data

About this Dataset

US Census Bureau's Monthly State Retail Sales Data

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

Variable	Description
fips	2-digit State Federal Information Processing Standards (FIPS) code. For more information on FIPS Codes, please reference this document. Note: The US is assigned a "00" State FIPS code.
state_abbr	States are assigned 2-character official U.S. Postal Service Code. The United States is assigned "USA" as its state_abbr value. For more information, please reference this document.
naics	Three-digit numeric NAICS value for retail subsector code.
subsector	Retail subsector.
year	Year.
month	Month.
change_yoy	Numeric year-over-year percent change in retail sales value.
change_yoy_se	Numeric standard error for year-over-year percentage change in retail sales value.
coverage_code	Character values assigned based on the non-imputed coverage of the data.

Variable	Description
coverage_code	Character values assigned based on the non-imputed coverage of the data.
coverage	Definition of the codes.

Acknowledgements

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

Tables

Coverage Codes

@kaggle.umerhaddii_us_census_bureaus_monthly_state_retail_sales_data.coverage_codes

2.48 KB
5 rows
2 columns


CREATE TABLE coverage_codes (
  "coverage_code" VARCHAR,
  "coverage" VARCHAR
);

State Retail

@kaggle.umerhaddii_us_census_bureaus_monthly_state_retail_sales_data.state_retail

87.55 KB
27456 rows
9 columns


CREATE TABLE state_retail (
  "fips" BIGINT,
  "state_abbr" VARCHAR,
  "naics" DOUBLE,
  "subsector" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "change_yoy" VARCHAR,
  "change_yoy_se" VARCHAR,
  "coverage_code" VARCHAR
);