economist_excess_deaths

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette

6,924 rows

View and edit SQL

cadence

Link rowid ▼ country region region_code start_date end_date year month population total_deaths covid_deaths expected_deaths excess_deaths non_covid_deaths covid_deaths_per_100k excess_deaths_per_100k excess_deaths_pct_change cadence week
101 Ecuador Morona Santiago EC-S 2020-01-01 2020-01-31 2020 1 192300 49 0 46.5 2.5 49 0.0 1.30005200208008 0.053763440860215 monthly  
102 Ecuador Morona Santiago EC-S 2020-02-01 2020-02-29 2020 2 192300 48 0 40.5 7.5 48 0.0 3.90015600624025 0.185185185185185 monthly  
103 Ecuador Morona Santiago EC-S 2020-03-01 2020-03-31 2020 3 192300 33 0 45.5 -12.5 33 0.0 -6.50026001040042 -0.274725274725275 monthly  
104 Ecuador Morona Santiago EC-S 2020-04-01 2020-04-30 2020 4 192300 23 0 45.0 -22.0 23 0.0 -11.4404576183047 -0.488888888888889 monthly  
105 Ecuador Morona Santiago EC-S 2020-05-01 2020-05-31 2020 5 192300 24 0 39.0 -15.0 24 0.0 -7.8003120124805 -0.384615384615385 monthly  
106 Ecuador Santo Domingo de los Tsáchilas EC-SD 2020-01-01 2020-01-31 2020 1 450700 204 0 207.5 -3.5 204 0.0 -0.776569780341691 -0.016867469879518 monthly  
107 Ecuador Santo Domingo de los Tsáchilas EC-SD 2020-02-01 2020-02-29 2020 2 450700 202 0 166.0 36.0 202 0.0 7.98757488351453 0.216867469879518 monthly  
108 Ecuador Santo Domingo de los Tsáchilas EC-SD 2020-03-01 2020-03-31 2020 3 450700 162 0 204.0 -42.0 162 0.0 -9.31883736410029 -0.205882352941177 monthly  
109 Ecuador Santo Domingo de los Tsáchilas EC-SD 2020-04-01 2020-04-30 2020 4 450700 239 0 184.5 54.5 239 0.0 12.0923008653206 0.295392953929539 monthly  
110 Ecuador Santo Domingo de los Tsáchilas EC-SD 2020-05-01 2020-05-31 2020 5 450700 256 0 186.0 70.0 256 0.0 15.5313956068338 0.376344086021505 monthly  
111 Ecuador Santa Elena EC-SE 2020-01-01 2020-01-31 2020 1 392600 116 0 111.0 5.0 116 0.0 1.27356087620988 0.045045045045045 monthly  
112 Ecuador Santa Elena EC-SE 2020-02-01 2020-02-29 2020 2 392600 113 0 107.0 6.0 113 0.0 1.52827305145186 0.0560747663551402 monthly  
113 Ecuador Santa Elena EC-SE 2020-03-01 2020-03-31 2020 3 392600 156 0 115.5 40.5 156 0.0 10.3158430973001 0.350649350649351 monthly  
114 Ecuador Santa Elena EC-SE 2020-04-01 2020-04-30 2020 4 392600 982 0 102.0 880.0 982 0.0 224.146714212939 8.62745098039216 monthly  
115 Ecuador Santa Elena EC-SE 2020-05-01 2020-05-31 2020 5 392600 310 0 100.0 210.0 310 0.0 53.4895568008151 2.1 monthly  
116 Ecuador Tungurahua EC-T 2020-01-01 2020-01-31 2020 1 584100 250 0 260.0 -10.0 250 0.0 -1.7120356103407 -0.0384615384615384 monthly  
117 Ecuador Tungurahua EC-T 2020-02-01 2020-02-29 2020 2 584100 235 0 219.0 16.0 235 0.0 2.73925697654511 0.0730593607305936 monthly  
118 Ecuador Tungurahua EC-T 2020-03-01 2020-03-31 2020 3 584100 215 0 241.5 -26.5 215 0.0 -4.53689436740284 -0.109730848861284 monthly  
119 Ecuador Tungurahua EC-T 2020-04-01 2020-04-30 2020 4 584100 260 0 208.5 51.5 260 0.0 8.81698339325458 0.247002398081535 monthly  
120 Ecuador Tungurahua EC-T 2020-05-01 2020-05-31 2020 5 584100 323 0 225.5 97.5 323 0.0 16.6923472008218 0.432372505543237 monthly  
121 Ecuador Sucumbíos EC-U 2020-01-01 2020-01-31 2020 1 225500 59 0 51.5 7.5 59 0.0 3.32594235033259 0.145631067961165 monthly  
122 Ecuador Sucumbíos EC-U 2020-02-01 2020-02-29 2020 2 225500 51 0 52.5 -1.5 51 0.0 -0.665188470066519 -0.0285714285714286 monthly  
123 Ecuador Sucumbíos EC-U 2020-03-01 2020-03-31 2020 3 225500 45 0 42.5 2.5 45 0.0 1.10864745011086 0.0588235294117647 monthly  
124 Ecuador Sucumbíos EC-U 2020-04-01 2020-04-30 2020 4 225500 50 0 56.0 -6.0 50 0.0 -2.66075388026608 -0.107142857142857 monthly  
125 Ecuador Sucumbíos EC-U 2020-05-01 2020-05-31 2020 5 225500 55 0 43.5 11.5 55 0.0 5.09977827050998 0.264367816091954 monthly  
126 Ecuador Galápagos EC-W 2020-01-01 2020-01-31 2020 1 32300 5 0 4.0 1.0 5 0.0 3.09597523219814 0.25 monthly  
127 Ecuador Galápagos EC-W 2020-02-01 2020-02-29 2020 2 32300 4 0 3.5 0.5 4 0.0 1.54798761609907 0.142857142857143 monthly  
128 Ecuador Galápagos EC-W 2020-03-01 2020-03-31 2020 3 32300 3 0 1.0 2.0 3 0.0 6.19195046439629 2.0 monthly  
129 Ecuador Galápagos EC-W 2020-04-01 2020-04-30 2020 4 32300 3 0 3.5 -0.5 3 0.0 -1.54798761609907 -0.142857142857143 monthly  
130 Ecuador Galápagos EC-W 2020-05-01 2020-05-31 2020 5 32300 1 0 4.0 -3.0 1 0.0 -9.28792569659443 -0.75 monthly  
131 Ecuador Cotopaxi EC-X 2020-01-01 2020-01-31 2020 1 482600 138 0 175.5 -37.5 138 0.0 -7.77041027766266 -0.213675213675214 monthly  
132 Ecuador Cotopaxi EC-X 2020-02-01 2020-02-29 2020 2 482600 156 0 137.0 19.0 156 0.0 3.93700787401575 0.138686131386861 monthly  
133 Ecuador Cotopaxi EC-X 2020-03-01 2020-03-31 2020 3 482600 146 0 152.5 -6.5 146 0.0 -1.34687111479486 -0.0426229508196722 monthly  
134 Ecuador Cotopaxi EC-X 2020-04-01 2020-04-30 2020 4 482600 151 0 146.0 5.0 151 0.0 1.03605470368835 0.0342465753424657 monthly  
135 Ecuador Cotopaxi EC-X 2020-05-01 2020-05-31 2020 5 482600 149 0 150.0 -1.0 149 0.0 -0.207210940737671 -0.00666666666666671 monthly  
136 Ecuador Pastaza EC-Y 2020-01-01 2020-01-31 2020 1 111300 34 0 23.5 10.5 34 0.0 9.43396226415094 0.446808510638298 monthly  
137 Ecuador Pastaza EC-Y 2020-02-01 2020-02-29 2020 2 111300 33 0 24.5 8.5 33 0.0 7.63701707097933 0.346938775510204 monthly  
138 Ecuador Pastaza EC-Y 2020-03-01 2020-03-31 2020 3 111300 22 0 26.5 -4.5 22 0.0 -4.04312668463612 -0.169811320754717 monthly  
139 Ecuador Pastaza EC-Y 2020-04-01 2020-04-30 2020 4 111300 22 0 25.5 -3.5 22 0.0 -3.14465408805031 -0.137254901960784 monthly  
140 Ecuador Pastaza EC-Y 2020-05-01 2020-05-31 2020 5 111300 16 0 19.5 -3.5 16 0.0 -3.14465408805031 -0.17948717948718 monthly  
141 Ecuador Zamora Chinchipe EC-Z 2020-01-01 2020-01-31 2020 1 117900 26 0 23.0 3.0 26 0.0 2.54452926208651 0.130434782608696 monthly  
142 Ecuador Zamora Chinchipe EC-Z 2020-02-01 2020-02-29 2020 2 117900 24 0 19.0 5.0 24 0.0 4.24088210347752 0.263157894736842 monthly  
143 Ecuador Zamora Chinchipe EC-Z 2020-03-01 2020-03-31 2020 3 117900 12 0 19.5 -7.5 12 0.0 -6.36132315521628 -0.384615384615385 monthly  
144 Ecuador Zamora Chinchipe EC-Z 2020-04-01 2020-04-30 2020 4 117900 19 0 22.5 -3.5 19 0.0 -2.96861747243427 -0.155555555555556 monthly  
145 Ecuador Zamora Chinchipe EC-Z 2020-05-01 2020-05-31 2020 5 117900 15 0 20.0 -5.0 15 0.0 -4.24088210347752 -0.25 monthly  
146 Indonesia Jakarta 0 2020-01-01 2020-01-31 2020 1 10770000 3303 0 2717.5 585.5 3303 0.0 5.4363974001857 0.215455381784729 monthly  
147 Indonesia Jakarta 0 2020-02-01 2020-02-29 2020 2 10770000 2744 0 2772.5 -28.5 2744 0.0 -0.264623955431755 -0.0102795311091073 monthly  
148 Indonesia Jakarta 0 2020-03-01 2020-03-31 2020 3 10770000 4422 84 3046.5 1375.5 4338 0.779944289693593 12.7715877437326 0.45150172328902 monthly  
149 Indonesia Jakarta 0 2020-04-01 2020-04-30 2020 4 10770000 4550 297 2967.5 1582.5 4253 2.75766016713092 14.6935933147632 0.533277169334457 monthly  
150 Indonesia Jakarta 0 2020-05-01 2020-05-31 2020 5 10770000 4355 139 2848.0 1507.0 4216 1.29062209842154 13.9925719591458 0.529143258426966 monthly  
151 Peru Peru PE 2020-01-01 2020-01-31 2020 1 32824358 9664 0 8610.66666666667 1053.33333333333 9664 0.0 3.20899904069208 0.12232889439455 monthly  
152 Peru Peru PE 2020-02-01 2020-02-29 2020 2 32824358 9176 0 8107.33333333333 1068.66666666667 9176 0.0 3.25571231786671 0.131814817860373 monthly  
153 Peru Peru PE 2020-03-01 2020-03-31 2020 3 32824358 9417 30 8958.0 459.0 9387 0.0913955422981921 1.39835179716234 0.051239115874079 monthly  
154 Peru Peru PE 2020-04-01 2020-04-30 2020 4 32824358 12373 1021 8293.0 4080.0 11352 3.11049495621514 12.4297937525541 0.49198118895454 monthly  
155 Peru Peru PE 2020-05-01 2020-05-31 2020 5 32824358 23825 3455 8787.0 15038.0 20370 10.5257199546751 45.8135388360071 1.71139182883806 monthly  
156 Russia Moscow 0 2020-01-01 2020-01-31 2020 1 12537954 10918 0 11358.2 -440.200000000001 10918 0.0 -3.51093966368038 -0.0387561409378248 monthly  
157 Russia Moscow 0 2020-02-01 2020-02-29 2020 2 12537954 9873 0 9931.2 -58.2000000000007 9873 0.0 -0.464190568891868 -0.00586031899468353 monthly  
158 Russia Moscow 0 2020-03-01 2020-03-31 2020 3 12537954 10250 0 10630.6 -380.6 10250 0.0 -3.0355829986296 -0.0358023065490189 monthly  
159 Russia Moscow 0 2020-04-01 2020-04-30 2020 4 12537954 11846 611 10125.8 1720.2 11235 4.87320339506749 13.7199418661131 0.169882873451974 monthly  
160 Russia Moscow 0 2020-05-01 2020-05-31 2020 5 12537954 15713 1866 9935.2 5777.8 13847 14.8828110232339 46.0824788478248 0.581548433851357 monthly  
161 Norway Norway 0 2020-01-01 2020-01-07 2020   5367580 860 0 924.4 -64.4 860       weekly 1
162 Norway Norway 0 2020-01-08 2020-01-14 2020   5367580 948 0 917.6 30.4 948       weekly 2
163 Norway Norway 0 2020-01-15 2020-01-21 2020   5367580 836 0 907.2 -71.2 836       weekly 3
164 Norway Norway 0 2020-01-22 2020-01-28 2020   5367580 862 0 884.8 -22.8 862       weekly 4
165 Norway Norway 0 2020-01-29 2020-02-04 2020   5367580 815 0 895.2 -80.2 815       weekly 5
166 Norway Norway 0 2020-02-05 2020-02-11 2020   5367580 796 0 864.0 -68.0 796       weekly 6
167 Norway Norway 0 2020-02-12 2020-02-18 2020   5367580 856 0 875.6 -19.6 856       weekly 7
168 Norway Norway 0 2020-02-19 2020-02-25 2020   5367580 811 0 867.6 -56.6 811       weekly 8
169 Norway Norway 0 2020-02-26 2020-03-03 2020   5367580 838 0 877.4 -39.4 838       weekly 9
170 Norway Norway 0 2020-03-04 2020-03-10 2020   5367580 796 0 868.4 -72.4 796       weekly 10
171 Norway Norway 0 2020-03-11 2020-03-17 2020   5367580 821 3 828.2 -7.20000000000005 818       weekly 11
172 Norway Norway 0 2020-03-18 2020-03-24 2020   5367580 802 7 817.0 -15.0 795       weekly 12
173 Norway Norway 0 2020-03-25 2020-03-31 2020   5367580 848 18 781.4 66.6 830       weekly 13
174 Norway Norway 0 2020-04-01 2020-04-07 2020   5367580 823 41 799.4 23.6 782       weekly 14
175 Norway Norway 0 2020-04-08 2020-04-14 2020   5367580 835 58 785.6 49.4 777       weekly 15
176 Norway Norway 0 2020-04-15 2020-04-21 2020   5367580 805 36 765.8 39.2 769       weekly 16
177 Norway Norway 0 2020-04-22 2020-04-28 2020   5367580 768 32 780.0 -12.0 736       weekly 17
178 Norway Norway 0 2020-04-29 2020-05-05 2020   5367580 743 14 741.6 1.39999999999998 729       weekly 18
179 Norway Norway 0 2020-05-06 2020-05-12 2020   5367580 733 19 736.4 -3.39999999999998 714       weekly 19
180 Norway Norway 0 2020-05-13 2020-05-19 2020   5367580 672 5 724.6 -52.6 667       weekly 20
181 Norway Norway 0 2020-05-20 2020-05-26 2020   5367580 724 2 732.2 -8.20000000000005 722       weekly 21
182 Norway Norway 0 2020-05-27 2020-06-02 2020   5367580 633 2 713.6 -80.6 631       weekly 22
183 Norway Norway 0 2020-06-03 2020-06-09 2020   5367580 624 2 714.2 -90.2 622       weekly 23
184 Sweden Sweden 0 2020-01-01 2020-01-07 2020   10338368 1879 0 1987.6 -108.6 1879       weekly 1
185 Sweden Sweden 0 2020-01-08 2020-01-14 2020   10338368 1866 0 1942.0 -76.0 1866       weekly 2
186 Sweden Sweden 0 2020-01-15 2020-01-21 2020   10338368 1789 0 1954.2 -165.2 1789       weekly 3
187 Sweden Sweden 0 2020-01-22 2020-01-28 2020   10338368 1794 0 1912.6 -118.6 1794       weekly 4
188 Sweden Sweden 0 2020-01-29 2020-02-04 2020   10338368 1794 0 1907.0 -113.0 1794       weekly 5
189 Sweden Sweden 0 2020-02-05 2020-02-11 2020   10338368 1771 0 1898.8 -127.8 1771       weekly 6
190 Sweden Sweden 0 2020-02-12 2020-02-18 2020   10338368 1822 0 1923.0 -101.0 1822       weekly 7
191 Sweden Sweden 0 2020-02-19 2020-02-25 2020   10338368 1774 0 2012.0 -238.0 1774       weekly 8
192 Sweden Sweden 0 2020-02-26 2020-03-03 2020   10338368 1751 0 1961.8 -210.8 1751       weekly 9
193 Sweden Sweden 0 2020-03-04 2020-03-10 2020   10338368 1831 0 1924.6 -93.5999999999999 1831       weekly 10
194 Sweden Sweden 0 2020-03-11 2020-03-17 2020   10338368 1781 8 1875.4 -94.4000000000001 1773       weekly 11
195 Sweden Sweden 0 2020-03-18 2020-03-24 2020   10338368 1883 73 1800.2 82.8 1810       weekly 12
196 Sweden Sweden 0 2020-03-25 2020-03-31 2020   10338368 2104 251 1825.8 278.2 1853       weekly 13
197 Sweden Sweden 0 2020-04-01 2020-04-07 2020   10338368 2444 532 1818.4 625.6 1912       weekly 14
198 Sweden Sweden 0 2020-04-08 2020-04-14 2020   10338368 2558 667 1726.4 831.6 1891       weekly 15
199 Sweden Sweden 0 2020-04-15 2020-04-21 2020   10338368 2455 628 1752.4 702.6 1827       weekly 16
200 Sweden Sweden 0 2020-04-22 2020-04-28 2020   10338368 2259 555 1715.8 543.2 1704       weekly 17

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [economist_excess_deaths] (
   [country] TEXT,
   [region] TEXT,
   [region_code] TEXT,
   [start_date] TEXT,
   [end_date] TEXT,
   [year] INTEGER,
   [month] INTEGER,
   [population] INTEGER,
   [total_deaths] INTEGER,
   [covid_deaths] INTEGER,
   [expected_deaths] FLOAT,
   [excess_deaths] FLOAT,
   [non_covid_deaths] INTEGER,
   [covid_deaths_per_100k] FLOAT,
   [excess_deaths_per_100k] FLOAT,
   [excess_deaths_pct_change] FLOAT,
   [cadence] TEXT
, [week] INTEGER);
Powered by Datasette · Query took 24.5ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette