Federal Spending & Obligations Intelligence

Executive Summary

DoD prime contract obligations increased materially across the five-year window in nominal dollars. The API-derived total rose from $387.0B in FY2021 to $491.7B in FY2025, an increase of $104.7B or 27.1%.

The pattern is concentrated, but not in a single dimension. The Navy, Army, and Air Force together represented 77.1% of nominal-dollar obligations; major aircraft, shipbuilding, engineering, pharmaceutical, and healthcare categories were also prominent.

Year-end timing warrants context-aware monitoring. September represented a median 14.8% of annual obligations, while the fourth fiscal quarter represented a median 29.9%. This is a planning and oversight question—not evidence of improper spending.

Business Question

How have Department of Defense contract obligations changed across recent completed fiscal years, which agencies and award categories drive the change, and where does spending concentration create planning or oversight questions?

The analysis is descriptive and decision-support oriented. It does not assess contract performance, necessity, legality, waste, fraud, or abuse.

Project Context

Client data and screenshots are confidential. This project reconstructs comparable analytical methods—source acquisition, classification, reconciliation, concentration analysis, data-quality testing, and executive communication—using public federal spending data in a distinct context.

Provenance and Confidentiality

Independent public-data reconstruction. This is not the original client deliverable and contains no client or employer data. It demonstrates comparable analytical methods in a different public context.

Provenance

ORIGINAL INDEPENDENT ANALYSIS

Data exposure

PUBLIC

Relationship to experience

DEMO-SAFE METHODOLOGY RECONSTRUCTION

Evidence level

FULLY REPRODUCIBLE

My Role

Independent analyst, data engineer, modeler, validator, and case-study author.

I defined the analytical question, reviewed the official endpoint documentation, created the retrieval and transformation pipeline, wrote and executed the SQL quality checks, validated the findings, and designed the reader-facing case study.

Data Source

The controlling source is the official USAspending API v2. Endpoints require no API key. Data was retrieved on 2026-08-15, and the API reported its award data last updated on 08/14/2026.

USAspending data is available for copying, adaptation, redistribution, and commercial or non-commercial use, subject to the site's stated limitations.

Data Scope

Period

FY2021-FY2025

Calendar bounds

October 1, 2020-September 30, 2025

Awarding agency

Department of Defense, top-tier code 097

Award types

A, B, C, D — prime contracts

Measure

Federal action obligations in nominal dollars

Core rows

5 annual · 60 monthly · 24 subagencies · 2,446 PSC · 1,083 NAICS · 57 geographies

FY2026 was excluded because it was incomplete on the retrieval date. All growth and period comparisons therefore use complete fiscal years and nominal dollars.

Data Quality Problems

Technical Architecture

USAspending API v2 → raw response cache → Python transformation → curated CSV outputs → SQLite staging and marts → automated quality checks → static JSON snapshot → accessible Next.js case study

Method

1. Filtered prime contract transactions to DoD awarding activity and award type codes A-D.
2. Excluded the incomplete current fiscal year and compared FY2021-FY2025 only.
3. Reconciled annual totals to 60 fiscal-month aggregates and to complete subagency category totals.
4. Measured year-over-year change, subagency and recipient concentration, PSC and NAICS mix, place-of-performance geography, and year-end timing.
5. Generated findings only after the Python transformation and SQLite quality checks passed.

Recipient names were normalized and identical names combined within the top-100 API subset. No corporate-parent relationships were inferred.

Key Findings

1. 01

   DoD contract obligations increased 27.1% from FY2021 to FY2025, a net change of $104.7B.

2. 02

   The series rose through FY2023, declined 2.4% in FY2024, then reached a five-year high in FY2025.

3. 03

   The three largest awarding subagencies accounted for 77.1% of five-year contract obligations in nominal dollars.

4. 04

   The ten largest normalized recipient names in the top-100 API subset represented 27.9% of total obligations.

5. 05

   September represented a median 14.8% of annual obligations; the fourth fiscal quarter represented a median 29.9%.

End-of-fiscal-year pattern

September's share increased in FY2024 and FY2025, reaching 18.8% in FY2025. The pattern should be paired with program, acquisition, funding, and execution context before any operational conclusion.

Recommendations

1. Use a repeatable annual and monthly monitoring view to separate structural changes from one-period variation.
2. Review subagency, recipient, product/service, and geography concentration together before forming a planning conclusion.
3. Treat September and fourth-quarter concentration as a planning question that needs program context—not as evidence of improper spending.
4. Maintain visible classification and reconciliation checks so unclassified or non-state amounts cannot silently disappear from analysis.

Impact

• Quantified five complete fiscal years of DoD prime contract obligations.
• Surfaced the agencies, recipients, contract categories, geographies, and fiscal periods that drive concentration.
• Created a repeatable retrieval, transformation, validation, and publishing process.
• This independent case study produced decision-support recommendations; implementation impact was not measured.

Limitations

• USAspending data is updated and may be revised after retrieval.
• Obligations are transaction-level net obligations and can include deobligations.
• Recipient results identify profiles/legal entities and are not a definitive corporate-parent rollup.
• Geography uses place of performance at state/territory level and excludes non-state foreign or unclassified amounts from the displayed state ranking.
• The API does not represent internal DoD accounting statuses such as unliquidated or undelivered obligations.

Amounts are descriptive nominal-dollar obligations. This work does not evaluate inflation-adjusted purchasing power, contract performance, program outcomes, appropriations law, or internal DoD accounting status.

What I Would Improve

• Add a governed corporate-parent entity-resolution layer while preserving the original recipient profile.
• Extend the dataset with award-level detail for distribution and deobligation analysis.
• Add inflation-adjusted comparisons and program context when those sources can be reconciled safely.
• Automate scheduled retrieval with change detection for revised historical data.

Technical Evidence

The downloadable bundle contains the executed Python pipeline, SQL staging and mart logic, quality checks, curated data, extraction manifest, summary, findings, executed notebook, and validation report.

The website renders from a static reviewed snapshot. A USAspending outage does not break this page.

Data Attribution

Source: USAspending.gov, U.S. Department of the Treasury, Bureau of the Fiscal Service. API accessed 2026-08-15. Award data last updated 08/14/2026.

This independent analysis is not endorsed by the Department of Defense, Department of the Treasury, USAspending, Deloitte, or any other organization.

Related Capabilities

View all portfolio projects →