Archive of COVID-19 Data from Canadian Government Sources

The data in this archive have moved. They can be accessed at the following link: https://drive.google.com/drive/folders/10ET5FBqO-K8FBdEaXgBjBZwJskIZGKNG?usp=sharing

From now on, this archive will be used only to store and collorate on archival scripts and metadata. Links to the data have been updated. Other options to explore and download the data will be available soon.

This repository provides automated, daily backups of COVID-19 data from various Canadian government sources. Selected non-governmental sources are also included.

File name timestamps are given in ET (America/Toronto) in the following format: %Y-%m-%d_%H-%M. The script is run nightly around 23:00 ET.

All code in this repository is covered by the MIT License. Licenses and terms of use for each archived dataset are given below.

This repository is maintained by Jean-Paul R. Soucy on behalf of the COVID-19 Open Data Working Group.

Table of contents:

Contributing

Community members may contribute to this repository in three ways:

Create an issue to request a dataset be added to the archive.
Create a pull request for archiver.py adding the ability to automatically archive a requested or not-yet-implemented dataset.
Submit archived versions of an existing, requested, or not-yet-implemented dataset. If possible, please use the original file name plus timestamp in the format described above.

Recommended citation

COVID-19 Canada Open Data Working Group. Archive of COVID-19 Data from Canadian Government Sources. https://github.com/jeanpaulrsoucy/covid-19-canada-gov-data. (Access date).

Running archiver.py

archiver.py can run in four modes:

python archiver.py serverprod: Download and commit files, running on the Heroku server.
python archiver.py localprod: Download and commit files, running on a local machine.
python archiver.py servertest: Download but do not commit files, running on the Heroku server.
python archiver.py localtest: Download but do not commit files, running on a local machine.

See archiver.py for more details.

Data sources/terms of use/supplementary material

The sources and terms of use for each included dataset are linked below. Supplementary material such as data dictionaries and codebooks are also included in the list below, if available. These files are included with the relevant datasets in a directory named supplementary.

Alberta

COVID-19 Alberta statistics
- ab/cases/covid19dataexport.csv
- Terms of use: Assumed to be Open Government Licence - Alberta; see also the disclaimer in the "data notes" tab of the website
COVID-19 relaunch status map
- ab/active-cases-by-region/covid19dataexport-relaunch.csv
- Terms of use: Assumed to be Open Government Licence - Alberta
COVID-19 school status map
- ab/school-status-by-region/covid19dataexport-schools.csv
- Terms of use: Assumed to be Open Government Licence - Alberta

Edmonton

COVID-19 in Alberta: Current cases by local geographic area (Edmonton)
- ab/edmonton-cases-by-area/COVID-19_in_Alberta__Current_cases_by_local_geographic_area.csv
- Terms of use: Assumed to be City of Edmonton Open Data Terms of Use

British Columbia

BC COVID-19 Data
- Case data: bc/case-data/BCCDC_COVID19_Dashboard_Case_Details.csv
  - The format of the column "Reported_Date" is %Y-%m-%d except for 2020-08-24 to 2020-08-26 where it is %m/%d/%Y.
  - Due to Excel's aggressive date conversion, the column "Age_Group" may occasionally contain "19-Oct" rather than "10-19" (e.g., see this Twitter thread). This archive may not represent a perfect record of the appearance of "19-Oct" as some files may have been processed in Excel prior to upload, either removing or introducing the anomalous value.
  - Data parsing advice for the above issues in R:
```
library(dplyr)
dat <- read.csv("http://www.bccdc.ca/Health-Info-Site/Documents/BCCDC_COVID19_Dashboard_Case_Details.csv") %>%
  mutate(
    Reported_Date = coalesce(as.Date(Reported_Date, "%Y-%m-%d"), as.Date(Reported_Date, "%m/%d/%Y")),
    Age_Group = recode(Age_Group, "19-Oct" = "10-19")
  )
```
  - On 2020-11-16 (a Monday), BCCDC retracted their daily datasets from their website and replaced them with datasets from the previous Friday (2020-11-13). These datasets have been saved as "BCCDC_COVID19_Dashboard_Case_Details_2020-11-16_23-05.csv" and "BCCDC_COVID19_Dashboard_Lab_Information_2020-11-16_23-05", whereas the retracted datasets have been preserved as "BCCDC_COVID19_Dashboard_Case_Details_2020-11-16_19-27" and "BCCDC_COVID19_Dashboard_Lab_Information_2020-11-16_19-27".
- Laboratory data: bc/laboratory-data/BCCDC_COVID19_Dashboard_Lab_Information.csv
- Regional data: bc/regional-case-summary/BCCDC_COVID19_Regional_Summary_Data.csv
- Terms of use: Disclaimer and data notes
COVID-19 Public Exposures
- Public exposures webpage screenshot: bc/public-exposures-webpage/public-exposures-screenshot.png
- Public exposures - flights: bc/public-exposures-flights/public-exposures-flights-tables-Current.pdf
- Public exposures - cruises, long distance bus, train, work sites, public events: bc/public-exposures-cruises-bus-train-work-public/Archived_COVID-19_Exposures.pdf (Not included as part of the nightly update, as it is archived)
- Public exposures Fraser webpage: bc/regional-exposure-events-fraser-webpage/regional-exposure-events-fraser-webpage.html (warning: some early files are .png screenshots and named differently)
- Public exposures Interior webpage: bc/regional-exposure-events-interior-webpage/regional-exposure-events-interior-webpage.html (warning: some early files are .png screenshots and named differently)
- Public exposures Island webpage: bc/regional-exposure-events-island-webpage/regional-exposure-events-island-webpage.html (warning: some early files are .png screenshots and named differently)
- Public exposures Northern webpage: bc/regional-exposure-events-northern-webpage/regional-exposure-events-northern-webpage.html (warning: some early files are .png screenshots and named differently)
- Public exposures Vancouver Coastal webpage: bc/regional-exposure-events-vancouver-coastal-webpage/regional-exposure-events-vancouver-coastal-webpage.html (warning: some early files are .png screenshots or .pdf files and named differently and/or formatted differently)
- School exposures Fraser webpage: bc/school-exposures-fraser-webpage/school-exposures-fraser-webpage.html (warning: some early files are .png screenshots and named differently)
- School exposures Interior webpage: bc/school-exposures-interior-webpage/school-exposures-interior-webpage.html (warning: some early files are .png screenshots and named differently)
- School exposures Island webpage: bc/school-exposures-island-webpage/school-exposures-island-webpage.html (warning: some early files are .png screenshots and named differently)
- School exposures Northern webpage: bc/school-exposures-northern-webpage/school-exposures-northern-webpage.html (warning: some early files are .png screenshots and named differently)
- School exposures Vancouver Coastal webpage: bc/school-exposures-vancouver-coastal-webpage/school-exposures-vancouver-coastal-webpage.html (warning: some early files are .png screenshots and named differently)
- Vancouver Coastal reported its first school outbreak on 2020-09-22. However, due to a change in the page format, the first day these data were captured in the dataset was 2020-10-05. Screenshots prior to this date ommit the list of schools. However, it is unlikely that any schools were removed from the list prior to it first being captured on 2020-10-05.
- Terms of use: TBD

Toronto

City of Toronto Daily Status of COVID-19 Cases
- on/toronto-daily-status/CityofToronto_COVID-19_Daily_Public_Reporting.xlsx
- Include supplementary material: Technical notes
- Terms of use: Assumed to be Open Government Licence – Toronto
City of Toronto COVID-19 Summary
- on/toronto-covid-summary/CityofToronto_COVID-19_Data.xlsx
- Include supplementary material: Technical notes
- Terms of use: Assumed to be Open Government Licence – Toronto
City of Toronto COVID-19 Neighbourhood Case Data
- on/toronto-neighbourhood-data/CityofToronto_COVID-19_NeighbourhoodData.xlsx
- Include supplementary material: Technical notes
- Terms of use: Assumed to be Open Government Licence – Toronto
City of Toronto COVID-19 Neighbourhood Testing Data
- on/toronto-neighbourhood-test-data/CityofToronto_COVID-19_Testing.xlsx
- Include supplementary material: Technical notes
- Terms of use: Assumed to be Open Government Licence – Toronto
City of Toronto COVID-19 Monitoring Dashboard
- on/toronto-monitoring-dashboard/CityofToronto_COVID-19_RecoveryData.xlsx
- Include supplementary material: Technical notes
- Terms of use: Assumed to be Open Government Licence – Toronto
City of Toronto Ethno-Racial Group, Income, & Infection
- on/toronto-ethno-racial-income/Ethno-Racial_Group,_Income,_and_COVID-19_Infection.xlsx (original file name is Ethno-Racial Group, Income, and COVID-19 Infection.xlsx, renamed to avoid spaces in file name)
- Include supplementary material: Technical notes
- Terms of use: Assumed to be Open Government Licence – Toronto
- Not included as part of the nightly update, as it does not seem to be receiving regular updates (data as of September 30, 2020)
COVID-19 Cases in Toronto
- on/toronto-cases/COVID19_cases.csv
- Data are extracted at 3 PM on the Monday of a given week and posted by Wednesday [dataset is updated only on Wednesdays]
- Terms of use: Assumed to be Open Government Licence – Toronto
University of Toronto COVID-19 tracking
- on/u-of-t-covid-tracking-webpage/u-of-t-covid-tracking-webpage.html (warning: some early files are .png screenshots and named differently)
- Data are reported every Monday with cumulative cases through the previous Friday [screenshots will be take every day in case the update frequency increases]
- Terms of use: TBD

Ottawa

Daily COVID-19 Dashboard (Ottawa)
- Demographics and Source of Infection for Cases, Deaths, and Hospitalizations: on/ottawa-cases-deaths-hosp-demographics-source-of-infection/COVID-19_Cases_and_Deaths_Ottawa_EN.csv
- Outbreaks in Healthcare Institutions, Childcare, Summer Camps, and Educational Establishments: on/ottawa-outbreaks-healthcare-childcare-camps-schools/COVID-19_Institutional_Outbreaks.csv
- Community Outbreaks: on/ottawa-community-outbreaks/COVID-19_Community_Outbreaks_in_Ottawa.csv
- Weekly Rates: on/ottawa-weekly-rates/COVID-19_Weekly_Cases_and_Rates_by_Age_in_Ottawa_EN.csv
- Estimated Reproduction Number in Ottawa: on/ottawa-estimated-rt/EN_-_Covid-19_Reproduction_Number,_R(t).csv
- Testing - Ottawa Residents: on/ottawa-residents-tested/COVID-19_Ottawa_Residents_Tested_EN.csv
- Ottawa cases and deaths: on/ottawa-cases-and-deaths/COVID-19_Cases_and_Deaths_in_Ottawa_EN.csv (Archived as of 2020-09-21, no longer part of the nightly update)
- Ottawa outbreaks in healthcare institutions: on/ottawa-outbreaks-in-healthcare-institutions/COVID-19_Outbreaks_in_Ottawa_Healthcare_Institutions_EN.csv (Archived as of 2020-09-21, no longer part of the nightly update)
- Ottawa hospitalization data: on/ottawa-hospitalization/Hospitalizations_of_Ottawa_residents_with_confirmed_COVID-19.csv (Archived as of 2020-09-21, no longer part of the nightly update)
- Include supplementary material: User guide, technical guide, overall status assessment
- Terms of use: Open Government Licence – City of Ottawa

Quebec

When both French and English data files are available, French files should be considered definitive (and in many cases, these files have been captured in the archive for a longer duration). The English versions of files avaiable in both languages will always have their directories marked with "-en" at the end.

Data on COVID-19 in Québec (province)
- Webpage EN: qc/qc-webpage-en/qc-webpage-en.html
- Webpage FR: qc/qc-webpage-fr/qc-webpage-fr.html
- Situation in Quebec: qc/situation-in-quebec/situation-au-quebec.csv
- Correctional facilities - cases among employees (FR): qc/correctional-cases-employees/donnees_covid_detention_employes_FR.csv
- Correctional facilities - cases among employees (EN): qc/correctional-cases-employees-en/donnees_covid_detention_employes_EN.csv
- Correctional facilities - cases among detainees (FR): qc/correctional-cases-detainees/
- Correctional facilities - cases among detainees (EN): qc/correctional-cases-detainees/donnees_covid_detention_personnes_incarcerees_EN.csv
- Vaccine doses administered by RSS (FR): qc/vaccine-doses-admin-by-rss/doses-vaccins.csv
- Vaccine doses administered by RSS (EN): qc/vaccine-doses-admin-by-rss-en/doses-vaccins-en.csv
- Outbreaks by setting (FR): qc/outbreaks-by-setting/eclosions-par-milieu.csv
- Outbreaks by setting (EN): qc/outbreaks-by-setting-en/eclosions-par-milieu-en.csv
- Cases percentage by age group (FR): qc/cases-percentage-by-age-group/pourcentage-cas-age.csv
- Cases percentage by age group (EN): qc/cases-percentage-by-age-group-en/pourcentage-cas-age-en.csv
- Deaths percentage by age group (FR): qc/deaths-percentage-by-age-group/pourcentage-deces-age.csv
- Deaths percentage by age group (EN): qc/deaths-percentage-by-age-group-en/pourcentage-deces-age-en.csv
- Cumulative deaths by region (FR): qc/cumulative-deaths-by-region/deces-region.csv
- Cumulative deaths by region (EN): qc/cumulative-deaths-by-region-en/deces-region-en.csv
- Recent daily cases by region (FR): qc/recent-daily-cases-by-region/cas-region.csv
- Recent daily cases by region (EN): qc/recent-daily-cases-by-region-en/cas-region-en.csv
- COVID-19 daily data 7 days (FR): qc/covid-data-daily-7-days/synthese-7jours.csv (Renamed to synthese-7joursV2.csv from synthese-7jours.csv after 2020-11-09; later renamed again to synthese-7jours.csv - a substantial number of files from November and December are missing due to this change)
- COVID-19 daily data 7 days (EN): qc/covid-data-daily-7-days-en/synthese-7jours-en.csv
- Cases by region 7 days (FR): qc/cases-by-region-7-days/cas-region-7jours.csv
- Cases by region 7 days (EN): qc/cases-by-region-7-days-en/cas-region-7jours-en.csv
Données COVID-19 au Québec (INSPQ)
- COVID-19 time series by region and demographics: qc/covid-time-series-by-region-and-demographics/covid19-hist.csv
- COVID-19 data (charts - summary, time series, and hospitalization by age): qc/covid-data-charts-summary-time-series-hosp-by-age/manual-data.csv
- Summary by region: qc/summary-by-region/regions.csv
- Deaths by RSS (health region) and living environment: qc/deaths-by-rss-and-living-environment/tableau-rpa-new.csv (Renamed from tableau-rpa.csv after 2020-09-16)
- Cases by RSS (health region) and RLS (local service network): qc/cases-by-rss-and-rls/tableau-rls-new.csv (Renamed from tableau-rls.csv after 2020-09-16)
- Comparisons (provinces): qc/comparisons-provinces/comparaisons_prov.csv
- Comparisons (countries): qc/comparisons-countries/comparaisons_pays.csv
- COVID-19 time series by region: qc/covid-time-series-by-region/PL_DATE.csv (Archived as of 2020-10-15, no longer part of the nightly update)
  - Advice for data process by Simon Coulombe
- COVID-19 data: qc/covid-data/combine.csv (Archived as of 2020-09-16, no longer part of the nightly update)
- COVID-19 data (charts): qc/covid-data-charts/combine2.csv (Archived as of 2020-09-16, no longer part of the nightly update)
- Terms of use: TBD
Données COVID-19 par âge et sexe au Québec
- COVID-19 data by age group and sex: qc/covid-data-by-age-and-sex/PL_AGE_SEXE.csv
- Terms of use: TBD
Données sur la COVID-19 au Québec
- Deaths time series by living environment: qc/deaths-time-series-by-living-environment/decesquotidien.csv
- Terms of use: TBD
Situation dans les milieux de vie pour personnes aînées et vulnérables
- Status report on confirmed cases and deaths by RPA (private residences for seniors): qc/status-report-cases-and-deaths-by-rpa/etat_situation_rpa.pdf
- Status report on confirmed cases and deaths by CHSLD (residential and long-term care centres): qc/status-report-cases-and-deaths-by-chsld/etat_situation_chsld.pdf
- Supplementary material: Canadian Armed Forces report on their presence in CHSLDs
- Terms of use: TBD
Situation dans les établissements scolaires
- Highlights - public and private school system: qc/schools-highlights/reseauScolaire_faitsSaillants.pdf
- List of schools - public and private school system: qc/schools-list-of-schools/reseauScolaire_listeEcoles.pdf
- Formerly Situation dans les établissements scolaires relative à la COVID-19: qc/schools-list-of-schools/etat_situation_ecole_2020-09-04_2020-09-06/etat_situation_ecole.pdf
- Formerly Liste des écoles ayant au moins un cas rapporté de la COVID-19 depuis le 1er septembre 2020: qc/schools-list-of-schools/liste-ecole-cas-rapportes_2020-09-08_2020-09-09/liste-ecole-cas-rapportes.pdf
- Terms of use: TBD

Montreal

Situation du coronavirus (COVID-19) à Montréal
- Note that these files are actually semicolon-separated since they use a comma as the decimal marker (rather than a period) and are encoded as ISO 8859-15 (rather than UTF-8)
- Montréal cases and deaths by CIUSSS (integrated health and social services centres): qc/montreal-cases-and-deaths-by-ciusss/ciusss.csv
- Montréal cases by area: qc/montreal-cases-by-area/municipal.csv
- Montréal cases and deaths by age group: qc/montreal-cases-and-deaths-by-age-group/grage.csv
- Montréal cases and deaths by sex: qc/montreal-cases-and-deaths-by-sex/sexe.csv
- Montréal epidemic curve: qc/montreal-epidemic-curve/courbe.csv
- Terms of use: TBD

Saskatchewan

Saskatchewan's Dashboard - Total Cases
- CSV: sk/cases-by-region/cases.csv
- Webpage: sk/cases-by-region-webpage/cases-webpage.html (warning: some early files are .png screenshots and named differently)
- Terms of use: TBD
Saskatchewan's Dashboard - Total Tests
- CSV: sk/tests-by-region/tests.csv
- Webpage: sk/tests-by-region-webpage/tests-webpage.html (warning: some early files are .png screenshots and named differently)
- Terms of use: TBD

Yukon

Case counts: COVID-19
- Webpage: yt/yukon-case-counts-webpage/yukon-case-counts-webpage.html
- Terms of use: TBD
Current COVID-19 situation
- Webpage: yt/yukon-current-situation-webpage/yukon-current-situation-webpage.html
- Terms of use: TBD

Other: Non-governmental sources

Canada

Canada COVID-19 School Case Tracker
- other/can/canada-covid-19-school-case-tracker/Canada_COVID-19_School_Report_Tracker.kml (original file name is Canada COVID-19 School Report Tracker.kml, renamed to avoid spaces in file name; warning: some early files are in .kmz format, which is compressed but handled almost identically to .kml)
- Terms of use: TBD
Unofficial COVID Alert Dashboard
- Estimated infections per day: other/can/unofficial-covid-alert-dashboard/estimated_infections_per_day.txt (Replaced after 2020-11-14 by unofficial-covid-alert-dashboard-analysis, no longer part of the nightly update)
- Diagnosis key analysis: other/can/unofficial-covid-alert-dashboard-analysis/DiagnosisKeysAnalysis.csv
- Upload delay: other/can/unofficial-covid-alert-dashboard-upload-delay/UploadDelay.csv
- Terms of use: TBD

Quebec

Covid Écoles Québec: Number of schools
- Excel spreadsheet: other/qc/covid-ecoles-quebec-school-list/COVIDECOLESQUEBEC.xlsx (original file name is COVIDECOLESQUEBEC_20200905.xlsx, renamed to avoid confusion)
- Terms of use: TBD

COVID-19 Canada Open Data Working Group

Data from the COVID-19 Canada Open Data Working Group is being added on an experimental basis. The full catalogue of historical data will be available in the future.

Data notes

On several occasions, the nightly archival script has failed to run. Depending on when the failure was identified, this may have resulted in a partial or total loss of archival data for that day. A list of these days is provided below:

Wednesday, October 21, 2020
Thursday, November 19, 2020

In the future, a package will be provided to more easily access the data provided in this archive and to document missing or incomplete data.

Acknowledgements

Many people are to thank for contributing archived data and code to this repository.

Name		Name	Last commit message	Last commit date
Latest commit History 175 Commits
data		data
.gitignore		.gitignore
.slugignore		.slugignore
LICENSE		LICENSE
README.md		README.md
archiver.py		archiver.py
archivist.py		archivist.py
indexer.py		indexer.py
requirements.txt		requirements.txt

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

Archive of COVID-19 Data from Canadian Government Sources

The data in this archive have moved. They can be accessed at the following link: https://drive.google.com/drive/folders/10ET5FBqO-K8FBdEaXgBjBZwJskIZGKNG?usp=sharing

From now on, this archive will be used only to store and collorate on archival scripts and metadata. Links to the data have been updated. Other options to explore and download the data will be available soon.

Contributing

Recommended citation

Running archiver.py

Data sources/terms of use/supplementary material

Alberta

Edmonton

British Columbia

Canada

Manitoba

Winnipeg

Northwest Territories

Nova Scotia

Nunavut

Ontario

Toronto

Ottawa

Quebec

Montreal

Saskatchewan

Yukon

Other: Non-governmental sources

Canada

Quebec

COVID-19 Canada Open Data Working Group

Data notes

Acknowledgements

About

Releases

Packages

Languages

License

luoluogogogo/covid-19-canada-gov-data

Folders and files

Latest commit

History

Repository files navigation

Archive of COVID-19 Data from Canadian Government Sources

The data in this archive have moved. They can be accessed at the following link: https://drive.google.com/drive/folders/10ET5FBqO-K8FBdEaXgBjBZwJskIZGKNG?usp=sharing

From now on, this archive will be used only to store and collorate on archival scripts and metadata. Links to the data have been updated. Other options to explore and download the data will be available soon.

Contributing

Recommended citation

Running archiver.py

Data sources/terms of use/supplementary material

Alberta

Edmonton

British Columbia

Canada

Manitoba

Winnipeg

Northwest Territories

Nova Scotia

Nunavut

Ontario

Toronto

Ottawa

Quebec

Montreal

Saskatchewan

Yukon

Other: Non-governmental sources

Canada

Quebec

COVID-19 Canada Open Data Working Group

Data notes

Acknowledgements

About

Resources

License

Stars

Watchers

Forks

Releases

Packages 0

Languages

Packages