Working with Healthcare Databases
Row-bind a list of data.frames or remote tables with variable selectio...
Build case definition function calls
Group records no more than n days apart as episodes
Compute Elixhauser Comorbidity Index
Compute duration between two dates
Cut the time period in one row into multiple rows by interval
Identify diseases/events from administrative records with age restrict...
Identify diseases/events from administrative records
Remove rows based on conditions or another data set
Execute parameterized case definitions
Get variables from multiple tables with common ID columns
healthdb: Working with Healthcare Databases
Identify rows with a match
Interpret if any n elements drawn from a date vector could be some day...
Find value corresponding to the input vector using a look-up table
Make test data
Pipe operator
Pool qualified clients from results of multiple definitions
Report number of distinct value in a column across data frames
Remove or flag groups failed to meet conditions based on dates
Remove or flag groups with n less than some number
A system for identifying diseases or events from healthcare databases and preparing data for epidemiological studies. It includes capabilities not supported by 'SQL', such as matching strings by 'stringr' style regular expressions, and can compute comorbidity scores (Quan et al. (2005) <doi:10.1097/01.mlr.0000182534.19832.83>) directly on a database server. The implementation is based on 'dbplyr' with full 'tidyverse' compatibility.
Useful links