Vehicle Number

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

Procurement overview for vehicle number 123J1418C0007 under Agency ID 12K2 over the last 10 years.

This page summarizes federal procurement activity for vehicle number 123J1418C0007 in Agency ID 12K2. The record shows 5 award actions and total obligations of $238.71 million over the analysis window.

Last full year Last 5 years Last 10 years

Generated at 03/21/2026

Analysis period: Last 10 years

Totals reflect the provided analysis window and may differ from other reports that use alternative filters or rounding.

Agency ID

12K2

PIID

123J1418C0007

Type

Vehicle

Total Obligated

238.71 million

238,713,108.00

Actions

Average Action Value

47,742,621.60

Overview

Over the last 10 years, vehicle number 123J1418C0007 has 5 award actions tied to Agency ID 12K2. Total obligated funding is $238,713,108, with an average action value of $47,742,621.6.

How to use this page

Use this page to review the obligation level and action count associated with vehicle number 123J1418C0007. The figures provide a concise view of activity for Agency ID 12K2 within the stated 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 = '123J1418C0007'
    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	238,713,108.00	238.71 million	5

Insight

Over the 10-year window for vehicle 123J1418C0007, all recorded obligations in this section are concentrated in a single top agency, the Agricultural Marketing Service. The agency accounts for $238.71 million across 5 awards, indicating a highly concentrated obligation profile with no distribution across additional 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 = '123J1418C0007'
        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 = '123J1418C0007'
    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
311615	POULTRY PROCESSING	238,713,108.00	238.71 million	5

Insight

Over the 10-year window, obligations for vehicle 12K2 PIID 123J1418C0007 are fully concentrated in NAICS 311615, Poultry Processing. This code accounts for 5 awards and $238.7 million in total obligated value, indicating a narrow and highly concentrated spending profile within the identified dataset.

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 = '123J1418C0007'
    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
8905	MEAT, POULTRY, AND FISH	238,713,108.00	238.71 million	5

Insight

For vehicle 12K2 / PIID 123J1418C0007 over the 10-year window, obligations are fully concentrated in PSC 8905, Meat, Poultry, and Fish. This PSC accounts for $238.71 million across 5 awards, indicating a narrow product mix with repeated procurement activity in the same category. The small award count relative to total obligated value suggests the vehicle has been used for a limited number of high-dollar actions rather than broad distribution across 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 = '123J1418C0007'
    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	238,713,108.00	238.71 million	1
2021	0.00	0.00	2
2022	0.00	0.00	1
2024	0.00	0.00	1

Insight

Obligations are highly concentrated in 2017, when one award accounted for $238.71 million. The remaining activity is limited to four awards in 2021, 2022, and 2024, all with $0 obligated, indicating no recorded funding against those actions. Over the 10-year window, this reflects a single-year funding peak followed by nominal award activity without obligation value.

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