Query Library

This guide is intended to help users of Zus data marts familiarize themselves with the data schema, learn about foundational concepts such as enrichment and lenses, and reference SQL queries for common population health related analyses, such as identify care gaps and high risk patients.

This guide is broken into 6 sections:

1. Understanding Zus data
2. Analyzing patient demographics
3. Evaluating population health
4. Identifying high risk patients
5. Supporting risk capture
6. Identifying care gaps

All queries referenced on this page are available in a public GitHub repo.

We plan to further build out this library over time as we identify new use cases. If you have any suggested additions or other feedback you would like to provide, please share your thoughts using this feedback form.