This page summarizes procurement activity for vehicle number under agency ID 8900 for PIID DEEM0004895 during the last 5 years. Reported obligations total $961.92 million across 119 award actions.
Vehicle Number
Vehicle Number 8900 / DEEM0004895 Federal Contract Action Summary (Last 5 Years)
FPDS analysis page for vehicle number associated with agency 8900 and PIID DEEM0004895 over the last 5 years.
Totals are based on the provided analysis window and include an exact obligated amount of $961,922,237.42 with an average action value of $8,083,380.15.
Overview
The record set for vehicle number under agency ID 8900 and PIID DEEM0004895 shows $961,922,237.42 in obligated value over the last 5 years. That total is distributed across 119 award actions, producing an average action value of $8,083,380.15. These figures provide a concise view of award volume and obligation scale for this vehicle.
How to use this page
Use this page to review the documented procurement history tied to vehicle number, including total obligations, action count, and average action value. It is useful for comparing this vehicle against other FPDS records using the same agency, PIID, or time 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 = 'DEEM0004895'
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 | 961,922,237.42 | 961.92 million | 119 |
Insight
For PIID DEEM0004895 over the 5-year window, obligations are fully concentrated within the Department of Energy. The agency account for the entire reported volume, totaling $961.92 million across 119 awards. This indicates a single-agency distribution with no evidence of cross-agency obligation activity in the provided 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 = '8900' AND content__IDV__contractID__IDVID__PIID = 'DEEM0004895'
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 = 'DEEM0004895'
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 | 961,922,237.42 | 961.92 million | 119 |
Insight
Over the 5-year window, obligations on vehicle PIID DEEM0004895 are fully concentrated in NAICS 562910, Remediation Services. The single reported NAICS accounts for $961.92 million across 119 awards, indicating a consistently focused procurement pattern rather than distribution across multiple industries. This concentration suggests the vehicle has been used primarily for remediation-related work under Agency 8900.
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 = 'DEEM0004895'
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 | 961,922,237.42 | 961.92 million | 119 |
Insight
Obligations for PIID DEEM0004895 are fully concentrated in PSC F999, Other Environmental Services, with $961.92 million across 119 awards over the 5-year window. This indicates a highly concentrated services profile rather than a diversified PSC mix. The award count suggests repeated procurement activity within the same PSC category.
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 = 'DEEM0004895'
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 | 161,774,664.06 | 161.77 million | 19 |
| 2022 | 208,253,895.58 | 208.25 million | 34 |
| 2023 | 207,779,976.62 | 207.78 million | 23 |
| 2024 | 187,295,282.30 | 187.30 million | 21 |
| 2025 | 196,818,418.86 | 196.82 million | 22 |
Insight
Obligations under PIID DEEM0004895 were relatively concentrated and stable over the five-year period, ranging from 161.77 million in 2021 to 208.25 million in 2022. Funding peaked in 2022, remained near that level in 2023 at 207.78 million, then declined in 2024 to 187.30 million before rebounding modestly in 2025 to 196.82 million. Award volume was highest in 2022 with 34 awards, compared with 19 in 2021 and 21-23 awards in subsequent years, indicating a shift from a lower-award base to a more sustained distribution.
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.