Fair Student Funding still doesn't cover the schools that need it most
A reproducibility log: the data this analysis touched, the queries it ran, the outside sources it leaned on, and the steps a third party would follow to re-run it.
Summary
Same data limitation as the Title I story. The analysis uses NYC Independent Budget Office (IBO) published per-school funding estimates to discuss the gap; our schools table contributes the demographic + outcome context.
Data sources
- Database tableschools
One row per New York City public school (DBN, name, district, borough, school_type, grade_band, latest_enrollment, proclivity_decile, proclivity_score, closed_at, admission_category).
- Database tableschool_year_metrics
Long-format per-school per-year metric facts (school_dbn, year, metric_key, subgroup, value, suppressed). Loaded from DOE/NYSED public files via scripts/loaders/*.
- External datasetNYC Independent Budget Office — Fair Student Funding analysis
Steps
Reference IBO's published estimates of per-school FSF gaps; cross-tab with our proclivity-decile distribution to see which schools fall short.
Caveats
IBO's estimates are from a specific year; the gap shifts as the funding formula is partially reformed.
Reproduce
Read IBO's most recent FSF report; for each school they cite, look up the DBN in our table to enrich with outcome context.
The recipe lives at data/stories/recipes.ts in the repo. Corrections welcome.