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 Coverage	United 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 Granularity	Employment: Monthly, Annual Prices: Monthly, Semi-Annual, Annual
Release Frequency	Each timeseries is subject to its own release calendar available on the BLS website
History	Employment: January 31, 1939 Prices: January 13, 1913

As with all Public Domain datasets, Cybersyn aims to release data on Snowflake Marketplace as soon as the underlying source releases new data. We check periodically for changes to the underlying source and, upon detecting a change, propagate the data to Snowflake Marketplace immediately. See our release process for more details.

Notes

EAV Model: All Cybersyn products follow the EAV (entity, attributes, value) model with a unified schema. Entities are tangible objects (e.g. geography, company) that Cybersyn provides data on. All timeseries' dates and values that refer to the entity are included in a timeseries table. Descriptors of the timeseries are included in an attributes table. Data is joinable across all Cybersyn products that have a GEO_ID. Refer to Cybersyn Concepts for more details.

Restatements: Timeseries tables, by default, contain the latest published version of all releases. In the future, we will maintain point-in-time pre-restatement values.

Tables & Sources

Tables	Source(s)
BUREAU_OF_LABOR_STATISTICS_EMPLOYMENT_ATTRIBUTES BUREAU_OF_LABOR_STATISTICS_EMPLOYMENT_TIMESERIES BUREAU_OF_LABOR_STATISTICS_PRICE_ATTRIBUTES BUREAU_OF_LABOR_STATISTICS_PRICE_TIMESERIES	bls.gov

Cybersyn Products

Tables above are available in the following Cybersyn data products:

• Financial & Economic Essentials

• Enterprise

Examples & 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;

Compare the trends of NYC metro area employment by industry

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 [e-mail] for questions.