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?

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.

The Green Goods and Services (GGS) program provides national and State estimates of GGS employment levels and rates by North American Industrial Classification System (NAICS) industry code and ownership. GGS employment is employment associated with producing green goods or providing green services. GGS employment level and rate estimates are also published at the State level for private, local government, State government, and federal government ownerships at the NAICS industry sector level. GGS was eliminated in 2013 as part of sequestration. For more information visit: https://www.bls.gov/ggs/

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.

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/

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/

Industry Productivity Viewer from https://data.bls.gov/apps/industry-productivity-viewer/home.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 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 Current Population Survey (CPS) is a monthly survey of households conducted by the Bureau of Census for the Bureau of Labor Statistics. It provides a comprehensive body of data on the labor force, employment, unemployment, persons not in the labor force, hours of work, earnings, and other demographic and labor force characteristics.

More information and details about the data provided can be found at http://www.bls.gov/cps

Unemployment Rate in the Northeast Census Region.

U.S. Bureau of Labor Statistics, Unemployment Rate in Northeast Census Region [CNERURN], retrieved from FRED, Federal Reserve Bank of St. Louis; https://fred.stlouisfed.org/series/CNERURN, May 11, 2021.

Gross metro product per job (2013 inflation-adjusted dollars)

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/

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 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 450 metropolitan areas and divisions. Each month, CES surveys approximately 142,000 businesses and government agencies, representing 689,000 individual worksites.

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

Industry Productivity Viewer.This spreadsheet gives yearly data on productivity. The BLS defines productivity as "how efficiently the U.S. converts inputs into the outputs of goods and services. Measures of labor productivity compare the growth in output to the growth in hours worked and measures of total factor productivity (TFP), also known as multifactor productivity (MFP), compare growth in output to the growth in a combination of inputs that include labor, capital, energy, materials, and purchased services."This spreadsheet is broken down by industry and measurements of productivity.

Employer-reported workplace injuries and illnesses, between 1994 and 2017.

Reference Layer: Bureau of Labor Statistics Monthly Unemployment (latest 14 months)_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 2022 (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: October 21, 2022Local Area Unemployment Statistics table download: https://www.bls.gov/lau/#tablesLocal Area Unemployment FTP downloads:State and CountyNationData 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 2021 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, 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.To better understand the different labor force statistics included in this map, see the diagram below from BLS:

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

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.