m4_outputevents: Access information regarding patient outputs including urine,...

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 outputevents table containing data representing all information regarding patient outputs, for example, urine, drainage, etc.

Usage

m4_outputevents(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

Table attributes for outputevents 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, outputevents_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_outputevents(con, cohort = 12384098)
dim(evt)

bigrquery::dbDisconnect(con)

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