US Occupation Example

📘

Ready to use this data? See the Core LMI reference documentation to get started.

Description

This example dataset shows (by year, class of worker, occupation, and area) occupation data including job counts by place of work, openings and replacement figures, earnings, and job counts by place of residence. This example data is available only for class of worker 1, and for the years 2012, 2013, and 2014. Data is available at the nation, state, MSA, county, census tract, and ZIP code levels, for the following artificial geography set: A total of 54 distinct census tracts (not displayed for brevity); ZIPs 60203, 60301, 60304, 60411, 60416, 60450, 60459; Counties 17015, 17031, 17037; MSA 169800; State 17; Nation 0

When requesting MSA codes or ZIP codes as the area constraint in a query, the code must be prepended by MSA or ZIP, respectively (e.g. for ZIP code 60203, use 'ZIP60203')

The geographies aggregate as follows:

• the census tracts aggregate to the state total (as do the ZIPs and counties);
• county 17031 consists of ZIPs 60203, 60301, 60304;
• county 17037 consists of ZIPs 60411, 60416;
• county 17015 consists of ZIPs 60450, 60459;
• MSA 169800 consists of counties 17031, 17037 (county 17015 has no associated MSA);
• state 17 consists of counties 17015, 17031, 17037;
• nation 0 is equivalent to state 17

Questions answered by this dataset

• How many pharmacist jobs were there in Illinois in 2012?
• What are the median earnings for purchasing managers in various ZIP codes around Chicago? How about the 75th percentile earnings?
• How many job openings where there due to replacement needs for marketing managers in Cook County in 2014?
• How did the 90th percentile earnings for graphic designers in the Charleston-Mattoon metropolitan area change from 2012 to 2014?

Metrics

• Jobs by place of work: The number of occupied positions. This is not quite the same as workers because one worker might fill more than one position.
• Earnings.Average: Average hourly earnings for each job.
• Growth: Growth is the net (non-negative) change for each year, and is calculated at the lowest level and aggregated up. For these reasons, it often differs from job change as calculated by subtracting an earlier year's jobs from a later year's job counts. The growth metric is a component of the openings metric (growth + replacements = openings).
• Replacements: Replacements is the number of existing jobs that are estimated to have been vacated in the year. Replacements takes into account job openings that are created but that are not due to growth in the occupation.
• Openings: Openings is the sum of growth and replacement, and it refers to the estimated number of job openings that exist both due to growth in the occupation and replacement needs in the occupation.
• Jobs by place of residence: The number of people living in an area that hold a job within the occupation in question. (The total will not be the same as jobs by place of work at the nation, since this is only a sample dataset.)
• Earnings (current occupation year) or HistoricalEarnings (2005 - current occupation year)
  • Percentile10: 10th percentile hourly earnings per worker.
  • Percentile25: 25th percentile hourly earnings per worker.
  • Percentile50: 50th percentile (median) hourly earnings per worker.
  • Percentile75: 75th percentile hourly earnings per worker.
  • Percentile90: 90th percentile hourly earnings per worker.
  • Median.Annual: 50th percentile (median) annual earnings per worker.
  • Percentile10.Annual: 10th percentile annual earnings per worker.
  • Percentile25.Annual: 25th percentile annual earnings per worker.
  • Percentile50.Annual: 50th percentile (median) annual earnings per worker.
  • Percentile75.Annual: 75th percentile annual earnings per worker.
  • Percentile90.Annual: 90th percentile annual earnings per worker.

Filters

• Class of Worker: 1
• Area (Nation, State, MSA, County, Census tract, ZIP code)
• Occupation (5-digit SOC)
• Year
• Jobs by place of work: 2012 - 2014
• Earnings: 2012 - 2014
• Growth: 2012 - 2014
• Replacements: 2012 - 2014
• Jobs by place of residence: 2012 - 2014

Core LMI Metadata