This page summarizes the award number N0002496F4060 for agency ID 9700 across the last 5 years. The record shows one award action with total obligations of $316,000,000.
Award Number
Award Number 9700 / N0002496F4060 Federal Contract Action Summary (Last 5 Years)
FPDS award record for agency ID 9700 and PIID N0002496F4060 showing one action and $316.00 million obligated over the last 5 years.
Dollar figures are based on the provided total obligated exact value of 316000000 and the readable amount of 316.00 million.
Agency ID
9700
PIID
N0002496F4060
Type
Award
Total Obligated
316.00 million
316,000,000.00
Actions
1
Average Action Value
316,000,000.00
Overview
The award record for PIID N0002496F4060 under agency ID 9700 reflects a single reported action in the analysis window. Total obligated amount is $316,000,000, which also equals the average action value because only one action is recorded.
How to use this page
Use this page to review the basic award-level totals reported for the selected period. It is suited to quick reference on obligation volume, action count, and the relationship between the total and average action value.
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 = 'N0002496F4060'
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 |
|---|---|---|---|---|
| 1700 | DEPT OF THE NAVY | 316,000,000.00 | 316.00 million | 1 |
Insight
Within the 5-year window for award N0002496F4060, obligations are fully concentrated in a single top agency: the Department of the Navy. This agency accounts for the entire $316.00 million reported and is associated with one award record, indicating no observable distribution across additional 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 = 'N0002496F4060'
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 |
|---|---|---|---|---|
| ENERGY, UNITED STATES DEPT OF | 316,000,000.00 | 316.00 million | 1 |
Insight
Obligations for PIID N0002496F4060 are fully concentrated in a single vendor, ENERGY, UNITED STATES DEPT OF, which accounts for $316.00 million across 1 award in the 5-year window. This indicates no vendor diversification within the reported award data and suggests the award activity is entirely tied to this one recipient.
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 = 'N0002496F4060'
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 |
|---|---|---|---|---|
| 332410 | POWER BOILER AND HEAT EXCHANGER MANUFACTURING | 316,000,000.00 | 316.00 million | 1 |
Insight
Over the 5-year window, obligations for PIID N0002496F4060 are fully concentrated in NAICS 332410, Power Boiler and Heat Exchanger Manufacturing. This category accounts for the entire reported obligation total of $316.00 million across a single award, indicating no diversification across NAICS codes in the provided data. The pattern reflects a highly concentrated procurement profile for this award.
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 = 'N0002496F4060'
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 |
|---|---|---|---|---|
| 2010 | SHIP AND BOAT PROPULSION COMPONENTS | 316,000,000.00 | 316.00 million | 1 |
Insight
Award obligations in the 5-year window are fully concentrated in PSC 2010, Ship and Boat Propulsion Components, with $316.0 million across a single award. This indicates no distribution across additional PSCs for the cited award and suggests a highly specialized procurement profile.
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 = 'N0002496F4060'
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 | 316,000,000.00 | 316.00 million | 1 |
Insight
Over the 5-year window, activity for PIID N0002496F4060 is concentrated entirely in 2021, with one award accounting for $316.00 million in total obligated amount. This indicates no observable year-over-year distribution within the provided period and suggests a single-year obligation profile rather than a recurring annual trend.
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.