Assessing data quality from the Clinical Practice Research Datalink: a methodological approach applied to the full blood count blood test

Abstract

A Full Blood Count (FBC) is a common blood test including 20 parameters, such as haemoglobin and platelets. FBCs from Electronic Health Record (EHR) databases provide a large sample of anonymised individual patient data and are increasingly used in research. We describe the quality of the FBC data in one EHR. The Test dataset from the Clinical Research Practice Datalink (CPRD) was accessed, which contains results of tests performed in primary care, such as FBC blood tests. Medical codes and entity codes, two coding systems used within CPRD to identify FBC records, were compared, with levels of mismatched coding, and number that could be rectified reported. The reliability of units of measurement are also described and missing data discussed. There were 14 entity codes and 138 medical codes for the FBC in the data. Medical and entity codes consistently corresponded to the same FBC parameter in 95.2% (n = 217,752,448) of parameters. In the 4.8% (n = 10,955,006) mismatches, the most common parameter rectified was mean platelet volume (n = 2,041,360) and 1,191,540 could not be rectified and were removed. Units of measurement were often either missing, partially entered, or did not appear to correspond to the blood value. The final dataset contained 16,537,017 FBC tests. Applying mathematical equations to derive some missing parameters in these FBCs resulted in 15 of 20 parameters available per FBC on average, with 0.3% of FBCs having all 20 parameters. Performing data quality checks can help to understand the extent of any issues in the dataset. We emphasise balancing large sample sizes with reliability of the data.

BLOod Test Trend for cancEr Detection (BLOTTED): protocol for an observational and prediction model development study using English primary care electronic health record data

“…Cancer diagnoses will be obtained from the National Cancer Registration and Analysis Service (NCRAS), Hospital Episode Statistics (HES) databases, and Office of National Statistics (ONS) (if related to death). Our blood test data preparation and reporting will follow the steps outlined in our previous work [ 14 ].…”

Trends in the full blood count blood test and colorectal cancer detection: a longitudinal, case-control study of UK primary care patient data

“…We used reference ranges provided by the Department of Laboratory Haematology at Oxford University Hospitals Trust in this study (Table 4) (Oxford University Hospitals NHS UK) for comparison with trends. A detailed account of our data preparation and validation processes has previously been reported 7 . We also previously provided summary statistics for each FBC parameter.…”

Full Blood Count Trends for Colorectal Cancer Detection in Primary Care: Development and Validation of a Dynamic Prediction Model

“…We therefore performed no data imputation and modelled all data as-is. A detailed account of our FBC data preparation and validation processes has previously been reported [21].…”