JOLTS

The Bureau of Labor Statistics’ Job Openings and Labor Turnover Survey (JOLTS) program produces data on job openings, hires, and separations. Although the content is non-standard and does not have a formal WID table, there has been a recent surge in interest in the data.

Data Sources

 Geographic ExtentNotes
BLSState, BLS Region, U.S.The JOLTS program recently added State estimates. The publication schedule lags by two months.
WID Version?CustomThis is a non-standard table structure and state uses vary. Instead of a download file, there is a python script to extract the data from the BLS LABSTAT database and format it to load into the WID. The script contains parameters to define years and areas for extraction allowing users to pull the most current BLS data as needed.

Table Format

This is non-standard content but has been structured to work seamlessly with the WID.

Table Structure

Update Calendar

BLS Schedule of Releases for JOLTS

Related Tables

The structure of related tables and the SQL are in the same files under Table Format above.

While JOLTS closely follows CES industries, it’s not perfectly aligned. The script above creates a new industry type to be added to the indcodes table, and one other lookup table (values in above documentation) is used to describe the components.