Skip to main content

Bureau of Labor Statistics (BLS)

Overview

The US Bureau of Labor Statistics (BLS) publishes the Consumer Price Index (CPI), Average Prices (AP), Job Openings and Labor Turnover Survey (JOLTS), State and Metro Area Employment, Hours, & Earnings (SAE), and Local Area Unemployment Statistics (LAUS) reports.

Topics covered:

  • Local Area Unemployment Statistics (LAUS) provides monthly and annual employment, unemployment, and labor force data for states and localities
  • Job Openings and Labor Turnover Survey (JOLTS) offers insights into labor demand and turnover rates, including data on job openings, hires, and separations
  • State and Metro Employment (SAE) delivers employment and wage data across various industries at state and metropolitan levels
  • Average Prices (AP) includes average prices of selected items (e.g. bread, eggs, electricity)
  • Consumer Price Index (CPI) is s a measure of the average change over time in the prices paid by urban consumers for a market basket of consumer goods and service
  • Employment Situation Summary (non-farm payroll)

Key Attributes

Geographic CoverageUnited States
Entity Level

Employment: Census Core Based Statistical Area (CBSA), City, County, Census Metropolitan Division, State, Country

Prices: Census Core Based Statistical Area (CBSA), Country

Time GranularityEmployment: Monthly, Annual
Prices: Monthly, Semi-Annual, Annual
Release FrequencyEach timeseries is subject to its own release calendar available on the BLS website
HistoryEmployment: January 31, 1939
Prices: January 13, 1913

Cybersyn Products

Tables above are available in the following Cybersyn data products:

Sample Queries

Average price paid for a typical basket of goods purchased at a convenience store

Create a time series of the average price paid for bananas, soft drinks, and ice cream nationwide starting in 2021.

SELECT ts.date,
att.variable_name,
ts.value
FROM cybersyn.bureau_of_labor_statistics_price_timeseries AS ts
JOIN cybersyn.bureau_of_labor_statistics_price_attributes AS att
ON (ts.variable = att.variable)
WHERE ts.date >= '2021-01-01'
AND att.report = 'Average Price'
AND (att.product ILIKE 'Ice cream%' OR
att.product ILIKE 'Bananas%' OR
att.product ILIKE 'All soft drinks, per 2 liters%')
ORDER BY date;

Track the total count of employees in the finance industry in New York over time. Observe trends from the dot-com bubble, global financial crisis, and Covid-19 pandemic.

SELECT geo.geo_name,
att.variable_name,
ts.date, ts.value
FROM cybersyn.bureau_of_labor_statistics_employment_timeseries AS ts
JOIN cybersyn.bureau_of_labor_statistics_employment_attributes AS att
ON (ts.variable = att.variable)
JOIN cybersyn.geography_index AS geo
ON (ts.geo_id = geo.geo_id)
WHERE att.report = 'State and Metro Employment'
AND att.industry = 'Financial Activities'
AND att.measure = 'All Employees'
AND att.frequency = 'Monthly'
AND att.seasonally_adjusted = FALSE
AND geo.geo_name ILIKE '%New York-Newark-Jersey City%'
ORDER BY date;

Disclaimers

The data in this product is sourced from Bureau of Labor Statistics (BLS).

Cybersyn is not endorsed by or affiliated with any of these providers. Contact support@cybersyn.com for questions.