Civic News

The push for open data inside Philly’s Department of Public Health

How the Community Health Explorer won over a city agency, and got people talking.

Heath and technology. (Stethoscope on circuit boards via Shutterstock)

Since that flashy Community Health Explorer tool dropped last month, some 2,000 users have tinkered around with the 77 datasets available on the platform, according to city officials.
Although there’s no number available, Dr. Cheryl Bettigole, Division Director for Chronic Disease Prevention at the Department of Public Health (PDPH), said there has been an increased interest in the data the PDPH had previously been sitting on — in the form of dreaded PDFs and slide decks.
See, since 2014, the department has been putting out information on public health indicators in the form of Community Health Assessment reports. Granted, they weren’t in the friendliest of formats (here, have a 132-page PDF).
“People would have to pass through hundreds of slides to get the information,” Bettigole admits.
So when the Office of Open Data and Digital Transformation first mentioned the concept of the Community Health Explorer, the PDPH was all over it.
“This is a tool we’ve been very excited about and working hard on for close to a year,” said Bettigole.
And then Amory Hillengas and Meagan Pharis came into the picture, who Lauren Ancona — the city data scientist who spearheaded the project— credited as instrumental parts of the tool’s development.
“The biggest process is completing the annual report,” Pharis, a data analyst for PDPH, said of working on the project. “But as for translating the report to this online interactive platform, the work was more about data integrity, about making sure it was presented accordingly.”

The tool shows Philly has some work to do when it comes to health.

The tool shows Philly has some work to do when it comes to health. (Screenshot)


Although all an average user sees while tinkering around with the Community Health Explorer are smooth graphics and charts, you can imagine where all that flashy info came from: boring, wonky spreadsheets.
The team took on the task of cleaning up extensive Excel files with all the raw data before it could be turned into the final product.


“We had a lot of notation and extra noise in our spreadsheets and it wasn’t as translatable to the external audience,” said Pharis.
The biggest lesson for Pharis was being able to tell the difference between how a health data scientist views data and how developers view it, and jumping across those differences in order to translate between shorthands.
“And also, learning how important data visualization is for getting your message out there, explains Pharis. “We get more feedback and more notice in this format.”
But in the end, all the usable, searchable data in the world is no good unless it gets used and generates action. That’s why, for Bettigole, the ideal interaction between the explorer and the average citizen goes like this:
“In my ideal world, people would look at the tool and have conversations with friends and family,” she said. “They would ask questions like, ‘If diabetes rates in my neighborhood are high, why is that?'”

Before you go...

Please consider supporting Technical.ly to keep our independent journalism strong. Unlike most business-focused media outlets, we don’t have a paywall. Instead, we count on your personal and organizational support.

Our services Preferred partners The journalism fund
Engagement

Join our growing Slack community

Join 5,000 tech professionals and entrepreneurs in our community Slack today!

Trending

16 places to responsibly dispose of old electronics in Philadelphia

19 tech and entrepreneurship events to check out before the holidays

Are digital navigators the answer to closing Philadelphia’s tech gap?

Expect high-speed internet at 100 Philly rec centers in 2025, Verizon says

Technically Media