Title Slide Breaking Local Stories with Economic Data
U.S. Bureau of Labor Statistics
Overberg Paul
Paul Overberg, a database editor at USA TODAY, !nds news in all kinds of data. He focuses on who the American people are and how they live -- their demographics. "at includes income in all forms; their lack of income, or poverty; and their jobs, the primary source of income for most people. "rough IRE/NICAR, he often helps local reporters learn about this kind of data. He also has worked as a science and health editor and as a local reporter and business editor.
[email protected] @poverberg
What we’ll cover Real news stories from BLS data on: • County employment, unemployment • Metro labor force, unemployment • Metro employment • Metro wage rates • State business dynamics • How to !nd each type of data • How to turn data → stories!
Photo by Flick user zesser
County unemployment “Fairfax County’s jobless rate declined slightly from October to November … to 3.6% …” -- Scott McCaffrey, Vienna (VA) Sun Gazette, Jan. 17, 2013
• Start here: bls.gov/lau/home.htm • Click on highlighted link: “LAU tables and maps” • County data: bls.gov/lau/laucntycur14.txt
bls.gov/lau/home.htm
County unemployment
• If you have a spreadsheet, open the !le and !lter on “Adams County, CO”
County unemployment
• Ideas: Google image search for “county unemployment map”
County unemployment
Video: Excel as BLS dashboard How to collect regular BLS data updates without having to reformat, analyze and graph them each month
Review the video at: http://bit.ly/econdata13
Metro unemployment “"e Lubbock-area unemployment rate fell to 5.8 percent in August from 6.4 percent in July … because of notable losses in both jobs and the civilian labor force.” -- Walt Nett, Sept. 21, 2012, Lubbock (Texas) Avalanche-Journal
http://lubbockonline.com/business/2012-09-21/local-unemployment-rate-falls-58-percent-sizeable-drop-workforce-jobs#.UUILNFe0J8E
http://bls.gov/lau/home.htm
Metro unemployment • Start here: bls.gov/lau/home.htm • Choose !rst link in highlighted section: “Unemployment rates for metro areas”
Metro unemployment Direct links: Monthly: bls.gov/web/metro/laummtrk.htm Year-over-year: bls.gov/web/metro/laummtch.htm
Metro employment “ … the six-county Chattanooga region added 3,900 jobs in the most recent 12-month period …” -- Dave Flessner, Jan. 1, 2013, Chattanooga Times Free-Press
www.timesfreepress.com/news/2013/jan/01/rebound-chattanooga-leads-state-job-growth
Metro employment Start here: bls.gov/news.release/metro.toc.htm • Table 1: Labor force, unemployed • Table 3: Employed
bls.gov/news.release/metro.toc.htm
Metro employment Start here: bls.gov/news.release/metro.toc.htm • Table 1: Labor force, unemployed • Table 3: Employed
Local wages “… Miami-Dade !nishes in the middle of the pack. ... average weekly wage grew to $880 in the third quarter of 2011, a 3.3 percent gain ... .” -- Douglas Hanks, HispanicBusiness.com, May 11, 2012
http://www.hispanicbusiness.com/2012/5/11/wage_gains_not_matching_job_gains.htm
Local wages Start here: bls.gov/bls/blswage.htm • Choose second link of fourth section: “For 375 metropolitan areas …” • Choose “T” for “Texas,” then “San Antonio-New Braunfels, TX”
bls.gov/bls/blswage.htm
Local wages -- Use column sorting to see top-paying occupations -- In Firefox, use add-on called TableTools2
Video: Location quotient A powerful tool to analyze your local economy
Review the video at: http://bit.ly/econdata13
Employment dynamics “… Colorado gained 128,595 private-sector jobs in last year’s fourth quarter from the previous quarter and lost 122,675 jobs, for a net gain of 5,920 jobs …” -- Mark Harden, Aug. 2, 2012, Denver Business Journal
www.bizjournals.com/denver/news/2012/08/02/colorado-gains-business-jobs-a-bit.html
Employment dynamics Start here: bls.gov/news.release/cewbd.toc.htm • Click on link for Table 6
http://bls.gov/news.release/cewbd.toc.htm
Employment dynamics
Employment dynamics To explore much deeper: onthemap.ces.census.gov
Questions? "anks for coming! Paul Overberg
USA TODAY poverberg@usatoday Twitter: @poverberg
http:/bit.ly/econdata13
for workshop slides, videos, handouts
Photo by Flickr user Xurble
