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.


4 thoughts on “A History of CPS Enrollment 1999-2014 (Rough Draft)

  1. Pingback: Adding in the CPS Facilities Plan Data… | Apples 2 Apples in Chicago Public Schools

  2. Pingback: Chicago: Rahm’s Demolition Derby for Public Schools | Diane Ravitch's blog

  3. 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?

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s