Career Changers Matrix

Purpose:Provide related occupation links between O*NET-SOC occupations.
Table Name:career_changers_matrix
Download: 31_career_changers_matrix.sql
Structure and Description:
ColumnTypeColumn Content
onetsoc_codeCharacter(10)O*NET-SOC Code (see Occupation Data)
related_onetsoc_codeCharacter(10)Related O*NET-SOC code mapping (see Occupation Data)
related_indexDecimal(3,0)Order of related code mappings

For each O*NET-SOC code included, up to 10 related O*NET-SOC codes are listed. The related occupations in this file make use of similar skills and experience; workers from one occupation may transfer to a job in a related occupation with minimal additional preparation.

The file is displayed in three tab delimited fields with the columns named O*NET-SOC Code, Related O*NET-SOC Code, and Index. The three fields are represented by one row. There are a total of 8,348 rows of data in this file.

File Structure Changes:
Release NumberDescription of Change
20.1Added as a new file

Data Example - career_changers_matrix:
onetsoc_​coderelated_​onetsoc_​coderelated_​index
11-1011.0011-9111.001
11-1011.0011-2022.002
11-1011.0011-3031.013
11-1011.0023-1011.004