COVID-19 Cumulative Cases for Ontario
- Chart 1: Cumulative Known Cases by Day
- Chart 2: Cumulative Known Cases by Day (Log scale)
- Chart 3: Daily Increase in Known Cases
- Chart 4: Cumulative Known Cases by Status
- Chart 5: Cumulative Daily Tests by Test Result
- Table 1: Daily Covid Test Results
- Table 2: Presumptive Cases
- Table 3: Hospitalization Details
- Notes on Charts and Tables
Chart 1: Cumulative Known Cases by Day
Chart 2: Cumulative Known Cases by Day (Log Scale)
Chart 3: Daily Increase in Known Cases
Chart 4: Cumulative Known Cases by Status
Chart 5: Cumulative Daily Tests by Test Result
Table 1: Daily COVID-19 Test Results
Table 2: Presumptive Cases
|Date||Total Results||% Positive||Presumed Positive||Presumed Total Positive|
Table 3: Hospitalization Details
Notes on Charts and Tables
Data sourced daily from Ontario Ministry of Health COVID-19 Info page.
Note: the Minstry updates the cumulative totals daily but does not break them down by day. I used the Wayback Machine to access snapshots of the page from previous days to get the earlier numbers and have been accessing the live site since March 16.
I was inspired to start tracking this by Hanna Faghfoury, who created a chart up to March 16, and by Patricia Treble at Macleans, who had the idea to use the Wayback Machine to grab previous daily totals.
Update, 2020-04-04: The Province has finally started publishing hospitalization details: number of people hospitalized, on ICU, and on ICU with ventilator. I include this data in Table 3, and will include a chart once I have more than one day of data.
Update, 2020-04-03: I added a page with national results by province for cumulative confirmed cases and deaths by day.
Update, 2020-04-01: I changed charts 4 and 5 from stacked line to stacked bar. It just seems easier to read this way.
Update 2, 2020-03-31: I added a fifth chart, Cumulative Daily Tests by Test Result. It's a stacked line chart of Positive, Negative and Pending test results by day.
Update, 2020-03-31: The Province has resumed publishing the number of pending cases ("Currently Under Investigation") so I was able to update yesterday's results to include the Pending. And because I know the total tests, the positive and the pending results, I was also able to calculate the negative results and the presumptive case total.
Update 3, 2020-03-30: Please note that the definition of "resolved" has changed. As John Michael McGrath reports: "Before today, 'resolved' meant two separate rests coming back negative; now it means 'not currently listed as hospitalized in iPHIS, those that are 14 days past symptom onset (if present) or 14 days past the episode date if the case is closed.'" So take the new Resolved total with a big grain of salt.
Update 2, 2020-03-30: The Ontario Government COVID-19 test results page changed its format this morning. They no longer list Negative and Pending test results, only Positive and Total tests. As a result, I can no longer determine Total Results (it was Positive + Negative) in order to calculate a Presumed Positive among the Pending test results. If the Province continues not to provide this breakdown, I may retire Table 2.
In addition, the number of Resolved cases was holding steady at 8 for 8 days from March 22 through March 29 and then jumped to 431 today, which suggests the number was not being updated prior to today. You can see the big jump on Chart 4.
Update, 2020-03-30: I added a fourth chart, Cumulative Known Cases by Status: Active, Resolved and Deceased. I calculate Active as Positive (total known cases) minus Resolved and Deceased. I also tweaked the language used in the charts and tables based on an excellent Twitter thread by linguist Dr. Suzanne Wertheim.
Update, 2020-03-26: I added a JSON API you can use to download this data.
Update, 2020-03-23: I bit the bullet and added a log chart of cumulative cases by day.
Update, 2020-03-22: I added an "Increase" column to calculate the change in positive cases from the previous day.
Update, 2020-03-21: Out of curiosity, I have added the following calculated fields to the data table:
- Total Results: sum of the Positive and Negative values and represents all completed tests.
- % Positive: percent of Total Results that have a Positive test result.
- Presumed Positive: multplies the Pending value (outstanding tests) by % Positive to estimate how many pending tests will return positive
- Presumed Total Positive: sum of the Positive and the Presumed Positive values to estimate the total number of positive cases
Please note that these values are not confirmed and should be regarded as speculative. The Presumed Positive and Presumed Total Positive are just estimates based on the assumption that the backlog of tests under investigation has the same percentage of positive cases as the tests that have been returned.
This assumption may not be correct. Specifically, the positive rate from the pending backlog may be lower than the current day, since the backlog spans several previous days and the % positive has been trending upward. As a result, the presumed total may be slightly high.