ES-202 Data Tool Help

Overview
This page is designed to assist users in viewing and downloading Employment and Wage information from the ES-202 using the data tool that allows you to customize your search.
There are six selections to help you narrow the criteria for your search. This page will guide you through the six 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:
  • Number of Establishments
  • Monthly Employment
  • Total Wages for the period selected
  • Average Monthly Employment for the period selected
  • Average Weekly Wages for the period selected
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 Employment and Wages 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 and you may select an actual area (Example: When you select City or Town in Geography, then you may choose a specific city, for instance, Boston, Lowell, etc. in Step 2).
  • State: Massachusetts
  • Metropolitan Statistical Areas: Areas with a population exceeding 100,000 as determined by the U.S. Census
  • Metropolitan New England City and Town Statistical Areas (NECTA): Areas as determined by the U.S. Census after the 2000 census.
  • Metropolitan NECTA Divisions: Divisions within the Boston-Cambridge-Quincy, MA-NH Metropolitan NECTA determined by the U.S. Census after the 2000 census.
  • Micropolitan NECTA: Areas as determined by the U.S. Census after the 2000 census.
    Detailed information about new area definitions is available from the Census Bureau at About Metropolitan and Micropolitan Statistical Areas.
  • Labor Market Areas: Central city or cities and surrounding territory within commuting distance
  • Workforce Investment Areas: Geographic areas created for the purpose of administering and delivering workforce development services including employment and training-related services
  • City or Town
  • County

Step 2: Select the Specific Geographic Area
The selection options in this tab will change based on what Geography you chose in the Step 1. If you chose "State" in Step 1, "Massachusetts" will automatically be selected for you.
You may only choose one Area at a time. If you wish to view multiple areas, you must return to Step 1 and make separate selections for each type of area.
 

Step 3: Select the Year
Once you have selected a Specific Geographic Area, this box will become available so you may select a year. Data is available for 2001 and 2002. You may only select one year at a time. If you wish to see multiple years, you must select multiple data sets.
Historical SIC Data is available and can be accessed from the main "Get Data" page (click on "Home" from the data tool to return to the Get Data home page).
 

Step 4: Select the Time Period
This box will give you the option to view Annual Data (only available once the entire year is complete and the data is made available) or a specific quarter:
  • First Quarter: January, February, and March
  • Second Quarter: April, May, and June
  • Third Quarter: July, August, and September
  • Fourth Quarter: October, November, and December

Step 5: Select the Ownership
Employers are classified as being a part of one of four sectors: Private, Federal Government, State Government, and Local Government. You may only select one ownership type.

Step 6: Select the Industry or Industry Sector
The selection options in this box were created based on your previous five selections.
Only industries for which data exists will be displayed: if you do not see an industry, there is either no data or the data are confidential. The industries are listed by North American Industry Classification System (NAICS) Codes, effectively phasing out the SIC (Standard Industry Classification) Codes.
If you wish to see historical data by SIC code, you must return to the main "Get Data" page (click on the "Home" button from the data tool).
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.
Below are descriptions of the first five choices in this box:
  • Total, all Industries: This choice will give you one row of data that will aggregate all the employment and wage statistics for your selection criteria or you may choose to get all the sub-categories.
  • Total by Industry Sector NAICS Code: This selection will return rows of data for each NAICS Super Sector and the sectors and sub-sector below with no detail. Super Sectors are higher aggregations of 2-digit industry sectors.
  • Total by 2-Digit NAICS Code: This selection will return rows of data for each 2-digit NAICS Code with no detail. Two-digit codes are the Industry Sectors, of which there are 21. Each 2-digit code has numerous 3-digit and 4-digit codes that break down industries into more specific areas of employment.
  • Goods-Producing Domain / Service-Providing Domain: This selection will return row of data for the relevant NAICS Domain or you may choose to get all the sub-categories.
  • NAICS Sector: This selection will return row of data for the relevant NAICS Sector or you may choose to get all the sub-categories.
If you choose Total, all Industries, Domain, Sector or any 2 or 3 digit code, you will be given the option to select "Category Only" or "Category with all sub-categories":
  • 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 (For example, if you select 92 Public Administration, you would also receive lines of data for 921, 9211, 931, etc.). If you select a 2-digit code, you will receive the 2 digit data along with all related 3 and 4 digit data. If a 3-digit code is selected, it is returned as well as the related 4-digit data.

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 printing annual data you will need to change to landscape page format. When you close this window, you will be returned to the data selection 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