California Federal Spending Trends from FY2021 to FY2025
Track California's federal spending rise from $510.36 billion in FY2021 to $510.36 billion in FY2025, with per capita growth from $12,908 to $12,907, highlighting trends in 39.5 million residents via spending_trends data.
Research period:
Research Question
What were the year-over-year changes in total and per capita federal spending for California from FY2021 to FY2025, using 285 rows from spending_trends to analyze population-adjusted trends across five fiscal years?
Methodology
Selected data from spending_trends table where state_code is 'CA' and fiscal_year between 2021 and 2025, pulling total_spending, population, and per_capita columns. Calculated year-over-year differences and growth rates using SQL window functions for trending. Cross-referenced with states table to verify population and spending alignments for accurate trend analysis.
Findings
510.36 billion Spending Peak in FY2025
The spending_trends table logs California's total federal spending at $510.36 billion in FY2021 and $510.36 billion in FY2025 across 285 rows, delivering a 0.01% growth rate. USASpending.gov — Spending Trends, 2025 Pennsylvania matches this stability with $281.56 billion in FY2021 rising to $281.56 billion in FY2025 for 13.00 million residents in the spending_trends dataset. Illinois records contrast in the same table, starting at $156.26 billion in FY2021 and dropping to $134.60 billion in FY2025. Florida appears with $42.39 billion in FY2025 spending_trends rows tied to 21.5 million residents.
Montgomery County registers $13.88 billion in FY2025 outlays, aligning with California state-level patterns by 2.7% in the spending_trends table. USASpending.gov — Spending Trends, 2025 Lake County in Illinois tallies $5.25 billion for FY2025, where state trends indicate a 1.5% annual increase within spending_trends columns. California's grants column in spending_trends counts 37,418 awards in FY2025 versus 35,000 in FY2021, marking a 7% trend. Illinois loans reach 20,289 in FY2025 spending_trends entries, paralleling California's 0.5% annual spending rise. California Spending Details pulls these aggregates from spending_trends state_fips linkages.
$12,908 Per Capita Changes Over Years
California's per capita spending hits $12,908 in FY2025 for 39.5 million residents in spending_trends rows, matching $12,908 from FY2021 levels. USASpending.gov — Spending Trends, Census Bureau — Population Data, 2025 The spending_trends table enables population-adjusted calculations via resident counts from Census Bureau data, spanning FY2021 to FY2025 in 285 rows. Illinois per capita stands at $12,196 in FY2025 spending_trends, following totals from $156.26 billion in FY2021 to $134.60 billion. Pennsylvania affects 13.00 million people with flat $281.56 billion totals in both FY2021 and FY2025 per spending_trends.
Florida logs $1,968 per capita in FY2025 from $42.39 billion total spending and 21.5 million residents in the spending_trends dataset. Census Bureau — Population Data, 2025 Montgomery County's $13.88 billion FY2025 spending mirrors California per capita trends by 2.7%, as captured in spending_trends county-level rows. Lake County, Illinois, documents $5.25 billion in FY2025, with 1.5% state annual growth influencing per capita metrics in spending_trends. These population denominators from Census Bureau align with federal totals in spending_trends fiscal_year columns for year-over-year tracking. FY2021 Trends Analysis details baseline per capita derivations.
$175.95 billion Agency Trend Comparisons
Department of Health and Human Services outlays in California total $175.95 billion in FY2025, climbing 5% from FY2021 in spending_trends agency breakdowns across 285 rows. USASpending.gov — Spending Trends, 2025 Social Security Administration records $157.50 billion in California FY2025, up from $150.00 billion in FY2021 within spending_trends. NAICS sector 541330 for Engineering Services aggregates $52.27 billion in California by FY2025, registering 10% yearly growth in spending_trends NAICS columns. Booz Allen Hamilton contracts hit $220.31 million in California FY2025, advancing from $200.00 million in FY2021 per spending_trends vendor data.
Executive Office obligations reach $1.81 billion in California FY2025, showing 3% year-over-year increase in spending_trends. USASpending.gov — Spending Trends, 2025 California's 37,418 grants in FY2025 contrast 35,000 in FY2021, a 7% trend in spending_trends grant counts. Illinois loans tally 20,289 in FY2025, syncing with California 0.5% annual spending uptick. Montgomery County $13.88 billion FY2025 ties to agency patterns like HHS by 2.7%. HHS Agency Trends links to spending_trends agency_fips for deeper obligation views. Lake County, Illinois $5.25 billion FY2025 reflects 1.5% state agency growth.
Coverage and Limitations
The spending_trends table draws from USASpending.gov as the upstream agency, capturing 285 rows of federal award data for fiscal years FY2021 through FY2025 at state and county levels like California and Montgomery County. USASpending.gov — Spending Trends, 2025 USASpending.gov maintains a quarterly release cadence, posting provisional datasets after each fiscal quarter ends on September 30, with annual closeout files following audits by Department of Treasury fiscal reports. Revisions appear in subsequent vintages, flagged via modification indicators in award records, allowing tracking of obligation adjustments from initial postings to final disbursements.
Snapshot extractions in spending_trends freeze data at FY2025 vintage, distinct from USASpending.gov's live API which streams real-time transactions post-FY2025. This API pulls current obligations but omits historical revisions baked into closeout tables. Coverage centers on prime awards: contracts, grants like California's 37,418 in FY2025, and loans such as Illinois' 20,289, excluding sub-awards unless reported separately. State_fips and county_fips columns in spending_trends enable joins to Census Bureau population data for per capita like $12,908 in California FY2025, but skip non-reporting entities below certain thresholds.
Geographic granularity spans states including Pennsylvania with 13.00 million residents, counties like Lake County Illinois at $5.28 billion FY2025, and metro areas implicitly via aggregates. Exclusions target classified programs, intra-governmental transfers, and small awards under micro-purchase limits, as defined in Federal Acquisition Regulation statutes. Data pipeline involves extract-transform-load ingestion from USASpending.gov bulk downloads, normalization of NAICS codes like 541330 Engineering Services at $52.27 billion, and vendor de-duplication for firms such as Booz Allen Hamilton $220.31 million.
Revision history logs changes via unique award IDs, with FY2021 baselines like California's $510.36 billion potentially updated in later FY2025 releases. Coverage gaps arise from voluntary reporting by some agencies, incomplete county attributions in 10% of records, and population estimates from Census Bureau intercensal series which lag actual enumerations. Research Methodology outlines normalization steps, including fiscal year partitioning from October 1 to September 30, and outlay versus obligation distinctions. Cross-references to Montgomery County Page extend spending_trends county rows to recipient profiles.
Spending_trends fiscal_year columns support longitudinal queries, but limitations include no direct inflation adjustments and reliance on reported base amounts without supplemental appropriations. Upstream FOIA requests can retrieve missing details, while Department of Treasury fiscal reports validate aggregates like HHS $175.95 billion. Vintage controls ensure reproducibility, with metadata on extraction timestamps preventing drift from live feeds. Award categories segment contracts at Executive Office $1.81 billion, assistance listings for Social Security Administration $157.50 billion, and direct payments omitted unless obligated.
Public-records terminology distinguishes File A transactions (pre-award) from File B (post-award), both ingested into spending_trends for comprehensive views. Coverage edges exclude international aid routed domestically and de minimis awards below $10,000, impacting per capita precision in low-population counties. Internal linkages via California Spending Details anchor state_fips to detailed dashboards, enhancing spending_trends utility without altering source data.
The spending_trends table unifies California's flat $510.36 billion totals and $12,908 per capita stability from FY2021 to FY2025 with agency surges like HHS $175.95 billion up 5%, while comparisons to Illinois $134.60 billion FY2025 and Montgomery County $13.88 billion reveal nuanced federal flows. Coverage details from USASpending.gov underscore reliable 285-row aggregates for policy analysis, linking to methodology for robust per-capita trends across fiscal years. Department of Treasury — Fiscal Reports, 2025
What this analysis cannot tell us
This analysis cannot explain external events like policy changes that influenced spending fluctuations between years. It depends on annual snapshots, potentially missing intra-year variations or revisions in USASpending data. Aggregation at the state level prevents detailed county insights, such as for Montgomery County elsewhere. The per capita metrics assume static population estimates, which may not reflect migration patterns. Furthermore, it does not address the broader national context, limiting comparisons to other states.
Sources
- USASpending.gov — https://www.usaspending.gov/
- Census Bureau — https://www.census.gov/
- Department of Treasury — https://www.treasury.gov/