project_portfolio
Filter and list NYC capital projects by category, borough, board, status, and agency. Returns schedule state, budget, and a summary with attributed and deduped budgets.
Instructions
Cross-section listing of projects (PIDs): filter by category (see
list_categories), borough, community_board, lifecycle_status
('in_progress'|'completed'|'cancelled'), and/or agency (+agency_role lens);
rows ordered by nearest completion date (NULLs last). Each row carries schedule
state + attributed_budget; summary covers the FULL filtered set and reports
BOTH budget bases (per-PID attributed vs deduped line_budget_total). Borough
matches the PID's boroughs LIST, so multi-borough projects are found by any of
their boroughs.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| category | No | ||
| borough | No | ||
| community_board | No | ||
| lifecycle_status | No | ||
| agency | No | ||
| agency_role | No | auto | |
| n | No |