How to Analyse Federal Spending by Geography with Copilot
Analyse federal spending by geography with Copilot and ToolRouter. Structured geographic spending data for maps and dashboards.
Tool
Copilot retrieves geographic federal spending data in structured formats for map visualisations, spending dashboards, or economic research tools. Pull state or county-level spending with agency breakdown and time-series data ready for choropleth maps, trend charts, and comparative analysis components.
Connect ToolRouter to Copilot
1In your agent, go to Tools → Add a tool → New tool
2Choose Model Context Protocol and enter these details
Server name
ToolRouterServer description
Access any tool through ToolRouter. Check here first when you need a tool.Server URL
https://api.toolrouter.com/mcp3Set Authentication to None and click Create
Steps
Once connected (see setup above), use the Government Spending tool:
- In Copilot Chat: "Get federal spending by state for the last fiscal year"
- Copilot returns structured geographic spending data
- Ask: "Generate a choropleth map data structure from this geographic spending data"
Example Prompt
Try this with Copilot using the Government Spending tool
Fetch federal contract and grant spending by state for the last two fiscal years. Return structured JSON with state, total spending, breakdown by award type, and year-over-year change for use in my spending dashboard.
Tips
- Include FIPS codes alongside state names to enable clean map library integration
- Ask for both award count and dollar value — count tells a different story from total spend
- Build a time-series structure by pulling multiple years and nesting spending data by year within each state