Occupation Level Metadata

Purpose:Provide O*NET-SOC Occupational Level Metadata associated with the incumbent data collection.
Table Name:occupation_level_metadata
Download: 07_occupation_level_metadata.sql
Structure and Description:
ColumnTypeColumn Content
onetsoc_codeCharacter(10)O*NET-SOC Code (see Occupation Data)
itemCharacter Varying(150)Occupation level statistics
responseCharacter Varying(75)Type of response
nDecimal(4,0)Sample size for occupation
percentDecimal(4,1)Percentage of responses
date_updatedDateDate when data was updated

This file contains occupational level metadata variables associated with data collection statistics. Refer to Appendix 3, Key to Incumbent Occupation Level Metadata for additional descriptions of the data provided in this file.

The file is displayed in six tab delimited fields with the columns named O*NET-SOC Code, Item, Response, N, Percent, and Date. The six fields are represented by one row. There are a total of 36,381 rows of data in this file.

File Structure Changes:
Release NumberDescription of Change
5.1Added as a new file
6.0 - 20.1No structure changes

Data Example - occupation_level_metadata:
onetsoc_​codeitemresponsenpercentdate_​updated
17-2071.00Data Collection ModePaper14952.32015-07-01
17-2071.00Data Collection ModeWeb14947.72015-07-01
17-2071.00How Long at Current Job1-5 Years14936.92015-07-01
17-2071.00How Long at Current Job10 Years or More14944.32015-07-01
17-2071.00How Long at Current Job6-9 Years14910.72015-07-01
17-2071.00How Long at Current Job<1 Year1497.42015-07-01
17-2071.00How Long at Current JobMissing1490.72015-07-01
17-2071.00Industry Division (Major Group Codes (SIC) within Division in parentheses)Agriculture, Forestry, Fishing (01-09)1490.02015-07-01
17-2071.00Industry Division (Major Group Codes (SIC) within Division in parentheses)Construction (15-17)1490.02015-07-01
17-2071.00Industry Division (Major Group Codes (SIC) within Division in parentheses)Financial, Insurance and Real Estate (60-67)1490.02015-07-01
17-2071.00Industry Division (Major Group Codes (SIC) within Division in parentheses)Manufacturing (20-39)14977.22015-07-01
17-2071.00Industry Division (Major Group Codes (SIC) within Division in parentheses)Mining (10-14)1490.02015-07-01
17-2071.00Industry Division (Major Group Codes (SIC) within Division in parentheses)Non-Classifiable (99)1490.02015-07-01
17-2071.00Industry Division (Major Group Codes (SIC) within Division in parentheses)Public Administration (90-97)1490.02015-07-01
17-2071.00Industry Division (Major Group Codes (SIC) within Division in parentheses)Retail Trade (52-59)1490.02015-07-01
17-2071.00Industry Division (Major Group Codes (SIC) within Division in parentheses)Services (70-89)14915.42015-07-01