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?

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:

Unemployment Rate in the United States increased to 4.20 percent in July from 4.10 percent in June of 2025. This dataset provides the latest reported value for - United States Unemployment Rate - plus previous releases, historical high and low, short-term forecast and long-term prediction, economic calendar, survey consensus and news.

In 2023, it was estimated that over 161 million Americans were in some form of employment, while 3.64 percent of the total workforce was unemployed. This was the lowest unemployment rate since the 1950s, although these figures are expected to rise in 2023 and beyond. 1980s-2010s Since the 1980s, the total United States labor force has generally risen as the population has grown, however, the annual average unemployment rate has fluctuated significantly, usually increasing in times of crisis, before falling more slowly during periods of recovery and economic stability. For example, unemployment peaked at 9.7 percent during the early 1980s recession, which was largely caused by the ripple effects of the Iranian Revolution on global oil prices and inflation. Other notable spikes came during the early 1990s; again, largely due to inflation caused by another oil shock, and during the early 2000s recession. The Great Recession then saw the U.S. unemployment rate soar to 9.6 percent, following the collapse of the U.S. housing market and its impact on the banking sector, and it was not until 2016 that unemployment returned to pre-recession levels. 2020s 2019 had marked a decade-long low in unemployment, before the economic impact of the Covid-19 pandemic saw the sharpest year-on-year increase in unemployment since the Great Depression, and the total number of workers fell by almost 10 million people. Despite the continuation of the pandemic in the years that followed, alongside the associated supply-chain issues and onset of the inflation crisis, unemployment reached just 3.67 percent in 2022 - current projections are for this figure to rise in 2023 and the years that follow, although these forecasts are subject to change if recent years are anything to go by.

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.

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

Graph and download economic data for Multiple Jobholders as a Percent of Employed (LNS12026620) from Jan 1994 to Aug 2025 about multiple jobholders, percent, 16 years +, household survey, employment, and USA.

This dataset contains annual average CES data for California statewide and areas from 1990 to 2023. 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.

In June 2025, the civilian labor force amounted to 170.38 million people in the United States. The term civilian labor force is used by the U.S. Bureau of Labor Statistics (BLS) to describe the subset of Americans who have jobs or are seeking a job, are at least 16 years old, are not serving in the military, and are not institutionalized.

Graph and download economic data for Infra-Annual Labor Statistics: Labor Force Total: From 15 to 64 Years for United States (LFAC64TTUSQ647S) from Q1 1970 to Q2 2025 about 15 to 64 years, labor force, labor, and USA.

Graph and download economic data for All Employees, Federal (CES9091000001) from Jan 1939 to Aug 2025 about establishment survey, federal, government, employment, and USA.

This dataset uses seasonally adjusted data from the US Bureau of Labor Statistics to present information on Maryland's labor force participation rate, employment rate, and unemployment rate.

In 2024, the U.S. employment rate stood at 60.1 percent. Employed persons consist of: persons who did any work for pay or profit during the survey reference week; persons who did at least 15 hours of unpaid work in a family-operated enterprise; and persons who were temporarily absent from their regular jobs because of illness, vacation, bad weather, industrial dispute, or various personal reasons. The employment-population ratio represents the proportion of the civilian non-institutional population that is employed. The monthly unemployment rate for the United States can be found here.

Key information about United States Employed Persons

• United States Employed Persons was reported at 163,307,000.000 Person in Feb 2025
• It recorded a decrease from the previous number of 163,895,000.000 Person for Jan 2025
• US Employed Persons data is updated monthly, averaging 109,912,500.000 Person from Jan 1948 to Feb 2025, with 926 observations
• The data reached an all-time high of 163,895,000.000 Person in Jan 2025 and a record low of 57,172,000.000 Person in Jun 1949
• US Employed Persons data remains active status in CEIC and is reported by CEIC Data
• The data is categorized under World Trend Plus’s Global Economic Monitor – Table: Employed Persons: Monthly: Seasonally Adjusted

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 approximately 7,600 areas, including counties, cities and metropolitan statistical areas. 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.

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.

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.

AHE: sa: PW: FA: Consumer Lending data was reported at 28.890 USD in Mar 2025. This records an increase from the previous number of 28.730 USD for Feb 2025. AHE: sa: PW: FA: Consumer Lending data is updated monthly, averaging 13.320 USD from Jan 1990 (Median) to Mar 2025, with 423 observations. The data reached an all-time high of 28.890 USD in Mar 2025 and a record low of 8.580 USD in Feb 1990. AHE: sa: PW: FA: Consumer Lending data remains active status in CEIC and is reported by U.S. Bureau of Labor Statistics. The data is categorized under Global Database’s United States – Table US.G: Current Employment Statistics: Average Hourly Earnings: Production Workers: Seasonally Adjusted.

Job Openings and Labor Turnover Survey data from the U.S. Bureau of Labor Statistics

AHE: sa: PW: EH: Child & Youth Services data was reported at 24.850 USD in Mar 2025. This records an increase from the previous number of 24.750 USD for Feb 2025. AHE: sa: PW: EH: Child & Youth Services data is updated monthly, averaging 15.010 USD from Jan 1990 (Median) to Mar 2025, with 423 observations. The data reached an all-time high of 24.850 USD in Mar 2025 and a record low of 8.520 USD in Jan 1990. AHE: sa: PW: EH: Child & Youth Services data remains active status in CEIC and is reported by U.S. Bureau of Labor Statistics. The data is categorized under Global Database’s United States – Table US.G: Current Employment Statistics: Average Hourly Earnings: Production Workers: Seasonally Adjusted.

In 2024, the employment rate of the workforce of 55 years and older decreased to 37.3 percent. Employment rate among young adults (age 16-24) was at 50.9 percent in 2024. For monthly updates on employment in the United States visit the annual national employment rate here.