economist_historical_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

34,904 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: year, month, start_date (date), end_date (date)

country

cadence

Link rowid ▼ country region region_code start_date end_date year week population total_deaths covid_deaths expected_deaths cadence month
1 1 Mexico Mexico City MX-CMX 2016-01-04 2016-01-10 2016 1 8918653 1520 0 TBC weekly  
2 2 Mexico Mexico City MX-CMX 2016-01-11 2016-01-17 2016 2 8918653 1575 0 TBC weekly  
3 3 Mexico Mexico City MX-CMX 2016-01-18 2016-01-24 2016 3 8918653 1673 0 TBC weekly  
4 4 Mexico Mexico City MX-CMX 2016-01-25 2016-01-31 2016 4 8918653 1715 0 TBC weekly  
5 5 Mexico Mexico City MX-CMX 2016-02-01 2016-02-07 2016 5 8918653 1724 0 TBC weekly  
6 6 Mexico Mexico City MX-CMX 2016-02-08 2016-02-14 2016 6 8918653 1726 0 TBC weekly  
7 7 Mexico Mexico City MX-CMX 2016-02-15 2016-02-21 2016 7 8918653 1819 0 TBC weekly  
8 8 Mexico Mexico City MX-CMX 2016-02-22 2016-02-28 2016 8 8918653 1798 0 TBC weekly  
9 9 Mexico Mexico City MX-CMX 2016-02-29 2016-03-06 2016 9 8918653 1606 0 TBC weekly  
10 10 Mexico Mexico City MX-CMX 2016-03-07 2016-03-13 2016 10 8918653 1617 0 TBC weekly  
11 11 Mexico Mexico City MX-CMX 2016-03-14 2016-03-20 2016 11 8918653 1617 0 TBC weekly  
12 12 Mexico Mexico City MX-CMX 2016-03-21 2016-03-27 2016 12 8918653 1377 0 TBC weekly  
13 13 Mexico Mexico City MX-CMX 2016-03-28 2016-04-03 2016 13 8918653 1380 0 TBC weekly  
14 14 Mexico Mexico City MX-CMX 2016-04-04 2016-04-10 2016 14 8918653 1457 0 TBC weekly  
15 15 Mexico Mexico City MX-CMX 2016-04-11 2016-04-17 2016 15 8918653 1387 0 TBC weekly  
16 16 Mexico Mexico City MX-CMX 2016-04-18 2016-04-24 2016 16 8918653 1330 0 TBC weekly  
17 17 Mexico Mexico City MX-CMX 2016-04-25 2016-05-01 2016 17 8918653 1314 0 TBC weekly  
18 18 Mexico Mexico City MX-CMX 2016-05-02 2016-05-08 2016 18 8918653 1376 0 TBC weekly  
19 19 Mexico Mexico City MX-CMX 2016-05-09 2016-05-15 2016 19 8918653 1324 0 TBC weekly  
20 20 Mexico Mexico City MX-CMX 2016-05-16 2016-05-22 2016 20 8918653 1275 0 TBC weekly  
21 21 Mexico Mexico City MX-CMX 2016-05-23 2016-05-29 2016 21 8918653 1335 0 TBC weekly  
22 22 Mexico Mexico City MX-CMX 2016-05-30 2016-06-05 2016 22 8918653 1283 0 TBC weekly  
23 23 Mexico Mexico City MX-CMX 2016-06-06 2016-06-12 2016 23 8918653 1396 0 TBC weekly  
24 24 Mexico Mexico City MX-CMX 2016-06-13 2016-06-19 2016 24 8918653 1301 0 TBC weekly  
25 25 Mexico Mexico City MX-CMX 2016-06-20 2016-06-26 2016 25 8918653 1334 0 TBC weekly  
26 26 Mexico Mexico City MX-CMX 2016-06-27 2016-07-03 2016 26 8918653 1297 0 TBC weekly  
27 27 Mexico Mexico City MX-CMX 2016-07-04 2016-07-10 2016 27 8918653 1376 0 TBC weekly  
28 28 Mexico Mexico City MX-CMX 2016-07-11 2016-07-17 2016 28 8918653 1301 0 TBC weekly  
29 29 Mexico Mexico City MX-CMX 2016-07-18 2016-07-24 2016 29 8918653 1293 0 TBC weekly  
30 30 Mexico Mexico City MX-CMX 2016-07-25 2016-07-31 2016 30 8918653 1322 0 TBC weekly  
31 31 Mexico Mexico City MX-CMX 2016-08-01 2016-08-07 2016 31 8918653 1248 0 TBC weekly  
32 32 Mexico Mexico City MX-CMX 2016-08-08 2016-08-14 2016 32 8918653 1216 0 TBC weekly  
33 33 Mexico Mexico City MX-CMX 2016-08-15 2016-08-21 2016 33 8918653 1289 0 TBC weekly  
34 34 Mexico Mexico City MX-CMX 2016-08-22 2016-08-28 2016 34 8918653 1345 0 TBC weekly  
35 35 Mexico Mexico City MX-CMX 2016-08-29 2016-09-04 2016 35 8918653 1308 0 TBC weekly  
36 36 Mexico Mexico City MX-CMX 2016-09-05 2016-09-11 2016 36 8918653 1319 0 TBC weekly  
37 37 Mexico Mexico City MX-CMX 2016-09-12 2016-09-18 2016 37 8918653 1310 0 TBC weekly  
38 38 Mexico Mexico City MX-CMX 2016-09-19 2016-09-25 2016 38 8918653 1220 0 TBC weekly  
39 39 Mexico Mexico City MX-CMX 2016-09-26 2016-10-02 2016 39 8918653 1353 0 TBC weekly  
40 40 Mexico Mexico City MX-CMX 2016-10-03 2016-10-09 2016 40 8918653 1353 0 TBC weekly  
41 41 Mexico Mexico City MX-CMX 2016-10-10 2016-10-16 2016 41 8918653 1322 0 TBC weekly  
42 42 Mexico Mexico City MX-CMX 2016-10-17 2016-10-23 2016 42 8918653 1322 0 TBC weekly  
43 43 Mexico Mexico City MX-CMX 2016-10-24 2016-10-30 2016 43 8918653 1353 0 TBC weekly  
44 44 Mexico Mexico City MX-CMX 2016-10-31 2016-11-06 2016 44 8918653 1331 0 TBC weekly  
45 45 Mexico Mexico City MX-CMX 2016-11-07 2016-11-13 2016 45 8918653 1438 0 TBC weekly  
46 46 Mexico Mexico City MX-CMX 2016-11-14 2016-11-20 2016 46 8918653 1359 0 TBC weekly  
47 47 Mexico Mexico City MX-CMX 2016-11-21 2016-11-27 2016 47 8918653 1529 0 TBC weekly  
48 48 Mexico Mexico City MX-CMX 2016-11-28 2016-12-04 2016 48 8918653 1560 0 TBC weekly  
49 49 Mexico Mexico City MX-CMX 2016-12-05 2016-12-11 2016 49 8918653 1548 0 TBC weekly  
50 50 Mexico Mexico City MX-CMX 2016-12-12 2016-12-18 2016 50 8918653 1444 0 TBC weekly  
51 51 Mexico Mexico City MX-CMX 2016-12-19 2016-12-25 2016 51 8918653 1433 0 TBC weekly  
52 52 Mexico Mexico City MX-CMX 2016-12-26 2017-01-01 2016 52 8918653 1509 0 TBC weekly  
53 53 Mexico Mexico City MX-CMX 2017-01-02 2017-01-08 2017 1 8918653 1734 0 TBC weekly  
54 54 Mexico Mexico City MX-CMX 2017-01-09 2017-01-15 2017 2 8918653 1588 0 TBC weekly  
55 55 Mexico Mexico City MX-CMX 2017-01-16 2017-01-22 2017 3 8918653 1507 0 TBC weekly  
56 56 Mexico Mexico City MX-CMX 2017-01-23 2017-01-29 2017 4 8918653 1508 0 TBC weekly  
57 57 Mexico Mexico City MX-CMX 2017-01-30 2017-02-05 2017 5 8918653 1607 0 TBC weekly  
58 58 Mexico Mexico City MX-CMX 2017-02-06 2017-02-12 2017 6 8918653 1515 0 TBC weekly  
59 59 Mexico Mexico City MX-CMX 2017-02-13 2017-02-19 2017 7 8918653 1629 0 TBC weekly  
60 60 Mexico Mexico City MX-CMX 2017-02-20 2017-02-26 2017 8 8918653 1652 0 TBC weekly  
61 61 Mexico Mexico City MX-CMX 2017-02-27 2017-03-05 2017 9 8918653 1655 0 TBC weekly  
62 62 Mexico Mexico City MX-CMX 2017-03-06 2017-03-12 2017 10 8918653 1637 0 TBC weekly  
63 63 Mexico Mexico City MX-CMX 2017-03-13 2017-03-19 2017 11 8918653 1665 0 TBC weekly  
64 64 Mexico Mexico City MX-CMX 2017-03-20 2017-03-26 2017 12 8918653 1552 0 TBC weekly  
65 65 Mexico Mexico City MX-CMX 2017-03-27 2017-04-02 2017 13 8918653 1545 0 TBC weekly  
66 66 Mexico Mexico City MX-CMX 2017-04-03 2017-04-09 2017 14 8918653 1534 0 TBC weekly  
67 67 Mexico Mexico City MX-CMX 2017-04-10 2017-04-16 2017 15 8918653 1385 0 TBC weekly  
68 68 Mexico Mexico City MX-CMX 2017-04-17 2017-04-23 2017 16 8918653 1390 0 TBC weekly  
69 69 Mexico Mexico City MX-CMX 2017-04-24 2017-04-30 2017 17 8918653 1455 0 TBC weekly  
70 70 Mexico Mexico City MX-CMX 2017-05-01 2017-05-07 2017 18 8918653 1372 0 TBC weekly  
71 71 Mexico Mexico City MX-CMX 2017-05-08 2017-05-14 2017 19 8918653 1434 0 TBC weekly  
72 72 Mexico Mexico City MX-CMX 2017-05-15 2017-05-21 2017 20 8918653 1454 0 TBC weekly  
73 73 Mexico Mexico City MX-CMX 2017-05-22 2017-05-28 2017 21 8918653 1331 0 TBC weekly  
74 74 Mexico Mexico City MX-CMX 2017-05-29 2017-06-04 2017 22 8918653 1280 0 TBC weekly  
75 75 Mexico Mexico City MX-CMX 2017-06-05 2017-06-11 2017 23 8918653 1361 0 TBC weekly  
76 76 Mexico Mexico City MX-CMX 2017-06-12 2017-06-18 2017 24 8918653 1313 0 TBC weekly  
77 77 Mexico Mexico City MX-CMX 2017-06-19 2017-06-25 2017 25 8918653 1374 0 TBC weekly  
78 78 Mexico Mexico City MX-CMX 2017-06-26 2017-07-02 2017 26 8918653 1352 0 TBC weekly  
79 79 Mexico Mexico City MX-CMX 2017-07-03 2017-07-09 2017 27 8918653 1314 0 TBC weekly  
80 80 Mexico Mexico City MX-CMX 2017-07-10 2017-07-16 2017 28 8918653 1359 0 TBC weekly  
81 81 Mexico Mexico City MX-CMX 2017-07-17 2017-07-23 2017 29 8918653 1305 0 TBC weekly  
82 82 Mexico Mexico City MX-CMX 2017-07-24 2017-07-30 2017 30 8918653 1390 0 TBC weekly  
83 83 Mexico Mexico City MX-CMX 2017-07-31 2017-08-06 2017 31 8918653 1400 0 TBC weekly  
84 84 Mexico Mexico City MX-CMX 2017-08-07 2017-08-13 2017 32 8918653 1299 0 TBC weekly  
85 85 Mexico Mexico City MX-CMX 2017-08-14 2017-08-20 2017 33 8918653 1293 0 TBC weekly  
86 86 Mexico Mexico City MX-CMX 2017-08-21 2017-08-27 2017 34 8918653 1276 0 TBC weekly  
87 87 Mexico Mexico City MX-CMX 2017-08-28 2017-09-03 2017 35 8918653 1350 0 TBC weekly  
88 88 Mexico Mexico City MX-CMX 2017-09-04 2017-09-10 2017 36 8918653 1422 0 TBC weekly  
89 89 Mexico Mexico City MX-CMX 2017-09-11 2017-09-17 2017 37 8918653 1481 0 TBC weekly  
90 90 Mexico Mexico City MX-CMX 2017-09-18 2017-09-24 2017 38 8918653 1570 0 TBC weekly  
91 91 Mexico Mexico City MX-CMX 2017-09-25 2017-10-01 2017 39 8918653 1341 0 TBC weekly  
92 92 Mexico Mexico City MX-CMX 2017-10-02 2017-10-08 2017 40 8918653 1367 0 TBC weekly  
93 93 Mexico Mexico City MX-CMX 2017-10-09 2017-10-15 2017 41 8918653 1317 0 TBC weekly  
94 94 Mexico Mexico City MX-CMX 2017-10-16 2017-10-22 2017 42 8918653 1384 0 TBC weekly  
95 95 Mexico Mexico City MX-CMX 2017-10-23 2017-10-29 2017 43 8918653 1397 0 TBC weekly  
96 96 Mexico Mexico City MX-CMX 2017-10-30 2017-11-05 2017 44 8918653 1363 0 TBC weekly  
97 97 Mexico Mexico City MX-CMX 2017-11-06 2017-11-12 2017 45 8918653 1409 0 TBC weekly  
98 98 Mexico Mexico City MX-CMX 2017-11-13 2017-11-19 2017 46 8918653 1423 0 TBC weekly  
99 99 Mexico Mexico City MX-CMX 2017-11-20 2017-11-26 2017 47 8918653 1384 0 TBC weekly  
100 100 Mexico Mexico City MX-CMX 2017-11-27 2017-12-03 2017 48 8918653 1492 0 TBC weekly  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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