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
Jeux de données disponibles au téléchargement
-
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
Informations supplémentaires
| Champ | Valeur |
|---|---|
| Dernière mise à jour | mars 24, 2026, 20:40 (TU) |
| Créé | mars 24, 2026, 20:40 (TU) |
|
Domaine / Sujet
Domaine ou sujet du jeu de données catalogué.
|
|
|
Titre
Titre du jeu de données.
|
COVID-19 Cases and Deaths Ottawa (Historical data) |
|
Description
Une description du jeu de données.
|
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
|
|
Étiquettes / Mots-clés
Mots-clés/étiquettes catégorisant le jeu de données.
|
|
|
Format (CSV, XLS, TXT, PDF, etc.)
Format de fichier du jeu de données.
|
|
|
Taille du jeu de données
Taille du jeu de données en mégaoctets.
|
680.0 |
|
Identifiant des métadonnées
Identifiant des métadonnées — peut être utilisé comme identifiant unique pour l’entrée du catalogue.
|
|
|
Date de publication
Date de publication du jeu de données.
|
2022-07-07 |
|
Période temporelle des données (date de début)
Date de début des données dans le jeu de données.
|
|
|
Période temporelle des données (date de fin)
Date de fin des données temporelles du jeu de données.
|
|
|
Zone géospatiale couverte
Région spatiale ou lieu nommé couvert par le jeu de données.
|
| Champ | Valeur |
|---|---|
|
Catégorie d’accès
Type d’accès accordé pour le jeu de données (ouvert, restreint, service, etc.).
|
public (affichage de la valeur pour English) |
|
Licence
Licence utilisée pour accéder au jeu de données.
|
https://ottawa.ca/en/city-hall/get-know-your-city/open-data#open-data-licence-version-2-0 |
|
Restrictions d’utilisation
Restrictions d’utilisation des données.
|
|
|
Emplacement
Emplacement du jeu de données.
|
https://od-dev2-ottawa.opendata.arcgis.com/datasets/ottawa::covid-19-cases-and-deaths-ottawa-historical-data (affichage de la valeur pour English) |
|
Service de données
Service de données pour accéder à un jeu de données.
|
|
|
Propriétaire
Propriétaire du jeu de données.
|
[email protected] (affichage de la valeur pour English) |
|
Point de contact
Qui contacter concernant l’accès ?
|
City of Ottawa (affichage de la valeur pour English) |
|
Courriel du point de contact
Courriel à utiliser pour l’accès ?
|
[email protected] (affichage de la valeur pour English) |
|
Éditeur
Éditeur du jeu de données.
|
City of Ottawa (affichage de la valeur pour English) |
|
Courriel de l’éditeur
Adresse courriel de l’éditeur.
|
|
|
Auteur
Auteur du jeu de données.
|
[email protected] |
|
Courriel de l'auteur
Adresse courriel de l’auteur.
|
|
|
Date d’accès
Date à laquelle les données et métadonnées ont été consultées.
|
2024-09-12 |
| Champ | Valeur |
|---|---|
|
Identifiant
Identifiant unique du jeu de données.
|
81a6b8a6d2824ebd8cfddd933ab043c4 (affichage de la valeur pour English) |
|
Langue
Langue(s) du jeu de données
|
English |
|
Lien vers la description du jeu de données
Une URL vers un document externe décrivant le jeu de données.
|
https://od-dev2-ottawa.opendata.arcgis.com/datasets/ottawa::covid-19-cases-and-deaths-ottawa-historical-data (affichage de la valeur pour English) |
|
Identifiant persistant
Les données sont identifiées par un identifiant persistant.
|
|
|
Identifiant globalement unique
Les données sont identifiées par un identifiant persistant et globalement unique.
|
|
|
Contient des données sur des individus
Le jeu de données contient-il des données sur des individus ?
|
|
|
Contient des données identifiables sur des individus
Le jeu de données contient-il des données identifiables sur des individus ?
|
|
|
Contient des données autochtones
Le jeu de données contient-il des données sur des communautés autochtones ?
|
|
|
Type de portail
Type de plateforme du portail source.
|
| Champ | Valeur |
|---|---|
|
Version
Version du jeu de données
|
None |
|
Source
Source du jeu de données.
|
None |
|
Notes de version
Notes de version à propos du jeu de données.
|
|
|
Est une version d’un autre jeu de données
Lien vers le jeu de données dont celui-ci est une version.
|
|
|
Autres versions
Lien vers les jeux de données qui en sont des versions.
|
|
|
Texte de provenance
Texte de provenance des données.
|
City of Ottawa (affichage de la valeur pour English) |
|
URL de provenance
URL de provenance des données.
|
|
|
Résolution temporelle
Décrit la granularité des données temporelles dans le jeu de données.
|
|
|
Résolution géospatiale en mètres
Décrit la granularité (en mètres) des données géospatiales dans le jeu de données.
|
|
|
Résolution géospatiale (par régions)
Décrit la granularité (par régions) des données géospatiales dans le jeu de données.
|
| Champ | Valeur |
|---|---|
|
Permission de la communauté autochtone
Qui détient la permission de la communauté autochtone. Qui contacter pour l’accès à un jeu de données concernant des communautés autochtones.
|
|
|
Permission communautaire
Permission communautaire (qui a accordé la permission).
|
|
|
Les communautés autochtones concernées par le jeu de données
Communautés autochtones dont sont issues les données.
|
| Champ | Valeur |
|---|---|
|
Nombre de lignes de données
Pour un jeu de données tabulaire, nombre total de lignes.
|
1578 |
|
Nombre de colonnes de données
Pour un jeu de données tabulaire, nombre total de colonnes uniques.
|
66 |
|
Nombre de cellules de données
Pour un jeu de données tabulaire, nombre total de cellules contenant des données.
|
104148 |
|
Nombre de relations de données
Pour un jeu de données RDF, nombre total de triplets.
|
|
|
Nombre d’entités
Pour un jeu de données RDF, nombre total d’entités.
|
|
|
Nombre de propriétés de données
Pour un jeu de données RDF, nombre total de propriétés uniques utilisées par les triplets.
|
|
|
Qualité des données
Décrit la qualité des données du jeu de données.
|
|
|
Métrique de qualité des données
Une métrique utilisée pour mesurer la qualité des données, telle que les valeurs manquantes ou les formats invalides.
|
0 Commentaires