Electronic Health Record Data Management and Analysis

Code for data management and analysis of an EHR relational database.

Files include:

Cut Buprenorphine Depression Data

• This file will open data and perform initial data exploration.

Explore Data

• Explore source data.
• Identify baseline dates.

Identify Baseline

• Import source datasets.
• Extract relevant events and dates.
• Aggregate information across sources.
• Identify baseline dates.

Manipulate EMR RX

• Manipulate Rx data from EMR datasets.

Buprenorphine Outcome

• Identify patient outcome (buprenorphine treatment post OUD).

Covariates

• Identify patient covariate data.

Demographics

• Identify patient demographics information.

Depression Exposure

• Identify patients with depression exposure.

Follow Up Period

• Identify patients with follow-up period criteria.

Health Care Utilization

• Identify patient health care utilization.

Medication Exclusions

• Extract Patients with medication exclusions.

PHQ-9

• Identify cohort PHQ-9 measurements.

Washout Period

• Identify exclusion criteria.
• Extract eligible population.

Cohort Dataset

• Combine all cohort criteria indicators and information.
• Identify eligible patients based on criteria.

Cohort Flowchart

• Create eligibility criteria flowchart.