Publication: Karlinsky & Kobak, 2021, Tracking excess mortality across countries during the COVID-19 pandemic with the World Mortality Dataset. eLife 10:e69336. https://elifesciences.org/articles/69336.
See the elife2021 folder for reproducible analysis from the paper. The figures shown below are being continuously updated after the publication.
Analysis code: all-countries.ipynb (can be run in Colab).
The data are sourced from the World Mortality Dataset. Excess mortality is computed relative to the baseline obtained using linear extrapolation of the 2015–19 trend. In each subplot in the figure below, gray lines are 2015–19, black line is baseline for 2020, red line is 2020, blue line is 2021. Countries are sorted by the % increase over the baseline.
Red number: excess mortality starting from the first officially reported Covid-19 death.
Gray number: excess mortality as a % of the annual baseline deaths.
Black number: excess mortality per 100,000 population.
Blue number: ratio to the daily reported Covid-19 deaths over the same period (sourced from WHO).
The same data but now represented as the number of deaths per 1000 people per year, and with countries sorted accordingly:
Top-10 countries in the World Mortality Dataset according to different metrics (only countries with over 500,000 population are shown):
See full table in CSV: excess-mortality.csv.
Compare with: FT, NYT, The Economist, WSJ.
Tracking of excess mortality and official Covid deaths:
Daily reported Covid-19 mortality and estimated excess mortality across the countries with the most reported Covid-19 deaths. Note that in this figure the excess mortality in all countries is FORECASTED using the undercount coefficient and the LATEST daily reported number of deaths. So this corresponds to the gray markers in the figure above.
The code for my February 2021 paper in Significance Excess mortality reveals Covid's true toll in Russia is available in the significance2021 folder, together with the frozen data and the final figures.
Figures below are updated every month. The up-to-date data can be found in the russian-data folder. Code: russia.ipynb
Note that around 10 thousand excess deaths in July in the Ural region and West Siberia could have been due to the heat wave.
Animation (English):
Animation (Russian):
Map (English):
Map (Russian):
Without regions:
Yearly deaths:
Back in 2019 Rosttat made forecast for 2020 (xls): 1.7890 million deaths (1.7413--1.8304). The actual number in 2019 was 1,800,683. The actual number in 2020 was 2,124,479. The excess compared to their forecast is 335 thousand. For reference, my linear forecast is 1.7660.
Detailed statistics in regions with the most excess deaths:
Extrapolation of the linear trend:
Seasonal variation:
Evolution of the undercount coefficient:
