Find Datasets from
UMB Researchers

Tools for Rapid Analysis of Blood Usage and Inventory During the COVID-19 Pandemic
UMB Dataset

UID: 113

Author(s): Colin Murphy*, Bryon P. Jackson, Magali Fontaine * Corresponding Author
Description
The COVID-19 pandemic severely affected blood collection activities due to social distancing requirements, deferral of blood drives, and other measures to prevent spread of infection. Medical facilities also experienced changes in blood usage patterns with the cancellation of elective surgeries. To evaluate fluctuating blood inventory levels, the University of Maryland Medical Center (UMMC) built an R-based workflow to facilitate rapid and repeatable analysis and visualization of blood usage data extracted from the Cerner Laboratory Information System (LIS). The generation of daily reports by blood product and hospital unit promoted informed decision-making with regard to changing ordering practices to avoid wastage. This dataset consists of 5 R Markdown workflow files and one README file. The workflows will continue to be updated in the GitHub repository as additional R Markdown documents are written to assist in identifying large users, optimize data cleaning and product identification, establish safe inventory levels based on historical and recent usage, and establish web‐based functionality via the shiny pack.
Subject Domain
Keywords
Access via GitHub

R Markdown files

Access Instructions
Free to All
Associated Publications
Data Type
Software Used
Cerner Laboratory
Epic EMR
R Markdown
RcppRoll
Tidyverse
Viridis
Dataset Format(s)
R Markdown