This page summarizes procurement activity for award number W31P4Q20C0023 over the last 10 years. It shows 349 award actions with total obligated funding of $10.48 billion and an average action value of $30,014,909.94.
Award Number
Award Number 9700 / W31P4Q20C0023 Federal Contract Action Summary (Last 10 Years)
FPDS award page for award number W31P4Q20C0023 under agency ID 9700, covering the last 10 years of reported obligations and actions.
Totals reflect the provided FPDS analysis window and may not represent the full lifecycle value of the award.
Overview
The record for award number W31P4Q20C0023 shows sustained procurement activity across the last 10 years, with 349 reported actions and $10.48 billion in obligated funding. The average action value is $30,014,909.94, which indicates a high-value award history within the reported period. This page is organized to support review of award-level obligation patterns under agency ID 9700.
How to use this page
Use this page to review obligation volume, action count, and average action value for W31P4Q20C0023 within the selected 10-year window. It is useful for identifying how the award has changed over time and for comparing award-level activity against other FPDS records tied to agency ID 9700.
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 = 'W31P4Q20C0023'
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 |
|---|---|---|---|---|
| 2100 | DEPT OF THE ARMY | 10,475,203,567.90 | 10.48 billion | 349 |
Insight
Over the 10-year window for award PIID W31P4Q20C0023, obligations in the top-agencies view are fully concentrated in a single agency, the Department of the Army. The Army accounts for $10.48 billion across 349 awards, indicating a highly concentrated obligation pattern with no evidence of distribution 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 = '9700' AND content__award__awardID__awardContractID__PIID = 'W31P4Q20C0023'
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 |
|---|---|---|---|---|
| LOCKHEED MARTIN CORPORATION | 64059 | 10,475,203,567.90 | 10.48 billion | 349 |
Insight
LOCKHEED MARTIN CORPORATION accounts for all reported obligation in this 10-year award view for PIID W31P4Q20C0023 under agency 9700, indicating complete vendor concentration. The vendor total is $10.48 billion across 349 awards, showing a high-volume, high-dollar relationship concentrated with a single supplier. This distribution suggests the award activity captured here is not diversified across 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 = 'W31P4Q20C0023'
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 |
|---|---|---|---|---|
| 336414 | GUIDED MISSILE AND SPACE VEHICLE MANUFACTURING | 10,475,203,567.90 | 10.48 billion | 349 |
Insight
Over the 10-year window, award PIID W31P4Q20C0023 is entirely concentrated in NAICS 336414, Guided Missile and Space Vehicle Manufacturing. This NAICS accounts for $10.48 billion across 349 awards, indicating a sustained and 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 = '9700' AND content__award__awardID__awardContractID__PIID = 'W31P4Q20C0023'
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 |
|---|---|---|---|---|
| 1410 | GUIDED MISSILES | 10,475,203,567.90 | 10.48 billion | 349 |
Insight
Within the 10-year window for award W31P4Q20C0023, obligations are fully concentrated in PSC 1410, Guided Missiles, totaling $10.48 billion across 349 awards. This indicates a highly focused procurement profile with no observable PSC diversification in the provided data. The volume of awards paired with the large obligated amount suggests sustained contracting activity in a single product category.
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 = 'W31P4Q20C0023'
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 |
|---|---|---|---|
| 2020 | 4,516,450,534.01 | 4.52 billion | 16 |
| 2021 | 940,998,762.32 | 941.00 million | 24 |
| 2022 | 1,700,085,353.15 | 1.70 billion | 41 |
| 2023 | 3,007,992,253.00 | 3.01 billion | 67 |
| 2024 | 194,920,862.16 | 194.92 million | 110 |
| 2025 | 114,755,803.26 | 114.76 million | 91 |
Insight
Obligations for PIID W31P4Q20C0023 are highly concentrated in 2020, when spending reached 4.52 billion across 16 awards, far exceeding subsequent years. From 2021 through 2023, obligated amounts remained in the hundreds of millions to low billions while award counts increased from 24 to 67, indicating broader distribution of activity. In 2024 and 2025, obligations declined sharply to 194.92 million and 114.76 million even as award counts remained elevated at 110 and 91, suggesting a shift toward a larger number of smaller-dollar awards.
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.