It is difficult to do data work on CPS data. Schools move, close, open, split, co-locate, turnaround, change names.
I’m posting this spreadsheet here to take advantage of the “many eyes” of those interested in CPS data.** I haven’t been able to verify every data cell yet. So use with caution.
**Changes to a school’s location or governance can be followed by sorting on “Unit Number”. The most recent location/governance will be indicated by CPS actual unit number (e.g. Phillips HS AUSL 1510) Previous locations or governance for that same school will be on a separate line using a variation on the unit number. (e.g Phillips HS 1510.1 is the next most recent record of that school, and so on.)
There are some school action decisions taking place this week in Chicago related to the expansion of charter schools. The decisions are being justified as placing charter schools in areas of “overcrowding”. And that is, of course, interesting to us at CPS Apples 2 Apples.
Each of these schools and school branches since 1999 in this dataset can be traced back to an address and a community area. We are trying to track each closing, each opening, each re-location and all of the enrollments attached to specific neighborhoods and addresses.
This is going to take some time, of course. If any coders and interaction designers would like to try their hand at visualizing this data, we would like to invite them to do so. Because it isn’t completely verified, this is data for dialogue, not diagnosis.
Data for community involvement and for dialogue is important in the Open Gov community as long as we all realize the limitations of drawing conclusions from rough drafts of data. Questions about the history of Chicago Public School actions, not conclusions, is what we’re after.
Please post any comments and/or corrections to the dataset in the comments below, and we’ll be posting revisions in the future.
Pingback: Adding in the CPS Facilities Plan Data… | Apples 2 Apples in Chicago Public Schools
Pingback: Chicago: Rahm’s Demolition Derby for Public Schools | Diane Ravitch's blog
Since 1994 I’ve been piloting uses of maps to support the growth of non-school tutor/mentor programs in high poverty neighborhoods In this blog article I show a map from circa 1998, which shows poverty, CPS student population per region, and non-school programs that were in my database at that time. http://mappingforjustice.blogspot.com/2016/05/map-shows-population-changes-in-chicago.html
I’ve never had the resources or tech talent to do this as well as needed, and newer technology now makes creating maps easier.
Is there a way to add layers to your maps, showing poverty and demographics, so that people could understand how these cuts affect poor people more than others?
Daniel, Chicago Hack Night at 1871 has the tech talent and can help you out, I’ll bet.