This page summarizes federal obligations recorded for vehicle number associated with PIID HSFLAR17D00002 and Agency ID 7015. The analysis window covers the last 5 years and includes 80 award actions.
Vehicle Number
Vehicle Number 7015 / HSFLAR17D00002 Federal Contract Action Summary (Last 5 Years)
Procurement analysis for vehicle number under PIID HSFLAR17D00002 for Agency ID 7015 over the last 5 years.
Total obligated amounts are shown as 23.32 million, with an exact total of 23319842.5 and an average action value of 291498.03.
Overview
Over the last 5 years, vehicle number under PIID HSFLAR17D00002 shows 80 award actions totaling 23.32 million in obligations. The exact obligated amount is 23319842.5, and the average action value is 291498.03.
How to use this page
Use this page to review obligation volume and action frequency for the identified vehicle record. The figures support basic procurement analysis by showing total spend, action count, and average action value within the selected 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 = '7015' AND content__IDV__contractID__IDVID__PIID = 'HSFLAR17D00002'
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 |
|---|---|---|---|---|
| 7015 | FEDERAL LAW ENFORCEMENT TRAINING CENTER | 23,319,842.50 | 23.32 million | 80 |
Insight
Over the 5-year window, all reported obligations for PIID HSFLAR17D00002 are concentrated within the Federal Law Enforcement Training Center (agency ID 7015), which accounts for $23.32 million across 80 awards. This indicates a fully concentrated agency distribution for the vehicle, with no other agencies represented in the provided rows. The award count suggests repeated use of the vehicle within a single agency rather than broad interagency spread.
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 = '7015' AND content__IDV__contractID__IDVID__PIID = 'HSFLAR17D00002'
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 = '7015' AND content__IDV__contractID__IDVID__PIID = 'HSFLAR17D00002'
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 |
|---|---|---|---|---|
| 561210 | FACILITIES SUPPORT SERVICES | 23,319,842.50 | 23.32 million | 80 |
Insight
Obligations for PIID HSFLAR17D00002 are fully concentrated in NAICS 561210, Facilities Support Services, over the 5-year window. The vehicle records 80 awards totaling $23.32 million under this single NAICS, indicating a highly focused scope with no diversification across other industry categories in the provided data.
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 = '7015' AND content__IDV__contractID__IDVID__PIID = 'HSFLAR17D00002'
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 |
|---|---|---|---|---|
| S299 | HOUSEKEEPING- OTHER | 23,319,842.50 | 23.32 million | 80 |
Insight
For PIID HSFLAR17D00002 over the 5-year window, obligations are fully concentrated in PSC S299, Housekeeping- Other. This PSC accounts for $23.32 million across 80 awards, indicating a consistent service profile rather than a diversified mix of product or service categories. The absence of other PSCs suggests spending activity under this vehicle is highly focused in a single procurement classification.
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 = '7015' AND content__IDV__contractID__IDVID__PIID = 'HSFLAR17D00002'
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 | 3,754,780.69 | 3.75 million | 15 |
| 2022 | 5,525,666.49 | 5.53 million | 11 |
| 2023 | 5,756,061.00 | 5.76 million | 20 |
| 2024 | 3,779,112.31 | 3.78 million | 23 |
| 2025 | 4,504,222.01 | 4.50 million | 11 |
Insight
Obligations under PIID HSFLAR17D00002 for Agency 7015 were concentrated in the middle of the 5-year window, peaking in 2023 at $5.76 million across 20 awards. Funding then declined to $3.78 million in 2024 before partially rebounding to $4.50 million in 2025, while award counts remained uneven, ranging from 11 to 23 per year. The pattern suggests year-to-year variability in obligation volume rather than a sustained upward or downward 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 5 years view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.