This page summarizes federal procurement activity for award number HT940223C0001 under agency ID 9700. The record covers the last 5 years and shows total obligated amount of 5,769,980,153.3 across 157 award actions.
Award Number
Award Number 9700 / HT940223C0001 Federal Contract Action Summary (Last 5 Years)
Award number HT940223C0001 for agency 9700 shows obligations of 5.77 billion across 157 actions in the last 5 years.
Totals reflect the provided analysis window and may differ from rounded display values used elsewhere on the page.
Overview
For the last 5 years, award number HT940223C0001 under agency ID 9700 accounts for 5,769,980,153.3 in total obligated value. That activity spans 157 actions, with an average action value of 36,751,465.94. The page is intended to support review of obligation magnitude and action frequency for this award.
How to use this page
Use this page to review the scale and cadence of procurement activity tied to HT940223C0001. The obligation total, action count, and average action value provide a compact basis for comparison with other awards or for checking changes over the selected period.
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 = 'HT940223C0001'
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) | 5,769,980,153.30 | 5.77 billion | 157 |
Insight
Within the 5-year window for award HT940223C0001, obligations are concentrated entirely in the Defense Health Agency (DHA), with 157 awards totaling $5.77 billion. This indicates a highly concentrated agency footprint rather than a distributed obligation pattern across multiple agencies. The volume of awards alongside the obligation level suggests sustained activity within DHA during the period.
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 = 'HT940223C0001'
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 |
|---|---|---|---|---|
| HUMANA GOVERNMENT BUSINESS, INC. | 050S0 | 5,769,980,153.30 | 5.77 billion | 157 |
Insight
Over the 5-year window, HUMANA GOVERNMENT BUSINESS, INC. (CAGE 050S0) accounts for $5.77 billion across 157 awards under PIID HT940223C0001, indicating very high vendor concentration. The obligation profile is materially concentrated in a single vendor relationship rather than broadly distributed across multiple suppliers. This pattern suggests sustained reliance on one contractor for a large share of obligated value in this award record.
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 = 'HT940223C0001'
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 | 5,769,980,153.30 | 5.77 billion | 157 |
Insight
For award HT940223C0001 over the 5-year window, obligations are fully concentrated in NAICS 524114, Direct Health and Medical Insurance Carriers. This single NAICS accounts for $5.77 billion across 157 awards, indicating a highly focused procurement profile with no observed diversification in the provided rows.
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 = 'HT940223C0001'
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- MANAGED HEALTHCARE | 5,760,347,641.37 | 5.76 billion | 153 |
| Q201 | MEDICAL- GENERAL HEALTH CARE | 9,632,511.93 | 9.63 million | 4 |
Insight
Obligations on this award are overwhelmingly concentrated in PSC Q201, with $5.76 billion across 153 actions under MEDICAL- MANAGED HEALTHCARE. A much smaller $9.63 million is recorded under the same PSC code description, MEDICAL- GENERAL HEALTH CARE, across 4 actions. Over the 5-year window, the award is therefore highly concentrated in a single PSC category, with limited distribution to the secondary PSC entry.
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 = 'HT940223C0001'
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 |
|---|---|---|---|
| 2022 | 3,210,837.31 | 3.21 million | 1 |
| 2024 | 341,733,269.81 | 341.73 million | 79 |
| 2025 | 5,425,036,046.18 | 5.43 billion | 77 |
Insight
Obligations for PIID HT940223C0001 are highly concentrated in the later years of the 5-year window. Activity increased from 1 award and $3.21 million in 2022 to 79 awards and $341.73 million in 2024, then rose sharply again in 2025 to 77 awards and $5.43 billion. The pattern indicates a pronounced shift in funding volume, with 2025 accounting for the dominant share of obligated dollars despite a similar award count to 2024.
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.