This page summarizes federal procurement activity for award number W912PL19C0015 under agency ID 9700. Over the last five years, the award reflects seven actions and a total obligated amount of -$322,845,750.53.
Award Number
Award Number 9700 / W912PL19C0015 Federal Contract Action Summary (Last 5 Years)
Award number W912PL19C0015 for agency ID 9700 shows seven recorded actions in the last five years with total obligated amount of -$322.85 million.
All values are based on the provided analysis window of the last five years and the recorded action-level obligation totals.
Overview
The award record for W912PL19C0015 contains seven actions within the last five years. The total obligated amount is -$322,845,750.53, with an average action value of -$46,120,821.50.
How to use this page
Use this page to review the award number, the agency ID, and the obligation totals tied to the recorded actions. The figures support basic procurement analysis within the stated five-year window without adding details not present in the source inputs.
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 = 'W912PL19C0015'
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 | -322,845,750.53 | -322.85 million | 7 |
Insight
Over the 5-year window, obligations are entirely concentrated in DEPT OF THE ARMY, which accounts for the full reported activity for this award. The seven awards associated with this agency total -$322.85 million, indicating a single-agency funding profile with no diversification across other agencies in the provided data. The negative obligated amount suggests net deobligations or adjustments rather than net new funding during the period.
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 = 'W912PL19C0015'
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 |
|---|---|---|---|---|
| SOUTHWEST VALLEY CONSTRUCTORS CO | 7V2D3 | -322,845,750.53 | -322.85 million | 7 |
Insight
Over the 5-year window, obligations for award W912PL19C0015 are fully concentrated with SOUTHWEST VALLEY CONSTRUCTORS CO (CAGE 7V2D3), which accounts for the only reported vendor activity in this section. The vendor received 7 award actions totaling -322.85 million in obligated value, indicating all recorded obligations in this query are tied to a single contractor. This pattern reflects complete vendor concentration and no observable distribution across additional top vendors.
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 = 'W912PL19C0015'
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 |
|---|---|---|---|---|
| 237310 | HIGHWAY, STREET, AND BRIDGE CONSTRUCTION | -322,845,750.53 | -322.85 million | 7 |
Insight
Obligations for PIID W912PL19C0015 are fully concentrated in NAICS 237310, Highway, Street, and Bridge Construction, over the 5-year window. This NAICS accounts for 7 awards and a total obligated amount of -$322.85 million, indicating all recorded activity in this view is within a single construction sector. The negative total obligated value should be interpreted in the context of contract adjustments or deobligations reflected in FPDS.
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 = 'W912PL19C0015'
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 |
|---|---|---|---|---|
| Y1LB | CONSTRUCTION OF HIGHWAYS, ROADS, STREETS, BRIDGES, AND RAILWAYS | -322,845,750.53 | -322.85 million | 7 |
Insight
Over the 5-year window, obligations for this award are entirely concentrated in PSC Y1LB, with seven actions totaling -$322.85 million. This indicates the award’s reported funding is not diversified across multiple PSCs in the provided data. The negative obligated amount should be interpreted as a net deobligation or adjustment for this PSC over the period.
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 = 'W912PL19C0015'
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 | 484,658.00 | 484.66 thousand | 5 |
| 2024 | -48,524,941.28 | -48.52 million | 1 |
| 2025 | -274,805,467.25 | -274.81 million | 1 |
Insight
Obligations are highly concentrated and episodic over the 5-year window, with five awards in 2021 totaling $484.66 thousand and single-award activity in 2024 and 2025. The later years show substantial negative obligated amounts of $48.52 million in 2024 and $274.81 million in 2025, indicating a pronounced downward shift in net obligations. The pattern suggests limited award frequency but outsized year-to-year volatility, driven by one transaction in each of the later 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 5 years view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.