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,992 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 - 25.0No structure changes

Data Example - occupation_level_metadata:
onetsoc_​codeitemresponsenpercentdate_​updated
25-1043.00Data Collection ModePaper6446.92020-08-01
25-1043.00Data Collection ModeWeb6453.12020-08-01
25-1043.00Employee Completeness RateNULLNULL94.12020-08-01
25-1043.00Employee Response RateNULLNULL45.62020-08-01
25-1043.00Establishment Eligibility RateNULLNULL71.32020-08-01
25-1043.00Establishment Response RateNULLNULL77.72020-08-01
25-1043.00How Long at Current Job1-5 Years6434.42020-08-01
25-1043.00How Long at Current Job10 Years or More6456.32020-08-01
25-1043.00How Long at Current Job6-9 Years644.72020-08-01
25-1043.00How Long at Current Job<1 Year644.72020-08-01
25-1043.00How Long at Current JobMissing640.02020-08-01
25-1043.00Industry Division (Major Group Codes (SIC) within Division in parentheses)Agriculture, Forestry, Fishing (01-09)640.02020-08-01
25-1043.00Industry Division (Major Group Codes (SIC) within Division in parentheses)Construction (15-17)640.02020-08-01
25-1043.00Industry Division (Major Group Codes (SIC) within Division in parentheses)Financial, Insurance and Real Estate (60-67)640.02020-08-01
25-1043.00Industry Division (Major Group Codes (SIC) within Division in parentheses)Manufacturing (20-39)640.02020-08-01
25-1043.00Industry Division (Major Group Codes (SIC) within Division in parentheses)Mining (10-14)640.02020-08-01