Inquiring minds are investigating job creation and losses during the economic recovery. Data for following Tableau Software interactive map is courtesy of Economic Modeling Specialists.

The interactive map below may take a while to load. Please give it time on a slow connection.

Map Usage Notes

Hover your cursor over any line to see additional information. You can also select a single category from the drop-down boxes to isolate a particular type of job.

http://public.tableausoftware.com/javascripts/api/viz_v1.js

Job Gains & Losses 2008 - 2012

Number and Types of Jobs Since 2007

Description 2007 Jobs 2008 Jobs 2009 Jobs 2010 Jobs 2011 Jobs 2012 Jobs
Agriculture, Forestry, Fishing and Hunting 1,922,790 1,869,078 1,839,432 1,834,643 1,859,107 1,857,019
Mining, Quarrying, and Oil and Gas Extraction 677,207 729,813 658,373 667,226 745,595 784,070
Utilities 549,539 557,983 560,714 551,287 549,921 556,529
Construction 9,954,961 9,423,176 8,214,435 7,633,863 7,607,315 7,594,530
Manufacturing 14,093,901 13,629,742 12,051,829 11,712,063 11,920,262 12,116,646
Wholesale Trade 6,180,035 6,133,949 5,738,315 5,634,236 5,711,683 5,817,036
Retail Trade 16,279,661 16,040,307 15,262,809 15,158,575 15,338,727 15,427,475
Transportation and Warehousing 4,942,074 4,904,568 4,601,110 4,544,128 4,664,351 4,763,272
Information 3,181,035 3,129,245 2,949,820 2,838,954 2,808,734 2,801,533
Finance and Insurance 6,462,141 6,308,789 6,058,519 5,976,245 6,042,862 6,081,019
Real Estate and Rental and Leasing 2,767,868 2,699,430 2,553,130 2,477,330 2,439,220 2,467,061
Professional, Scientific, and Technical Services 8,970,748 9,110,964 8,789,436 8,744,022 8,951,222 9,202,138
Management of Companies and Enterprises 1,839,616 1,895,417 1,855,139 1,854,778 1,914,543 1,949,283
Admin and Support and Waste Management 9,301,860 8,892,117 8,081,998 8,311,872 8,626,800 8,934,731
Educational Services (Private) 3,317,313 3,413,586 3,504,764 3,575,972 3,666,851 3,760,523
Health Care and Social Assistance 16,304,386 16,716,857 17,036,693 17,301,036 17,506,396 17,848,232
Arts, Entertainment, and Recreation 2,375,489 2,389,692 2,337,992 2,313,773 2,336,448 2,342,772
Accommodation and Food Services 11,615,709 11,643,560 11,306,013 11,322,307 11,588,412 11,875,069
Other Services (except Public Administration) 7,502,059 7,522,620 7,451,832 7,398,326 7,478,030 7,525,044
Government 24,187,207 24,510,271 24,568,231 24,561,911 24,253,390 24,152,210
Unclassified Industry 216,926 208,532 173,872 152,667 173,741 186,339
Total 152,642,524 151,729,695 145,594,456 144,565,212 146,183,610 148,042,530

Gains and Losses Since End of 2007

Description 2012 – 2007
Agriculture, Forestry, Fishing and Hunting -65,771
Mining, Quarrying, and Oil and Gas Extraction 106,863
Utilities 6,990
Construction -2,360,431
Manufacturing -1,977,255
Wholesale Trade -362,999
Retail Trade -852,186
Transportation and Warehousing -178,802
Information -379,502
Finance and Insurance -381,122
Real Estate and Rental and Leasing -300,807
Professional, Scientific, and Technical Services 231,390
Management of Companies and Enterprises 109,667
Administrative and Support and Waste Management and Remediation Services -367,129
Educational Services (Private) 443,210
Health Care and Social Assistance 1,543,846
Arts, Entertainment, and Recreation -32,717
Accommodation and Food Services 259,360
Other Services (except Public Administration) 22,985
Government -34,997
Unclassified Industry -30,587
Total -4,599,994

Job Winners

  • Healthcare gained jobs every year since 2007, a total of  1,543,846
  • Private Education Services gained every year since 2007, a total of 443,210
  • Mining and Quarrying gained every year since 2007, a total of 106,863 

Job Losers

  • Construction lost jobs every year since 2007, a total of -2,360,431
  • Information lost jobs every year since 2007, a total of  -379,502
  • Government lost jobs every year since 200, a total of -34,997
  • Real Estate lost jobs every year from 2007-2011, a total of -300,807 since 2007
  • Manufacturing has gained jobs two consecutive years but the 2007-2012 total is -1,977,255
  • Retail Trade has gained jobs two consecutive years but the 2007-2012 total is -852,186

Lost and Gone Forever

The three largest net losers (construction, manufacturing, retail trade) have a net combined total of -5,189,872 since 2007. Most of those jobs are lost and gone forever.

Another 300,807 real estate jobs are lost and gone forever, as are 381,122 Finance and Insurance jobs, and  379,502 Information jobs.

Economic Modeling Data Notes

Data is yearly, so the period 2007-2012 is from the beginning of 2007 to the end of 2012. Snapshots below are from end-of year numbers.

Data is from multiple sources as explained below so it will not exactly match BLS reported numbers.

Comments from Economic Modeling Specialists

“Our data is used by many to research and understand regional employment trends and dynamics. It’s composed of comprehensive information on industries, occupations, demographics — as well as things like occupational skills, education, training, and even the names and size of companies in your region broken down by industry.

To do this we link nearly 90 data sources — from federal sources like the Bureau of Labor Statistics to state and private sources.

If you’ve ever worked with this sort of information, you know it can be hard to collect and present. It’s also often incomplete and outdated. So we organize the data, bring it up to date, and build software and reports around it so you can put it to use more quickly and effectively”

Thanks to Economic Modeling Specialists and Mike Klaczynski at Tableau Software for this post.

Mike “Mish” Shedlock

“Wine Country” Economic Conference Hosted By Mish
Click on Image to Learn More