New Guide: Lessons for Creating a Data Dashboard in Your County

September 18, 2019
New Guide: Lessons for Creating a Data Dashboard in Your County

Over the last two years, the Texas Criminal Justice Coalition has worked to make the state’s criminal justice system more transparent by obtaining and visualizing criminal court data. Beginning with Harris County, this project has helped hold people in power accountable for their promises of reform.

With funding from Microsoft Cities Team and a partnership with data science firm January Advisors, this work expanded geographically to Dallas County, as well as expanding in scope to encompass best practices for increasing transparency in local criminal justice systems throughout Texas.

This is an iterative process. Criminal court disposition data is controlled at the county level, and Texas has 254 counties. Our approach was to begin by focusing on two of Texas’ most populous counties where reforms are already taking place. But it wasn’t easy.

Along the way, we encountered challenges related to obtaining and cleaning data, ensuring quality data, and visualizing data in ways that help people understand the narratives behind the data. Among other lessons, we learned the following while attempting to overcome these challenges:

  • The data must serve different kinds of community members, including advocates, voters, researchers, policymakers, and more. Engaging with each group helps shed light on what they want to get out of the experience.
  • Data is not standardized across Texas counties, so we had to develop methods for collecting, managing, and visualizing disparate datasets. Spelling mistakes are common!
  • Projects like this require a strategic data infrastructure, because even data from two counties requires a lot of care to maintain and update.

For more on each of the lessons learned, click here for a guide on our experiences. 

In addition to the lessons we learned, this guide outlines the steps we took, and the hurdles we faced, while working on this project. It also includes ways that the data could be used beyond the dashboard, such as tracking the impact of diversion programs and other campaign promises by elected officials. Finally, the guide outlines best practices for how to obtain new datasets and bring greater transparency to the other 250+ counties in Texas (and beyond!).

We hope you enjoy learning about our experience as much as we enjoyed working on the project. And stay tuned for more to come!

About the Author: 

Jay Jenkins, J.D.

Harris County Project Attorney

As TCJC’s project attorney advancing adult and youth justice reforms in the Houston and larger Harris County region, Jay has been part of the TCJC team since 2014.  He received his J.D. from Northwestern University School of Law in 2009, where he also advanced youth justice policy reform in Chicago.  Upon graduation, Jay worked as a civil litigator for three years.  His mission at TCJC is to work with local justice advocacy organizations and marginalized communities to promote best practices and innovations that will improve access to justice for all of Harris County.  You can learn more about Jay here.