The Manitoba Population Research Data Repository currently holds two COVID-19 specific datasets available for research. In addition, some of our regular Repository data is being updated on a monthly basis. This includes all relevant data, not just cases related to COVID-19. See Repository Data Being Updated Monthly for more information on these datasets.
The following tables describe the content and frequency of updates to the COVID-19 data, the variables available from the data, and the date range of data contained in the files.
There are two specific COVID-19 Repository datasets available for research:
The Lab Testing and Results data includes test information and results, acquisition information and patient date of birth, postal code and group membership (e.g. health care worker, general public). These data are updated monthly.
PLEASE NOTE: The table content in the November 25, 2020 COVID-19 Lab Testing and Results Data acquisition has undergone significant changes since the last acquisition. Additional fields were added to the database, four fields were renamed, and one field - Group - was eliminated, with similar information added in three new fields. These changes are identified by asterisks in the Lab Testing and Results Data Field Information table below.
Dataset Name | COVID-19_Lab_Test_Result |
Source | Manitoba Health Seniors and Active Living (MHSAL) |
Summary Description | Provincial COVID-19 lab test results |
Data Level | Individual |
Time Period | February 14, 2020 - November 30, 2020 |
Number of records | 368,589 |
Number of fields | 36 |
Field Descriptions | See Data Field Information table below |
Update Frequency | Monthly (unstructured dates/times) |
Update Mechanism | Internal extract, transformation, loading (ETL) process. New data set contains both previous and new records |
Last Updated | December 4, 2020 |
Field | Description | Format/Type |
Client ID ** | Scrambled Manitoba Health Personal Health ID Number (** renamed from Patient ID) | ID |
Age | Age in years at the time of lab test collection date of individual tested | Num |
Lab Turnaround Time - Collection ** | Lab test turnaround time from collection in hours (** renamed from Lab Time) | Num |
Lab Turnaround Time - Receipt * | Lab test turnaround time from receipt in hours (* new field) | Num |
Result Turnaround Time - Disclosed * | Result turnaround time to disclosed in hours (* new field) | Num |
Essential Worker *** | Is Patient an Essential Worker - Yes (1) or No (0) (*** new field replacing Group) | Num |
First Responder *** | Is Patient a First Responder - Yes (1) or No (0) (*** new field replacing Group) | Num |
Healthcare Worker *** | Is Patient a Healthcare Worker - Yes (1) or No (0) (*** new field replacing Group) | Num |
Client Requested Copy * | Client Requested Copy of Test Result - Y or N (* new field) | Char |
Collection Site Group * | Collection Site Group (e.g. Health Sciences Centre) (* new field) | Char |
Collection Site Name * | Name of Collection Site (e.g. COVID-19 Main St. Drive-Through) (* new field) | Char |
Collection Site RHA * | RHA where Collection Site is located (e.g. Winnipeg RHA) (* new field) | Char |
Collection Site Type * | Type of Collection Site (e.g. Community Site) (* new field) | Char |
File PHIN Type | MCHP process to determine Patient ID | Char |
Jurisdiction | Jurisdiction | Char |
Lab Group * | Lab Group (e.g. Cadham Provincial Lab) (*new field) | Char |
Lab Name | Name of the lab that performed the test | Char |
Lab Previous Resut * | Result of previous lab test (e.g. Not Detected; Detected) (* new field) | Char |
Lab Previous Test Name * | Test name of previous lab test (* new field) | Char |
Lab Reasons * | Reason for lab test (e.g. Diagnostic) (* new field) | Char |
Lab Result | Result of lab test (e.g. Not Detected; Detected) | Char |
Lab Source * | Lab Source (e.g. Lab Results) (* new field) | Char |
Lab Status * | Lab Status (e.g. Result Completed) (* new field) | Char |
Lab Test Name ** | Name of the current lab test (see list of Lab Test Names below) (** renamed from Lab Test) | Char |
Postal Code | 6-digit Postal code of individual tested | Char |
Province | Province | Char |
Regional Health Authority | Regional Health Authority of Client | Char |
MCHP Acquisition Date | Date MCHP acquired record from Manitoba Health | Date |
Date of birth | Date of birth of individual tested | Date |
Call Centre Disclosed Date * | Date Call Centre disclosed result (* new field) | Datetime |
Client Disclosed Date * | Date Client notified of result (* new field) | Datetime |
Lab Collection Date ** | Date the lab specimen was collected (** renamed from Collection Date) | Datetime |
Lab Previous Result Date * | Date of previous lab result (* new field) | Datetime |
Lab Receipt Date | Date the specimen was received in the performing lab | Datetime |
Lab Result Date | Date the lab test result was recorded | Datetime |
Online Disclosed Date * | Date result disclosed / reported online (* new field) | Datetime |
The following list of COVID-19-related lab test names can be found in the Lab Test variable of the COVID-19 Lab Testing and Results data:
Surveillance data includes two separate tables containing Case and Contact Investigation information. This includes infection and acquisition classifications, symptoms, risk factors, exposure, interventions and transmission assessments. The data only relates to lab confirmed and probable COVID-19 cases. The Surveillance data will be updated monthly.
The data is collected from two COVID-19 Surveillance (Case Investigation and Contact Investigation) forms, available on the Manitoba Health Seniors and Active Living (MHSAL) website at: https://www.gov.mb.ca/health/publichealth/surveillance/forms.html
Dataset Name | MHPHIMS_SURV_CASES |
Source | Manitoba Health Seniors and Active Living (MHSAL) |
Summary Description | Case Surveillance data for lab confirmed and probable COVID-19 cases |
Data Level | Individual |
Time Period | March 13, 2020 - November 29, 2020 |
Number of records | 16,825 |
Number of fields | 46 |
Field Descriptions | See Data Field Information table below |
Update Frequency | Monthly (unstructured dates/times) |
Update Mechanism | Internal extract, transformation, loading (ETL) process. New data set contains both previous and new records |
Last Updated | November 30, 2020 |
Dataset Name | MHPHIMS_SURV_CONTACTS |
Source | Manitoba Health Seniors and Active Living (MHSAL) |
Summary Description | Contacts Surveillance data for cases of lab confirmed and probable COVID-19 cases |
Data Level | Individual |
Time Period | March 13, 2020 - November 29, 2020 |
Number of records | 81,063 |
Number of fields | 23 |
Field Descriptions | See Data Field Information table below |
Update Frequency | Monthly (unstructured dates/times) |
Update Mechanism | Internal extract, transformation, loading (ETL) process. New data set contains both previous and new records |
Last Updated | November 30, 2020 |
NOTE: If you are planning on using Ethnicity or First Nations data in your research, additional approvals/permissions are required.
Some of our regular Repository data is being updated on a monthly basis. This includes all relevant data, not just cases related to COVID-19. These datasets include:
Some of our regular Repository data is not being updated monthly and is not available for current COVID-19 research purposes. This includes:
For more information about the data available in the Manitoba Population Research Data Repository, see: Repository Data List.