This page provides a procurement overview for the Defense Security Cooperation Agency (DSCA) using the available FPDS analysis window. No award actions are recorded in the provided data for this period.
Federal Agency
DEFENSE SECURITY COOPERATION AGENCY (DSCA) Federal Contract Obligations (Last 5 Years)
Federal procurement summary for the Defense Security Cooperation Agency (DSCA), Agency ID 97AT, covering the last 5 years.
The dataset provided shows 0 award actions and no populated totals, vendor, NAICS, or annual trend rows.
Agency ID
97AT
Total Obligated
0.00
Award Actions
0
Average Action Value
0.00
About DEFENSE SECURITY COOPERATION AGENCY (DSCA) federal contract activity
FPDS Query returned no recorded awards for Defense Security Cooperation Agency (DSCA), Agency ID 97AT, in the last 5 years based on the provided dataset. With an award count of 0 and no obligated amount available, there is no measurable obligation or average award value to characterize for the period.
Vendor concentration and leading contractors
No top vendors are identifiable because the underlying award set for the analysis window is empty. As a result, vendor concentration, repeat-award relationships, and supplier mix cannot be assessed from the provided data.
Industry profile based on NAICS activity
No NAICS codes can be ranked or summarized because there are no reported awards in the analysis window. Without transactions, there is no basis for determining the agency’s procurement mix by industry.
Annual contract trend over the analysis window
No annual trend can be established from the provided data because the annual series is empty. The absence of reported obligations and awards precludes year-over-year comparison, growth analysis, or volatility assessment.
How to interpret this page
This summary is based only on the FPDS Query inputs provided for the last 5 years and does not infer missing values. When the award set is empty, descriptive statistics, vendor rankings, NAICS rankings, and trend analysis are not available and are reported as such.
Top Vendors
SELECT
vendor_name,
total_obligated,
award_count,
formatReadableQuantity(total_obligated) AS total_obligated_readable
FROM
(
SELECT
content__award__vendor__vendorHeader__vendorName AS vendor_name,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count
FROM fpds.data
WHERE
contract_type = 1
AND content__award__purchaserInformation__contractingOfficeAgencyID = '97AT'
AND content__award__vendor__vendorHeader__vendorName IS NOT NULL
AND content__award__vendor__vendorHeader__vendorName != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY vendor_name
)
ORDER BY total_obligated DESC
LIMIT 10| Vendor | Total Obligated | Readable | Award Actions |
|---|
Insight
No notable vendor concentration was available for this analysis window.
Top NAICS
SELECT
naics_code,
naics_name,
total_obligated,
award_count,
formatReadableQuantity(total_obligated) AS total_obligated_readable
FROM
(
SELECT
content__award__productOrServiceInformation__principalNAICSCode AS naics_code,
anyHeavy(content__award__productOrServiceInformation__principalNAICSCode__description) AS naics_name,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count
FROM fpds.data
WHERE
contract_type = 1
AND content__award__purchaserInformation__contractingOfficeAgencyID = '97AT'
AND content__award__productOrServiceInformation__principalNAICSCode IS NOT NULL
AND content__award__productOrServiceInformation__principalNAICSCode != ''
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY naics_code
)
ORDER BY total_obligated DESC
LIMIT 10| NAICS Code | Description | Total Obligated | Readable | Award Actions |
|---|
Insight
No notable NAICS concentration was available for this analysis window.
Annual Trend
SELECT
year,
total_obligated,
award_count,
formatReadableQuantity(total_obligated) AS total_obligated_readable
FROM
(
SELECT
toYear(parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate)) AS year,
sum(content__award__dollarValues__obligatedAmount) AS total_obligated,
count() AS award_count
FROM fpds.data
WHERE
contract_type = 1
AND content__award__purchaserInformation__contractingOfficeAgencyID = '97AT'
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) >= toStartOfYear(now()) - INTERVAL 5 YEAR
AND parseDateTimeBestEffortOrNull(content__award__relevantContractDates__signedDate) < toStartOfYear(now())
GROUP BY year
)
ORDER BY year DESC| Year | Total Obligated | Readable | Award Actions |
|---|
Insight
No annual trend data was available for this analysis window.
Use FPDS Query for deeper analysis
Explore federal procurement data with custom SQL, fast filtering, and deeper market analysis across agencies, vendors, NAICS, and contract trends.
Continue from this last 5 years view into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.