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 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 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 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 Quarterly Census of Employment and Wages (QCEW) program is a cooperative program involving the Bureau of Labor Statistics (BLS) of the United States Department of Labor and the State Employment Security Agencies (SESAs). The QCEW program produces a comprehensive tabulation of employment and wage information for workers covered by State unemployment insurance (UI) laws and Federal workers covered by the Unemployment Compensation for Federal Employees (UCFE) program. Publicly available data files include information on the number of establishments, monthly employment, and quarterly wages, by NAICS industry, by county, by ownership sector, for the entire United States. These data are aggregated to annual levels, to higher industry levels (NAICS industry groups, sectors, and supersectors), and to higher geographic levels (national, State, and Metropolitan Statistical Area (MSA)). To download and analyze QCEW data, users can begin on the QCEW Databases page. Downloadable data are available in formats such as text and CSV. Data for the QCEW program that are classified using the North American Industry Classification System (NAICS) are available from 1990 forward, and on a more limited basis from 1975 to 1989. These data provide employment and wage information for arts-related NAICS industries, such as: Arts, entertainment, and recreation (NAICS Code 71) Performing arts and spectator sports Museums, historical sites, zoos, and parks Amusements, gambling, and recreation Professional, scientific, and technical services (NAICS Code 54) Architectural services Graphic design services Photographic services Retail trade (NAICS Code 44-45) Sporting goods, hobby, book and music stores Book, periodical, and music stores Art dealers For years 1975-2000, data for the QCEW program provide employment and wage information for arts-related industries are based on the Standard Industrial Classification (SIC) system. These arts-related SIC industries include the following: Book stores (SIC 5942) Commercial photography (SIC Code 7335) Commercial art and graphic design (SIC Code 7336) Museums, Botanical, Zoological Gardens (SIC Code 84) Dance studios, schools, and halls (SIC Code 7911) Theatrical producers and services (SIC Code 7922) Sports clubs, managers, & promoters (SIC Code 7941) Motion Picture Services (SIC Code 78) The QCEW program serves as a near census of monthly employment and quarterly wage information by 6-digit NAICS industry at the national, state, and county levels. At the national level, the QCEW program provides employment and wage data for almost every NAICS industry. At the State and area level, the QCEW program provides employment and wage data down to the 6-digit NAICS industry level, if disclosure restrictions are met. Employment data under the QCEW program represent the number of covered workers who worked during, or received pay for, the pay period including the 12th of the month. Excluded are members of the armed forces, the self-employed, proprietors, domestic workers, unpaid family workers, and railroad workers covered by the railroad unemployment insurance system. Wages represent total compensation paid during the calendar quarter, regardless of when services were performed. Included in wages are pay for vacation and other paid leave, bonuses, stock options, tips, the cash value of meals and lodging, and in some States, contributions to deferred compensation plans (such as 401(k) plans). The QCEW program does provide partial information on agricultural industries and employees in private households. Data from the QCEW program serve as an important source for many BLS programs. The QCEW data are used as the benchmark source for employment by the Current Employment Statistics program and the Occupational Employment Statistics program. The UI administrative records collected under the QCEW program serve as a sampling frame for BLS establishment surveys. In addition, data from the QCEW program serve as a source to other Federal and State programs. The Bureau of Economic Analysis (BEA) of the Department of Commerce uses QCEW data as the base for developing the wage and salary component of personal income. The Employment and Training Administration (ETA) of the Department of Labor and the SESAs use QCEW data to administer the employment security program. The QCEW data accurately reflect the ex

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

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.

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.

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/

This dataset contains annual average CES data for California statewide and areas from 1990 to 2024.

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.

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

Context

This dataset lists the number of employees (in the thousands) of the total private industry in the United States from March 31, 1939 through August 30, 2016. Averages are taken quarterly and are seasonally adjusted.

Content

Data includes the date of the quarterly collection and the number of employees (in the thousands).

Inspiration

• Is there a general trend of employment throughout the year?
• Have certain historical events correlated with drastic changes in employment? What other datasets could you use to prove causation?
• Several other BLS datasets break down employment numbers by industry, gender, state, etc. What other employment trends can you find?

Acknowledgement

This dataset is part of the US Department of Labor Bureau of Labor Statistics Datasets (the Employment and Unemployment database), and the original source can be found here.

Graph and download economic data for Multiple Jobholders (LNS12026619) from Jan 1994 to Sep 2025 about multiple jobholders, 16 years +, household survey, employment, and USA.

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/

1990 to present (approximate 2 month lag) Virginia Labor Force and Unemployment estimates by Month by County.

Special data considerations: Period values of "M01-M12" represent Months of Year; "M13" is the Annual Average.

U.S. Bureau of Labor Statistics; Local Area Unemployment Statistics, table la.data.54.Virginia Data accessed from the Bureau of Labor Statistics public database LABSTAT (https://download.bls.gov/pub/time.series/la/)

Supporting documentation can be found on the U.S. Bureau of Labor Statistics website under Local Area Unemployment Statistics, Handbook of Methods (https://www.bls.gov/opub/hom/lau/home.htm)

Survey Description: 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.

To establish uniform labor force concepts and definitions in all States and areas consistent with those used for the U.S. as a whole, monthly national estimates of employment and unemployment from the Current Population Survey are used as controls (benchmarks) for the State labor force statistics.

Summary Data Available: Monthly labor force and unemployment series are available for approximately 7,500 geographic areas, including cities over 25,000 population, counties, metropolitan areas, States, and other areas.

For each area, the following measures are presented by place of residence:

• Total civilian labor force,
• Total number of people employed,
• Total number of people unemployed, and
• Unemployment rate

Data Characteristics: Rates are expressed as percents with one decimal place. Levels are measured as individual persons (not thousands) and are stored with no decimal places.

Graph and download economic data for Quits: Total Nonfarm (JTSQUR) from Dec 2000 to Aug 2025 about quits, nonfarm, and USA.

The National Compensation Survey (NCS) provides comprehensive measures of occupational wages; employment cost trends, and benefit incidence and detailed plan provisions. Detailed occupational earnings are available for metropolitan and non-metropolitan areas, broad geographic regions, and on a national basis. The index component of the NCS (ECI) measures changes in labor costs. Average hourly employer cost for employee compensation is presented in the ECEC.

This dataset provides employment, unemployment, labor force and unemployment rate monthly estimates for State of Iowa. Data has been adjusted to eliminate the effect of intrayear variations which tend to occur during the same period on an annual basis. Data available beginning January 2000.