This page summarizes federal award activity for award number W58P0522C0002 within agency 9700 over the last 5 years. The award has 7 recorded actions and $1,597,461,996 in total obligated dollars.
Award Number
Award Number 9700 / W58P0522C0002 Federal Contract Action Summary (Last 5 Years)
Award number W58P0522C0002 for agency 9700 shows 7 actions over the last 5 years and $1.60 billion in total obligated amount.
Dollar figures are based on the provided total obligated exact value and readable rounded amount.
Overview
The award record for W58P0522C0002 shows 7 actions in the last 5 years, with total obligated dollars of $1,597,461,996. The average action value is $228,208,856.57, indicating that the award history is concentrated in a small number of high-value actions. This page is intended to support review of award-level obligation trends for agency 9700.
How to use this page
Use this page to assess how obligations are distributed across the award action history for W58P0522C0002. The figures can help with basic procurement analysis, such as identifying overall scale, action count, and average action size within the selected 5-year window.
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 = 'W58P0522C0002'
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,597,461,996.00 | 1.60 billion | 7 |
Insight
Within the 5-year window for award PIID W58P0522C0002, obligations are concentrated entirely under DEPT OF THE ARMY (agency ID 2100). That agency accounts for the full $1.60 billion in obligated value across 7 awards, indicating a single-agency funding profile with no visible distribution across other top agencies in the provided data. This concentration suggests the award activity is heavily focused within one agency rather than spread across multiple departments.
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 = 'W58P0522C0002'
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 |
|---|---|---|---|---|
| GLAXOSMITHKLINE LLC | 667E9 | 1,597,461,996.00 | 1.60 billion | 7 |
Insight
GLAXOSMITHKLINE LLC is the sole vendor listed and accounts for the full reported obligation in this 5-year window, with $1.60 billion across 7 awards. This indicates complete concentration of obligations with a single vendor under PIID W58P0522C0002. The distribution reflects a highly focused award pattern rather than a broad vendor base.
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 = 'W58P0522C0002'
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 | 1,597,461,996.00 | 1.60 billion | 7 |
Insight
Obligations under PIID W58P0522C0002 in the 5-year window are fully concentrated in NAICS 325412, Pharmaceutical Preparation Manufacturing. This NAICS accounts for $1.60 billion across 7 awards, indicating a narrow procurement footprint with spending concentrated in a single industry category. No other NAICS categories are reflected in the provided rows.
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 = 'W58P0522C0002'
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 | 1,597,461,996.00 | 1.60 billion | 7 |
Insight
Award obligations under PIID W58P0522C0002 are fully concentrated in PSC 6505, Drugs and Biologicals, with $1.60 billion obligated across 7 awards over the 5-year window. This indicates a narrow procurement mix and a strong dependence on a single product/service category. The small award count relative to total obligations suggests comparatively high-dollar transactions within this PSC.
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 = 'W58P0522C0002'
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 | 651,094,500.00 | 651.09 million | 1 |
| 2022 | 945,807,496.00 | 945.81 million | 5 |
| 2023 | 560,000.00 | 560.00 thousand | 1 |
Insight
Obligations for PIID W58P0522C0002 are highly concentrated in 2021 and 2022, with $651.09 million across 1 award in 2021 and $945.81 million across 5 awards in 2022. The 2023 activity is minimal by comparison, at $560.00 thousand across 1 award, indicating a sharp drop in annual obligation volume. Over the 5-year window provided, the pattern reflects a short period of heavy funding followed by a pronounced decline.
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.