U.S. flag

An official website of the United States government

Department of Labor Logo United States Department of Labor
Dot gov

The .gov means it's official.
Federal government websites often end in .gov or .mil. Before sharing sensitive information, make sure you're on a federal government site.

Https

The site is secure.
The https:// ensures that you are connecting to the official website and that any information you provide is encrypted and transmitted securely.

State and Metro Area Employment, Hours, & Earnings
Bureau of Labor Statistics > Current Employment Statistics (State and Metro Area) > Data > Databases

CES State and Area Data Access Tips

This page provides step-by-step instructions for extracting employment, hours, and earnings data from the Current Employment Statistics State and Area (CES-SA) data retrieval tools.

The CES State and Area homepage, https://www.bls.gov/sae, provides access to estimates of industry employment, hours, and earnings for all 50 States, the District of Columbia, Puerto Rico, the U.S. Virgin Islands, and about 450 metropolitan areas and divisions. It also provides access to related resources such as the State Employment and Unemployment and Metropolitan Area Employment and Unemployment news releases, interactive products, and research articles. The following options are available on the CES-SA Databases page in the left side navigation bar under Browse CES or at https://www.bls.gov/sae/data/.htm.

Table of Contents

Top Picks

The Top Picks data retrieval list contains the most requested CES-SA statistics.

  1. Click on Top Picks from www.bls.gov/sae/data/.htm.
  2. Click on the state of interest.
  3. Click on the checkbox next to each data series of interest.
  4. Click the Retrieve Data button. The default of 10 years of data will display in a new window.

The format of the output data can be changed using the More Formatting Options link in the upper right corner. See More Formatting Options under Other Tips below for an explanation of how to use each of the formatting options.

Back to Top

Using Data Search to Create Customized Tables

The Create Customized Tables data retrieval tools allow users to retrieve data for any published CES-SA series and output the data into tables. The two tools available are described below and use one screen or multiple screens to retieve the appropriate data.

One-Screen Data Search

The One-Screen Data Search data retrieval tool allows users to retrieve data for all published CES-SA series. To use this tool, Java must be loaded on your computer. If your computer does not have Java, use the Multi-Screen Data Search method described below. Up to 200 hundred series can be selected at once using this tool.

To retrieve data using this tool:

  1. Click on One-Screen Data Search from https://www.bls.gov/sae/data/.htm.

  2. Select one or more states (part 1 of 7) — CES State and Area publishes employment, hours, and earnings data at the state level for all 50 States, the District of Columbia, Puerto Rico, and the U.S. Virgin Islands.

  3. Select one or more metropolitan areas or divisions (part 2 of 7) — CES State and Area publishes employment, hours, and earnings data at the metropolitan area and division level for approximately 450 metropolitan areas and divisions.

  4. Select one or more supersectors (part 3 of 7) — Depending on the selections in boxes one and two, a list of the available supersectors appears in box three. Click on the supersector that contains the industry of interest. To select more than one supersector, see the Selecting Multiple Inputs section of this page under Other Tips.

  5. Select one or more industries (part 4 of 7) — Depending on the selections in boxes one through three, a list of the available industries will appear in box four. Click on the industry(ies) of interest. To navigate directly to an industry, use the Find box (described below in Find Box under Other Tips). To select more than one industry, see the Selecting Multiple Inputs section of this page under Other Tips.

  6. Select one or more data types (part 5 of 7) — Data types include employment, hours, earnings, and their derivatives. Each data type indicates its unit of measurement. To select a data type, click on the data type description from the list. To navigate directly to a data type, use the data type find box (described in the Find Box section of this page under Other Tips). To select more than one data type, see the Selecting Multiple Inputs section of this page under Other Tips.

  7. Select seasonal adjustment (part 6 of 7) — Select not seasonally adjusted and/or seasonally adjusted data series by clicking the check box next to the desired seasonal adjustment option(s). Time series data are seasonally adjusted to eliminate the effect of predictable variations that occur during the same period every year. More information about seasonal adjustments to CES-SA data is available at https://www.bls.gov/osmr/research-papers/1994/st940350.htm. If the data are not available, the text next to the check box will be grey instead of black.

  8. Get data (part 7 of 7) — After completing boxes one to six, the Get Data button becomes active. Click to retrieve the data. A new window will open with a table containing up to 10 years of the most recently available CES-SA data pertaining to the industry(ies) and data type(s) selected.

    OR

    Add to your selection (part 7 of 7) — After completing boxes one to six, the Add To Your Selection button also becomes active. Click this button to add the currently selected data series to a list of selected industries. Clicking on the button adds each selection to the list in the Your Selection box; multiple selections can be added to this box. Click the Get Data button to retrieve all of the selected data series.

More Formatting Options — More formatting options are available once the data have been retrieved. See the More Formatting Options section of this page under Other Tips for further instructions.

Back to Top

Multi-Screen Data Search

The Multi-Screen Data Search data retrieval tool allows users to retrieve data for any published CES-SA series. This tool uses five successive pages to make data series selections.

To retrieve data using this tool:

  1. Click on Multi-Screen Data Search from https://www.bls.gov/sae/data/.htm.

  2. Select seasonal adjustment (screen 1 of 7) — Check the box next to not seasonally adjusted, seasonally adjusted, or both. Time series data are seasonally adjusted to eliminate the effect of predictable variations that occur during the same period every year. More information about seasonal adjustments to CES-SA data is available at https://www.bls.gov/osmr/research-papers/1994/st940350.htm. Click the Next Form button to move to the next screen.

  3. Select one or more data types (screen 2 of 7) — Click on the data type(s) to view. To select more than one data type, see the Selecting Multiple Inputs section of this page under Other Tips. A list of data types is available at https://download.bls.gov/pub/time.series/sm/sm.data_type. Click the Next Form button to move to the next screen.

  4. Select one or more states (screen 3 of 7) — Click on the state(s) to view. To select more than one state, see the Selecting Multiple Inputs section of this page under Other Tips. A list of states is available at https://download.bls.gov/pub/time.series/sm/sm.state. Click the Next Form button to move to the next screen.

  5. Select one or more areas (screen 4 of 7) — Click on the area(s) to view. To select more than one area, see the Selecting Multiple Inputs section of this page under Other Tips. A list of areas is available at https://download.bls.gov/pub/time.series/sm/sm.area. Click the Next Form button to move to the next screen.

  6. Select one or more supersectors (screen 5 of 7) — Click on the supersector(s) containing the desired industry. For more information about industries see the Major Industry Groupings section of the CES Technical Notes at www.bls.gov/web/empsit/cestn.htm#section3b. To select more than one supersector, see the Selecting Multiple Inputs section of this page under Other Tips. Click the Next Form button to move to the next screen.

  7. Select one or more industries (screen 6 of 7) — A list of available industries for the options selected on the previous pages will appear in the scroll box. To select more than one industry, see the Selecting Multiple Inputs section of this page under Other Tips. More information about CES-SA industry codes and using the Text and Code Search boxes is available under Other Tips. Click the Next Form button to move to the next screen.

  8. Confirm series ID(s) (screen 7 of 7) — The series ID(s) for the selected industries are displayed in a text box. Saving the ID(s) will make it easier to pull the same data in the future using the Series Report tool described below. Click the Retrieve Data button to move to the next screen.

More Formatting Options — More formatting options are available once the data have been retrieved. See the More Formatting Options section of this page under Other Tips for further instructions.

Back to Top

Series Report

The Series Report data retrieval tool allows a user to retrieve data by providing a series ID. To use this tool:

  1. Open the Series Report data retrieval tool from https://www.bls.gov/sae/data/.htm.

  2. Enter the series ID(s) into the text box after the screen opens. Information about CES-SA series IDs is available at https://www.bls.gov/help/hlpforma.htm#SM.

  3. Click Next -> once the appropriate series have been entered.

  4. Edit the formatting options for the output. The formatting options screen is described in the More Formatting Options section of this page under Other Tips.

  5. Click Retrieve Data.

Back to Top

Flat Files

The Flat Files directory contains text files of CES-SA data and information about CES-SA series that can be viewed or downloaded. Information about these files is available in sm.txt in the same directory.

Back to Top

Discontinued Data Series

With the release of January 2003 data on March 20, 2003, the basis for industry classification changed from the SIC 1987 to the NAICS 2002. The historical SIC-based CES series can be retrieved using the Create Customized Tables (one screen), Create Customized Tables (multiple screens), and Flat File methods described above at the CES-SA databases page in the "Discontinued Data Series" section. The results are categorized by SIC and not by the North American Industry Classification System (NAICS), making them incompatible with later NAICS-based CES data. More information about the use of NAICS and SIC in the CES program is available at www.bls.gov/ces/naics/home.htm.

Back to Top

Other BLS Employment Data

Other employment data from BLS is available on the Overview of BLS Statistics on Employment page at www.bls.gov/bls/employment.htm or on the BLS home page at www.bls.gov. Available data include but are not limited to state and metropolitan area statistics, occupational employment statistics, labor force statistics, and wage and compensation statistics.

Contact information and phone numbers for all BLS programs are available on the BLS Contacts page at www.bls.gov/bls/contact.htm.

For information about the CES State and Area division or CES-SA data, call us at 202-691-6559 or email us.

Back to Top

Other Tips

More Formatting Options

Use the following options to change output formats:

  1. Select view of the data — In the upper left hand corner of the screen, choose how to display the data. Table Format is the default view, listing columns for each month and rows for each year. Column Format will list the data in one long column with a row for each year and month combination. Multi-series table will list all of the series chosen in one table with a row for each series and a column for each month and year combination. Underneath the Select view of the data box, several calculations can be applied to the original data. Check the boxes next to each version of the data to view, including the original data, a variety of different net changes of the series, and a variety of different net percentage changes of the series.

  2. Select the time frame for your data — In the upper right hand corner under Specify year range, select the year to begin the time series in the From drop down menu and the year to end the time series in the To drop down menu. The menus contain all of the years that are available for the selected series.

  3. Output type — On the left underneath Select view of the data is a box for Output Type. The data can be output as an HTML table or as text. Text output is either comma delimited or tab delimited; this can be specified in the drop down menu under the Text radio button.

  4. Graphs — Next to Output Type under Graphs, click the checkbox next to include graphs to add a line graph for each of the selected series.

  5. Retrieve data — After selecting the desired formats, click the Retrieve data button. Repeat this process if the data needs further changes.



Find Box

Type all or part of a data type description, industry name, or industry code in the text box, then click on the Find button. The first match in the data type list will be selected; repeated clicks of the Find button will move the selection to the next match in the list.

Text and Code Search

For screens 2 to 6 under Create Customize Tables Multiple Screens, the Text or Code search features can be used to easily find supersectors, data types, or industries on the respective screens. Use the text search to look for names and descriptions, such as electronic manufacturing or average hourly earnings. Use the code search to find all or part of a number that represents a CES-SA industry code or supersector. More information about each of these boxes is available at www.bls.gov/help/hlpserch.htm.

Selecting Multiple Inputs

In each scroll box described above in both the One Screen and Multiple Screens Create Customized Tables sections, it is possible to select multiple data types, supersectors, and industries. To select a block of industries, click the first industry in a group, hold down the Shift key, and click the last industry in the group. This will work if industries appear in a block with no unwanted industries in between. To select multiple industries that are not grouped together, click the each industry individually while holding down the Ctrl key.

CES-SA Industry Codes

In the industry list, the ordering is based on an 8-digit CES industry code. The first two digits indicate the supersector, and the last six digits relate to the NAICS code of the series. For example, 31334000 is the code for supersector 31, durable goods manufacturing, and NAICS 334000, computer and electronic product manufacturing.

A Note About Manufacturing

The manufacturing sector is broken into two parts. The first two digits of the CES tabcode indicate whether the industry is part of durable goods (31) or nondurable goods (32). To select industries within manufacturing, first select either durable or nondurable goods manufacturing from the supersector lists described in both the One Screen and Multiple Screens under Create Customized Tables above.

BLS Tutorials

BLS provides help and tutorials for the data retrieval tools at www.bls.gov/help/home.htm.

Back to Top

 

Last Modified Date: October 13, 2017