This page summarizes award HT940223C0001 for agency ID 9700 across the last 10 years. It shows 157 award actions with total obligated amount of 5.77 billion dollars.
Award Number
Award Number 9700 / HT940223C0001 Federal Contract Action Summary (Last 10 Years)
Federal procurement summary for award number HT940223C0001 under agency ID 9700, showing obligations and action activity over the last 10 years.
Total obligated exact is 5769980153.3 and the average action value is 36751465.94.
Overview
Award HT940223C0001 has 157 recorded actions in the last 10 years, with total obligated funding of 5,769,980,153.3. The average action value is 36,751,465.94, indicating repeated activity across the analysis window.
How to use this page
Use this page to review obligation totals and action volume for award HT940223C0001 under agency ID 9700. It provides a concise starting point for FPDS review, spending analysis, and comparison against other awards in the same 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 10 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
For this award over the 10-year window, obligations are fully concentrated within a single top agency: the Defense Health Agency (DHA). DHA accounts for $5.77 billion across 157 awards, indicating that this contract is tied to a highly concentrated agency relationship rather than a broad distribution across multiple agencies.
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 10 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
HUMANA GOVERNMENT BUSINESS, INC. is the sole top vendor identified for this award over the 10-year window, with 157 awards totaling $5.77 billion. Obligations are fully concentrated with one vendor, indicating a highly concentrated vendor profile rather than a distributed award base. This level of concentration suggests sustained reliance on a single contractor for the cited award activity.
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 10 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
Obligations for award HT940223C0001 over the 10-year window are fully concentrated in NAICS 524114, Direct Health and Medical Insurance Carriers. This NAICS accounts for $5.77 billion across 157 awards, indicating a highly concentrated spending pattern within a single industry classification. No other NAICS codes are reflected in the provided data, so the observed distribution is entirely focused on this sector.
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 10 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 under this award are overwhelmingly concentrated in PSC Q201, Medical- Managed Healthcare, which accounts for $5.76 billion across 153 awards. A much smaller amount, $9.63 million across 4 awards, is classified under PSC Q201, Medical- General Health Care. This distribution indicates that the award’s obligated spending over the 10-year window is almost entirely tied to managed healthcare services, with limited activity in the general health care category.
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 10 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 2025, which accounts for 5.43 billion across 77 awards and materially exceeds prior years. In 2024, activity remains substantial at 341.73 million across 79 awards, while 2022 is limited to a single award totaling 3.21 million. This pattern indicates a sharp escalation in obligated value over the period, with recent years driving nearly all observable activity.
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 10 years view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.