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 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 34,338 rows of data in this file.

File Structure Changes:
Release NumberDescription of Change
5.1Added as a new file
6.0 - 20.3No structure changes
21.0Items added and renamed; see Appendix 3, Key to Occupation Level Metadata
21.1 - 23.0No structure changes

Data Example - occupation_level_metadata:
onetsoc_​codeitemresponsenpercentdate_​updated
35-2014.00Data Collection ModePaper10289.22018-08-01
35-2014.00Data Collection ModeWeb10210.82018-08-01
35-2014.00Employee Completeness RateNULLNULL88.72018-08-01
35-2014.00Employee Response RateNULLNULL38.52018-08-01
35-2014.00Establishment Eligibility RateNULLNULL88.72018-08-01
35-2014.00Establishment Response RateNULLNULL39.92018-08-01
35-2014.00How Long at Current Job1-5 Years10236.32018-08-01
35-2014.00How Long at Current Job10 Years or More10240.22018-08-01
35-2014.00How Long at Current Job6-9 Years10217.62018-08-01
35-2014.00How Long at Current Job<1 Year1024.92018-08-01
35-2014.00How Long at Current JobMissing1021.02018-08-01
35-2014.00Industry Division (Major Group Codes (SIC) within Division in parentheses)Agriculture, Forestry, Fishing (01-09)1020.02018-08-01
35-2014.00Industry Division (Major Group Codes (SIC) within Division in parentheses)Construction (15-17)1020.02018-08-01
35-2014.00Industry Division (Major Group Codes (SIC) within Division in parentheses)Financial, Insurance and Real Estate (60-67)1020.02018-08-01
35-2014.00Industry Division (Major Group Codes (SIC) within Division in parentheses)Manufacturing (20-39)1020.02018-08-01
35-2014.00Industry Division (Major Group Codes (SIC) within Division in parentheses)Mining (10-14)1020.02018-08-01