Context

The Bureau of Labor Statistics (BLS) is a unit of the United States Department of Labor. It is the principal fact-finding agency for the U.S. government in the broad field of labor economics and statistics and serves as a principal agency of the U.S. Federal Statistical System. The BLS is a governmental statistical agency that collects, processes, analyzes, and disseminates essential statistical data to the American public, the U.S. Congress, other Federal agencies, State and local governments, business, and labor representatives. Source: https://en.wikipedia.org/wiki/Bureau_of_Labor_Statistics

Content

Bureau of Labor Statistics including CPI (inflation), employment, unemployment, and wage data.

Update Frequency: Monthly

Querying BigQuery Tables

Fork this kernel to get started.

Acknowledgements

https://bigquery.cloud.google.com/dataset/bigquery-public-data:bls

https://cloud.google.com/bigquery/public-data/bureau-of-labor-statistics

Dataset Source: http://www.bls.gov/data/

This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source - http://www.data.gov/privacy-policy#data_policy - and is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset.

Banner Photo by Clark Young from Unsplash.

Inspiration

What is the average annual inflation across all US Cities? What was the monthly unemployment rate (U3) in 2016? What are the top 10 hourly-waged types of work in Pittsburgh, PA for 2016?

The Occupational Outlook Handbook (OOH) is a nationally recognized source of career information, designed to provide valuable assistance to individuals making decisions about their future work lives. The Handbook is revised every two years. The OOH offers information on the hundreds of occupations that provide the majority of jobs in the United States. Each occupational profile describes the typical duties performed by the occupation, the work environment of that occupation, the typical education and training needed to enter the occupation, the median pay for workers in the occupation, and the job outlook over the coming decade for that occupation. For information on occupations, please visit: https://www.bls.gov/ooh/

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

Monthly statistics regarding the labor force, employment and unemployment in Mesa and nearby municipalities. Unemployment rate sourced at BLS.gov Data Viewer. Employment Data - Bureau of Labor Statistics - http://www.bls.gov/data/ Local Area Unemployment Statistics (LAUS) - https://www.bls.gov/lau/ (See for next data release dates). To see how these terms are defined and what they include, please visit the Terms Glossary from the United State Department of Labor’s Bureau of Labor Statistics (BLS), which can be found at the following web address: http://www.bls.gov/bls/glossary.htm

This layer contains the latest 14 months of unemployment statistics from the U.S. Bureau of Labor Statistics (BLS). The data is offered at the nationwide, state, and county geography levels. Puerto Rico is included. These are not seasonally adjusted values. The layer is updated monthly with the newest unemployment statistics available from BLS. There are attributes in the layer that specify which month is associated to each statistic. Most current month: August 2025 (preliminary values at the state and county level) The attributes included for each month are:Unemployment rate (%)Count of unemployed populationCount of employed population in the labor forceCount of people in the labor force Data obtained from the U.S. Bureau of Labor Statistics. Data downloaded: October 1, 2025Local Area Unemployment Statistics table download: https://www.bls.gov/lau/#tablesLocal Area Unemployment FTP downloads:State and CountyNation Data Notes:This layer is updated automatically when the BLS releases their most current monthly statistics. The layer always contains the most recent estimates. It is updated within days of the BLS"s county release schedule. BLS releases their county statistics roughly 2 months after-the-fact. The data is joined to 2023 TIGER boundaries from the U.S. Census Bureau.Monthly values are subject to revision over time.For national values, employed plus unemployed may not sum to total labor force due to rounding.As of the January 2022 estimates released on March 18th, 2022, BLS is reporting new data for the two new census areas in Alaska - Copper River and Chugach - and historical data for the previous census area - Valdez Cordova.As of the March 17th, 2025 release, BLS now reports data for 9 planning regions in Connecticut rather than the 8 previous counties. To better understand the different labor force statistics included in this map, see the diagram below from BLS:

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?

The Employment Projections (EP) program develops information about the labor market for the Nation as a whole for 10 years in the future. For more information visit: https://www.bls.gov/emp/

The Current Employment Statistics (CES) program produces detailed industry estimates of nonfarm employment, hours, and earnings of workers on payrolls. CES National Estimates produces data for the nation, and CES State and Metro Area produces estimates for all 50 States, the District of Columbia, Puerto Rico, the Virgin Islands, and about 450 metropolitan areas and divisions.See ces-schemas.txt for a listing of the columns and a few rows of the zipped tables.See ce.series for a summary of each the tablesSee Handbook of Methods (https://www.bls.gov/opub/hom/ces/presentation.htm) for background of the data collection and presentation.See the pdf files for screenshots of the home pages.

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 Business Employment Dynamics (BED) is a set of statistics generated from the Quarterly Census of Employment and Wages (QCEW) program. These quarterly data series consist of gross job gains and gross job losses statistics from 1992 forward. These data help to provide a picture of the dynamic state of the labor market. For more information and data visit: https://www.bls.gov/bed/

Historical information on the Employment Dataset shows several current and historical annual statistics regarding population, the labor force, employment and unemployment in the City of Mesa. Monthly labor force, employment and unemployment information is at https://citydata.mesaaz.gov/External-Data/Employment-and-Labor-Force-Monthly/3vbg-xf63.

Sources: Population Data - United States Census Bureau -https://www.census.gov/topics/population/data.html Employment Data - Bureau of Labor Statistics - http://www.bls.gov/data/ Local Area Unemployment Statistics (LAUS) - https://www.bls.gov/lau/ To see how these terms are defined and what they include, please visit the Terms Glossary from the United State Department of Labor’s Bureau of Labor Statistics (BLS), which can be found at the following web address: http://www.bls.gov/bls/glossary.htm

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

The Current Employment Statistics (CES) program produces detailed industry estimates of employment, hours, and earnings of workers on nonfarm payrolls. CES State and Metro Area produces data for all 50 States, the District of Columbia, Puerto Rico, the Virgin Islands, and about 430 metropolitan areas and divisions. CES National Estimates produces estimates for the nation.Each month, CES surveys approximately 121,000 businesses and government agencies, representing 631,000 individual worksites.See sme-schemas.txt for a listing of the columns and a few rows of each of the tables.See Handbook of Methods (https://www.bls.gov/opub/hom/sae/) for background of the data collection and presentation methodsSee the pdf files for screenshots of the home pages.

This dataset represents the CHANGE in the number of jobs per industry category and sub-category from the previous month, not the raw counts of actual jobs. The data behind these monthly change values is from the Bureau of Labor Statistics (BLS) Current Employment Statistics (CES) program. CES data represents businesses and government agencies, providing detailed industry data on employment on nonfarm payrolls.

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 Local Area Unemployment Statistics (LAUS) program is a federal-state cooperative effort which produces monthly estimates of produces monthly and annual employment, unemployment, and labor force data for approximately 7,000 areas including Census regions and divisions, States, counties, metropolitan areas, and many cities.

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

The Work Stoppages program provides monthly and annual data and analysis of major work stoppages involving 1,000 or more workers lasting one full shift or longer. The monthly and annual data show the establishment and union(s) involved in the work stoppage along with the _location, the number of workers and the days of idleness. The monthly data list all work stoppages involving 1,000 or more workers that occurred during the full calendar month for each month of the year. The annualized data provide statistics, analysis and details of each work stoppage of 1,000 or more workers that occurred during the year. The work stoppages data are gathered from public news sources, such as newspapers and the Internet. The BLS does not distinguish between strikes and lock-outs in the data; both are included in the term "work stoppages". For more information and data visit: https://www.bls.gov/wsp/

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

The Local Area Unemployment Statistics (LAUS) program is a federal-state cooperative effort in which monthly estimates of total employment and unemployment are prepared for over 7,500 areas: Census regions and divisionsStatesMetropolitan Statistical AreasMetropolitan DivisionsMicropolitan Statistical AreasCombined Metropolitan Statistical AreasSmall Labor Market AreasCounties and county equivalentsCities of 25,000 population or moreCities and towns in New England regardless of population These estimates are key indicators of local economic conditions. The Bureau of Labor Statistics (BLS) of the U.S. Department of Labor is responsible for the concepts, definitions, technical procedures, validation, and publication of the estimates that state workforce agencies prepare under agreement with BLS. A wide variety of customers use these estimates: Federal programs use the data for allocations to states and areas, as well as eligibility determinations for assistance.State and local governments use the estimates for planning and budgetary purposes and to determine the need for local employment and training services.Private industry, researchers, the media, and other individuals use the data to assess localized labor market developments and make comparisons across areas. The concepts and definitions underlying LAUS data come from the Current Population Survey (CPS), the household survey that is the source of the national unemployment rate. State monthly model-based estimates are controlled in "real time" to sum to national monthly employment and unemployment estimates from the CPS. These models combine current and historical data from the CPS, the Current Employment Statistics (CES) survey, and state unemployment insurance (UI) systems. Estimates for seven large areas and their respective balances of state also are model-based. Estimates for counties are produced through a building-block approach known as the "Handbook method." This procedure also uses data from several sources, including the CPS, the CES program, state UI systems, and the Census Bureau's American Community Survey (ACS), to create estimates that are adjusted to the statewide measures of employment and unemployment. Estimates for cities are prepared using disaggregation techniques based on inputs from the ACS, annual population estimates, and current UI data.

The American Time Use Survey (ATUS) provides nationally representative estimates of how, where, and with whom Americans spend their time, and is the only federal survey providing data on the full range of nonmarket activities, from childcare to volunteering.

For more information visit https://www.bls.gov/tus/