About this Dataset

CT Occupational Employment & Wages (OES) - 2022-Q1

The Connecticut Occupational Employment and Wage data provides employment and wage data by occupation and is based on the results of the Occupational Employment Statistics (OES) survey. The OES program conducts a bi-annual mail survey designed to produce estimates of employment and wages for over 800 occupations. These estimates are generated at the national, state, and metropolitan area levels. For more information, please visit us at http://www1.ctdol.state.ct.us/lmi/wages/default.asp.
Organization: State of Connecticut
Last updated: 2020-11-12T14:57:51.908462
Tags: ct, occupational-employment-wages, oes, wage

Tables

Table 1

@usgov.state_of_connecticut_ct_occupational_employment_wages__9294feba.table_1

326.36 kB
3,829 rows
22 columns

CREATE TABLE table_1 (
  "state_fips" BIGINT,
  "area" BIGINT,
  "areaname" VARCHAR,
  "soc_code" VARCHAR,
  "soc_title" VARCHAR,
  "employment" VARCHAR,
  "meanhourlywage" VARCHAR,
  "meanannualwage" VARCHAR,
  "entrylevelhourlywage" VARCHAR,
  "entrylevelannualwage" VARCHAR,
  "experiencedlevelhourlywage" VARCHAR,
  "experiencedlevelannualwage" VARCHAR,
  "n_10_hourlywage" VARCHAR  -- 10%HourlyWage,
  "n_10_annualwage" VARCHAR  -- 10%AnnualWage,
  "n_25_hourlywage" VARCHAR  -- 25%HourlyWage,
  "n_25_annualwage" VARCHAR  -- 25%AnnualWage,
  "medianhourlywage" VARCHAR,
  "medianannualwage" VARCHAR,
  "n_75_hourlywage" VARCHAR  -- 75%HourlyWage,
  "n_75_annualwage" VARCHAR  -- 75%AnnualWage,
  "n_90_hourlywage" VARCHAR  -- 90%HourlyWage,
  "n_90_annualwage" VARCHAR  -- 90%AnnualWage
);