This page presents procurement activity for award number DEAC3010CC40017 for agency ID 8900 across the last 10 years. It includes total obligations, action count, and average action value for the award record.
Award Number
Award Number 8900 / DEAC3010CC40017 Federal Contract Action Summary (Last 10 Years)
FPDS award page for award number DEAC3010CC40017 under agency ID 8900, summarizing obligations and actions over the last 10 years.
Amounts reflect a total obligated value of 3.84 billion dollars, with an exact total of 3835826589.53 across 320 actions.
Overview
The award record for DEAC3010CC40017 shows 320 recorded actions in the last 10 years. Total obligated dollars equal 3,835,826,589.53, with an average action value of 11,986,958.09. This provides a compact view of activity volume and funding level for the award.
How to use this page
Use this page to review the award’s obligation pattern and compare action volume against total dollars obligated. The figures support basic analysis of award activity for agency ID 8900 without adding data beyond the FPDS record.
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 = 'DEAC3010CC40017'
AND content__award__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
AND content__award__purchaserInformation__contractingOfficeAgencyID != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 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 | 3,835,826,589.53 | 3.84 billion | 320 |
Insight
For PIID DEAC3010CC40017 over the 10-year window, all reported obligations are concentrated in a single top agency: the Department of Energy, with $3.84 billion across 320 awards. This indicates complete agency-level concentration in the provided results, with no evidence of distribution across other agencies in this query output. The award volume suggests repeated obligated activity under the same agency rather than a one-off obligation pattern.
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 = 'DEAC3010CC40017'
AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
AND content__award__vendor__vendorHeader__vendorName != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 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-B&W PORTSMOUTH LLC | 5SMD3 | 3,593,268,513.53 | 3.59 billion | 273 |
| FLUOR-B&W PORTSMOUTH LLC | 242,558,076.00 | 242.56 million | 47 |
Insight
Obligations under PIID DEAC3010CC40017 are highly concentrated in FLUOR-B&W PORTSMOUTH LLC, which accounts for 3.59 billion across 273 awards. The same vendor name also appears in a separate row without a CAGE code, with 242.56 million across 47 awards, indicating additional obligated activity recorded under a second vendor identifier. Together, these rows indicate that this contractor dominates the award’s obligated spend over the 10-year window.
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 = 'DEAC3010CC40017'
AND content__award__productOrServiceInformation__principalNAICSCode IS NOT NULL
AND content__award__productOrServiceInformation__principalNAICSCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 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 | 3,835,826,589.53 | 3.84 billion | 320 |
Insight
Obligations for PIID DEAC3010CC40017 are fully concentrated in NAICS 562910, Remediation Services, with $3.84 billion obligated across 320 awards over the 10-year window. This indicates a highly focused procurement profile with no observable NAICS diversification in the provided data. The award volume suggests repeated activity within the same services category rather than a broad mix of procurement types.
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 = 'DEAC3010CC40017'
AND content__award__productOrServiceInformation__productOrServiceCode IS NOT NULL
AND content__award__productOrServiceInformation__productOrServiceCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 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 |
|---|---|---|---|---|
| P500 | SALVAGE- DEMOLITION OF STRUCTURES/FACILITIES (OTHER THAN BUILDINGS) | 3,835,826,589.53 | 3.84 billion | 320 |
Insight
Award activity under PIID DEAC3010CC40017 is fully concentrated in PSC P500, with $3.84 billion obligated across 320 awards over the 10-year window. This indicates a narrow procurement profile centered on salvage and demolition of structures/facilities other than buildings, rather than a diversified mix of product or service categories. The relatively high award count alongside the full obligation concentration suggests repeated use of the same PSC for this award record.
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 = 'DEAC3010CC40017'
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 10 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC
| Year | Total Obligated | Readable | Actions |
|---|---|---|---|
| 2016 | 242,558,076.00 | 242.56 million | 45 |
| 2017 | 245,296,981.00 | 245.30 million | 33 |
| 2018 | 372,483,282.79 | 372.48 million | 33 |
| 2019 | 367,979,857.79 | 367.98 million | 19 |
| 2020 | 400,526,761.95 | 400.53 million | 34 |
| 2021 | 507,302,741.05 | 507.30 million | 28 |
| 2022 | 388,919,415.38 | 388.92 million | 41 |
| 2023 | 500,231,860.11 | 500.23 million | 38 |
| 2024 | 559,806,766.06 | 559.81 million | 31 |
| 2025 | 250,720,847.40 | 250.72 million | 18 |
Insight
Obligations for PIID DEAC3010CC40017 under Agency 8900 are concentrated in the later years of the 10-year window, rising from $242.56 million in 2016 to a peak of $559.81 million in 2024. Annual obligations fluctuate materially rather than following a steady trajectory, with a notable increase from 2020 through 2024 despite a dip in 2022. Award counts are uneven across the period, ranging from 18 to 45 per year, indicating variable annual award activity alongside the higher-obligation years.
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.