This page summarizes award DESC0004645 for agency ID 8900 over the last 5 years. The award shows 39 actions and total obligated dollars of $510.82 million.
Award Number
Award Number 8900 / DESC0004645 Federal Contract Action Summary (Last 5 Years)
Federal procurement profile for award number DESC0004645 under agency ID 8900, covering obligations and actions over the last 5 years.
Totals are based on the provided analysis window and reflect a total obligated amount of $510,818,612.13 and an average action value of $13,097,913.13.
Overview
Award DESC0004645 is associated with agency ID 8900 and, in the last 5 years, records 39 award actions. The total obligated amount is $510,818,612.13, with an average action value of $13,097,913.13.
How to use this page
Use this page to review the award-level obligation pattern for DESC0004645 within the stated analysis window. The figures support basic comparison across actions, but they do not provide contract text, performance details, or additional award attributes not included in the supplied data.
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 = 'DESC0004645'
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 | 510,818,612.13 | 510.82 million | 39 |
Insight
Within the 5-year window for PIID DESC0004645, all reported obligations are concentrated in a single agency: the Department of Energy. The award is fully distributed to one top agency record, with 39 awards totaling $510.82 million. This indicates a high degree of obligation concentration with no diversification across other agencies 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__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 = 'DESC0004645'
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 |
|---|---|---|---|---|
| URS | 64BY8 | 469,013,326.36 | 469.01 million | 25 |
| UCOR LLC | 64BY8 | 41,805,285.77 | 41.81 million | 14 |
Insight
Award activity under PIID DESC0004645 is highly concentrated in URS, which accounts for $469.01 million across 25 awards over the past 5 years. UCOR LLC is the only other listed vendor and received $41.81 million across 14 awards, indicating a steep drop-off in obligated value after the top vendor. Both rows share CAGE code 64BY8, suggesting the obligations are concentrated within a single vendor identifier rather than dispersed across distinct suppliers.
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 = 'DESC0004645'
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 | 510,818,612.13 | 510.82 million | 39 |
Insight
Over the 5-year window, obligations for PIID DESC0004645 are fully concentrated in NAICS 562910, Remediation Services, with $510.82 million across 39 awards. This indicates a narrow occupational or mission-specific scope, with no observable diversification across other NAICS codes in the provided data. The award pattern suggests sustained procurement activity in a single services category rather than a distributed spend profile.
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 = 'DESC0004645'
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 | 510,818,612.13 | 510.82 million | 39 |
Insight
Obligations for DESC0004645 are fully concentrated in PSC F999, Other Environmental Services, with $510.82 million obligated across 39 awards over the 5-year window. This indicates a narrow service profile with all reported obligations captured under a single PSC. The average obligation per award is substantial, suggesting relatively high-value, recurring environmental service actions rather than a broadly distributed mix of product or service categories.
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 = 'DESC0004645'
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 | 469,188,974.09 | 469.19 million | 23 |
| 2022 | 35,807,120.44 | 35.81 million | 12 |
| 2023 | -1,070,197.60 | -1.07 million | 3 |
| 2025 | 6,892,715.20 | 6.89 million | 1 |
Insight
Obligations for PIID DESC0004645 are highly concentrated in 2021, when 23 awards accounted for $469.19 million, far exceeding subsequent years. Annual obligated value declined sharply in 2022 to $35.81 million across 12 awards, then turned slightly negative in 2023 at -$1.07 million across 3 awards, indicating net deobligation activity. Activity resumed in 2025 with a single award totaling $6.89 million, but remains well below the 2021 peak.
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.