Which schools in Illinois are in the most trouble?
Illinois has a budget crisis. There are currently about 60 hours left in the fiscal year and the state still hasn’t passed a budget. One of the biggest pressure points is K-12 funding. If the general assembly doesn’t pass K-12 funding soon then many schools across the state will be unable to open. As a way to show constituents that members of the General Assembly posted a spreadsheet that indicated how many days every school district in the state could operate if they didn’t receive funding in the upcoming fiscal year. I wanted to analyze that.
Some initial analysis
Let’s take a broad look at the data.
There are 852 districts in the state.
Here’s some simple frequencies. There is one big thing to note here: there are 541 NA’s. Those NA’s are actually districts that can remain open for the entire year. That means about 63% of districts can survive the entire year without state funding.
We have to remember that this histogram does not include those 541 who can make it the entire year. Most would survive over 200 days, as well.
Let’s run the same histogram and include the schools who have an entire year of funding in their reserves.
A lot of schools in Illinois are in very good shape. About 2/3 of them have a year of reserves on hand. That’s a pretty surprising statistic.
I need to do a lot of things with this data to generate a map of the counties that are most in danger. The first thing I’m going to do is eliminate all those districts that could survive the entire year and just deal with 311 that remain.
In order for a map to make any sense it can’t just be a raw count of number of schools in trouble by county, but it needs to expressed as a percentage of schools that have a limited amount of funds. Here’s how I got there.
There’s a bunch of syntax there. Basically I created a smaller dataframe that has a column with just those percentages and then I had to add the FIPS code for each county in order to actually map the counties. That’s below.
First thing. Counties in gray indicated counties that don’t have a school district that will run out of money this fiscal year. The other big takeaway is that there are a lot of counties in southern Illinois that are really struggling. In fact, southeastern Illinois is ground zero for potential problems.
I wanted to compare the number of schools in trouble with the poverty rate by county. It’s somewhat interesting to note that a lot of counties in Illinois have about the same level of poverty. Many are in the 10-15% range. There is some more poverty in southern Illinois but the difference isn’t really that stark.
Breakdown by Members of the General Assembly
It might be helpful for our state representatives to know which of them represent the highest number of schools that are in danger of closing down. Let’s do a count and display that in a histogram.
Below is datatable that is interactive and will allow you to search for any school district and look at the amount of time they have before the money runs out.