Employment counts by SIC and NAICS codes, county, and quarter since 2000 from Colorado Department of Labor and Employment (CDLE).
This dataset has the following 29 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
stateabbrv | stateabbrv | text | The two letter state abbreviation. | CO view top 100 |
statename | statename | text | State name. | Colorado view top 100 |
stfips | stfips | number | State FIPS code. | 8 view top 100 |
areaname | areaname | text | Geographic area name. | Colorado El Paso County Denver County Arapahoe County Jefferson County view top 100 |
areatype | areatype | number | Code describing type of geographic area: e.g. county, service delivery area, MSA. | 4 1 view top 100 |
areatyname | areatyname | text | Descriptive title of the areatype. | County State view top 100 |
area | area | number | Six-digit code assigned to represent a geographic area. Front fill with zeroes. | 0 41 31 5 59 view top 100 |
periodyear | periodyear | number | Character representation of calendar-year (e.g. 2000). | 2007 2004 2003 2006 2002 view top 100 |
periodtype | periodtype | number | Code describing type of period (e.g. Annual, quarterly, monthly, etc.). | 2 1 view top 100 |
period | period | number | Period Code. Will be set to '00' where periodtype is annual. | 1 3 2 0 4 view top 100 |
pertypdesc | pertypdesc | text | A description of the period type. | Quarterly Annual view top 100 |
indcodty | indcodty | number | Code describing the industry code type. | 10 view top 100 |
indcode | indcode | text | 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. | 00 10 1028 1021 92 view top 100 |
codetitle | codetitle | text | The descriptive title for this industry code. | Public Administration Total, All Industries and Ownerships Total, All Industries Construction Professional and Technical Services view top 100 |
ownership | ownership | text | Ownership is a two-digit indicator that identifies the employer by public or private ownership. | 50 00 10 30 20 view top 100 |
ownertitle | ownertitle | text | Title of ownership. | Private Aggregate of all types Federal Government Local Government State Government view top 100 |
prelim | prelim | number | Preliminary/revised flag 0 = Not Preliminary, 1 = Preliminary | 0 1 view top 100 |
firms | firms | number | The number of firms in the industry. | 0 3 4 5 1 view top 100 |
estab | estab | number | The number of employer establishments in the industry. (reporting units) | 0 3 4 5 6 view top 100 |
avgemp | avgemp | number | The number of workers employed in the industry. | 0 5 8 6 7 view top 100 |
mnth1emp | mnth1emp | number | Employment on the first month of the quarter. | 0 5 7 8 6 view top 100 |
mnth2emp | mnth2emp | number | Employment on the second month of the quarter. | 0 5 7 8 6 view top 100 |
mnth3emp | mnth3emp | number | Employment on the third month of the quarter. | 0 5 8 7 10 view top 100 |
topempav | topempav | number | Average employment for the quarter or year of the top employer for the specified geography and industry code | 0 7 6 4 3 view top 100 |
totwage | totwage | number | The total wages paid to all workers in the industry for the period. | 0 3000 6000 1950 9000 view top 100 |
avgwkwage | avgwkwage | number | Average weekly wage per worker. | 0 532 548 555 510 view top 100 |
taxwage | taxwage | number | Total taxable wages. | 0 17000 34000 11550 78184 view top 100 |
contrib | contrib | number | Employer contributions to the UI fund. | 0 23 162 157 117 view top 100 |
suppress | suppress | text | An indicator that the record contains confidential data that must be suppressed for public use. 0 = Not Suppressed, 1 = Suppress employment & wage data | 0 view top 100 |