Open data and maps tell the local story of unemployment and recovery spending

Washington-based DevelopmentSeed continues to tell dazzling data stories with open source mapping tools. This week, they’ve posted a map of the local impact of unemployment and recovery spending. The map visualizes unemployment rate changes at a county level and folds in total economic recovery spending by the government under the American Recovery and Reinvestment Act of 2009. In the map embedded below, red corresponds to an increased unemployment rate and green corresponds to a lower unemployment rate or job growth. Counties that received less than $10 million dollars in recovery spending have a white pattern.

David Cole explains more in a post at

Over the last year, we see that unemployment dropped in 58% of counties by an average of 0.25 percentage points. On average the Recovery Act funded 31 projects at a total of $24,131,582.47 per county. Nationally this works out to about $282.66 in recovery spending per person.

Overall, it’s impossible to tell for sure how much recovery spending improved the economic situation, because we just don’t know how bad things could have been. It may be the case that without spending, this map would have a lot more red. Or maybe not. What’s interesting here is the local impact and information we are able to see from processing a few sets of open data. Check out how your county is doing compared to its surroundings. How about compared to a more or less urban county nearby?

Strata Conference New York 2011, being held Sept. 22-23, covers the latest and best tools and technologies for data science — from gathering, cleaning, analyzing, and storing data to communicating data intelligence effectively. Save 20% on registration with the code STN11RAD

One thought on “Open data and maps tell the local story of unemployment and recovery spending

  1. Pingback: 2011 Gov 2.0 year in review - O'Reilly Radar

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.