This page summarizes award activity for vehicle number AID267H1700001 within agency ID 7200 during the last 5 years. The record shows 7 award actions with a total obligated amount of 11.86 million.
Vehicle Number
Vehicle Number 7200 / AID267H1700001 Federal Contract Action Summary (Last 5 Years)
Federal procurement summary for vehicle number AID267H1700001 at agency 7200 over the last 5 years.
Amount figures are based on the provided total obligated exact value of 11859020 and the readable rounded value of 11.86 million.
Overview
Across the last 5 years, vehicle number AID267H1700001 recorded 7 award actions tied to agency 7200. The total obligated amount is 11,859,020, with an average action value of 1,694,145.71. This page is limited to the provided award-level totals and does not add contract details not included in the source inputs.
How to use this page
Use this page to review the overall obligation pattern for PIID AID267H1700001 and compare the average action value against the total awarded amount. The figures support a quick procurement-level scan of activity at agency 7200 without inferring scope, performance, or vehicle type beyond the supplied label.
Top Agencies
SELECT
content__IDV__purchaserInformation__contractingOfficeAgencyID AS agency_id,
content__IDV__purchaserInformation__contractingOfficeAgencyID__name AS agency_name,
sum(content__IDV__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count,
formatReadableQuantity(sum(content__IDV__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
content__IDV__contractID__IDVID__agencyID = '7200' AND content__IDV__contractID__IDVID__PIID = 'AID267H1700001'
AND content__IDV__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
AND content__IDV__purchaserInformation__contractingOfficeAgencyID != ''
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__IDV__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 |
|---|---|---|---|---|
| 7200 | AGENCY FOR INTERNATIONAL DEVELOPMENT | 11,859,020.00 | 11.86 million | 7 |
Insight
Across the 5-year window, all reported obligation under vehicle AID267H1700001 is concentrated within Agency for International Development (agency ID 7200), totaling $11.86 million across 7 awards. This indicates the vehicle’s use is fully attributable to a single agency in the provided data, with no distribution across additional agencies. The award pattern suggests repeated use by the same agency rather than broad interagency utilization.
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__IDV__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count
FROM fpds.data
WHERE
content__IDV__contractID__IDVID__agencyID = '7200' AND content__IDV__contractID__IDVID__PIID = 'AID267H1700001'
AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
AND content__award__vendor__vendorHeader__vendorName != ''
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__IDV__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__IDV__productOrServiceInformation__principalNAICSCode AS naics_code,
content__IDV__productOrServiceInformation__principalNAICSCode__description AS naics_name,
sum(content__IDV__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count,
formatReadableQuantity(sum(content__IDV__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
content__IDV__contractID__IDVID__agencyID = '7200' AND content__IDV__contractID__IDVID__PIID = 'AID267H1700001'
AND content__IDV__productOrServiceInformation__principalNAICSCode IS NOT NULL
AND content__IDV__productOrServiceInformation__principalNAICSCode != ''
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
naics_code,
naics_name
ORDER BY total_obligated DESC
LIMIT 10
| NAICS Code | Description | Total Obligated | Readable | Actions |
|---|---|---|---|---|
| 541990 | ALL OTHER PROFESSIONAL, SCIENTIFIC, AND TECHNICAL SERVICES | 11,859,020.00 | 11.86 million | 7 |
Insight
Over the 5-year window, obligations for vehicle AID267H1700001 are concentrated entirely in NAICS 541990, All Other Professional, Scientific, and Technical Services. This category accounts for $11.86 million across 7 awards, indicating a narrow procurement profile with all observed activity mapped to a single NAICS code. The pattern suggests limited NAICS distribution and no diversification across other industries in the provided data.
Top PSC Codes
SELECT
content__IDV__productOrServiceInformation__productOrServiceCode AS psc_code,
content__IDV__productOrServiceInformation__productOrServiceCode__description AS psc_name,
sum(content__IDV__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count,
formatReadableQuantity(sum(content__IDV__dollarValues__obligatedAmount)) AS total_obligated_readable
FROM fpds.data
WHERE
content__IDV__contractID__IDVID__agencyID = '7200' AND content__IDV__contractID__IDVID__PIID = 'AID267H1700001'
AND content__IDV__productOrServiceInformation__productOrServiceCode IS NOT NULL
AND content__IDV__productOrServiceInformation__productOrServiceCode != ''
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY
psc_code,
psc_name
ORDER BY total_obligated DESC
LIMIT 10
| PSC Code | Description | Total Obligated | Readable | Actions |
|---|---|---|---|---|
| R408 | SUPPORT- PROFESSIONAL: PROGRAM MANAGEMENT/SUPPORT | 11,859,020.00 | 11.86 million | 7 |
Insight
Over the 5-year window, obligations under PIID AID267H1700001 are fully concentrated in PSC R408, Support- Professional: Program Management/Support. This PSC accounts for $11.86 million across 7 awards, indicating a narrow procurement profile with spending concentrated in a single professional support category. The distribution suggests limited PSC diversity for this vehicle during the period reviewed.
Annual Trend
SELECT
toYear(parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate)) AS year,
sum(content__IDV__dollarValues__obligatedAmount) AS total_obligated,
formatReadableQuantity(sum(content__IDV__dollarValues__obligatedAmount)) AS total_obligated_readable,
count() AS award_count
FROM fpds.data
WHERE
content__IDV__contractID__IDVID__agencyID = '7200' AND content__IDV__contractID__IDVID__PIID = 'AID267H1700001'
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC
| Year | Total Obligated | Readable | Actions |
|---|---|---|---|
| 2021 | 9,909,020.00 | 9.91 million | 4 |
| 2022 | 1,950,000.00 | 1.95 million | 3 |
Insight
For PIID AID267H1700001, obligations were concentrated in 2021, with $9.91 million across 4 awards, compared with $1.95 million across 3 awards in 2022. This indicates a sharp year-over-year decline in obligated dollars, while award activity remained relatively limited and only slightly lower. Over the 5-year window provided, the visible activity is concentrated in these two years, with 2021 representing the dominant funding level.
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.