This award page summarizes procurement activity for award number HT940221C0007 under agency ID 9700. In the last 5 years, the award recorded 94 actions and $1,832,188,050.37 in total obligated amount.
Award Number
Award Number 9700 / HT940221C0007 Federal Contract Action Summary (Last 5 Years)
Award number HT940221C0007 for agency 9700 shows 94 recorded actions over the last 5 years with total obligations of $1.83 billion.
Totals reflect the stated 5-year analysis window and the exact obligated amount provided for this award.
Overview
Award number HT940221C0007 is associated with agency ID 9700 and shows procurement activity concentrated within the last 5 years. The award totals $1,832,188,050.37 in obligations across 94 actions, with an average action value of $19,491,362.24. These figures provide a compact view of the award's recorded activity and spending level.
How to use this page
Use this page to review the award's obligation history, action volume, and average action value at a glance. The summary supports basic FPDS-style analysis by tying the award number to a defined agency and a fixed analysis window.
Top Agencies
SELECT
content__award__purchaserInformation__contractingOfficeAgencyID AS agency_id,
content__award__purchaserInformation__contractingOfficeAgencyID__name AS agency_name,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count,
formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
content__award__awardID__awardContractID__agencyID = '9700' AND content__award__awardID__awardContractID__PIID = 'HT940221C0007'
AND content__award__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
AND content__award__purchaserInformation__contractingOfficeAgencyID != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
agency_id,
agency_name
ORDER BY total_obligated DESC
LIMIT 10
| Agency ID | Agency Name | Total Obligated | Readable | Actions |
|---|---|---|---|---|
| 97DH | DEFENSE HEALTH AGENCY (DHA) | 1,832,188,050.37 | 1.83 billion | 94 |
Insight
Over the 5-year window, obligations for PIID HT940221C0007 are fully concentrated within a single top agency, the Defense Health Agency (DHA). DHA accounts for $1.83 billion across 94 awards, indicating both substantial spend and repeated use of this award relationship. With no other agencies listed in the provided rows, the distribution is entirely concentrated in DHA.
Top Vendors
SELECT
vendor_name,
cage_code,
total_obligated,
award_count,
formatReadableQuantity(total_obligated) AS total_obligated_readable
FROM
(
SELECT
content__award__vendor__vendorHeader__vendorName AS vendor_name,
ifNull(content__award__vendor__vendorSiteDetails__entityIdentifiers__cageCode, '') AS cage_code,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count
FROM fpds.data
WHERE
content__award__awardID__awardContractID__agencyID = '9700' AND content__award__awardID__awardContractID__PIID = 'HT940221C0007'
AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
AND content__award__vendor__vendorHeader__vendorName != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
vendor_name,
cage_code
)
ORDER BY total_obligated DESC
LIMIT 10
| Vendor | CAGE Code | Total Obligated | Readable | Actions |
|---|---|---|---|---|
| EXPRESS SCRIPTS, INC. | 1WPW1 | 1,687,096,177.99 | 1.69 billion | 85 |
| EVERNORTH FEDERAL SERVICES INC | 0Q6S3 | 145,091,872.38 | 145.09 million | 9 |
Insight
Within the 5-year window for award HT940221C0007, obligations are highly concentrated with EXPRESS SCRIPTS, INC. (CAGE 1WPW1) accounting for 1.69 billion across 85 awards. EVERNORTH FEDERAL SERVICES INC (CAGE 0Q6S3) is a distant second at 145.09 million across 9 awards, indicating a pronounced funding gap between the top vendor and the next largest recipient. This distribution suggests the award is heavily concentrated with one vendor rather than broadly distributed across suppliers.
Top NAICS
SELECT
content__award__productOrServiceInformation__principalNAICSCode AS naics_code,
content__award__productOrServiceInformation__principalNAICSCode__description AS naics_name,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count,
formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
content__award__awardID__awardContractID__agencyID = '9700' AND content__award__awardID__awardContractID__PIID = 'HT940221C0007'
AND content__award__productOrServiceInformation__principalNAICSCode IS NOT NULL
AND content__award__productOrServiceInformation__principalNAICSCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
naics_code,
naics_name
ORDER BY total_obligated DESC
LIMIT 10
| NAICS Code | Description | Total Obligated | Readable | Actions |
|---|---|---|---|---|
| 524114 | DIRECT HEALTH AND MEDICAL INSURANCE CARRIERS | 1,832,188,050.37 | 1.83 billion | 94 |
Insight
For PIID HT940221C0007 over the 5-year window, all reported obligations are concentrated in NAICS 524114, Direct Health and Medical Insurance Carriers. This NAICS accounts for $1.83 billion across 94 awards, indicating a highly focused obligation pattern with no distribution across additional NAICS codes in the provided data.
Top PSC Codes
SELECT
content__award__productOrServiceInformation__productOrServiceCode AS psc_code,
content__award__productOrServiceInformation__productOrServiceCode__description AS psc_name,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count,
formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
content__award__awardID__awardContractID__agencyID = '9700' AND content__award__awardID__awardContractID__PIID = 'HT940221C0007'
AND content__award__productOrServiceInformation__productOrServiceCode IS NOT NULL
AND content__award__productOrServiceInformation__productOrServiceCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
psc_code,
psc_name
ORDER BY total_obligated DESC
LIMIT 10
| PSC Code | Description | Total Obligated | Readable | Actions |
|---|---|---|---|---|
| Q201 | MEDICAL- GENERAL HEALTH CARE | 1,039,380,089.32 | 1.04 billion | 36 |
| Q201 | MEDICAL- MANAGED HEALTHCARE | 792,807,961.05 | 792.81 million | 58 |
Insight
Award activity is concentrated in PSC Q201, with $1.04 billion obligated across 36 awards for Medical- General Health Care and $792.81 million obligated across 58 awards for Medical- Managed Healthcare. The two PSC entries together account for the full activity reflected here, indicating a strong focus on health care-related services within the five-year window. The higher obligation tied to the first Q201 category despite fewer awards suggests larger average award values in that segment.
Annual Trend
SELECT
toYear(parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate)) AS year,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable,
count() AS award_count
FROM fpds.data
WHERE
content__award__awardID__awardContractID__agencyID = '9700' AND content__award__awardID__awardContractID__PIID = 'HT940221C0007'
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC
| Year | Total Obligated | Readable | Actions |
|---|---|---|---|
| 2021 | 23,596,175.00 | 23.60 million | 1 |
| 2022 | 82,423,926.26 | 82.42 million | 8 |
| 2023 | 598,725,181.36 | 598.73 million | 18 |
| 2024 | 577,236,490.78 | 577.24 million | 35 |
| 2025 | 550,206,276.97 | 550.21 million | 32 |
Insight
Obligations for PIID HT940221C0007 increased sharply from 23.60 million across 1 award in 2021 to 82.42 million across 8 awards in 2022, then expanded to 598.73 million across 18 awards in 2023. Funding remained elevated but eased slightly in 2024 and 2025, with 577.24 million across 35 awards and 550.21 million across 32 awards, respectively. The pattern indicates a major step-up in obligation volume beginning in 2023, with later years characterized by a higher award count but somewhat lower total obligations than the 2023 peak.
Use FPDS Query for deeper award and vehicle analysis
Explore federal procurement data with custom SQL, fast filtering, and deeper contract action analysis across agencies, vendors, NAICS, PSC, and annual trends.
Continue from this last 5 years view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.