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 18Updates the NYCHA revenue calculations in routers/nycha.py to sum recognized revenue instead of taking the maximum, ensuring additive cash and negative adjustments are correctly calculated. It also makes the revenue classification guard case-insensitive and updates the remaining budget formula to modified minus recognized.wegovnyc/databook-private ↗Jul 17Added an individual NYCHA contract profile page featuring detailed contract metadata, financial stat tiles, and a matched payments visualization. The contracts explorer now links directly to these profiles, which are served live via a new DuckDB-powered API endpoint.wegovnyc/databook-private ↗Jul 17Added a searchable, sortable, and exportable NYCHA vendors directory to the NYCHA organization profile. Introduced NYCHA-native vendor profiles for vendors without PASSPort records, linking all NYCHA vendors to either their City PASSPort or NYCHA-native profile. Added supporting API endpoints and caching.wegovnyc/databook-private ↗Jul 17This update automates the weekly refresh of the NYCHA vendor crosswalk script. It also adds a "NYCHA Activity" section to City vendor profiles, displaying aggregated contract and spending data for crosswalked vendors with deep links to the Housing Authority procurement explorers.wegovnyc/databook-private ↗Jul 17This documentation-only update adds the July 17, 2026, session status to CLAUDE.md, detailing progress on NYCHA unification, record explorers, and the vendor crosswalk. It also adds a repository renaming note to the README.wegovnyc/databook-private ↗Jul 17Fixed a file-not-found error in the NYCHA vendor crosswalk generator by inlining the SQL DDL directly into the Python script. This ensures the generator runs successfully inside the API container, which does not bundle the external SQL scripts directory.wegovnyc/databook-private ↗Knowledge
No knowledge items yet.
Repositories
wegovnyc/databook_interfaceJan 26, 2022