This page summarizes FPDS procurement data for the National Capital Planning Commission over the last full year. The available records show 0 award actions, so there is no obligated amount, average action value, vendor concentration, NAICS mix, or annual spending trend to report from the provided inputs.
Federal Agency
NATIONAL CAPITAL PLANNING COMMISSION Federal Contract Obligations (Last Year)
Federal procurement activity for the National Capital Planning Commission (Agency ID 9502) during the last full year shows no recorded award actions.
No award actions were recorded in the analysis window, so the dataset contains no obligations or related breakdowns.
About NATIONAL CAPITAL PLANNING COMMISSION federal contract activity
During the last full year, the National Capital Planning Commission recorded no FPDS awards in the provided data, with an award count of 0 and no reported obligated amount. As a result, there is no measurable procurement activity to summarize for this analysis period.
Vendor concentration and leading contractors
No vendors appear in the supplied dataset for the analysis window. Without award records, there is no basis to identify recurring contractors, vendor concentration, or supplier mix.
Industry profile based on NAICS activity
No NAICS codes are associated with recorded awards in the provided data. This prevents any assessment of procurement by industry category or spending distribution across NAICS groups.
Annual contract trend over the analysis window
No annual trend can be established because the analysis window contains no award activity. With zero recorded awards and no obligated dollars, there is no year-over-year or intra-year movement to evaluate.
How to interpret this page
This page reflects FPDS Query data for the National Capital Planning Commission, Agency ID 9502, using the last full year as the analysis window. The narrative is limited to the metrics provided: total obligated amount, award count, average award value, top vendors, top NAICS codes, and annual trend.
Top Vendors
SELECT
vendor_name,
total_obligated,
award_count,
formatReadableQuantity(total_obligated) AS total_obligated_readable
FROM
(
SELECT
content__award__vendor__vendorHeader__vendorName AS vendor_name,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count
FROM fpds.data
WHERE
contract_type = 1
AND content__award__purchaserInformation__contractingOfficeAgencyID = '9502'
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
)
ORDER BY total_obligated DESC
LIMIT 10
| Vendor | Total Obligated | Readable | Award Actions |
|---|
Insight
No notable vendor concentration was available for this analysis window.
Top NAICS
SELECT
naics_code,
naics_name,
total_obligated,
award_count,
formatReadableQuantity(total_obligated) AS total_obligated_readable
FROM
(
SELECT
content__award__productOrServiceInformation__principalNAICSCode AS naics_code,
anyHeavy(content__award__productOrServiceInformation__principalNAICSCode__description) AS naics_name,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count
FROM fpds.data
WHERE
contract_type = 1
AND content__award__purchaserInformation__contractingOfficeAgencyID = '9502'
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
)
ORDER BY total_obligated DESC
LIMIT 10
| NAICS Code | Description | Total Obligated | Readable | Award Actions |
|---|
Insight
No notable NAICS concentration was available for this analysis window.
Annual Trend
SELECT
year,
total_obligated,
award_count,
formatReadableQuantity(total_obligated) AS total_obligated_readable
FROM
(
SELECT
toYear(parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate)) AS year,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count
FROM fpds.data
WHERE
contract_type = 1
AND content__award__purchaserInformation__contractingOfficeAgencyID = '9502'
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 DESC
| Year | Total Obligated | Readable | Award Actions |
|---|
Insight
No annual trend data was available for this analysis window.
Use FPDS Query for deeper analysis
Explore federal procurement data with custom SQL, fast filtering, and deeper market analysis across agencies, vendors, NAICS, and contract trends.
Continue from this last full year view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.