EHI Playground

Welcome to the interactive SQL playground! Here you can write and execute SQL queries against the Epic EHI sample database directly in your browser.

Load Example:-- Select an example query --00 - View the scope of EHI data available in our export00 - Your first EHI query - see real patient encounters00 - Understanding Epic's date formats00 - Pattern 1: Join patient data with encounters00 - Pattern 2: Find tables by keyword using metadata00 - Your first look at the _metadata table structure00 - Understanding the _metadata structure00 - Discover what key tables do00 - Get full documentation for any table00 - Find all tables related to diagnoses00 - Find all date/time columns related to admission00 - Find foreign key relationships for patients00 - Analyze metadata completeness00 - First, get the documentation00 - Then see actual data patterns00 - See evidence of hierarchical data in relational form00 - Observe hierarchical patterns in account contacts00 - See the scale that demands this architecture00 - Discover Epic's internal date system00 - Trace hierarchical relationships through shared IDs00 - Common Epic master file prefixes01 - Discover the prevalence of the LINE pattern01 - Examine the (ID, LINE) pattern in encounter diagnoses01 - Proof that LINE does not indicate priority01 - Verify LINE numbering always starts at 101 - See the variety of data using the (ID, LINE) pattern01 - Count items per parent correctly01 - Discover tables using the grouped list pattern01 - See the grouped list pattern in action01 - Examine the structure of a grouped list table01 - Understand the variety of grouped list applications01 - Aggregate values within groups01 - Verify the numbering rules for grouped lists01 - Discover the scope of history tracking01 - Compare a regular table to its history counterpart01 - See the address change history01 - Understand the active record pattern01 - Find a patient's address on a specific date01 - Examine different types of historical data01 - Identify audit tracking columns01 - Analyze history table structures01 - Compare tables with and without history tracking01 - Prove that ZC_ lookup tables don't exist01 - Discover the prevalence of the _C_NAME pattern01 - See category values in practice01 - Find columns where documentation reveals numeric codes01 - Check for case variations in category values01 - Demonstrate lack of referential constraints01 - Analyze category naming patterns01 - Investigate _C columns without _NAME01 - Create a reference list of valid values01 - See why standard dates aren't enough01 - Verify the Epic epoch date01 - Analyze decimal sequencing patterns01 - Discover all _REAL date columns01 - Demonstrate why _REAL sorting is essential01 - Verify _REAL values are unique per patient01 - Prove decimals aren't timestamps01 - Discover the most common column patterns01 - Understand the _YN boolean pattern01 - Explore ID/NAME pairs01 - See ID/NAME pairs in action01 - Discover continuation tables01 - Analyze temporal column patterns01 - Explore financial amount columns01 - Understand CSN usage01 - See all patterns working together02 - Explore the core patient record02 - View the comprehensive patient master documentation02 - Explore granular language preferences02 - Explore the continuation table pattern02 - See specialized data in overflow tables02 - Examine PCP assignment and preferences02 - Confirm absence of gender identity fields02 - Search for merge tracking tables02 - Check for test patient identification02 - Compare internal and external patient identifiers02 - Prove PAT_ID is the universal foreign key02 - Examine the multiple name storage formats02 - Explore patient aliases and alternative names02 - Compare race and ethnicity storage patterns02 - Understand the three-tier address system02 - Get complete address with street lines02 - View emergency contacts02 - Compare the record counts of the two diagnosis storage models02 - Examine the diagnosis structure for a single encounter02 - Prove that LINE number does not indicate priority02 - View a patient's active problem list02 - Find when ongoing problems were addressed in specific encounters02 - Look up common diagnoses in the master table02 - Create a timeline of all diagnoses for a patient02 - View recent patient encounters02 - Verify CSN uniqueness and its role as a primary key02 - Demonstrate the decimal date pattern for chronological sorting02 - Analyze encounter types across different departments02 - View hospital admissions and length of stay02 - Show the complete patient journey for an encounter02 - Analyze appointment status distribution02 - Understand the different provider roles02 - Create a patient's encounter timeline02 - View the different types of non-medication orders02 - Examine a lab order and its status02 - Examine a complete metabolic panel with all its result components02 - View imaging orders and their status02 - Track referrals to specialists02 - Analyze order status distribution02 - Overview of safety-critical data volumes02 - View current medication orders with status02 - Get patient sig instructions for a medication02 - View a patient's active allergies and their severity02 - See detailed reactions for a specific allergy02 - View a patient's immunization history02 - View complete vaccine administration details including lot number02 - Explore all available health maintenance topics and categorize them02 - View current health maintenance status for a specific patient02 - Analyze how health maintenance items get completed across the system02 - Identify the most common overdue preventive care items03 - View the different types of clinical notes available03 - Read the content of a recent clinical note03 - Find external (scanned) documents03 - View a patient's recent vital signs from flowsheets03 - List all flowsheet measurements recorded for a patient03 - View measurement context, including who recorded it and where03 - Check a patient's portal account status and activation details03 - View recent messages for a patient showing direction and threading03 - Read the complete text of a patient's message about wrist pain03 - Analyze the types of conversations a patient has initiated03 - Analyze bidirectional message flow for a patient03 - Explore available communication preference types03 - Create a complete patient portal engagement summary04 - Show how patients link to insurance coverage through accounts04 - Examine comprehensive coverage information including member details04 - View the multi-tier benefit structure with deductibles and coinsurance04 - Analyze deductible accumulation across multiple benefit records04 - Display comprehensive service benefits showing network variations04 - Check coverage verification and eligibility status05 - Check what fraction of encounters have INPATIENT_DATA_ID05 - Compare INPATIENT_DATA_ID presence with actual hospital records05 - List departments using INPATIENT_DATA_ID05 - Show ED workflow tracking in non-ED departments05 - Show which tables use INPATIENT_DATA_ID for tracking05 - Examine IP_DATA_STORE connections05 - Correctly identify true hospital admissions05 - Analyze what features INPATIENT_DATA_ID enables

Query Name:

SQL Query Editor

▶ Run Query🔗 Share

SELECT * FROM PATIENT LIMIT 10;

Tips:

• Press Ctrl+Enter to run your query
• Your query is automatically saved to the URL - bookmark or share the link!
• Try loading an example query from the dropdown above
• The database contains Epic EHI sample data with patient, encounter, and clinical tables

Quick Start Examples

Try these queries to get started:

1. List all patients:

   SELECT PAT_ID, PAT_NAME, BIRTH_DATE
   FROM PATIENT
   LIMIT 10;

2. Find recent encounters:

   SELECT p.PAT_NAME, e.CONTACT_DATE, e.ENC_TYPE_TITLE
   FROM PAT_ENC e
   JOIN PATIENT p ON e.PAT_ID = p.PAT_ID
   ORDER BY e.CONTACT_DATE DESC
   LIMIT 20;

3. View available tables:

   SELECT name
   FROM sqlite_master
   WHERE type='table'
   ORDER BY name;

Features

• Live Execution - Queries run instantly in your browser using SQL.js
• URL Sharing - Your queries are saved to the URL for easy sharing
• Example Library - Load pre-built queries from the manual chapters
• Keyboard Shortcuts - Press Ctrl+Enter to run queries quickly
• Export Results - Copy query results to use elsewhere

Happy querying! 🚀