Repository Data - COVID-19 and Updates

COVID-19 Research ResourcesOngoing COVID-19 Research Projects | Published COVID-19 Research |

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. This data also contains specific coding for services and treatment related to COVID-19.

The following tables describe the content and frequency of updates to the two COVID-19 datasets, the variables available from the data, and the date range of data contained in the files.

The two specific COVID-19 Repository datasets available for research are:

  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 - February 1, 2021
    Number of records 491,182
    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 February 18, 2021
    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

For more information on the COVID-19 related data contained in these additional datasets, please see the MCHP concept titled Coronavirus (COVID-19) Coding and Data Sources.

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.


Last Updated: February 18, 2021