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.
It also updates the liveness probe to use the unauthenticated `/health` endpoint and adds a script to generate the required credentials.
This pull request adds a documentation plan to establish the Postgres database as the authoritative system of record for the organization directory. It outlines a five-phase proposal to fix broken data refreshes, migrate parent links, build a new editing interface, and safely retire the legacy Airtable store.
Added a draft bug report documenting referential integrity issues in the OTI registry's "reports_to" field, where 17% of parent references match no published record. The report details the causes of these broken links and recommends publishing a machine-readable "reports_to_record_id" column to establish a stable, verifiable organizational hierarchy.
This update integrates OTI data to assign organization types and parent relationships, resolving all remaining synthetic hex IDs. It introduces a display_name field to show official OTI names without breaking URL paths or contract joins, and fixes four silent type-filtering bugs to improve data coverage.
This pull request adopts NYC's official agency registry by importing 133 missing OTI organizations and adding their attributes. It repairs 10,004 dangling organization IDs across 18 production tables, resolves a mapping issue for the NYC Districting Commission, and applies three database cleanup fixes.
Updated the API to read PostgreSQL credentials directly from the environment instead of the env.yaml file. This consolidates credential sourcing into a single, more secure location.