This page summarizes federal award activity for vehicle number under PIID HHSD200201562101I for Agency ID 7523. The record shows 5 award actions and total obligated funding of $243.67 million.
Vehicle Number
Vehicle Number 7523 / HHSD200201562101I Federal Contract Action Summary (Last 10 Years)
Procurement analysis page for vehicle number associated with PIID HHSD200201562101I and Agency ID 7523 over the last 10 years.
Dollar figures are based on the provided exact total obligated amount of 243672519.89 and the stated 10-year analysis window.
Overview
Over the last 10 years, this vehicle number record reflects 5 award actions tied to PIID HHSD200201562101I. Total obligated funding is $243,672,519.89, with an average action value of $48,734,503.98. The page is intended to support review of obligation volume and award activity for Agency ID 7523.
How to use this page
Use this page to review the scale and cadence of award activity associated with this vehicle number. It provides a compact summary of total obligations, action count, and average action value for analysis and comparison.
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 = 'HHSD200201562101I'
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 | 243,672,519.89 | 243.67 million | 5 |
Insight
Over the 10-year window for vehicle PIID HHSD200201562101I, obligations are fully concentrated in a single top agency: the Centers for Disease Control and Prevention. CDC accounts for $243.67 million across 5 awards, indicating a highly concentrated obligation pattern with limited distribution across agencies. This suggests the vehicle has been used almost exclusively by CDC over the period reflected in the 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 = '7523' AND content__IDV__contractID__IDVID__PIID = 'HHSD200201562101I'
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 = 'HHSD200201562101I'
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 | 243,672,519.89 | 243.67 million | 5 |
Insight
Over the 10-year window, obligations for vehicle PIID HHSD200201562101I are fully concentrated in NAICS 325412, Pharmaceutical Preparation Manufacturing. This NAICS accounts for 5 awards totaling $243.67 million, indicating a narrow but material spend profile within a single industry classification.
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 = 'HHSD200201562101I'
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 | 243,672,519.89 | 243.67 million | 5 |
Insight
This vehicle’s obligations are fully concentrated in PSC 6505, Drugs and Biologicals, with $243.67 million across 5 awards over the 10-year window. The pattern indicates a narrow commodity focus rather than a diversified services mix, with obligation volume driven by a small number of awards.
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 = 'HHSD200201562101I'
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 | 243,672,519.89 | 243.67 million | 3 |
| 2018 | 0.00 | 0.00 | 1 |
| 2023 | 0.00 | 0.00 | 1 |
Insight
Obligations under PIID HHSD200201562101I are highly concentrated in 2016, when 243.67 million was obligated across 3 awards. Activity in the remaining observed years is minimal, with one award recorded in 2018 and one in 2023, both showing zero obligations. This pattern indicates a single-year obligation spike followed by nominal award activity without associated funding in later years.
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.