Vehicle Number

Vehicle Number 12K2 / 123J1417C0011 Federal Contract Action Summary (Last 10 Years)

Federal procurement record for vehicle number 123J1417C0011 under agency ID 12K2, showing obligations over the last 10 years.

This page summarizes award activity for vehicle number 123J1417C0011 within the last 10 years. The record includes 3 award actions with total obligated spending of 55.03 million.

Last full year Last 5 years Last 10 years

Generated at 03/21/2026

Analysis period: Last 10 years

Total obligated amount is 55,033,029.64 and average action value is 18,344,343.21.

Agency ID

12K2

PIID

123J1417C0011

Type

Vehicle

Total Obligated

55.03 million

55,033,029.64

Actions

Average Action Value

18,344,343.21

Overview

The procurement record for vehicle number 123J1417C0011 covers 3 award actions in the last 10 years. Total obligated spending is 55,033,029.64, with an average action value of 18,344,343.21. This page is organized for review of obligation totals and award count only.

How to use this page

Use this page to review the basic award profile tied to vehicle number 123J1417C0011 and agency ID 12K2. The available measures support quick comparison of total obligations, action count, and average action value across the analysis window.

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 10 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	55,033,029.64	55.03 million	3

Insight

Within the 10-year window, all recorded vehicle obligations for PIID 123J1417C0011 are concentrated in a single agency, Agricultural Marketing Service (Agency ID 12K2). That agency accounts for $55.03 million across 3 awards, indicating a highly concentrated obligation pattern with no diversification across other 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__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 10 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 10 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	55,033,029.64	55.03 million	3

Insight

For PIID 123J1417C0011 over the 10-year window, obligations are fully concentrated in NAICS 311421, Fruit and Vegetable Canning. This NAICS accounts for $55.03 million across 3 awards, indicating a narrow concentration of obligated activity within a single industry category. The limited award count suggests repeated procurement activity rather than broad distribution across multiple NAICS codes.

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 10 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	55,033,029.64	55.03 million	3

Insight

For PIID 123J1417C0011, obligations over the 10-year window are concentrated entirely in PSC 8915, Fruits and Vegetables, with $55.03 million across 3 awards. This indicates a narrow procurement profile for the vehicle, with no evidence in the provided rows of diversification into other PSCs. The limited award count suggests a small number of large actions driving total obligated value.

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 10 YEAR
    AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC

Year	Total Obligated	Readable	Actions
2017	55,033,029.64	55.03 million	1
2023	0.00	0.00	2

Insight

Obligations for PIID 123J1417C0011 are highly concentrated in 2017, when a single award accounted for $55.03 million. In 2023, there were two recorded awards with no obligated dollars, indicating activity without recorded funding in that year. Across the 10-year window, the pattern suggests a one-time obligation spike rather than a sustained annual funding 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 10 years view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.

Start 7-Day Trial Learn More