This page summarizes procurement activity tied to award W58P0522C0001 under agency ID 9700 over the last 5 years. The award shows 8 actions and 12,549,999,847.5 in total obligated value, with an average action value of 1,568,749,980.94.
Award Number
Award Number 9700 / W58P0522C0001 Federal Contract Action Summary (Last 5 Years)
Award number W58P0522C0001 for agency 9700 covers 8 recorded actions in the last 5 years, with total obligations of 12.55 billion.
Values reflect the provided analysis window and may differ from other reports depending on timing and rounding.
Overview
This award page is centered on PIID W58P0522C0001 and the procurement activity recorded for agency ID 9700 in the last 5 years. The award has 8 actions and a total obligated amount of 12,549,999,847.5, which is the basis for the summary shown here. The average action value is 1,568,749,980.94, indicating that the recorded activity is concentrated in relatively large-dollar actions. This overview is limited to the values provided for the award and does not add contract details beyond those inputs.
How to use this page
Use this page to review the award-level obligation total and action count for W58P0522C0001. It can support basic procurement review, search indexing, and cross-checking against other FPDS-derived summaries. The analysis window is the last 5 years, so the figures should be interpreted as a recent-history snapshot rather than a full lifecycle record. For comparisons, rely on the exact obligated amount and action count rather than rounded values.
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 = 'W58P0522C0001'
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 | 12,549,999,847.50 | 12.55 billion | 8 |
Insight
Obligations for this award are fully concentrated in one agency: the Department of the Army, which accounts for $12.55 billion across 8 awards. This indicates a highly concentrated funding profile with no distribution across other agencies in the provided results. The pattern suggests the award is tied primarily to Army activity over the 5-year window.
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 = 'W58P0522C0001'
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 |
|---|---|---|---|---|
| PFIZER INC. | 86491 | 12,549,999,847.50 | 12.55 billion | 8 |
Insight
PFIZER INC. is the sole top vendor associated with this award record over the 5-year window, with $12.55 billion in total obligated funding across 8 awards. This indicates a highly concentrated vendor profile, with all observed obligations attributed to one contractor. The limited vendor distribution suggests this award activity is not diversified across multiple suppliers within the available data.
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 = 'W58P0522C0001'
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 |
|---|---|---|---|---|
| 325412 | PHARMACEUTICAL PREPARATION MANUFACTURING | 12,549,999,847.50 | 12.55 billion | 8 |
Insight
Obligations for PIID W58P0522C0001 over the 5-year window are fully concentrated in NAICS 325412, Pharmaceutical Preparation Manufacturing, with $12.55 billion across 8 awards. This indicates a highly concentrated spend profile with no diversification across additional NAICS codes in the provided data. The award activity is limited in count but very large in dollar value, suggesting a small number of high-value actions within a single industry classification.
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 = 'W58P0522C0001'
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 |
|---|---|---|---|---|
| 6505 | DRUGS AND BIOLOGICALS | 12,549,999,847.50 | 12.55 billion | 8 |
Insight
Over the 5-year window, obligations under PIID W58P0522C0001 are fully concentrated in PSC 6505, Drugs and Biologicals, with $12.55 billion obligated across 8 awards. This indicates a narrow product mix and high dependence on a single PSC category. The concentration suggests limited distribution across PSCs 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 = '9700' AND content__award__awardID__awardContractID__PIID = 'W58P0522C0001'
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 | 5,295,000,000.00 | 5.29 billion | 1 |
| 2022 | 7,254,999,847.50 | 7.25 billion | 5 |
| 2023 | 0.00 | 0.00 | 2 |
Insight
Obligations for PIID W58P0522C0001 were concentrated in 2021 and 2022, with 5.29 billion obligated across 1 award in 2021 and 7.25 billion across 5 awards in 2022. In 2023, there were 2 awards recorded with zero obligated dollars, indicating award activity without reported obligation in that year. Overall, the five-year window reflects a sharp concentration of obligated funding in the first two years followed by no obligated value in the latest year provided.
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.