This award record identifies PIID W15QKN21C0012 under agency ID 9700. In the last full year, the award had one action and a total obligated amount of -30.00.
Award Number
Award Number 9700 / W15QKN21C0012 Federal Contract Action Summary (Last Year)
Award W15QKN21C0012 for agency 9700 shows one recorded action in the last full year with total obligations of -30.00.
Values shown here reflect the supplied analysis window and may include negative obligations as recorded in the source data.
Agency ID
9700
PIID
W15QKN21C0012
Type
Award
Total Obligated
-30.00
-30.00
Actions
1
Average Action Value
-30.00
Overview
The award record for PIID W15QKN21C0012 is associated with agency ID 9700. For the last full year, the record shows one award action with an average action value of -30.00 and total obligated amount of -30.00. This page reflects the supplied award-level data only.
How to use this page
Use this page to review the award number and its obligation activity for the selected time window. The single recorded action and negative obligated total provide a compact view of the award’s recent transactional history.
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 = 'W15QKN21C0012'
AND content__award__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
AND content__award__purchaserInformation__contractingOfficeAgencyID != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 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 | -30.00 | -30.00 | 1 |
Insight
Within the 1-year window for PIID W15QKN21C0012, obligations are concentrated entirely with DEPT OF THE ARMY (agency ID 2100), which accounts for the only recorded award activity in the provided rows. The single award reflects a net obligated amount of -$30.00, indicating a small downward adjustment rather than positive funding growth. No additional agencies appear in the provided data, so there is no evidence of broader distribution across agencies in this 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 = 'W15QKN21C0012'
AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
AND content__award__vendor__vendorHeader__vendorName != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 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 | -30.00 | -30.00 | 1 |
Insight
Over the 1-year window for award W15QKN21C0012, obligations are fully concentrated with PFIZER INC. (CAGE 86491), which accounts for the only recorded vendor activity in this section. The award count is 1 and the total obligated amount is -$30.00, indicating a minimal net deobligation rather than positive funding. This reflects very limited vendor distribution and no meaningful diversification in obligated activity.
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 = 'W15QKN21C0012'
AND content__award__productOrServiceInformation__principalNAICSCode IS NOT NULL
AND content__award__productOrServiceInformation__principalNAICSCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 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 |
|---|---|---|---|---|
| 325414 | BIOLOGICAL PRODUCT (EXCEPT DIAGNOSTIC) MANUFACTURING | -30.00 | -30.00 | 1 |
Insight
Over the past 1 year, obligations for award W15QKN21C0012 under agency 9700 were fully concentrated in NAICS 325414, Biological Product (except Diagnostic) Manufacturing. This NAICS accounted for a single recorded award action with a total obligated amount of -$30.00, indicating a minimal net downward adjustment rather than substantive spending. No other NAICS codes appear in the provided data for this period, so the distribution is entirely concentrated in one category.
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 = 'W15QKN21C0012'
AND content__award__productOrServiceInformation__productOrServiceCode IS NOT NULL
AND content__award__productOrServiceInformation__productOrServiceCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 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 | -30.00 | -30.00 | 1 |
Insight
For award W15QKN21C0012 in the 1-year window, obligations are fully concentrated in PSC 6505, Drugs and Biologicals. This PSC accounts for a single award line with a net obligated value of -$30.00, indicating a minimal and negative obligation movement rather than sustained spending. The distribution is highly concentrated, with no other PSCs represented in the provided data.
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 = 'W15QKN21C0012'
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 1 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC| Year | Total Obligated | Readable | Actions |
|---|---|---|---|
| 2025 | -30.00 | -30.00 | 1 |
Insight
For award W15QKN21C0012 in Agency 9700 over the 1-year window, obligations are concentrated entirely in FY2025, with one recorded action. The single-year total obligated amount is -30.00, indicating a net deobligation rather than positive funding. With only one year represented, no multi-year trend can be inferred from this query window.
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 full year view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.