Name: Food Deserts In The U.S.
Creator: Kaggle
License: https://www.usa.gov/government-works

About this Dataset

Food Deserts In The U.S.

Food Deserts in the United States

I jokingly call my neighborhood a Food Desert, as there's not a grocery store to be found nearby (and I live in a city!). This piqued my curiosity, and found that there's actually a fairly detailed data set maintained by the Economic Research Service (ERS) and U.S. Department of Agriculture (USDA).

What is a Food Desert?

The USDA defines living in a food desert as:

living more than one mile from a supermarket in urban/suburban areas, and more than 10 miles from a supermarket in rural areas

This data is pulled from the Food Access Research Atlas, and contains information on supermarket access at various distances. This data measures access by the Census-Tract, and as such provides a fairly granular overview. Additionally, what I thought was interesting is that it combined Food Access data with other fields such as age, race, rural or urban, and income.

Tables

Food Access Research Atlas

@kaggle.tcrammond_food_access_and_food_deserts.food_access_research_atlas

37.26 MB
72,864 rows
147 columns

CREATE TABLE food_access_research_atlas (
  "censustract" BIGINT,
  "state" VARCHAR,
  "county" VARCHAR,
  "urban" BIGINT,
  "pop2010" BIGINT,
  "ohu2010" BIGINT,
  "groupquartersflag" BIGINT,
  "numgqtrs" BIGINT,
  "pctgqtrs" DOUBLE,
  "lilatracts_1and10" BIGINT,
  "lilatracts_halfand10" BIGINT,
  "lilatracts_1and20" BIGINT,
  "lilatracts_vehicle" BIGINT,
  "hunvflag" BIGINT,
  "lowincometracts" BIGINT,
  "povertyrate" DOUBLE,
  "medianfamilyincome" BIGINT,
  "la1and10" BIGINT,
  "lahalfand10" BIGINT,
  "la1and20" BIGINT,
  "latracts_half" BIGINT,
  "latracts1" BIGINT,
  "latracts10" BIGINT,
  "latracts20" BIGINT,
  "latractsvehicle_20" BIGINT,
  "lapop1_10" DOUBLE,
  "lapop05_10" DOUBLE,
  "lapop1_20" DOUBLE,
  "lalowi1_10" DOUBLE,
  "lalowi05_10" DOUBLE,
  "lalowi1_20" DOUBLE,
  "lapophalf" DOUBLE,
  "lapophalfshare" DOUBLE,
  "lalowihalf" DOUBLE,
  "lalowihalfshare" DOUBLE,
  "lakidshalf" DOUBLE,
  "lakidshalfshare" DOUBLE,
  "laseniorshalf" DOUBLE,
  "laseniorshalfshare" DOUBLE,
  "lawhitehalf" DOUBLE,
  "lawhitehalfshare" DOUBLE,
  "lablackhalf" DOUBLE,
  "lablackhalfshare" DOUBLE,
  "laasianhalf" DOUBLE,
  "laasianhalfshare" DOUBLE,
  "lanhopihalf" DOUBLE,
  "lanhopihalfshare" DOUBLE,
  "laaianhalf" DOUBLE,
  "laaianhalfshare" DOUBLE,
  "laomultirhalf" DOUBLE,
  "laomultirhalfshare" DOUBLE,
  "lahisphalf" DOUBLE,
  "lahisphalfshare" DOUBLE,
  "lahunvhalf" DOUBLE,
  "lahunvhalfshare" DOUBLE,
  "lasnaphalf" DOUBLE,
  "lasnaphalfshare" DOUBLE,
  "lapop1" DOUBLE,
  "lapop1share" DOUBLE,
  "lalowi1" DOUBLE,
  "lalowi1share" DOUBLE,
  "lakids1" DOUBLE,
  "lakids1share" DOUBLE,
  "laseniors1" DOUBLE,
  "laseniors1share" DOUBLE,
  "lawhite1" DOUBLE,
  "lawhite1share" DOUBLE,
  "lablack1" DOUBLE,
  "lablack1share" DOUBLE,
  "laasian1" DOUBLE,
  "laasian1share" DOUBLE,
  "lanhopi1" DOUBLE,
  "lanhopi1share" DOUBLE,
  "laaian1" DOUBLE,
  "laaian1share" DOUBLE,
  "laomultir1" DOUBLE,
  "laomultir1share" DOUBLE,
  "lahisp1" DOUBLE,
  "lahisp1share" DOUBLE,
  "lahunv1" DOUBLE,
  "lahunv1share" DOUBLE,
  "lasnap1" DOUBLE,
  "lasnap1share" DOUBLE,
  "lapop10" DOUBLE,
  "lapop10share" DOUBLE,
  "lalowi10" DOUBLE,
  "lalowi10share" DOUBLE,
  "lakids10" DOUBLE,
  "lakids10share" DOUBLE,
  "laseniors10" DOUBLE,
  "laseniors10share" DOUBLE,
  "lawhite10" DOUBLE,
  "lawhite10share" DOUBLE,
  "lablack10" DOUBLE,
  "lablack10share" DOUBLE,
  "laasian10" DOUBLE,
  "laasian10share" DOUBLE,
  "lanhopi10" DOUBLE,
  "lanhopi10share" DOUBLE,
  "laaian10" DOUBLE
);

Food Access Variable Lookup

@kaggle.tcrammond_food_access_and_food_deserts.food_access_variable_lookup

8.56 kB
147 rows
3 columns

CREATE TABLE food_access_variable_lookup (
  "field" VARCHAR,
  "longname" VARCHAR,
  "description" VARCHAR
);