Abstract:Research with structured Electronic Health Records (EHRs) is expanding as data becomes more accessible; analytic methods advance; and the scientific validity of such studies is increasingly accepted. However, data science methodology to enable the rapid searching/extraction, cleaning and analysis of these large, often complex, datasets is less well developed. In addition, commonly used software is inadequate, resulting in bottlenecks in research workflows and in obstacles to increased transparency and reproducibility of the research. Preparing a research-ready dataset from EHRs is a complex and time consuming task requiring substantial data science skills, even for simple designs. In addition, certain aspects of the workflow are computationally intensive, for example extraction of longitudinal data and matching controls to a large cohort, which may take days or even weeks to run using standard software. The rEHR package simplifies and accelerates the process of extracting ready-for-analysis datasets from EHR databases. It has a simple import function to a database backend that greatly accelerates data access times. A set of generic query functions allow users to extract data efficiently without needing detailed knowledge of SQL queries. Longitudinal data extractions can also be made in a single command, making use of parallel processing. The package also contains functions for cutting data by time-varying covariates, matching controls to cases, unit conversion and construction of clinical code lists. There are also functions to synthesise dummy EHR. The package has been tested with one for the largest primary care EHRs, the Clinical Practice Research Datalink (CPRD), but allows for a common interface to other EHRs. This simplified and accelerated work flow for EHR data extraction results in simpler, cleaner scripts that are more easily debugged, shared and reproduced.

EHR-SeqSQL : A Sequential Text-to-SQL Dataset For Interactively Exploring Electronic Health Records

EHRSQL: A Practical Text-to-SQL Benchmark for Electronic Health Records

LI-EMRSQL: Linking Information Enhanced Text2SQL Parsing on Complex Electronic Medical Records

Overview of the EHRSQL 2024 Shared Task on Reliable Text-to-SQL Modeling on Electronic Health Records

EHRXQA: A Multi-Modal Question Answering Dataset for Electronic Health Records with Chest X-ray Images

SeSQL: A High-Quality Large-Scale Session-Level Chinese Text-to-SQL Dataset.

SeSQL: Yet Another Large-scale Session-level Chinese Text-to-SQL Dataset

Retrieval augmented text-to-SQL generation for epidemiological question answering using electronic health records

Knowledge Graph-based Question Answering with Electronic Health Records

SM3-Text-to-Query: Synthetic Multi-Model Medical Text-to-Query Benchmark

Exploratory Electronic Health Record Analysis with Ehrapy

DrugEHRQA: A Question Answering Dataset on Structured and Unstructured Electronic Health Records For Medicine Related Queries

KU-DMIS at EHRSQL 2024:Generating SQL query via question templatization in EHR

EHRCon: Dataset for Checking Consistency between Unstructured Notes and Structured Tables in Electronic Health Records

Question Answering for Complex Electronic Health Records Database using Unified Encoder-Decoder Architecture

ECG-QA: A Comprehensive Question Answering Dataset Combined With Electrocardiogram

A Query Engine for Self-controlled Case Series, with an application to COVID-19 EHR data

Towards Unbiased Evaluation of Detecting Unanswerable Questions in EHRSQL

CSS: A Large-scale Cross-schema Chinese Text-to-SQL Medical Dataset

rEHR: An R package for manipulating and analysing Electronic Health Record data

LG AI Research & KAIST at EHRSQL 2024: Self-Training Large Language Models with Pseudo-Labeled Unanswerable Questions for a Reliable Text-to-SQL System on EHRs