O*NET® 23.1 Database

The O*NET database contains a rich set of variables that describe work and worker characteristics, including skill requirements. Developers and other customers are encouraged to incorporate the O*NET database within their products, services, and research. This section contains an overview of the most recent database and a variety of database download options, as well as format-specific data dictionaries.

Highlights of the O*NET 23.1 Database

The 23.1 release includes the following:

  • 946 technology skills related to 197 occupations were updated from employer job postings. Currently, 192 “hot technologies” are identified.
  • 191 alternate titles related to 100 occupations were added from employer job postings and other sources.

In the 23.0 database, 100 occupations were updated by job incumbents and occupational experts, bringing the total to 968.

  • Addition and update of Task Statement ratings (importance, relevance, and frequency) for 100 occupations
  • Addition and update of Abilities, Skills, Work Activities, Knowledge, and Work Context data for 100 occupations
  • Addition and update of Training and Work Experience and Education data for 100 occupations
  • Addition and update of Work Styles data for 100 occupations
  • Addition and update of Job Zones data for 100 occupations
  • Addition and update of Detailed Work Activities (DWAs) and linkages for 33 occupations
  • Addition and update of Alternate Titles and Sample of Reported Titles for 294 occupations

The O*NET Database: A Primary Source of Occupational Information

The O*NET database has a wide variety of worker and job oriented data categories. The O*NET Content Model provides the framework that identifies and organizes this important information about work. The O*NET-SOC Occupation Taxonomy covers work performed in the U.S. economy and defines the set of occupations for which data is collected.

The O*NET Data Collection Program currently makes updates to the O*NET Database on a quarterly basis, with a primary update occurring in the 3rd quarter of each year. Listings showing data updates by category or occupation are available on the Occupation Update Summary page. See Data Publication Schedule for a listing of primary updates and collection history. Past releases of the O*NET Database are available on the Database Releases Archive page.

Science Behind the O*NET Database

We have published several reports to explain the research and procedures involved in developing the O*NET Database. To learn more, visit these sections in our Reports and Documents area:

Share or Adapt the O*NET Database

Creative Commons licensed
The O*NET 23.1 Database is available under a Creative Commons license. See the Database license page for more information.

The O*NET database is provided in five formats:

  • Microsoft Excel (XLSX)
  • Tab-delimited text files
  • SQL files for MySQL, PostgreSQL, or compatible relational databases
  • SQL files for Microsoft SQL Server
  • SQL files for Oracle Database

Previous releases of the database are available at the Database Releases Archive.

Creative Commons licensed
The O*NET 23.1 Database is available under a Creative Commons license. See the Database license page for more information.

All Files

O*NET 23.1 Database

Download all 36 files in the O*NET core database, in one convenient ZIP archive.

Data Dictionary

Read the comprehensive documentation for the O*NET 23.1 Database online.

Individual File Documentation

Creative Commons licensed
The O*NET 23.1 Database is available under a Creative Commons license. See the Database license page for more information.

Knowledge, Skills, Abilities

Knowledge

This file contains the Content Model Knowledge data associated with each O*NET-SOC occupation. Read more...

Skills

This file contains the Content Model Skill data associated with each O*NET-SOC occupation. Read more...

Abilities

This file contains the Content Model Ability data associated with each O*NET-SOC occupation. Read more...

Education, Experience, Training

Education, Training, and Experience

This file contains the percent frequency data associated with Education, Training, and Experience Content Model elements. Read more...

Education, Training, and Experience Categories

This file contains the categories associated with the Education, Training, and Experience content area. Read more...

Job Zones

This file contains each O*NET-SOC code and its corresponding Job Zone number. Read more...

Job Zone Reference

This file describes the five O*NET Job Zones, which are groups of occupations that need the same level of experience, education, and training. Read more...

Interests, Work Values, Work Styles

Interests

This file contains the Content Model Interest data associated with each O*NET-SOC occupation. Read more...

Work Values

This file contains the Content Model Work Values data associated with each O*NET- SOC occupation. Read more...

Work Styles

This file contains the Content Model Work Styles data associated with each O*NET-SOC occupation. Read more...

Tasks

Task Statements

This file contains the tasks associated with each O*NET-SOC occupation. Read more...

Task Ratings

This file contains the task ratings associated with each O*NET-SOC occupation. Read more...

Task Categories

This file contains the categories associated with the Task content area. Read more...

Emerging Tasks

This file contains new and revised task statements proposed for future data collection. Read more...

Tools & Technology

Tools and Technology updated in 23.1

This file contains the Tools and Technology examples, including hot technologies, associated with O*NET-SOC occupations. Read more...

UNSPSC Reference

This file contains a listing of commodities in the United Nations Standard Products and Services Code (UNSPSC), version 15.1101. Read more...

Work Activities

Work Activities

This file contains the Content Model Work Activity data associated with each O*NET-SOC occupation. Read more...

IWA Reference

This file contains each Intermediate Work Activity and its corresponding O*NET Work Activity element ID. Read more...

DWA Reference

This file contains each Detailed Work Activity and its corresponding GWA and IWA identifiers. Read more...

Tasks to DWAs

This file maps each Detailed Work Activity (DWA) to the task statements, and consequently to the O*NET-SOC occupations, requiring that activity. Read more...

Work Context

Work Context

This file contains the Content Model Work Context data associated with each O*NET-SOC occupation. Read more...

Work Context Categories

This file contains the categories associated with the Work Context content area. Read more...

Occupation Titles

Occupation Data

This file contains each O*NET-SOC code, occupational title, and definition/description. Read more...

Alternate Titles updated in 23.1

This file contains alternate, or "lay", occupational titles for the O*NET-SOC classification system. Read more...

Sample of Reported Titles updated in 23.1

This file contains job titles frequently reported by incumbents and occupational experts on data collection surveys. Read more...

Related Occupations

Career Changers Matrix

For each O*NET-SOC code included, up to 10 related O*NET-SOC codes are listed. Read more...

Career Starters Matrix

For each O*NET-SOC code included, 10 related O*NET-SOC codes are listed. Read more...

Green

Green Occupations

This file contains the occupations that have been identified as Green. Read more...

Green Task Statements

This file contains the green tasks associated with O*NET-SOC occupations. Read more...

Tasks to Green DWAs

This file maps each Green Detailed Work Activity (Green DWA) to the task statements, and consequently to the O*NET-SOC occupations, requiring that activity. Read more...

Green DWA Reference

This file contains each Green Detailed Work Activity and the element ID of its corresponding generalized Work Activity. Read more...

Data Collection

Content Model Reference

This file contains the Content Model elements and descriptions. Read more...

Occupation Level Metadata

This file contains occupational level metadata variables associated with data collection statistics. Read more...

Level Scale Anchors

This file contains the scale anchors associated with the following four content areas – 1) Abilities, 2) Knowledge, 3) Skills, and 4) Work Activities. Read more...

Scales Reference

This file contains the Scale information by which the raw values are measured. Read more...

Survey Booklet Locations

This file contains the Content Model elements that have corresponding survey item numbers in the Survey Booklet. Read more...