Using Data to Track the COVID-19 Outbreak in Canada

By BrainStation March 31, 2020
Share

Colin Fraser, a Data Scientist at Facebook (and a former Lead Educator at BrainStation) has recently publish a dashboard that tracks the growth of COVID-19 across Canadian provinces. The data comes from the Johns Hopkins COVID-19 resource center, which they’ve shared publicly in this GitHub repo.

While Fraser cannot guarantee the accuracy of this information with the rapid progression of the virus, the data should be consistent with the Johns Hopkins dashboard.

Current Tally

According to the latest data, as of March 30th, 2020 there have been 7,385 confirmed cases reported in Canada, resulting in 79 deaths.

Breakdowns by province are below.

Confirmed Cases

Province Most Recent Data Confirmed Cases New Cases Average Daily Growth Rate (Last seven days)
Alberta 2020-03-30 661 40 12.5%
British Columbia 2020-03-30 970 86 11.4%
Manitoba 2020-03-30 96 24 27.5%
New Brunswick 2020-03-30 68 2 24.5%
Newfoundland 2020-03-30 148 13 34.9%
Northwest Territories 2020-03-30 1 0 0.0%
Nova Scotia 2020-03-30 127 5 17.9%
Ontario 2020-03-30 1,706 351 19.1%
Prince Edward Island 2020-03-30 18 7 33.2%
Quebec 2020-03-30 3,430 590 28.2%
Saskatchewan 2020-03-30 156 0 14.1%
Yukon 2020-03-30 4 0 8.3%

Deaths

Province Most Recent Data Total Deaths New Deaths Average Daily Growth Rate (Last seven days)
Alberta 2020-03-30 3 1 21.4%
British Columbia 2020-03-30 19 2 5.8%
Manitoba 2020-03-30 1 0 NA
Newfoundland 2020-03-30 1 1 NA
Ontario 2020-03-30 31 10 28.0%
Quebec 2020-03-30 22 0 32.9%
Saskatchewan 2020-03-30 2 2 NA

Confirmed Cases

Confirmed Cases Since The 10th Case

This chart shows the number of confirmed cases in each province, with the number of days since the 10th case on the x-axis. I’ve included New York State and Washington State for comparison, since those are two of the major US outbreaks. The dashed lines indicate how this chart would look if doubling the number of cases took two, three, or four days.

Growth Rate in Confirmed Cases Since 10th Confirmed Case

This plot shows the daily growth rate of confirmed cases since the 10th confirmed case. We want this to go to zero.

Confirmed Cases Over Time

This chart shows the number of confirmed cases on each date.

Deaths

Deaths Since 3rd Death

This chart shows the number of deaths since the third date in each province or state.

Deaths Over Time

This shows the number of deaths on each date (min three deaths). Note, I am not sure why Quebec dips for a few days, but this is consistent with the data provided by the JHU dashboard.

“The Curve”

This plot shows the number of active cases (cumulative confirmed cases minus deaths and recoveries) over time since the date of the tenth confirmed case in each location. This is “the curve” that you’ve heard about trying to flatten. Note that a different y-axis is drawn for each location.

Country Totals

This chart shows the number of confirmed cases since the tenth confirmed cases in a few selected countries.

Data

The data that I used to produce these charts is below.

Click here to find the COVID-19 data used by Fraser used.

 

Icon

Learn data skills to boost your career – from home!

BrainStation offers Online Live Certificate Courses in data science, data analytics, machine learning, and python programming. Attend live classes and interact with Instructors and peers from anywhere in the world.

Speak to a Learning Advisor