This page summarizes federal procurement activity tied to vehicle number 75D30123D16109 for agency ID 7523. The record shows 811,332,890.5 in total obligated across 9 award actions, for an average action value of 90,148,098.94.
Vehicle Number
Vehicle Number 7523 / 75D30123D16109 Federal Contract Action Summary (Last 5 Years)
Vehicle number 75D30123D16109 for agency 7523 records 9 award actions over the last 5 years, with 811.33 million obligated.
Figures reflect the last 5 years and use the provided obligated totals and action counts for this vehicle record.
Overview
For agency ID 7523, vehicle number 75D30123D16109 shows procurement activity concentrated in 9 award actions during the last 5 years. Total obligated is 811,332,890.5, with an average action value of 90,148,098.94.
How to use this page
Use this page to review the obligation pattern tied to this vehicle record and compare it with other FPDS entries for the same agency. The totals and action count provide a compact view of activity without adding details not present in the source inputs.
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 = '75D30123D16109'
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 | 811,332,890.50 | 811.33 million | 9 |
Insight
Over the 5-year window, the Centers for Disease Control and Prevention accounts for all reported obligation activity in this vehicle, with $811.33 million across 9 awards. This indicates complete concentration within a single agency rather than a distributed obligation base. The award count suggests repeated use of the vehicle by the same agency over the period.
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 = '75D30123D16109'
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 = '75D30123D16109'
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 | 811,332,890.50 | 811.33 million | 9 |
Insight
Over the 5-year window, obligations for vehicle PIID 75D30123D16109 are fully concentrated in NAICS 325412, Pharmaceutical Preparation Manufacturing. This single NAICS accounts for $811.33 million across 9 awards, indicating a highly concentrated spend profile with no diversification across other NAICS codes in 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 = '75D30123D16109'
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 | 811,332,890.50 | 811.33 million | 9 |
Insight
Obligations for vehicle 75D30123D16109 are fully concentrated in PSC 6505, Drugs and Biologicals, with $811.33 million across 9 awards over the 5-year window. This indicates a highly focused requirement profile with no visible category diversification in the provided data. The award pattern suggests repeated procurement activity within the same supply class rather than spread across multiple 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 = '7523' AND content__IDV__contractID__IDVID__PIID = '75D30123D16109'
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 |
|---|---|---|---|
| 2023 | 706,670,326.70 | 706.67 million | 7 |
| 2024 | 104,662,563.80 | 104.66 million | 2 |
Insight
Obligations for PIID 75D30123D16109 were heavily concentrated in 2023, with 706.67 million across 7 awards, compared with 104.66 million across 2 awards in 2024. This indicates a sharp year-over-year decline in both obligation volume and award activity over the 5-year window provided. The pattern suggests funding was much more heavily front-loaded in 2023, with limited subsequent award execution in 2024.
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.