The Occupational Employment and Wage Statistics (OES) program conducts a semi-annual survey to produce estimates of employment and wages for specific occupations. The OES program collects data on wage and salary workers in nonfarm establishments in order to produce employment and wage estimates for about 800 occupations. Data from self-employed persons are not collected and are not included in the estimates. The OES program produces these occupational estimates by geographic area and by industry. Estimates based on geographic areas are available at the National, State, Metropolitan, and Nonmetropolitan Area levels. The Bureau of Labor Statistics produces occupational employment and wage estimates for over 450 industry classifications at the national level. The industry classifications correspond to the sector, 3-, 4-, and 5-digit North American Industry Classification System (NAICS) industrial groups. More information and details about the data provided can be found at http://www.bls.gov/oes

The Occupational Employment and Wage Statistics (OEWS) Survey is a federal-state cooperative program between the Bureau of Labor Statistics (BLS) and State Workforce Agencies (SWAs). The BLS provides the procedures and technical support, draws the sample, and produces the survey materials, while the SWAs collect the data. SWAs from all fifty states, plus the District of Columbia, Puerto Rico, Guam, and the Virgin Islands participate in the survey. Occupational employment and wage rate estimates at the national level are produced by BLS using data from the fifty states and the District of Columbia. Employers who respond to states' requests to participate in the OEWS survey make these estimates possible.

The OEWS survey collects data from a sample of establishments and calculates employment and wage estimates by occupation, industry, and geographic area. The semiannual survey covers all non-farm industries. Data are collected by the Employment Development Department in cooperation with the Bureau of Labor Statistics, US Department of Labor. The OEWS Program estimates employment and wages for approximately 830 occupations. It also produces employment and wage estimates for statewide, Metropolitan Statistical Areas (MSAs), and Balance of State areas. Estimates are a snapshot in time and should not be used as a time series.

The OEWS estimates are published annually.

SOURCE: https://www.bls.gov/oes/oes_emp.htm

The Employment Cost Index (ECI) component of the National Compensation Survey (NCS) that measures changes in labor costs. The ECI is a quarterly measure of the change in the cost of labor, free from the influence of employment shifts among occupations and industries. The compensation series includes changes in wages and salaries plus employer costs for employee benefits. The wage and salary series and benefit series provide the change for the two components of compensation. Employee benefit costs are calculated as cost-per-hour-worked for 21 benefits, ranging from employer payments for Social Security to paid time off for holidays. For information and data please visit: https://www.bls.gov/ncs/

Graph and download economic data for Total wages and salaries, BLS (BA06RC1A027NBEA) from 1982 to 2023 about salaries, wages, GDP, and USA.

The Quarterly Census of Employment and Wages (QCEW) Program is a Federal-State cooperative program between the U.S. Department of Labor’s Bureau of Labor Statistics (BLS) and the California EDD’s Labor Market Information Division (LMID). The QCEW program produces a comprehensive tabulation of employment and wage information for workers covered by California Unemployment Insurance (UI) laws and Federal workers covered by the Unemployment Compensation for Federal Employees (UCFE) program.

The QCEW program serves as a near census of monthly employment and quarterly wage information by 6-digit industry codes from the North American Industry Classification System (NAICS) at the national, state, and county levels. At the national level, the QCEW program publishes employment and wage data for nearly every NAICS industry. At the state and local area level, the QCEW program publishes employment and wage data down to the 6-digit NAICS industry level, if disclosure restrictions are met. In accordance with the BLS policy, data provided to the Bureau in confidence are used only for specified statistical purposes and are not published. The BLS withholds publication of Unemployment Insurance law-covered employment and wage data for any industry level when necessary to protect the identity of cooperating employers.

Data from the QCEW program serve as an important input to many BLS programs. The Current Employment Statistics and the Occupational Employment Statistics programs use the QCEW data as the benchmark source for employment. The UI administrative records collected under the QCEW program serve as a sampling frame for the BLS establishment surveys.

In addition, the data serve as an input to other federal and state programs. The Bureau of Economic Analysis (BEA) of the Department of Commerce uses the QCEW data as the base for developing the wage and salary component of personal income.

The U.S. Department of Labor’s Employment and Training Administration (ETA) and California's EDD use the QCEW data to administer the Unemployment Insurance program. The QCEW data accurately reflect the extent of coverage of California’s UI laws and are used to measure UI revenues; national, state and local area employment; and total and UI taxable wage trends.

The U.S. Department of Labor’s Bureau of Labor Statistics publishes new QCEW data in its County Employment and Wages news release on a quarterly basis. The BLS also publishes a subset of its quarterly data through the Create Customized Tables system, and full quarterly industry detail data at all geographic levels.

Disclaimer: For information regarding future updates or preliminary/final data releases, please refer to the Bureau of Labor Statistics Release Calendar: https://www.bls.gov/cew/release-calendar.htm

About this Dataset

This dataset combines automation probability data with a breakdown of the number of jobs and salary in each occupation by state within the USA. Automation probability was acquired from the work of Carl Benedikt Freyand Michael A. Osborne; State employment data is from the Bureau of Labor Statistics. Note that for simplicity of analysis, all jobs where data was not available or there were less than 10 employees were marked as zero.

How to Cite this Dataset

If you use this dataset in your research, please credit the authors.

Salary Data

@misc{u.s. bureau of labor statistics, title={Occupational Employment Statistics}, url={https://www.bls.gov/oes/current/oes_nat.htm}, journal={U.S. BUREAU OF LABOR STATISTICS}}

Automation Data

@article{frey_osborne_2017, title={The future of employment: How susceptible are jobs to computerisation?}, volume={114}, DOI={10.1016/j.techfore.2016.08.019}, journal={Technological Forecasting and Social Change}, author={Frey, Carl Benedikt and Osborne, Michael A.}, year={2017}, pages={254–280}}

License

License was not specified at the source.

Splash Banner

Photo by Alex Knight on Unsplash

The Employer Costs for Employee Compensation (ECEC) is a measure of the cost of labor. The compensation series includes wages and salaries plus employer costs for individual employee benefits. Employee benefit costs are calculated as cents-per-hour-worked for individual benefits ranging from employer payments for Social Security to paid time off for holidays. The survey covers all occupations in the civilian economy, which includes the total private economy (excluding farms and households), and the public sector (excluding the Federal government). Statistics are published for the private and public sectors separately, and the data are combined in a measure for the civilian economy.

For information and data, visit: https://www.bls.gov/ncs/ect/

Context

A striking graph from the Social Security Administration (https://www.ssa.gov/policy/docs/factsheets/at-a-glance/earnings-men-1988-2018.html) shows that median annual earnings for all men above the age of 20 have decreased since 1988: https://www.ssa.gov/policy/docs/factsheets/at-a-glance/earnings-men-1988-2018.svg" alt="">

I wanted to better understand how educational attainment has played a role in the above trend, and to come up with a model to forecast the future trend for earnings by educational attainment.

As I began looking at the data from the Bureau of Labor Statistics website, there was a striking trend: the median weekly earnings for all groups of people who did not have a bachelors degree or higher had decreased from 1979 levels, in constant 2020 dollars.

Content

I collated data from the US Bureau of Labor Statistics (https://www.bls.gov/webapps/legacy/cpsatab4.htm) and (https://www.bls.gov/cps/cpswktabs.htm) and the US Census Bureau (https://www.census.gov/data/tables/time-series/demo/income-poverty/historical-income-people.html) to create this dataset.

I have omitted details of gender and race, to solely look at the correlation between educational attainment and median weekly earnings over the years. All of the data is for ages 25 and higher unless otherwise stated in the column header.

An important note is that all the earnings data are in constant base 2020 dollars. This removes the effects of inflation and makes it possible to compare the numbers over the years.

The data starts at the year 1960, but unfortunately only overall labor force data, and population percentages of persons with a high school graduation (HSG) and persons with a Bachelors or Higher Degree are available. Median weekly earnings data categorized by educational attainment is available from 1979 onwards, while labor force data i.e., labor force level, labor force participation rate and the employment level by educational attainment is available only from 1992 onwards.

The only columns that have data from 1960 onwards are: (i) overall labor force level, (ii) civilian non-institutional population level, (iii) overall labor force participation rate, (iv) overall employment level, (v) overall percentage of high school graduates, and (vi) overall percentage of persons with a bachelors degree or higher.

Some of the columns can be calculated from other columns, for instance the civilian non-institutional population level can be calculated from the labor force participation rate.

Acknowledgements

All of this data is from the Bureau of Labor Statistics, and the Census Bureau: https://www.bls.gov/webapps/legacy/cpsatab4.htm , https://www.bls.gov/cps/cpswktabs.htm and https://www.census.gov/data/tables/time-series/demo/income-poverty/historical-income-people.html .

A big thank you to all those who worked so hard to collect and organize this data.

Inspiration

The main question is: what is the best way to generate forecasts for median weekly earnings for each educational attainment level?

Graph and download economic data for Employed: Workers paid hourly rates: Government wage and salary workers: 16 years and over (LEU0204926100A) from 2000 to 2020 about paid, salaries, workers, hours, wages, 16 years +, government, employment, rate, and USA.

Graph and download economic data for Employed full time: Wage and salary workers: Eligibility interviewers, government programs occupations: 16 years and over (LEU0254500500A) from 2000 to 2024 about occupation, full-time, salaries, workers, 16 years +, wages, government, employment, and USA.

The Quarterly Census of Employment and Wages (QCEW) program publishes a quarterly count of employment and wages reported by employers covering 98 percent of U.S. jobs, available at the county, MSA, state and national levels by industry.

More information and details about the data provided can be found at http://www.bls.gov/cew

Context:

The Occupational Employment Statistics (OES) and National Compensation Survey (NCS) programs have produced estimates by borrowing from the strength and breadth of each survey to provide more details on occupational wages than either program provides individually. Modeled wage estimates provide annual estimates of average hourly wages for occupations by selected job characteristics and within geographical location. The job characteristics include bargaining status (union and nonunion), part- and full-time work status, incentive- and time-based pay, and work levels by occupation.

Direct estimates are based on survey responses only from the particular geographic area to which the estimate refers. In contrast, modeled wage estimates use survey responses from larger areas to fill in information for smaller areas where the sample size is not sufficient to produce direct estimates. Modeled wage estimates require the assumption that the patterns to responses in the larger area hold in the smaller area.

The sample size for the NCS is not large enough to produce direct estimates by area, occupation, and job characteristic for all of the areas for which the OES publishes estimates by area and occupation. The NCS sample consists of 6 private industry panels with approximately 3,300 establishments sampled per panel, and 1,600 sampled state and local government units. The OES full six-panel sample consists of nearly 1.2 million establishments.

The sample establishments are classified in industry categories based on the North American Industry Classification System (NAICS). Within an establishment, specific job categories are selected to represent broader occupational definitions. Jobs are classified according to the Standard Occupational Classification (SOC) system.

Content:

Summary: Average hourly wage estimates for civilian workers in occupations by job characteristic and work levels. These data are available at the national, state, metropolitan, and nonmetropolitan area levels.

Frequency of Observations: Data are available on an annual basis, typically in May.

Data Characteristics: All hourly wages are published to the nearest cent.

Acknowledgements:

This dataset was taken directly from the Bureau of Labor Statistics and converted to CSV format.

Inspiration:

This dataset contains the estimated wages of civilian workers in the United States. Wage changes in certain industries may be indicators for growth or decline. Which industries have had the greatest increases in wages? Combine this dataset with the Bureau of Labor Statistics Consumer Price Index dataset and find out what kinds of jobs you would need to afford your snacks and instant coffee!

Graph and download economic data for Employment Cost Index: Wages and salaries for State and local government workers in Service occupations (CIU3020000300000I) from Q1 2001 to Q2 2025 about ECI, state & local, occupation, salaries, workers, wages, government, services, and USA.

The Employment Cost Index (ECI) measures the change in the hourly labor cost to employers over time. The ECI uses a fixed “basket” of labor to produce a pure cost change, free from the effects of workers moving between occupations and industries and includes both the cost of wages and salaries and the cost of benefits.In the private sector, business owners and human resources professionals can use the ECI to make decisions about pay adjustments to help them stay competitive. In the public sector, the Federal Reserve and others use the ECI to gauge the health of the labor market, adjust contracts, and research the labor market.There are two data schemas:NAICS-SOC basis (2001-Present) - ciSIC-OCS basis (1979-2005) - ec

National Compensation Survey - Benefits produces comprehensive data on the incidence (the percentage of workers with access to and participation in employer provided benefit plans) and provisions of selected employee benefit plans. The Employee Benefits Survey (EBS) is an annual survey of the incidence and provisions of selected benefits provided by employers. The data are presented as a percentage of employees who participate in a certain benefit, or as an average benefit provision (for example, the average number of paid holidays provided to employees per year). The survey covers paid leave benefits such as holidays and vacations, and person, funeral, jury duty, military, parental, and sick leave; sickness and accident, long-term disability, and life insurance; medical, dental, and vision care plans; defined benefit pension and defined contribution plans; flexible benefits plans; reimbursement accounts; and unpaid parental leave. Also, data are tabulated on the incidence of several other benefits, such as severance pay, child-care assistance, wellness programs, and employee assistance programs.

For more information and data visit: https://www.bls.gov/ebs/

The National Compensation Survey (NCS) program produces information on wages by occupation for many metropolitan areas.The Modeled Wage Estimates (MWE) provide annual estimates of average hourly wages for occupations by selected job characteristics and within geographical location. The job characteristics include bargaining status (union and nonunion), part- and full-time work status, incentive- and time-based pay, and work levels by occupation. The modeled wage estimates are produced using a statistical procedure that combines survey data collected by the National Compensation Survey (NCS) and the Occupational Employment Statistics (OES) programs. Borrowing from the strengths of the NCS, information on job characteristics and work levels, and from the OES, the occupational and geographic detail, the modeled wage estimates provide more detail on occupational average hourly wages than either program is able to provide separately. Wage rates for different work levels within occupation groups also are published. Data are available for private industry, State and local governments, full-time workers, part-time workers, and other workforce characteristics.

VITAL SIGNS INDICATOR Income (EC5)

FULL MEASURE NAME Worker income by workplace (earnings)

LAST UPDATED October 2016

DESCRIPTION Income reflects the median earnings of individuals and households from employment, as well as the income distribution by quintile. Income data highlight how employees are being compensated for their work on an inflation-adjusted basis.

DATA SOURCE U.S. Census Bureau: Decennial Census Count 4Pb (1970) Form STF3 (1980-1990) Form SF3a (2000) https://nhgis.org

U.S. Census Bureau: American Community Survey Form B08521 (2006-2015; place of employment) http://api.census.gov

Bureau of Labor Statistics: Consumer Price Index All Urban Consumers Data Table (1970-2015; specific to each metro area) http://data.bls.gov

CONTACT INFORMATION vitalsigns.info@mtc.ca.gov

METHODOLOGY NOTES (across all datasets for this indicator) Income data reported in a given year reflects the income earned in the prior year (decennial Census) or in the prior 12 months (American Community Survey); note that this inconsistency has a minor effect on historical comparisons (for more information, go to: http://www.census.gov/acs/www/Downloads/methodology/ASA_nelson.pdf). American Community Survey 1-year data is used for larger geographies – metropolitan areas and counties – while smaller geographies rely upon 5-year rolling average data due to their smaller sample sizes. Quintile income for 1970-2000 is imputed from Decennial Census data using methodology from the California Department of Finance (for more information, go to: http://www.dof.ca.gov/Forecasting/Demographics/Census_Data_Center_Network/documents/How_to_Recalculate_a_Median.pdf). Bay Area income is the population weighted average of county-level income.

Income has been inflated using the Consumer Price Index specific to each metro area; however, some metro areas lack metro-specific CPI data back to 1970 and therefore adjusted data is unavailable for some historical data points. Note that current MSA boundaries were used for historical comparison by identifying counties included in today’s metro areas.

Graph and download economic data for Employment Level - Nonagriculture, Government Wage and Salary Workers (LNU02032188) from Jan 1948 to Sep 2025 about nonagriculture, salaries, workers, 16 years +, wages, household survey, government, employment, and USA.

Numbers of private-sector establishments in Pierce County, by quarter, reporting information about employment and wages on the Quarterly Census of Employment and Wages.

VITAL SIGNS INDICATOR
Jobs by Industry (EC1)

FULL MEASURE NAME
Employment by place of work by industry sector

LAST UPDATED
December 2022

DESCRIPTION
Jobs by industry refers to both the change in employment levels by industry and the proportional mix of jobs by economic sector. This measure reflects the changing industry trends that affect our region’s workers.

DATA SOURCE
Bureau of Labor Statistics, Quarterly Census of Employment and Wages (QCEW) - https://www.bls.gov/cew/downloadable-data-files.htm
1990-2021

CONTACT INFORMATION
vitalsigns.info@bayareametro.gov

METHODOLOGY NOTES (across all datasets for this indicator)
Quarterly Census of Employment and Wages (QCEW) employment data is reported by the place of work and represent the number of covered workers who worked during, or received pay for, the pay period that included the 12th day of the month. Covered employees in the private-sector and in the state and local government include most corporate officials, all executives, all supervisory personnel, all professionals, all clerical workers, many farmworkers, all wage earners, all piece workers and all part-time workers. Workers on paid sick leave, paid holiday, paid vacation and the like are also covered.

Besides excluding the aforementioned national security agencies, QCEW excludes proprietors, the unincorporated self-employed, unpaid family members, certain farm and domestic workers exempted from having to report employment data and railroad workers covered by the railroad unemployment insurance system. Excluded as well are workers who earned no wages during the entire applicable pay period because of work stoppages, temporary layoffs, illness or unpaid vacations.

The location quotient (LQ) is used to evaluate level of concentration or clustering of an industry within the Bay Area and within each county of the region. A location quotient greater than 1 means there is a strong concentration for of jobs in an industry sector. For the Bay Area, the LQ is calculated as the share of the region’s employment in a particular sector divided by the share of California's employment in that same sector. For each county, the LQ is calculated as the share of the county’s employment in a particular sector divided by the share of the region’s employment in that same sector.

Data is mainly pulled from aggregation level 73, which is county-level summarized at the North American Industry Classification System (NAICS) supersector level (12 sectors). This aggregation level exhibits the least loss due to data suppression, in the magnitude of 1-2 percent for regional employment, and is therefore preferred. However, the supersectors group together NAICS 11 Agriculture, Forestry, Fishing and Hunting; NAICS 21 Mining and NAICS 23 Construction. To provide a separate tally of Agriculture, Forestry, Fishing and Hunting, the aggregation level 74 data was used for NAICS codes 11, 21 and 23.

QCEW reports on employment in Public Administration as NAICS 92. However, many government activities are reported with an industry specific code - such as transportation or utilities even if those may be public governmental entities. In 2021 for the Bay Area, the largest industry groupings under public ownership are Education and health services (58%); Public administration (29%) and Trade, transportation, and utilities (29%). With the exception of Education and health services, all other public activities were coded as government/public administration, regardless of industry group.

For the county data there were some industries that reported 0 jobs or did not report jobs at the desired aggregation/NAICS level for the following counties/years:

Farm:
(aggregation level: 74, NAICS code: 11) - Contra Costa: 2008-2010 - Marin: 1990-2006, 2008-2010, 2014-2020 - Napa: 1990-2004, 2013-2021 - San Francisco: 2019-2020 - San Mateo: 2013

Information:
(aggregation level: 73, NAICS code: 51) - Solano: 2001

Financial Activities:
(aggregation level: 73, NAICS codes: 52, 53) - Solano: 2001

Unclassified:
(aggregation level: 73, NAICS code: 99) - All nine Bay Area counties: 1990-2000 - Marin, Napa, San Mateo, and Solano: 2020 - Napa: 2019 - Solano: 2001