Job Zones

Purpose:Provide a mapping of O*NET-SOC occupations to Job Zone ratings.
Table Name:job_zones
Download: 14_job_zones.sql
Structure and Description:
ColumnTypeColumn Content
onetsoc_codeCharacter(10)O*NET-SOC Code (see Occupation Data)
job_zoneDecimal(1,0)Job Zone number (see Job Zone Reference)

This file contains each O*NET-SOC code and its corresponding Job Zone number.

The file is displayed in four tab delimited fields with the columns named O*NET-SOC Code, Job Zone, Date, and Domain Source. The four fields are represented by one row. There are a total of 874 rows of data in this file.

For more information, see:

File Structure Changes:
Release NumberDescription of Change
5.0No structure changes
5.1Date and Domain Source columns added
6.0 - 25.2No structure changes

Data Example - job_zones:
onetsoc_​codejob_​zonedate_​updateddomain_​source
19-4043.0042020-11-01Analyst - Transition
11-3031.0042020-11-01Analyst - Transition
53-5021.0032020-11-01Analyst - Transition
25-4022.0052020-11-01Analyst - Transition
53-6051.0042020-11-01Analyst - Transition
53-4022.0022020-11-01Analyst - Transition