Award Number

Award Number 8900 / DENR0000031 Federal Contract Action Summary (Last Year)

Federal award record for award number DENR0000031 under agency ID 8900, showing no recorded obligations or actions in the last full year.

This page summarizes the award identified by PIID DENR0000031 for agency ID 8900. In the last full year, the award shows zero obligated dollars and no recorded award actions.

Last full year Last 5 years Last 10 years

Generated at 03/20/2026

Analysis period: Last full year

Analysis is based on the last full year and reflects total obligated amount of 0.00, award action count of 0, and average action value of 0.

Agency ID

8900

PIID

DENR0000031

Type

Award

Total Obligated

0.00

Actions

Average Action Value

0.00

Overview

The award record for DENR0000031 is associated with agency ID 8900. For the last full year, the available data show no obligated amount, no award actions, and an average action value of zero.

How to use this page

Use this page to confirm the award identifier and review its reported activity for the selected analysis window. Because the current record shows no obligations or actions, it is mainly useful as a lookup and verification reference.

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 = '8900' AND content__award__awardID__awardContractID__PIID = 'DENR0000031'
    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

Insight

No agency concentration was available for this analysis 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 = '8900' AND content__award__awardID__awardContractID__PIID = 'DENR0000031'
        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

Insight

No vendor concentration was available for this analysis window.

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 = '8900' AND content__award__awardID__awardContractID__PIID = 'DENR0000031'
    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

Insight

No NAICS concentration was available for this analysis window.

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 = '8900' AND content__award__awardID__awardContractID__PIID = 'DENR0000031'
    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

Insight

No PSC concentration was available for this analysis window.

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 = '8900' AND content__award__awardID__awardContractID__PIID = 'DENR0000031'
    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

Insight

No annual trend data was available for this analysis 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.

Start 7-Day Trial Learn More