GCHU Report: Preventable deaths in Oxford and Oxfordshire

GCHU is pleased to share the report: ‘Preventable deaths in Oxford and Oxfordshire‘ written by Joshua Loo and Georgia Richards.

GCHU is pleased to share the report: ‘Preventable deaths in Oxford and Oxfordshire‘ written by Joshua Loo and Georgia Richards.

Joshua Loo was a Research Analyst at the GCHU in September 2021 as part of the Micro-Internship programme run by the University of Oxford’s Careers Service.

I’ve had plenty of interesting work to do this week. We were tasked with analysing coroners’ reports in a particular area (i.e. Oxford) and writing a report. I also wrote code to automate some of my analysis and I improved and modified the web scraper that collects data for the Preventable Deaths Database. I added features so that it counts the responses as well as the expected responses to Prevention of Future Death reports. I wrote code that automatically displays plots that show how many reports have been sent over time and what the response rate is. Most bizarrely, I’ve written a tome of rather inelegant regex to correct the typos in the area field on the reports: it doesn’t help that there have been several mergers over the past decades. Georgia has been delightful to work with, and was very accommodating in allowing me to get my hands on the database itself; hopefully some of what I’ve done will be useful in future.

Joshua Loo, GCHU Micro-Internship Research Analyst

Read more about our award-winning internship opportunities on recent blog.