This page summarizes award number DEEM0004083 for agency ID 8900 across the last 5 years. The record shows 49 award actions with total obligated funding of $363,731,173.85.
Award Number
Award Number 8900 / DEEM0004083 Federal Contract Action Summary (Last 5 Years)
Federal award number DEEM0004083 for agency ID 8900, showing obligation and action activity over the last 5 years.
Dollar values are shown as provided in the source data, with a readable total of $363.73 million and an exact total of $363,731,173.85.
Overview
Award number DEEM0004083 is associated with agency ID 8900 in the last 5 years of available data. The award records 49 actions and total obligated funding of $363,731,173.85, with an average action value of $7,423,085.18. This view is limited to the provided award-level metrics.
How to use this page
Use this page to review award-level activity, including the total obligated amount, action count, and average action value. It can support basic procurement review, historical comparison, and identification of higher-value award activity within the analysis window.
Top Agencies
SELECT
content__award__purchaserInformation__contractingOfficeAgencyID AS agency_id,
content__award__purchaserInformation__contractingOfficeAgencyID__name AS agency_name,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count,
formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
content__award__awardID__awardContractID__agencyID = '8900' AND content__award__awardID__awardContractID__PIID = 'DEEM0004083'
AND content__award__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
AND content__award__purchaserInformation__contractingOfficeAgencyID != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__award__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 | 363,731,173.85 | 363.73 million | 49 |
Insight
For PIID DEEM0004083 over the 5-year window, obligations are fully concentrated within a single top agency: the Department of Energy. This agency accounts for $363.73 million across 49 awards, indicating a broad distribution of action at the agency level rather than concentration in multiple agencies.
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__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count
FROM fpds.data
WHERE
content__award__awardID__awardContractID__agencyID = '8900' AND content__award__awardID__awardContractID__PIID = 'DEEM0004083'
AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
AND content__award__vendor__vendorHeader__vendorName != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
vendor_name,
cage_code
)
ORDER BY total_obligated DESC
LIMIT 10
| Vendor | CAGE Code | Total Obligated | Readable | Actions |
|---|---|---|---|---|
| FLUOR IDAHO, LLC | 6GGS3 | 363,731,173.85 | 363.73 million | 49 |
Insight
FLUOR IDAHO, LLC is the sole top vendor listed for DEEM0004083 over the 5-year window, with 49 awards totaling $363.73 million. This indicates a highly concentrated obligation pattern, with all identified top-vendor activity in the provided data attributable to a single contractor. The volume of awards suggests repeated use of this vendor across the period rather than reliance on a small spread of contractors.
Top NAICS
SELECT
content__award__productOrServiceInformation__principalNAICSCode AS naics_code,
content__award__productOrServiceInformation__principalNAICSCode__description AS naics_name,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count,
formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
content__award__awardID__awardContractID__agencyID = '8900' AND content__award__awardID__awardContractID__PIID = 'DEEM0004083'
AND content__award__productOrServiceInformation__principalNAICSCode IS NOT NULL
AND content__award__productOrServiceInformation__principalNAICSCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__award__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 | 363,731,173.85 | 363.73 million | 49 |
Insight
Over the 5-year window, obligations for PIID DEEM0004083 are fully concentrated in NAICS 562910, Remediation Services. This single NAICS accounts for $363.73 million across 49 awards, indicating a highly focused procurement profile with no diversification across other industry codes in the provided data.
Top PSC Codes
SELECT
content__award__productOrServiceInformation__productOrServiceCode AS psc_code,
content__award__productOrServiceInformation__productOrServiceCode__description AS psc_name,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count,
formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
content__award__awardID__awardContractID__agencyID = '8900' AND content__award__awardID__awardContractID__PIID = 'DEEM0004083'
AND content__award__productOrServiceInformation__productOrServiceCode IS NOT NULL
AND content__award__productOrServiceInformation__productOrServiceCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__award__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 | 363,731,173.85 | 363.73 million | 49 |
Insight
Obligations for PIID DEEM0004083 are concentrated entirely in PSC F999, Other Environmental Services, totaling $363.73 million across 49 awards over the 5-year window. This indicates a highly concentrated service profile with no observed PSC diversification in the provided data. The average obligation per award is approximately $7.43 million, suggesting repeated awards at a substantial but relatively consistent scale.
Annual Trend
SELECT
toYear(parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate)) AS year,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
formatReadableQuantity(sum(content__award__dollarValues__obligatedAmount)) AS total_obligated_readable,
count() AS award_count
FROM fpds.data
WHERE
content__award__awardID__awardContractID__agencyID = '8900' AND content__award__awardID__awardContractID__PIID = 'DEEM0004083'
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC
| Year | Total Obligated | Readable | Actions |
|---|---|---|---|
| 2021 | 391,857,491.62 | 391.86 million | 42 |
| 2022 | -28,126,317.77 | -28.13 million | 7 |
Insight
For PIID DEEM0004083 at agency 8900, obligations were heavily concentrated in 2021, with $391.86 million across 42 awards. In 2022, obligated value fell sharply to -$28.13 million across 7 awards, indicating a material year-over-year reversal in both volume and dollar value. This pattern suggests the award’s activity was concentrated in 2021, with substantially lower and negative net obligations in 2022.
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.