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:

1. COVID-19 Lab Testing and Results Data
2. COVID-19 Surveillance Data - Cases and Contacts

1 - COVID-19 Lab Testing and Results Data

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.

COVID-19 Lab Testing and Results Dataset Information
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

COVID-19 Lab Testing and Results Dataset - Data Field Information
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

Lab Test Names

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:

• 2019 Coronavirus (COVID-19) Reverse-Transcriptase PCR
• 2019 Novel (2019-n CoV) Coronavirus RNA (NAAT)
• 2019 Novel Coronavirus (2019-nCoV) RNA; NAAT
• 2019 Novel Coronavirus (2019-nCoV) RNA; NAATL
• 2019 Novel coronavirus E gene
• 2019 Novel coronavirus RNA panel
• COVID-1
• COVID-19 PCR
• COVID-19 Virus RNA (NAAT)
• COVID-19 virus PCR interpretation
• E GENE
• EGENEE GENE
• OVERALOVERALL
• SMUDLSmudge/Degenerated Cells
• XMB880-8COVID-19 Virus RNA (NAAT)

2 - COVID-19 Surveillance Data - Cases and Contacts

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

COVID-19 Surveillance - Cases

COVID-19 Surveillance Cases Dataset Information
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

COVID-19 Surveillance Cases Dataset - Data Field Information
Field	Description	Format/Type
Client ID	MCHP Scrambled Personal Health ID Number (PHIN)	ID
PHIMS Client ID	Scrambled PHIMS Client ID Number (for linking to Contacts dataset)	ID
PHIMS Investigation ID	Scrambled PHIMS Investigation ID Number (for linking to Contacts dataset)	ID
Currently Hospitalized	Current Hospitalization Flag (as of date of extract)	Num
ICU Ever	ICU Admission Flag (=1 if client currently or previously admitted to ICU)	Num
ICU LOS	Total ICU Length of Stay in Days (since COVID-19 diagnosis)	Num
Non-ICU LOS	Total Non-ICU Hospital Length of Stay in Days (since COVID-19 diagnosis)	Num
Total LOS	Total Hospital Length of Stay in Days (since COVID-19 diagnosis)	Num
Case Classification	Classification of Case Status (e.g. Lab Confirmed, Probable)	Char
Current Bed Group	Current Bed Group (if patient admitted as of date of extract)	Char
Gender	Gender of Client (PHIMS)	Char
Jurisdiction	Jurisdiction (or source of other client ID)	Char
Healthcare Worker Flag	Health Care Worker Flag (Y, N, or blank)	Char
Most Recent Admit Hospital	Most Recent Admitting Hospital (as of date of extract)	Char
Organization Responsible	Organization Responsible for the Case	Char
Outcome Result	Description of Case Outcome	Char
Postal Code	Postal Code of Client (PHIMS)	Char
Primary Investigating Organization	Primary Investigating Organization	Char
Primary Investigating Organization-Case	Primary Investigating Organization for the Case	Char
Regional Health Authority	Regional Health Authority of Client	Char
Client ID Scrambled PHIN Type	MCHP process for assigning Scrambled PHIN	Char
Sex	Sex (data from Registry)	Char
Symptom 1	Symptom 1 for Case	Char
Symptom 2	Symptom 2 for Case	Char
Symptom 3	Symptom 3 for Case	Char
Symptom 4	Symptom 4 for Case	Char
Symptom 5	Symptom 5 for Case	Char
Symptom 6	Symptom 6 for Case	Char
Symptom 7	Symptom 7 for Case	Char
Symptom 8	Symptom 8 for Case	Char
Symptom 9	Symptom 9 for Case	Char
Symptom 10	Symptom 10 for Case	Char
Symptom 11	Symptom 11 for Case	Char
Symptom 12	Symptom 12 for Case	Char
Symptom 13	Symptom 13 for Case	Char
Symptom 14	Symptom 14 for Case	Char
MCHP Acquisition Date	Date MCHP acquired record from Manitoba Health	Date
Birth Date	Birthdate of Client	Date
Death Date	Date of Death (if applicable)	Date
Discharge Date	Most Recent Discharge Date	Date
First COVID Admit Date	First Hospital Admission Date (COVID-19)	Date
Most Recent Admit Date	Most Recent Hospital Admission Date (as of date of extract)	Date
Outcome Date	Date that the Case Outcome was Determined	Date
Recovered Date	Date Client was Determined to be Recovered	Date
Report Date	Date Case Reported	Date
Symptom Onset Date	Date of Symptom Onset	Date

COVID-19 Surveillance - Contacts

COVID-19 Surveillance Contacts Dataset Information
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

COVID-19 Surveillance Contacts Dataset - Data Field Information
Field	Description	Format/Type
Contacted Client ID	Contacted Client - MCHP Scrambled Personal Health ID Number (PHIN)	ID
Contacted Client ID - PHIMS	Scrambled PHIMS Client ID Number for Person Contacted by COVID-19 Source (for linking to Cases dataset)	ID
Contacted Client ID - PHIN	Scrambled MB Health PHIN for Person Contacted by COVID-19 Source	ID
PHIMS Investigation ID	Scrambled PHIMS Investigation ID Number (for linking to Cases dataset)	ID
PHIMS Transmission ID	Scrambled PHIMS Transmission Event ID (for grouping contacts from the same transmission event)	ID
Source Client ID	MCHP Scrambled Personal Health ID Number (PHIN) for Contact's COVID-19 Source	ID
Source Client ID - PHIMS	Scrambled PHIMS Client ID Number for Contact's COVID-19 Source (for linking to Cases dataset)	ID
Source Client ID - PHIN	Scrambled MB Health PHIN for Contact's COVID-19 Source	ID
Contacted Client ID Scrambled PHIN Type	MCHP process to determine Contacted Client Scrambled PHIN	Char
Contact Ethnicity Description	Ethnicity of Person Contacted by COVID-19 Source (PHIMS Standard Description)	Char
Contact Ethnicity Free Text	Ethnicity of Person Contacted by COVID-19 Source (free text)	Char
Contact First Nations Self Identify	PHIMS First Nations Self-Identification of Person Contacted by COVID-19 Source (no data as of 2020-11-29)	Char
Contact First Nations Status	PHIMS First Nations Status of Person Contacted by COVID-19 Source (PHIMS standard description)	Char
Contact Postal Code	Postal Code for Person Contacted by COVID-19 Source (PHIMS)	Char
Contact Identification Type	Type of Contact (with identified individual, or with one or more unidentified individuals) [derived]	Char
Source Client ID Scrambled PHIN Type	Source Client - MCHP process for assigning Source Client Scrambled PHIN	Char
Source Ethnicity Description	Ethnicity of Contact's COVID-19 Source (PHIMS standard description)	Char
Source Ethnicity Free Text	Ethnicity of Contact's COVID-19 Source (free text)	Char
Source First Nations Self Identify	PHIMS First Nations Self-Identification of Contact's COVID-19 Source (no data as of 2020-11-29)	Char
Source First Nations Status	PHIMS First Nations Status of Contact's COVID-19 Source (PHIMS standard description)	Char
Source Postal Code	Postal Code for Contact's COVID-19 Source (PHIMS)	Char
Type of Exposure Setting	Category of COVID-19 Exposure Setting (PHIMS) - e.g.: Household exposure, type of community contact	Char
MCHP Acquisition Date	Date MCHP acquired record from Manitoba Health	Date

NOTE: If you are planning on using Ethnicity or First Nations data in your research, additional approvals/permissions are required.

3 - Repository Data Being Updated Monthly

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:

• i-Registry (Manitoba Health Insurance Registry);
• Medical Claims / Medical Services;
• Critical Care and Medicine (Intensive Care Unit (ICU));
• Drug Program Information Network (DPIN);
• Emergency Department Information System (EDIS); and
• Immunizations MDS

4 - Repository Data Not Being Updated Monthly

Some of our regular Repository data is not being updated monthly and is not available for current COVID-19 research purposes. This includes:

• Hospital Abstracts data - this data is updated annually.
• National Ambulatory Care Reporting System (NACRS) - this data is included as part of the Emergency Department Information System (EDIS) update.

For more information about the data available in the Manitoba Population Research Data Repository, see: Repository Data List.