Employment wages by industry, year, and area, from Colorado Department of Labor and Employment, since 2009
This dataset has the following 38 columns:
| Column Name | API Column Name | Data Type | Description |
|---|---|---|---|
| stateabbrv | stateabbrv | text | The two letter state abbreviation. |
| statename | statename | text | State name. |
| stfips | stfips | number | State FIPS code. |
| areaname | areaname | text | Geographic area name. |
| areatype | areatype | number | Code describing type of geographic area: e.g. county, service delivery area, MSA. |
| area | area | number | Six-digit code assigned to represent a geographic area. Front fill with zeroes. |
| periodyear | periodyear | number | Character representation of calendar-year (e.g. 2000). |
| periodtype | periodtype | number | Code describing type of period (e.g. Annual, quarterly, monthly, etc.). |
| pertypdesc | pertypdesc | text | A description of the period type. |
| period | period | number | Period code. Will be set to ‘00’ where periodtype is annual. |
| indcodty | indcodty | number | Code describing the industry code type. |
| indcode | indcode | number | A code used in the classification of establishments by type of activity in which they are engaged. For codes not 6 characters long, left justify and blank (ASCII 32) fill. Either SIC or NAICS code can be used. A siccode of 9999 means non-classifiable; industry not specified. |
| indcodetitle | indcodetitle | text | The descriptive title for this industry code. |
| occodetype | occodetype | number | Code describing the type of occupational coding system. |
| occodetydesc | occodetydesc | text | Title of classification Code. |
| codetitle | codetitle | text | The descriptive title for this occupation or training code. |
| wagesource | wagesource | number | A code representing the source of the wage data. |
| wagesrdesc | wagesrdesc | text | A description of the source of the wage data. |
| ratetype | ratetype | number | Code which identifies the type of wage rate. |
| ratetydesc | ratetydesc | text | A description of the type of wage rate. |
| empcount | empcount | number | Total employment. |
| response | response | number | Response rate for the occupation’s actual or real survey data. Does NOT include imputed data in the rate calculation. |
| mean | mean | number | Mean wage for the occupation. |
| entrywg | entrywg | number | Entry level wage for the occupation, mean of the first third (ALC definition). |
| experience | experience | number | Experienced level wage for the occupation, mean of upper two thirds (ALC definition). |
| pct10 | pct10 | number | Wage at tenth percentile. |
| pct25 | pct25 | number | Wage at twenty-fifth percentile. |
| median | median | number | Median wage of the occupation; also the wage at fiftieth percentile. |
| pct75 | pct75 | text | Wage at seventy-fifth percentile. |
| pct90 | pct90 | text | Wage at ninetieth percentile. |
| udpct | udpct | text | User defined percentile. |
| udpctwage | udpctwage | text | Wage at user defined percentile. |
| udrnglopct | udrnglopct | text | Low percentile for user defined range. |
| udrnghipct | udrnghipct | text | High percentile for user defined range. |
| udrngmean | udrngmean | text | Mean wage for user defined range. |
| wpctrelerr | wpctrelerr | text | Relative percent error on wage. |
| epctrelerr | epctrelerr | number | Relative percent error on employment. |
| panelcode | panelcode | text | Reference panel code (yyyymm) |