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

Published: 17 Sept 2022, Last Modified: 22 Oct 2023NeurIPS 2022 Datasets and Benchmarks Readers: Everyone
Keywords: EHR, EHR QA, Text-to-SQL, semantic parsing
Abstract: We present a new text-to-SQL dataset for electronic health records (EHRs). The utterances were collected from 222 hospital staff, including physicians, nurses, insurance review and health records teams, and more. To construct the QA dataset on structured EHR data, we conducted a poll at a university hospital and templatized the responses to create seed questions. Then, we manually linked them to two open-source EHR databases—MIMIC-III and eICU—and included them with various time expressions and held-out unanswerable questions in the dataset, which were all collected from the poll. Our dataset poses a unique set of challenges: the model needs to 1) generate SQL queries that reflect a wide range of needs in the hospital, including simple retrieval and complex operations such as calculating survival rate, 2) understand various time expressions to answer time-sensitive questions in healthcare, and 3) distinguish whether a given question is answerable or unanswerable based on the prediction confidence. We believe our dataset, EHRSQL, could serve as a practical benchmark to develop and assess QA models on structured EHR data and take one step further towards bridging the gap between text-to-SQL research and its real-life deployment in healthcare. EHRSQL is available at
Author Statement: Yes
TL;DR: A new practical text-to-SQL dataset for electronic health records (EHRs)
Supplementary Material: pdf
Dataset Url:
License: CC-BY-4.0
Contribution Process Agreement: Yes
In Person Attendance: Yes
Community Implementations: [![CatalyzeX](/images/catalyzex_icon.svg) 2 code implementations](
19 Replies