Weekly Spend (by merchant location)

Overview

The weekly spend by merchant location table contains information about all spending that takes place at brick and mortar locations in a given census tract, regardless of where the purchaser lives. Data is released weekly on a six day lag. Data is available for every week going back to January 2019. It is available for download in CSV format.

The consumer spending table shows the estimated consumer spending that occurred in the selected geography in a given week. Consumer spending includes all transactions — including credit card, debit card, and cash transactions — that take place at a point of sale, such as at retail stores, supermarkets, restaurants, taxis, and bars. It also includes e-commerce transactions in these same categories.

The data does not include all household expenditures; for example, rent, car payments, and healthcare spending is not included. This most closely aligns Replica’s consumer spending metric to the Census Bureau’s Monthly Retail Trade Estimates. Transactions are categorized by the merchant’s NAICS code.

Sample Download

Click here to download a CSV sample of Replica's weekly spend by merchant location table.

Schema

Field Name	Content Type	Sample Value	Description
geo_id	Integer	36005014100	The GEOID of the corresponding row's geography, as defined by the US Census Bureau.
geo_name	String	141 (Bronx, NY)	The name corresponding to the row’s geography, as defined by the US Census Bureau or specified by the user.
week/month_starting	Date	2022-06-13	The first day of the week (Saturday) or month of the corresponding row’s data, depending on whether monthly or weekly data was selected.
population	Integer	5756	The total population in the geography selected.
category_spend_total	Float	42157.48438	The total consumer spend in ": { " in a given week across the following categories: • Airline/hospitality/car rental • Entertainment/recreation • Gas stations/parking/taxis/tolls • Grocery stores • Restaurants/bars • Retail Note: Spend by merchant estimates only include in-person spending.

Methodology

Read Replica's Weekly Economic Model Methodology.