← Back to Posts

Forty states published school spending and nobody looked: Ian Patterson on open data without readers

Sean Roberts•September 9, 2020•4 min read

Ian Patterson runs the studio at Lincoln Network, where I work, so this conversation was with a colleague about a project our team built. I wanted to talk about one finding in particular, because it applies far beyond schools.

The federal education law passed in 2015, the Every Student Succeeds Act, requires every state to report how much is spent per pupil at each individual school. That had never been collected before. About forty states have now published it for the first time. Ian and our policy team went looking for it and found three things.

This data was very difficult to find, it was very difficult to analyze, and it was not getting really any attention so far, both from policymakers, school districts themselves, and parents.

So they built what they believe is the first database that lets anyone look up, in one place, how much their local school spends, whether it is a district school or a charter. Ian pointed to regular polling by EdChoice showing that most Americans badly underestimate how much their local schools spend on each child, so the number alone can change a conversation.

He was clear about why he thinks it matters this fall. With remote learning and shorter instructional hours, much of the cost of educating a child has moved back onto parents: supervising school at home, or arranging childcare if they are essential workers who cannot stay home. Depending on the district, spending can run fifteen or twenty thousand dollars a student, and higher in a few places. None of that money follows the student to where they are now spending most of their time. Ian sees the database as a conversation starter, first for researchers and policymakers and eventually for parents. A few states have started letting some funding follow students, and he would like that discussion to begin with real numbers.

Whatever you think about where school money should go, and people disagree about it with good reason, the first step is being able to see where it goes now. That is the part I keep coming back to.

Forty states published data that a federal law required, at real cost to every school district that had to produce it, and almost nobody looked. The data was not hidden. It was simply not usable. It was scattered across forty different state websites in different formats, it took expertise to interpret, and it was not attached to any question an ordinary person was asking. Publishing is not the same as informing.

Open data needs a reader, and readers need three things the raw files do not supply: a question they already care about, a comparison that makes a number mean something, and a format they can use without an analyst. Our team put the numbers in one place and tied them to the most local question there is, what my school spends. That does more for transparency than the original publication did.

There is a lesson here for anyone who writes a reporting mandate. The law should require not just that the data exist, but that someone can find it, compare it and understand it. And there is a lesson for anyone who builds with public data. The job is not done when the data is downloaded. It is done when someone who was not looking for a spreadsheet learns something they did not know. Ian has learned a second lesson about that, from watching parents use school-search tools: parents go quiet at a dashboard.

From Lincoln Shorts, the interview series I hosted for Lincoln Network, recorded 9 September 2020.

Share this post