Linking administrative data sets of inpatient infectious diseases diagnoses in far North Queensland: a cohort profile
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 Classifi...
Saved in:
| Main Authors: | , , , , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
BMJ Publishing Group
2020-03-01
|
| Series: | BMJ Open |
| Online Access: | https://bmjopen.bmj.com/content/10/3/e034845.full |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1846138691232202752 |
|---|---|
| author | Damon P Eisen Emma S McBryde Luke Vasanthakumar Matthew Murray Miriam Harings Oyelola Adegboye |
| author_facet | Damon P Eisen Emma S McBryde Luke Vasanthakumar Matthew Murray Miriam Harings Oyelola Adegboye |
| author_sort | Damon P Eisen |
| collection | DOAJ |
| description | 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. |
| format | Article |
| id | doaj-art-94391b2128674b90b9c00a0a5d4789c2 |
| institution | Kabale University |
| issn | 2044-6055 |
| language | English |
| publishDate | 2020-03-01 |
| publisher | BMJ Publishing Group |
| record_format | Article |
| series | BMJ Open |
| spelling | doaj-art-94391b2128674b90b9c00a0a5d4789c22024-12-07T07:15:09ZengBMJ Publishing GroupBMJ Open2044-60552020-03-0110310.1136/bmjopen-2019-034845Linking administrative data sets of inpatient infectious diseases diagnoses in far North Queensland: a cohort profileDamon P Eisen0Emma S McBryde1Luke Vasanthakumar2Matthew Murray3Miriam Harings4Oyelola Adegboye5Infectious Diseases, Townsville Hospital and Health Service, Townsville, Queensland, AustraliaAustralian Institute of Tropical Health and Medicine, James Cook University, Townsville, Queensland, AustraliaInfectious Diseases, Townsville Hospital, Townsville, Queensland, AustraliaCommonline Pty Ltd, Townsville, Queensland, AustraliaInfectious Diseases, Townsville Hospital, Townsville, Queensland, Australia2 Menzies School of Health Research, Charles Darwin University, Darwin, Northern Territory, AustraliaPurpose 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.https://bmjopen.bmj.com/content/10/3/e034845.full |
| spellingShingle | Damon P Eisen Emma S McBryde Luke Vasanthakumar Matthew Murray Miriam Harings Oyelola Adegboye Linking administrative data sets of inpatient infectious diseases diagnoses in far North Queensland: a cohort profile BMJ Open |
| title | Linking administrative data sets of inpatient infectious diseases diagnoses in far North Queensland: a cohort profile |
| title_full | Linking administrative data sets of inpatient infectious diseases diagnoses in far North Queensland: a cohort profile |
| title_fullStr | Linking administrative data sets of inpatient infectious diseases diagnoses in far North Queensland: a cohort profile |
| title_full_unstemmed | Linking administrative data sets of inpatient infectious diseases diagnoses in far North Queensland: a cohort profile |
| title_short | Linking administrative data sets of inpatient infectious diseases diagnoses in far North Queensland: a cohort profile |
| title_sort | linking administrative data sets of inpatient infectious diseases diagnoses in far north queensland a cohort profile |
| url | https://bmjopen.bmj.com/content/10/3/e034845.full |
| work_keys_str_mv | AT damonpeisen linkingadministrativedatasetsofinpatientinfectiousdiseasesdiagnosesinfarnorthqueenslandacohortprofile AT emmasmcbryde linkingadministrativedatasetsofinpatientinfectiousdiseasesdiagnosesinfarnorthqueenslandacohortprofile AT lukevasanthakumar linkingadministrativedatasetsofinpatientinfectiousdiseasesdiagnosesinfarnorthqueenslandacohortprofile AT matthewmurray linkingadministrativedatasetsofinpatientinfectiousdiseasesdiagnosesinfarnorthqueenslandacohortprofile AT miriamharings linkingadministrativedatasetsofinpatientinfectiousdiseasesdiagnosesinfarnorthqueenslandacohortprofile AT oyelolaadegboye linkingadministrativedatasetsofinpatientinfectiousdiseasesdiagnosesinfarnorthqueenslandacohortprofile |