Flag of the United States of America An official website of the United States government Here’s how you know Expand details arrow

Table Builder

Updated monthly | Data as of March 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*

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*

Step 4: Select filters (optional)

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

Available after selecting a dataset

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 🗙