Skip to main content
Top
Published in: BMC Medical Informatics and Decision Making 1/2017

Open Access 01-12-2017 | Research article

Using a linked database for epidemiology across the primary and secondary care divide: acute kidney injury

Authors: M. Johnson, H. Hounkpatin, S. Fraser, D. Culliford, M. Uniacke, P. Roderick

Published in: BMC Medical Informatics and Decision Making | Issue 1/2017

Login to get access

Abstract

Background

NHS England has mandated the use in hospital laboratories of an automated early warning algorithm to create a consistent method for the detection of acute kidney injury (AKI). It generates an ‘alert’ based on changes in serum creatinine level to notify attending clinicians of a possible incident case of the condition, and to provide an assessment of its severity. We aimed to explore the feasibility of secondary data analysis to reproduce the algorithm outside of the hospital laboratory, and to describe the epidemiology of AKI across primary and secondary care within a region.

Methods

Using the Hampshire Health Record Analytical database, a patient-anonymised database linking primary care, secondary care and hospital laboratory data, we applied the algorithm to one year (1st January-31st December 2014) of retrospective longitudinal data. We developed database queries to modularise the collection of data from various sectors of the local health system, recreate the functions of the algorithm and undertake data cleaning.

Results

Of a regional population of 642,337 patients, 176,113 (27.4%) had two or more serum creatinine test results available, with testing more common amongst older age groups. We identified 5361 (or 0.8%) with incident AKI indicated by the algorithm, generating a total of 13,845 individual AKI alerts. A cross-sectional assessment of each patient’s first alert found that more than two-thirds of cases originated in the community, of which nearly half did not lead to a hospital admission.

Conclusion

It is possible to reproduce the algorithm using linked primary care, secondary care and hospital laboratory data, although data completeness, data quality and technical issues must be overcome. Linked data is essential to follow the significant proportion of people with AKI who transition from primary to secondary care, and can be used to assess clinical outcomes and the impact of interventions across the health system. This study emphasises that the development of data systems bridging across different sectors of the health and social care system can provide benefits for researchers, clinicians, healthcare providers and commissioners.
Appendix
Available only for authorised users
Literature
1.
go back to reference Thomas M, Sitch A, Dowswell G. The initial development and assessment of an automatic alert warning of acute kidney injury. Nephrol Dial Transplant. 2011;26(7):2161–8.CrossRefPubMed Thomas M, Sitch A, Dowswell G. The initial development and assessment of an automatic alert warning of acute kidney injury. Nephrol Dial Transplant. 2011;26(7):2161–8.CrossRefPubMed
4.
5.
go back to reference Wonnacott A, Meran S, Amphlett B, Talabani B, Phillips A. Epidemiology and outcomes in community-acquired versus hospital-acquired AKI. Clin J Am Soc Nephrol. 2014;9(6):1007–14.CrossRefPubMedPubMedCentral Wonnacott A, Meran S, Amphlett B, Talabani B, Phillips A. Epidemiology and outcomes in community-acquired versus hospital-acquired AKI. Clin J Am Soc Nephrol. 2014;9(6):1007–14.CrossRefPubMedPubMedCentral
8.
go back to reference Thomas ME, Blaine C, Dawnay A, Devonald MA, Ftouh S, Laing C, Latchem S, Lewington A, Milford DV, Ostermann M. The definition of acute kidney injury and its use in practice. Kidney Int. 2015;87(1):62–73.CrossRefPubMed Thomas ME, Blaine C, Dawnay A, Devonald MA, Ftouh S, Laing C, Latchem S, Lewington A, Milford DV, Ostermann M. The definition of acute kidney injury and its use in practice. Kidney Int. 2015;87(1):62–73.CrossRefPubMed
9.
go back to reference Benson T. The history of the read codes: the inaugural James read memorial lecture 2011. J Innov Health Informatics. 2011;19(3):173–82.CrossRef Benson T. The history of the read codes: the inaugural James read memorial lecture 2011. J Innov Health Informatics. 2011;19(3):173–82.CrossRef
10.
go back to reference Tukey J. Exploratory data analysis. 1st ed. Reading: Addison-Wesley; 1977. Tukey J. Exploratory data analysis. 1st ed. Reading: Addison-Wesley; 1977.
11.
go back to reference Fraser SD, Parkes J, Culliford D, Santer M, Roderick PJ. Timeliness in chronic kidney disease and albuminuria identification: a retrospective cohort study. BMC Fam Pract. 2015;16:18.CrossRefPubMedPubMedCentral Fraser SD, Parkes J, Culliford D, Santer M, Roderick PJ. Timeliness in chronic kidney disease and albuminuria identification: a retrospective cohort study. BMC Fam Pract. 2015;16:18.CrossRefPubMedPubMedCentral
12.
go back to reference Fraser SDS, Watkinson GE, Rennie CA, King D, Sanderson H, Edwards L, Roderick P. Sociodemographic differences in diabetic retinopathy screening; using patient-level primary care data for health equity audit. Clin Audit. 2011;7 Fraser SDS, Watkinson GE, Rennie CA, King D, Sanderson H, Edwards L, Roderick P. Sociodemographic differences in diabetic retinopathy screening; using patient-level primary care data for health equity audit. Clin Audit. 2011;7
13.
go back to reference Sundvall P, Stuart B, Davis M, Roderick P, Moore M. Antibiotic use in the care home setting: a retrospective cohort study analysing routine data. BMC Geriatr. 2015;15:71.CrossRefPubMedPubMedCentral Sundvall P, Stuart B, Davis M, Roderick P, Moore M. Antibiotic use in the care home setting: a retrospective cohort study analysing routine data. BMC Geriatr. 2015;15:71.CrossRefPubMedPubMedCentral
14.
go back to reference Williams NP, Coombs NA, Johnson MJ, Josephs LK, Rigge LA, Staples KJ, Thomas M, Wilkinson TM. Seasonality, risk factors and burden of community-acquired pneumonia in COPD patients: a population database study using linked health care records. Int J Chron Obstruct Pulmon Dis. 2017;12:313–22.CrossRefPubMedPubMedCentral Williams NP, Coombs NA, Johnson MJ, Josephs LK, Rigge LA, Staples KJ, Thomas M, Wilkinson TM. Seasonality, risk factors and burden of community-acquired pneumonia in COPD patients: a population database study using linked health care records. Int J Chron Obstruct Pulmon Dis. 2017;12:313–22.CrossRefPubMedPubMedCentral
15.
go back to reference Kerr M, Bedford M, Matthews B, O'Donoghue D. The economic impact of acute kidney injury in England. Nephrol Dial Transplant. 2014;29(7):1362–8.CrossRefPubMed Kerr M, Bedford M, Matthews B, O'Donoghue D. The economic impact of acute kidney injury in England. Nephrol Dial Transplant. 2014;29(7):1362–8.CrossRefPubMed
16.
go back to reference Lafrance JP, Djurdjev O, Levin A. Incidence and outcomes of acute kidney injury in a referred chronic kidney disease cohort. Nephrol Dial Transplant. 2010;25(7):2203–9.CrossRefPubMed Lafrance JP, Djurdjev O, Levin A. Incidence and outcomes of acute kidney injury in a referred chronic kidney disease cohort. Nephrol Dial Transplant. 2010;25(7):2203–9.CrossRefPubMed
17.
go back to reference Selby NM, Crowley L, Fluck RJ, McIntyre CW, Monaghan J, Lawson N, Kolhe NV. Use of electronic results reporting to diagnose and monitor AKI in hospitalized patients. Clin J Am Soc Nephrol. 2012;7(4):533–40.CrossRefPubMed Selby NM, Crowley L, Fluck RJ, McIntyre CW, Monaghan J, Lawson N, Kolhe NV. Use of electronic results reporting to diagnose and monitor AKI in hospitalized patients. Clin J Am Soc Nephrol. 2012;7(4):533–40.CrossRefPubMed
18.
go back to reference Siew ED, Matheny ME, Ikizler TA, Lewis JB, Miller RA, Waitman LR, Go AS, Parikh CR, Peterson JF. Commonly used surrogates for baseline renal function affect the classification and prognosis of acute kidney injury. Kidney Int. 2010;77(6):536–42.CrossRefPubMed Siew ED, Matheny ME, Ikizler TA, Lewis JB, Miller RA, Waitman LR, Go AS, Parikh CR, Peterson JF. Commonly used surrogates for baseline renal function affect the classification and prognosis of acute kidney injury. Kidney Int. 2010;77(6):536–42.CrossRefPubMed
19.
go back to reference Siew ED, Peterson JF, Eden SK, Moons KG, Ikizler TA, Matheny ME. Use of multiple imputation method to improve estimation of missing baseline serum creatinine in acute kidney injury research. Clin J Am Soc Nephrol. 2013;8(1):10–8.CrossRefPubMed Siew ED, Peterson JF, Eden SK, Moons KG, Ikizler TA, Matheny ME. Use of multiple imputation method to improve estimation of missing baseline serum creatinine in acute kidney injury research. Clin J Am Soc Nephrol. 2013;8(1):10–8.CrossRefPubMed
20.
go back to reference Závada J, Hoste E, Cartin-Ceba R, Calzavacca P, Gajic O, Clermont G, Bellomo R, Kellum JA. A comparison of three methods to estimate baseline creatinine for RIFLE classification. Nephrol Dial Transplant. 2010;25(12):3911–8.CrossRefPubMed Závada J, Hoste E, Cartin-Ceba R, Calzavacca P, Gajic O, Clermont G, Bellomo R, Kellum JA. A comparison of three methods to estimate baseline creatinine for RIFLE classification. Nephrol Dial Transplant. 2010;25(12):3911–8.CrossRefPubMed
21.
go back to reference Sawhney S, Marks A, Ali T, Clark L, Fluck N, Prescott GJ, Simpson WG, Black C. Maximising acute kidney injury alerts--a cross-sectional comparison with the clinical diagnosis. PLoS One. 2015;10(6):e0131909.CrossRefPubMedPubMedCentral Sawhney S, Marks A, Ali T, Clark L, Fluck N, Prescott GJ, Simpson WG, Black C. Maximising acute kidney injury alerts--a cross-sectional comparison with the clinical diagnosis. PLoS One. 2015;10(6):e0131909.CrossRefPubMedPubMedCentral
22.
go back to reference Sawhney S, Fluck N, Fraser SD, Marks A, Prescott GJ, Roderick PJ, Black C. KDIGO-based acute kidney injury criteria operate differently in hospitals and the community-findings from a large population cohort. Nephrol Dial Transplant. 2016;31(6):922–9.CrossRefPubMedPubMedCentral Sawhney S, Fluck N, Fraser SD, Marks A, Prescott GJ, Roderick PJ, Black C. KDIGO-based acute kidney injury criteria operate differently in hospitals and the community-findings from a large population cohort. Nephrol Dial Transplant. 2016;31(6):922–9.CrossRefPubMedPubMedCentral
23.
go back to reference Sawhney S, Fluck N, Marks A, Prescott G, Simpson W, Tomlinson L, Black C. Acute kidney injury-how does automated detection perform? Nephrol Dial Transplant. 2015;30(11):1853–61.CrossRefPubMedPubMedCentral Sawhney S, Fluck N, Marks A, Prescott G, Simpson W, Tomlinson L, Black C. Acute kidney injury-how does automated detection perform? Nephrol Dial Transplant. 2015;30(11):1853–61.CrossRefPubMedPubMedCentral
24.
go back to reference Dobbins TA, Badgery-Parker T, Currow DC, Young JM. Assessing measures of comorbidity and functional status for risk adjustment to compare hospital performance for colorectal cancer surgery: a retrospective data-linkage study. BMC Med Inform Decis Mak. 2015;15:55.CrossRefPubMedPubMedCentral Dobbins TA, Badgery-Parker T, Currow DC, Young JM. Assessing measures of comorbidity and functional status for risk adjustment to compare hospital performance for colorectal cancer surgery: a retrospective data-linkage study. BMC Med Inform Decis Mak. 2015;15:55.CrossRefPubMedPubMedCentral
25.
go back to reference Michalakidis G, Kumarapeli P, Ring A, van Vlymen J, Krause P, de Lusignan S. A system for solution-orientated reporting of errors associated with the extraction of routinely collected clinical data for research and quality improvement. Stud Health Technol Inform. 2010;160:724–8.PubMed Michalakidis G, Kumarapeli P, Ring A, van Vlymen J, Krause P, de Lusignan S. A system for solution-orientated reporting of errors associated with the extraction of routinely collected clinical data for research and quality improvement. Stud Health Technol Inform. 2010;160:724–8.PubMed
26.
go back to reference van Vlymen J, de Lusignan S, Hague N, Chan T, Dzregah B. Ensuring the quality of aggregated general practice data: lessons from the primary care data quality Programme (PCDQ). Stud Health Technol Inform. 2005;116:1010–5.PubMed van Vlymen J, de Lusignan S, Hague N, Chan T, Dzregah B. Ensuring the quality of aggregated general practice data: lessons from the primary care data quality Programme (PCDQ). Stud Health Technol Inform. 2005;116:1010–5.PubMed
27.
go back to reference John A, McGregor J, Fone D, Dunstan F, Cornish R, Lyons RA, Lloyd KR. Case-finding for common mental disorders of anxiety and depression in primary care: an external validation of routinely collected data. BMC Med Inform Decis Mak. 2016;16:35.CrossRefPubMedPubMedCentral John A, McGregor J, Fone D, Dunstan F, Cornish R, Lyons RA, Lloyd KR. Case-finding for common mental disorders of anxiety and depression in primary care: an external validation of routinely collected data. BMC Med Inform Decis Mak. 2016;16:35.CrossRefPubMedPubMedCentral
28.
go back to reference Millett ER, Quint JK, De Stavola BL, Smeeth L, Thomas SL. Improved incidence estimates from linked vs. stand-alone electronic health records. J Clin Epidemiol. 2016;75:66–9.CrossRefPubMedPubMedCentral Millett ER, Quint JK, De Stavola BL, Smeeth L, Thomas SL. Improved incidence estimates from linked vs. stand-alone electronic health records. J Clin Epidemiol. 2016;75:66–9.CrossRefPubMedPubMedCentral
29.
go back to reference de Lusignan S, van Weel C. The use of routinely collected computer data for research in primary care: opportunities and challenges. Fam Pract. 2006;23(2):253–63.CrossRefPubMed de Lusignan S, van Weel C. The use of routinely collected computer data for research in primary care: opportunities and challenges. Fam Pract. 2006;23(2):253–63.CrossRefPubMed
30.
go back to reference Berndt DJ, Fisher JW, Hevner AR, Studnicki J. Healthcare data warehousing and quality assurance. IEEE Computer. 2001;34(12):56–65.CrossRef Berndt DJ, Fisher JW, Hevner AR, Studnicki J. Healthcare data warehousing and quality assurance. IEEE Computer. 2001;34(12):56–65.CrossRef
Metadata
Title
Using a linked database for epidemiology across the primary and secondary care divide: acute kidney injury
Authors
M. Johnson
H. Hounkpatin
S. Fraser
D. Culliford
M. Uniacke
P. Roderick
Publication date
01-12-2017
Publisher
BioMed Central
Published in
BMC Medical Informatics and Decision Making / Issue 1/2017
Electronic ISSN: 1472-6947
DOI
https://doi.org/10.1186/s12911-017-0503-8

Other articles of this Issue 1/2017

BMC Medical Informatics and Decision Making 1/2017 Go to the issue