NCNYC Civil Title Viewer
Profiles of NYC civil-service titles — descriptions, positions, roles and pay. Began as a standalone experiment and now lives as Databook’s titles section.
DA
activeopen government
Databook
An 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.
DASubprojects
In the open
Activity
Jul 15Fixed 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.wegovnyc/databook-private ↗Jul 15Updates 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.wegovnyc/databook-private ↗Jul 15Added 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.wegovnyc/databook-private ↗Jul 15Launched the initial public release of the Databook project, establishing the codebase and repository for public access.wegovnyc/databook ↗Jul 15This 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.wegovnyc/databook-private ↗Jul 15Fixed 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.wegovnyc/databook-private ↗Knowledge
No knowledge items yet.
Repositories
wegovnyc/databook_interfaceJan 26, 2022