Interests

Purpose:Provide general occupational interest (RIASEC) high-point codes and numeric profile data for each O*NET-SOC occupation.
Table Name:interests
Download: 13_interests.sql
Structure and Description:
ColumnTypeColumn Content
onetsoc_codeCharacter(10)O*NET-SOC Code (see Occupation Data)
element_idCharacter Varying(20)Content Model Outline Position (see Content Model Reference)
scale_idCharacter Varying(3)Scale ID (see Scales Reference)
data_valueDecimal(5,2)Rating associated with the O*NET-SOC occupation

This file contains the general occupational interest (RIASEC) high-point codes and numeric profile data for each O*NET-SOC occupation.

Interest ratings are presented as two scales: OI reports the RIASEC level of each interest and IH presents “high-point codes”, the numbers of the RIASEC scales for the first, second and/or third highest ratings.

The high-point values represent the following elements:

 0.00 = No high point available 
 1.00 = Realistic 
 2.00 = Investigative 
 3.00 = Artistic 
 4.00 = Social 
 5.00 = Enterprising 
 6.00 = Conventional 

The file is displayed in six tab delimited fields with the columns named O*NET-SOC Code, Element ID, Scale ID, Data Value, Date, and Domain Source. The six fields are represented by one row. There are a total of 8,307 rows of data in this file.

For more information, see:

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

Data Example - interests:
onetsoc_​codeelement_​idscale_​iddata_​valuedate_​updateddomain_​source
43-4041.001.B.1.aOI1.002023-11-01Machine Learning
43-4041.001.B.1.bOI1.852023-11-01Machine Learning
43-4041.001.B.1.cOI1.002023-11-01Machine Learning
43-4041.001.B.1.dOI3.392023-11-01Machine Learning
43-4041.001.B.1.eOI4.472023-11-01Machine Learning
43-4041.001.B.1.fOI7.002023-11-01Machine Learning
43-4041.001.B.1.gIH6.002023-11-01Machine Learning
43-4041.001.B.1.hIH5.002023-11-01Machine Learning
43-4041.001.B.1.iIH4.002023-11-01Machine Learning
29-2034.001.B.1.aOI6.252023-11-01Machine Learning
29-2034.001.B.1.bOI4.632023-11-01Machine Learning
29-2034.001.B.1.cOI1.002023-11-01Machine Learning
29-2034.001.B.1.dOI3.582023-11-01Machine Learning
29-2034.001.B.1.eOI1.002023-11-01Machine Learning
29-2034.001.B.1.fOI4.872023-11-01Machine Learning
29-2034.001.B.1.gIH1.002023-11-01Machine Learning
29-2034.001.B.1.hIH6.002023-11-01Machine Learning
29-2034.001.B.1.iIH2.002023-11-01Machine Learning