The record for vehicle number 123J1418C0007 under agency ID 12K2 covers the last 5 years of activity. It shows 4 award actions with total obligated amount of 0.00.
Vehicle Number
Vehicle Number 12K2 / 123J1418C0007 Federal Contract Action Summary (Last 5 Years)
This page summarizes vehicle number 123J1418C0007 for agency 12K2 over the last 5 years, showing four award actions and no obligated value.
All dollar figures on this page reflect a total obligated amount of 0.00 and an average action value of 0.
Agency ID
12K2
PIID
123J1418C0007
Type
Vehicle
Total Obligated
0.00
0.00
Actions
4
Average Action Value
0.00
Overview
This procurement record identifies vehicle number 123J1418C0007 associated with agency ID 12K2. Across the last 5 years, the award action count is 4 and the total obligated amount remains 0.00.
How to use this page
Use this page to review the basic FPDS record for vehicle number 123J1418C0007 and confirm its award activity. The available data support a read of the transaction count and obligated totals only.
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 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 | 4 |
Insight
Over the 5-year window, all reported obligations for PIID 123J1418C0007 under vehicle 12K2 are concentrated in Agricultural Marketing Service (12K2), which accounts for 4 awards and $0.00 obligated. This indicates award activity is present, but no recorded obligation value is associated with these awards in the provided data. The distribution is fully concentrated in a single agency with no observed obligated spending.
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 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 = '123J1418C0007'
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 |
|---|---|---|---|---|
| 311615 | POULTRY PROCESSING | 0.00 | 0.00 | 4 |
Insight
Over the 5-year window, this vehicle’s obligations under PIID 123J1418C0007 are fully concentrated in NAICS 311615, Poultry Processing. The category appears consistently represented with 4 awards, but total obligated dollars remain at $0.00, indicating activity with no recorded obligation value. This suggests a narrow industrial focus with minimal financial execution under the vehicle.
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 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 |
|---|---|---|---|---|
| 8905 | MEAT, POULTRY, AND FISH | 0.00 | 0.00 | 4 |
Insight
Within the 5-year window for vehicle 123J1418C0007, obligations are concentrated in a single PSC: 8905, Meat, Poultry, and Fish. This PSC accounts for all 4 awards, but reported total obligated dollars are $0.00, indicating activity without recorded obligation value in the provided data. The distribution is fully concentrated and provides no evidence of diversification across PSCs in this query set.
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 5 YEAR
AND parseDateTimeBestEffortOrNull(content__IDV__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
ORDER BY year ASC| Year | Total Obligated | Readable | Actions |
|---|---|---|---|
| 2021 | 0.00 | 0.00 | 2 |
| 2022 | 0.00 | 0.00 | 1 |
| 2024 | 0.00 | 0.00 | 1 |
Insight
Over the 5-year window, this vehicle shows no obligated dollars in the reported years, with total obligated value at $0 in 2021, 2022, and 2024. Award activity is limited and intermittent, with two awards in 2021 and one award each in 2022 and 2024, indicating low-volume use without financial concentration. The absence of obligations across all reported years suggests no measurable funding trend within this dataset.
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.