ED Visits

In this section we describe methods for analyzing emergency department visits. Once you're familiar with this basic approach you should be able to develop a wide variety of different analyses for ED visits.

If your data is in the Tuva data model you can follow along and execute the code on your data.

Part 1: Identifying ED Visits

This video explains how to identify ED visits using the Tuva data model.

Part 2: Basic ED Analytics

This video and the diagram below explain examples of basic ED analytics. The SQL code to create all of the tables described in the video and diagram below is located here.

This video demonstrates how to run these example analytics in a notebook and shows results from Medicare LDS claims data.