economist_historical_deaths

Table actions
⚠️ 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,165 rows

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

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

country >30

cadence 2

Link rowid ▼ country region region_code start_date end_date days year week population total_deaths covid_deaths expected_deaths cadence month quarter
1 1 Italy Italy 0 2014-12-29 2015-01-04 7 2015 1 60367471 15178 0 TBC weekly    
2 2 Italy Italy 0 2015-01-05 2015-01-11 7 2015 2 60367471 15811 0 TBC weekly    
3 3 Italy Italy 0 2015-01-12 2015-01-18 7 2015 3 60367471 15480 0 TBC weekly    
4 4 Italy Italy 0 2015-01-19 2015-01-25 7 2015 4 60367471 14922 0 TBC weekly    
5 5 Italy Italy 0 2015-01-26 2015-02-01 7 2015 5 60367471 15228 0 TBC weekly    
6 6 Italy Italy 0 2015-02-02 2015-02-08 7 2015 6 60367471 15640 0 TBC weekly    
7 7 Italy Italy 0 2015-02-09 2015-02-15 7 2015 7 60367471 15510 0 TBC weekly    
8 8 Italy Italy 0 2015-02-16 2015-02-22 7 2015 8 60367471 15149 0 TBC weekly    
9 9 Italy Italy 0 2015-02-23 2015-03-01 7 2015 9 60367471 14544 0 TBC weekly    
10 10 Italy Italy 0 2015-03-02 2015-03-08 7 2015 10 60367471 14211 0 TBC weekly    
11 11 Italy Italy 0 2015-03-09 2015-03-15 7 2015 11 60367471 13846 0 TBC weekly    
12 12 Italy Italy 0 2015-03-16 2015-03-22 7 2015 12 60367471 13455 0 TBC weekly    
13 13 Italy Italy 0 2015-03-23 2015-03-29 7 2015 13 60367471 13126 0 TBC weekly    
14 14 Italy Italy 0 2015-03-30 2015-04-05 7 2015 14 60367471 12832 0 TBC weekly    
15 15 Italy Italy 0 2015-04-06 2015-04-12 7 2015 15 60367471 12811 0 TBC weekly    
16 16 Italy Italy 0 2015-04-13 2015-04-19 7 2015 16 60367471 12781 0 TBC weekly    
17 17 Italy Italy 0 2015-04-20 2015-04-26 7 2015 17 60367471 12046 0 TBC weekly    
18 18 Italy Italy 0 2015-04-27 2015-05-03 7 2015 18 60367471 11946 0 TBC weekly    
19 19 Italy Italy 0 2015-05-04 2015-05-10 7 2015 19 60367471 12177 0 TBC weekly    
20 20 Italy Italy 0 2015-05-11 2015-05-17 7 2015 20 60367471 11518 0 TBC weekly    
21 21 Italy Italy 0 2015-05-18 2015-05-24 7 2015 21 60367471 11058 0 TBC weekly    
22 22 Italy Italy 0 2015-05-25 2015-05-31 7 2015 22 60367471 10848 0 TBC weekly    
23 23 Italy Italy 0 2015-06-01 2015-06-07 7 2015 23 60367471 12060 0 TBC weekly    
24 24 Italy Italy 0 2015-06-08 2015-06-14 7 2015 24 60367471 11447 0 TBC weekly    
25 25 Italy Italy 0 2015-06-15 2015-06-21 7 2015 25 60367471 10591 0 TBC weekly    
26 26 Italy Italy 0 2015-06-22 2015-06-28 7 2015 26 60367471 10808 0 TBC weekly    
27 27 Italy Italy 0 2015-06-29 2015-07-05 7 2015 27 60367471 11819 0 TBC weekly    
28 28 Italy Italy 0 2015-07-06 2015-07-12 7 2015 28 60367471 13269 0 TBC weekly    
29 29 Italy Italy 0 2015-07-13 2015-07-19 7 2015 29 60367471 13303 0 TBC weekly    
30 30 Italy Italy 0 2015-07-20 2015-07-26 7 2015 30 60367471 14555 0 TBC weekly    
31 31 Italy Italy 0 2015-07-27 2015-08-02 7 2015 31 60367471 12009 0 TBC weekly    
32 32 Italy Italy 0 2015-08-03 2015-08-09 7 2015 32 60367471 12595 0 TBC weekly    
33 33 Italy Italy 0 2015-08-10 2015-08-16 7 2015 33 60367471 11716 0 TBC weekly    
34 34 Italy Italy 0 2015-08-17 2015-08-23 7 2015 34 60367471 10619 0 TBC weekly    
35 35 Italy Italy 0 2015-08-24 2015-08-30 7 2015 35 60367471 11116 0 TBC weekly    
36 36 Italy Italy 0 2015-08-31 2015-09-06 7 2015 36 60367471 11352 0 TBC weekly    
37 37 Italy Italy 0 2015-09-07 2015-09-13 7 2015 37 60367471 10629 0 TBC weekly    
38 38 Italy Italy 0 2015-09-14 2015-09-20 7 2015 38 60367471 11358 0 TBC weekly    
39 39 Italy Italy 0 2015-09-21 2015-09-27 7 2015 39 60367471 10687 0 TBC weekly    
40 40 Italy Italy 0 2015-09-28 2015-10-04 7 2015 40 60367471 11228 0 TBC weekly    
41 41 Italy Italy 0 2015-10-05 2015-10-11 7 2015 41 60367471 11624 0 TBC weekly    
42 42 Italy Italy 0 2015-10-12 2015-10-18 7 2015 42 60367471 11389 0 TBC weekly    
43 43 Italy Italy 0 2015-10-19 2015-10-25 7 2015 43 60367471 11834 0 TBC weekly    
44 44 Italy Italy 0 2015-10-26 2015-11-01 7 2015 44 60367471 11722 0 TBC weekly    
45 45 Italy Italy 0 2015-11-02 2015-11-08 7 2015 45 60367471 11850 0 TBC weekly    
46 46 Italy Italy 0 2015-11-09 2015-11-15 7 2015 46 60367471 11629 0 TBC weekly    
47 47 Italy Italy 0 2015-11-16 2015-11-22 7 2015 47 60367471 11689 0 TBC weekly    
48 48 Italy Italy 0 2015-11-23 2015-11-29 7 2015 48 60367471 11738 0 TBC weekly    
49 49 Italy Italy 0 2015-11-30 2015-12-06 7 2015 49 60367471 12501 0 TBC weekly    
50 50 Italy Italy 0 2015-12-07 2015-12-13 7 2015 50 60367471 12491 0 TBC weekly    
51 51 Italy Italy 0 2015-12-14 2015-12-20 7 2015 51 60367471 12463 0 TBC weekly    
52 52 Italy Italy 0 2015-12-21 2015-12-27 7 2015 52 60367471 12560 0 TBC weekly    
53 53 Italy Italy 0 2015-12-28 2016-01-03 7 2015 53 60367471 13218 0 TBC weekly    
54 54 Italy Italy 0 2016-01-04 2016-01-10 7 2016 1 60367471 13517 0 TBC weekly    
55 55 Italy Italy 0 2016-01-11 2016-01-17 7 2016 2 60367471 13055 0 TBC weekly    
56 56 Italy Italy 0 2016-01-18 2016-01-24 7 2016 3 60367471 13545 0 TBC weekly    
57 57 Italy Italy 0 2016-01-25 2016-01-31 7 2016 4 60367471 13388 0 TBC weekly    
58 58 Italy Italy 0 2016-02-01 2016-02-07 7 2016 5 60367471 12997 0 TBC weekly    
59 59 Italy Italy 0 2016-02-08 2016-02-14 7 2016 6 60367471 13168 0 TBC weekly    
60 60 Italy Italy 0 2016-02-15 2016-02-21 7 2016 7 60367471 12685 0 TBC weekly    
61 61 Italy Italy 0 2016-02-22 2016-02-28 7 2016 8 60367471 12709 0 TBC weekly    
62 62 Italy Italy 0 2016-02-29 2016-03-06 7 2016 9 60367471 12772 0 TBC weekly    
63 63 Italy Italy 0 2016-03-07 2016-03-13 7 2016 10 60367471 12845 0 TBC weekly    
64 64 Italy Italy 0 2016-03-14 2016-03-20 7 2016 11 60367471 12887 0 TBC weekly    
65 65 Italy Italy 0 2016-03-21 2016-03-27 7 2016 12 60367471 12525 0 TBC weekly    
66 66 Italy Italy 0 2016-03-28 2016-04-03 7 2016 13 60367471 12725 0 TBC weekly    
67 67 Italy Italy 0 2016-04-04 2016-04-10 7 2016 14 60367471 12291 0 TBC weekly    
68 68 Italy Italy 0 2016-04-11 2016-04-17 7 2016 15 60367471 11822 0 TBC weekly    
69 69 Italy Italy 0 2016-04-18 2016-04-24 7 2016 16 60367471 11594 0 TBC weekly    
70 70 Italy Italy 0 2016-04-25 2016-05-01 7 2016 17 60367471 11420 0 TBC weekly    
71 71 Italy Italy 0 2016-05-02 2016-05-08 7 2016 18 60367471 11595 0 TBC weekly    
72 72 Italy Italy 0 2016-05-09 2016-05-15 7 2016 19 60367471 11422 0 TBC weekly    
73 73 Italy Italy 0 2016-05-16 2016-05-22 7 2016 20 60367471 10950 0 TBC weekly    
74 74 Italy Italy 0 2016-05-23 2016-05-29 7 2016 21 60367471 11509 0 TBC weekly    
75 75 Italy Italy 0 2016-05-30 2016-06-05 7 2016 22 60367471 10842 0 TBC weekly    
76 76 Italy Italy 0 2016-06-06 2016-06-12 7 2016 23 60367471 11030 0 TBC weekly    
77 77 Italy Italy 0 2016-06-13 2016-06-19 7 2016 24 60367471 10766 0 TBC weekly    
78 78 Italy Italy 0 2016-06-20 2016-06-26 7 2016 25 60367471 11442 0 TBC weekly    
79 79 Italy Italy 0 2016-06-27 2016-07-03 7 2016 26 60367471 11247 0 TBC weekly    
80 80 Italy Italy 0 2016-07-04 2016-07-10 7 2016 27 60367471 11293 0 TBC weekly    
81 81 Italy Italy 0 2016-07-11 2016-07-17 7 2016 28 60367471 11324 0 TBC weekly    
82 82 Italy Italy 0 2016-07-18 2016-07-24 7 2016 29 60367471 11170 0 TBC weekly    
83 83 Italy Italy 0 2016-07-25 2016-07-31 7 2016 30 60367471 11042 0 TBC weekly    
84 84 Italy Italy 0 2016-08-01 2016-08-07 7 2016 31 60367471 10991 0 TBC weekly    
85 85 Italy Italy 0 2016-08-08 2016-08-14 7 2016 32 60367471 10606 0 TBC weekly    
86 86 Italy Italy 0 2016-08-15 2016-08-21 7 2016 33 60367471 11144 0 TBC weekly    
87 87 Italy Italy 0 2016-08-22 2016-08-28 7 2016 34 60367471 11193 0 TBC weekly    
88 88 Italy Italy 0 2016-08-29 2016-09-04 7 2016 35 60367471 10748 0 TBC weekly    
89 89 Italy Italy 0 2016-09-05 2016-09-11 7 2016 36 60367471 10479 0 TBC weekly    
90 90 Italy Italy 0 2016-09-12 2016-09-18 7 2016 37 60367471 10584 0 TBC weekly    
91 91 Italy Italy 0 2016-09-19 2016-09-25 7 2016 38 60367471 10321 0 TBC weekly    
92 92 Italy Italy 0 2016-09-26 2016-10-02 7 2016 39 60367471 11094 0 TBC weekly    
93 93 Italy Italy 0 2016-10-03 2016-10-09 7 2016 40 60367471 11158 0 TBC weekly    
94 94 Italy Italy 0 2016-10-10 2016-10-16 7 2016 41 60367471 12362 0 TBC weekly    
95 95 Italy Italy 0 2016-10-17 2016-10-23 7 2016 42 60367471 12060 0 TBC weekly    
96 96 Italy Italy 0 2016-10-24 2016-10-30 7 2016 43 60367471 11816 0 TBC weekly    
97 97 Italy Italy 0 2016-10-31 2016-11-06 7 2016 44 60367471 11744 0 TBC weekly    
98 98 Italy Italy 0 2016-11-07 2016-11-13 7 2016 45 60367471 11889 0 TBC weekly    
99 99 Italy Italy 0 2016-11-14 2016-11-20 7 2016 46 60367471 12476 0 TBC weekly    
100 100 Italy Italy 0 2016-11-21 2016-11-27 7 2016 47 60367471 12146 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] INTEGER,
   [start_date] TEXT,
   [end_date] TEXT,
   [days] INTEGER,
   [year] INTEGER,
   [week] INTEGER,
   [population] INTEGER,
   [total_deaths] INTEGER,
   [covid_deaths] INTEGER,
   [expected_deaths] TEXT,
   [cadence] TEXT
, [month] INTEGER, [quarter] INTEGER);
CREATE INDEX [idx_economist_historical_deaths_country]
    ON [economist_historical_deaths] ([country]);
CREATE INDEX [idx_economist_historical_deaths_cadence]
    ON [economist_historical_deaths] ([cadence]);
CREATE INDEX [idx_economist_historical_deaths_end_date]
    ON [economist_historical_deaths] ([end_date]);