Clean Plates

Health inspection reports for restaurants in Philadelphia were only available from a city-run database, making it very difficult for users to find the important information on each establishment. This project was designed to scrape and store every inspection reports for every restaurant in the city from 2014 to present day.

Users can now easily search for inspections by restaurant name, neighborhood or zip code. Inspections are split into violation categories and restaurants are compared to others in the area to allow users to view how clean each establishment is and has been in the past.

After the project launched, the City of Philadelphia changed the rules on health inspections based on the work done. Prior to the project, the reports were only posted online 30 days after the inspections, but have since been changed to one day, to be more transparent.

Visit

My Role

I was that of the creator, designer, and developer. I came up with the idea, wrote the code to scrape the data, and finally designed and built the site. I also set up the database and server infrastructure to host the project. After the projected launched, I wrote a script to scrape data from an additional county and added that to the project as well.

Languages

Python

Django

MySQL

Leaflet.js

Other Projects

TrueCar

Planet of Triumphs

Nature's Bakery