Spending Trends

California Federal Contract Spending Trends

California 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 62.31.

Federal Contract Spending Spending Trends Spending Series Series

Updated 03/20/2026

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

Analysis

The latest visible point is 2025 at 62.31.

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

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

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

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

-- California 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 = 'CA'
)
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
1965 0.00 1 77000
1967 0.00 1 57565
1970 0.00 1 12164
1972 0.00 1 333682
1973 0.00 1 91809
1975 0.00 1 88000
1976 0.02 10 2074642
1977 0.00 2 3475559
1978 0.03 7 4956060
1979 0.21 508 419162
1980 1.38 617 2246471
1981 2.99 477 6285318
1982 0.96 764 1262506
1983 1.00 537 1873563
1984 1.41 654 2159223
1985 30.86 55599 555077
1986 2.15 450 4798456
1987 31.86 53249 598379
1988 28.32 49010 577864
1989 4.98 386 12908571
1990 24.68 43389 568831
1991 27.16 49158 552601
1992 26.19 54965 476540
1993 25.24 48036 525494
1994 24.61 49893 493268
1995 25.99 60047 432961
1996 26.89 70725 380313
1997 25.94 57877 448285
1998 24.67 55257 446486
1999 24.07 53606 449067
2000 25.33 59232 427649
2001 27.96 65546 426647
2002 33.38 83769 398484
2003 49.53 114153 433941
2004 38.49 153253 251195
2005 42.08 262292 160445
2006 44.05 298300 147682
2007 47.96 303482 158063
2008 51.10 338112 151138
2009 55.94 268068 208687
2010 56.41 274579 205442
2011 53.36 261569 204021
2012 52.23 235091 222197
2013 47.97 209505 228978
2014 46.21 221362 208794
2015 47.68 329284 144813
2016 52.12 363897 143238
2017 54.18 351008 154366
2018 57.74 360350 160252
2019 61.25 405860 150933
2020 59.70 369291 161665
2021 52.31 371086 140967
2022 57.72 367836 156939
2023 61.61 387708 158921
2024 61.87 341086 181407
2025 62.31 353266 176386

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
56
First Visible Point
1965
Mean
29.68
Median
27.56
Max
62.31
2025
Min
0.00
1965
Volatility
22.19
22.19
Rows Returned
56

Series Extremes

Largest Increase
29.71
1986 → 1987 · 1,381.86%
Largest Decrease
-28.71
1985 → 1986 · -93.03%

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.