Datasets: Air pollutants PM2.5, PM10, NO2, and ozone levels were modelled for 157,361 home and school locations, anonymised into the Secure Anonymised Information Linkage (SAIL) Databank, and summarised into minimum, average and maximum readings for 4 daily time periods reflecting pupil home/school exposure. Adding a unique Residential Anonymised Linking Field (RALF) allowed linkage of pollution estimates to individual level data. Annual pollution datasets contained 369 columns and 472,083-rows, with one column per location, pollutant, daily time-period and day of year. Dataset transformation produced a 5 column, 3,446,205,900-row matrix per year.
Methods and Conclusions: An algorithm using Structured Query Language (SQL) to manage data held within a relational database management system, was designed to reduce dimensionality from 24 billion to 18,241 rows of data. The algorithm calculated average means for each pollutant (PM2.5, PM10, NO2, and ozone levels) over the revision and examination periods, and summarised data into one row per pupil. The algorithm adjusted for weekends, school, and bank holidays, it calculated daily pollutant exposure for each pupil, and successfully linked 95% of pupil pollution exposures to their health and education data.