Clinical Characterization of Patients Hospitalized with COVID-19 and Influenza

• Analytics use case(s): Characterization
• Study type: Clinical Application
• Tags: OHDSI, Study-a-thon, COVID-19
• Study lead: Edward Burn, Seng Chan You
• Study lead forums tag: EdBurn, SCYou
• Study start date: March 16, 2020
• Study end date: April 9, 2020
• Protocol: Word Doc
• Publications:
• Results explorer: Influenza Cohort Diagnostics

A study to describe the baseline characteristics of suspected cases of the COVID-19 or confirmed cases of the COVID-19 and influenza patients from 2014-2019 and 2009-2010 (H1N1 pandemic).

Requirements

• A database in Common Data Model version 5 in one of these platforms: SQL Server, Oracle, PostgreSQL, IBM Netezza, Apache Impala, Amazon RedShift, or Microsoft APS.
• Incorporation of OMOP Vocabulary release v20200331 in your local ETL and following OHDSI Community Guidance for Mapping
• R version 3.5.0 or newer
• On Windows: RTools
• Java
• 25 GB of free disk space

See here for instructions on how to set up the R environment on Windows.

How to run

1. This study is currently comprised of two cohort diagnostics packages. The first, in "/COVID Cohort Diagnostics", is for cohorts of individuals with COVID-19. The second, in "/Influenza Cohort Diagnostic", is for cohorts of individuals with influenza in previous years.

2. You will ultimately build two separate libraries for these analysis: CovidHospCohortDiag (the Covid Characterization study) and InfluenzaHospCohortDiag (the Influena Characterization study). Each Analysis folder has specific instructions on how to install the study library.

Note: If you encounter errors in devtools pulling the study packages, you may find it easier to download the repo zip locally and uploading it through your RStudio console. Instructions to upload packages are provided in The Book of OHDSI

3. When completed, the output will exist as a .ZIP file in the export directory in the output folder location. This file contains the results to submit to the study lead. To do so, please use the function below. You must supply the directory location to where you have saved the <study key name>.dat file to the privateKeyFileName argument. You must contact the study coordinator to receive the required private key.

  keyFileName <- "<directory location of where you saved the study key name.dat>"
  userName <- "study-data-site-covid19"
  OhdsiSharing::sftpUploadFile(privateKeyFileName = keyFileName,
                           userName = userName,
                           remoteFolder = "Covid19Characterization/<COVID cohort diagnostics OR Influenza cohort diagnostics>",
                           fileName = "<directory location of outputFolder/export>")

Note: You will need to remove the <> and replace with information from your environment. For the remoteFolder, you will choose one: COVID cohort diagnostics OR Influenza cohort diagnostics based on which study package you ran.

If you are unable to utilize the OhdsiSharing package, you may utilize a SFTP client of your choosing (e.g. FileZilla) and upload through that tool. If you have questions, contact the study coordinator.

License

The CovidHospCohortDiag (the Covid Characterization study) and InfluenzaHospCohortDiag (the Influena Characterization study) packages are licensed under Apache License 2.0