CES-790 Data Tool Help

Overview
This page is designed to assist users in viewing and downloading Current Employment Statistics from the CES-790 using the data tool that allows you to customize your search.
There are three selections to help you narrow the criteria for your search. This page will guide you through the steps to narrow down the information to be viewed.
You must follow the selection steps in order.
  • After you make a selection, the next drop-down box will become available for you to make your next selection.
  • You will notice that the page will reload after each selection has been made and the options for the next drop-down menu will appear.
  • Once all selections have been made, options for viewing and downloading the data will become available.
This Help Page explains the process in greater detail and provides information about the selection options.
The following data will be included in the view page or download:
  • Most Recent Month Employment Data
  • Most Recent 13 Months Employment Data
  • Calendar Year by Month Employment Data
  • Additional Manufacturing Data (if applicable): Production Workers, Average Hourly Earnings (AHE), Average Weekly Hours (AWH), and Average Weekly Earnings (AWE)
See below for detailed help on each of the Steps in the data tool.
 

Step 1: Select Geography
The Select Geography tab is your first key to accessing Current Employment Statistics through the data tool. You must select a Geography before continuing to any of the other Steps. Once you have chosen a Geography, Step 2 will be available to you.
Data is available for the Commonwealth of Massachusetts and each of the Metropolitan New England City and Town Statistical Areas (NECTA) and six Metropolitan Divisions within the Boston-Cambridge-Quincy, MA-NH Metropolitan NECTA. Metropolitan New England City and Town Statistical Areas as determined by the U.S. Census. If you choose ‘State’, you are able to choose between Seasonally Adjusted Data and Not Seasonally Adjusted data. These options are not available for any other Geography.
 

Step 2: Select Industry or Industry Sector.
In the Select Industry or Industry Sector tab, only industries for which data exists will be displayed: if you do not see an industry, there are no data available. The industries are listed by North American Industry Classification System (NAICS) Codes, effectively phasing out the SIC (Standard Industry Classification) Codes.
To learn more about NAICS Codes and the structure, click here for information provided by the Bureau of Labor Statistics (BLS) or here for information by the Census Bureau.
All individual CES Series Codes as well as the Aggregate levels are displayed in this box. Select only one Industry or Industry sector. If you choose an aggregate level (indicated by capitalized letters), the two options will appear
  • Category Only: This choice will return one row of data that corresponds with your ‘Industry or Industry Sector’ choice.
  • Category with all sub-categories: This choice will return multiple rows of data: the ‘Industry or Industry Sector’ selected along with all the related sub-groupings.

Step 3: Select the Time Period
Once you have selected a Industry or Industry Sector, this box will become available so you may select a time period. The choices are: Most Recent Month, Most Recent 13 Months, and Calendar Year by Month. The Most Recent Month is not necessarily the current month or last month: it is the most recent month for which data exists in the records and is publicly available.
If you select Calendar Year by Month, another box will appear that allows you to choose the year(s) for which you would like to see data. You may select more than one year by holding down the ‘ctrl’ key.
 

Step 4: Select Additional Manufacturing Data (if applicable)
The Select Additional Manufacturing Data tab will only become available if you selected 30-000000 MANUFACTURING and Calendar Year by Month and data exists for at least one of the years you selected. Data is available beginning in 2001. There are five data choices available. ‘CES Employment Data’ is the main CES number that is reported for all Industries: the other four data types are additional data specific to the Manufacturing industry.
 

Viewing and Downloading Data
Options for viewing and downloading data will only be made available once you have progressed through all six steps. There are three ways in which to view the data:
  • HTML: A new browser window will open and display the data. From this page, you may ‘Print’ the page to your default printer. When you close this window, you will be returned to the data tool. All your selection criteria will remain selected, so you can then choose to download the data after viewing it.
  • Microsoft Excel: If you select this option, you can choose to save the Excel file to a location on your hard drive or to simply view it in your browser (from which you can save it to your hard drive, if you choose). Formatting will be preserved when you save it in Excel.
  • Comma Separated Value (.CSV): This file can be imported to any number of spreadsheet and database programs as well as a text program (such as Notepad). The delineator is a comma. This file is data only: formatting is not preserved.

 

For addition information, please contact:
Research Library Information Number: 617-626-5744
E-Mail: detlmi@detma.org