Skip to content

This repo stores data on SNAP retailers based on historical records provided by USDA. All retailers have been geocoded and geographic identifiers have been added.

Notifications You must be signed in to change notification settings


Folders and files

Last commit message
Last commit date

Latest commit



82 Commits

Repository files navigation

Historical database of SNAP authorized retailers

This repository stores data on SNAP authorized retailers nationally. Data are from the USDA's SNAP retailer page, which currently provides historical data through December 31, 2022.

This project has added the following attributes to the USDA's data:

  • Broader groupings of store types from USDA's classification for use in analysis
  • Additional variables for years of authorization and the end of authorization in addition to the date
  • Geographic identifiers for the county, tract, PUMA, and place of all listed retailers for use in aggregation and analysis.

There are two main files available for download, both in zipped format to meet Github's size restrictions:

History of this project

The previous version of this repository linked yearly records of SNAP retailers. USDA now provides a single historical file that includes retailer IDs, and so geocoding and updating these records is now much easier. The previous datasets are still available on this site, covering 2005-2020:

  • The main CSV file with this link. This includes a combined version of the listings provided by USDA with dummy variables for each year and geographic coordinates for all stores.

  • An additional file with the state, county, census tracts, and metropolitan statistical areas of each store is avilable here and can be joined with the store id code. Right click and choose "Save link as" to download.

  • Metadata showing variable names are available on this spreadsheet.

  • The data folder of this repo contains the original files provided by USDA, which show store listings for June 30 from 2008-2019.

R scripts showing the data consolidation and editing process are also available in the home directory of the repo.

Version history/notes

  • 7/20/2023: The data were updated to include retailer additions and exits from SNAP in 2022.
  • 5/5/2022: A new version of the dataset using USDA's historical retailer data was created and added to the repository
  • 11/17/2020: Data for January and June 2020 were added to the dataset
  • 10/28/2019: 2019 Retailers were added to the dataset. These are stores authorized on June 30, 2019. Most were matched to existing records using exact or fuzzy matching. See the 2019 update script for the exact procedure.
  • 10/27/2019: An additional ~10,000 retailers were combined based on fuzzy matching on address.
  • 10/19/2019: About 15,000 duplicate retailers were identified and removed. See the "duplicate_reduction" script for that date for more detail.
  • 12/18/2018: A small correction was made for the MSA id on some stores (< 5,000).
  • 12/14/2018: Data on dollar stores nationally was added to the data folder, and a script for visualizing these across years is now in the scripts folder.
  • 12/12/2018: Data on SNAP retailers from June 30, 2018 was joined to the existing dataset. Location IDs were also added for unique addresses, and some duplicates in the earlier dataset were combined.


This repo stores data on SNAP retailers based on historical records provided by USDA. All retailers have been geocoded and geographic identifiers have been added.






No releases published


No packages published