process_hospital: Process the shaped hospital data into a Tableau ready format

In lcrayton18/State_package_burdenandtrajectory: Used to calculate sub-state metrics relating to the COVID-19 pandemic

Description

Process the shaped hospital data into a Tableau ready format

Usage

process_hospital(hosp_df)

Arguments

hosp_df

data.frame output by pull_hospital

Value

a Tableau ready data.frame with the following columns:

Hosp_RunDate

Date hospital report was run

Date

Date hospital information was reported

Region

Name of geographic unit (county, state, HERC region)

Region_ID

ID code for geographic unit (FIPS for county and state)

RowType

Are row values summary or daily values

Hosp_dailyCOVID_px

Daily count of COVID patients

Hosp_dailyCOVID_ICUpx

Daily count of COVID patients in the ICU

Hosp_totalbeds

Total Beds (ICU, Intermediate, Med/Surg, Neg. Flow)

Hosp_beds_IBA

Total Immediate Beds Available (ICU, Intermediate, Med/Surg, Neg. Flow)

Hosp_totalICU

Total ICU Beds

Hosp_ICU_IBA

Immediate ICU Beds Available

Hosp_num_px_vent

Current Number of Ventilated Patients (Induvated and mechanically ventilated)

Hosp_total_vents

Total rented/owned/demoed general use ventilators on hand

Hosp_intermed_beds_IBA

Immediate Intermediate Care Beds Available

Hosp_negflow_beds_IBA

Immediate Negative Airflow Isolation Beds Available

Hosp_medsurg_beds_IBA

Immediate Medical/Surgical Beds Available

Hosp_PrctBeds_IBA

Hosp_beds_IBA / Hosp_totalbeds

Hosp_PrctICU_IBA

Hosp_ICU_IBA / Hosp_ICU_IBA

Hosp_PrctVent_Used

Hosp_num_px_vent / Hosp_total_vents

Hosp_COVID_px_Trajectory

Trajectory for Hospitalized COVID patient count (see score_trajectory)

Hosp_COVID_px_Trajectory_Class

Trajectory for Hospitalized COVID patient count (see class_trajectory)

Hosp_COVID_ICUpx_Trajectory

Trajectory for ICU COVID patient count (see score_trajectory)

Hosp_COVID_ICUpx_Trajectory_Class

Trajectory for ICU COVID patient count (see class_trajectory)

Examples

## Not run: 
library(dplyr)

output <- pull_hospital("path-to-hospital-extract") %>%
  shape_hospital_data() %>%
  process_hospital()

## End(Not run)

lcrayton18/State_package_burdenandtrajectory documentation built on July 19, 2020, 12:37 a.m.