Philly Center City District SIPS: An Interactive Map

A collection of interactive maps showing restaurants participating in Philly’s CCD SIPS

journalism
R
maps
webscraping
robotstxt
rvest
leaflet
tidygeocoder
Authors

Silvia Canelón

Mallori Lofton-Malachi

Published

June 16, 2024

Modified

March 2, 2025

Interactive Map QR code Map tutorial Workshop

1,552 unique visitors in the United States visited this post 2,032 times between June 5th and August 28th, 2024!

2,032 views, 1,397 visitors, 89% bounce rate, average visit time of 1 minute and 1 second. Column chart shows peaks on Wednesdays and valleys on Thursdays through Saturdays

Philly’s Center City District posted a list of restaurants and bars participating in Philly’s 2024 CCD SIPS. CCD SIPS is a series of summer Wednesday evenings (5-7pm) filled with happy hour specials, between June 5th and August 28th.

Information from the website was scarped in order to present the information as a map. You can click or tap on the circle map markers to see information about each restaurant/bar along with a direct link to their posted happy hour specials.

Check out the link at the top of this post for a larger version of the interactive map below, search the table below, or take a look at CCD SIPS maps from past years.

We’ve recently augmented the map with findings from the most recent food safety inspection report made available by the Philadelphia Department of Public Health for each establishment.

Each establishment is marked “Yes” if it had any violations in either the “foodborne illness risk factors” or “lack of good retail practices” categories. Here’s a summary from the Philly Inquirer Clean Plates tool, of what these categories mean:

How to Interpret Inspection Findings

Items on inspection reports are divided into two categories:

  • “Foodborne Illness Risk Factors” (top half of the form) are food establishments’ practices or procedures that scientists say play a direct role in transmitting germs. These are given higher priority during inspections. Repeat problems are taken more seriously; those that are fixed through public health interventions during the visit, less so. Specific violations or combinations of violations may trigger reinspections, which are common.
  • “Good Retail Practices” (bottom half) are given a lower priority. Research suggests that they can prevent the conditions that lead to contamination but do not cause illness directly. But a high number of violations may indicate a problem.

Map view

Table view

Past years

Back to top

Citation

For attribution, please cite this work as:
Canelón, Silvia, and Mallori Lofton-Malachi. 2024. “Philly Center City District SIPS: An Interactive Map.” June 16, 2024. https://silviacanelon.com/project/2024-06-16-ccd-sips/.