Graph and download economic data for Average Hourly Earnings of All Employees, Total Private (CEU0500000003) from Mar 2006 to Feb 2025 about earnings, average, establishment survey, hours, wages, private, employment, and USA.

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 Occupational Employment Statistics (OES) program conducts a semi-annual mail survey designed 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 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.

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

Graph and download economic data for Employed: Paid at prevailing federal minimum wage: Government wage and salary workers: 16 years and over (LEU0204926300A) from 2000 to 2024 about paid, minimum wage, salaries, workers, 16 years +, federal, wages, government, employment, 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.

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

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/

Graph and download economic data for Employed: Percent of hourly paid workers: Paid total at or below prevailing federal minimum wage: Government wage and salary workers: 16 years and over (LEU0204926500A) from 2000 to 2024 about paid, minimum wage, salaries, workers, hours, 16 years +, federal, wages, percent, government, employment, and USA.

The Current Employment Statistics survey, as a joint Federal-State undertaking, generates State and area, as well as national, statistics on employment, hours, and earnings.

Graph and download economic data for Employed full time: Wage and salary workers: Operations research analysts occupations: 16 years and over (LEU0254477900A) from 2000 to 2024 about analysts, operating, occupation, full-time, salaries, workers, 16 years +, wages, employment, and USA.

Graph and download economic data for Average Hourly Earnings of All Employees, Manufacturing (CES3000000003) from Mar 2006 to Feb 2025 about earnings, establishment survey, hours, wages, manufacturing, employment, and USA.

VITAL SIGNS INDICATOR Income (EC4)

FULL MEASURE NAME Household income by place of residence

LAST UPDATED May 2019

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 B19013 (2006-2017; place of residence) http://api.census.gov Bureau of Labor Statistics: Consumer Price Index All Urban Consumers Data Table (1970-2017; specific to each metro area) http://data.bls.gov

CONTACT INFORMATION vitalsigns.info@bayareametro.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.

VITAL SIGNS INDICATOR Income (EC4)

FULL MEASURE NAME Household income by place of residence

LAST UPDATED May 2019

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 B19013 (2006-2017; place of residence) http://api.census.gov

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

CONTACT INFORMATION vitalsigns.info@bayareametro.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 Employed full time: Wage and salary workers: Eligibility interviewers, government programs occupations: 16 years and over: Men (LEU0254607300A) from 2000 to 2024 about occupation, full-time, males, salaries, workers, 16 years +, wages, government, employment, and USA.

In November 2024, the average hourly earnings of all employees in the United States was at 11.25 U.S. dollars. The data have been seasonally adjusted. The deflators used for constant-dollar earnings shown here come from the Consumer Price Indexes Programs. The Consumer Price Index for All Urban Employees (CPI-U) is used to deflate the data for all employees. A comparison of the rate of wage growth versus the monthly inflation since 2020 rate can be accessed here. Real wages are wages that have been adjusted for inflation.

Graph and download economic data for Unemployment Level All Industries Government Wage & Salary Workers (LNU03028615) from Jun 1976 to Feb 2025 about salaries, workers, 16 years +, wages, household survey, government, unemployment, industry, and USA.

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: Median usual weekly real earnings: Wage and salary workers: 25 years and over: Women (LEU0252883400Q) from Q1 2000 to Q4 2024 about females, full-time, 25 years +, salaries, workers, earnings, wages, median, real, employment, and USA.