This page provides a procurement record view for vehicle number associated with Agency ID 12K2 and PIID 123J1417C0011. The available award history shows 2 award actions in the last 5 years.
Vehicle Number
Vehicle Number 12K2 / 123J1417C0011 Federal Contract Action Summary (Last 5 Years)
Analyst summary for vehicle number in FPDS, covering Agency ID 12K2, PIID 123J1417C0011, and activity in the last 5 years.
Reported obligated dollars are 0.00, with an exact total obligated value of 0 and an average action value of 0.
Agency ID
12K2
PIID
123J1417C0011
Type
Vehicle
Total Obligated
0.00
0.00
Actions
2
Average Action Value
0.00
Overview
This procurement page summarizes the FPDS record for vehicle number tied to Agency ID 12K2 and PIID 123J1417C0011. Over the last 5 years, the record includes 2 award actions and no reported obligated dollars. The average action value is 0.
How to use this page
Use this page to review the basic award footprint for vehicle number and to confirm the reported financial totals. The page is most useful for quick identification, record matching, and high-level search discovery.
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 = '12K2' AND content__IDV__contractID__IDVID__PIID = '123J1417C0011'
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 |
|---|---|---|---|---|
| 12K2 | AGRICULTURAL MARKETING SERVICE | 0.00 | 0.00 | 2 |
Insight
Within the 5-year window for vehicle PIID 123J1417C0011, obligations are entirely concentrated in Agricultural Marketing Service (12K2). The agency accounts for 2 awards, but total obligated dollars are reported as 0.00, indicating award activity without recorded funding value in this view. This suggests the vehicle’s observed use in the period is limited and not distributed across multiple agencies.
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 = '12K2' AND content__IDV__contractID__IDVID__PIID = '123J1417C0011'
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 = '12K2' AND content__IDV__contractID__IDVID__PIID = '123J1417C0011'
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 |
|---|---|---|---|---|
| 311421 | FRUIT AND VEGETABLE CANNING | 0.00 | 0.00 | 2 |
Insight
Within the 5-year window for vehicle 12K2 and PIID 123J1417C0011, obligations in the top NAICS category are concentrated in NAICS 311421, Fruit and Vegetable Canning. This category accounts for 2 awards but records $0.00 obligated, indicating award activity without associated obligation value in the provided data. The result suggests limited financial concentration in this NAICS within the queried record set.
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 = '12K2' AND content__IDV__contractID__IDVID__PIID = '123J1417C0011'
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 |
|---|---|---|---|---|
| 8915 | FRUITS AND VEGETABLES | 0.00 | 0.00 | 2 |
Insight
For PIID 123J1417C0011 over the 5-year window, obligations are concentrated entirely in PSC 8915 (Fruits and Vegetables). Although there are 2 awards in this PSC, reported total obligated amount is $0.00, indicating activity without recorded obligation value in the provided data. This suggests a narrow PSC distribution for the vehicle, with no diversification across other product/service categories in the rows provided.
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 = '12K2' AND content__IDV__contractID__IDVID__PIID = '123J1417C0011'
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 |
|---|---|---|---|
| 2023 | 0.00 | 0.00 | 2 |
Insight
For agency 12K2 vehicle 123J1417C0011, the 5-year annual trend data provided includes activity only in FY 2023. Obligations were $0.00 across 2 awards, indicating the vehicle has recorded award actions in the period but no associated obligated dollars in the supplied data. With only one year represented, no multi-year trend in obligation volume or distribution can be assessed.
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.