Linking administrative data sets of inpatient infectious diseases diagnoses in far North Queensland: a cohort profile

Eisen, Damon P., McBryde, Emma S., Vasanthakumar, Luke, Murray, Matthew, Harings, Miriam, and Adegboye, Oyelola (2020) Linking administrative data sets of inpatient infectious diseases diagnoses in far North Queensland: a cohort profile. BMJ Open, 10. e034845.

PDF (Published Version) - Published Version
Available under License Creative Commons Attribution Non-commercial.

Download (2MB) | Preview
View at Publisher Website:


Purpose: To design a linked hospital database using administrative and clinical information to describe associations that predict infectious diseases outcomes, including long-term mortality.

Participants: A retrospective cohort of Townsville Hospital inpatients discharged with an International Classification of Diseases and Related Health Problems 10th Revision Australian Modification code for an infectious disease between 1 January 2006 and 31 December 2016 was assembled. This used linked anonymised data from: hospital administrative sources, diagnostic pathology, pharmacy dispensing, public health and the National Death Registry. A Created Study ID was used as the central identifier to provide associations between the cohort patients and the subsets of granular data which were processed into a relational database. A web-based interface was constructed to allow data extraction and evaluation to be performed using editable Structured Query Language.

Findings to date: The database has linked information on 41 367 patients with 378 487 admissions and 1 869 239 diagnostic/procedure codes. Scripts used to create the database contents generated over 24 000 000 database rows from the supplied data. Nearly 15% of the cohort was identified as Aboriginal or Torres Strait Islanders. Invasive staphylococcal, pneumococcal and Group A streptococcal infections and influenza were common in this cohort. The most common comorbidities were smoking (43.95%), diabetes (24.73%), chronic renal disease (17.93%), cancer (16.45%) and chronic pulmonary disease (12.42%). Mortality over the 11-year period was 20%.

Future plans: This complex relational database reutilising hospital information describes a cohort from a single tropical Australian hospital of inpatients with infectious diseases. In future analyses, we plan to explore analyses of risks, clinical outcomes, healthcare costs and antimicrobial side effects in site and organism specific infections.

Item ID: 65429
Item Type: Article (Research - C1)
ISSN: 2044-6055
Copyright Information: © Author(s) (or their employer(s)) 2020. Re-use permitted under CC BY-NC. No commercial re-use. See rights and permissions. Published by BMJ.
Funders: Townsville Hospital and Health Services Study Education Research Trust
Date Deposited: 05 Jan 2021 23:34
FoR Codes: 42 HEALTH SCIENCES > 4203 Health services and systems > 420308 Health informatics and information systems @ 40%
32 BIOMEDICAL AND CLINICAL SCIENCES > 3202 Clinical sciences > 320211 Infectious diseases @ 40%
40 ENGINEERING > 4006 Communications engineering > 400602 Data communications @ 20%
SEO Codes: 92 HEALTH > 9201 Clinical Health (Organs, Diseases and Abnormal Conditions) > 920109 Infectious Diseases @ 100%
Downloads: Total: 866
Last 12 Months: 58
More Statistics

Actions (Repository Staff Only)

Item Control Page Item Control Page