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 16Fixed a rendering bug on the agency profile where the organization head badge displayed raw Blade directive code.wegovnyc/databook-private ↗Jul 15This pull request adds two new tables, agency_head_enrichment and agency_contact_enrichment, to derive agency heads and addresses from NYC Greenbook data. It includes idempotent SQL scripts and an auto-refresh hook that rebuilds both tables daily after each Greenbook ingestion, boosting combined city agency address coverage from 29% to 51%.wegovnyc/databook-private ↗Jul 15This stops DuckDB from incorrectly parsing backup directories as active partitions, resolving 500 errors on the spending summary endpoint.wegovnyc/databook-private ↗Jul 15Corrected an explanatory note on the NYCHA budget page to clarify that NYCHA stopped reporting its appropriated budget after FY2023. The page now accurately explains that FY2024 onward only displays committed and actual spending, rather than incorrectly attributing the missing data to whether a fiscal year is closed.wegovnyc/databook-private ↗Jul 15The scripts now tolerate API cold-starts and heavy initial queries, preventing valid data from being rolled back while maintaining normal behavior once the API is warmed up.wegovnyc/databook-private ↗Jul 15Adds a new NYCHA procurement landing page with headline figures and clickable cards for its four financial domains. It collapses the four separate NYCHA submenu links into a single "NYCHA" link and introduces an on-page tab bar for navigating between the NYCHA overview, budget, revenue, contracts, and spending pages.wegovnyc/databook-private ↗Knowledge
No knowledge items yet.
Repositories
wegovnyc/databook_interfaceJan 26, 2022