This page summarizes procurement activity tied to award number W52P1J09C0013 for agency ID 9700. Over the last 5 years, the award shows 90 actions and total obligated amount of 1.87 billion.
Award Number
Award Number 9700 / W52P1J09C0013 Federal Contract Action Summary (Last 5 Years)
Federal award record for award number W52P1J09C0013 under agency ID 9700, showing obligation and action activity over the last 5 years.
Figures are based on the provided analysis window and may reflect rounded display values versus exact totals.
Agency ID
9700
PIID
W52P1J09C0013
Type
Award
Total Obligated
1.87 billion
1,867,829,701.96
Actions
90
Average Action Value
20,753,663.36
Overview
The award record for W52P1J09C0013 shows 90 award actions in the last 5 years. Total obligated amount is 1,867,829,701.96, with an average action value of 20,753,663.36. The readable total shown on the page is 1.87 billion.
How to use this page
Use this page to review award-level obligation totals and action volume for agency ID 9700. The record can support basic trend review, comparison against related awards, and validation of the reported total obligated amount and average action value.
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 = '9700' AND content__award__awardID__awardContractID__PIID = 'W52P1J09C0013'
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 |
|---|---|---|---|---|
| 2100 | DEPT OF THE ARMY | 1,867,829,701.96 | 1.87 billion | 90 |
Insight
Within the 5-year window for PIID W52P1J09C0013, obligations are concentrated in a single agency: the Department of the Army accounts for $1.87 billion across 90 awards. This indicates a highly concentrated award profile with no distribution across other agencies in the provided results. The award activity is therefore primarily driven by Army obligations rather than a broad interagency mix.
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 = '9700' AND content__award__awardID__awardContractID__PIID = 'W52P1J09C0013'
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 |
|---|---|---|---|---|
| BECHTEL PARSONS BLUE GRASS, A JOINT VENTURE | 3FT89 | 1,867,829,701.96 | 1.87 billion | 90 |
Insight
All reported obligations in this 5-year window are concentrated with BECHTEL PARSONS BLUE GRASS, A JOINT VENTURE (CAGE 3FT89), which accounts for $1.87 billion across 90 awards under PIID W52P1J09C0013. This indicates a single-vendor concentration with no other vendors reflected in the provided rows. The award activity is frequent and consistently distributed across multiple actions rather than isolated to a small number of awards.
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 = '9700' AND content__award__awardID__awardContractID__PIID = 'W52P1J09C0013'
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 |
|---|---|---|---|---|
| 562211 | HAZARDOUS WASTE TREATMENT AND DISPOSAL | 1,867,829,701.96 | 1.87 billion | 90 |
Insight
Over the 5-year window, obligations for PIID W52P1J09C0013 are fully concentrated in NAICS 562211, Hazardous Waste Treatment and Disposal, with $1.87 billion across 90 awards. This indicates a single-industry procurement profile with no diversification across NAICS codes in the provided data. The volume of awards suggests recurring activity within the same service category rather than broad category dispersion.
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 = '9700' AND content__award__awardID__awardContractID__PIID = 'W52P1J09C0013'
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 |
|---|---|---|---|---|
| F108 | ENVIRONMENTAL SYSTEMS PROTECTION- ENVIRONMENTAL REMEDIATION | 1,867,829,701.96 | 1.87 billion | 90 |
Insight
PSC F108 (Environmental Systems Protection - Environmental Remediation) accounts for the full observed obligations in this 5-year award window for PIID W52P1J09C0013, with $1.87 billion across 90 awards. This indicates a complete concentration of award activity in a single PSC category, with no diversification across other PSCs in the provided rows. The pattern suggests sustained procurement emphasis on environmental remediation work for this instrument.
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 = '9700' AND content__award__awardID__awardContractID__PIID = 'W52P1J09C0013'
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 | 439,249,106.76 | 439.25 million | 20 |
| 2022 | 313,254,505.58 | 313.25 million | 18 |
| 2023 | 471,103,403.51 | 471.10 million | 22 |
| 2024 | 414,834,184.68 | 414.83 million | 18 |
| 2025 | 229,388,501.43 | 229.39 million | 12 |
Insight
Obligations under PIID W52P1J09C0013 were concentrated in a relatively narrow annual range from 2021 through 2024, with award counts between 18 and 22 and annual obligations between $313.25 million and $471.10 million. The high point occurred in 2023 at $471.10 million across 22 awards, followed by a decline in 2024 to $414.83 million across 18 awards. The 2025 value is notably lower at $229.39 million across 12 awards, indicating a marked reduction in both obligated amount and award activity in the most recent year.
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.