Vehicle Number

Vehicle Number 8900 / DEEM0004895 Federal Contract Action Summary (Last 10 Years)

Federal procurement record for vehicle number DEEM0004895 under agency 8900, covering the last 10 years of award activity.

This page summarizes award activity for vehicle number DEEM0004895 within agency ID 8900 over the last 10 years. The record shows 198 award actions and total obligated funding of 1,495,564,987.36.

Last full year Last 5 years Last 10 years

Generated at 03/20/2026

Analysis period: Last 10 years

Values reflect the provided analysis window and obligated amounts for this vehicle record; totals may differ by rounding in readable displays.

Agency ID

8900

PIID

DEEM0004895

Type

Vehicle

Total Obligated

1.50 billion

1,495,564,987.36

Actions

198

Average Action Value

7,553,358.52

Overview

Across the last 10 years, vehicle number DEEM0004895 is associated with 198 award actions and total obligations of 1,495,564,987.36. The average action value is 7,553,358.52, which indicates substantial activity across the record. This page is intended as a factual summary of the procurement data tied to the vehicle identifier.

How to use this page

Use this page to review the scale and frequency of obligations linked to vehicle number DEEM0004895. It can support basic procurement analysis, trend review, and record lookup within agency ID 8900.

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 10 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	1,495,564,987.36	1.50 billion	198

Insight

Within the 10-year window for PIID DEEM0004895, all reported obligated dollars are concentrated at the Department of Energy (Agency ID 8900). The agency accounts for $1.50 billion across 198 awards, indicating a highly concentrated obligation pattern under this vehicle. No other agencies are represented in the provided rows, so the distribution is singular rather than dispersed.

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 10 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 10 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	1,495,564,987.36	1.50 billion	198

Insight

Over the 10-year window, obligations for this vehicle are fully concentrated in NAICS 562910, Remediation Services, with $1.50 billion obligated across 198 awards. This indicates a highly focused acquisition profile rather than a diversified set of industry classifications. The volume of awards suggests repeated use of the vehicle for remediation-related requirements under Agency ID 8900 and PIID DEEM0004895.

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 10 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	1,495,564,987.36	1.50 billion	198

Insight

Obligations under PIID DEEM0004895 are fully concentrated in PSC F999, Other Environmental Services, with $1.50 billion across 198 awards over the 10-year window. This indicates a highly focused spend profile with no evidence of diversification across PSCs in the provided results. The award count suggests repeated procurement activity within the same service category rather than reliance on a broad mix of products or services.

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 10 YEAR
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC

Year	Total Obligated	Readable	Actions
2017	43,336,011.00	43.34 million	12
2018	149,660,000.00	149.66 million	24
2019	151,894,091.41	151.89 million	15
2020	188,752,647.53	188.75 million	28
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 for PIID DEEM0004895 are concentrated in a sustained mid-to-high range after 2017, rising from 43.34 million across 12 awards in 2017 to 149.66 million in 2018 and remaining above 150 million in each subsequent year except 2017. The highest annual obligation occurred in 2022 at 208.25 million across 34 awards, with similarly elevated levels in 2023 (207.78 million) and 2025 (196.82 million). Award volume generally tracks obligation growth, peaking in 2022, while 2024 reflects a moderate pullback to 187.30 million and 21 awards.

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 10 years view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.

Start 7-Day Trial Learn More