Spending Trends

Pennsylvania Federal Contract Spending Trends

Pennsylvania Federal Contract Spending Trends shows how federal contract spending changes across the visible time series in FPDS-derived procurement data.

The latest visible point is 2025 at 26.98.

Federal Contract Spending Spending Trends Spending Series Series

Updated 03/20/2026

Latest Period
2025
26.98
Visible Change
26.98
Peak Period
2025
26.98
Trend Direction
Up
Unknown

Analysis

The latest visible point is 2025 at 26.98.

Why it matters: Use this page to evaluate how federal contract spending levels shift over time and identify inflection points.

Methodology: The query returns a structured time series, detects a period column and a primary numeric metric, and computes visible-series statistics such as latest value, peak, low, and overall change.

Commentary

Pennsylvania Federal Contract Spending Trends tracks federal contract spending over time in FPDS-derived data.

Key takeaway: The latest visible point is 2025 at 26.98.

Analyst note: This page is best used for directional review, turning points, and quick comparison against related time windows or scopes.

Trend Chart

This chart plots Federal Contract Spending over the visible time series returned by the query.

Query Used

-- Pennsylvania Federal Contract Spending Trends
SELECT
    fiscal_year,
    round(sum(obligated_amount) / 1000000000, 2) AS spending_billion_usd,
    count() AS award_count,
    round(sum(obligated_amount) / count(), 0) AS avg_award_size
FROM
(
    SELECT
        if(
            toUInt8(substring(content__award__relevantContractDates__signedDate, 6, 2)) >= 10,
            toUInt16(substring(content__award__relevantContractDates__signedDate, 1, 4)) + 1,
            toUInt16(substring(content__award__relevantContractDates__signedDate, 1, 4))
        ) AS fiscal_year,
        content__award__dollarValues__obligatedAmount AS obligated_amount,
        content__award__placeOfPerformance__principalPlaceOfPerformance__stateCode AS state_code
    FROM fpds.data
    WHERE
        contract_type = 1
        AND content__award__relevantContractDates__signedDate != ''
        AND state_code = 'PA'
)
WHERE fiscal_year < toYear(today())
GROUP BY fiscal_year
ORDER BY fiscal_year ASC

Trend Table

This table shows the structured time series returned by the query.

Fiscal Year Spending Billion Usd Award Count Avg Award Size
1976 0.00 1 0
1978 0.00 1 5000000
1979 2.97 14586 203702
1980 3.08 19204 160727
1981 3.40 18613 183017
1982 3.59 21563 166704
1983 3.86 14623 264217
1984 4.57 15596 293307
1985 4.84 14593 332019
1986 5.07 14638 346474
1987 4.49 15039 298966
1988 4.38 13793 317817
1989 3.80 11412 333287
1990 3.74 12413 301788
1991 4.31 13360 322950
1992 4.54 16075 282507
1993 3.32 12751 261047
1994 3.68 12532 293781
1995 3.69 15383 240132
1996 5.04 16966 297378
1997 4.38 14284 307203
1998 4.55 14442 315085
1999 5.73 14811 387306
2000 5.74 16023 358284
2001 6.24 17591 355171
2002 7.10 22356 317610
2003 7.55 36272 208283
2004 9.28 45221 205309
2005 9.46 89622 105594
2006 10.17 149562 68024
2007 14.49 202473 71591
2008 17.74 215491 82325
2009 18.04 162182 111254
2010 18.58 168760 110121
2011 19.38 166673 116293
2012 18.87 159188 118597
2013 16.21 145390 111506
2014 16.68 146233 114122
2015 15.00 379325 39550
2016 15.48 499005 31032
2017 15.79 530740 29753
2018 16.99 585557 29024
2019 18.92 636200 29748
2020 17.98 588208 30583
2021 17.58 558604 31481
2022 19.73 580174 34018
2023 23.28 648490 35908
2024 26.60 678183 39225
2025 26.98 697831 38666

How This Trend Is Built

Measure how a selected procurement metric changes across time.

Query structure

  • The query selects a time dimension used as the x-axis for the trend.
  • It calculates or returns a numeric metric for each visible period.
  • The result is interpreted as a chronological series for trend analysis.
  • The metric focuses on obligated dollars or a directly related spending aggregate.

Included fields

  • fiscal_year — Defines the chronological unit used for the trend series.
  • spending_billion_usd — Defines the main value plotted and analyzed over time.
  • award_count — Provides additional numeric context that can support interpretation.
  • avg_award_size — Provides additional numeric context that can support interpretation.

How to use this trend

  • trend direction analysis
  • time-series review
  • federal procurement timing analysis
  • spending trajectory review
  • budget pattern review

Computed Metrics

Series Points
49
First Visible Point
1976
Mean
10.14
Median
6.24
Max
26.98
2025
Min
0.00
1976
Volatility
7.31
7.31
Rows Returned
49

Series Extremes

Largest Increase
4.32
2006 → 2007 · 42.48%
Largest Decrease
-2.66
2012 → 2013 · -14.10%

Related Pages

Method Notes

  • Trend interpretation is based on the returned query result set ordered by the detected period column.
  • Change metrics compare the first visible point and the latest visible point in the series.
  • Volatility is based on the standard deviation of the visible numeric series.

Use FPDS Query for deeper trend analysis

Go beyond the published time series with custom SQL, broader filters, saved queries, and deeper procurement analysis across agencies, vendors, industries, states, contract structures, and competitive segments.

Continue from this trend page into full FPDS Query workflows with deeper filtering, custom SQL, saved queries, and broader market comparison.