Name: US Census Bureau's Monthly State Retail Sales Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

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.54 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

89.65 kB
27,456 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
);