Quarterly Census of Employment and Wages
Welcome to the step-by-step guide on how to use the Quarterly Census of Employment and Wages one-screen query system
The Quarterly Census of Employment and Wages data are a product of a Federal-State cooperative program. These data are a complete count of employment and wages for workers covered by unemployment insurance programs in the 50 States, the District of Columbia, Puerto Rico, and the Virgin Islands. The datatypes reported here include the number of employees, the number of establishments, total wages, average weekly wage per employee, and average annual pay per employee.
This tool lets users query the BLS databases for specific data series. For each survey and program, make a selection for each characteristic in the order listed. As you make your selection, the remaining characteristics will filter to show only choices where data are available. After choosing the series, click on "Add to selection." If you need more data series, repeat the steps of choosing the data series you need. After you've finished finding the data series you need, click on the "Get Data" button to retrieve the data, and an HTML table with data for the most recent 10 years will display. If you desire a different time period or format, you may modify the options on the data display page, or click on the "More Formatting Options" button for additional options on refining the data retrieval results. Note: users may not retrieve more than 200 data series in one query.
Click on the State of interest, or click on Metropolitan Statistical Areas or U.S. Total if that is your interest. Another option allows you to quickly compare statewide data for more than one state.
Type all or part of a search string in the search text box. The contents of the box will filter to show only those options that contain the search string.
If you selected a state at the first step, you may now click to select one or more counties within the State, or statewide data for the State. If you selected Metropolitan Statistical Areas at the first step, you may now click to select one or more MSAs of interest. If you selected U.S. Total at the first step, you have no option at this step. If you selected All States - Statewide at the first step, you may now click to select one or more states of interest.
To select multiple options, hold the Ctrl/Command button, and click the desired options.
Type all or part of a search string in the search text box. The contents of the box will filter to show only those options that contain the search string.
For the areas currently selected, industries with reported activity are displayed. Select one or more industries of interest. industries without reported activity within the currently selected areas are not displayed, and cannot be selected.
To select multiple options, hold the Ctrl/Command button, and click the desired options.
For the areas and industries currently selected, the ownership sectors with reported activity and available data are displayed. Select one or more ownership sectors of interest.
To select multiple options, hold the Ctrl/Command button, and click the desired options.
For the current selection, the establishment size strata with reported activity and available data are displayed. Select one or more establishment size strata of interest.
To select multiple options, hold the Ctrl/Command button, and click the desired options.
For the current selection, the available data types are displayed. Select one or more data types of interest.
To select multiple options, hold the Ctrl/Command button, and click the desired options.
You must make a selection for each of the characteristics in the order listed. Once you have selected all of the characteristics, the "Add to selection" button becomes active. Click the "Add to selection" button to list the selected data series in the "Your selection" box. You can return to the characteristics boxes and make new selections to request additional data series. Click the "Get Data" button to retrieve all the selected data series.
You must make a selection for each of the characteristics in the order listed. Once you have selected all of the characteristics, the "Get Data" button becomes active. Click to retrieve the data.
Last Modified Date: February 20, 2018
United States Department of Labor
