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 bug where recognized revenue was underreported by switching its aggregation from MAX to SUM. This correctly totals additive cash receipts instead of discarding identical transactions. Adopted and modified budget figures continue to use MAX to prevent over-counting.
Updates CLAUDE.md with the July 15, 2026 status report. Documented changes include faster weekly OCE refreshes, live M/WBE and NYCHA datasets, CheckbookNYC API throttling fixes, and spending-denormalization notes.
Added a NYCHA landing page with subsection navigation and a weekly lake refresh script. Improved reliability by adding retries for CheckbookNYC parsing and post-swap live-checks, and corrected the revenue calculation to sum collected revenue.
Launched the initial public release of the Databook project, establishing the codebase and repository for public access.
This update fixes NYCHA spending calculations to include payroll data, which was previously omitted. It applies a new shared spending expression across all aggregations that uses the allocated amount spent when available, falls back to the check amount for payroll, and defaults to zero otherwise.
Fixed a bug in NYCHA spending calculations by switching the aggregated column from check_amount to amount_spent. This resolves a data duplication issue that was over-counting total spending by approximately 377 times, correcting the FY2025 total from an inflated $1.9 trillion to the accurate $5.5 billion.