db_get_icustays: Simple table specific reference function for the ICUSTAYS...

In hdshea/MIMIC3db: Package for building, loading and referencing a SQLite version of the MIMIC-III v1.4 database on a local network

Description

Simple table specific reference function for the ICUSTAYS table data

Usage

db_get_icustays(con, ...)

Arguments

con	A DBIConnection object, as returned by DBI::dbConnect().
...	an optional where parameter with a character string representing a SQL WHERE clause.

Value

a tibble with the results.

See Also

For an overview of the MIMIC-III database, see: Overview of the MIMIC-III data. For details on the ICUSTAYS table, see: The icustays table.

Examples

con <- RSQLite::dbConnect(RSQLite::SQLite(), ":memory:")
ex <- tibble::tibble(SUBJECT_ID = c(10006, 10011))
RSQLite::dbWriteTable(con, "ICUSTAYS", ex)

td <- db_get_icustays(con, where = "WHERE SUBJECT_ID = 10006")

RSQLite::dbDisconnect(con)

hdshea/MIMIC3db documentation built on Dec. 20, 2021, 3:44 p.m.