Award Number

Award Number 9700 / W911QY21C0031 Federal Contract Action Summary (Last 10 Years)

FPDS award record for award number W911QY21C0031 under agency ID 9700, showing obligations and action history over the last 10 years.

This page summarizes the procurement award identified by PIID W911QY21C0031 for agency ID 9700. The record shows 7 award actions and total obligated dollars of 2.21 billion across the analysis window.

Last full year Last 5 years Last 10 years

Generated at 03/20/2026

Analysis period: Last 10 years

Totals reflect the last 10 years of available award activity; exact obligated value is 2,205,000,834 and the average action value is 315,000,119.14.

Agency ID

9700

PIID

W911QY21C0031

Type

Award

Total Obligated

2.21 billion

2,205,000,834.00

Actions

Average Action Value

315,000,119.14

Overview

The award number W911QY21C0031 is associated with agency ID 9700 and shows 7 recorded actions in the analysis window. Total obligated dollars for the period are 2,205,000,834, which rounds to 2.21 billion, with an average action value of 315,000,119.14. This page is intended to support review of the award’s obligation history and action count over time.

How to use this page

Use this page to identify the award by PIID, review its obligation total, and compare the overall activity level across the last 10 years. The action count and average action value provide a quick reference for assessing how obligations were distributed across recorded actions.

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 = 'W911QY21C0031'
    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	2,205,000,834.00	2.21 billion	7

Insight

For PIID W911QY21C0031 over the 10-year window, obligations are fully concentrated in a single agency: the Department of the Army (agency ID 2100). The Army accounts for $2.21 billion across 7 awards, indicating that all recorded obligated activity in this scope is tied to one agency rather than distributed across multiple agencies. This concentration suggests a highly focused procurement relationship with no diversification across other top 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 = 'W911QY21C0031'
        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
MERCK SHARP & DOHME CORP.	6B2S4	2,205,000,834.00	2.21 billion	7

Insight

MERCK SHARP & DOHME CORP. is the sole top vendor identified for PIID W911QY21C0031 over the 10-year window, accounting for $2.21 billion across 7 awards. Obligations are fully concentrated with a single vendor, indicating a highly concentrated award profile with no diversification among top recipients in this dataset. This concentration suggests the award’s obligated value has been consistently directed to one contractor rather than distributed across multiple 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 = 'W911QY21C0031'
    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
325412	PHARMACEUTICAL PREPARATION MANUFACTURING	2,205,000,834.00	2.21 billion	7

Insight

Over the 10-year window, obligations for award W911QY21C0031 are fully concentrated in NAICS 325412, Pharmaceutical Preparation Manufacturing. This NAICS accounts for 2.21 billion across 7 awards, indicating a narrow industrial profile and repeated use of the same sector. The distribution suggests sustained obligation activity within a single NAICS rather than diversification across multiple industries.

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 = 'W911QY21C0031'
    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
6505	DRUGS AND BIOLOGICALS	2,205,000,834.00	2.21 billion	7

Insight

Obligations under PIID W911QY21C0031 are fully concentrated in PSC 6505, Drugs and Biologicals, with $2.21 billion obligated across 7 awards over the 10-year window. This pattern indicates a highly focused procurement profile with no diversification across other PSCs in the provided data. The award activity is limited in count but materially significant in dollar value, suggesting substantial individual obligations within the same 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 = 'W911QY21C0031'
    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
2021	2,204,799,848.00	2.20 billion	4
2022	200,986.00	200.99 thousand	2
2023	0.00	0.00	1

Insight

Obligations for PIID W911QY21C0031 are highly concentrated in 2021, when 4 awards accounted for $2.20 billion. Activity drops sharply in 2022 to $200.99 thousand across 2 awards, and 2023 records 1 award with no obligated amount. Over the 10-year window, the pattern indicates a one-year obligation spike followed by minimal subsequent funding.

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.

Start 7-Day Trial Learn More