John Burn-Murdoch+ Your Authors @jburnmurdoch Stories, stats & scatterplots for @FinancialTimes | Daily updates of the coronavirus trajectory tracker | john.b[email protected] | #dataviz Jun. 01, 2020 1 min read + Your Authors

NEW: we’re pleased to announce all of our excess deaths data is now public, in CSV format  https://github.com/Financial-Times/coronavirus-excess-mortality-data 

• Data for 24 countries and counting
• Down to regions/cities in many cases
• Includes numbers for Italy through to end of April

We’re not the only ones collecting and publishing this data.

Worth checking out the resources already published by @J_CD_T & co at @TheEconomist ( https://github.com/TheEconomist/covid-19-excess-deaths-tracker ) and @atmccann & co at @nytimes ( https://github.com/nytimes/covid-19-data/tree/master/excess-deaths )

We’ve already shared this data directly with academics, but we’re taking the step to make it completely public today so that more people can dig into the numbers, combine with their own datasets etc.

Now for a peak behind-the-scenes:

In some cases the data was easy to come-by, with national statistical bodies like @ONS making timely mortality data readily available.

In others, it was trickier...

Last month Italy’s Social Security Institute published a report on deaths up to the end of April, but did not make the raw data available  https://www.inps.it/docallegatiNP/Mig/Dati_analisi_bilanci/Nota_CGSA_mortal_Covid19_def.pdf 

Undeterred, we traced it out of their PDF report using the brilliant Web Plot Digitizer  https://apps.automeris.io/wpd/ 

One day I will see some data online and won’t be able to find a way to extract it from the page, but that day is yet to arrive.


You can follow @jburnmurdoch.



Bookmark

____
Tip: mention @threader_app on a Twitter thread with the keyword “compile” to get a link to it.

Enjoy Threader? Sign up.

Since you’re here...

... we’re asking visitors like you to make a contribution to support this independent project. In these uncertain times, access to information is vital. Threader gets 1,000,000+ visits a month and our iOS Twitter client was featured as an App of the Day by Apple. Your financial support will help two developers to keep working on this app. Everyone’s contribution, big or small, is so valuable. Support Threader by becoming premium or by donating on PayPal. Thank you.


Follow Threader