Job Zones

Purpose:Provide a mapping of O*NET-SOC occupations to Job Zone ratings.
Table Name:job_zones
Download: mssql 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 955 rows of data in this file.

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

Data Example - job_zones:
onetsoc_​codejob_​zonedate_​updateddomain_​source
13-1022.0032015-07-01Analyst
17-2071.0042015-07-01Analyst
19-1032.0042015-07-01Analyst
27-1023.0022015-07-01Analyst
47-2082.0022015-07-01Analyst
51-9051.0022015-07-01Analyst