Short-term (two-year) estimations, projections, and growth rates for industry and occupation by geographic area in Colorado provided by the 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 |
areatype | areatype | number | Code describing type of geographic area: e.g. county, service delivery area, MSA. | 21 1 75 view top 100 |
areatyname | areatyname | text | Descriptive title of the areatype. | Metropolitan Statistical Area State Balance of State view top 100 |
areaname | areaname | text | Geographic area name. | Colorado Denver - Aurora MSA Colorado Springs MSA Boulder-Longmont MSA Fort Collins-Loveland MSA view top 100 |
periodid | periodid | number | A 2-digit code identifying the type of period used. | 69 76 view top 100 |
perioddesc | perioddesc | text | Description of period range. | Colorado Short-Term Projections, 2016-2018, June 2016 Colorado Short-Term Projections, 2020-2022, December 2019 view top 100 |
periodtype | periodtype | number | Code describing type of period (e.g. Annual, quarterly, monthly, etc.) | 1 view top 100 |
matincodty | matincodty | number | A code to identify matincode as SIC code based or NAICS code based; 1 = SIC based, 2 = NAICS based | 2 view top 100 |
matintitle | matintitle | text | Industry title. | Self Employed and Unpaid Family Workers, All Jobs Total All Industries Services Providing Government Total Self Employed and Unpaid Family Workers, All Jobs view top 100 |
matoccodty | matoccodty | number | A code to identify matoccode as 9 char and OES code based or 10 char and SOC code based. 1 = OES based, 2 = SOC based | 2 view top 100 |
matocctitl | matocctitl | text | Occupation title. | Total, All Occupations Office and Administrative Support Occupations Management Occupations Business and Financial Operations Occupations Sales and Related Occupations view top 100 |
estemp | estemp | number | The base-year employment estimate. | 5 13 12 15 14 view top 100 |
projemp | projemp | number | The projected-year employment estimate. | 14 13 5 12 15 view top 100 |
nchg | nchg | number | Numeric Change between the projected estimate and the base estimate. | 0 1 2 3 -1 view top 100 |
aopeng | aopeng | number | A value representing the annual average openings due to growth. The value is calculated by subtracting the Base Year Employment estimate from the Projected Year Employment estimate, then dividing by the number of years in the projection period. (projemp-estemp)/No. years. | 0 2 1 4 6 view top 100 |
aopenr | aopenr | number | A value representing the annual average openings due to net replacement. The value is calculated by dividing the total openings due to net replacements (in the projection period) by the number of years in the projection period. | 2 0 1 4 6 view top 100 |
aopent | aopent | number | A value representing the total annual average openings due to growth and net replacements. | 0 2 4 1 3 view top 100 |
suppress | suppress | number | An indicator that the record contains confidential data that must be suppressed for public use: 0 = Not Confidential; 1 = Confidential | 0 view top 100 |
area | area | number | A 6-digit code assigned to represent a geographic area. Front fill with zeroes. | 0 19740 17820 14500 22660 view top 100 |
matincode | matincode | number | Industry code from Micro Matrix. | 0 102000 670 671 6010 view top 100 |
matoccode | matoccode | number | Occupation code from Micro Matrix. For codes not 10 characters long, left justify and blank (ASCII 32) fill. | 0 430000 110000 130000 410000 view top 100 |
pctestind | pctestind | number | The percentage of projected employment for the indicated industry represented by projected employment for the indicated occupation within that industry. | 0.01 0.02 0.03 0.04 0.06 view top 100 |
pctprojind | pctprojind | number | The percentage of projected employment for the indicated industry represented by projected employment for the indicated occupation within that industry. | 0.01 0.02 0.03 0.04 0.05 view top 100 |
pchg | pchg | number | Percent change over period.((projemp-estemp)/estemp)*100 | 0 7.6923 6.6667 6.25 5.5556 view top 100 |
growrate | growrate | number | A value representing the annualized percentage growth. This value is calculated by dividing the Projected year by the Base year. Taking the results to the 1/n power, where n is the number of years in the projection period, subtracting 1 from the result and multiplying that result by 100. Ie. grrate=(((projemp/estemp)^1/n)-1)*100 | 0 3.7749 3.2796 3.0776 2.7402 view top 100 |
pctprojocc | pctprojocc | number | The percentage of the projected employment estimate for the indicated occupation represented by the projected employment estimate for the indicated industry within that occupation. | 100 0.19 0.24 0.17 0.08 view top 100 |
pctestocc | pctestocc | number | The percentage of the projected employment estimate for the indicated occupation represented by the projected employment estimate for the indicated industry within that occupation. | 100 0.19 0.08 0.16 0.17 view top 100 |