OPM Federal Workforce Data Portal

Visualization catalog • Raw data docs • Unused variables

⚠️ Put together quickly - may have errors. Verify against data.opm.gov

🏷️ Click filters to find dashboards
📊 Total: 22 visualizations
🔍 Showing: 22

📊 Employment Data (EHRI Status)

Monthly snapshots of all active federal employees

Files
59 monthly (Jan 2021 - Nov 2025)
Rows per file
~2.1M
Columns
31
File size
~800 MB each

Key Columns

agency / agency_code
Parent agency (62 unique agencies)
Type: string Nulls: <0.01%
agency_subelement / agency_subelement_code
Sub-agency or bureau (331 unique)
Type: string Nulls: <0.01%
age_bracket
Age ranges (11 brackets from <20 to 65+)
Type: string Nulls: 0%
occupational_series / occupational_series_code
Specific job series (511 unique, e.g., 0610-Nurse, 2210-IT)
Type: string Nulls: 0%
grade / pay_plan
Pay grade and plan (GS, WG, etc.)
Type: string Nulls: <0.03%
annualized_adjusted_basic_pay
Annual salary (contains "REDACTED" for sensitive records)
Type: string Nulls: <0.01%
duty_station_state / duty_station_state_abbreviation
Work location (~48% redacted for privacy)
Type: string Nulls: 0%
education_level
24 levels from "No formal education" to "Doctorate"
Type: string Nulls: 0%
length_of_service_years
Years in federal service (0-72.5, mean: 11.94)
Type: float Nulls: 0%

➕ Accessions Data (EHRI Dynamics)

New hires and transfers into federal service

Files
59 monthly (Jan 2021 - Nov 2025)
Total rows
118K
Columns
33
File size
2-10 MB

Unique Columns (vs Employment)

accession_category / accession_category_code
Type of entry: Competitive (AA), Excepted (AC), SES (AD), Transfer (AE)
4 categories
personnel_action_effective_date_yyyymm
Month when action took effect (replaces snapshot_yyyymm)
Type: int

➖ Separations Data (EHRI Dynamics)

Resignations, retirements, and departures from federal service

Files
59 monthly (Jan 2021 - Nov 2025)
Total rows
335K
Columns
33
Sep 2025 spike
125K rows

Unique Columns (vs Employment)

separation_category / separation_category_code
Type of departure: Quit (SB), Voluntary Retire (SG), Transfer (SJ), RIF (SC), Termination (SH), Early Out (SD), Other (SA/SE), Mass Transfer (SL)
9 categories

Note: September 2025 shows 125K separations vs typical ~20K/month, indicating significant workforce reduction events.

These variables are present in the raw EHRI data files but are not currently featured in OPM's visualization catalog. They represent opportunities for additional custom analysis.

stem_occupation & stem_occupation_type

Pre-computed aggregation of occupational series into STEM/Health/Other categories. If you already have occupational_series, this is just a convenience grouping.

ALL OTHER OCCUPATIONS (72.8%) STEM OCCUPATIONS (18.4%) HEALTH OCCUPATIONS (8.7%)

supervisory_status & supervisory_status_code

Indicates supervisory, managerial, team leader, or non-supervisory positions. Values: 2 (Supervisor/Mgr), 4-8 (various), mean: 7.21 (most non-supervisory)

ALL OTHER POSITIONS (84%) SUPERVISOR OR MANAGER (11.7%) TEAM LEADER LEADER MANAGEMENT OFFICIAL

Potential analyses:

  • What is the supervisor-to-employee ratio across agencies?
  • How does supervisory status correlate with salary and grade?
  • Are supervisors more or less likely to separate than non-supervisors?
  • How has the management layer changed over time?

work_schedule & work_schedule_code

Work arrangement: Full-time (95.4%), Part-time, Intermittent, Seasonal variations, Job Sharer, Phased Retirement

F - Full-time P - Part-time I - Intermittent G - Full-time Seasonal S - Part-time Seasonal J - Intermittent Seasonal Q - Job Sharer R - Phased Retirement

Potential analyses:

  • Which agencies rely most on part-time or seasonal workers?
  • How does work schedule affect separation rates?
  • What occupational series have the highest proportion of intermittent workers?
  • How many employees are using phased retirement options?

length_of_service_years

Years in federal service: 0-72.5 years. Mean: 11.94 (Employment), 7.22 (Accessions), 18.54 (Separations - higher due to retirements)

Potential analyses:

  • What is the average tenure by agency or occupational series?
  • How does tenure correlate with grade level and salary?
  • At what tenure length do employees most commonly separate?
  • Which agencies have the most experienced workforce?
  • How does new hire tenure (prior service) vary by accession type?