Illustration by Freepik Storyset

COVID-19 Visualizations

Cathy Jian, Celine Guirguis, Emily Nie, Michelle Lam, Mina Chong, Palak Agarwal, Rahma Osman, Ria Patel, Risheena Banerji, Sara Gehlaut, Thomas Cwintal, Vanessa Wong

In September 2020, a pandemic visualization taskforce was developed to combat the general lack of knowledge surrounding important data amassed from the SARS-CoV-2 virus in the past year. In preventing this panic, the Canadian government has effectively cut off the knowledge base of Canadians regarding the pandemic and important statistics. To reverse this, the Race to a Cure pandemic taskforce has aggregated current data related to three major points of interest: 

  1. Availability of medical resources in Canadian Hospitals

  2. Correlating, Testing, and Reporting of Cases

  3. Chronic Illness Patient Protection [specifically, cancer]

Researchers of the taskforce conducted an extensive review of current information available on the three topics of interest. Following this review of current literature and data, researchers identified datasets (provided directly from Statistics Canada) that encompassed a niche subtopic in each umbrella topic of interest. Said datasets were presented in visual formats, using the visualization software Tableau. The visualizations should accurately shed light on current data available on major topics of interest related to the SARS-CoV-2 pandemic.

Cleaning Hospital Room

Availability of beds, PPE, and ICU capacity

in hospitals

During the SARS-CoV-2 pandemic, many patients who test positive may be admitted to a hospital’s intensive care unit (ICU) based on their condition. The symptom profile of the SARS-CoV-2 virus is extremely varied and on the severe end of the spectrum, can include trouble breathing, persistent pain and pressure in the chest, oxygen deprivation and amnesia (Symptoms of Coronavirus). This symptomology often leads to major complications that land patients in the ICU. 

As the second wave of the pandemic is currently underway, it is to be expected the need for beds, personal protective equipment (PPE), and ICU spaces will rise. The issue, however, occurs when there is an equal number of patients in critical care units who are hospitalized for other conditions. These individuals require similar resources to SARS-CoV-2 patients, and a struggle between which group receives which resources arises. A number of visualizations explore this resource struggle and the managing efforts of hospitals across Canada during the second wave. 

a

  Correlations between ICU Bed Capacities and Deaths  

Thomas Cwintal

In this data set, researchers collected the latest ICU bed capacities in the following provinces and territories: Alberta, British Columbia, Manitoba, New Brunswick, Newfoundland, Nova Scotia, Northwest Territories, Prince Edward Island, Saskatchewan, and the Yukon Territory. The data relating SARS-CoV-2 deaths and the subsequent ICU capacities in each region was recorded in a double bar graph. The graph summarized statistics from December 2020 to present day. Both data sets related these numbers in units per thousand people in the province of interest. The data shows that areas with higher bed capacities, on average, displayed lower SARS-CoV-2 deaths per thousand. However, areas with known lesser populations (i.e the Northwest Territories) displayed low bed numbers and a low death rate. This can be attributed to the fact that with a lower overall population to service, lower bed numbers (in comparison to densely populated regions like Ontario) would not affect hospitals as this would be enough to service said population. 

c

  General Hospital Capacities 

Michelle Lam

This dataset focuses on general hospital resources in the province of Alberta. With an increasing trend of SARS-CoV-2 cases in the province, it is quickly becoming a pandemic hotspot. In the graph labelled “ICU cases in Alberta”, researchers have amalgamated all ICU case counts from across Canada (in blue) and Alberta (in red). The graph details ICU hospitalizations from September 20th to November 19th, and shows a clear increase in the number of hospitalizations. This can be attributed to the presence of a “second wave” of SARS-CoV-2. As Canadian provinces transition from warmer summer weather to colder conditions and the flu season, the infectious ability of the virus increases exponentially. The increase in ICU hospitalizations can also be attributed to looser restrictions and the return of students and adults to institutions (school, after-school activities, and workplaces). The graph labelled “Acute Care Services in Alberta in April” provides a comparison of resources available at the onset of the pandemic to the numbers seen in Alberta right now. The data looks at large urban centres (Edmonton, Calgary) and general areas of the province (Northern, Central, and Southern Alberta). 

 

Drive-through Coronavirus Testing

Correlating testing, reporting and cases

This sub-project focuses on how the number of COVID-19 tests done daily relates to cases counts and how hospitals are handling this situation. The correlating testing, reporting and cases visualization project gathered data for hospital capacity, ICU capacity, COVID-19 cases reported and testing for a variety of geographical locations across Canada during the year 2020 to see whether there is any correlation between testing, cases and hospital capacity. The hypothesis is that since hospitals only have a fixed number of staff, when testing increases the number of staff treating patients decreases. If more testing is done and cases do in fact go up, then the number of staff treating patients increases and the number of testing decreases meaning that fewer tests are done and people are unable to get their results quickly, further spreading the virus. This project collected, analysed and visually represented provincial data from Alberta, British Columbia, Manitoba, Quebec, Saskatchewan and the Maritimes as well as regional data from urban centers like Ottawa to see if there is any correlation.

a

  Hospitalization 

Emily Nie

Using data of hospitalization from COVID-19 in Alberta, Manitoba, Ottawa and Quebec we were able to create a histogram with lines coloured blue, orange, red and teal respectively to represent the hospitalization data over time. Alberta hospitalization data is from March 8 to November 3. Manitoba hospitalization data is from May 8 to October 24; this data is the weekly average of hospitalization numbers, additionally, there is a gap in the data on the week of October 11. Ottawa hospitalization data is from February 10 to October 31. Quebec hospitalization data is from March 6 to November 3.

b

  ICU Capacity 

Palak Agarwal

[VISUALIZATION IN PROGRESS] Using data of ICU Capacity from COVID-19 in Alberta, Manitoba, Ottawa and Quebec, we were able to create a histogram with lines coloured yellow, green, blue, and red respectively to represent the ICU cases over time. All four locations have ICU data from March 6 to October 31. The definition of intensive care in Quebec changed on May 19. 

c

  Regional Data 

Cathy Jian

Using data of COVID-19 hospitalization, ICU capacity, deaths, testing and active, confirmed, and recovered cases in Alberta,  British Columbia and Saskatchewan, we were able to make the following stacked bar charts to make provincial comparisons. In the hospitalizations, ICU capacity, and deaths graph, the provinces are listed in alphabetical order with patients who are deceased, hospitalized and in intensive care represented by the orange, red and teal bars respectively. This data was taken on December 13. 

In the breakdown of COVID-19 cases and total tests completed graphs, the provinces are listed in alphabetical order with tests completed, active cases, confirmed cases, and recovered cases represented by the yellow, orange, red, and green bars respectively. This data was taken on December 13.

d

  Testing/Positivity 

Ria Patel

Using data of daily COVID-19 testing and active cases in Alberta, British Columbia Manitoba, Ottawa and Quebec we were able to create a histogram with lines coloured red, green, yellow, purple, and blue respectively to represent the testing and reporting data over time. Alberta testing and reporting data is from March 6 to November 3. British Columbia testing and reporting data is from January 25 to November 2. Manitoba testing and reporting data is from May 3 to October 24; this data is the weekly average of test and case numbers. Ottawa testing and reporting data is from March 10 to October 28. Quebec testing and reporting data is from March 6 to November 5.

 

e

  Interview with Epidemiologist 

In order to achieve a deeper insight into the correlation between testing and reporting of COVID-19 cases during this pandemic, members of this visualization project team met with Cynthia Carr, a Canadian epidemiologist, founder of EPI Research and specialist in epidemiology and health policy for remote and Indigenous communities.

Carr advised our team on how to gather and analyze data and she gave insightful opinions into the field of epidemiology in the context of the ongoing pandemic. 

First, after reflecting on her experience in health policy and the political side of pandemic planning, Carr explained that prevention is the best method of planning. No amount of testing or lockdowns will prevent what could have been prevented by a strong health care infrastructure. The constant change in governing parties and short term health care plans create a difficult environment to cultivate strong pandemic prevention practices.

Cynthia Carr

Second, Carr reiterated that epidemiologists have studied pandemic graphs and created projections of cases counts based on current infrastructure for multiple pandemics and epidemics. The actual number of cases and the reported number of cases is almost always different as testing can be faulty and not every person gets tested. This validated the concern of testing affecting reporting. If less than ten tests are done in a day, the number of new cases that day will most definitely be equal to or lower than ten, despite potential untested positive cases.

Finally, in answer to our root questions:“Does more testing mean more cases?”, Carr answered no. That conclusion is easy to jump to but doesn’t take any of the other factors into effect. Everything from all citizens wearing masks to abiding by 14 day quarantine rules affects how a pandemic runs its course. Testing simply reveals a portion of the affected population, the amount of tests reflect the sample population size. The rules for testing including letting asymptomatic people or those with mild symptoms get tests also affects case numbers. 

In conclusion, the statement “increased testing means increasing cases” is an overgeneralization as there are far too many factors at play to determine a single cause of increasing COVID-19 case reporting.

Hospital Corridor

Protecting cancer patients during COVID-19

Cancer patients are one of the more vulnerable demographics during the time of the COVID-19 pandemic. This sub-project focuses on two main ideas: the world's first clinical trial led by Dr. Rebecca Auer, aiming to protect cancer patients from COVID-19 by boosting their immune systems, as well as Canadian hospitals and how they are accommodating cancer patients. 

a

  Dr. Rebecca Auer's Clinical Trial on IMM 101 

IMM 101 is a form of dead bacteria that works like a vaccine to activate certain innate immune cells to boost the immune system’s ability to fight harmful viruses and cancer cells. The goal of the clinical trial led by Dr. Rebecca Auer was to test if IMM-101 can reduce the severity of COVID-19 on patients who already have cancer. In 8 cancer centres in Canada, the goal of recruiting 1500 people who are currently receiving some sort of active cancer treatment. 500 will receive 3 doses of IMM-101, 1000 will receive no treatment. The researchers will then follow the participants of the study to see whether they become infected with COVID-19 to observe their symptoms and the impact on their cancer treatment plan (with results expected in 9 months - march 2021) IMM-101 enhances the body’s immune response in a non-specific way (innate immune response). Therefore, in this clinical trial, scientists are trying to see if IMM-101’s effects can be extended to COVID-19 infections and reduce the severity of the infection on patients with cancer. 

 

Dr. Rebecca Auer

b

How Canadian Hospitals are taking extra precautions when it comes to cancer patients
British Columbia

The priorities of the BC Cancer Care system during COVID-19 are the patient's care, symptoms, health, medication, needs and information. BC wants its cancer patients to be aware of the situation, informed as to what they can do to stay safe, and to understand the risk and follow precautions when going to pharmacies, centers and appointments. Many aspects of cancer care have changed as remote interaction is safest for patients. The visitor policy makes mental health extremely important as patients go through one of the hardest things in their lives. The new virtual resources are put in place to ensure safety and adequate support.There is a 0 visitor policy, with few exceptions. New additions to the system include virtual patient records, as well as online therapy and support. All measures have been taken place to prioritize safety by minimizing patient contact and ensuring that patients don't have to interact with people outside of their social circle. The same COVID-19 recommendations of wearing a mask and staying 2m apart apply for cancer patients. Most cancer screening services have reopened and medication is delivered to avoid trips to pharmacies.

Follow Us on Social Media

Sign up to the Race to a Cure Newsletters

  • Facebook
  • LinkedIn
  • Instagram

RACE TO A CURE

© 2020 Race to a Cure

Incorporated under the Canada Not-for-profit Corporations Act