Loading...
Loading...
The 2013 closures clustered in a small set of historically Black, disinvested South and West Side community areas where surviving schools remain overw
The real public data behind The Geography of the 2013 Chicago School Closures. 2013 CPS closed-school list (53 schools, with street addresses) + repo CPS active-school snapshot (661 schools, SY2016-17) as comparison universe. Files are hosted here directly so the analysis is reproducible; analysis.py reads only these files and prints the figures the paper reports.
These files are hosted directly on Rooted Forward and load below as live spreadsheets. Sort by clicking a column header, filter rows with the search box, change page size, or use Export current view in any spreadsheet toolbar to save your filtered view in CSV, TSV, or JSON.
analysis.py
Reproducible pandas script. Verifies the developments file is a subset of the portfolio, isolates OCII Western Addition-Area 2 (21 developments / 914 units / 821 income-restricted), tabulates tenure a
Source: Chicago Public Schools / Chicago Board of Education action (closed list, primary source via CBS Chicago and Education Week, corroborated by UIC Great Cities Institute); City of Chicago Data Portal for the CPS school universe; repo file already shipped
This file is not a tabular CSV. Use the download button above to save it locally.
cps-active-schools-sy2016-17-enriched.csv
The repo's 661-school CPS active-school snapshot (SY2016-17, City of Chicago Data Portal) reduced to analysis columns and enriched with a community_area assigned by the same point-in-polygon method. U
Source: Chicago Public Schools / Chicago Board of Education action (closed list, primary source via CBS Chicago and Education Week, corroborated by UIC Great Cities Institute); City of Chicago Data Portal for the CPS school universe; repo file already shipped
License
Code MIT, derived data CC BY 4.0.
What the cleaned archive will contain when complete. Column names and types may evolve until the archive ships.
| Column | Type | Description |
|---|---|---|
| school_id | text | |
| short_name | text | |
| long_name | text | |
| primary_category | text | |
| address | text | |
| zip | text | |
cps-active-schools-sy2016-17.csv
The original repo CPS active-school full-list file (SY2016-17, 661 schools, all original columns), copied unchanged from public/data/school-closures-2013-and-after/cps-schools-full-list.csv as the unt
Source: Chicago Public Schools / Chicago Board of Education action (closed list, primary source via CBS Chicago and Education Week, corroborated by UIC Great Cities Institute); City of Chicago Data Portal for the CPS school universe; repo file already shipped
cps-closed-schools-2013-geocoded.csv
The 53 schools on the 2013 CPS closure roster (names + street addresses verbatim from the CBS Chicago primary-source list, corroborated by NBC Chicago and DNAinfo), geocoded to lat/lng (Census geocode
Source: Chicago Public Schools / Chicago Board of Education action (closed list, primary source via CBS Chicago and Education Week, corroborated by UIC Great Cities Institute); City of Chicago Data Portal for the CPS school universe; repo file already shipped
cps-closed-schools-2013.csv
The pre-geocoding closed-school source file: the 53 closure-roster school names and street addresses transcribed from the CBS Chicago primary-source list, before lat/lng and community-area enrichment.
Source: Chicago Public Schools / Chicago Board of Education action (closed list, primary source via CBS Chicago and Education Week, corroborated by UIC Great Cities Institute); City of Chicago Data Portal for the CPS school universe; repo file already shipped
geocode_and_enrich.py
One-time, documented enrichment script. Geocodes the 53 closed-school addresses (Census public geocoder), assigns community areas to both closed and active schools by pure-Python ray-casting point-in-
Source: Chicago Public Schools / Chicago Board of Education action (closed list, primary source via CBS Chicago and Education Week, corroborated by UIC Great Cities Institute); City of Chicago Data Portal for the CPS school universe; repo file already shipped
This file is not a tabular CSV. Use the download button above to save it locally.
| school_latitude |
| text |
| school_longitude | text |
| student_count_total | text |
| student_count_low_income | text |
| student_count_black | text |
| student_count_hispanic | text |
| student_count_white | text |
| overall_rating | text |