Skip to main content
medRxiv
  • Home
  • About
  • Submit
  • ALERTS / RSS
Advanced Search

Using Administrative Data to Incorporate Age and Sex-Dependent Resource Use for COVID-19 Acute Care Resource Use Simulations in Ontario, Canada

View ORCID ProfileStephen Mac, View ORCID ProfileRaphael Ximenes, View ORCID ProfileKali Barrett, View ORCID ProfileYasin A. Khan, View ORCID ProfilePetros Pechlivanoglou, Juan David Rios, View ORCID ProfileDavid Naimark, View ORCID ProfileBeate Sander
doi: https://doi.org/10.1101/2020.12.16.20248166
Stephen Mac
1Institute of Health Policy, Management and Evaluation, University of Toronto, Toronto, Canada
2Toronto Health Economics and Technology Assessment (THETA) Collaborative, University Health Network, Toronto, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
  • ORCID record for Stephen Mac
  • For correspondence: sm.mac@mail.utoronto.ca
Raphael Ximenes
2Toronto Health Economics and Technology Assessment (THETA) Collaborative, University Health Network, Toronto, Canada
3Escola de Matemática Aplicada, Fundação Getúlio Vargas, Rio de Janeiro, Brasil
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
  • ORCID record for Raphael Ximenes
Kali Barrett
1Institute of Health Policy, Management and Evaluation, University of Toronto, Toronto, Canada
4University Health Network, Toronto, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
  • ORCID record for Kali Barrett
Yasin A. Khan
1Institute of Health Policy, Management and Evaluation, University of Toronto, Toronto, Canada
4University Health Network, Toronto, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
  • ORCID record for Yasin A. Khan
Petros Pechlivanoglou
1Institute of Health Policy, Management and Evaluation, University of Toronto, Toronto, Canada
5Hospital for Sick Children, Toronto, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
  • ORCID record for Petros Pechlivanoglou
Juan David Rios
5Hospital for Sick Children, Toronto, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
David Naimark
1Institute of Health Policy, Management and Evaluation, University of Toronto, Toronto, Canada
5Hospital for Sick Children, Toronto, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
  • ORCID record for David Naimark
Beate Sander
1Institute of Health Policy, Management and Evaluation, University of Toronto, Toronto, Canada
2Toronto Health Economics and Technology Assessment (THETA) Collaborative, University Health Network, Toronto, Canada
7ICES, Toronto, Canada
8Public Health Ontario, Toronto, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
  • ORCID record for Beate Sander
  • Abstract
  • Full Text
  • Info/History
  • Metrics
  • Data/Code
  • Preview PDF
Loading

Abstract

As the COVID-19 pandemic has progressed, more local data has become available, enabling a more granular modeling approach. In March 2020, we developed a COVID-19 Resource Estimator (CORE) model to estimate the acute care resource use in Ontario, Canada. In this paper, we describe the evolution of CORE2.0 to incorporate age, sex, and time-dependent acute care resource use, length of stay, and mortality to simulate hospital occupancy. Demographics (e.g., age and sex) of infected cases are informed by 4-month averages between March-June, and July-October using 10-year age groups. The probability of hospitalization, ICU admission, and requiring mechanical ventilation are all age and sex-dependent. LOS for each acute care level ranges from 5.7 to 16.15 days in the ward, 6.5 to 10.7 days in the ICU without ventilation, and 14.8 to 21.6 days on the ventilator, depending on month of infection. We calibrated some LOS components to reported ward and ICU occupancy between June 15 and October 31, 2020. Furthermore, we demonstrate the use of CORE2.0 for a regional analysis of Region of Waterloo, Ontario, Canada to simulate the ward bed, ICU bed, and ventilator occupancies for 30 days starting December 2020 for three case trajectory scenarios. Moving forward, this model has become highly flexible and customizable to data updates, and can better inform acute care planning and public measures as the pandemic progresses.

Introduction

In March 2020, we developed a COVID-19 Resource Estimator (CORE) model to estimate the acute care resource use in Ontario, Canada.(1) This model was based on predominantly international data and made assumptions based on expert opinion due to the limited knowledge of COVID-19 early in the pandemic. Since then, we have updated the model through several iterations (up to CORE 1.8) to better represent Ontario acute care pathways for COVID-19 patients. These updates include updated hospitalization, admissions, length of stay (LOS), and mortality data based on Ontario data, as well as an updated model structure. As the pandemic has progressed, more local, context-specific data on resource use became available, enabling a more granular modeling approach in our latest update to CORE 2.0. The schematic of CORE 2.0 is shown in Figure 1. All previous updates can be found in another report.(2) Here we describe the key structural and data updates to CORE 2.0.

Figure 1.
  • Download figure
  • Open in new tab
Figure 1. Updated model schematic of CORE 2.0.

Blue arrows represent recovery pathways; patients recovering from mechanical ventilation would transition to ward beds or remain in ICU beds (without mechanical ventilator) if there are no ward beds, and patients recovering from the ICU would also recover in the ward post-ICU. Red arrows represent the deterioration of patients who would require more intensive care and treatment. Patients can die in any of the health states.

Methods

Evolving COVID-19 Data in Ontario, Canada

CCM Plus is Ontario’s province-wide population-based dataset on all individuals who test positive for COVID-19. (3) CCM Plus includes individual-level data on demographics (e.g., age, sex, region), epidemiology (e.g., likely acquisition), patient characteristics (e.g., co-morbidities), acute care resource utilization (e.g., hospitalization, intensive care unit (ICU) admission, invasive mechanical ventilation (IMV)), health outcomes (e.g., mortality), and long-term care (LTC) residency. We obtained research ethics board approval from the University of Toronto.

We conducted a population-based cohort study using public health data to describe age- and sex-specific acute care use, LOS, and mortality.(4) This study showed that acute care use, including LOS, and mortality varies by age and sex, and has decreased between March and September in Ontario overall and within each groups. We include these changes and temporal trends in the updated model to capture unmeasured effects (e.g., changes in clinical practice).(4)

Demographics

The modelled population (i.e., incident cases starting March 1, 2020) takes into consideration individuals’ age and sex, informed by Ontario reported COVID-19 case demographics. In CORE 2.0, demographic parameter values (e.g., age and sex) of infected cases are sampled from distributions informed by 4-month averages between March-June, and July-October (Table 1). Day-to-day demographics fluctuate similarly to daily reported cases. We chose 4-months because after June, there was a noticeable increase in the proportion of reported COVID-19 cases in the younger age groups: 0-9, 10-19, 20-29 and 30-39 years. Using this data, an individual’s age and sex now determines the individual’s probability of being hospitalized, requiring ICU admission, mechanical ventilation, and death. A 4-month time frame balanced using specific data and computational resources required for simulation.

View this table:
  • View inline
  • View popup
  • Download powerpoint
Table 1. COVID-19 case demographics over time in Ontario

Time from Episode Date to Hospitalization

In CORE 2.0, we incorporated a lag period of 8 days between symptom onset and hospitalization for all cases. This lag period was informed by the mean number of days from episode date (defined as the earliest of case created, case reported, specimen, and symptom onset dates) to hospital admission date observed in Ontario.(5) We assumed that all COVID-19 individuals do not interact with the healthcare system in this period of 8 days, and do not consider variability across individuals.

Acute Care Resource Use

The probability of hospitalization, ICU admission, and ICU admissions requiring mechanical ventilation were all updated using age and sex-stratified parameter values (Table 2). For ICU admissions, there was a decrease in the proportion of ICU admissions in September within all age groups, and we therefore used the mean proportion of ICU admissions for September and October for anyone requiring ICU admission post-August.

View this table:
  • View inline
  • View popup
  • Download powerpoint
Table 2. Acute care resource use proportions by acute care level and time in Ontario

Mortality

The probability of death for patients in each of the acute care levels were updated by age, sex, and time (Table 3). Similar to the case demographics, there was a notable change in mortality, overall, and within age groups, in May and June. Hence, we used the mean mortality from March to May for the first three months of the pandemic, and the mean mortality from June to October for incident cases from June onwards. To parameterize the model, which is in daily time-steps, mortality was converted over the duration of the average LOS in each respective level of acute care (ward, ICU without IMV, and ICU with IMV).

View this table:
  • View inline
  • View popup
  • Download powerpoint
Table 3. Mortality by acute care level, age and sex

Length of Stay

We updated LOS (days) for each acute care level, which also changed over time by month (Table 4). When the individual is hospitalized, LOS is sampled from poisson and gamma distributions informed by monthly mean LOS and standard deviation. For patients who are admitted to ward, the average LOS was between 5.7 and 16.15 days. For patients requiring ICU care without ventilation, their average stay in the ICU was between 6.5 to 10.7 days. For patients who needed ICU care and ventilation, their average stay in the ICU was between 14.8 and 21.6 days. For any individual requiring ICU care (ventilator or no ventilator), the time spent in the ward prior and post ICU admission was 6.83 days; we assumed the 6.83 days was equally divided for the ward LOS pre- and post-ICU. Individuals requiring ventilators spend on average 1.2 days in the ICU without ventilation. Overall, for an individual requiring ventilation, their LOS includes the following distinct components: time spent in the ward prior and post to ICU admission, time in the ICU not ventilated, plus time on ventilation. Anytime during this LOS, patients may die. When an individual no longer requires a resource, either due to completion of LOS and discharge or death, the resource will become available to other individuals. Individuals who cannot access their required resource form a queue and may die depending on their disease severity.

View this table:
  • View inline
  • View popup
  • Download powerpoint
Table 4. Length of stay over time by acute care level

Analysis and Calibration

The model starts simulations on March 1, 2020. The number of COVID-19 cases between March 1, 2020 and October 31, 2020 were taken from Ontario’s Ministry of Health data.(6) We calibrated some LOS components (ICU, non-ventilated) to reported ward and ICU (with and without ventilation) occupancy between June 15 and October 31, 2020.(7) The non-ventilated ICU LOS was calibrated only for the most recent month of October since the analysis is subject to some censoring (i.e., individuals who may not have an outcome at the end of analysis follow-up time). The simulated occupancy from CORE 2.0 is compared to the reported occupancy data for all levels of care in Figures 2a-2c. Overall, simulations for all three level of care resources compare well with reported occupancy data up until October 31, 2020. A brief summary of all parameters is in Table 5.

View this table:
  • View inline
  • View popup
  • Download powerpoint
Table 5. Summary of model inputs for CORE 2.0
Figure 2a.
  • Download figure
  • Open in new tab
Figure 2a. Predicted and confirmed ward occupancy in Ontario based on administrative data
Figure 2b.
  • Download figure
  • Open in new tab
Figure 2b. Predicted and confirmed ICU occupancy in Ontario based on administrative data
Figure 2c.
  • Download figure
  • Open in new tab
Figure 2c. Predicted and confirmed ventilator occupancy in Ontario based on administrative data
Figure 3.
  • Download figure
  • Open in new tab
Figure 3. Predicted resource use in Waterloo region between Dec 1 and 30, 2020 for A) Ward beds B) ICU beds C) Ventilators

Regional Application of CORE 2.0 in Ontario

Here we describe an example of the use of CORE 2.0 for a regional analysis of acute care resource use for the Region of Waterloo, Ontario, Canada that serves 617,870 people from the cities of Cambridge, Kitchener, Waterloo and townships of North Dumfries, Wellesley, Wilmot and Woolwich. In this example, we simulate the ward bed, ICU bed, and ventilator occupancies for 30 days starting on December 1, 2020 for three different case trajectory scenarios:

  1. Growth 1.01: Growth of incident cases for 10 days at 1%, followed by contraction (reduction) of incident cases by 5% (i.e., [incident cases] day = [incident cases] day-1*0.95, where day = current date) for the remainder of the 30 days.

  2. Growth 1.03: Growth of incident cases for 10 days at 3%, followed by contraction (reduction) of incident cases by 5% for the remainder of the 30 days.

  3. Growth 1.05: growth of incident cases for 10 days at 5%, followed by contraction (reduction) of incident cases by 5% for the remainder of the 30 days.

These scenarios were chosen based on input from stakeholders from the region, and are designed to capture the potential decrease in cases after recent implementation of public health interventions to limit community transmission. The contraction rate of 5% starting at 10 days after peak are user-defined assumptions. The model used a run-in time of 8-days prior to the simulation start date (i.e., November 23, 2020), allowing the reported cases in the past 8 days to also start being hospitalized (if needed) on December 1st, and onwards, to provide a more accurate number of occupancies required within the next 30 days. The reported cases for November 23 to 30, 2020 were obtained from the Region of Waterloo.(8) On November 30, 2020, there were 66 incident cases reported, which is what the case growth scenarios started with; all reported cases used as input is reported in Table 6.

View this table:
  • View inline
  • View popup
  • Download powerpoint
Table 6. Case inputs for regional example

The results reported are the ward bed, ICU bed, and ventilator occupancies in Figures 3A-3C. These are the number of people requiring this resource on specific dates, and not the new admissions (i.e., there are new admissions, and also discharges based on survival, and length of stay). In these scenarios, as the increase of incident cases grows faster, the need for all resources increases. In the most conservative scenario used to estimate the capacity required, the Region of Waterloo may require up to 29 ward beds, 10 ICU beds, and 8 ventilators for COVID-19 patients, and in the worst case growth estimate (5%), these numbers increase to 37, 13, and 10, respectively.

There are some limitations to this regional analysis. First, the model parameters have all been calibrated and validated to Ontario’s population-level use of COVID-19 resource use, length of stay, and mortality by age and sex. This does not necessarily reflect the population from the Region of Waterloo. However, the Region of Waterloo is not considered a rural area or geographically different from many of the hotspots in Ontario (e.g., Toronto, Peel Region) and so the demographics of COVID-19 cases should still apply. Second, the results represent the occupancy that would be seen in the entire Region of Waterloo region, and not necessarily at a specific hospital. These results do not consider the current ward, ICU and ventilator occupancies prior to December 1, 2020. Unfortunately, because these individuals’ trajectory in their LOS is unknown, it was not possible to add these current occupancies into the model and so these must be considered for the near-term future in addition to the new resources predicted. Despite these caveats, CORE 2.0 was able to simulate acute care resource needs for regional analysis and provide an estimate for local hospital planners for resource allocation purposes.

Conclusion

CORE 2.0 now simulates individuals and their COVID-19 disease trajectory incorporating age, sex, and temporal trends for acute care resource use, mortality, and LOS. This model is highly flexible and customizable to data updates, and can better inform acute care planning and public measures as the pandemic progresses.

Data Availability

All data is presented in the Tables and Appendix of the manuscript and referenced when cited from the literature.

Appendix

Appendix 1. Patient Pathways

  1. Sent home: We assume individual self-isolates and recovers; these patients are not explicitly modeled.

  2. Admitted to ward: The individual is assigned a LOS sampled from a distribution that determines their LOS in the hospital. This individual is now subject to a daily probability of death. Once their stay is complete (i.e., did not die), this individual is discharged home and recovers.

  3. Admitted to intensive care unit (ICU): This individual is assigned a LOS sampled from a distribution for their ward stay (pre-ICU). If this sampled LOS for the ward (pre-ICU) stay is < 1, this individual proceeds straight to the ICU on the same day. If the LOS for the pre-ICU ward stay ≥ 1, then the individual is first admitted to the ward and they will deteriorate at a later day to require ICU admission.

    • This new structure more accurately simulates patient pathway, so that they can enter straight to ICU, or deteriorate later.

    • Once this individuals’ stay in the ward is equal to the LOS sampled for their ward stay (pre-ICU), this individual would deteriorate and are admitted to the ICU if resources are available. This individual is then assigned a LOS, sampled from a distribution, for their ICU admission and have a daily probability of death in the ICU.

    • Once their stay is complete (i.e., did not die), they are assigned a LOS in the ward (post-ICU), sampled from a distribution, and spend their recovery in the ward.

  4. Admitted to ICU with mechanical ventilator: If an individual is admitted to the ICU, there is a probability they will require a ventilator. If they do not need a ventilator, then they continue to the ICU like Step 3 above.

    • If an individual requires a ventilator, they are assigned a LOS, sampled from a distribution, to determine the number of days they stay in the ICU before requiring ventilation (pre-Vent). If this LOS < 1, this individual will require a ventilator immediately and receive it if the resources are available.

    • If this pre-Vent LOS ≥ 1, then this individual is admitted to the ICU and does not require a ventilator yet. Once this individuals’ stay in the ICU is equal to the pre-Vent LOS, they will deteriorate and require a ventilator.

    • This new structure more accurately simulates patient pathway, so that they can need a ventilator right away, or deteriorate while in the ICU later.

    • If a ventilator is available, they will be assigned a LOS sampled from a distribution. If they recover, they will move to the ward if these resources are available.

Footnotes

  • Funding Statement: This research was supported, in part, by a Canada Research Chair in Economics of Infectious Diseases held by Beate Sander (CRC-950-232429) and COVID-19 Rapid Research Funding (C-291-2431272-SANDER).

  • Competing interests: Kali Barrett has received personal fees from Xenios AG, outside of the submitted work. No other competing interests were declared.

References

  1. 1.↵
    Barrett K, Khan YA, Mac S, Ximenes R, Naimark DMJ, Sander B. Estimation of COVID-19– induced depletion of hospital resources in Ontario, Canada. Can Med Assoc J. 2020 May 14;192(24):E640–646.
    OpenUrlAbstract/FREE Full Text
  2. 2.↵
    Mac S, Ximenes R, Barrett K, Khan YA, Naimark D, Sander B. Predicting Hospital Resource Use in Ontario For a Potential Second Wave [Internet]. 2020. Available from: www.covid-19-mc.ca
  3. 3.↵
    Public Health Ontario. iPHIS Resources [Internet]. 2020 [cited 2020 Oct 9]. Available from: https://www.publichealthontario.ca/en/diseases-and-conditions/infectious-diseases/ccm/iphis
  4. 4.↵
    Mac S, Barrett K, Khan YA, Naimark DMJ, Rosella L, Ximenes R, et al. COVID-19 Demographics, Acute Care Resource Use and Mortality by Age and Sex in Ontario, Canada: Population-based Retrospective Cohort Analysis. medRxiv [Internet]. 2020 Jan 1;2020.11.04.20225474. Available from: http://medrxiv.org/content/early/2020/11/06/2020.11.04.20225474.abstract
  5. 5.↵
    Mac S, Barrett K, Khan YA, Naimark DMJ, Rosella L, Ximenes R, et al. COVID-19 Demographics, Acute Care Resource Use and Mortality by Age and Sex in Ontario, Canada: Population-based Retrospective Cohort Analysis. medRxiv. 2020 Jan;2020.11.04.20225474.
  6. 6.↵
    Government of Ontario. COVID-19 case data: All Ontario [Internet]. 2020 [cited 2020 Oct 9]. Available from: https://covid-19.ontario.ca/data
  7. 7.↵
    Ontario Ministry of Health. Daily Bed Census. 2020.
  8. 8.↵
    Region of Waterloo. Waterloo Region COVID-19 summary [Internet]. 2020 [cited 2020 Dec 9]. Available from: https://www.regionofwaterloo.ca/en/health-and-wellness/positive-cases-in-waterloo-region.aspx#
Back to top
PreviousNext
Posted December 18, 2020.
Download PDF
Data/Code
Email

Thank you for your interest in spreading the word about medRxiv.

NOTE: Your email address is requested solely to identify you as the sender of this article.

Enter multiple addresses on separate lines or separate them with commas.
Using Administrative Data to Incorporate Age and Sex-Dependent Resource Use for COVID-19 Acute Care Resource Use Simulations in Ontario, Canada
(Your Name) has forwarded a page to you from medRxiv
(Your Name) thought you would like to see this page from the medRxiv website.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
Share
Using Administrative Data to Incorporate Age and Sex-Dependent Resource Use for COVID-19 Acute Care Resource Use Simulations in Ontario, Canada
Stephen Mac, Raphael Ximenes, Kali Barrett, Yasin A. Khan, Petros Pechlivanoglou, Juan David Rios, David Naimark, Beate Sander
medRxiv 2020.12.16.20248166; doi: https://doi.org/10.1101/2020.12.16.20248166
Reddit logo Twitter logo Facebook logo LinkedIn logo Mendeley logo
Citation Tools
Using Administrative Data to Incorporate Age and Sex-Dependent Resource Use for COVID-19 Acute Care Resource Use Simulations in Ontario, Canada
Stephen Mac, Raphael Ximenes, Kali Barrett, Yasin A. Khan, Petros Pechlivanoglou, Juan David Rios, David Naimark, Beate Sander
medRxiv 2020.12.16.20248166; doi: https://doi.org/10.1101/2020.12.16.20248166

Citation Manager Formats

  • BibTeX
  • Bookends
  • EasyBib
  • EndNote (tagged)
  • EndNote 8 (xml)
  • Medlars
  • Mendeley
  • Papers
  • RefWorks Tagged
  • Ref Manager
  • RIS
  • Zotero
  • Tweet Widget
  • Facebook Like
  • Google Plus One

Subject Area

  • Infectious Diseases (except HIV/AIDS)
Subject Areas
All Articles
  • Addiction Medicine (228)
  • Allergy and Immunology (506)
  • Anesthesia (110)
  • Cardiovascular Medicine (1245)
  • Dentistry and Oral Medicine (206)
  • Dermatology (147)
  • Emergency Medicine (282)
  • Endocrinology (including Diabetes Mellitus and Metabolic Disease) (534)
  • Epidemiology (10032)
  • Forensic Medicine (5)
  • Gastroenterology (500)
  • Genetic and Genomic Medicine (2467)
  • Geriatric Medicine (238)
  • Health Economics (480)
  • Health Informatics (1647)
  • Health Policy (754)
  • Health Systems and Quality Improvement (637)
  • Hematology (250)
  • HIV/AIDS (536)
  • Infectious Diseases (except HIV/AIDS) (11872)
  • Intensive Care and Critical Care Medicine (626)
  • Medical Education (253)
  • Medical Ethics (75)
  • Nephrology (268)
  • Neurology (2290)
  • Nursing (139)
  • Nutrition (352)
  • Obstetrics and Gynecology (454)
  • Occupational and Environmental Health (537)
  • Oncology (1249)
  • Ophthalmology (377)
  • Orthopedics (134)
  • Otolaryngology (226)
  • Pain Medicine (158)
  • Palliative Medicine (50)
  • Pathology (325)
  • Pediatrics (734)
  • Pharmacology and Therapeutics (315)
  • Primary Care Research (282)
  • Psychiatry and Clinical Psychology (2281)
  • Public and Global Health (4844)
  • Radiology and Imaging (843)
  • Rehabilitation Medicine and Physical Therapy (492)
  • Respiratory Medicine (652)
  • Rheumatology (286)
  • Sexual and Reproductive Health (241)
  • Sports Medicine (227)
  • Surgery (269)
  • Toxicology (44)
  • Transplantation (125)
  • Urology (99)