Green Occupations

Purpose:Provide a comprehensive list of all Green occupations.
Table Name:green_occupations
Structure and Description:
ColumnTypeColumn Content
onetsoc_codeCharacter(10)O*NET-SOC Code (see Occupation Data)
green_occupational_categoryCharacter Varying(40)Green Occupational Category

This file contains the occupations that have been identified as Green. The Green occupational categories assigned to the occupations are:

  • Green New & Emerging — The impact of green economy activities and technologies is sufficient to create the need for unique work and worker requirements, which results in the generation of new occupations.
  • Green Enhanced Skills — The impact of green economy activities and technologies results in a significant change to the work and worker requirements of an existing O*NET-SOC occupation.
  • Green Increased Demand — The impact of green economy activities and technologies results in an increase in employment demand, but does not entail significant changes in the work and worker requirements of the occupation.

The file is displayed in two tab delimited fields with the columns named O*NET-SOC Code and Green Occupational Category. The two fields are represented by one row. There are a total of 204 rows of data in this file.

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

Data Example - green_occupations:
onetsoc_​codegreen_​occupational_​category
17-3023.03Green Enhanced Skills
17-3024.00Green Enhanced Skills
17-3024.01Green New & Emerging
17-3025.00Green Enhanced Skills
17-3026.00Green Enhanced Skills