Databook
activeopen governmentAn award-winning transparency tool that combines over 50 official NYC open datasets — agencies, people, jobs, capital projects, schools, districts and procurement — into one searchable picture of how city government works.
Fixed a rendering bug on the agency profile where the organization head badge displayed raw Blade directive code.
This pull request adds two new tables, agency_head_enrichment and agency_contact_enrichment, to derive agency heads and addresses from NYC Greenbook data. It includes idempotent SQL scripts and an auto-refresh hook that rebuilds both tables daily after each Greenbook ingestion, boosting combined city agency address coverage from 29% to 51%.
This stops DuckDB from incorrectly parsing backup directories as active partitions, resolving 500 errors on the spending summary endpoint.
Corrected an explanatory note on the NYCHA budget page to clarify that NYCHA stopped reporting its appropriated budget after FY2023. The page now accurately explains that FY2024 onward only displays committed and actual spending, rather than incorrectly attributing the missing data to whether a fiscal year is closed.
The scripts now tolerate API cold-starts and heavy initial queries, preventing valid data from being rolled back while maintaining normal behavior once the API is warmed up.
Adds a new NYCHA procurement landing page with headline figures and clickable cards for its four financial domains. It collapses the four separate NYCHA submenu links into a single "NYCHA" link and introduces an on-page tab bar for navigating between the NYCHA overview, budget, revenue, contracts, and spending pages.