Vehicle Number

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

Procurement analysis for vehicle number DEEM0004895 at agency 8900 during the last full year, showing 22 award actions and $196.82 million obligated.

This page summarizes federal procurement activity for vehicle number DEEM0004895 under agency 8900 in the last full year. The record shows 22 award actions with total obligated dollars of $196,818,418.86.

Last full year Last 5 years Last 10 years

Generated at 03/20/2026

Analysis period: Last full year

Dollar figures are shown as reported, with the readable total rounded to $196.82 million and the exact total retained for analysis.

Agency ID

8900

PIID

DEEM0004895

Type

Vehicle

Total Obligated

196.82 million

196,818,418.86

Actions

Average Action Value

8,946,291.77

Overview

In the last full year, vehicle number DEEM0004895 recorded 22 award actions at agency 8900. Total obligations were $196,818,418.86, with an average action value of $8,946,291.77. These figures provide a concise view of the contract activity associated with this vehicle record.

How to use this page

Use this page to review the scale and frequency of obligation activity tied to vehicle number DEEM0004895. The combination of action count, total obligated amount, and average action value supports basic procurement analysis for the selected period.

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 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	196,818,418.86	196.82 million	22

Insight

Within the 1-year window for vehicle PIID DEEM0004895, all reported obligations are concentrated in a single top agency: the Department of Energy. DOE accounts for $196.82 million across 22 awards, indicating a fully concentrated obligation profile in the provided data. No additional agencies are reflected in the rows, so distribution beyond DOE cannot be assessed from this result set.

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 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 = 'DEEM0004895'
    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
562910	REMEDIATION SERVICES	196,818,418.86	196.82 million	22

Insight

Obligations for PIID DEEM0004895 over the past year are fully concentrated in a single NAICS category: 562910, Remediation Services. This category accounts for 22 awards totaling $196.82 million, indicating a highly focused procurement profile with no observed diversification across other NAICS codes in the provided data.

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 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	196,818,418.86	196.82 million	22

Insight

Over the 1-year window, obligations under PIID DEEM0004895 are fully concentrated in PSC F999, Other Environmental Services. The single PSC accounts for $196.82 million across 22 awards, indicating a highly focused award profile with no diversification across PSCs in the provided data. This concentration suggests the vehicle is being used primarily for a specific environmental services requirement rather than a broad mix of service categories.

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

Year	Total Obligated	Readable	Actions
2025	196,818,418.86	196.82 million	22

Insight

Over the 1-year window, obligations for PIID DEEM0004895 were concentrated entirely in FY2025, with total obligated amounts of $196.82 million across 22 awards. This indicates a high level of funding activity within a single fiscal year rather than a multi-year spread. The award count suggests the obligations were distributed across multiple actions, but the available data provide no evidence of prior-year activity for trend comparison.

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.

Start 7-Day Trial Learn More