INTRODUCTION
The Data Library enables users to quickly look at differences across regions, occupations, and Industries. Occupation Data in the Data Library adds granularity to regional Industry employment and compensation data, such as occupation classification Employment levels and Wage and Salary Income by occupation.
OVERVIEW
The 2018-2022 Occupation Data applied to all IMPLAN Data Set Years for all counties and states in the U.S. are available in Data Library.
Find more information in the Occupation and Core Competency Data article.
The 2023 Data Year, which utilizes the 528 Industry Set, is not currently available in Data Library. The 528 Industry Set is specifically for the U.S. data in the 2023 Data Year at this time. All previous Data Years currently available in Data Library (2001-2022) will require the use of the 546 Industries Set until the release of the updated IMPLAN 528 Industry Set time series data (coming in 2025).
DASHBOARDS
AREA OCCUPATION COMPARE
This Dashboard includes 3 tiles:
- Year over Year is a line chart showing the filtered Metric over Data Years for the filter Region(s).
- County View is a map chart of the filtered Metric by Five Digit FIPS (this is the county code Looker uses to map the data).
- Occupation Table is a table chart of the filtered Metric by Occupation Code and Occupation Description at the filtered Occupation Level for the filtered Region(s).
When viewing a Dashboard, use the filters to change the data points displayed. Filter options include:
- Dollar Type: by default, dollars are displayed in Real dollars. See Dollar Year
- Data Year: the most recent Data Year is displayed by default in the County View and Occupation Table tiles. All available Data Years are displayed in the Year over Year tile
- Dollar Year: by default, dollars are shown in current year dollars
- Occupation Data Year: define the year of the Occupation Data. The most recent Occupation Data Year is set by default
- Occupation Level: define the level of detail in the occupation classifications. 3 - minor is set by default
- State: North Carolina, South Carolina, and Georgia are set by default
- County: no county filter is set by default
- Aggregation: the Industry Aggregation Scheme by default is the 546 unaggregated scheme
- Industry: no Industry filter is set by default
- Occupation: no occupation filter is set by default
- Metric: Employee Compensation is set by default
AREA OCCUPATION DETAIL
This Dashboard includes 2 tiles:
- Occupation Summary is a table chart showing Wage and Salary Employment, Wage and Salary Income, Supplements to Wage and Salary Income, Employee Compensation, Hours Worked, and Location Quotient by Occupation Code and Occupation Description at the filtered Occupation Level for the filtered Region(s).
- Occupation Averages is a table chart showing Average Wage and Salary Income, Average Supplements to Wages and Salaries, Average Employee Compensation, Average Hours per Year, Average Wage and Salary Income per Hour, Average Supplements to Wages and Salaries per Hour, and Average Employee Compensation per Hour by Occupation Code and Occupation Description at the filtered Occupation Level for the filtered Region(s).
Filter options include:
- Dollar Type: by default, dollars are displayed in Real dollars. See Dollar Year
- Data Year: the most recent Data Year is set by default
- Dollar Year: by default, dollars are shown in current year dollars
- Occupation Data Year: define the year of the Occupation Data. The most recent Occupation Data Year is set by default
- Occupation Level: define the level of detail in the occupation classifications. 3 - minor is set by default
- State: North Carolina is set by default
- County: no county filter is set by default
- Aggregation: the Industry Aggregation Scheme by default is the 546 unaggregated scheme
- Industry: no industry filter is set by default
- Occupation: no occupation filter is set by default
The Dashboard Actions in the upper right provides more options such as downloading the Dashboard to a PDF. On each tile, click the Tile actions (a series of three vertical dots that appear in the upper right of a tile when hovering over it with a cursor) for the option to download the data within that tile. Select Explore from here within the Tile actions to access more data query options. Exploring from the Dashboard allows users to dig into the data starting from the settings within the Dashboard tile.
EXPLORE
Explore the Occupation Data by selecting Occupation Data from the Explore drop-down menu, or by selecting Explore from here from an Occupation Data Dashboard Tile or Look.
By default in Explore, a filter is set for State: North Carolina. Because of the amount of data in this section, this default filter has been set to improve data query performance. The Dollar Type is Real and the Dollar Year is the current year, and the Data Year is the most recent Data Year. With these settings, all dollar values included in a data query will be adjusted for inflation and displayed in current year dollars. It is recommended to always either filter or pivot on Data Year. Otherwise, data measures will be summed over Data Years.
By default, the Aggregation Scheme Param is 546 Unaggregated and Occupation Aggregation Level is 3 - minor. Industry Dimensions will be available in the 546 Industry Scheme and Occupation Dimensions will be available at the 3 - minor level with these settings.
FILTER-ONLY FIELDS
AGGREGATION SCHEME PARAM
The aggregation filter provides the option to view data by Industry at one of the following levels of granularity:
- 546 Unaggregated: most granular. Data is available for each IMPLAN Industry according to the most recent 546 Industry Scheme.
- IMPLAN 2 Digit NAICS 546: Data is aggregated for Industries corresponding to each 2 Digit NAICS.
- IMPLAN 3 Digit NAICS 546: Data is aggregated for Industries corresponding to each 3 Digit NAICS.
Download the 2022 aggregated NAICS to IMPLAN 546 Industries bridge for details.
DOLLAR TYPE
When Dollar Type is Real, Nominal dollar values are adjusted to be in the selected Dollar Year(s). When Filtering by multiple Dollar Years, select or pivot on Dollar Year to prevent potential double counting. Dollar Year only applies when Dollar Type is Real.
FIELD PICKER
The Field Picker allows users to pick any one of the Measures from the filter drop-down menu. The Measure titled “Metric” to do so is tied to the Field Picker. Select, filter, and/or pivot on this measure in order to include it in the data query.
DIMENSIONS
Select a Dimension to include as a column with all Dimension possibilities.
Click Filter on a Dimension to specify which Dimension possibilities appear in the data query.
Click Pivot on a Dimension to transpose the Dimension rows into columns.
Dimensions | Details |
---|---|
County |
All U.S. counties are possible Dimensions. When states are selected in the State filter, only counties within the filtered states will appear in the county filter or in the data query when selected. |
Data Year | All IMPLAN Data Years are possible Dimensions. |
Dim Single Industry Occupation (Yes/No) | Indicates if an Occupation is specific to a single Industry (Yes) or if it exists in multiple Industries (No). |
Dollar Year |
Years 1997 through 2060 are possible Dimensions. Dollar Year only applies when Dollar Type is Real. When Dollar Type is Real, Nominal dollar values are adjusted to be in the selected Dollar Year(s). When Filtering by multiple Dollar Years, select or pivot on Dollar Year to prevent potential double counting. |
Five Digit Fips |
A Five Digit Federal Information Processing Standards (FIPS) is a county code. The first two digits indicate the state and the following three digits indicate the county. All U.S. Five Digit FIPS codes are possible Dimensions. This Dimension is used to map the data in the County View Map Chart found on the Dashboard. This file contains FIPS codes for all counties and states. |
Industry | All 546 IMPLAN Industries (Code and Description) are possible Dimensions. |
Industry Code | All 546 IMPLAN Industry Codes (numbers) are possible Dimensions. |
Industry Description | All 546 IMPLAN Industry Descriptions (names) are possible Dimensions. |
Occupation | All Occupations (Code and Description) are possible Dimensions. The Occupations included in this Dimension will depend on the Occupation Aggregation Level. |
Occupation Aggregation Level |
The following Occupation Aggregation Level options allows users to display Occupations by either 1, 2, 3, 4, or 5 digit Occupation Codes: 1 - Total (all Occupations, only one Occupation Category) 2 - Major 3 - Minor 4 - Broad 5 - Detail (most granular level of occupations) |
Occupation Code | All Occupation Codes are possible Dimensions. The Occupation Codes included in this Dimension will depend on the Occupation Aggregation Level. |
Occupation Data Year | All available Occupation Data Years are possible Dimensions. |
Occupation Description | All Occupation Descriptions are possible Dimensions. The Occupation Descriptions included in this Dimension will depend on the Occupation Aggregation Level. |
Region |
All 50 States plus the District of Columbia are possible Dimensions. Pivoting or selecting Region will display filtered states when filtering on state and will display filtered counties when filtering on county. |
State | All 50 States plus the District of Columbia are possible Dimensions. |
MEASURES
Measures are displayed based on Dimension settings. Select a Measure to include as a column in the data query.
Measures | Details |
---|---|
Average Employee Compensation | Average Employee Compensation per wage and salary employee. Calculated as Employee Compensation divided by wage and salary Employment. |
Average Employee Compensation per Hour | Average Employee Compensation per wage and salary employee, per hour. Calculated as Employee Compensation divided by hours worked. |
Average Hours per Year | Average hours worked per year per wage and salary employee. Calculated as hours worked divided by wage and salary Employment. |
Average Supplements to Wages and Salaries | Average Supplements to Wages and Salaries per wage and salary employee. Calculated as supplements to wages and salaries divided by wage and salary Employment. |
Average Supplements to Wages and Salaries per Hour | Average Supplements to Wages and Salaries per wage and salary employee per hour. Calculated as supplements to wages and salaries divided by hours worked. |
Average Wage and Salary Income | Average Wage and Salary Income per wage and salary employee. Calculated as wages and salaries divided by wage and salary Employment. |
Average Wage and Salary Income per Hour | Average Wage and Salary Income per wage and salary employee per hour. Calculated as wages and salaries divided by hours worked. |
Employee Compensation | Fully loaded payroll. See full EC definition. |
Hours Worked | Total hours worked by wage and salary employment. |
Industry Count | Count of IMPLAN Industries that an occupation is evident in. |
Location Quotient | Measures the relative concentration of a competency or occupation. |
Metric | Metric is recommended to be selected only in conjunction with a Field Picker filter (a Filter-Only Field). This is a helpful Dashboard option. |
Occupation Count | Count of detailed Occupations. |
Supplements to Wages and Salary | Value consists of employer contributions for employee pension and insurance funds and of employer contributions for government social insurance; the difference between Employee Compensation and Wage and Salary Income. |
Wage and Salary Employment | Headcount of salaried or wage-earning employees; excluding Proprietors. |
Wage and Salary Income | Total wage and salary income. These consist of the monetary remuneration of employees, and are broadly defined to include commissions, tips, and bonuses; voluntary employee contributions to deferred compensation plans, such as 401(k) plans; employee gains from exercising stock options; and receipts-in-kind that represent income. |
RELATED ARTICLES
Occupation and Core Competency Data
Written August 30, 2023
Updated December 30, 2024