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,604 rows where cadence = "weekly"

View and edit SQL

Suggested facets: week, start_date (date), end_date (date)

cadence

  • weekly · 6,604
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
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
201 Sweden Sweden 0 2020-04-29 2020-05-05 2020   10338368 2237 544 1649.0 588.0 1693       weekly 18
202 Sweden Sweden 0 2020-05-06 2020-05-12 2020   10338368 2146 479 1633.2 512.8 1667       weekly 19
203 Sweden Sweden 0 2020-05-13 2020-05-19 2020   10338368 1935 355 1580.4 354.6 1580       weekly 20
204 Sweden Sweden 0 2020-05-20 2020-05-26 2020   10338368 1814 329 1535.6 278.4 1485       weekly 21
205 Sweden Sweden 0 2020-05-27 2020-06-02 2020   10338368 1702 278 1582.0 120.0 1424       weekly 22
206 Sweden Sweden 0 2020-06-03 2020-06-09 2020   10338368 1656 240 1530.6 125.4 1416       weekly 23
207 Turkey Istanbul 0 2020-01-01 2020-01-07 2020   15519267 1699 0 1766.66666666667 -67.6666666666667 1699       weekly 1
208 Turkey Istanbul 0 2020-01-08 2020-01-14 2020   15519267 1777 0 1800.66666666667 -23.6666666666667 1777       weekly 2
209 Turkey Istanbul 0 2020-01-15 2020-01-21 2020   15519267 1826 0 1809.66666666667 16.3333333333333 1826       weekly 3
210 Turkey Istanbul 0 2020-01-22 2020-01-28 2020   15519267 1822 0 1795.66666666667 26.3333333333333 1822       weekly 4
211 Turkey Istanbul 0 2020-01-29 2020-02-04 2020   15519267 1670 0 1690.66666666667 -20.6666666666667 1670       weekly 5
212 Turkey Istanbul 0 2020-02-05 2020-02-11 2020   15519267 1617 0 1608.66666666667 8.33333333333326 1617       weekly 6
213 Turkey Istanbul 0 2020-02-12 2020-02-18 2020   15519267 1530 0 1514.66666666667 15.3333333333333 1530       weekly 7
214 Turkey Istanbul 0 2020-02-19 2020-02-25 2020   15519267 1468 0 1552.33333333333 -84.3333333333333 1468       weekly 8
215 Turkey Istanbul 0 2020-02-26 2020-03-03 2020   15519267 1500 0 1555.33333333333 -55.3333333333333 1500       weekly 9
216 Turkey Istanbul 0 2020-03-04 2020-03-10 2020   15519267 1447 0 1504.33333333333 -57.3333333333333 1447       weekly 10
217 Turkey Istanbul 0 2020-03-11 2020-03-17 2020   15519267 1546 0 1458.0 88.0 1546       weekly 11
218 Turkey Istanbul 0 2020-03-18 2020-03-24 2020   15519267 1768 22 1485.0 283.0 1746       weekly 12
219 Turkey Istanbul 0 2020-03-25 2020-03-31 2020   15519267 1888 85 1443.66666666667 444.333333333333 1803       weekly 13
220 Turkey Istanbul 0 2020-04-01 2020-04-07 2020   15519267 2252 255.5 1433.66666666667 818.333333333333 1996.5       weekly 14
221 Turkey Istanbul 0 2020-04-08 2020-04-14 2020   15519267 2244 339 1462.0 782.0 1905       weekly 15
222 Turkey Istanbul 0 2020-04-15 2020-04-21 2020   15519267 2031 428 1401.66666666667 629.333333333333 1603       weekly 16
223 Turkey Istanbul 0 2020-04-22 2020-04-28 2020   15519267 1914 366.5 1432.66666666667 481.333333333333 1547.5       weekly 17
224 Turkey Istanbul 0 2020-04-29 2020-05-05 2020   15519267 1772 264 1398.0 374.0 1508       weekly 18
225 Turkey Istanbul 0 2020-05-06 2020-05-12 2020   15519267 1691 187 1403.66666666667 287.333333333333 1504       weekly 19
226 Italy Piemonte 1 2020-01-01 2020-01-07 2020   4165469 1007 0 1226.8 -219.8 1007       weekly 1
227 Italy Piemonte 1 2020-01-08 2020-01-14 2020   4165469 1015 0 1246.6 -231.6 1015       weekly 2
228 Italy Piemonte 1 2020-01-15 2020-01-21 2020   4165469 1031 0 1208.8 -177.8 1031       weekly 3
229 Italy Piemonte 1 2020-01-22 2020-01-28 2020   4165469 1064 0 1199.2 -135.2 1064       weekly 4
230 Italy Piemonte 1 2020-01-29 2020-02-04 2020   4165469 1067 0 1175.6 -108.6 1067       weekly 5
231 Italy Piemonte 1 2020-02-05 2020-02-11 2020   4165469 1066 0 1163.2 -97.2 1066       weekly 6
232 Italy Piemonte 1 2020-02-12 2020-02-18 2020   4165469 1029 0 1133.2 -104.2 1029       weekly 7
233 Italy Piemonte 1 2020-02-19 2020-02-25 2020   4165469 1011 0 1055.6 -44.5999999999999 1011       weekly 8
234 Italy Piemonte 1 2020-02-26 2020-03-03 2020   4165469 1074 0 1072.4 1.59999999999991 1074       weekly 9
235 Italy Piemonte 1 2020-03-04 2020-03-10 2020   4165469 1142 17 1052.6 89.4000000000001 1125       weekly 10
236 Italy Piemonte 1 2020-03-11 2020-03-17 2020   4165469 1347 116 1029.8 317.2 1231       weekly 11
237 Italy Piemonte 1 2020-03-18 2020-03-24 2020   4165469 1788 241 966.6 821.4 1547       weekly 12
238 Italy Piemonte 1 2020-03-25 2020-03-31 2020   4165469 2103 480 954.6 1148.4 1623       weekly 13
239 Italy Piemonte 1 2020-04-01 2020-04-07 2020   4165469 1863 465 964.0 899.0 1398       weekly 14
240 Italy Piemonte 1 2020-04-08 2020-04-14 2020   4165469 1749 608 973.8 775.2 1141       weekly 15
241 Italy Piemonte 1 2020-04-15 2020-04-21 2020   4165469 1492 558 906.6 585.4 934       weekly 16
242 Italy Piemonte 1 2020-04-22 2020-04-28 2020   4165469 1290 451 901.0 389.0 839       weekly 17
243 Italy Piemonte 1 2020-04-29 2020-05-05 2020   4165469 936 280 922.8 13.2 656       weekly 18
244 Italy Piemonte 1 2020-05-06 2020-05-12 2020   4165469 854 212 906.6 -52.6 642       weekly 19
245 Italy Valle d'Aosta/Vallée d'Aoste 2 2020-01-01 2020-01-07 2020   114653 35 0 28.0 7.0 35       weekly 1
246 Italy Valle d'Aosta/Vallée d'Aoste 2 2020-01-08 2020-01-14 2020   114653 24 0 37.2 -13.2 24       weekly 2
247 Italy Valle d'Aosta/Vallée d'Aoste 2 2020-01-15 2020-01-21 2020   114653 22 0 34.2 -12.2 22       weekly 3
248 Italy Valle d'Aosta/Vallée d'Aoste 2 2020-01-22 2020-01-28 2020   114653 23 0 26.4 -3.4 23       weekly 4
249 Italy Valle d'Aosta/Vallée d'Aoste 2 2020-01-29 2020-02-04 2020   114653 28 0 31.2 -3.2 28       weekly 5
250 Italy Valle d'Aosta/Vallée d'Aoste 2 2020-02-05 2020-02-11 2020   114653 35 0 28.8 6.2 35       weekly 6
251 Italy Valle d'Aosta/Vallée d'Aoste 2 2020-02-12 2020-02-18 2020   114653 32 0 34.2 -2.2 32       weekly 7
252 Italy Valle d'Aosta/Vallée d'Aoste 2 2020-02-19 2020-02-25 2020   114653 27 0 30.4 -3.4 27       weekly 8
253 Italy Valle d'Aosta/Vallée d'Aoste 2 2020-02-26 2020-03-03 2020   114653 20 0 28.6 -8.6 20       weekly 9
254 Italy Valle d'Aosta/Vallée d'Aoste 2 2020-03-04 2020-03-10 2020   114653 31 0 28.2 2.8 31       weekly 10
255 Italy Valle d'Aosta/Vallée d'Aoste 2 2020-03-11 2020-03-17 2020   114653 34 2 28.0 6.0 32       weekly 11
256 Italy Valle d'Aosta/Vallée d'Aoste 2 2020-03-18 2020-03-24 2020   114653 52 17 25.6 26.4 35       weekly 12
257 Italy Valle d'Aosta/Vallée d'Aoste 2 2020-03-25 2020-03-31 2020   114653 71 37 27.0 44.0 34       weekly 13
258 Italy Valle d'Aosta/Vallée d'Aoste 2 2020-04-01 2020-04-07 2020   114653 75 44 25.0 50.0 31       weekly 14
259 Italy Valle d'Aosta/Vallée d'Aoste 2 2020-04-08 2020-04-14 2020   114653 46 18 27.0 19.0 28       weekly 15
260 Italy Valle d'Aosta/Vallée d'Aoste 2 2020-04-15 2020-04-21 2020   114653 33 8 26.4 6.6 25       weekly 16

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 234.858ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette