How to Analyse Federal Spending by Geography with Claude
Analyse federal spending by geography with Claude and ToolRouter. State and regional government spending analysis.
Tool
Claude analyses geographic spending data and connects the numbers to economic and political context. It identifies which states are the biggest recipients of federal contracts versus grants, explains what the spending composition reveals about a region's economic relationship with the federal government, and tracks year-over-year changes to identify shifts.
Connect ToolRouter to Claude
1Open connector settings Open Settings
2Add a custom connector with these details
Name
ToolRouterURL
https://api.toolrouter.com/mcp3Let Claude set you up Open Claude
Steps
Once connected (see setup above), use the Government Spending tool:
- Ask Claude: "Show me federal spending in Texas by agency for the last fiscal year"
- Claude returns geographic spending breakdown with agency and category data
- Ask: "Which states receive the most federal contract spending per capita?"
- Ask: "How has federal spending in this state changed over the last five years?"
Example Prompt
Try this with Claude using the Government Spending tool
Analyse federal contract and grant spending in Ohio for the last fiscal year. Which agencies are the biggest spenders in the state, what sectors are the money going into, and how does Ohio's federal spending compare to neighbouring states?
Tips
- Ask for per-capita spending comparisons to normalise for state population differences
- Track spending trends over three or more years to distinguish a one-year anomaly from a structural shift
- Ask Claude to explain what the spending mix (contracts vs grants, defence vs civilian) reveals about a region's economic character