https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0
Effective June 7th, 2024, this dataset will no longer be updated.This file contains data for the last 6 weeks on: Weekly counts and rates of Ottawa residents with laboratory-confirmed COVID-19 by episode date (i.e. the earliest of symptom onset, testing or reported date) and age. Weekly counts and rates of Ottawa residents with laboratory-confirmed COVID-19 by reported date. Data are from the Ontario Ministry of Health Public Health Case and Contact Management Solution (CCM).
Accuracy: Points of consideration for interpretation of the data: Data are entered into and extracted by Ottawa Public Health from the Ontario Ministry of Health Public Health Case and Contact Management Solution (CCM). The COD is a dynamic disease reporting system that allows for ongoing updates; data represent a snapshot at the time of extraction and may differ from previous or subsequent reports.As the cases are investigated and more information is available, the dates are updated. A person’s exposure may have occurred up to 14 days prior to onset of symptoms. Symptomatic cases occurring in approximately the last 14 days are likely under-reported due to the time for individuals to seek medical assessment, availability of testing, and receipt of test results.Confirmed cases are those with a confirmed COVID-19 laboratory result as per the Ministry of Health Public health management of cases and contacts of COVID-19 in Ontario. March 25, 2020 version 6.0.Counts will be subject to varying degrees of underreporting due to a variety of factors, such as disease awareness and medical care seeking behaviours, which may depend on severity of illness, clinical practice, changes in laboratory testing, and reporting behaviours.Surveillance testing for COVID-19 began in long term care facilities on April 25, 2020. Update Frequency: Tuesdays and Fridays
Attributes: Data fields: Week – Date of the first day of the episode week (i.e. the week during which the case first developed symptom, got tested or was reported to OPH – whichever was earliest). Date in format YYYY-MM-DD H:MM. Weekly Rate of COVID-19 by 20-year Age Groupings (per 100,000 pop) and Episode Date – The number of Ottawa residents with confirmed COVID-19 within an age group (e.g. 0-9 years) divided by the total Ottawa population for that age group. This fraction is then multiplied by 100,000 to get a rate of COVID-19 per 100,000 population for that age group.Weekly Total of Cases by Episode Date - number of Ottawa residents with laboratory-confirmed COVID-19 by episode date.Weekly Total of Cases by Reported Date – number of Ottawa residents with laboratory-confirmed COVID-19 by reported date.Weekly Rate of COVID-19 (per 100,000 pop) by Reported Date – number of Ottawa residents with laboratory-confirmed COVID-19 by reported date divided by the total Ottawa population and multiplied by 100,000. Contact: OPH Epidemiology Team | Epidemiology & Evidence, Ottawa Public Health
https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0
Effective June 7th, 2024, this dataset will no longer be updated.This file contains data on:
Cumulative count of Ottawa residents with laboratory-confirmed COVID-19 by episode date (i.e. the earliest of symptom onset, testing or reported date), including active cases and resolved cases.
Cumulative count of Ottawa residents with laboratory-confirmed COVID-19 who died by date of death.
Daily count of Ottawa residents with laboratory-confirmed COVID-19 by reported date and episode date.
Daily count of Ottawa residents with laboratory-confirmed COVID-19 by outbreak association and episode date.
Daily count of Ottawa residents with laboratory-confirmed COVID-19 newly admitted to the hospital, currently in hospital, and currently in the intensive care unit (ICU).
Cumulative rate of confirmed COVID-19 for Ottawa residents by age group and episode date.
Cumulative rate of confirmed COVID-19 for Ottawa residents by gender and episode date.
Daily count of Ottawa residents with laboratory-confirmed COVID-19 by source of infection and episode date.
Data are from the Ontario Ministry of Health Public Health Case and Contact Management Solution (CCM).
Accuracy: Points of consideration for interpretation of the data:
The percent of cases with no known epidemiological (epi) link, during the current day and previous 13 days, is calculated as the number of cases with no known epi link among all cases. The percent of cases with no known epi link is unstable during time periods with few cases.
Source of infection is based on a case's epidemiologic linkage. If no epidemiologic linkage is identified, source of infection is allocated using a hierarchy of risk factors: related to travel prior to April 1, 2020 > part of an outbreak > close or household contact of a known case > related to travel since April 1, 2020 > unspecified epidemiological link > no known source of infection > no information available.
Data are entered into and extracted by Ottawa Public Health from the Ontario Ministry of Health Public Health Case and Contact Management Solution (CCM). The CCM is a dynamic disease reporting system that allows for ongoing updates; data represent a snapshot at the time of extraction and may differ from previous or subsequent reports.
As the cases are investigated and more information is available, the dates are updated.
A person’s exposure may have occurred up to 14 days prior to onset of symptoms. Symptomatic cases occurring in approximately the last 14 days are likely under-reported due to the time for individuals to seek medical assessment, availability of testing, and receipt of test results.
Confirmed cases are those with a confirmed COVID-19 laboratory result as per the Ministry of Health Public health management of cases and contacts of COVID-19 in Ontario. March 25, 2020 version 6.0.
Counts will be subject to varying degrees of underreporting due to a variety of factors, such as disease awareness and medical care seeking behaviours, which may depend on severity of illness, clinical practice, changes in laboratory testing, and reporting behaviours.
Data on hospital admissions, ICU admissions and deaths are likely under-reported as these events may occur after the completion of public health follow up of cases. Cases that were admitted to hospital or died after follow-up was completed may not be captured in iPHIS or local health unit reporting tools.
Cases are associated with a specific, isolated community outbreak; an institutional outbreak (e.g. healthcare, childcare, education); or no known outbreak (i.e., sporadic).
The distribution of the source of infection among confirmed cases is impacted by the provincial guidance on testing.
Surveillance testing for COVID-19 began in long term care facilities on April 25, 2020.
Source of infection is allocated using a hierarchy: Related to travel prior to April 1, 2020 > Close contact of a known case or part of a community outbreak or source of infection is an institutional outbreak > Related to travel since April 1, 2020 > No known source of infection > Missing.
The percent of cases with unknown source, during the current day and previous 13 days, is calculated as the number of cases with no known source among cases who source of infection is not an institutional outbreak. Calculated over a 14 day period (i.e. the day of interest and the preceding 13 days). The percent of cases with no known source is unstable during time periods with few cases.
Update Frequency: Wednesdays
Attributes: Data fields:
Data fields:
Date – Date in format YYYY-MM-DD H:MM. The date type varies based on the column of interest and could be:
- Episode date – Earliest of
symptom onset, test or reported date for cases;
- Date of death – The date
the person was reported to have died
- Reported date – Date the
confirmed laboratory results were reported to Ottawa Public Health
- Hospitalization date
Cumulative Cases by Episode Date – cumulative number of Ottawa residents with laboratory-confirmed COVID-19 by episode date. Cumulative Resolved Cases by Episode Date – cumulative number of Ottawa residents with laboratory-confirmed COVID-19 that have not died and are either (1) assessed as ‘recovered’ in The CCM or (2) 14 days past their episode date and not currently hospitalized. Cumulative Active Cases by Episode Date– cumulative number of Ottawa residents with an active COVID-19 infection. Calculated as the total number of Ottawa residents with COVID-19 excluding resolved and deceased cases. Cumulative Deaths by Date of Death - cumulative number of Ottawa residents with laboratory-confirmed COVID-19 who died by date of death. Deaths are included whether or not COVID-19 was determined to be a contributing or underlying cause of death. Daily Cases by Reported Date – number of Ottawa residents with laboratory-confirmed COVID-19 by reported date 7-Day Average of Newly Reported Cases by Reported Date – number of Ottawa residents with laboratory-confirmed COVID-19 by reported date. Calculated over a 7 day period (i.e. the day of interest and the preceding 6 days). Daily Cases by Episode Date - number of Ottawa residents with laboratory-confirmed COVID-19 by episode date. Daily Cases Linked to a Community Outbreak by Episode Date – number of Ottawa residents with laboratory-confirmed COVID-19 associated with a specific isolated community outbreak by episode date. Daily Cases Linked to an Institutional Outbreak – number of Ottawa residents with laboratory-confirmed COVID-19 associated with a COVID-19 outbreak in a healthcare, childcare or educational establishment by case episode date. Healthcare institutions include places such as long-term care homes, retirement homes, hospitals, other healthcare institutions (e.g. group homes, shelters). Daily Cases Not Linked to an Institutional Outbreak (i.e. Sporadic Cases) – number of Ottawa residents with laboratory-confirmed COVID-19 not associated to an outbreak of COVID-19. Cases Newly Admitted to Hospital – Daily number of Ottawa residents with confirmed COVID-19 admitted to hospital. Emergency room visits are not included in the number of hospital admissions. Cases Currently in Hospital – Number of Ottawa residents with confirmed COVID-19 currently in hospital, includes patients in intensive care. Emergency room visits are not included in the number of hospitalizations. Cases Currently in ICU - Number of Ottawa residents with confirmed COVID-19 currently being treated in the intensive care unit (ICU). It is a subset of the count of hospitalized cases. Cumulative Rate of COVID-19 by 10-year Age Groupings (per 100,000 pop) and Episode Date – The number of Ottawa residents with confirmed COVID-19 within an age group (e.g. 0-9 years) divided by the total Ottawa population for that age group. This fraction is then multiplied by 100,000 to get a rate of COVID-19 per 100,000 population for that age group. Cumulative Rate of COVID-19 by Gender (per 100,000 pop) and Episode Date – The number of Ottawa residents with confirmed COVID-19 of a given gender (e.g. female) divided by the total Ottawa population for that gender. This fraction is then multiplied by 100,000 to get a rate of COVID-19 per 100,000 population for that gender. Source of infection is travel by episode date: individuals who are most likely to have acquired their infection during out-of-province travel. Number of cases with missing information on source of infection by episode date: assessment for source of infection was not completed. Number of cases with no known epidemiological link by episode date: individuals who did not travel outside Ontario, are not part of an outbreak, and are not able to identify someone with COVID-19 from whom they might have acquired infection. The assessment for source of infection was completed, but no sources were identified. Source of infection is a close contact by episode date: individuals presumed to have acquired their infection following close contact (e.g. household member, friend, relative) with an individual with confirmed COVID-19. Source of infection is an outbreak by episode date: individuals who are most likely to have acquired their infection as part of a confirmed COVID-19 outbreak. Source of Infection is Unknown by Episode Date: Ottawa residents with confirmed COVID-19 who did not travel outside
https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0
Rates of confirmed COVID-19 in Ottawa Wards, excluding LTC and RH cases, and number of cases in LTCH and RH in Ottawa Wards. Data are provided for all cases (i.e. cumulative), cases reported within 30 days of the data pull (i.e. last 30 days), and cases reported within 14 days of the data pull (i.e. last 14 days). Based on the most up to date information available at 2pm from the COVID-19 Ottawa Database (The COD) on the day prior to publication.Rates of confirmed COVID-19 in Ottawa Wards, excluding LTC and RH cases, and number of cases in LTCH and RH in Ottawa Wards. Data are provided for all cases (i.e. cumulative), cases reported within 30 days of the data pull (i.e. last 30 days), and cases reported within 14 days of the data pull (i.e. last 14 days). Based on the most up to date information available at 2pm from the COVID-19 Ottawa Database (The COD) on the day prior to publication. You can see the map on Ottawa Public Health's website.Accuracy: Points of consideration for interpretation of the data:Data extracted by Ottawa Public Health at 2pm from the COVID-19 Ottawa Database (The COD) on May 12th, 2020. The COD is a dynamic disease reporting system that allow for continuous updates of case information. These data are a snapshot in time, reflect the most accurate information that OPH has at the time of reporting, and the numbers may differ from other sources. Cases are assigned to Ward geography based on their postal code and Statistics’ Canada’s enhanced postal code conversion file (PCCF+) released in January 2020. Most postal codes have multiple geographic coordinates linked to them. Thus, when available, postal codes were attributed to a XY coordinates based on the Single Link Identifier provided by Statistics’ Canada’s PCCF+. Otherwise, postal codes that fall within the municipal boundaries but whose SLI doesn’t, were attributed to the first XY coordinates within Ottawa listed in the PCCF+. For this reason, results for rural areas should be interpreted with caution as attribution to XY coordinates is less likely to be based on an SLI and rural postal codes typically encompass a much greater surface area than urban postal codes (e.i. greater variability in geographic attribution, less precision in geographic attribution). Population estimates are based on the 2016 Census. Rates calculated from very low case numbers are unstable and should be interpreted with caution. Low case counts have very wide 95% confidence intervals, which are the lower and upper limit within which the true rate lies 95% of the time. A narrow confidence interval leads to a more precise estimate and a wider confidence interval leads to a less precise estimate. In other words, rates calculated from very low case numbers fluctuate so much that we cannot use them to compare different areas or make predictions over time.Update Frequency: Biweekly Attributes:Ward Number – numberWard Name – textCumulative rate (per 100 000 population), excluding cases linked to outbreaks in LTCH and RH – cumulative number of residents with confirmed COVID-19 in a Ward, excluding those linked to outbreaks in LTCH and RH, divided by the total population of that WardCumulative number of cases, excluding cases linked to outbreaks in LTCH and RH - cumulative number of residents with confirmed COVID-19 in a Ward, excluding cases linked to outbreaks in LTCH and RHCumulative number of cases linked to outbreaks in LTCH and RH - Number of residents with confirmed COVID-19 linked to an outbreak in a long-term care home or retirement home by WardRate (per 100 000 population) in the last 30 days, excluding cases linked to outbreaks in LTCH and RH –number of residents with confirmed COVID-19 in a Ward reported in the 30 days prior to the data pull, excluding those linked to outbreaks in LTCH and RH, divided by the total population of that WardNumber of cases in the last 30 days, excluding cases linked to outbreaks in LTCH and RH - cumulative number of residents with confirmed COVID-19 in a Ward reported in the 30 days prior to the data pull, excluding cases linked to outbreaks in LTCH and RHNumber of cases in the last 30 days linked to outbreaks in LTCH and RH - Number of residents with confirmed COVID-19, reported in the 30 days prior to the data pull, linked to an outbreak in a long-term care home or retirement home by WardRate (per 100 000 population) in the last 14 days, excluding cases linked to outbreaks in LTCH and RH –number of residents with confirmed COVID-19 in a Ward reported in the 30 days prior to the data pull, excluding those linked to outbreaks in LTCH and RH, divided by the total population of that WardNumber of cases in the last 14 days, excluding cases linked to outbreaks in LTCH and RH - cumulative number of residents with confirmed COVID-19 in a Ward reported in the 30 days prior to the data pull, excluding cases linked to outbreaks in LTCH and RHContact: OPH Epidemiology Team
https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0
Summary of COVID-19 outbreaks in Ottawa healthcare, childcare and educational establishments, based on the most up to date information available in the the Ontario Ministry of Health Public Health Case and Contact Management Solution (CCM) .
Accuracy: Points of consideration for interpretation of the data: The data was extracted by Ottawa Public Health from the Ontario Ministry of Health Public Health Case and Contact Management Solution (CCM) . The CCM is a dynamic disease reporting system that allows for ongoing updates to data previously entered. The data extracted from The CCM represent a snapshot at the time of extraction and may differ in previous or subsequent reports.Data are for confirmed outbreaks and the number of staff, living in Ottawa, and residents/patients/students with laboratory confirmed COVID-19 associated to each outbreak is provided. Please note, individuals may be linked to multiple outbreaks. All the outbreaks reflect the outbreak definitions at the time they were declared open:Healthcare Institutions: From April 1st 2020, 1 staff or resident case of laboratory-confirmed COVID-19 is considered an outbreak in long-term care homes (LTCH), retirement homes (RH) and other healthcare institutions (e.g. group home, assisted living, group shelter) and declared facility wide. Starting May 10th 2020, 2 staff or patient cases of laboratory-confirmed COVID-19 within a specified hospital unit within a 14-day period where both cases could have reasonably acquired their infection in hospital is considered an outbreak in a public hospital.Childcare & Education: Starting July 2020, 1 child or staff (or household member) case of laboratory-confirmed COVID-19 is considered an outbreak in a childcare establishment. Starting August 26 2020, 2 student or staff (or visitor) cases of laboratory-confirmed COVID-19 within a specified class within a 14-day period where at least one case could have reasonably acquired their infection at school (including transportation and before/after school care) is considered an outbreak in an educational establishment. Update Frequency: Tuesdays and Fridays
Attributes: Data fields: Facility Name – textType of Facility - textLocation in Facility – textReported Date – date the COVID-19 outbreak was openedEnd Date - date the COVID-19 outbreak was closedResident/Patient/Child/Student Cases – number of residents, patients, children, or students with confirmed COVID-19Resident/Patient/Child/Student Cases – number of residents, patients, children, or students with confirmed COVID-19 who diedStaff Cases – number of staff with confirmed COVID-19Staff Deaths – number of staff with confirmed COVID-19 who diedTotal Cases – total number of people with confirmed COVID-19Total Deaths – total number of people with confirmed COVID-19 who died Contact: OPH Epidemiology Team | Epidemiology & Evidence, Ottawa Public Health
https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0
Daily number of Ottawa residents tested for COVID-19 and the percentage of residents tested with laboratory-confirmed COVID-19. Data are based on information extracted from the Ontario Laboratories Information System (OLIS) on Monday, Wednesday, and Friday.
Accuracy: Points of consideration for interpretation of the data: Not all labs report to OLIS and only patients with health card numbers are included in the OLIS dataset.Once an individual is confirmed positive, subsequent tests for that individual are excluded from the daily totals.Duplicate tests are excluded from the total number of positive tests, including those that arose from multiple tests of cure. Results for patients who placed an OLIS consent block (~50 records province-wide) are excluded.Staff working in long-term care homes are not captured in OLIS.City assignment in OLIS is based on the patient's health card address. Patients living in long-term care homes may not have the correct address associated with their health cards; therefore, not all tests in long-term care homes may be captured.Confirmed cases are those with a confirmed COVID-19 laboratory result as per the Ministry of Health Public health management of cases and contacts of COVID-19 in Ontario. March 25, 2020 version 6.0.The province has had to limit testing to priority groups in the early stages of the pandemic. Since only a small fraction of all the persons who were infected with the COVID-19 virus were tested, the number of reported confirmed community cases underestimates the actual number of infections. Information on overall infection rates in Canada will not be available until large studies on COVID-19 antibody presence in blood serum are conducted. Based on available information, the actual number of infections may lie from 5 to 30 times or more than the reported number of cases (1).Surveillance testing for COVID-19 began in long term care facilities on April 25, 2020. Reference: Richterich P. Severe underestimation of COVID-19 case numbers: Effect of epidemic growth rate and test restrictions. medRxiv. April 2020: 2020.04.13. doi.org/10.1101/2020.04.13.20064220 Update Frequency: Tuesdays and Fridays Attributes: Data fields: Date – date of the test (YYYY-MM-DD).Number of tests – number of Ottawa residents tested for COVID-19Daily % Positivity – number of Ottawa residents tested on that day that received a positive test result for COVID-19 divided by the total number of Ottawa residents tested on that dayNumber of tests in LTCH– number of Ottawa residents in long-term care homes who were tested for COVID-19LTCH Daily % Positivity – number of Ottawa residents in long-term care homes tested on that day that received a positive test result for COVID-19 divided by the total number of Ottawa residents in long-term care homes tested on that day Contact: OPH Epidemiology Team | Epidemiology & Evidence, Ottawa Public Health
https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0
Cumulative and monthly counts and rates of confirmed COVID-19 in Ottawa neighbourhoods, excluding cases linked to outbreaks in long-term care homes (LTCH) and retirement homes (RH). Based on the most up to date information available at 2pm from the COVID-19 Ottawa Database (The COD) on the day the data is pulled to provide the monthly update.
Accuracy: Points of consideration for interpretation of the data:
• Data extracted by Ottawa Public Health at 2pm from the COVID-19 Ottawa Database (The COD) the day prior to publication. The COD is a dynamic disease reporting system that allow for continuous updates of case information. These data are a snapshot in time, reflect the most accurate information that OPH has at the time of reporting, and the numbers may differ from other sources.
• A case (an individual with laboratory-confirmed COVID-19 infection) is assigned to an Ottawa Neighbourhood Study (ONS) geography based on the individual’s residential postal code and the ONS’s postal code conversion file. As the area served by a given postal code may cross multiple neighbourhoods, the ONS postal code conversion file identifies the proportion of each postal code that falls within a neighbourhood. Thus, for cases with postal codes falling within multiple neighbourhoods, a fraction of those cases will be assigned to each neighbourhood.
• Rates calculated from very low case numbers or for neighbourhoods with very small populations are unstable and should be interpreted with caution. Low case counts have very wide 95% confidence intervals, which are the lower and upper limit within which the true rate lies 95% of the time. A narrow confidence interval leads to a more precise estimate and a wider confidence interval leads to a less precise estimate. In other words, rates calculated from very low case numbers fluctuate so much that we cannot use them to compare different areas or make predictions over time.
Update Frequency: Monthly
Attributes: Data fields
• ONS Neighbourhood – text • Cumulative rate (per 100 000 population), excluding cases linked to outbreaks in LTCH and RH – cumulative number of residents with confirmed COVID-19 in a neighbourhood, excluding those linked to outbreaks in LTCH and RH, divided by the total population of that neighbourhood • Cumulative number of cases, excluding cases linked to outbreaks in LTCH and RH - cumulative number of residents with confirmed COVID-19 in a neighbourhood, excluding cases linked to outbreaks in LTCH and RH • Monthly rates (per 100 000 population), excluding cases linked to outbreaks in LTCH and RH –number of residents with confirmed COVID-19 in a neighbourhood reported to OPH during the month of interest, excluding those linked to outbreaks in LTCH and RH, divided by the total population of that neighbourhood. • Monthly number of cases reported, excluding cases linked to outbreaks in LTCH and RH - number of residents with confirmed COVID-19 in a neighbourhood reported to OPH during the month of interest, excluding cases linked to outbreaks in LTCH and RH.
Contact: OPH Epidemiology Team & Ottawa Neighbourhood Study Team | Epidemiology & Evidence, Ottawa Public Health
https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0
This file contains data regarding a 7-day average of the estimated instantaneous reproduction number, R(t), of COVID-19 in Ottawa. The reproduction number, R, is the average number of secondary cases of disease caused by a single infected individual over his or her infectious period. R(t) values greater than 1 indicate the virus is spreading faster and each case infects more than one contact, and less than 1 indicates the spread is slowing and the epidemic is coming under control.
R(t) was calculated using the EpiEstim package, developed by Cori et al. (2013; DOI: 10.1093/aje/kwt133), in the R software environment for statistical computing and graphics. Accurate episode date was used as the time anchor and cases were assigned as having a local or travel-related source of infection.
Accuracy: Points of consideration for interpretation of the data: Data are entered into and extracted by Ottawa Public Health from la Solution de gestion des cas et des contacts pour la santé publique (Solution GCC). The CCM is a dynamic disease reporting system that allows for ongoing updates; data represent a snapshot at the time of extraction and may differ from previous or subsequent reports.As the cases are investigated and more information is available, the dates are updated.A person’s exposure may have occurred up to 14 days prior to onset of symptoms. Symptomatic cases occurring in approximately the last 14 days are likely under-reported due to the time for individuals to seek medical assessment, availability of testing, and receipt of test results.Confirmed cases are those with a confirmed COVID-19 laboratory result as per the Ministry of Health Public health management of cases and contacts of COVID-19 in Ontario. March 25, 2020 version 6.0.Counts will be subject to varying degrees of underreporting due to a variety of factors, such as disease awareness and medical care seeking behaviours, which may depend on severity of illness, clinical practice, changes in laboratory testing, and reporting behaviours.Surveillance testing for COVID-19 began in long term care facilities on April 25, 2020. Attributes: Data fields: Date – the earliest of symptom onset, test or reported date for cases (YYYY-MM-DD H:MM).Lower Bound - 95% Confidence Interval - lower bound of the 95% confidence interval for the 7-day average of the R(t) estimate. Upper Bound - 95% Confidence Interval - upper bound of the 95% confidence interval for the 7-day average of the R(t) estimate.Estimate of R(t) (7 Day Average) - 7-day average of the estimated instantaneous reproduction number, R(t), of COVID-19 in Ottawa. Nowcasting Adjusted Cases by Episode Date – number of Ottawa residents with confirmed COVID-19 by episode date. Counts for the most recent 14 days represent a nowcasting adjusted estimate developed by R. Imgrund in 2020. The model uses linear regression to estimate the number of future cases expected to have an accurate episode date within that 14-day window. Update Frequency: As of March 2022, the dataset is no longer updated. Historical data only. Contact: OPH Epidemiology Team
https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0
COVID-19 testing rates and percent positivity, excluding long-term care home (LTCH) residents, by Ottawa Neighbourhood Study neighbourhoods. Data are a compilation of data extracted weekly by the Institute for Clinical Evaluative Sciences (ICES) from iPHIS Plus and Public Health Ontario's COVID-19 laboratory data (Chung H. et al., 2021).Date created:Data effective May 2021. Uploaded to Open Data on May 30, 2021.Update frequency: MonthlyAccuracy - Points of consideration for interpretation of the data:Testing data were compiled by the Institute for Clinical Evaluative Sciences (ICES) and are based on information extracted from iPHIS Plus and Public Health Ontario's COVID-19 laboratory data (Chung H, Fung K, Ishiguro L, Paterson M, et al. Characteristics of COVID-19 diagnostic test recipients, Applied Health Research Questions (AHRQ) # 2021 0950 080 000. Toronto: Institute for Clinical Evaluative Sciences; 2020). Data are updated monthly and are provided by IC/ES as weekly counts. Monthly aggregates are based on the start date of weekly counts.Individuals who have testing episodes on multiple days in a weekly testing period are only counted once per week. Those who have both negative and positive test results within a weekly testing period are considered positive. Any and all testing episodes after an individual's first confirmed positive COVID-19 test (since 15 January 2020) are excluded from subsequent weekly counts (both numerator and denominator). Testing date represents the date of specimen collection. Due to the time required for transportation and processing of specimens, it takes 6 days for approximately 95% of results to be finalized and reported for a given testing date. Tested individuals include those whose result is confirmed positive, negative, indeterminate, or pending. For individuals confirmed positive using their record in the Ontario Ministry of Health integrated Public Health Information System (iPHIS), their public health unit (PHU) assignment was based on their diagnosing PHU. For all others, PHU assignment was based on the postal code in RPDB as of the testing date. The current Registered Persons Database (RPDB), which has basic demographic information on anyone who has ever received an Ontario health card number, is updated up to 30 April 2021.Only COVID-19 testing by standard polymerase chain reaction are reported. Tests done by other methods, such as rapid point-of-care, are excluded.Rates and percent positivity calculated from very low case counts, or for small populations, are unstable and should be interpreted with caution. For this reason, testing rates and percent positivity are not presented for neighbourhoods with populations of less than 2000 persons or when counts (i.e. total number tested or total number tested positive) are between 1-6 for a given neighbourhood.Confirmed cases are those with a confirmed COVID-19 laboratory result as per the Ministry of Health Public health management of cases and contacts of COVID-19 in Ontario. March 25, 2020 version 6.0.The province has had to limit testing to priority groups in the early stages of the pandemic. Since only a small fraction of all the persons who were infected with the COVID-19 virus were tested, the number of reported confirmed community cases underestimates the actual number of infections. Information on overall infection rates in Canada will not be available until large studies on COVID-19 antibody presence in blood serum are conducted. Based on available information, the actual number of infections may lie from 5 to 30 times or more than the reported number of cases (1). Surveillance testing for COVID-19 began in long term care facilities on April 25, 2020.Reference: 1. Richterich P. Severe underestimation of COVID-19 case numbers: Effect of epidemic growth rate and test restrictions. medRxiv. April 2020: 2020.04.13. doi.org/10.1101/2020.04.13.20064220Attributes - Data Fields:ONS ID – Ottawa Neighbourhood Study (ONS) neighbourhood identification number.ONS Name – ONS neighbourhood name.Month – The year and month of data, based on the start date of weekly counts.Testing rate (per 1000 population), excluding LTCH residents – number of Ottawa residents tested for COVID-19 during the month of interest, excluding LTCH residents, divided by the total population of that neighbourhood and multiplied by 1000.% Positivity (Excluding LTCH) – number of Ottawa residents tested for COVID-19 during the month of interest that received a positive test result divided by the total number of Ottawa residents tested during that month. Both the numerator and the denominator exclude LTCH residents.
https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0
Summary of COVID-19 community outbreaks in Ottawa based on the most up to date information available in the Ontario Ministry of Health Public Health Case and Contact Management Solution (CCM).
Accuracy: Points of consideration for interpretation of the data:
• The data was extracted by Ottawa Public Health from the Ontario Ministry of Health Public Health Case and Contact Management Solution (CCM). The CCM is a dynamic disease reporting system that allows for ongoing updates to data previously entered. The data extracted from The CCM represent a snapshot at the time of extraction and may differ in previous or subsequent reports.
• Data are for confirmed outbreaks and the number Ottawa residents with laboratory confirmed COVID-19 associated to each outbreak is provided. Please note, individuals may be linked to multiple outbreaks.
• All the outbreaks reflect the outbreak definitions at the time they were declared open:
o Community: From April 1st 2020, 2 or more laboratory-confirmed COVID-19 cases with an epidemiological link in the setting within a 14-day period where at least 2 cases could have reasonably acquired their infection in the setting. Examples of epidemiological links in community settings include community organization (e.g. attended same social or volunteer club meeting), religious/spiritual organization (e.g. attended same service), residential (e.g. multi-unit dwelling - from different households in the same apartment building but rode the elevator together, used a common room at the same time), social event (e.g. attended same one-time party, wedding or funeral together), sports and recreation (e.g. attended same sports team practice or fitness class), or workplace (e.g. same work area, same shift).
• Public health is only required to formally declare outbreaks for workplace community settings but has chosen to declare outbreaks in other community settings when there is more risk to the public, there are challenges in contact tracing and/or capacity allows. Since October 2020, OPH has systematically reported outbreaks in other community settings. Please see the definitions for community outbreaks posted on the OPH COVID-19 Dashboard web page for more information.
Attributes: Data fields:
• Outbreak ID
• Setting - text
• Sub-category - text
• Start Date - outbreak start date
• End Date – outbreak end date
• Cases – total number of people with confirmed COVID-19 linked to the outbreak
• Deaths – total number of people with confirmed COVID-19 linked to the outbreak who died
Update Frequency: Daily
Contact: OPH Epidemiology Team
https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0
Date created: November 2023Update frequency: Daily from Mon to Friday, excluding statutory holidays.Accuracy: Points of consideration for interpretation of the data:The data was extracted by Ottawa Public Health from the Ministry of Health and Long-Term Care’s integrated Public Health Information System (iPHIS) and COVID-19 Case and Contact Management solution (CCM). IPHIS and CCM are dynamic disease reporting systems that allow for ongoing updates to data previously entered. The data extracted from iPHIS and CCM represent a snapshot at the time of extraction and may differ in previous or subsequent reports.Data are presented for confirmed outbreaks and all outbreaks met the outbreak definitions at the time of reporting.Data fields:Type of Outbreak - textOutbreak Name – textFacility Type – textOutbreak Location Details – textStart Date – Date outbreak declaredEnd Date – Date outbreak declared overAetiologic agent - textAuthor: OPH Epidemiology TeamAuthor email: OPH-Epidemiology@ottawa.caMaintainer Organization: Epidemiology & Evidence, Ottawa Public Health
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Risk of bias assessment—Modified Newcastle-Ottawa Scale [10].
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
In the “Source” column, literature indicates that we found a value directly from data in the literature, inferred indicates that we inferred a value based on published data in the literature, by definition signifies a value that we set in our model formulation, chosen indicates that a value is unknown but we made a choice in our model, borrowed indicates that we adopted a value directly from a model in the literature, and fit indicates that we use Ottawa case data along with other (i.e., not fit) parameters in this table to estimate a value.
https://ottawa.ca/fr/hotel-de-ville/decouvrir-votre-ville/donnees-ouverteshttps://ottawa.ca/fr/hotel-de-ville/decouvrir-votre-ville/donnees-ouvertes
Les taux de tests et pourcentage de positivité de la COVID-19, à l’exclusion des résidents des foyers de soins de longue durée (FSLD), par quartiers de l’Étude des quartiers d’Ottawa. Les données sont une compilation de données extraites chaque semaine par l’Institut de recherche en services de santé (IRSS) de l’iPHIS Plus et des données de laboratoire sur la COVID-19 de Santé publique Ontario (Chung H. et coll., 2021).Date de création:Données en vigueur mai 2021. Téléchargé aux données ouvertes le 30 mai 2021.Fréquence des mises à jour:MensuellementExactitude - Points à considérer pour l’interprétation des données:Les données d’essai ont été compilées par l’Institut de recherche en services de santé (IRSS) et sont basées sur les données de laboratoire sur la COVID-19 d’iPHIS Plus et de Santé publique Ontario (Chung H, Fung K, Ishiguro L, Paterson M, et coll. Characteristics of COVID-19 diagnostic test recipients, Applied Health Research Questions (AHRQ) # 2021 0950 080 000. Toronto : Institut de recherche en services de santé; 2020). Les données sont mises à jour mensuellement et sont fournies par IC/ES sous forme de dénombrements hebdomadaires. Les agrégats mensuels sont basés sur la date de début des dénombrements hebdomadaires.Les personnes qui ont des épisodes de test sur plusieurs jours dans une période de test hebdomadaire ne sont comptées qu’une fois par semaine. Les personnes qui obtiennent des résultats négatifs et positifs au cours d’une période de test hebdomadaire sont considérées comme positives. Tous les épisodes de test après le premier résultat positif à la COVID-19 confirmé pour un individu (depuis le 15 janvier 2020) sont exclus du dénombrement hebdomadaire ultérieur (numérateur et dénominateur). La date de test représente la date de la collecte des échantillons. En raison du temps requis pour le transport et le traitement des échantillons, il faut 6 jours pour que 95 % des résultats soient finalisés et déclarés pour une date de test donnée. Les personnes dépistées comprennent celles dont le résultat est confirmé positif, négatif, indéterminé ou en attente. Pour les personnes confirmées positives à l’aide de leur dossier dans le système intégré d’information sur la santé publique (iPHIS) du ministère de la Santé de l’Ontario, leur affectation au bureau de santé publique (BSP) était fondée sur leur diagnostic du BSP. Pour tous les autres, l’affectation du BSP était basée sur le code postal dans la base de données des personnes inscrites à la date de test. La base de données des personnes inscrites (BDPI), qui contient des renseignements démographiques de base sur toute personne qui a déjà reçu un numéro de carte de santé de l’Ontario, est à jour jusqu’au 30 avril 2021.Seuls les tests pour la COVID-19 par réaction en chaîne de polymérase standard sont signalés. Les tests effectués par d’autres méthodes, comme le test rapide au point de service, sont exclus.Les taux et le pourcentage de positivité calculés à partir de dénombrements de cas très faibles, ou pour de petites populations, sont instables et doivent être interprétés avec prudence. Pour cette raison, les taux de dépistage et le pourcentage de positivité ne sont pas présentés pour les quartiers dont la population est inférieure à 2 000 personnes ou lorsque le nombre (c.-à-d. le nombre total testé ou le nombre total déclaré positif) se situe entre 1 et 6 pour un quartier donné.Les cas de COVID-19 confirmés sont ceux qui ont obtenu des résultats positifs en laboratoire selon le document du ministère de la Santé de l’Ontario portant sur la prise en charge par la santé publique des cas de maladie à COVID-19 et des contacts qui y sont associés. Le 25 mars 2020, version 6.0.La province a dû limiter les tests aux groupes prioritaires aux premiers stades de la pandémie. Puisque parmi toutes les personnes qui ont été infectées par la COVID-19, un faible pourcentage seulement a été testé, le nombre de cas confirmés dans la collectivité représente une sous-estimation du nombre réel d’infections. Les renseignements liés au taux global d’infection au Canada ne seront disponibles que lorsque des études de grande envergure auront été menées sur la présence d’anticorps dans le sérum sanguin des personnes touchées par la COVID-19. Si l’on se base sur les informations fournies, le nombre actuel d’infections pourrait être de 5 à 30 fois plus élevé que le nombre de cas signalés (1). Les tests de surveillance pour COVID-19 ont commencé dans les FSLD le 25 avril 2020.Référence : Richterich P. Severe underestimation of COVID-19 case numbers: Effect of epidemic growth rate and test restrictions. medrxiv. Avril 2020 : 2020.04.13. doi.org/10.1101/2020.04.13.20064220 Attributs:ID ÉQO – numéro d’identification du quartier de l’Étude de quartiers d’Ottawa (ÉQO).Nom ÉQO – nom du quartier de l’ÉQO.Mois – l’année et le mois des données, en fonction de la date de début des dénombrements hebdomadaires.Taux de tests (pour 1 000 habitants), à l’exclusion des résidents des FSLD – nombre de résidents d’Ottawa qui ont fait l’objet de tests pour la COVID-19 au cours du mois d’intérêt, à l’exclusion des résidents des FSLD, divisé par la population totale de ce quartier et multiplié par 1 000.Pourcentage de positivité (à l’exclusion des FSLD) – nombre de résidents d’Ottawa qui ont fait l’objet d’un test pour la COVID-19 au cours du mois d’intérêt et qui ont obtenu un résultat positif, divisé par le nombre total de résidents d’Ottawa qui ont fait l’objet d’un test durant ce mois. Le numérateur et le dénominateur excluent tous les deux les résidents des FSLD.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Imaging findings in Covid-19.
https://ottawa.ca/fr/hotel-de-ville/decouvrir-votre-ville/donnees-ouverteshttps://ottawa.ca/fr/hotel-de-ville/decouvrir-votre-ville/donnees-ouvertes
Nombre quotidien de résidents d'Ottawa testés pour la COVID-19 et pourcentage de résidents testés chez qui la COVID-19 a été confirmée en laboratoire. Les données sont extraites du Système d’information de laboratoire de l’Ontario (SILO) les lundi, mercredi et vendredi.
Exactitude: Points à considérer pour l’interprétation des données Ce ne sont pas tous les laboratoires qui font rapport au SILO et seuls les patients détenteurs d’un numéro de carte Santé sont inclus dans le fichier de données du SILO.Lorsqu’une personne est confirmée positive, ses tests subséquents sont exclus des totaux quotidiens. Les tests en double ont été exclus du nombre total de cas positifs, y compris ceux qui découlent de plusieurs tests de cure.Les résultats pour les patients qui ont placé un blocage au consentement dans le SILO (~ 50 dossiers dans l’ensemble de la province) sont exclus.Le personnel travaillant dans des foyers de soins de longue durée n’est pas pris en compte dans le SILO.La détermination de l’unité de santé publique responsable pour chaque test dans le SILO est fondée sur l’adresse identifié sur la carte Santé d’un patient. Il est possible que l’adresse associée à la carte Santé des patients résidant dans des foyers de soins de longue durée ne soit pas exacte et par conséquent, il se peut que certains des tests effectués dans les foyers n’apparaissent pas dans le SILO. Les cas confirmés de la COVID-19 sont ceux qui ont obtenu des résultats positifs en laboratoire selon le document du ministère de la Santé de l’Ontario portant sur la prise en charge par la santé publique des cas de maladie à COVID-19 et des contacts qui y sont associés, 25 mars 2020, version 6.0.Les tests de surveillance pour la COVID-19 ont commencé dans les FSLD le 25 avril 2020.La province a dû limiter les tests aux groupes prioritaires au début de la pandémie. Puisque parmi toutes les personnes qui ont été infectées par la COVID-19, un faible pourcentage seulement a été testé, le nombre de cas confirmés dans la collectivité représente une sous-estimation du nombre réel d’infections. Les renseignements liés au taux global d’infection au Canada ne seront disponibles que lorsque des études de grande envergure auront été menées sur la présence d’anticorps dans le sérum sanguin des personnes touchées par la COVID-19. Si l’on se base sur les informations fournies, le nombre actuel d’infections pourrait être de 5 à 30 fois plus élevé que le nombre de cas signalés (1). Référence : Richterich P. Severe underestimation of COVID-19 case numbers: Effect of epidemic growth rate and test restrictions. medrxiv. Avril 2020 : 2020.04.13. doi.org/10.1101/2020.04.13.20064220 Fréquence des mises à jour: Les mardis et vendredis
Attributs: Champs de données : Date - date du test (AAAA-MM-JJ).Nombre de tests – nombre de résidents d’Ottawa ayant subi un test de dépistage pour la COVID-19Pourcentage quotidien de positivité – le pourcentage de tests positifs parmi le nombre total de tests effectués à une date donnéeNombre de tests dans les foyers de soins de longue durée (FSLD)– nombre de résidents de FSLD à Ottawa ayant subi un test de dépistage pour la COVID-19Pourcentage quotidien de positivité dans les FSLD– le pourcentage de tests positifs dans les FSLD parmi le nombre total de tests effectués à une date donnée dans les FSLD Courriel de l'auteur: Équipe d’épidémiologie de SPO | Épidémiologie et données probantes, Santé publique Ottawa
Not seeing a result you expected?
Learn how you can add new datasets to our index.
https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0
Effective June 7th, 2024, this dataset will no longer be updated.This file contains data for the last 6 weeks on: Weekly counts and rates of Ottawa residents with laboratory-confirmed COVID-19 by episode date (i.e. the earliest of symptom onset, testing or reported date) and age. Weekly counts and rates of Ottawa residents with laboratory-confirmed COVID-19 by reported date. Data are from the Ontario Ministry of Health Public Health Case and Contact Management Solution (CCM).
Accuracy: Points of consideration for interpretation of the data: Data are entered into and extracted by Ottawa Public Health from the Ontario Ministry of Health Public Health Case and Contact Management Solution (CCM). The COD is a dynamic disease reporting system that allows for ongoing updates; data represent a snapshot at the time of extraction and may differ from previous or subsequent reports.As the cases are investigated and more information is available, the dates are updated. A person’s exposure may have occurred up to 14 days prior to onset of symptoms. Symptomatic cases occurring in approximately the last 14 days are likely under-reported due to the time for individuals to seek medical assessment, availability of testing, and receipt of test results.Confirmed cases are those with a confirmed COVID-19 laboratory result as per the Ministry of Health Public health management of cases and contacts of COVID-19 in Ontario. March 25, 2020 version 6.0.Counts will be subject to varying degrees of underreporting due to a variety of factors, such as disease awareness and medical care seeking behaviours, which may depend on severity of illness, clinical practice, changes in laboratory testing, and reporting behaviours.Surveillance testing for COVID-19 began in long term care facilities on April 25, 2020. Update Frequency: Tuesdays and Fridays
Attributes: Data fields: Week – Date of the first day of the episode week (i.e. the week during which the case first developed symptom, got tested or was reported to OPH – whichever was earliest). Date in format YYYY-MM-DD H:MM. Weekly Rate of COVID-19 by 20-year Age Groupings (per 100,000 pop) and Episode Date – The number of Ottawa residents with confirmed COVID-19 within an age group (e.g. 0-9 years) divided by the total Ottawa population for that age group. This fraction is then multiplied by 100,000 to get a rate of COVID-19 per 100,000 population for that age group.Weekly Total of Cases by Episode Date - number of Ottawa residents with laboratory-confirmed COVID-19 by episode date.Weekly Total of Cases by Reported Date – number of Ottawa residents with laboratory-confirmed COVID-19 by reported date.Weekly Rate of COVID-19 (per 100,000 pop) by Reported Date – number of Ottawa residents with laboratory-confirmed COVID-19 by reported date divided by the total Ottawa population and multiplied by 100,000. Contact: OPH Epidemiology Team | Epidemiology & Evidence, Ottawa Public Health