Vehicle Number

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

Federal procurement summary for vehicle number associated with PIID DEEM0002043, showing obligations, action count, and average action value over the last 10 years.

This page summarizes procurement activity for vehicle number under agency ID 8900 for PIID DEEM0002043 across the last 10 years. Total obligated amount is $50.39 million across 47 award actions, with an average action value of $1,072,108.36.

Last full year Last 5 years Last 10 years

Generated at 03/21/2026

Analysis period: Last 10 years

Amounts are reported as total obligated readable of $50.39 million and total obligated exact of 50389093.13.

Agency ID

8900

PIID

DEEM0002043

Type

Vehicle

Total Obligated

50.39 million

50,389,093.13

Actions

Average Action Value

1,072,108.36

Overview

Over the last 10 years, this vehicle number record shows 47 award actions totaling $50,389,093.13 in obligated funding. The average action value is $1,072,108.36, indicating repeated contract activity rather than a single isolated award. This page is centered on agency ID 8900 and PIID DEEM0002043.

How to use this page

Use this page to review the overall obligation level, action volume, and average action value for the specified vehicle number. It can support procurement analysis, record matching, and comparisons against other FPDS query results for the same PIID or agency ID.

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 = 'DEEM0002043'
    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	50,389,093.13	50.39 million	47

Insight

Within the 10-year window for vehicle PIID DEEM0002043, obligations are fully concentrated in a single top agency: the Department of Energy (Agency ID 8900). DOE accounts for 47 awards totaling $50.39 million, indicating all recorded obligations in the provided rows are centered on one agency relationship. This pattern suggests a highly concentrated award history with no visible agency diversification in the supplied 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 = 'DEEM0002043'
        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 = 'DEEM0002043'
    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
621111	OFFICES OF PHYSICIANS (EXCEPT MENTAL HEALTH SPECIALISTS)	50,389,093.13	50.39 million	47

Insight

Over the 10-year window, obligations for vehicle DEEM0002043 are fully concentrated in NAICS 621111, Offices of Physicians (except Mental Health Specialists), with $50.39 million across 47 awards. This indicates a highly focused spending pattern with no diversification across other NAICS codes in the provided data. The award count suggests repeated procurement activity within the same service category rather than a single large obligation.

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 = 'DEEM0002043'
    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
Q526	MEDICAL- MEDICAL/PSYCHIATRIC CONSULTATION	50,389,093.13	50.39 million	47

Insight

Obligations are fully concentrated in PSC Q526, Medical-Medical/Psychiatric Consultation, totaling $50.39 million across 47 awards over the 10-year window. This indicates a highly focused service profile for PIID DEEM0002043, with no evidence of PSC diversification in the provided data. The award count suggests repeated procurement activity within the same service category rather than broad spend distribution.

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 = 'DEEM0002043'
    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
2016	14,880,007.75	14.88 million	10
2017	16,720,000.85	16.72 million	15
2018	18,786,487.46	18.79 million	16
2019	1,841,540.19	1.84 million	4
2022	0.00	0.00	1
2025	-1,838,943.12	-1.84 million	1

Insight

Obligations for PIID DEEM0002043 were concentrated in 2016 through 2018, with annual funding rising from 14.88 million in 2016 to a peak of 18.79 million in 2018 across 10 to 16 awards per year. Activity then declined sharply in 2019 to 1.84 million across 4 awards, followed by minimal or no positive obligations in later observed years. The 2022 entry reflects a zero-obligation award, and 2025 shows a negative obligation of 1.84 million, indicating a downward adjustment or de-obligation rather than new 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 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