This page summarizes procurement activity for the vehicle number entity tied to Agency ID 8900 and PIID 89303322DEM000077. During the last full year, total obligations reached $508.47 million across 30 award actions.
Vehicle Number
Vehicle Number 8900 / 89303322DEM000077 Federal Contract Action Summary (Last Year)
Analysis of vehicle number activity for Agency ID 8900 under PIID 89303322DEM000077 during the last full year.
Obligation values are shown as reported, with exact total obligated amount of $508,466,644.24 and average action value of $16,948,888.14.
Agency ID
8900
PIID
89303322DEM000077
Type
Vehicle
Total Obligated
508.47 million
508,466,644.24
Actions
30
Average Action Value
16,948,888.14
Overview
In the last full year, the vehicle number record for Agency ID 8900 shows 30 award actions and total obligations of $508,466,644.24. The average action value was $16,948,888.14, indicating substantial award-level activity within the period. This page is intended to support review of that procurement record without adding assumptions beyond the reported data.
How to use this page
Use this page to review the scope and scale of obligations associated with vehicle number activity for the identified PIID. The figures can be used as a starting point for award-level analysis, trend review, or comparison with other FPDS query results. All amounts and counts on this page are limited to the provided analysis window and reported values.
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 = '8900' AND content__IDV__contractID__IDVID__PIID = '89303322DEM000077'
AND content__IDV__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
AND content__IDV__purchaserInformation__contractingOfficeAgencyID != ''
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 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 |
|---|---|---|---|---|
| 8900 | ENERGY, DEPARTMENT OF | 508,466,644.24 | 508.47 million | 30 |
Insight
For the 1-year window, obligations under PIID 89303322DEM000077 are concentrated entirely within the Department of Energy (agency ID 8900), which accounts for $508.47 million across 30 awards. This indicates a fully concentrated agency distribution for this vehicle, with no evidence of cross-agency obligation sharing in the provided data. The award count suggests multiple actions within a single agency relationship rather than broad dispersion across departments.
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 = '8900' AND content__IDV__contractID__IDVID__PIID = '89303322DEM000077'
AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
AND content__award__vendor__vendorHeader__vendorName != ''
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 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 = '8900' AND content__IDV__contractID__IDVID__PIID = '89303322DEM000077'
AND content__IDV__productOrServiceInformation__principalNAICSCode IS NOT NULL
AND content__IDV__productOrServiceInformation__principalNAICSCode != ''
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 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 |
|---|---|---|---|---|
| 562211 | HAZARDOUS WASTE TREATMENT AND DISPOSAL | 508,466,644.24 | 508.47 million | 30 |
Insight
Obligations in the 1-year window are fully concentrated in NAICS 562211, Hazardous Waste Treatment and Disposal, with $508.47 million across 30 awards. This indicates a narrow procurement profile for the vehicle, with all recorded obligations tied to a single industrial classification. The award count suggests repeated activity within the same NAICS rather than diversification across multiple sectors.
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 = '8900' AND content__IDV__contractID__IDVID__PIID = '89303322DEM000077'
AND content__IDV__productOrServiceInformation__productOrServiceCode IS NOT NULL
AND content__IDV__productOrServiceInformation__productOrServiceCode != ''
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 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 |
|---|---|---|---|---|
| F999 | OTHER ENVIRONMENTAL SERVICES | 508,466,644.24 | 508.47 million | 30 |
Insight
Over the 1-year window, obligations for PIID 89303322DEM000077 are fully concentrated in PSC F999, Other Environmental Services, with $508.47 million across 30 awards. This indicates a single-category spend profile with no observed PSC diversification in the provided data. The average obligated amount is approximately $16.95 million per award, suggesting relatively high-value placements within this PSC.
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 = '8900' AND content__IDV__contractID__IDVID__PIID = '89303322DEM000077'
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 YEAR
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC| Year | Total Obligated | Readable | Actions |
|---|---|---|---|
| 2025 | 508,466,644.24 | 508.47 million | 30 |
Insight
Over the 1-year window, obligations for vehicle PIID 89303322DEM000077 are concentrated entirely in FY 2025, with $508.47 million obligated across 30 awards. This indicates a high level of funding activity in a single fiscal year rather than a distributed multi-year trend. The average obligation per award is substantial, suggesting a relatively concentrated award pattern within the period reviewed.
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 full year view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.