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.

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.

Generated at 03/20/2026

Analysis period: 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.

Agency ID
8900
PIID
DEEM0004895
Type
Vehicle
Total Obligated
961.92 million
961,922,237.42
Actions
119
Average Action Value
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.