Check out our new beta site at datalab.usaspending.gov. These pages will remain up as we transition to the new site over the next few weeks.
Connecting USAspending and federal employment data to visualize how personnel obligations across the federal government's budget translate to staffing across the government.
In the first two quarters of fiscal year 2017 (FY17), a total of $115 million dollars in personnel compensation was obligated by the largest 24 federal agencies (referred to as CFO Act Agencies*). Figure 1 shows how government-wide personnel compensation and benefits spending is distributed across these agencies, with the largest amount of personnel spending dedicated to the Department of Defense followed by the Department of Agriculture.
Figure 1: Personnel Budgets Across Government
CFO Act Agencies employ 1.9 million people across the nation, with the largest number of employees located in the District of Columbia, California, Virginia, Maryland, and Texas. Twenty three percent, or 407 thousand, CFO Act Agency employees are located in either the District of Columbia, Maryland, or Virginia.
Figure 2: CFO Act Agency Employees by State
Figure 3 illustrates how these agency’s employees include diverse types of employees. Government employees consisting of a mix of various type of staff across these agencies, including administrative, medical, legal, and engineering staff. This is shown by separating each agency’s workforce by occupational category, which groups related occupations by function. The largest proportion of employees across CFO Act agencies are employed in administrative and clerical, or medical, hospital, dental, and public health occupations.
Figure 3: Government Employees by Occupation
These analyses were conducted using federal agency obligations data reported to USAspending.gov, which is available to the public, and agency employment data made available by the Office of Personnel Management (OPM) at FedScope.OPM.gov. Personnel compensation obligations data for all CFO Act agencies were used to identify the cost of personnel compensation for each agency through the end of quarter two for the current fiscal year, 2017. This excludes any military compensation and benefits spending, such as housing allowances, health insurance, and retirement account contributions. FedScope employment data was used to verify the personnel data reported to USAspending by each CFO Act agency and evaluate the distribution of employees across the country. Employee location and occupational series data reflect the information made available by OPM in Fedscope as of March 2017. Employee information includes all full-time, and other than full-time employees reported to OPM, who were reported as being located within the United States.
* Chief Financial Officers (CFO) Act of 1993 established the CFO Council and the member agencies, more information on these agencies can be found here: https://cfo.gov/about/.
Analysis Resources: Fedscope.opm.gov