pull_wedss: Pull Confirmed Case data from WEDSS

In carlbfrederick/ohiCovidMetrics: Used to calculate sub-state metrics relating to the COVID-19 pandemic

Description

This function supplies a wrapper to fetch the results from a SQL query from WEDSS and then performs basic data cleaning to calculate the confirmed case metrics.

Usage

pull_wedss(query, conn, end_date = NULL)

Arguments

query	query to pull data from WEDSS. This call should only pull counties or jurisdictions that will automatically be aggregated into HERC regions and Statewide.
conn	connection to database (see odbcConnect) or OdbcConnection
end_date	(default = NULL) If specified it is the end date of the time series that you wish to analyze. It should be something coercible to Date format with as.Date. If you want all data leave it blank.

Value

a cleaned version of the COVID-19 Historical Data Table including HERC regions with the following columns

fips

renamed from GEOID

geo_type

renamed from GEO

geo_name

renamed from NAME

post_date

LoadDttm converted to Date format

case_daily

cleaned daily new positive cases from POS_NEW except for the first day which is from POSITIVE

test_daily

cleaned daily new total tests from TEST_NEW except for the first day which is from POSITIve + NEGATIVE

death_daily

cleaned daily new deaths from DTH_NEW except for the first day which is from DEATHS

pop_2018

2018 Population Numbers pulled from WISH

case_cum

daily cumulative positive cases calculated from case_daily

test_cum

daily cumulative total tests calculated from test_daily

death_cum

daily cumulative deaths calculated from death_daily

and likely one or more of the following columns if applicable

case_daily_raw

original daily new positive cases before cleaning

test_daily_raw

original daily new total tests before cleaning

death_daily_raw

cleaned daily new deaths before cleaning

Examples

## Not run: 
   library(RODBC)
   channel <- odbcConnect("databasename", ...)

   sql_query <- "SELECT * FROM TABLE WHERE GEO = 'COUNTY'"

   hdt <- pull_wedss(query = sql_query, conn = channel, end_date = as.Date("2020-06-24"))

## End(Not run)

carlbfrederick/ohiCovidMetrics documentation built on Jan. 10, 2022, 12:20 p.m.