This page summarizes award activity for vehicle number 89303322DEM000067 for agency ID 8900 across the last 5 years. The record shows 42 award actions with total obligations of 161,956,283.67.
Vehicle Number
Vehicle Number 8900 / 89303322DEM000067 Federal Contract Action Summary (Last 5 Years)
Federal procurement summary for vehicle number 89303322DEM000067 under agency ID 8900, covering award activity over the last 5 years.
All values reflect the provided analysis window and obligation totals for this vehicle record.
Agency ID
8900
PIID
89303322DEM000067
Type
Vehicle
Total Obligated
161.96 million
161,956,283.67
Actions
42
Average Action Value
3,856,101.99
Overview
Over the last 5 years, vehicle number 89303322DEM000067 recorded 42 award actions for agency ID 8900. Total obligated value reached 161,956,283.67, with an average action value of 3,856,101.99.
How to use this page
Use this page to review the scale and cadence of award activity tied to this vehicle record. The totals provide a compact view of obligation volume and average action size within 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 = '8900' AND content__IDV__contractID__IDVID__PIID = '89303322DEM000067'
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 |
|---|---|---|---|---|
| 8900 | ENERGY, DEPARTMENT OF | 161,956,283.67 | 161.96 million | 42 |
Insight
Over the 5-year window for vehicle PIID 89303322DEM000067, all recorded obligations are concentrated within the Department of Energy (agency ID 8900). The entity has 42 awards totaling $161.96 million, indicating a complete concentration of obligated activity in a single top agency. This pattern suggests the vehicle’s usage is heavily centralized rather than distributed across multiple agencies.
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 = '89303322DEM000067'
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 = '8900' AND content__IDV__contractID__IDVID__PIID = '89303322DEM000067'
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 |
|---|---|---|---|---|
| 562910 | REMEDIATION SERVICES | 161,956,283.67 | 161.96 million | 42 |
Insight
Over the 5-year window, obligations for this vehicle are fully concentrated in NAICS 562910, Remediation Services, with $161.96 million across 42 awards. This indicates a narrow industrial distribution and a sustained procurement pattern centered on remediation work rather than a broad mix of NAICS activity. The average obligation per award is approximately $3.86 million, suggesting moderate award fragmentation within a single dominant NAICS.
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 = '89303322DEM000067'
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 |
|---|---|---|---|---|
| F999 | OTHER ENVIRONMENTAL SERVICES | 161,956,283.67 | 161.96 million | 42 |
Insight
Over the 5-year window, obligations for vehicle PIID 89303322DEM000067 are concentrated entirely in PSC F999, Other Environmental Services. This PSC accounts for 161.96 million across 42 awards, indicating a consistent and highly focused spend pattern within a single services category. No other PSCs are reported in this section, so the distribution is fully concentrated rather than diversified.
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 = '89303322DEM000067'
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 |
|---|---|---|---|
| 2021 | 500,000.00 | 500.00 thousand | 1 |
| 2022 | 447,118,603.38 | 447.12 million | 12 |
| 2023 | -285,662,319.71 | -285.66 million | 14 |
| 2024 | 0.00 | 0.00 | 8 |
| 2025 | 0.00 | 0.00 | 7 |
Insight
Obligations for PIID 89303322DEM000067 are highly concentrated in 2022 and 2023, with a sharp increase to $447.12 million in 2022 followed by a negative obligated amount of $285.66 million in 2023. The remaining years show materially lower activity, including only $500 thousand in 2021 and zero obligated amounts in 2024 and 2025 despite continued award counts. This pattern indicates a brief period of elevated obligation activity with subsequent downward adjustment or deobligation rather than sustained annual funding.
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.