This page summarizes award number HT940212C0001 for agency ID 9700 over the last 10 years. It shows 402 award actions with total obligated amount of 5.82 billion and an average action value of 14,465,365.18.
Award Number
Award Number 9700 / HT940212C0001 Federal Contract Action Summary (Last 10 Years)
Federal procurement summary for award number HT940212C0001 under agency ID 9700, covering the last 10 years of recorded actions and obligations.
Obligated totals are shown as both a rounded readable figure and the exact value of 5815076801.4.
Agency ID
9700
PIID
HT940212C0001
Type
Award
Total Obligated
5.82 billion
5,815,076,801.40
Actions
402
Average Action Value
14,465,365.18
Overview
The record for award number HT940212C0001 in agency ID 9700 shows 402 actions across the last 10 years. Total obligated funding equals 5,815,076,801.4, with an average action value of 14,465,365.18. This page is intended to support review of obligation volume and action frequency for the award.
How to use this page
Use this page to review the award’s obligation totals, action count, and average action value within the selected time window. It is useful for comparing this award’s activity against other procurement records in the same agency context.
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 = 'HT940212C0001'
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,815,076,801.40 | 5.82 billion | 402 |
Insight
For this award over the 10-year window, obligation activity is fully concentrated within one top agency: Defense Health Agency (DHA). DHA accounts for 402 awards and $5.82 billion in total obligated value, indicating both high transaction volume and dominant funding concentration under this PIID. No other agencies are present in the provided rows, so agency distribution is not diversified in the observed data.
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 = 'HT940212C0001'
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 |
|---|---|---|---|---|
| UNITEDHEALTH MILITARY & VETERANS SERVICES, LLC | 3,168,943,585.25 | 3.17 billion | 227 | |
| UNITEDHEALTH MILITARY & VETERANS SERVICES, LLC | 53JY0 | 2,646,133,216.15 | 2.65 billion | 175 |
Insight
Obligations for this award are highly concentrated in one vendor entity, UNITEDHEALTH MILITARY & VETERANS SERVICES, LLC, which accounts for $3.17 billion across 227 awards in the 10-year window. The same vendor also appears under CAGE 53JY0 with $2.65 billion across 175 awards, indicating a substantial share of obligated dollars is concentrated within a single contractor despite separate vendor identifiers. This pattern suggests strong award dependence on one provider rather than a broad vendor distribution.
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 = 'HT940212C0001'
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,815,076,801.40 | 5.82 billion | 402 |
Insight
Over the 10-year window, obligations for award HT940212C0001 under agency 9700 are fully concentrated in NAICS 524114, Direct Health and Medical Insurance Carriers. This NAICS accounts for $5.82 billion across 402 awards, indicating a highly focused procurement pattern with no diversification across other 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 = 'HT940212C0001'
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- GENERAL HEALTH CARE | 5,815,076,801.40 | 5.82 billion | 402 |
Insight
Obligations for PIID HT940212C0001 are fully concentrated in PSC Q201, Medical - General Health Care, totaling $5.82 billion across 402 awards over the 10-year window. This indicates a highly focused procurement profile with no evidence of PSC diversification in the provided data. The average obligation per award is substantial, consistent with a large health care-related acquisition pattern.
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 = 'HT940212C0001'
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 |
|---|---|---|---|
| 2016 | 3,155,647,633.59 | 3.16 billion | 199 |
| 2017 | 2,408,978,071.39 | 2.41 billion | 147 |
| 2018 | 221,157,038.93 | 221.16 million | 50 |
| 2019 | 29,294,057.49 | 29.29 million | 6 |
Insight
Obligations for PIID HT940212C0001 were highly concentrated in 2016 and 2017, totaling 3.16 billion and 2.41 billion across 199 and 147 awards, respectively. Activity then declined sharply in 2018 to 221.16 million across 50 awards and fell further in 2019 to 29.29 million across 6 awards. This pattern indicates a steep reduction in both obligated dollars and award volume over the period provided.
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.