Flag of the United States of America
An official website of the United States government
Here’s how you know Expand details arrow
Incomplete Data: A change in Department of War (DOW) data processing prevented some components from submitting June 2026 and July 2026 data. Most data has now been received, with some components still outstanding. Visuals and downloads with Status and Dynamics data are affected; all non-DOW data is unaffected. See Release Notes for a full list of affected components. Data will be updated once all submissions are received.

Table Builder

Updated monthly | Data as of July 2026

This page is your workspace for building custom tables using federal workforce data from EHRI Status and Dynamics datasets. Start by selecting a dataset, then set a date range and table elements, and apply optional filters to create a table tailored to your analysis needs.
Use the FWD Data Dictionary to understand how fields are defined across Employment, Accessions, and Separations data.
Download FWD Data Dictionary
Note: Salary data is redacted for many federal employees due to the Data Release Policy, and some values are null due to data‑processing rules. As a result, the average salary metric may not represent all employees.

All fields marked with an asterisk (*) are required.

Step 1: Select dataset

Select the dataset for your table. Each dataset has a specific purpose.*

Employment

Snapshot of all federal civilian employees in a pay status.

Accessions

Data on personnel actions for new hires and transfers.

Separations

Data on resignations, retirements, and other separations.

Step 2: Select a timeframe

Select the monthly date range to use for your table.

Available after selecting a dataset

Date range*

TIMEFRAME

-

Step 3: Select table elements

Select the rows, columns, and metrics for your table. Selecting these elements creates a table similar to a pivot table or a crosstab. Click the information icon to learn more about how these table elements create your table.
Available after selecting a dataset

Rows*

Column*

Metrics*

TABLE ELEMENTS

-

Step 4: Select filters (optional)

Select filters to narrow down the data to specific details you are exploring.

Available after selecting a dataset

Filters

Step 5: Generate table

Table generation may take a few moments depending on the amount of data selected.

Available after making selections in Steps 2 and 3
0/50

Select a dataset, configure timeframe and table

elements, apply filters, and press "Generate table"

An unhandled error has occurred. Reload 🗙
Reconnecting to the server… Connection lost.