August 3, 2009 § 1 Comment
I’ve read dozens of news stories in the past few months that compared the recession’s effect on one area to its effect on the nation as a whole. These stories benefit from charts that convey the hard numbers behind the story.
Above is an example of how you might compare the unemployment rate in Columbia, Mo., to the rate in the United States. The city seems to be doing okay, relatively speaking.
The numbers to build this chart come from www.bls.gov/data/. From that page, scroll down to the unemployment section, and select the one-screen data search for “local area unemployment statistics.”
The search page will look something like this:
For the national figures use the one-screen search for “labor force statistics including the national unemployment rate.”
It has more options than the local-area statistics page. On option 7, choose unemployment rate. On option 8, choose not seasonally adjusted. On option 9, chose monthly.
In general you want to use seasonally adjusted rates when they’re available. Unfortunately, this database does not provide the adjusted rates for local areas. You have to use unadjusted rates for the national statistics as well to make an accurate comparison.