Skip to main content
medRxiv
  • Home
  • About
  • Submit
  • ALERTS / RSS
Advanced Search

Assessing the quality of clinical and administrative data extracted from hospitals: The General Medicine Inpatient Initiative (GEMINI) experience

View ORCID ProfileSachin V. Pasricha, Hae Young Jung, Vladyslav Kushnir, Denise Mak, Radha Koppula, Yishan Guo, Janice L. Kwan, Lauren Lapointe-Shaw, View ORCID ProfileShail Rawal, Terence Tang, Adina Weinerman, Fahad Razak, Amol A. Verma
doi: https://doi.org/10.1101/2020.03.16.20036962
Sachin V. Pasricha
1Li Ka Shing Knowledge Institute, St. Michael’s Hospital, Toronto, Canada
2School of Medicine, Faculty of Health Sciences, Queen’s University, Kingston, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
  • ORCID record for Sachin V. Pasricha
Hae Young Jung
1Li Ka Shing Knowledge Institute, St. Michael’s Hospital, Toronto, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Vladyslav Kushnir
1Li Ka Shing Knowledge Institute, St. Michael’s Hospital, Toronto, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Denise Mak
1Li Ka Shing Knowledge Institute, St. Michael’s Hospital, Toronto, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Radha Koppula
1Li Ka Shing Knowledge Institute, St. Michael’s Hospital, Toronto, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Yishan Guo
1Li Ka Shing Knowledge Institute, St. Michael’s Hospital, Toronto, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Janice L. Kwan
3Department of Medicine, University of Toronto, Toronto, Canada
4Department of Medicine, Mount Sinai Hospital, Toronto, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Lauren Lapointe-Shaw
3Department of Medicine, University of Toronto, Toronto, Canada
5Division of General Internal Medicine, University Health Network, Toronto, Canada
6Institute for Clinical and Evaluative Sciences, Toronto, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Shail Rawal
3Department of Medicine, University of Toronto, Toronto, Canada
5Division of General Internal Medicine, University Health Network, Toronto, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
  • ORCID record for Shail Rawal
Terence Tang
3Department of Medicine, University of Toronto, Toronto, Canada
7Institute for Better Health, Trillium Health Partners, Toronto, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Adina Weinerman
3Department of Medicine, University of Toronto, Toronto, Canada
8Sunnybrook Health Sciences Centre, Toronto, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Fahad Razak
1Li Ka Shing Knowledge Institute, St. Michael’s Hospital, Toronto, Canada
3Department of Medicine, University of Toronto, Toronto, Canada
9Institute for Health Policy, Management and Evaluation, University of Toronto, Toronto, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
Amol A. Verma
1Li Ka Shing Knowledge Institute, St. Michael’s Hospital, Toronto, Canada
3Department of Medicine, University of Toronto, Toronto, Canada
9Institute for Health Policy, Management and Evaluation, University of Toronto, Toronto, Canada
  • Find this author on Google Scholar
  • Find this author on PubMed
  • Search for this author on this site
  • For correspondence: amol.verma@mail.utoronto.ca
  • Abstract
  • Full Text
  • Info/History
  • Metrics
  • Supplementary material
  • Data/Code
  • Preview PDF
Loading

Abstract

Objective Large clinical databases are increasingly being used for research and quality improvement, but there remains uncertainty about how computational and manual approaches can be used together to assess and improve the quality of extracted data. The General Medicine Inpatient Initiative (GEMINI) database extracts and standardizes a broad range of data from clinical and administrative hospital data systems, including information about attending physicians, room transfers, laboratory tests, diagnostic imaging reports, and outcomes such as death in-hospital. We describe computational data quality assessment and manual data validation techniques that were used for GEMINI.

Methods The GEMINI database currently contains 245,559 General Internal Medicine patient admissions at 7 hospital sites in Ontario, Canada from 2010-2017. We performed 7 computational data quality checks followed by manual validation of 23,419 selected data points on a sample of 7,488 patients across participating hospitals. After iteratively re-extracting data as needed based on the computational data quality checks, we manually validated GEMINI data against the data that could be obtained using the hospital’s electronic medical record (i.e. the data clinicians would see when providing care), which we considered the gold standard. We calculated accuracy, sensitivity, specificity, and positive and negative predictive values of GEMINI data.

Results Computational checks identified multiple data quality issues – for example, the inclusion of cancelled radiology tests, a time shift of transfusion data, and mistakenly processing the symbol for sodium, “Na”, as a missing value. Manual data validation revealed that GEMINI data were ultimately highly reliable compared to the gold standard across nearly all data tables. One important data quality issue was identified by manual validation that was not detected by computational checks, which was that the dates and times of blood transfusion data at one site were not reliable. This resulted in low sensitivity (66%) and positive predictive value (75%) for blood transfusion data at that site. Apart from this single issue, GEMINI data were highly reliable across all data tables, with high overall accuracy (ranging from 98-100%), sensitivity (95-100%), specificity (99-100%), positive predictive value (93-100%), and negative predictive value (99-100%) compared to the gold standard.

Discussion and Conclusion Iterative assessment and improvement of data quality based primarily on computational checks permitted highly reliable extraction of multisite clinical and administrative data. Computational checks identified nearly all of the data quality issues in this initiative but one critical quality issue was only identified during manual validation. Combining computational checks and manual validation may be the optimal method for assessing and improving the quality of large multi-site clinical databases.

Competing Interest Statement

The authors have declared no competing interest.

Funding Statement

The General Medicine Inpatient Initiative (GEMINI) was supported by grants from the Green Shield Canada Foundation and the University of Toronto Division of General Internal Medicine. This study was supported by grant SMH-17-007 from the St. Michaels Hospital Medical Services Association Innovation Fund. Amol Verma is supported by funding from the Eliot Phillipson Clinician-Scientist Training Program, Department of Medicine, University of Toronto.

Author Declarations

All relevant ethical guidelines have been followed; any necessary IRB and/or ethics committee approvals have been obtained and details of the IRB/oversight body are included in the manuscript.

Yes

All necessary patient/participant consent has been obtained and the appropriate institutional forms have been archived.

Yes

I understand that all clinical trials and any other prospective interventional studies must be registered with an ICMJE-approved registry, such as ClinicalTrials.gov. I confirm that any such study reported in the manuscript has been registered and the trial registration ID is provided (note: if posting a prospective study registered retrospectively, please provide a statement in the trial ID field explaining why the study was not registered in advance).

Yes

I have followed all appropriate research reporting guidelines and uploaded the relevant EQUATOR Network research reporting checklist(s) and other pertinent material as supplementary files, if applicable.

Yes

Data Availability

The data used to create this manuscript is available in the GEMINI database.

Copyright 
The copyright holder for this preprint is the author/funder, who has granted medRxiv a license to display the preprint in perpetuity. All rights reserved. No reuse allowed without permission.
Back to top
PreviousNext
Posted March 18, 2020.
Download PDF

Supplementary Material

Data/Code
Email

Thank you for your interest in spreading the word about medRxiv.

NOTE: Your email address is requested solely to identify you as the sender of this article.

Enter multiple addresses on separate lines or separate them with commas.
Assessing the quality of clinical and administrative data extracted from hospitals: The General Medicine Inpatient Initiative (GEMINI) experience
(Your Name) has forwarded a page to you from medRxiv
(Your Name) thought you would like to see this page from the medRxiv website.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
Share
Assessing the quality of clinical and administrative data extracted from hospitals: The General Medicine Inpatient Initiative (GEMINI) experience
Sachin V. Pasricha, Hae Young Jung, Vladyslav Kushnir, Denise Mak, Radha Koppula, Yishan Guo, Janice L. Kwan, Lauren Lapointe-Shaw, Shail Rawal, Terence Tang, Adina Weinerman, Fahad Razak, Amol A. Verma
medRxiv 2020.03.16.20036962; doi: https://doi.org/10.1101/2020.03.16.20036962
Digg logo Reddit logo Twitter logo Facebook logo Google logo LinkedIn logo Mendeley logo
Citation Tools
Assessing the quality of clinical and administrative data extracted from hospitals: The General Medicine Inpatient Initiative (GEMINI) experience
Sachin V. Pasricha, Hae Young Jung, Vladyslav Kushnir, Denise Mak, Radha Koppula, Yishan Guo, Janice L. Kwan, Lauren Lapointe-Shaw, Shail Rawal, Terence Tang, Adina Weinerman, Fahad Razak, Amol A. Verma
medRxiv 2020.03.16.20036962; doi: https://doi.org/10.1101/2020.03.16.20036962

Citation Manager Formats

  • BibTeX
  • Bookends
  • EasyBib
  • EndNote (tagged)
  • EndNote 8 (xml)
  • Medlars
  • Mendeley
  • Papers
  • RefWorks Tagged
  • Ref Manager
  • RIS
  • Zotero
  • Tweet Widget
  • Facebook Like
  • Google Plus One

Subject Area

  • Health Informatics
Subject Areas
All Articles
  • Addiction Medicine (161)
  • Allergy and Immunology (416)
  • Anesthesia (91)
  • Cardiovascular Medicine (860)
  • Dentistry and Oral Medicine (159)
  • Dermatology (98)
  • Emergency Medicine (250)
  • Endocrinology (including Diabetes Mellitus and Metabolic Disease) (394)
  • Epidemiology (8566)
  • Forensic Medicine (4)
  • Gastroenterology (385)
  • Genetic and Genomic Medicine (1755)
  • Geriatric Medicine (167)
  • Health Economics (373)
  • Health Informatics (1245)
  • Health Policy (622)
  • Health Systems and Quality Improvement (468)
  • Hematology (196)
  • HIV/AIDS (376)
  • Infectious Diseases (except HIV/AIDS) (10306)
  • Intensive Care and Critical Care Medicine (553)
  • Medical Education (192)
  • Medical Ethics (51)
  • Nephrology (212)
  • Neurology (1679)
  • Nursing (97)
  • Nutrition (252)
  • Obstetrics and Gynecology (326)
  • Occupational and Environmental Health (451)
  • Oncology (929)
  • Ophthalmology (263)
  • Orthopedics (102)
  • Otolaryngology (172)
  • Pain Medicine (114)
  • Palliative Medicine (40)
  • Pathology (253)
  • Pediatrics (536)
  • Pharmacology and Therapeutics (254)
  • Primary Care Research (208)
  • Psychiatry and Clinical Psychology (1772)
  • Public and Global Health (3845)
  • Radiology and Imaging (624)
  • Rehabilitation Medicine and Physical Therapy (320)
  • Respiratory Medicine (521)
  • Rheumatology (208)
  • Sexual and Reproductive Health (168)
  • Sports Medicine (158)
  • Surgery (190)
  • Toxicology (36)
  • Transplantation (101)
  • Urology (76)