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.
- Click on Top Picks from www.bls.gov/sae/data.htm.
- Click on the state of interest.
- Click on the checkbox next to each data series of interest.
- 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:
-
Click on One-Screen Data Search
from https://www.bls.gov/sae/data.htm.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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/abstract/st/st940350.htm. If the data are
not available, the text next to the check box will be grey instead of black.
-
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:
-
Click on Multi-Screen Data Search
from https://www.bls.gov/sae/data.htm.
-
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/abstract/st/st940350.htm. Click the Next Form button
to move to the next screen.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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:
-
Open the Series Report data retrieval tool
from https://www.bls.gov/sae/data.htm.
-
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.
-
Click Next -> once the appropriate series have been entered.
-
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.
-
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/cesnaics.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:
-
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.
-
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.
-
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.
-
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.
-
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