Who doesn't love an interactive map?
I created an interactive version of the D3 map from my last post on predicting school closures. The map shows the areas hit the hardest by public school closures over the period 2010-2015. Hover over counties to bring up a text box with more information.
The Nitty Gritty
Interested in the finer points of how I created the above map? Read On!
- Data: Data was obtained from the National Center for Education Statistics' Common Core of Data from the years 2009-10 through 2014-15, which can be downloaded for free here.
- Processing: Data analysis was done in python using the pandas library. The total number of schools, closures, and closure rates for each county were calculated as follows:
- Total Number of Schools: Number of regular public schools that were operational in 2009-10. (i.e. schools in the 2009-10 CCD datafile where variables TYPE=1 and STATUS=1, 3, 4, 5 or 8. Full documentation is available here.)
- Total Number of Closures: Number of regular, 2009-10 operational schools that closed (either temporarily or permanently) between 2010-11 and 2014-15. (i.e. schools that were flagged as STATUS = 2 or 6 in the CCD datafile from at least one of those years).
- Closure Rate: Number of closures divided by the number of schools.
If you want to see more, check out the GitHub repo.