AMERICAN BATTLE MONUMENTS COMMISSION leads this ranking at 7.4K. The top 10 account for 100.00% of the value in this result set, indicating a very high concentration pattern.
Agencies
Agencies Increasing Spending
Agencies Increasing Spending shows which federal agencies rank highest by Primary Metric in FPDS-based procurement data.
Analysis
AMERICAN BATTLE MONUMENTS COMMISSION leads this ranking at 7.4K. The top 10 account for 100.00% of the value in this result set, indicating a very high concentration pattern.
Why it matters: Use this page to identify leaders, compare major participants, and understand how activity is distributed across this segment of the federal market.
Methodology: The query groups FPDS records by the ranked entity, calculates the main metric, and orders results from highest to lowest. Supporting columns add context to the leaderboard.
Key Findings
- AMERICAN BATTLE MONUMENTS COMMISSION holds the top position.
- The top 10 account for 100.00% of the value in this result set.
Limitations
- Interpretation depends on the SQL scope and selected filters.
- This page reflects only the returned query result set.
Query Used
-- Agencies Increasing Spending (Year-over-Year)
WITH current_year AS (
SELECT
content__award__purchaserInformation__contractingOfficeAgencyID AS agency_id,
anyHeavy(content__award__purchaserInformation__contractingOfficeAgencyID__name) AS agency_name,
sum(content__award__dollarValues__obligatedAmount) AS total_current
FROM fpds.data
WHERE
contract_type = 1
AND content__award__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
AND content__award__relevantContractDates__signedDate IS NOT NULL
AND content__award__relevantContractDates__signedDate != ''
AND toYear(parseDateTimeBestEffort(content__award__relevantContractDates__signedDate)) = toYear(now())
GROUP BY content__award__purchaserInformation__contractingOfficeAgencyID
),
previous_year AS (
SELECT
content__award__purchaserInformation__contractingOfficeAgencyID AS agency_id,
sum(content__award__dollarValues__obligatedAmount) AS total_previous
FROM fpds.data
WHERE
contract_type = 1
AND content__award__purchaserInformation__contractingOfficeAgencyID IS NOT NULL
AND content__award__relevantContractDates__signedDate IS NOT NULL
AND content__award__relevantContractDates__signedDate != ''
AND toYear(parseDateTimeBestEffort(content__award__relevantContractDates__signedDate)) = toYear(now()) - 1
GROUP BY content__award__purchaserInformation__contractingOfficeAgencyID
)
SELECT
c.agency_id,
c.agency_name,
c.total_current,
formatReadableQuantity(c.total_current) AS total_current_readable,
p.total_previous,
formatReadableQuantity(p.total_previous) AS total_previous_readable,
(c.total_current - p.total_previous) AS growth_absolute,
formatReadableQuantity(c.total_current - p.total_previous) AS growth_absolute_readable,
(c.total_current - p.total_previous) / nullIf(p.total_previous, 0) AS growth_rate
FROM current_year c
INNER JOIN previous_year p
ON c.agency_id = p.agency_id
WHERE
p.total_previous > 0
AND c.total_current > p.total_previous
ORDER BY growth_rate DESC
LIMIT 100
Ranking Table
This table ranks results by Primary Metric from highest to lowest.
| # | Agency Id | Agency Name | Total Current | Total Current Readable | Total Previous | Total Previous Readable | Growth Absolute | Growth Absolute Readable | Growth Rate |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 7,400.00 | AMERICAN BATTLE MONUMENTS COMMISSION | 861248.16 | 861.25 thousand | 200000 | 200.00 thousand | 661248.16 | 661.25 thousand | 3.3 |
How This Ranking Is Built
Build a ranked FPDS view for "Agencies Increasing Spending" using aggregated procurement data.
Query structure
- Results are sorted from highest to lowest by the main ranking metric.
- Grouping is used to combine FPDS records into comparable entity-level results.
Included fields
- agency_name — Defines the ranked agency.
- agency_id — Defines the main ranking metric: Primary Metric.
- total_current — Adds supporting context to the leaderboard.
- total_previous — Adds supporting context to the leaderboard.
- growth_absolute — Adds supporting context to the leaderboard.
- growth_rate — Adds supporting context to the leaderboard.
How to use this ranking
- Supports fast market review.
- Helps compare leaders and close competitors.
- Adds context beyond a raw transaction list.
Computed Metrics
Top Entities
| # | Entity | Value |
|---|---|---|
| 1 | AMERICAN BATTLE MONUMENTS COMMISSION | 7.4K |
Related Pages
Use FPDS Query for deeper ranking analysis
Go beyond the published leaderboard with custom SQL, broader filters, saved queries, and deeper procurement market analysis across agencies, vendors, industries, PSC categories, and time windows.
Continue from this ranking into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.