Cognitive development Respiratory Tract Illness and Effects of eXposure (CORTEX) project: Combining high spatial resolution pollution measurements with individual level data, a methodological approach.
Introduction The Secure Anonymised Information Linkage (SAIL) databank facilitated linkage of routinely collected health and education data, high spatial resolution pollution modelling and daily pollen measurements for 18,241 pupils in 7 cross-sectional cohorts across Cardiff city, UK, to investigat...
| Main Authors: | , , , , , , , , , , , , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Swansea University
2018-08-01
|
| Series: | International Journal of Population Data Science |
| Online Access: | https://ijpds.org/article/view/802 |
| _version_ | 1797427071206555648 |
|---|---|
| author | Sarah Rodgers Jane Lyons Amy Mizen Damon Berridge Ashley Akbari David Carruthers Gwyneth Davies Lorraine Dearden Ruth Doherty Iain Lake Anna Mavrogianni Ai Milojevic Sarah Strickland Paul Wilkinson |
| author_facet | Sarah Rodgers Jane Lyons Amy Mizen Damon Berridge Ashley Akbari David Carruthers Gwyneth Davies Lorraine Dearden Ruth Doherty Iain Lake Anna Mavrogianni Ai Milojevic Sarah Strickland Paul Wilkinson |
| author_sort | Sarah Rodgers |
| collection | DOAJ |
| description | Introduction
The Secure Anonymised Information Linkage (SAIL) databank facilitated linkage of routinely collected health and education data, high spatial resolution pollution modelling and daily pollen measurements for 18,241 pupils in 7 cross-sectional cohorts across Cardiff city, UK, to investigate effects of air quality and respiratory health conditions on education attainment.
Objectives and Approach
An urban atmospheric dispersion and chemistry modelling system (ADMS-Urban) simulated modelled hourly concentrations of air pollutants: PM2.5, PM10, NO2 and ozone levels. These were summarised into minimum, average and maximum daily readings for 4 time periods (e.g. school hours 9am-3pm) for all home and school locations across Cardiff between 2009 and 2015. The combination of different pollutants, measurements and time-periods created a comprehensive multi-row dataset per location. We transformed the dimensionality of this high-resolution data to create one row of summarised data per pupil per cohort, in preparation for statistical analysis.
Results
157,361 school and home locations across Cardiff were anonymised and household linkage fields were appended to combine pollution estimates at the household/school to individual health data. The pollution dataset contained 369 columns, 472,083 rows per year with one column per location, pollutant type, pollutant measurement, daily time-period, and day of year. Dataset transformation reduced algorithm computation by creating a single date column, producing a five column, 3,446,205,900-row matrix per year dataset. The algorithm adjusted for weekends, school/bank holidays and allowed location to vary 3pm-5pm on school days when pupil location was uncertain. The algorithm calculated tailored pollution exposures per pupil for revision and examination periods, creating one row per pupil and reducing 7 years of data and 24 billion rows to 18,241.
Conclusion/Implications
We successfully linked 95% of the cohorts’ household/school pollution data to their corresponding health and education data. This demonstrates data linking retrospective exposures for total populations using multiple daily locations, and extends our analysis platform for natural experiments to include daily exposure. Future work includes adding modelled route exposures. |
| first_indexed | 2024-03-09T08:40:04Z |
| format | Article |
| id | doaj.art-9200607c51ea47149573fe320e924561 |
| institution | Directory Open Access Journal |
| issn | 2399-4908 |
| language | English |
| last_indexed | 2024-03-09T08:40:04Z |
| publishDate | 2018-08-01 |
| publisher | Swansea University |
| record_format | Article |
| series | International Journal of Population Data Science |
| spelling | doaj.art-9200607c51ea47149573fe320e9245612023-12-02T17:15:04ZengSwansea UniversityInternational Journal of Population Data Science2399-49082018-08-013410.23889/ijpds.v3i4.802802Cognitive development Respiratory Tract Illness and Effects of eXposure (CORTEX) project: Combining high spatial resolution pollution measurements with individual level data, a methodological approach.Sarah Rodgers0Jane Lyons1Amy Mizen2Damon Berridge3Ashley Akbari4David Carruthers5Gwyneth Davies6Lorraine Dearden7Ruth Doherty8Iain Lake9Anna Mavrogianni10Ai Milojevic11Sarah Strickland12Paul Wilkinson13Swansea University Medical SchoolFarr Institute, Swansea UniversityFarr Institute, Swansea University Medical SchoolFarr Institute, Swansea University Medical SchoolHealth Data Research UK - Wales and Northern Ireland, Swansea University Medical SchoolCambridge Environmental Research ConsultantsSwansea University Medical SchoolInstitute of Fiscal StudiesUniversity of EdinburghUniversity of East AngliaUniversity College LondonLondon School of Hygiene and Tropical MedicineCambridge Environmental Research ConsultantsLondon School of Hygiene and Tropical MedicineIntroduction The Secure Anonymised Information Linkage (SAIL) databank facilitated linkage of routinely collected health and education data, high spatial resolution pollution modelling and daily pollen measurements for 18,241 pupils in 7 cross-sectional cohorts across Cardiff city, UK, to investigate effects of air quality and respiratory health conditions on education attainment. Objectives and Approach An urban atmospheric dispersion and chemistry modelling system (ADMS-Urban) simulated modelled hourly concentrations of air pollutants: PM2.5, PM10, NO2 and ozone levels. These were summarised into minimum, average and maximum daily readings for 4 time periods (e.g. school hours 9am-3pm) for all home and school locations across Cardiff between 2009 and 2015. The combination of different pollutants, measurements and time-periods created a comprehensive multi-row dataset per location. We transformed the dimensionality of this high-resolution data to create one row of summarised data per pupil per cohort, in preparation for statistical analysis. Results 157,361 school and home locations across Cardiff were anonymised and household linkage fields were appended to combine pollution estimates at the household/school to individual health data. The pollution dataset contained 369 columns, 472,083 rows per year with one column per location, pollutant type, pollutant measurement, daily time-period, and day of year. Dataset transformation reduced algorithm computation by creating a single date column, producing a five column, 3,446,205,900-row matrix per year dataset. The algorithm adjusted for weekends, school/bank holidays and allowed location to vary 3pm-5pm on school days when pupil location was uncertain. The algorithm calculated tailored pollution exposures per pupil for revision and examination periods, creating one row per pupil and reducing 7 years of data and 24 billion rows to 18,241. Conclusion/Implications We successfully linked 95% of the cohorts’ household/school pollution data to their corresponding health and education data. This demonstrates data linking retrospective exposures for total populations using multiple daily locations, and extends our analysis platform for natural experiments to include daily exposure. Future work includes adding modelled route exposures.https://ijpds.org/article/view/802 |
| spellingShingle | Sarah Rodgers Jane Lyons Amy Mizen Damon Berridge Ashley Akbari David Carruthers Gwyneth Davies Lorraine Dearden Ruth Doherty Iain Lake Anna Mavrogianni Ai Milojevic Sarah Strickland Paul Wilkinson Cognitive development Respiratory Tract Illness and Effects of eXposure (CORTEX) project: Combining high spatial resolution pollution measurements with individual level data, a methodological approach. International Journal of Population Data Science |
| title | Cognitive development Respiratory Tract Illness and Effects of eXposure (CORTEX) project: Combining high spatial resolution pollution measurements with individual level data, a methodological approach. |
| title_full | Cognitive development Respiratory Tract Illness and Effects of eXposure (CORTEX) project: Combining high spatial resolution pollution measurements with individual level data, a methodological approach. |
| title_fullStr | Cognitive development Respiratory Tract Illness and Effects of eXposure (CORTEX) project: Combining high spatial resolution pollution measurements with individual level data, a methodological approach. |
| title_full_unstemmed | Cognitive development Respiratory Tract Illness and Effects of eXposure (CORTEX) project: Combining high spatial resolution pollution measurements with individual level data, a methodological approach. |
| title_short | Cognitive development Respiratory Tract Illness and Effects of eXposure (CORTEX) project: Combining high spatial resolution pollution measurements with individual level data, a methodological approach. |
| title_sort | cognitive development respiratory tract illness and effects of exposure cortex project combining high spatial resolution pollution measurements with individual level data a methodological approach |
| url | https://ijpds.org/article/view/802 |
| work_keys_str_mv | AT sarahrodgers cognitivedevelopmentrespiratorytractillnessandeffectsofexposurecortexprojectcombininghighspatialresolutionpollutionmeasurementswithindividualleveldataamethodologicalapproach AT janelyons cognitivedevelopmentrespiratorytractillnessandeffectsofexposurecortexprojectcombininghighspatialresolutionpollutionmeasurementswithindividualleveldataamethodologicalapproach AT amymizen cognitivedevelopmentrespiratorytractillnessandeffectsofexposurecortexprojectcombininghighspatialresolutionpollutionmeasurementswithindividualleveldataamethodologicalapproach AT damonberridge cognitivedevelopmentrespiratorytractillnessandeffectsofexposurecortexprojectcombininghighspatialresolutionpollutionmeasurementswithindividualleveldataamethodologicalapproach AT ashleyakbari cognitivedevelopmentrespiratorytractillnessandeffectsofexposurecortexprojectcombininghighspatialresolutionpollutionmeasurementswithindividualleveldataamethodologicalapproach AT davidcarruthers cognitivedevelopmentrespiratorytractillnessandeffectsofexposurecortexprojectcombininghighspatialresolutionpollutionmeasurementswithindividualleveldataamethodologicalapproach AT gwynethdavies cognitivedevelopmentrespiratorytractillnessandeffectsofexposurecortexprojectcombininghighspatialresolutionpollutionmeasurementswithindividualleveldataamethodologicalapproach AT lorrainedearden cognitivedevelopmentrespiratorytractillnessandeffectsofexposurecortexprojectcombininghighspatialresolutionpollutionmeasurementswithindividualleveldataamethodologicalapproach AT ruthdoherty cognitivedevelopmentrespiratorytractillnessandeffectsofexposurecortexprojectcombininghighspatialresolutionpollutionmeasurementswithindividualleveldataamethodologicalapproach AT iainlake cognitivedevelopmentrespiratorytractillnessandeffectsofexposurecortexprojectcombininghighspatialresolutionpollutionmeasurementswithindividualleveldataamethodologicalapproach AT annamavrogianni cognitivedevelopmentrespiratorytractillnessandeffectsofexposurecortexprojectcombininghighspatialresolutionpollutionmeasurementswithindividualleveldataamethodologicalapproach AT aimilojevic cognitivedevelopmentrespiratorytractillnessandeffectsofexposurecortexprojectcombininghighspatialresolutionpollutionmeasurementswithindividualleveldataamethodologicalapproach AT sarahstrickland cognitivedevelopmentrespiratorytractillnessandeffectsofexposurecortexprojectcombininghighspatialresolutionpollutionmeasurementswithindividualleveldataamethodologicalapproach AT paulwilkinson cognitivedevelopmentrespiratorytractillnessandeffectsofexposurecortexprojectcombininghighspatialresolutionpollutionmeasurementswithindividualleveldataamethodologicalapproach |