The first wave of the pandemic hit Italy the hardest.
The government suspended all non-urgent health care. I collected data from hundreds of hospital and local NHS agencies to measure the impact of this decision. The country performed one third of the scheduled surgeries and only 10 per cent of breast and colon cancer screenings.
I also collected data on infected NHS personnel and ICU admissions at hospital level (best we have from the government is at regional level).
Data show no correlation between the pandemic impact and healthcare referral.
This project is a one of a kind in Italy. It was funded by novelist Paolo Giordano, through a scolarship at Sissa in Trieste, Italy.
It provides, so far, the most detailed database on the pandemics impact on healthcare, healthcare personnel infections and ICU admissions.
I filed 200 Foia request.
I used tabula to extract data from pdfs
I built my dataset with Google sheets
I used Tableau Public to visualize them
I ued GitHub to let data available to everyone
What was the hardest part of this project?
Italy’ public administration is not renowned for its efficiency and digital skills. I had to file 200 Foia requests, receiving data in different formats. The pandemic and the vaccinal campaign didn’t help in making local NHS more cooperative.
It took me eight months (and quite a lot of patience 🙂 ) to collect the data.
What can others learn from this project?
Using Foia to collect information from the public sector is not a common practice in Italian newsrooms. The same can be said for a data driven approach to reporting news.
I think fellow Italian journalist can learn a work method.