This page summarizes the vehicle number entry tied to PIID HHSD200201689088I for agency ID 7523. The available record shows one award action and zero total obligated amount across the last 5 years.
Vehicle Number
Vehicle Number 7523 / HHSD200201689088I Federal Contract Action Summary (Last 5 Years)
Vehicle number record for PIID HHSD200201689088I under agency ID 7523, showing one award action in the last 5 years and no obligated value reported.
Totals reflect the provided analysis window and show 0.00 readable obligated value, 0 exact obligated value, 1 award action, and an average action value of 0.
Agency ID
7523
PIID
HHSD200201689088I
Type
Vehicle
Total Obligated
0.00
0.00
Actions
1
Average Action Value
0.00
Overview
The record for vehicle number under PIID HHSD200201689088I is limited to a single award action in the last 5 years. Reported obligation totals are zero, with no readable obligated amount and no average value above zero. This indicates activity is present in the record, but no monetary obligation is shown in the provided data.
How to use this page
Use this page to confirm the presence of a vehicle number entry and the associated award action count for agency ID 7523. It is also useful for quickly checking that the reported obligated totals are zero over the stated 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 = 'HHSD200201689088I'
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 |
|---|---|---|---|---|
| 7523 | CENTERS FOR DISEASE CONTROL AND PREVENTION | 0.00 | 0.00 | 1 |
Insight
Within the 5-year window, all reported obligations for PIID HHSD200201689088I are concentrated in a single agency: the Centers for Disease Control and Prevention (Agency ID 7523). Although there is one award recorded, the total obligated amount is $0.00, indicating no obligated dollars associated with this vehicle in the period reviewed. This pattern reflects highly limited distribution and no measurable funding concentration beyond a single agency recipient.
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 = 'HHSD200201689088I'
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 = '7523' AND content__IDV__contractID__IDVID__PIID = 'HHSD200201689088I'
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 |
|---|---|---|---|---|
| 325412 | PHARMACEUTICAL PREPARATION MANUFACTURING | 0.00 | 0.00 | 1 |
Insight
Obligations under this vehicle are fully concentrated in NAICS 325412, Pharmaceutical Preparation Manufacturing, with one award recorded over the 5-year window. The reported total obligated is $0.00, indicating no obligated dollars associated with the single award in this category. This pattern suggests very limited activity and no observable NAICS diversification within the provided data.
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 = 'HHSD200201689088I'
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 |
|---|---|---|---|---|
| 6505 | DRUGS AND BIOLOGICALS | 0.00 | 0.00 | 1 |
Insight
The vehicle’s PSC activity over the 5-year window is fully concentrated in PSC 6505, Drugs and Biologicals. This category accounts for the only reported award count in the provided rows, with one award and no obligated dollars recorded. The absence of obligated value indicates reported use of the vehicle in this PSC without measurable financial outlay in the dataset provided.
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 = 'HHSD200201689088I'
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 |
|---|---|---|---|
| 2022 | 0.00 | 0.00 | 1 |
Insight
Over the 5-year window, this vehicle shows activity only in 2022, with one award and no obligated dollars reported. Obligations are fully concentrated in a single year, indicating no observable multi-year distribution or spending trend in the provided data. This pattern suggests limited recent funding activity under PIID HHSD200201689088I for Agency ID 7523.
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.