Vehicle Number

Vehicle Number 7527 / 75H71121D00001 Federal Contract Action Summary (Last 5 Years)

Federal procurement summary for vehicle number 75H71121D00001 under agency ID 7527 over the last 5 years.

This page presents obligation and action data for vehicle number 75H71121D00001 for agency ID 7527 across the last 5 years. The record shows 11 award actions with total obligated amounts of $116,554,297.12.

Generated at 03/21/2026

Analysis period: Last 5 years

Total obligated is shown as both the exact amount and a readable rounded figure; average action value is $10,595,845.19.

Agency ID
7527
PIID
75H71121D00001
Type
Vehicle
Total Obligated
116.55 million
116,554,297.12
Actions
11
Average Action Value
10,595,845.19

Overview

Over the last 5 years, vehicle number 75H71121D00001 recorded 11 award actions tied to agency ID 7527. Total obligated funding for the period is $116,554,297.12, with an average action value of $10,595,845.19.

How to use this page

Use this page to review the procurement footprint for this vehicle record by agency and time window. The figures support quick comparison of total obligation, action count, and average action value.

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 = '75H71121D00001'
    AND content__IDV__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
    AND content__IDV__purchaserInformation__contractingOfficeAgencyID != ''
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 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 116,554,297.12 116.55 million 11

Insight

Over the 5-year window, obligations under PIID 75H71121D00001 are fully concentrated within a single agency: Indian Health Service (agency ID 7527). Indian Health Service accounts for 11 awards totaling $116.55 million, indicating exclusive agency-level concentration for this vehicle in the provided 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__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 = '75H71121D00001'
        AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
        AND content__award__vendor__vendorHeader__vendorName != ''
        AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 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 = '75H71121D00001'
    AND content__IDV__productOrServiceInformation__principalNAICSCode IS NOT NULL
    AND content__IDV__productOrServiceInformation__principalNAICSCode != ''
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 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
325413 IN-VITRO DIAGNOSTIC SUBSTANCE MANUFACTURING 116,554,297.12 116.55 million 11

Insight

Obligations under PIID 75H71121D00001 are fully concentrated in NAICS 325413, In-Vitro Diagnostic Substance Manufacturing, over the 5-year window. This category accounts for $116.55 million across 11 awards, indicating a narrow procurement profile focused on a single product/service area. The absence of additional NAICS categories suggests limited industry diversification within this vehicle.

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 = '75H71121D00001'
    AND content__IDV__productOrServiceInformation__productOrServiceCode IS NOT NULL
    AND content__IDV__productOrServiceInformation__productOrServiceCode != ''
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 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
6550 IN VITRO DIAGNOSTIC SUBSTANCES, REAGENTS, TEST KITS AND SETS 116,554,297.12 116.55 million 11

Insight

Within the 5-year window, vehicle PIID 75H71121D00001 shows complete obligation concentration in PSC 6550, In Vitro Diagnostic Substances, Reagents, Test Kits and Sets. Total obligations for this PSC are $116.55 million across 11 awards, indicating repeated use of the vehicle for a single product/service category rather than a diversified spend profile.

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 = '75H71121D00001'
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC
Year Total Obligated Readable Actions
2021 58,277,194.00 58.28 million 5
2022 58,277,103.12 58.28 million 6

Insight

Obligations for PIID 75H71121D00001 were essentially flat across the two reported years, holding at about $58.28 million in both 2021 and 2022. Award activity increased from 5 to 6 awards, indicating slightly greater distribution of obligations without a material change in total funded value. This pattern suggests a stable vehicle with limited year-to-year variation in obligation concentration.

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.