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?

Graph and download economic data for All Employees, Manufacturing (MANEMP) from Jan 1939 to Jul 2025 about headline figure, establishment survey, employment, manufacturing, and USA.

Graph and download economic data for Total wages and salaries, BLS: Adjustment for wages and salaries not covered or not fully covered by unemployment insurance (W873RC1A027NBEA) from 1982 to 2023 about covered, adjusted, insurance, salaries, wages, unemployment, GDP, and USA.

This dataset from the Bureau of Labor Statistics provides monthly estimates regarding total employment and unemployment, which together comprise the labor force. 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 labor force 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 from BLS for a variety of geographic areas, including states, MSAs, counties, cities and towns, and other census regions.

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.

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.

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.

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

United States Employment: NF: Over-the-Month Change: Revision: 3rd-1st data was reported at -42.000 Person th in Feb 2025. This records a decrease from the previous number of 24.000 Person th for Jan 2025. United States Employment: NF: Over-the-Month Change: Revision: 3rd-1st data is updated monthly, averaging 8.000 Person th from Jan 1979 (Median) to Feb 2025, with 552 observations. The data reached an all-time high of 839.000 Person th in Mar 1996 and a record low of -752.000 Person th in Mar 2020. United States Employment: NF: Over-the-Month Change: Revision: 3rd-1st 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: Employment: Non Farm Payroll.

The employment and unemployment indicator shows several data points. The first figure is the number of people in the labor force, which includes the number of people who are either working or looking for work. The second two figures, the number of people who are employed and the number of people who are unemployed, are the two subcategories of the labor force. The unemployment rate is a calculation of the number of people who are in the labor force and unemployed as a percentage of the total number of people in the labor force.

The unemployment rate does not include people who are not employed and not in the labor force. This includes adults who are neither working nor looking for work. For example, full-time students may choose not to seek any employment during their college career, and are thus not considered in the unemployment rate. Stay-at-home parents and other caregivers are also considered outside of the labor force, and therefore outside the scope of the unemployment rate.

The unemployment rate is a key economic indicator, and is illustrative of economic conditions in the county at the individual scale.

There are additional considerations to the unemployment rate. Because it does not count those who are outside the labor force, it can exclude individuals who were looking for a job previously, but have since given up. The impact of this on the overall unemployment rate is difficult to quantify, but it is important to note because it shows that no statistic is perfect.

The unemployment rates for Champaign County, the City of Champaign, and the City of Urbana are extremely similar between 2000 and 2023.

All three areas saw a dramatic increase in the unemployment rate between 2006 and 2009. The unemployment rates for all three areas decreased overall between 2010 and 2019. However, the unemployment rate in all three areas rose sharply in 2020 due to the effects of the COVID-19 pandemic. The unemployment rate in all three areas dropped again in 2021 as pandemic restrictions were removed, and were almost back to 2019 rates in 2022. However, the unemployment rate in all three areas rose slightly from 2022 to 2023.

This data is sourced from the Illinois Department of Employment Security’s Local Area Unemployment Statistics (LAUS), and from the U.S. Bureau of Labor Statistics.

Sources: Illinois Department of Employment Security, Local Area Unemployment Statistics (LAUS); U.S. Bureau of Labor Statistics.

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

Bureau of Labor Statistics Pacific Rim - U.S. Exports of Goods by F.A.S. Basis to Pacific Rim was 38482.73795 Mil. of $ in May of 2025, according to the United States Federal Reserve. Historically, Bureau of Labor Statistics Pacific Rim - U.S. Exports of Goods by F.A.S. Basis to Pacific Rim reached a record high of 45355.42184 in October of 2023 and a record low of 9402.70000 in January of 1992. Trading Economics provides the current actual value, an historical data chart and related indicators for Bureau of Labor Statistics Pacific Rim - U.S. Exports of Goods by F.A.S. Basis to Pacific Rim - last updated from the United States Federal Reserve on July of 2025.

Bureau of Labor Statistics Industrialized Countries - Import Price Index: Other electrical equipment and component manufacturing for Industrialized Countries was 140.50000 Index 2010=100 in December of 2019, according to the United States Federal Reserve. Historically, Bureau of Labor Statistics Industrialized Countries - Import Price Index: Other electrical equipment and component manufacturing for Industrialized Countries reached a record high of 140.50000 in December of 2019 and a record low of 92.60000 in January of 2017. Trading Economics provides the current actual value, an historical data chart and related indicators for Bureau of Labor Statistics Industrialized Countries - Import Price Index: Other electrical equipment and component manufacturing for Industrialized Countries - last updated from the United States Federal Reserve on July of 2025.

United States AHE: sa: PW: OS: Computer & Office Machine Repair data was reported at 27.100 USD in Nov 2022. This records an increase from the previous number of 26.940 USD for Oct 2022. United States AHE: sa: PW: OS: Computer & Office Machine Repair data is updated monthly, averaging 16.620 USD from Jan 1990 (Median) to Nov 2022, with 395 observations. The data reached an all-time high of 27.690 USD in Jan 2022 and a record low of 12.090 USD in Jan 1990. United States AHE: sa: PW: OS: Computer & Office Machine Repair 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.G076: Current Employment Statistics: Average Hourly Earnings: Production Workers: Seasonally Adjusted.

Bureau of Labor Statistics Industrialized Countries - Import Price Index: Sawmills and wood preservation for Industrialized Countries was 188.70000 Index 2010=100 in December of 2020, according to the United States Federal Reserve. Historically, Bureau of Labor Statistics Industrialized Countries - Import Price Index: Sawmills and wood preservation for Industrialized Countries reached a record high of 263.30000 in September of 2020 and a record low of 83.00000 in October of 2015. Trading Economics provides the current actual value, an historical data chart and related indicators for Bureau of Labor Statistics Industrialized Countries - Import Price Index: Sawmills and wood preservation for Industrialized Countries - last updated from the United States Federal Reserve on July of 2025.

Bureau of Labor Statistics Industrialized Countries - Import Price Index by Origin (NAICS): Electrical Equipment, Appliance, and Component Manufacturing for Industrialized Countries was 127.40000 Index 2010=100 in May of 2025, according to the United States Federal Reserve. Historically, Bureau of Labor Statistics Industrialized Countries - Import Price Index by Origin (NAICS): Electrical Equipment, Appliance, and Component Manufacturing for Industrialized Countries reached a record high of 127.40000 in May of 2025 and a record low of 94.60000 in August of 2016. Trading Economics provides the current actual value, an historical data chart and related indicators for Bureau of Labor Statistics Industrialized Countries - Import Price Index by Origin (NAICS): Electrical Equipment, Appliance, and Component Manufacturing for Industrialized Countries - last updated from the United States Federal Reserve on July of 2025.

These market data provide a comprehensive set of measures of changes in economic activity throughout the coastal regions of the United States. In regard to the sources of data, establishments, employment, and wages are taken from the Quarterly Census of Employment and Wages (QCEW). The data series also is known as the ES-202 data. These data are based on the quarterly reports of nearly all employers in the United States. These reports are filed with each state's employment or labor department, and each state then transmits the data to the Bureau of Labor Statistics (BLS), where the national databases are maintained. The data for the Coastal Economies have been taken from the national databases at BLS (except in the case of Massachusetts). Gross State Product (GSP) data are taken from the Bureau of Economic Analysis (BEA), which develops the estimates of GSP from a number of sources. In regard to "employment", data are reported by employers, not employees, and does not contain any information about age. There is no difference between "employed" and "employment". The source is known as the payroll survey, a survey filed by employers every 3 months showing the number of people employed at each establishment in each of the preceding 3 months. Detailed information on the geographies the data are available for can be found here: https://coast.noaa.gov/htdata/SocioEconomic/CoastalEconomy/CoastalEconomy_DataDescription.pdf

United States AHE: sa: PW: WT: DG: Lumber & Wood data was reported at 27.980 USD in Mar 2025. This records an increase from the previous number of 27.970 USD for Feb 2025. United States AHE: sa: PW: WT: DG: Lumber & Wood data is updated monthly, averaging 17.840 USD from Jan 1990 (Median) to Mar 2025, with 423 observations. The data reached an all-time high of 28.260 USD in Jan 2025 and a record low of 9.860 USD in Jan 1990. United States AHE: sa: PW: WT: DG: Lumber & Wood 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.

United States Agg Weekly Hours Index: sa: PW: Financial Activities data was reported at 116.600 2002=100 in Nov 2018. This records a decrease from the previous number of 116.700 2002=100 for Oct 2018. United States Agg Weekly Hours Index: sa: PW: Financial Activities data is updated monthly, averaging 82.900 2002=100 from Jan 1964 (Median) to Nov 2018, with 659 observations. The data reached an all-time high of 116.700 2002=100 in Oct 2018 and a record low of 41.400 2002=100 in Jan 1964. United States Agg Weekly Hours Index: sa: PW: Financial Activities data remains active status in CEIC and is reported by Bureau of Labor Statistics. The data is categorized under Global Database’s United States – Table US.G036: Current Employment Statistics Survey: Aggregate Weekly Payroll and Hours Index: Production Workers.

United States Employment: NF: sa: EH: Office of Mental Health Practitioner data was reported at 94.100 Person th in May 2018. This records an increase from the previous number of 93.700 Person th for Apr 2018. United States Employment: NF: sa: EH: Office of Mental Health Practitioner data is updated monthly, averaging 54.400 Person th from Jan 1990 (Median) to May 2018, with 341 observations. The data reached an all-time high of 94.100 Person th in May 2018 and a record low of 24.100 Person th in Jan 1990. United States Employment: NF: sa: EH: Office of Mental Health Practitioner data remains active status in CEIC and is reported by Bureau of Labor Statistics. The data is categorized under Global Database’s USA – Table US.G026: Current Employment Statistics Survey: Employment: Non Farm: sa.