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.
Removes the unused StrapiService class following the retirement of the Strapi CMS.
Migrated the Databook blog from the retiring Strapi CMS to the new Sarapis Payload CMS. This update replaces StrapiService with PayloadService to fetch and render articles, configures brand-scoped filtering, and updates the three main article call sites while keeping existing Blade views intact.
Removed the retired StrapiService and transitioned the blog to read articles from the Sarapis Payload CMS instead of Strapi.
Added a new payroll-refresh.sh script with current and backfill modes to safely update and backfill large payroll datasets via atomic swaps. Updated CLAUDE.md documentation and validated the FY2025 payroll data with zero truncation.
This pull request adds the Payroll domain to Databook, achieving full parity with CheckbookNYC. It introduces a stream-aggregating extractor to rollup raw payroll data, adds new API endpoints under a payroll router, and implements a frontend dashboard and record explorer for visualizing aggregated agency and title-level payroll metrics.
Implemented Phase 3 of the NYCHA crosswalk with fuzzy and curated match tiers. Integrated NYCHA vendors into global search with pointers to City vendors, and corrected the NYCHA revenue calculation to sum recognized revenue instead of using the maximum value.