Skip to content
← All datasets

Low Access to Supermarkets (USDA 2019 Map)

Share of residents living far from a supermarket or large grocery store, by county: USDA's 2019 store list and 2010 Census population.

Year coverage
2019–2019
Updated
irregular
Version
1.0.0
Schema hash
7ec2e12494bc

Detail levels available

StateCounty · default

Overview

How many Georgians lived far from a supermarket, supercenter or large grocery store, for Georgia and each of its 159 counties, from the U.S. Department of Agriculture Economic Research Service's 2019 Large Retailer Access Map (formerly the Food Access Research Atlas): the residents (2010 Census) living more than a set straight-line distance from the nearest such store on ERS's 2019 store list, and their share of the population. USDA's main definition counts people more than 1 mile from a store in urban census tracts and more than 10 miles in rural tracts; two other urban/rural thresholds and four single distances (half a mile to 20 miles) are also served. County and state figures are our sums of ERS's 2010 census-tract counts.

Row grain: One row per year, county_fips, tract_geoid, distance_threshold.

Key metric

pct_population_low_access — Share of Residents with Low Access to a Supermarket (proportion)

The single headline value most answers want.

Variables

Every column in the fact table. The code is the exact field name the API returns.

ColumnTypeUnitRangeNull?Description
yearYearinteger——no2019, the year of ERS's supermarket list; the population is from the 2010 Census (see year_meaning). One release.
Full description
2019, the year of ERS's supermarket list; the population is from the 2010 Census (see year_meaning). One release.
county_fipsCounty FIPSstring——yes5-digit county FIPS code (FK to the counties dimension): the first five digits of ERS's 2010 census tract codes. NULL on the Georgia (state) row.
Full description
5-digit county FIPS code (FK to the counties dimension): the first five digits of ERS's 2010 census tract codes. NULL on the Georgia (state) row.

Joins counties; adds its label columns.

tract_geoidTract GEOIDstring——yesAlways NULL: ERS publishes 2010 census tracts, which do not join the 2020 tracts dimension, so figures are summed to counties. Kept for the health domain's standard key shape.
Full description
Always NULL: ERS publishes 2010 census tracts, which do not join the 2020 tracts dimension, so figures are summed to counties. Kept for the health domain's standard key shape.

Joins tracts; adds its label columns.

distance_thresholdDistance Thresholdstring——noHow far from a supermarket counts as low access; 1_mile_urban_10_miles_rural is USDA's main definition.
Full description
The straight-line distance to the nearest supermarket, supercenter or large grocery store beyond which a resident counts as having low access. USDA's urban/rural definitions: 1_mile_urban_10_miles_rural (USDA's main definition: more than 1 mile in urban tracts, more than 10 miles in rural tracts), half_mile_urban_10_miles_rural and 1_mile_urban_20_miles_rural. One distance for every tract, urban or rural: all_tracts_half_mile, all_tracts_1_mile, all_tracts_10_miles and all_tracts_20_miles. ERS calls a tract rural when its population-weighted center is outside any urban area of 2,500 or more people. The thresholds nest (a resident beyond 1 mile is also beyond half a mile): pick one, never add across them.
7 allowed values
  • 1_mile_urban_10_miles_rural
  • half_mile_urban_10_miles_rural
  • 1_mile_urban_20_miles_rural
  • all_tracts_half_mile
  • all_tracts_1_mile
  • all_tracts_10_miles
  • all_tracts_20_miles
num_population_low_accessResidents with Low Accessintegercount—yesResidents (2010 Census) living beyond the distance threshold from the nearest supermarket, supercenter or large grocery store on ERS's 2019 list: the sum of ERS's 2010 census-tract counts in the county (or Georgia), a tract count ERS writes as NULL (no value) counted as 0. Our calculation. ERS's tract counts are whole-number estimates, so a 0 can be less than one person rounded down. The numerator of pct_population_low_access.
Full description
Residents (2010 Census) living beyond the distance threshold from the nearest supermarket, supercenter or large grocery store on ERS's 2019 list: the sum of ERS's 2010 census-tract counts in the county (or Georgia), a tract count ERS writes as NULL (no value) counted as 0. Our calculation. ERS's tract counts are whole-number estimates, so a 0 can be less than one person rounded down. The numerator of pct_population_low_access.
num_populationPopulation (2010 Census)integercount—yesThe county's (or Georgia's) 2010 Census population: the sum of ERS's 2010 census-tract populations (Georgia 9,687,653, the 2010 Census count). The same on every distance_threshold row of a place: never add it across thresholds. The denominator of pct_population_low_access.
Full description
The county's (or Georgia's) 2010 Census population: the sum of ERS's 2010 census-tract populations (Georgia 9,687,653, the 2010 Census count). The same on every distance_threshold row of a place: never add it across thresholds. The denominator of pct_population_low_access.
pct_population_low_accessShare of Residents with Low Access to a Supermarketnumberproportion—yesShare of residents living beyond the distance threshold from the nearest supermarket, supercenter or large grocery store.
Full description
Share of residents (2010 Census) living beyond the distance threshold, straight-line, from the nearest supermarket, supercenter or large grocery store on ERS's 2019 list: our calculation, num_population_low_access / num_population, on the 0-1 scale (0.309 = 30.9%). Georgia: 30.9% at USDA's main definition (1 mile urban / 10 miles rural), 55.8% at half a mile urban / 10 miles rural, 29.8% at 1 mile urban / 20 miles rural; 82.6% beyond half a mile and 54.8% beyond 1 mile in every tract, 1.1% beyond 10 miles and 452 people beyond 20 miles. Low access, not USDA's low-income and low-access ('food desert') tract designation. For several counties, pool as SUM(num_population_low_access) / SUM(num_population) within one threshold. Chattahoochee County's 97.6% at the main definition (the highest) is preserved as published: 29% of its residents live in group quarters, and the share is the same without them; food sources on the Army post may not be on ERS's 2019 store list.

Filters

Query parameters the fact endpoint accepts. Comma-separated values are OR within a parameter; multiple parameters AND together.

ParameterKindAllowed valuesNotes
yearyear_exactany value—
year_minyear_rangeany value—
year_maxyear_rangeany value—
detaildetailcountiesstatesenum-enforced, default: counties
county_fipsforeign_keyany valuemulti-value
tract_geoidforeign_keyany valuemulti-value
distance_thresholdcategorical
7 allowed values
  • 1_mile_urban_10_miles_rural
  • half_mile_urban_10_miles_rural
  • 1_mile_urban_20_miles_rural
  • all_tracts_half_mile
  • all_tracts_1_mile
  • all_tracts_10_miles
  • all_tracts_20_miles
multi-value, enum-enforced, pick one

Example requests

Run these against the base URL — they return live data.

All rows (first page), counties level

curl "https://georgiacivicdata.org/api/v1/health/food_access_2019"

counties data for 2019

curl "https://georgiacivicdata.org/api/v1/health/food_access_2019?year=2019"

Filtered to distance_threshold = 1_mile_urban_10_miles_rural for 2019

curl "https://georgiacivicdata.org/api/v1/health/food_access_2019?year=2019&distance_threshold=1_mile_urban_10_miles_rural"

One county (FIPS 13121), 2019

curl "https://georgiacivicdata.org/api/v1/health/food_access_2019?county_fips=13121&year=2019&detail=counties"

Download 2019 as CSV

curl "https://georgiacivicdata.org/api/v1/health/food_access_2019?year=2019&format=csv"

Notes & limitations

NULL handling

    Limitations

    One release, not a series: where Georgia's 2010 Census population lived relative to the supermarkets, supercenters and large grocery stores of 2019 (year 2019 labels the store list; see year_meaning). A resident has low access when the nearest such store is more than a set straight-line distance away: by USDA's main definition (distance_threshold 1_mile_urban_10_miles_rural) more than 1 mile in an urban census tract and more than 10 miles in a rural one. The thresholds nest: pick one. Not USDA's 'food desert' (low-income and low-access tract) designation: this counts everyone beyond the distance, at any income and in any tract. County and state figures are our calculation: ERS publishes 2010 census tracts, which do not match the 2020 tracts, so each county row sums its tracts' counts and 2010 populations (Georgia's 159 counties did not change between 2010 and 2020) and the share is the summed count over the summed population. Distance is straight-line, from the center of each half-kilometer grid cell where ERS placed the population (from 2010 census blocks) to the center of the cell with the nearest store: not travel distance, and blind to roads, vehicles, transit, prices and store quality. Other food sources (convenience and dollar stores, small grocers, farmers' markets) do not count. A county's figure at the urban/rural thresholds mixes its urban tracts (the 1-mile or half-mile rule) and its rural tracts (10 or 20 miles); ERS calls a tract rural when its population-weighted center is outside any urban area of 2,500 or more people. Where nobody lives beyond the distance, ERS writes NULL (no value) in place of a tract's count; those tracts count as 0 here (ERS flags none of them as low access at that distance, and none has anyone at a farther distance). Tract counts are ERS's whole-number estimates, so a 0, a tract's or a county's, can be a fraction of a person rounded down rather than nobody (a few tracts show a count of 0 beside a positive share), and sums can differ by a few people from ERS's own unrounded county figures. Residents of group quarters (dormitories, barracks, prisons, nursing homes: 253,199 Georgians in ERS's file) count where they live, though many have food provided on site; ERS marks 10 Georgia tracts where at least 67% of residents live in group quarters. Not comparable with USDA's 2025 SNAP-authorized Retailer Access Map (SRAM): it counts any SNAP-authorized store (including convenience and dollar stores), on 2020 tracts with 2020 population, so never splice the two or read a trend between them. ERS expects a new version of this map in winter 2026-27, which would be a separate release. ERS's file lists 1,957 Georgia tracts; the 2010 tracts it leaves out have no residents (its population adds up to Georgia's 2010 Census count, 9,687,653). ERS suppresses nothing, and there are no NULLs; a 0 means nobody, or by ERS's estimate less than one person, lives beyond the distance. Not served: ERS's counts for low-income people, children, seniors, race and ethnicity groups and households without a vehicle, its tract flags, and tract rows. tract_geoid is always NULL.