Vehicle Number

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

Federal procurement record for vehicle number 123J1420D0264 under agency ID 12K2, covering the last 10 years and showing 4 award actions totaling $247.65 million.

This page summarizes award activity for vehicle number 123J1420D0264 within agency ID 12K2 over the last 10 years. The record reflects 4 award actions with total obligated funding of $247,654,759.

Last full year Last 5 years Last 10 years

Generated at 03/21/2026

Analysis period: Last 10 years

Totals are based on the provided obligated amount and action count for the specified analysis window.

Agency ID

12K2

PIID

123J1420D0264

Type

Vehicle

Total Obligated

247.65 million

247,654,759.00

Actions

Average Action Value

61,913,689.75

Overview

The procurement record for vehicle number 123J1420D0264 shows 4 award actions in the last 10 years. Total obligated funding is $247,654,759, with an average action value of $61,913,689.75.

How to use this page

Use this page to review the scale and frequency of award activity associated with vehicle number 123J1420D0264. The figures support comparison across award actions and provide a concise financial summary for the selected period.

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 = '123J1420D0264'
    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	247,654,759.00	247.65 million	4

Insight

For PIID 123J1420D0264 over the 10-year window, all reported obligations in this section are concentrated in Agricultural Marketing Service (agency 12K2). The agency accounts for $247.65 million across 4 awards, indicating a highly concentrated funding profile within the queried vehicle. With only one agency represented, there is no observed distribution across additional top agencies in this result set.

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 = '123J1420D0264'
        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 = '123J1420D0264'
    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	247,654,759.00	247.65 million	4

Insight

Obligations for PIID 123J1420D0264 under agency 12K2 are fully concentrated in NAICS 311421, Fruit and Vegetable Canning, with $247.65 million across 4 awards over the 10-year window. This indicates a narrow industrial footprint and limited NAICS diversification within the vehicle record. The distribution suggests sustained spending in a single food-processing category rather than a broad contract mix.

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 = '123J1420D0264'
    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	247,654,759.00	247.65 million	4

Insight

Over the 10-year window for vehicle 123J1420D0264 under Agency ID 12K2, obligations are concentrated entirely in PSC 8915, Fruits and Vegetables. This PSC accounts for $247.65 million across 4 awards, indicating a narrow spend profile with activity confined to a single product category. The limited award count suggests spending concentration rather than broad distribution across multiple PSCs.

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 = '123J1420D0264'
    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
2020	247,654,759.00	247.65 million	1
2023	0.00	0.00	3

Insight

Obligations are highly concentrated in 2020, when a single award accounted for 247.65 million. By contrast, 2023 shows three awards with no recorded obligations, indicating activity continued but without obligating funds in that year. Over the 10-year window, the vehicle exhibits an uneven funding pattern rather than a steady annual obligation stream.

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