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.
This update adds two org-chart views to the Databook, setting our custom view as the default and adding an official NYC view. It also fixes bugs with root and parent node IDs, and replaces the stale static JSON file with dynamic API-based tree generation.
Updated the core normalizer to derive the organizations dictionary directly from the databook register. This change was integrated into the main branch by merging pull request #13.
Retired organizations are no longer served through search, MCP, the public API, and the OCE. This update filters out inactive entities across these key endpoints to ensure only active organizations are returned.
Restored missing classification and official nodes to the organization chart, resolving 63 orphaned parent references and 5 dangling core entity IDs. Replaced the "not on chart" bucket with a tri-state `in_org_chart` flag, and backed up modified rows to a temporary table before clearing their parent fields.
This update prevents retired organizations from appearing in search results, the MCP server, the public API, and OCE queries by applying active-status filters across all serving endpoints. It also updates district lookups, and retired organization profile pages now display a redirect notice.
Fixed a bug where the agencies page displayed only 28 rows instead of ~270 due to hardcoded client-side filtering. This PR replaces the client-side filter with a new backend endpoint using centralized organization types and updates the agency count scheduler.