Vehicle Number

Vehicle Number 7523 / HHSD200201689087I Federal Contract Action Summary (Last 10 Years)

Procurement summary for vehicle number under agency 7523, covering PIID HHSD200201689087I over the last 10 years.

This page summarizes award activity tied to vehicle number for PIID HHSD200201689087I. Over the last 10 years, the record shows 11 award actions with total obligated dollars of 1.10 billion.

Last full year Last 5 years Last 10 years

Generated at 03/20/2026

Analysis period: Last 10 years

Financial totals are based on the provided analysis window and show an exact obligated amount of 1095198421.5.

Agency ID

7523

PIID

HHSD200201689087I

Type

Vehicle

Total Obligated

1.10 billion

1,095,198,421.50

Actions

Average Action Value

99,563,492.86

Overview

The record for vehicle number under agency 7523 and PIID HHSD200201689087I includes 11 award actions in the last 10 years. Total obligated funding is 1.10 billion, with an average action value of 99,563,492.86.

How to use this page

Use this page to review the scale of obligated funding associated with this vehicle-level record. The figures provide a compact view of action count, average action value, and total obligations for the selected analysis window.

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 = '7523' AND content__IDV__contractID__IDVID__PIID = 'HHSD200201689087I'
    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
7523	CENTERS FOR DISEASE CONTROL AND PREVENTION	1,095,198,421.50	1.10 billion	11

Insight

For vehicle PIID HHSD200201689087I over the 10-year window, obligations are fully concentrated with the Centers for Disease Control and Prevention (Agency ID 7523). The agency accounts for $1.10 billion across 11 awards, indicating repeated use of this vehicle by a single agency rather than broad cross-agency distribution. This pattern suggests agency-specific dependence on the vehicle and limited dispersion of obligated dollars.

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 = '7523' AND content__IDV__contractID__IDVID__PIID = 'HHSD200201689087I'
        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 = '7523' AND content__IDV__contractID__IDVID__PIID = 'HHSD200201689087I'
    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
325412	PHARMACEUTICAL PREPARATION MANUFACTURING	1,095,198,421.50	1.10 billion	11

Insight

Over the 10-year window, obligations on this vehicle are fully concentrated in NAICS 325412, Pharmaceutical Preparation Manufacturing, with $1.10 billion across 11 awards. This indicates a narrow industrial scope and sustained use of the vehicle for pharmaceutical preparation requirements. The distribution suggests limited NAICS diversification within the observed period.

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 = '7523' AND content__IDV__contractID__IDVID__PIID = 'HHSD200201689087I'
    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
6505	DRUGS AND BIOLOGICALS	1,095,198,421.50	1.10 billion	11

Insight

Over the 10-year window, obligations under PIID HHSD200201689087I are entirely concentrated in PSC 6505, Drugs and Biologicals, with $1.10 billion obligated across 11 awards. This indicates a highly focused procurement profile rather than a diversified PSC mix. The concentration in a single PSC suggests this vehicle has been used consistently for drug and biologic acquisitions.

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 = '7523' AND content__IDV__contractID__IDVID__PIID = 'HHSD200201689087I'
    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	904,738,121.59	904.74 million	7
2017	190,460,299.91	190.46 million	3
2022	0.00	0.00	1

Insight

Obligations for vehicle HHSD200201689087I are highly concentrated in 2016, when the instrument received $904.74 million across 7 awards. Activity dropped sharply in 2017 to $190.46 million across 3 awards, indicating a significant year-over-year decline in funded volume. A single 2022 award was recorded with $0 obligated, suggesting no measurable funding was associated with that action.

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