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 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

Historical Employment Statistics 1990 - current. The Current Employment Statistics (CES) more information program provides the most current estimates of nonfarm employment, hours, and earnings data by industry (place of work) for the nation as a whole, all states, and most major metropolitan areas. The CES survey is a federal-state cooperative endeavor in which states develop state and sub-state data using concepts, definitions, and technical procedures prescribed by the Bureau of Labor Statistics (BLS). Estimates produced by the CES program include both full- and part-time jobs. Excluded are self-employment, as well as agricultural and domestic positions. In Connecticut, more than 4,000 employers are surveyed each month to determine the number of the jobs in the State. For more information please visit us at http://www1.ctdol.state.ct.us/lmi/ces/default.asp.

Context

This is a dataset that I built by scraping the United States Department of Labor's Bureau of Labor Statistics. I was looking for county-level unemployment data and realized that there was a data source for this, but the data set itself hadn't existed yet, so I decided to write a scraper and build it out myself.

Content

This data represents the Local Area Unemployment Statistics from 1990-2016, broken down by state and month. The data itself is pulled from this mapping site:

https://data.bls.gov/map/MapToolServlet?survey=la&map=county&seasonal=u

Further, the ever-evolving and ever-improving codebase that pulled this data is available here:

https://github.com/jayrav13/bls_local_area_unemployment

Acknowledgements

Of course, a huge shoutout to bls.gov and their open and transparent data. I've certainly been inspired to dive into US-related data recently and having this data open further enables my curiosities.

Inspiration

I was excited about building this data set out because I was pretty sure something similar didn't exist - curious to see what folks can do with it once they run with it! A curious question I had was surrounding Unemployment vs 2016 Presidential Election outcome down to the county level. A comparison can probably lead to interesting questions and discoveries such as trends in local elections that led to their most recent election outcome, etc.

Next Steps

Version 1 of this is as a massive JSON blob, normalized by year / month / state. I intend to transform this into a CSV in the future as well.

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.

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: May 2025 (preliminary values at the 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 forceData obtained from the U.S. Bureau of Labor Statistics. Data downloaded: July 18th, 2025Local Area Unemployment Statistics table download: https://www.bls.gov/lau/#tablesLocal Area Unemployment FTP downloads:State and County NationData 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:

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

Abstract

This dataset includes economic statistics on inflation, prices, unemployment, and pay & benefits provided by the Bureau of Labor Statistics (BLS)

Documentation

Update frequency: Monthly Dataset source: U.S. Bureau of Labor Statistics Terms of use: 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. See the GCP Marketplace listing for more details and sample queries: https://console.cloud.google.com/marketplace/details/bls-public-data/bureau-of-labor-statistics

Analysis of ‘BLS Jobs Data - Change from the Previous Month’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/0b021ff3-2cb3-4a10-83d8-89673850f301 on 26 January 2022.

--- Dataset description provided by original source is as follows ---

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.

--- Original source retains full ownership of the source dataset ---

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 American Time Use Survey (ATUS) is an annual survey which provides nationally representative estimates of how, where, and with whom Americans aged 15 years old and up spend their time. The data includes information collected from nearly 245,000 interviews conducted from 2003 to 2023. It is the only federal survey providing data on the full range of nonmarket activities, from childcare to volunteering. ATUS data can be used in economic research, health and safety indicators, measures of family and work-life balance, and international comparisons. ATUS data files can be linked to the Current Population Survey.

The Quarterly Census of Employment and Wages (QCEW) program provides several different types of data files. These files are available for download. Data classified using the North American Industry Classification System (NAICS) are available from 1990 forward [in this archived dataset, through 2024], and on a more limited basis from 1975 to 1989. NAICS-based data files from 1990 to 2000 were re-constructed from data classified under the Standard Industrial Classification (SIC) system. NAICS-based data files from 1975 to 1989 contain only totals by-ownership. NAICS data can be downloaded from the NAICS-Based Data Files table below.Data classified using the Standard Industrial Classification (SIC) system is available from 1975 through 2000. SIC data can be downloaded from the second table below titled SIC-Based Data Files.

This dataset from the Bureau of Labor Statistics provides monthly estimates regarding total employment and unemployment, which together comprise the labor force. The unemployment rate is the percentage of people in the labor force who are unemployed. Our data extract lists all data published for North Carolina’s counties from January 2019 to the present. This dataset is a comprehensive nationwide representation using estimates derived from the national Current Population Survey (CPS) and American Community Survey 5-year estimates. No disaggregations by demographic or worker characteristics are included in the unemployment rate estimate. Time series reports for each variable (employment, unemployment, and labor force) are available for each geography (county) using the BLS multi-screen data tool. Preliminary estimates are released within 30 days of each month and finalized within another 30 days, resulting in a 2-month data lag. The data is available for a variety of geographic areas, including states, MSAs, counties, cities and towns, and other census regions.

DO NOT EDIT THIS DATASET. This dataset, which is automatically updated contains Bureau of Labor Statistics data. This dataset is updated by a Socrata process; please contact support@socrata.com if you encounter any questions or issues.

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/

Analysis of ‘BLS Jobs by Industry Category’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/ce915016-6e4a-4598-85c8-6c616a136b50 on 27 January 2022.

--- Dataset description provided by original source is as follows ---

Data 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.

--- Original source retains full ownership of the source dataset ---

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.

Labor force and unemployment estimates for States and local areas are developed by State workforce agencies to measure local labor market conditions under a Federal-State cooperative program. The Department of Labor develops the concepts, definitions, and technical procedures which are used by State agencies for preparation of labor force and unemployment estimates.

These estimates are derived from a variety of sources, including the Current Population Survey, the Current Employment Statistics survey, the Quarterly Census of Employment and Wages, various programs at the Census Bureau, and unemployment insurance claims data from the State workforce agencies.

The Current Employment Statistics (CES) program is a Federal-State cooperative effort in which monthly surveys are conducted to provide estimates of employment, hours, and earnings based on payroll records of business establishments. The CES survey is based on approximately 119,000 businesses and government agencies representing approximately 629,000 individual worksites throughout the United States.

CES data reflect the number of nonfarm, payroll jobs. It includes the total number of persons on establishment payrolls, employed full- or part-time, who received pay (whether they worked or not) for any part of the pay period that includes the 12th day of the month. Temporary and intermittent employees are included, as are any employees who are on paid sick leave or on paid holiday. Persons on the payroll of more than one establishment are counted in each establishment. CES data excludes proprietors, self-employed, unpaid family or volunteer workers, farm workers, and household workers. Government employment covers only civilian employees; it excludes uniformed members of the armed services.

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.

The Job Openings and Labor Turnover Survey (JOLTS) program provides national estimates of rates and levels for job openings, hires, and total separations. Total separations are further broken out into quits, layoffs and discharges, and other separations. Unadjusted counts and rates of all data elements are published by supersector and select sector based on the North American Industry Classification System (NAICS). The number of unfilled jobs—used to calculate the job openings rate—is an important measure of the unmet demand for labor. With that statistic, it is possible to paint a more complete picture of the U.S. labor market than by looking solely at the unemployment rate, a measure of the excess supply of labor. Information on labor turnover is valuable in the proper analysis and interpretation of labor market developments and as a complement to the unemployment rate. For more information and data visit: https://www.bls.gov/jlt/