Vehicle Number

Vehicle Number 7527 / HHSI236201500003C Federal Contract Action Summary (Last 10 Years)

Procurement history for vehicle number HHSI236201500003C under agency ID 7527 over the last 10 years.

This page summarizes obligation activity tied to vehicle number HHSI236201500003C for agency ID 7527. The record shows 19 award actions with total obligated amounts of 63.41 million.

Last full year Last 5 years Last 10 years

Generated at 03/21/2026

Analysis period: Last 10 years

Totals reflect the last 10 years and the exact obligated amount is 63,414,636.9 across 19 actions.

Agency ID

7527

PIID

HHSI236201500003C

Type

Vehicle

Total Obligated

63.41 million

63,414,636.90

Actions

Average Action Value

3,337,612.47

Overview

The procurement record for vehicle number HHSI236201500003C shows 19 award actions across the last 10 years. Total obligated amount is 63,414,636.9, with an average action value of 3,337,612.47. This page is intended to support review of obligation volume and action frequency for agency ID 7527.

How to use this page

Use this page to review the overall scale of awards associated with vehicle number HHSI236201500003C. The combination of total obligated amount, action count, and average action value provides a concise basis for comparing this record with other procurement entries.

Top Agencies

SELECT
    content__IDV__purchaserInformation__contractingOfficeAgencyID AS agency_id,
    content__IDV__purchaserInformation__contractingOfficeAgencyID__name AS agency_name,
    sum(content__IDV__dollarValues__obligatedAmount) AS total_obligated,
    count() AS award_count,
    formatReadableQuantity(sum(content__IDV__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
    content__IDV__contractID__IDVID__agencyID = '7527' AND content__IDV__contractID__IDVID__PIID = 'HHSI236201500003C'
    AND content__IDV__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
    AND content__IDV__purchaserInformation__contractingOfficeAgencyID != ''
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 YEAR
    AND parseDateTimeBestEffortOrNull(content__IDV__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
7527	INDIAN HEALTH SERVICE	63,414,636.90	63.41 million	19

Insight

Over the 10-year window, obligations for PIID HHSI236201500003C are fully concentrated within a single top agency: the Indian Health Service (Agency ID 7527). This agency accounts for $63.41 million across 19 awards, indicating that the vehicle’s activity is entirely concentrated with one buyer rather than distributed 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__IDV__dollarValues__obligatedAmount) AS total_obligated,
        count() AS award_count
    FROM fpds.data
    WHERE
        content__IDV__contractID__IDVID__agencyID = '7527' AND content__IDV__contractID__IDVID__PIID = 'HHSI236201500003C'
        AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
        AND content__award__vendor__vendorHeader__vendorName != ''
        AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 YEAR
        AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
    GROUP BY
        vendor_name,
        cage_code
)
ORDER BY total_obligated DESC
LIMIT 10

Vendor	CAGE Code	Total Obligated	Readable	Actions

Insight

No vendor concentration was available for this analysis window.

Top NAICS

SELECT
    content__IDV__productOrServiceInformation__principalNAICSCode AS naics_code,
    content__IDV__productOrServiceInformation__principalNAICSCode__description AS naics_name,
    sum(content__IDV__dollarValues__obligatedAmount) AS total_obligated,
    count() AS award_count,
    formatReadableQuantity(sum(content__IDV__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
    content__IDV__contractID__IDVID__agencyID = '7527' AND content__IDV__contractID__IDVID__PIID = 'HHSI236201500003C'
    AND content__IDV__productOrServiceInformation__principalNAICSCode IS NOT NULL
    AND content__IDV__productOrServiceInformation__principalNAICSCode != ''
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 YEAR
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
    naics_code,
    naics_name
ORDER BY total_obligated DESC
LIMIT 10

NAICS Code	Description	Total Obligated	Readable	Actions
524291	CLAIMS ADJUSTING	63,414,636.90	63.41 million	19

Insight

Obligations for this vehicle are concentrated in NAICS 524291, Claims Adjusting, which accounts for the full observed total of $63.41 million across 19 awards. This indicates a narrow functional focus with no evidence of diversification across other NAICS codes in the provided 10-year window. The award count suggests repeated use within the same industry category rather than broad distribution across multiple sectors.

Top PSC Codes

SELECT
    content__IDV__productOrServiceInformation__productOrServiceCode AS psc_code,
    content__IDV__productOrServiceInformation__productOrServiceCode__description AS psc_name,
    sum(content__IDV__dollarValues__obligatedAmount) AS total_obligated,
    count() AS award_count,
    formatReadableQuantity(sum(content__IDV__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
    content__IDV__contractID__IDVID__agencyID = '7527' AND content__IDV__contractID__IDVID__PIID = 'HHSI236201500003C'
    AND content__IDV__productOrServiceInformation__productOrServiceCode IS NOT NULL
    AND content__IDV__productOrServiceInformation__productOrServiceCode != ''
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 YEAR
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
    psc_code,
    psc_name
ORDER BY total_obligated DESC
LIMIT 10

PSC Code	Description	Total Obligated	Readable	Actions
R710	SUPPORT- MANAGEMENT: FINANCIAL	63,414,636.90	63.41 million	19

Insight

Obligations for PIID HHSI236201500003C are concentrated in a single PSC, R710 (Support- Management: Financial), which accounts for 63.41 million across 19 awards over the 10-year window. This indicates a narrow distribution of activity within the vehicle, with all reported obligations attributed to one service category. The concentration suggests this vehicle has been used primarily for financial management support services rather than a diversified mix of PSCs.

Annual Trend

SELECT
    toYear(parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate)) AS year,
    sum(content__IDV__dollarValues__obligatedAmount) AS total_obligated,
    formatReadableQuantity(sum(content__IDV__dollarValues__obligatedAmount)) AS total_obligated_readable,
    count() AS award_count
FROM fpds.data
WHERE
    content__IDV__contractID__IDVID__agencyID = '7527' AND content__IDV__contractID__IDVID__PIID = 'HHSI236201500003C'
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 YEAR
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC

Year	Total Obligated	Readable	Actions
2016	13,006,917.00	13.01 million	3
2017	13,547,490.38	13.55 million	3
2018	14,285,495.60	14.29 million	5
2019	14,462,036.98	14.46 million	4
2020	8,120,541.30	8.12 million	3
2025	-7,844.36	-7.84 thousand	1

Insight

Obligations for PIID HHSI236201500003C were concentrated in FY2016-FY2019, with annual totals ranging from $13.01 million to $14.46 million across 3 to 5 awards per year. Funding declined sharply in FY2020 to $8.12 million, about 44 percent below FY2019, indicating a material contraction in annual activity. The only later reported year, FY2025, shows a small negative obligation of $7.84 thousand on one award, which is likely an adjustment rather than a substantive spending level.

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.

Start 7-Day Trial Learn More