Exploring a novel linked dataset and building linked data analytics skills in Public Health Intelligence teams in Sussex.
Objectives Public health intelligence teams in Sussex wanted to use newly linked health and social care data, to gain insights into local patterns of multi-morbidity, service use, service provision and socio-demographic data. In this study we report initial exploration of this new linked dataset, in...
| Main Authors: | , , , , , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Swansea University
2022-08-01
|
| Series: | International Journal of Population Data Science |
| Subjects: | |
| Online Access: | https://ijpds.org/article/view/1937 |
| _version_ | 1797427166173986816 |
|---|---|
| author | Natalie Johnston Elizabeth Ford Richard Tyler Vicki Spencer-Hughes Anotida Madzvamuse Graham Evans Kate Gilchrist |
| author_facet | Natalie Johnston Elizabeth Ford Richard Tyler Vicki Spencer-Hughes Anotida Madzvamuse Graham Evans Kate Gilchrist |
| author_sort | Natalie Johnston |
| collection | DOAJ |
| description | Objectives
Public health intelligence teams in Sussex wanted to use newly linked health and social care data, to gain insights into local patterns of multi-morbidity, service use, service provision and socio-demographic data. In this study we report initial exploration of this new linked dataset, in a partnership between university and local authority analysts.
Approach
The Sussex Integrated Dataset (SID) comprises person-level health and social care data on residents and services users across Sussex. During a 6-month secondment, two analysts evaluated the number of data sources available for each individual, evaluated data quality for identifying long-term conditions, developed presentation methods to compare SID outputs on demographics and condition prevalence with open source or expected distributions, and identified the skills-mix and infrastructure required in local authorities for future work. They worked alongside the SID data processing team to inform and improve data quality; and with university data-scientists to learn prediction modelling.
Results
Analysts established an efficient querying system to investigate the breadth of data available, more thoroughly focusing on encounters and demographic data in all sources. Long-term conditions were identified through code lists in a range of NHS data sources, to enable consideration of multi-morbidity by demographic. A range of quality issues were identified, such as non-current patients being uploaded into the SID, distorting prevalence estimates, and GP practice populations that did not match expected figures published by NHS digital. Results were represented in multi-morbidity plots, maps, and theographs. Through this data exploration, we have been able to identify the skills-mix needed for local Public Health Intelligence teams to maximise the use of linked data to achieve Public Health objectives.
Conclusion
We have made many conceptual breakthroughs, particularly in understanding data quality, however still need a more complete understanding of quality issues in SID for public health outputs to have meaningful use. Further investigation into the patterns of service use, as well as modelling of multi-morbidity to make predictions and target interventions, will be key next steps.
|
| first_indexed | 2024-03-09T08:41:14Z |
| format | Article |
| id | doaj.art-b560d4a5301941be82f273ff03a1d77f |
| institution | Directory Open Access Journal |
| issn | 2399-4908 |
| language | English |
| last_indexed | 2024-03-09T08:41:14Z |
| publishDate | 2022-08-01 |
| publisher | Swansea University |
| record_format | Article |
| series | International Journal of Population Data Science |
| spelling | doaj.art-b560d4a5301941be82f273ff03a1d77f2023-12-02T17:01:49ZengSwansea UniversityInternational Journal of Population Data Science2399-49082022-08-017310.23889/ijpds.v7i3.1937Exploring a novel linked dataset and building linked data analytics skills in Public Health Intelligence teams in Sussex.Natalie Johnston0Elizabeth Ford1Richard Tyler2Vicki Spencer-Hughes3Anotida Madzvamuse4Graham Evans5Kate Gilchrist6Brighton & Hove City CouncilBrighton and Sussex Medical SchoolWest Sussex County CouncilEast Sussex County CouncilUniversity of SussexEast Sussex County CouncilBrighton & Hove City CouncilObjectives Public health intelligence teams in Sussex wanted to use newly linked health and social care data, to gain insights into local patterns of multi-morbidity, service use, service provision and socio-demographic data. In this study we report initial exploration of this new linked dataset, in a partnership between university and local authority analysts. Approach The Sussex Integrated Dataset (SID) comprises person-level health and social care data on residents and services users across Sussex. During a 6-month secondment, two analysts evaluated the number of data sources available for each individual, evaluated data quality for identifying long-term conditions, developed presentation methods to compare SID outputs on demographics and condition prevalence with open source or expected distributions, and identified the skills-mix and infrastructure required in local authorities for future work. They worked alongside the SID data processing team to inform and improve data quality; and with university data-scientists to learn prediction modelling. Results Analysts established an efficient querying system to investigate the breadth of data available, more thoroughly focusing on encounters and demographic data in all sources. Long-term conditions were identified through code lists in a range of NHS data sources, to enable consideration of multi-morbidity by demographic. A range of quality issues were identified, such as non-current patients being uploaded into the SID, distorting prevalence estimates, and GP practice populations that did not match expected figures published by NHS digital. Results were represented in multi-morbidity plots, maps, and theographs. Through this data exploration, we have been able to identify the skills-mix needed for local Public Health Intelligence teams to maximise the use of linked data to achieve Public Health objectives. Conclusion We have made many conceptual breakthroughs, particularly in understanding data quality, however still need a more complete understanding of quality issues in SID for public health outputs to have meaningful use. Further investigation into the patterns of service use, as well as modelling of multi-morbidity to make predictions and target interventions, will be key next steps. https://ijpds.org/article/view/1937Public Health IntelligenceLinked dataMulti-morbidityCapacity buildingData quality |
| spellingShingle | Natalie Johnston Elizabeth Ford Richard Tyler Vicki Spencer-Hughes Anotida Madzvamuse Graham Evans Kate Gilchrist Exploring a novel linked dataset and building linked data analytics skills in Public Health Intelligence teams in Sussex. International Journal of Population Data Science Public Health Intelligence Linked data Multi-morbidity Capacity building Data quality |
| title | Exploring a novel linked dataset and building linked data analytics skills in Public Health Intelligence teams in Sussex. |
| title_full | Exploring a novel linked dataset and building linked data analytics skills in Public Health Intelligence teams in Sussex. |
| title_fullStr | Exploring a novel linked dataset and building linked data analytics skills in Public Health Intelligence teams in Sussex. |
| title_full_unstemmed | Exploring a novel linked dataset and building linked data analytics skills in Public Health Intelligence teams in Sussex. |
| title_short | Exploring a novel linked dataset and building linked data analytics skills in Public Health Intelligence teams in Sussex. |
| title_sort | exploring a novel linked dataset and building linked data analytics skills in public health intelligence teams in sussex |
| topic | Public Health Intelligence Linked data Multi-morbidity Capacity building Data quality |
| url | https://ijpds.org/article/view/1937 |
| work_keys_str_mv | AT nataliejohnston exploringanovellinkeddatasetandbuildinglinkeddataanalyticsskillsinpublichealthintelligenceteamsinsussex AT elizabethford exploringanovellinkeddatasetandbuildinglinkeddataanalyticsskillsinpublichealthintelligenceteamsinsussex AT richardtyler exploringanovellinkeddatasetandbuildinglinkeddataanalyticsskillsinpublichealthintelligenceteamsinsussex AT vickispencerhughes exploringanovellinkeddatasetandbuildinglinkeddataanalyticsskillsinpublichealthintelligenceteamsinsussex AT anotidamadzvamuse exploringanovellinkeddatasetandbuildinglinkeddataanalyticsskillsinpublichealthintelligenceteamsinsussex AT grahamevans exploringanovellinkeddatasetandbuildinglinkeddataanalyticsskillsinpublichealthintelligenceteamsinsussex AT kategilchrist exploringanovellinkeddatasetandbuildinglinkeddataanalyticsskillsinpublichealthintelligenceteamsinsussex |