ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Death rates in 2020 compared with previous years'
2
Working data for blog article: https://vaccinationdilemma.com/2021/04/06/covid-19-part-5-comparing-2020-death-rates-with-previous-years/
3
4
All sheets (except WSP) in this workbook have been derived from data downloaded from the following:
5
6
Human Mortality Database. Max Planck Institute for Demographic Research (Germany) and University of California, Berkeley (USA).
7
Available at www.mortality.org (data downloaded on March 26, 2021).
8
9
SHEETS
10
WSP: the World Standard Population (used as reference population for direct age-standardisation).
11
SummaryData: A table summarising key data from the 31 countries.
12
AUT — TWN: one sheet for each of the 31 countries in the analysis.
13
14
Tables 1 and 2 in the article can be found in the sheet KOR.
15
Table 3 in the article can be found in selected columns of the sheet SummaryData.
16
17
DATA
18
The data found in each of the 31 sheets representing countries (AUT — TWN) was derived by importing the STMF.csv file (downloaded from www.mortality.org on March 26, 2021) into a database table, renaming the 'Year' field to 'Yr', then running the following SQL query:
19
20
SELECT
21
CountryCode, Yr,
22
AVG(R0_14)*1000 AS R0,
23
AVG(R15_64)*1000 AS R15,
24
AVG(R65_74)*1000 AS R65,
25
AVG(R75_84)*1000 AS R75,
26
AVG(R85p)*1000 AS R85,
27
AVG(RTotal)*1000 AS RTot
28
FROM <your_data_table_name>* WHERE Sex='b'
29
GROUP BY CountryCode, Yr
30
ORDER BY CountryCode, Yr
31
32
* Replace with the database table name chosen.
33
34
The required rows were then copied and pasted into each sheet in this workbook.
35
The ASR column for each country sheet was calculated via direct standardisation using the World Standard Population found in the sheet WSP.
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100