Wed
Feb 10 2010
08:37 am
Food environment atlas
By: R. Neal

Here's an interesting new site from the USDA: Food Environment Atlas. It has statistics at the county level. There are also tools to map and compare counties by various criteria.

Knox County's statistics after the jump...


County FIPS Code 47093
County Name Knox
State Name Tennessee
# Households no car & > 1 mi to store 5136
% Households no car & > 1 mi to store 3.26
# Low income & > 1 mi to store 57032
% Low income & > 1 mi to store 14.94
# Grocery stores 74
Grocery stores/ 1000 pop 0.175
# Supercenters and club stores 5
Supercenters and club stores/ 1000 pop 0.012
# Convenience stores no gas 58
Convenience stores no gas/ 1000 pop 0.137
# Convenience stores with gas 162
Convenience stores with gas/ 1000 pop 0.382
# SNAP-authorized stores 278
SNAP-authorized stores per/ 1000 pop 0.646
SNAP redemption/SNAP-authorized stores 212112
# WIC-authorized stores 51
WIC-authorized stores/ 1000 pop 0.119
WIC redemptions/WIC-authorized stores 126253
# Fast-food restaurants 339
Fast-food restaurants/ 1000 pop 0.8
# Full-service restaurants 313
Full-service restaurants/ 1000 pop 0.739
Fast-food expenditures per capita* 513
Restaurant expenditures per capita* 476
Avg monthly # SNAP participants* 1072054
Total SNAP benefits ($1000) 48918
Average monthly SNAP $ benefits 95
SNAP participation rate* 91
% Low-income receiving SNAP 38.1
Avg monthly # School-Lunch participants* 616380
% Students free-lunch eligible 28.5
% Students reduced-price-lunch eligible 4.6
Avg monthly # Schl-Breakfast particpnts* 250399
Avg monthly # Summer-Food participants* 28843
# Summer-Food program sites 59
Avg daily meals at Summer-Food sites 6858
Avg monthly # WIC participants* 174832
WIC $ redemptions 6438918
Avg daily served Child-&-Adult Care* 57706.75
Lbs per capita fruit&veg** 160
Ratio per capita fruit&veg/prep food** 53.7
Lbs per capita pkg sweetsnacks** 117
Gals per capita soft drinks** 89
Lbs per capita meat&poultry** 69
Lbs per capita solid fats** 18
Lbs per capita prepared meals** 297
Household food insecurity 2007* 1
Household food insecurity 2008* 0
Child food insecurity* 0
Relative price of low-fat milk ** 1.08
Relative price of sweetened drinks** 1
Relative ratio lw-fat milk/swtnd drnk** 1.17
Price ratio green-leafy/starchy veg** 1.62
Price ratio fruit/pkg sweet snacks** 0.34
Price ratio fruit/pkg savory snacks** 0.38
Price ratio wholegrain/refinedgrain** 1.28
Soda sales tax - retail stores* 0
Soda sales tax - vending* 0
Chip & pretzel sales tax - vending* 0
General food sales tax - retail stores* 0.055
Adult diabetes rate 12
Adult obesity rate 27.5
Low-income preschool obesity rate 13.7
# Farms with direct sales 89
% Farms with direct sales 7.3
% Farm sales $ direct to consumer 1.2
$ Direct farm sales 236
$ Direct farm sales per capita 0.56
# Farmers' markets 3
Farmers' markets/ 1000 pop 0.007
# Vegetable acres harvested 88
Vegetable acres harvested/ 1000 pop 0.21
Farm to school program 0
% Adults meeting activity guidelines* 51.8
% Highschoolers physically active* 42
Recreation & fitness facilities/ 1000 pop 0.116
ERS natural amenity index 4
% White 85.6
% Black 8.8
% Hispanic 2.4
% Asian 1.7
% Amer. Indian or Alaska Native 0.3
% Hawaiian or Pacific Islander 0
Median household income 45922
Poverty rate 14.3
Persistent poverty counties 0
Child poverty rate 17.5
Persistent child poverty counties 0
Metro-nonmetro counties 1
Population loss counties 0
Topics:
WhitesCreek's picture

Interesting stuff

Submitted by WhitesCreek on Wed, 2010/02/10 - 8:52am.

How did you get the data to download? Did you download the entire spreadsheet?

R. Neal's picture

Copied the text from the

Submitted by R. Neal on Wed, 2010/02/10 - 8:54am.

Copied the text from the table, inserted it into an editor that understands the HTML (Textpad), pasted that into Excel.

Want Roane Co?

WhitesCreek's picture

Yes I do,

Submitted by WhitesCreek on Wed, 2010/02/10 - 9:00am.

Thank you very much. I tried to do that but couldn't get it to work.

R. Neal's picture

Here you go: View as

Submitted by R. Neal on Wed, 2010/02/10 - 9:07am.

Here you go:

View as table

HTML in a txt file

Excel

(Right click and save target/link as...)

R. Neal's picture

Looks like some of the data

Submitted by R. Neal on Wed, 2010/02/10 - 9:13am.

Looks like some of the data is at state, region/district, or metro level. Some of the comparisons show the whole state as the same color, others have regions in the same color.

WhitesCreek's picture

Thanks. I owe you as per

Submitted by WhitesCreek on Wed, 2010/02/10 - 9:17am.

Thanks. I owe you as per usual.

Mykhailo's picture

All of the data included in

Submitted by Mykhailo on Wed, 2010/02/10 - 11:57am.

All of the data included in the Atlas are aggregated into an Excel spreadsheet for easy download.

Seriously?

FAIL.*

At least it's not a pdf, though.

(* I hold Rahm Emanuel personally responsible)

Mykhailo's picture

Even more than that, why is

Submitted by Mykhailo on Wed, 2010/02/10 - 12:17pm.

Even more than that, why is there no web service API thingy? Hopefully they have plans to roll this out eventually. It should be a basic, fundamental fact of life for every data-generating agency today, and any high-level IT manager that doesn't live and breathe this stuff should be fired.

EricLykins's picture

Hey, dorks

Submitted by EricLykins on Thu, 2010/02/11 - 5:37am.

new fad with the kids in California:

The project's goal is to inform and engage citizens by making politics and the money involved more transparent. We seek to un-scatter the political web-- the people, the relationships, and the money. Our method is to bring together databases that previously didn't talk to each other and people that previously didn't collaborate. By using computers and humans to "connect the dots", we can make the political process more transparent. Such transparency will help us choose better leaders and lead to our leaders behaving better...
The software is based on a service-oriented architecture and a web service API. This means that any governmental organization can have their campaign data displayed here by publishing it in the API format we have devised.

Government as a platform

We have an enormous opportunity right now to make a difference. There’s a receptivity to new ideas that we haven’t seen in a generation. Government at all levels has put out the call for help. It’s up to the tech community to respond, with our ideas, with our voices, with our creativity, and with our code.

more databases from Ellen Miller + "Improvements Needed For High Value Datasets On Data.gov."

5 Guiding Principles for any government employee -elected, appointed or hired.

“A popular Government, without popular information, or the means of
acquiring it, is but a Prologue to a Farce or a Tragedy; or, perhaps both. Knowledge will forever govern ignorance: And a people who mean to be their own Governors, must arm themselves with the power which knowledge gives.” –James Madison, letter to W.T. Barry, August 4, 1822

and for non-dorks, what it all means: "making the transition to describing what we do in a way that is broadly understandable."

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

TN Progressive

TN Politics

Knox TN Today

Local TV News

News Sentinel

    State News

    Wire Reports

    Lost Medicaid Funding

    To date, the failure to expand Medicaid/TennCare has cost the State of Tennessee ? in lost federal funding. (Source)

    Search and Archives