Data Set Data Sources
Projects USAspending.gov
Spending USAspending.gov, Grants.gov, Presidential Budget Requests FY 2017–27
People (by Office) USAspending.gov, Presidential Budget Requests FY 2017–27
People (by Occupation) Office of Personnel Management (OPM)

Last Updated September 3, 2026.

The variables sourced from USAspending.gov are updated quarterly. Variables derived from presidential budget requests (requested budget and requested staff) are updated episodically as new budget documents are released, with the most recent as of April 3, 2026.

A comprehensive data dictionary is available for download below, providing detailed definitions and sources for each variable across all four datasets.

This is a living database. EFIF welcomes questions, suggestions, and corrections from users. For inquiries, suggestions, or to report data issues, please contact the research team.

The analysis focuses on DOE’s “science and energy innovation offices” listed below. EFIF chose to focus on this subset of offices because they are tasked with carrying out DOE’s end-to-end innovation mandate, including research, demonstration, deployment, and commercialization. EFIF excluded entities and agencies operating under DOE (such as National Nuclear Security Administration or Energy Information Administration) which are not directly part of this mission. The DOE restructuring announced on November 20, 2025 resulted in consolidating and/or renaming several of these offices. Where discrepancies exist between old names and current names, this analysis uses current names. 

Office List
  • Advanced Research Projects Agency—Energy (ARPA-E)
  • Critical Minerals and Energy Innovation (CMEI)
  • Cybersecurity, Energy Security, and Emergency Response (CESER)
  • Departmental Administration
  • Electricity (OE)
  • Energy Dominance Financing (EDF)
  • Hydrocarbons and Geothermal Energy (HGEO)
  • Indian Energy Policy and Programs (IE)
  • Nuclear Energy (NE)
  • Other Energy Offices
    • Includes spending accounts that multiple offices draw from, such as Critical and Emerging Technologies  
  • Technology Commercialization (OTT)
  • Science (SC)

Congress appropriates funds to Treasury spending accounts, not to DOE offices. USAspending reports by account. DOE offices often draw on several accounts. In the spending and people (by office) datasets, EFIF has chosen to sort these accounts into DOE offices, manually aggregating them so that the data shown here represents the total amount of funding, staff, etc., that an office holds. EFIF based its mapping of accounts to offices on Congressional Budget Justifications released by DOE’s Chief Financial Officer. Download the full dataset and see the “DOE Offices and Accounts” for the full methodology.

The Projects data set includes over 17,000 DOE-issued awards with that have been active since FY 2017 or later. All data are sourced from USAspending.gov, the Treasury Department’s official federal spending transparency portal, except for cancellations data (see “award status” below). The data encompass grants, loans, and other financial assistance transactions issued by DOE.

Data Collection and Updates 

EFIF downloads award data from USAspending.gov’s Custom Award Download tool, extracting comprehensive information on each award, such as: 

  • Obligation and outlay amounts. 
  • Performance period start and end dates. 
  • Primary place of performance. 
  • Award descriptions and program activities. 
  • Funding office designation. 

To track changes over time, EFIF maintains a “prior obligations” column that reflects the original amount obligated to an award at the time of contract execution, if that number was later adjusted. The main obligations column contains the most current figure from our most recent data update.

Technology and Sector Categorization

Awards are categorized by technology type and end-use sector based on keyword analysis of three fields: award description, program activities, and funding office. EFIF recognizes that many awards incorporate multiple technologies or serve multiple end-use sectors. In cases where awards could fit multiple categories, we assign them based on the field with the highest number of relevant keyword matches. Awards that do not match any keywords are categorized manually. These classifications are not authoritative and are intended as a useful reference.

Award Status

EFIF classified awards as active, concluded, canceled, or not started yet. Active, concluded, and not started yet classifications are based on the performance period start and end dates. Performance period dates are disregarded for cancelled awards. EFIF only includes cancellations that have been publicly confirmed by DOE, a congressional committee, or recipient press releases. Recipient-initiated cancellations are not included in the canceled category and are categorized as concluded once the performance period end date is updated in USAspending.

Funding Office and Federal Accounts 

The funding office designation indicates which DOE office’s budget the award draws from, while the federal account number identifies the specific Treasury account used to fund the award. See the “federal account symbols” section below for more information.

The Spending and People (By Office) data sets provide office-level financial and workforce metrics for DOE’s science and energy innovation offices. Drawing on public federal data, these data sets bring together budget, workforce, and spending information to help users understand how resources are allocated and managed across DOE offices.

Data Sources

The primary data source for both datasets is USAspending.gov, specifically Form A and Form B. Two additional sources supply specific fields:

  • The Office of Management and Budget’s (OMB) annual technical supplement to the president’s budget request supplies the “requested budget” and “requested staff” fields.
  • Grants.gov supplies the “funding available” field, which reflects estimated program funding across DOE funding opportunity announcements by office and fiscal year.

Key Variables in These data Sets Include:

  • Total budgetary resources, which include new appropriations, unobligated carryover balances, and authority from offsetting collections. 
  • Full-time equivalent (FTE) staffing levels. 
  • Spending on advisory and assistance services. 
  • Other office-level financial and workforce metrics. 

Requested Budget and Requested Staff

These variables reflect what the administration asked Congress for in the next fiscal year’s budget but are stored in the row for the year the request was published. For example, the FY 2027 presidential budget request—released during FY 2026—appears in the FY 2026 row. This lets you compare, within a single row, what an office actually received versus what the administration subsequently requested for the following fiscal year.

Federal Account Symbols

These datasets are organized by federal account symbols, which correspond to Treasury accounts. Congress appropriates funding to Treasury accounts, which OMB then apportions to agencies. Treasury accounts often, but do not always, map directly to individual offices. Some accounts exist for multiple offices to spend from, such as the Energy Security and Infrastructure Modernization Fund. Most accounts are dedicated to a single office.

The People (By Occupation) data set draws on federal workforce data from the Office of Personnel Management (OPM). OPM publishes data covering the entire federal workforce; EFIF narrows this to DOE and summarizes the results by fiscal year and occupation type. OPM defines occupation type as job category that an employee’s position falls under based on the duties and required qualifications of the position. Unlike the three datasets discussed above, People (By Occupation) is DOE-wide, not just the science and energy innovation offices.

Scope and Coverage

This dataset includes full-time federal DOE employees across all offices, excluding National Nuclear Security Administration and Federal Energy Regulatory Commission. Because OPM’s source data does not identify individual DOE offices, EFIF reports this data at the departmental level only. Employment (headcount) data are benchmarked to September of each fiscal year. Hires and separations are reported monthly by OPM. EFIF totals hires and separations across all months within each fiscal year. Thus, headcount totals represent values at the end of each fiscal year while hires and separations represent the cumulative total across the fiscal year. Due to how separations and hires are processed by OPM, employment headcount differences from year to year may not equal reported total hires and/or separations numbers. See OPM release policy notes for additional information.

Key Variables

For each occupation type and fiscal year, the data set reports several metrics, including:

  • The number of career and political appointees at the end of the fiscal year.
  • Average length of service for current employees.
  • Total length of service for current employees.
  • The number of new hires across the fiscal year.
  • The total number of separations across the fiscal year.
  • Deferred Resignation Program (DRP) separations across the fiscal year.
  • Non-DRP separations across the fiscal year.

Note, length of service is defined by OPM as the number of years of federal civilian employment, creditable military service, and other service made creditable by specific legislation. OPM has stated on its federal workforce data webpage that it is still processing DRP separations, thus these values are subject to change.

Occupation Category

OPM lists approximately 200 occupation series. EFIF categorized these occupations into 15 categories based on OPM descriptions of both occupation series and occupation groups.

Note: position descriptions may not reflect actual day to day tasks – for example a physical scientist may be hired to perform program manager activities but is categorized by OPM as a physical scientist due to past experience and expertise. These categorizations reflect OPM data.

Accounting and Budgeting: Financial administration roles: Accounting, Accounting Technician, Auditing, Budget Analysis, Budget Clerical and Assistance, Civilian Pay, and related financial management/administration series.

  • Business Management, Operations, and Logistics: Operational and business-support roles: Appraising, Contracting, Financial Analysis, General Supply, Grants Management, Industrial Property Management, Insurance Examining, Inventory Management, Loan Specialist, Logistics Management, Procurement, Production Control, Property Disposal, Public Utilities Specialist, Purchasing, Realty, and Supply-related series.
  • Construction, Facilities, and Maintenance: Skilled trades and facilities upkeep: Air Conditioning Equipment Mechanic, Building Management, Carpentry, Electrical/Electronic Equipment Repair and Mechanic series, Engineering Equipment Operating, Facility Operations Services, Food Services, Information Technology Management, Laboring, Librarian/Library Technician, Machining, Maintenance Mechanic, Materials Handler, Painting, Plumbing, Printing Services, Quality Assurance, Rigging, Sheet Metal Mechanic, and Welding.
  • Engineering and Architecture: Technical engineering disciplines: Aerospace, Architecture, Chemical, Civil, Computer, Construction Control Technical, Electrical, Electronics, Engineering Technical, Environmental, Fire Protection, General Engineering, Industrial, Materials, Mechanical, Mining, Nuclear, Petroleum, and Safety Engineering.
  • General Administrative and Program Management: Broad administrative and program-support functions: Administration and Office Support Student Trainee, Administrative Officer, Community Planning, Emergency Management Specialist, Government Information Specialist, Management and Program Analysis, Miscellaneous Administration and Program, Program Management, Security Administration, Support Services Administration, and Telecommunications.
  • Human Resources: Personnel-related roles: Equal Employment Opportunity, Human Resources Assistance, Human Resources Management (and its student trainee track), and Workforce Development.
  • Legal: Legal and compliance functions: Administrative Law Judge, Aviation Safety, Copyright and Patent Student Trainee, Criminal Investigation, General Attorney, Inspection/Investigation/Enforcement/Compliance series, Investigative Analysis, Law Clerk, Legal Assistance, Legal Instruments Examining, Mine Safety and Health Inspection, Paralegal Specialist, and Patent Attorney.
  • Mathematics, Statistics, and Data Science: Quantitative analysis roles: Actuarial Science, Computer Science, Data Science Series, General Mathematics and Statistics, Mathematical Statistics, Mathematics, Operations Research, and Statistics.
  • Medical, Hospital, Dental, and Public Health: Health-related roles: General Health Science, Health System Administration/Specialist, Industrial Hygiene, Medical Officer, Nurse, and Safety and Occupational Health Management.
  • Office Services: Clerical and administrative support: Computer Clerk and Assistant, Mail and File, Management and Program Clerical and Assistance, Miscellaneous Clerk and Assistant, Office Automation Clerical and Assistance, Records and Information Management, Secretary, and Security Clerical and Assistance.
  • Physical and Biological Sciences: Natural science disciplines: Biological Science Student Trainee, Cartography, Chemistry, Ecology, Environmental Protection, Fish and Wildlife Administration/Biology, Forestry, Geology, Health Physics, Hydrology, Land Surveying, Metallurgy, Meteorology, Microbiology, Physical Science, Physics, Survey Technical, and Toxicology.
  • Social Science, Psychology & Education: Social science, education, and communications roles: Archeology, Economist, Education and Training, Foreign Affairs, Geography, History, Instructional Systems, Intelligence, Interior Design, International Relations, Psychology, Public Affairs, Social Science, Technical Information/Writing, Training Instruction, and Visual Information.
  • Transportation and Mobile Equipment : Vehicle and equipment operation: Aircraft Mechanic, Aircraft Operation, Heavy Mobile Equipment Mechanic, Misc Transportation/Mobile Equipment Operation, Motor Vehicle Operating, Traffic Management, Transportation Clerk and Assistant, and Transportation Specialist.
  • Invalid: Invalid. Reflects OPM data limitations.

Appointment Type

OPM reports a total of 17 different appointment types. EFIF aggregated these into three categories: career political, and other.

“Career” includes career (competitive service permanent), career (senior executive service permanent), career-conditional (competitive service permanent), executive (excepted service permanent), nonpermanent (competitive service nonpermanent), schedule policy/career (permanent), and Schedule B (excepted service permanent). 

“Political” includes executive (excepted service nonpermanent), limited term (senior executive service nonpermanent), noncareer (senior executive service permanent), and Schedule C (excepted service nonpermanent). 

“Other” includes other (excepted service nonpermanent), other (excepted service permanent), Schedule D (excepted service nonpermanent), Schedule A (excepted service nonpermanent), Schedule A (excepted service permanent, Schedule D (excepted service permanent), and invalid.