COVID-19 Cases and Deaths Ottawa (Historical data)
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.
Effective June 7th, 2024, this dataset will no longer be updated.
This file contains data on:
1. 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.
2. Cumulative count of Ottawa residents with laboratory-confirmed COVID-19 who
died by date of death.
3. Daily count of Ottawa residents with laboratory-confirmed COVID-19 by reported
date and episode date.
4. Daily count of Ottawa residents with laboratory-confirmed COVID-19 by
outbreak association and episode date.
5. 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).
6. Cumulative rate of confirmed COVID-19 for Ottawa residents by age group and
episode date.
7. Cumulative rate of confirmed COVID-19 for Ottawa residents by gender and
episode date.
8. 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:<o:p></o:p>
- 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 Ontario, are not part of an institutional or community 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 Missing by Episode Date - Ottawa residents with confirmed COVID-19 that did not complete an assessment for source of infection.
- Sum of Non-Institutional Source of Infection Over the Last 14 Days - Ottawa residents with confirmed COVID-19, within a 14 day window preceding and including the day of interest, whose source of infection was not an institutional outbreak. Thus, the calculation excludes residents of institutions but includes any health care worker who was the first case at an institution (and therefore probably not exposed in the institutional setting).
- % no known epidemiological link by episode date – 14 day average: percentage of all cases that have no know epidemiological link. Calculated over a 14 day period (i.e. the day of interest and the preceding 13 days). The numerator is the number of Ottawa residents with confirmed COVID-19 that have no known epidemiological link and the denominator is the total number of Ottawa residents with confirmed COVID-19 (including those with missing source of infection information).
Contact: OPH Epidemiology Team | Epidemiology & Evidence,
Ottawa Public Health
Datasets available for download
-
COVID_19_Cases_and_Deaths_OttawaTable
Layer 0 via ArcGIS REST API
-
COVID_19_Cases_and_Deaths_Ottawa (Explore)HTML
Explore COVID_19_Cases_and_Deaths_Ottawa on ArcGIS Hub
Additional Info
| Field | Value |
|---|---|
| Last Updated | March 24, 2026, 20:40 (UTC) |
| Created | March 24, 2026, 20:40 (UTC) |
|
Domain / Topic
Domain or topic of the dataset being cataloged.
|
|
|
Title
Title for the Dataset.
|
COVID-19 Cases and Deaths Ottawa (Historical data) |
|
Description
A description of the dataset.
|
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. Effective June 7th, 2024, this dataset will no longer be updated. This file contains data on:
- 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
|
|
Tags / Keywords
Keywords/tags categorizing the dataset.
|
|
|
Format (CSV, XLS, TXT, PDF, etc)
File format of the dataset.
|
|
|
Dataset Size
Dataset size in megabytes.
|
680.0 |
|
Metadata Identifier
Metadata identifier – can be used as the unique identifier for catalogue entry
|
|
|
Published Date
Published date of the dataset.
|
2022-07-07 |
|
Time Period Data Span (start date)
Start date of the data in the dataset.
|
|
|
Time Period Data Span (end date)
End date of time data in the dataset.
|
|
|
GeoSpatial Area Data Span
A spatial region or named place the dataset covers.
|
| Field | Value |
|---|---|
|
Access category
Type of access granted for the dataset (open, closed, service, etc).
|
public |
|
License
License used to access the dataset.
|
https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0 |
|
Limits on use
Limits on use of data.
|
|
|
Location
Location of the dataset.
|
https://od-dev2-ottawa.opendata.arcgis.com/datasets/ottawa::covid-19-cases-and-deaths-ottawa-historical-data |
|
Data Service
Data service for accessing a dataset.
|
|
|
Owner
Owner of the dataset.
|
[email protected] |
|
Contact Point
Who to contact regarding access?
|
City of Ottawa |
|
Contact Point Email
The email to contact regarding access?
|
[email protected] |
|
Publisher
Publisher of the dataset.
|
City of Ottawa |
|
Publisher Email
Email of the publisher.
|
|
|
Author
Author of the dataset.
|
[email protected] |
|
Author Email
Email of the author.
|
|
|
Accessed At
Date the data and metadata was accessed.
|
2024-09-12 |
| Field | Value |
|---|---|
|
Identifier
Unique identifier for the dataset.
|
81a6b8a6d2824ebd8cfddd933ab043c4 |
|
Language
Language(s) of the dataset
|
English |
|
Link to dataset description
A URL to an external document describing the dataset.
|
https://od-dev2-ottawa.opendata.arcgis.com/datasets/ottawa::covid-19-cases-and-deaths-ottawa-historical-data |
|
Persistent Identifier
Data is identified by a persistent identifier.
|
|
|
Globally Unique Identifier
Data is identified by a persistent and globally unique identifier.
|
|
|
Contains data about individuals
Does the data hold data about individuals?
|
|
|
Contains data about identifiable individuals
Does the data hold identifiable data about individual?
|
|
|
Contains Indigenous Data
Does the data hold data about Indigenous communities?
|
|
|
Portal Type
Platform type of the source portal.
|
| Field | Value |
|---|---|
|
Version
Version of the datatset
|
None |
|
Source
Source of the dataset.
|
None |
|
Version notes
Version notes about the dataset.
|
|
|
Is version of another dataset
Link to dataset that it is a version of.
|
|
|
Other versions
Link to datasets that are versions of it.
|
|
|
Provenance Text
Provenance Text of the data.
|
City of Ottawa |
|
Provenance URL
Provenance URL of the data.
|
|
|
Temporal resolution
Describes how granular the date/time data in the dataset is.
|
|
|
GeoSpatial resolution in meters
Describes how granular (in meters) geospatial data is in the dataset.
|
|
|
GeoSpatial resolution (in regions)
Describes how granular (in regions) geospatial data is in the dataset.
|
| Field | Value |
|---|---|
|
Indigenous Community Permission
Who holds the Indigenous Community Permission. Who to contact regarding access to a dataset that has data about Indigenous communities.
|
|
|
Community Permission
Community permission (who gave permission).
|
|
|
The Indigenous communities the dataset is about
Indigenous communities from which data is derived.
|
| Field | Value |
|---|---|
|
Number of data rows
If tabular dataset, total number of rows.
|
1578 |
|
Number of data columns
If tabular dataset, total number of unique columns.
|
66 |
|
Number of data cells
If tabular dataset, total number of cells with data.
|
104148 |
|
Number of data relations
If RDF dataset, total number of triples.
|
|
|
Number of entities
If RDF dataset, total number of entities.
|
|
|
Number of data properties
If RDF dataset, total number of unique properties used by the triples.
|
|
|
Data quality
Describes the quality of the data in the dataset.
|
|
|
Metric for data quality
A metric used to measure the quality of the data, such as missing values or invalid formats.
|
0 Comments