County/Metro Indicator - Retail Food Environment Index

U.S. Census Bureau. (2018). Economy Wide Statistics Division, County Business Patterns (2013-2016). Accessed July 18th, 2018.

Definition:

Retail Food Environment Index (RFEI) is the ratio of convenience stores (excluding gas stations convenience stores), limited-service restaurants (aka fast food restaurants), and full-service restaurants TO supermarkets and specialty food stores

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"healthstat-dph-sbcounty-gov/countymetro-indicator-retail-food-environment-wzrk-aynt\".\"countymetro_indicator_retail_food_environment\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.