Perren A, Cerutti B, Kaufmann M, Rothen HU. A novel method to assess data quality in large medical registries and databases.
Int J Qual Health Care 2020;
31:1-7. [PMID:
30608577 DOI:
10.1093/intqhc/mzy249]
[Citation(s) in RCA: 6] [Impact Index Per Article: 1.5] [Reference Citation Analysis] [Abstract] [Key Words] [Track Full Text] [Journal Information] [Subscribe] [Scholar Register] [Received: 07/02/2018] [Revised: 10/07/2018] [Accepted: 12/14/2018] [Indexed: 01/19/2023] Open
Abstract
BACKGROUND
There is no gold standard to assess data quality in large medical registries. Data auditing may be impeded by data protection regulations.
OBJECTIVE
To explore the applicability and usefulness of funnel plots as a novel tool for data quality control in critical care registries.
METHOD
The Swiss ICU-Registry from all 77 certified adult Swiss ICUs (2014 and 2015) was subjected to quality assessment (completeness/accuracy). For the analysis of accuracy, a list of logical rules and cross-checks was developed. Type and number of errors (true coding errors or implausible data) were calculated for each ICU, along with noticeable error rates (>mean + 3 SD in the variable's summary measure, or >99.8% CI in the respective funnel-plot).
RESULTS
We investigated 164 415 patient records with 31 items each (37 items: trauma diagnosis). Data completeness was excellent; trauma was the only incomplete item in 1495 of 9871 records (0.1%, 0.0%-0.6% [median, IQR]). In 15 572 patients records (9.5%), we found 3121 coding errors and 31 265 implausible situations; the latter primarily due to non-specific information on patients' provenance/diagnosis or supposed incoherence between diagnosis and treatments. Together, the error rate was 7.6% (5.9%-11%; median, IQR).
CONCLUSIONS
The Swiss ICU-Registry is almost complete and data quality seems to be adequate. We propose funnel plots as suitable, easy to implement instrument to assist in quality assurance of such a registry. Based on our analysis, specific feedback to ICUs with special-cause variation is possible and may promote such ICUs to improve the quality of their data.
Collapse