Using a Data Quality Framework to Clean Data Extracted from the Electronic Health Record: A Case Study.
Open accessThe DOI matches its Crossref record; 7 of the 7 references it cites were found in a registry or an index.
Abstract
Objectives: Examine (1) the appropriateness of using a data quality (DQ) framework developed for relational databases as a data-cleaning tool for a dataset extracted from two EPIC databases; and (2) the differences in statistical parameter estimates on a dataset cleaned with the DQ framework and dataset not cleaned with the DQ framework.Background: The use of data contained within electronic health records (EHRs) has the potential to open doors for a new wave of innovative research. Without adequate preparation of such large datasets for analysis, the results might be erroneous, which might affect clinical decision making or results of Comparative Effectives Research studies.Methods: Two Emergency Department (ED) datasets extracted from EPIC databases (adult ED and children ED) were used as examples for examining the five concepts of DQ based on a DQ assessment framework designed for EHR databases. The first dataset contained 70,061 visits, and the second dataset contained 2,815,550 visits. SPSS Syntax examples as well as step-by-step instructions of how to apply the five key DQ concepts these EHR database extracts are provided.Conclusions: SPSS Syntax to address each of DQ concepts proposed by Kahn et al. (2012) was developed. The dataset cleaned using Kahn’s framework yielded more accurate results than the dataset cleaned without this framework. Future plans involve creating functions in R language for cleaning data extracted from the EHR as well as an R package the combines DQ checks with missing data analysis functions.
Overview
The claims and statistics of this paper haven’t been checked yet.
Free: it reads the open-access text and checks the first 5 claims that cite a source we can check. Create a free account to check every claim.
Integrity signals
Registry
Cites
Statistics
Verification
Claims the paper makes
The claims and statistics of this paper haven’t been checked yet.
Free: it reads the open-access text and checks the first 5 claims that cite a source we can check. Create a free account to check every claim.
Self-check
Percentages, sums and reported differences re-computed from the paper’s own numbers.
The self-check needs the paper’s full text.
Citations
Cites
Weiskopf, N. G., & Weng, C. (2013) · Journal of the American Medical Informatics Association · doi:10.1136/amiajnl-2011-000681 · Cited by 1,216
Hersh, W. R., Weiner, M. G., Embi, P. J., Logan, J. R., Payne, P. R. O., Bernstam, E. V., Lehmann, H. P., Hripcsak, G., Hartzog, T. H., Cimino, J. J., et al. (2013) · Medical Care · doi:10.1097/mlr.0b013e31829b1dbd · Cited by 567
Data cleaning: detecting, diagnosing, and editing data abnormalities
Van den Broeck, J., Argeseanu Cunningham, S., Eeckels, R., & Herbst, K. (2005) · PLoS Medicine · doi:10.1371/journal.pmed.0020267 · Cited by 446
McGinn, C. A., Grenier, S., Duplantie, J., Shaw, N., Sicotte, C., Mathieu, L., Leduc, Y., Légaré, F., & Gagnon, M.-P. (2011) · BMC Medicine · doi:10.1186/1741-7015-9-46 · Cited by 393
Kahn, M. G., Raebel, M. A., Glanz, J. M., Riedlinger, K., & Steiner, J. F. (2012) · Medical Care · doi:10.1097/mlr.0b013e318257dd67 · Cited by 260 · cited 9×
“Each of these data types entails differences in the following: (1) extraction methods, (2) quality evaluation standards, (3) screening procedures, and (4) cleaning procedures prior to being ready for secondary use or statistical analysis.”
BackgroundMethodInfluentialValidity of electronic health record-derived quality measurement for performance monitoring
Parsons, A., McCullough, C., Wang, J., & Shih, S. (2012) · Journal of the American Medical Informatics Association · doi:10.1136/amiajnl-2011-000557 · Cited by 137
Johnson, K. E., Kamineni, A., Fuller, S., Olmstead, D., & Wernli, K. J. (2014) · eGEMs (Generating Evidence & Methods to improve patient outcomes) · doi:10.13063/2327-9214.1058 · Cited by 39
Cited by
Electronic Health Record Data Quality Assessment and Tools: A Systematic Review
Lewis, A. E., Weiskopf, N., Abrams, Z. B., Foraker, R., Lai, A. M., Payne, P. R. O., & Gupta, A. (2023) · Journal of the American Medical Informatics Association · doi:10.1093/jamia/ocad120 · Cited by 171
Curtis, J. R., Lee, R. Y., Brumback, L. C., Kross, E. K., Downey, L., Torrence, J., LeDuc, N., Mallon Andrews, K., Im, J., Heywood, J., et al. (2023) · JAMA · doi:10.1001/jama.2023.8812 · Cited by 91
Data Quality–Driven Improvement in Health Care: Systematic Literature Review
Lighterness, A., Adcock, M., Scanlon, L. A., & Price, G. (2024) · Journal of Medical Internet Research · doi:10.2196/57615 · Cited by 26
“The legal and technical implications associated with data cleaning, as opposed to addressing the root causes of poor data, underscore potential risks to patient safety [56-58].”
Metadata
- Authors
- Dziadkowiec, O., Callahan, T., Ozkaynak, M., Reeder, B., & Welton, J.
- Venue
- eGEMs (Generating Evidence & Methods to improve patient outcomes)
- Publisher
- Ubiquity Press, Ltd.
- Published
- 2016-06-24
- Volume
- 4
- Issue
- 1
- Pages
- 11
- ISSN
- 2327-9214 (ISSN-L)
- OpenAlex
- W2466978013
- Cited by
- 37
- References
- 7
- FWCI
- 2.19
- Type
- journal article
- Language
- en
- Open access
- diamond
About these checks
Registry, retraction, Cites and statistics results are computed, not judged, with one exception: a printed reference that no index lists is read once by a model before it counts as a citation error. Claims are extracted by a model and kept only when their quote appears verbatim in the text; each cited source is then checked, with a model’s help, for whether it says what the claim relies on. Those verdicts can be wrong — read the claim’s quote and the cited source before relying on one.
Statistics and arithmetic are recomputed, not judged.
Confidence bands are shown only for fields calibrated on our annotated test set. None is calibrated yet, so no band is shown.
What counts as a claim ›How we measure confidence ›How we check this ›
Are you an author, or do you see a problem with this page? Request a review
How to cite
Cite CoChat for the checks on this page, and the paper for its own findings.
- This page
- CoChat. (2026). Citation check: Using a Data Quality Framework to Clean Data Extracted from the Electronic Health Record: A Case Study. https://app.cochat.ai/papers/10.13063/2327-9214.1201
- The paper
- Dziadkowiec, O., Callahan, T., Ozkaynak, M., Reeder, B., & Welton, J. (2016). Using a Data Quality Framework to Clean Data Extracted from the Electronic Health Record: A Case Study. eGEMs (Generating Evidence & Methods to improve patient outcomes). https://doi.org/10.13063/2327-9214.1201
Data sources
Bibliographic data: Semantic Scholar, OpenAlex, Crossref.
Contains information from the Semantic Scholar Academic Graph Datasets, made available under the ODC Attribution License (ODC-BY 1.0).
Semantic Scholar’s data is described in: Kinney, R., et al. (2023). The Semantic Scholar Open Data Platform. arXiv:2301.10140.