m4_datetimeevents: Access documented information which is in a date format (e.g....

In hdshea/MIMIC4db: Package for building, loading and referencing the Google BigQuery verion of the MIMIC-IV

Description

This function provides base access to the datetimeevents table containing data which represents all date measurements about a patient in the ICU.

Usage

m4_datetimeevents(con, cohort = NULL, itemlist = NULL, ...)

Arguments

con	A bigrquery::bigquery() DBIConnection object, as returned by DBI::dbConnect() with an appropriate bigrquery::bigquery() DBI driver specified in the call.
cohort	an optional vector of patient IDs defining the cohort of interest
itemlist	an optional vector of item IDs defining the event types of interest
...	additional optional passed along parameters.

Details

For example, the date of last dialysis would be in the DATETIMEEVENTS table, but the systolic blood pressure would not be in this table.

Table attributes for datetimeevents table:

(PKEY subject_id, hadm_id, stay_id)

(FKEY subject_id) -> patients table

(FKEY hadm_id) -> admissions table

(FKEY stay_id) -> icustays table

(FKEY itemid) -> d_items table, datetimeevents_items sub-table

Value

a tibble with the results.

Examples

# To run examples, you must have the BIGQUERY_TEST_PROJECT environment
# variable set to name of project which has billing set up and to which
# you have write access.
con <- bigrquery::dbConnect(
  bigrquery::bigquery(),
  project = bigrquery::bq_test_project(),
  quiet = TRUE
)

evt <- m4_datetimeevents(con, cohort = 15914798)
dim(evt)

bigrquery::dbDisconnect(con)

hdshea/MIMIC4db documentation built on Dec. 20, 2021, 3:45 p.m.