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.
Added a System Config panel to the queue user interface. Introduced automatic retry logic to handle transient connection drops when connecting to Socrata.
Fixed a bug in the direct IP import callback by adding the required Host header. This ensures the import callback requests are correctly routed and accepted when communicating directly via IP address.
Added a live-refreshing queue management UI and optimized performance by running dataset processing in a thread pool. Switched to an asyncio queue for background tasks and secured the UI by pre-serializing and escaping single quotes in the datasets JSON.
Redesigned the platform with a light mode theme and Databook.NYC branding, including map basemap and UI adjustments. Added a tabbed housing data interface, map auto-fitting for building profiles, and click-to-navigate overlay districts. Fixed NYCHA and rent-stabilized badges, menu padding, and logo styling.
Added 13 new NYC Open Data datasets and implemented a vertical sidebar layout. Fixed DOB Permits column names, corrected district ID formats for evictions, housing, and rodent inspections, and restricted Databook tabs to supported district types.
Added API proxies for CORS, lazy loading, column formatting, and NTA support. Fixed Housing Data table formatting using global CSS, corrected ACRIS legals column keys to match API field names, and added missing ACRIS legals and parties to building profile housing data.