m4_procedureevents: Access procedures documented during the ICU stay

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

Description

This functions provides base access to the procedureevents table from the hospital ICU. They include data on all procedures documented during the ICU stay (e.g. ventilation), though not necessarily conducted within the ICU (e.g. x-ray imaging).

Usage

m4_procedureevents(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 procedureevents 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, procedureevents_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_procedureevents(con, cohort = 12384098)
dim(evt)

bigrquery::dbDisconnect(con)

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