budget_breakdown
Retrieve total budget or spend for NYC capital projects, grouped by managing agency or category, with optional agency and role filters.
Instructions
Total budget / spend by managing_agency or category, deduped on (fms_id,
managing_agency). Category is line-grain (additive). Optional agency scopes to one
agency; agency_role ('auto'|'sponsor'|'managing') picks owner vs builder lens. For
richer cuts use run_sql.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| group_by | No | managing_agency | |
| metric | No | total_budget | |
| period | No | current | |
| agency | No | ||
| agency_role | No | auto |