Exploring the OMOP Database in Patient Journey Intelligence | Database Explorer Tutorial

John Snow Labs is a healthcare AI company and the industry leader in medical language models, with 150M+ downloads of its open-source libraries and models, 500+ enterprise customers, and 30+ peer-reviewed papers. Its software runs inside your own environment, on-premises or in your private cloud, with no data movement and no external API calls. Patient Journey Intelligence is the John Snow Labs platform for secondary use of clinical data. It ingests multimodal patient data (clinical notes, PDFs, FHIR, CDA, DICOM, and structured EHR records), extracts 400+ medical entities from unstructured text, harmonizes everything to the OMOP Common Data Model, and de-identifies PHI with 99%+ accuracy. Every extracted fact carries a confidence score and a link back to the source document it came from. Learn more about Patient Journey Intelligence: https://www.johnsnowlabs.com/patient-journey-intelligence/ IN THIS VIDEO Explore the OMOP database behind Patient Journey Intelligence without leaving the browser. This short tutorial walks through the Database Explorer: how to find tables, preview their content, see how they relate to each other, and run SQL queries against patient data. Every database connected to Patient Journey Intelligence is available here for query and exploration. You can check what each table contains right now, see how tables link through shared keys, and answer ad hoc questions with read-only SQL. WHAT YOU WILL SEE 1. Open the Database Explorer under Data Integration. 2. Pick the OMOP database from the database selector. 3. Narrow the schema filter to the Patient Journey Intelligence schema, which holds the OMOP clinical tables. 4. Search for "condition" to list the matching tables with their row counts. 5. Select a table (condition_occurrence) to preview its rows and columns. 6. Switch to the visual view to see tables as cards with keys and column types. 7. Clear the search to browse the schema as a diagram. 8. Follow the relation lines to see how tables link, for example condition_occurrence to visit_occurrence through visit_occurrence_id. 9. Open the SQL Query tab and write a patient query. 10. Execute it and read the results beside the query. WHY IT MATTERS - One place to explore every database behind the platform - List view for quick checks of table size, columns and current content - Visual view for understanding the schema and the relations between tables - Read-only SQL editor for safe, ad hoc analysis on OMOP data TIMESTAMPS 0:00 What the Database Explorer is for 0:14 Choosing the database and schema, searching tables 0:23 Previewing table content in the list view 0:30 Visual view: schema diagram and table relations 0:42 SQL Query tab: running a patient query ABOUT PATIENT JOURNEY INTELLIGENCE Patient Journey Intelligence by John Snow Labs turns raw, multimodal healthcare data into a unified, queryable patient journey built on the OMOP Common Data Model. Learn more: https://www.johnsnowlabs.com/ #PatientJourneyIntelligence #OMOP #HealthcareAI #JohnSnowLabs #ClinicalData #SQL #HealthData #RealWorldData