Ontario COVID-19 Tracker Project

Bowen Zhang
June 24,2020

Introduction

This presentation is to introduce the Shiny application: Ontario Covid Tracker

Overview:

  • The application was built in Rstudio with the Shiny App and Leaflet packages. Here is an Overview:
  • The tracker allows users to view geographical data on each of the cases of COVID-19 in Ontario, Canada.
  • Users can filter the data and view the reactive map's results


Data API is from Ontario Data Catalogue: Link

The Data

We obtained the data via API and sourced 5 out of the 17 original variables for relevance.

  • Outcome1: The outcome of each case reported as of the current date
  • Case_Reported_Date: Date which the case was reported
  • Reporting_PHU_Latitude: Latitude of the reporting Public Health Unit
  • Reporting_PHU_Longitude: Longitude of the reporting Public Health Unit
  • Reporting_PHU: Name of the Public Health Unit reporting the case
'data.frame':   34016 obs. of  5 variables:
 $ Outcome1               : chr  "Resolved" "Resolved" "Resolved" "Resolved" ...
 $ Case_Reported_Date     : chr  "2020-05-09T00:00:00" "2020-05-21T00:00:00" "2020-05-29T00:00:00" "2020-05-30T00:00:00" ...
 $ Reporting_PHU_Latitude : num  43.7 43.7 43.7 43.7 43.7 ...
 $ Reporting_PHU_Longitude: num  -79.4 -79.4 -79.4 -79.4 -79.4 ...
 $ Reporting_PHU          : chr  "Toronto Public Health" "Toronto Public Health" "Toronto Public Health" "Toronto Public Health" ...

Functionality

  • Interactive map showing clusters of COVID-19 cases in Ontario
  • Filter by status: Resolved, Fatal, Not Resolved
  • Filter by date the cases were reported
  • Filter by individual Public Health Unit
  • Dive into each cluster to view Markers for individual cases (zoom in and click on cluster)
  • Dive into each individual case to see status and date for the patient (click on the marker)

Conclusion

Here is a quick output of the total number of cases (June 24/20):

length(covdata[,1])
[1] 34016




Try the Ontario Covid Tracker Shiny App yourself: Link Here

Github: Link Here