< Return to Datasets Menu

2010 Occupational Employment Statistics

2010 Occupational Employment Statistics V1

https://api.dol.gov/V1/Statistics/OES2010

The Occupational Employment Statistics (OES) program conducts a semi-annual mail survey designed to produce estimates of employment and wages for specific occupations. The OES program collects data on wage and salary workers in nonfarm establishments in order to produce employment and wage estimates for about 800 occupations. Data from self-employed persons are not collected and are not included in the estimates. The OES program produces these occupational estimates by geographic area and by industry. Estimates based on geographic areas are available at the National, State, Metropolitan, and Nonmetropolitan Area levels. The Bureau of Labor Statistics produces occupational employment and wage estimates for over 450 industry classifications at the national level. The industry classifications correspond to the sector, 3-, 4-, and 5-digit North American Industry Classification System (NAICS) industrial groups. More information and details about the data provided can be found at https://www.bls.gov/oes/

Summary Data Available

Cross-industry estimates are available by Nation, State, and metropolitan area for about 800 occupations. Industry specific estimates are available at the National level for over 450 industries.

Data Characteristics

  • Annual wage estimates are rounded to the nearest dollar and are stored with no decimal place.
  • Hourly wage estimates are rounded to the nearest cent and are stored with two decimal places.
  • Employment estimates are rounded to the nearest ten and are stored with no decimal place.
  • Percent relative standard errors are rounded to the nearest tenth and are stored with one decimal place.
  • Special characteristics of the data are footnoted where necessary.

Browse Metadata

Dataset Tables

area Table

Area Codes and Area Names
Column Name Data Type Column Description
Column Name area_code Data Type varchar(7) Column Description Area Code - Primary Key
Column Name areatype_code Data Type varchar(1) Column Description Area Type Code
Column Name area_name Data Type varchar(100) Column Description Area Name

area_definitions Table

States, Counties, and Metropolitan Specific Areas
Column Name Data Type Column Description
Column Name FIPS Data Type varchar(10) Column Description FIPS - Primary Key
Column Name State Data Type varchar(100) Column Description State Name
Column Name MSA_code Data Type varchar(20) Column Description Metropolitan Specific Area Code - Primary Key
Column Name MSA_name Data Type varchar(255) Column Description Metropolitan Specific Area Name
Column Name Aggregate_MSA_code Data Type varchar(20) Column Description Aggregate Metropolitan Specific Area Code
Column Name Aggregate_MSA_name Data Type varchar(255) Column Description Aggregate Metropolitan Specific Area Name
Column Name County_code Data Type varchar(20) Column Description County Code - Primary Key
Column Name Township_code Data Type varchar(20) Column Description Township Code - Primary Key
Column Name County_name Data Type varchar(255) Column Description County Name
Column Name Township_name Data Type varchar(255) Column Description Township Name

areatype Table

Area Types
Column Name Data Type Column Description
Column Name areatype_code Data Type varchar(1) Column Description Area Type Code - Primary Key
Column Name areatype_name Data Type varchar(100) Column Description Area Type Name

data Table

Current Estimates
Column Name Data Type Column Description
Column Name series_id Data Type varchar(30) Column Description Serie ID - Primary Key
Column Name year Data Type varchar(4) Column Description Year - Primary Key
Column Name period Data Type varchar(3) Column Description Period - Primary Key
Column Name value Data Type varchar(12) Column Description Value of the Estimate
Column Name footnote_codes Data Type varchar(1) Column Description Unique Code used to identify a specific footnote

datatype Table

Data Types
Column Name Data Type Column Description
Column Name datatype_code Data Type varchar(2) Column Description Datatype Code - Primary Key
Column Name datatype_name Data Type varchar(100) Column Description Datatype Name
Column Name footnote_code Data Type varchar(1) Column Description Unique Code used to identify a specific footnote

footnote Table

Footnotes and Explanation
Column Name Data Type Column Description
Column Name footnote_code Data Type varchar(1) Column Description Footnote Code - Primary Key
Column Name footnote_text Data Type varchar(250) Column Description Footnote Text

industry Table

Industry Codes and Titles
Column Name Data Type Column Description
Column Name industry_code Data Type varchar(6) Column Description Industry Code - Primary Key
Column Name industry_name Data Type varchar(100) Column Description Industry Name
Column Name display_level Data Type varchar(2) Column Description Display Level
Column Name selectable Data Type varchar(1) Column Description Selectable
Column Name sort_sequence Data Type varchar(5) Column Description Sort Sequence

industry_titles Table

Industry Titles
Column Name Data Type Column Description
Column Name Industry_Code Data Type varchar(6) Column Description Industry Code - Primary Key
Column Name Industry_Title Data Type varchar(255) Column Description Industry Title

occugroup Table

Major Occupation Groups Codes and Titles
Column Name Data Type Column Description
Column Name occugroup_code Data Type varchar(6) Column Description Occupation Group Code - Primary Key
Column Name occugroup_name Data Type varchar(100) Column Description Occupation Group Name

occupation Table

Detail Occupation Codes and Titles
Column Name Data Type Column Description
Column Name occupation_code Data Type varchar(6) Column Description Occupation Code - Primary Key
Column Name occupation_name Data Type varchar(100) Column Description Occupation Name
Column Name display_level Data Type varchar(1) Column Description Display Level
Column Name selectable Data Type varchar(1) Column Description Selectable
Column Name sort_sequence Data Type varchar(5) Column Description Sort Sequence

occupation_definitions Table

Occupation Definitions
Column Name Data Type Column Description
Column Name OCC_CODE Data Type varchar(10) Column Description Occupation Code - Primary Key
Column Name OCC_TITL Data Type varchar(255) Column Description Occupation Name
Column Name DEF Data Type varchar(max) Column Description Definition

release Table

Reference Date
Column Name Data Type Column Description
Column Name release_date Data Type varchar(7) Column Description Release Date - Primary Key
Column Name description Data Type varchar(50) Column Description Release Description

Seasonal Table

Seasonal Adjustment Indicator
Column Name Data Type Column Description
Column Name seasonal Data Type varchar(1) Column Description Seasonal Code - Primary Key
Column Name seasonal_text Data Type varchar(30) Column Description Seasonal Description

sector Table

Industry Sector Codes and Titles
Column Name Data Type Column Description
Column Name sector_code Data Type varchar(6) Column Description Sector Code - Primary Key
Column Name sector_name Data Type varchar(100) Column Description Sector Name

series Table

All Series Codes with Start and End Dates
Column Name Data Type Column Description
Column Name series_id Data Type varchar(30) Column Description Series ID - Primary Key
Column Name seasonal Data Type varchar(1) Column Description Seasonal
Column Name areatype_code Data Type varchar(1) Column Description Area Type Code
Column Name area_code Data Type varchar(7) Column Description Area Code
Column Name industry_code Data Type varchar(6) Column Description Industry Code
Column Name occupation_code Data Type varchar(6) Column Description Occupation Code
Column Name datatype_code Data Type varchar(2) Column Description Datatype Code
Column Name footnote_codes Data Type varchar(10) Column Description Footnote Code
Column Name begin_year Data Type varchar(4) Column Description Begin Year
Column Name begin_period Data Type varchar(3) Column Description Begin Period
Column Name end_year Data Type varchar(4) Column Description End Year
Column Name end_period Data Type varchar(3) Column Description End Period

The series_id (OEUM000040000000000000001) can be broken out into:

Code Value(Example)

  • survey abbreviation = OE
  • seasonal(code) = U
  • area_code = 0000400
  • industry_code = 000000
  • occupation_code = 000000
  • datatype_code = 01

statemsa Table

States and Areas
Column Name Data Type Column Description
Column Name state_code Data Type varchar(2) Column Description State Code - Primary Key
Column Name msa_code Data Type varchar(7) Column Description Metropolitan Specific Area Code - Primary Key
Column Name msa_name Data Type varchar(100) Column Description Metropolitan Specific Area Name