Employment by MSA and industry

An interactive visualization of employment in metropolitan areas.

Employment data from the Bureau of Economic Analysis, an agency of the United States Department of Commerce, is available for all metropolitan areas and major industries. I present this data in an interactive visualization using Tableau Public. In this visualization you may access several different presentations of the data. You may filter for specific areas, industries, and time periods. The data is available in a table of employment numbers, or in series presented as the percentage change since the first value. This illustrates relative growth, rather than magnitude, of employment. This is annual data from BEA table CA25N1 through 2015, the last year available at this time.

In the nearby example from the visualization we can see that Wichita has performed poorly compared to some peers of interest.

You may use the visualization yourself by clicking here.

Of note, the definitions of MSAs change from time to time.2

Employment by MSA and Industry example. Click for larger.


  1. Bureau of Economic Analysis. Regional Economic Accounts. https://www.bea.gov/regional/.
  2. Broomfield County, CO, was created from parts of Adams, Boulder, Jefferson, and Weld counties effective November 15, 2001. Estimates for Broomfield county begin with 2002.
    Estimates from 2008 forward separate Skagway-Hoonah-Angoon Census Area into Skagway Municipality and Hoonah-Angoon Census Area. Estimates from 2009 forward separate Wrangell-Petersburg Census Area into Petersburg Census Area and Wrangell City and Borough. In addition, a part of the Prince of Wales-Outer Ketchikan Census Area was annexed by Ketchikan Gateway Borough and part (Meyers Chuck Area) was included in the new Wrangell City and Borough. The remainder of the Prince of Wales-Outer Ketchikan Census Area was renamed Prince of Wales-Hyder Census Area. Petersburg Borough was created from part of former Petersburg Census Area and part of Hoonah-Angoon Census Area for 2013 forward. Prince of Wales-Hyder Census Area added part of the former Petersburg Census Area beginning in 2013. For years 2009-2012, Petersburg Borough reflects the geographic boundaries of the former Petersburg Census Area. Wade Hampton Census Area was renamed Kusilvak Census Area on July 1, 2015.
    Virginia combination areas consist of one or two independent cities with 1980 populations of less than 100,000 combined with an adjacent county. The county name appears first, followed by the city name(s). Separate estimates for the jurisdictions making up the combination area are not available. Bedford County, VA includes the independent city of Bedford for all years.
    Shannon County, SD was renamed to Oglala Lakota County, SD on May 1, 2015.
    Nonmetropolitan portion includes micropolitan counties.