⚠️ 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

41,659 rows

View and edit SQL

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

country

cadence

Link rowid ▼ country region region_code start_date end_date year month population total_deaths covid_deaths expected_deaths cadence week
1 Russia Russia 0 2015-01-01 2015-01-31 2015 1 146748590 174723 0 TBC monthly  
2 Russia Russia 0 2015-02-01 2015-02-28 2015 2 146748590 156737 0 TBC monthly  
3 Russia Russia 0 2015-03-01 2015-03-31 2015 3 146748590 175810 0 TBC monthly  
4 Russia Russia 0 2015-04-01 2015-04-30 2015 4 146748590 164705 0 TBC monthly  
5 Russia Russia 0 2015-05-01 2015-05-31 2015 5 146748590 154855 0 TBC monthly  
6 Russia Russia 0 2015-06-01 2015-06-30 2015 6 146748590 161267 0 TBC monthly  
7 Russia Russia 0 2015-07-01 2015-07-31 2015 7 146748590 155922 0 TBC monthly  
8 Russia Russia 0 2015-08-01 2015-08-31 2015 8 146748590 145113 0 TBC monthly  
9 Russia Russia 0 2015-09-01 2015-09-30 2015 9 146748590 154600 0 TBC monthly  
10 Russia Russia 0 2015-10-01 2015-10-31 2015 10 146748590 156753 0 TBC monthly  
11 Russia Russia 0 2015-11-01 2015-11-30 2015 11 146748590 147626 0 TBC monthly  
12 Russia Russia 0 2015-12-01 2015-12-31 2015 12 146748590 163302 0 TBC monthly  
13 Russia Russia 0 2016-01-01 2016-01-31 2016 1 146748590 169771 0 TBC monthly  
14 Russia Russia 0 2016-02-01 2016-02-29 2016 2 146748590 156779 0 TBC monthly  
15 Russia Russia 0 2016-03-01 2016-03-31 2016 3 146748590 166307 0 TBC monthly  
16 Russia Russia 0 2016-04-01 2016-04-30 2016 4 146748590 150761 0 TBC monthly  
17 Russia Russia 0 2016-05-01 2016-05-31 2016 5 146748590 160437 0 TBC monthly  
18 Russia Russia 0 2016-06-01 2016-06-30 2016 6 146748590 156514 0 TBC monthly  
19 Russia Russia 0 2016-07-01 2016-07-31 2016 7 146748590 146874 0 TBC monthly  
20 Russia Russia 0 2016-08-01 2016-08-31 2016 8 146748590 159864 0 TBC monthly  
21 Russia Russia 0 2016-09-01 2016-09-30 2016 9 146748590 149829 0 TBC monthly  
22 Russia Russia 0 2016-10-01 2016-10-31 2016 10 146748590 150667 0 TBC monthly  
23 Russia Russia 0 2016-11-01 2016-11-30 2016 11 146748590 156836 0 TBC monthly  
24 Russia Russia 0 2016-12-01 2016-12-31 2016 12 146748590 163274 0 TBC monthly  
25 Russia Russia 0 2017-01-01 2017-01-31 2017 1 146748590 179410 0 TBC monthly  
26 Russia Russia 0 2017-02-01 2017-02-28 2017 2 146748590 146802 0 TBC monthly  
27 Russia Russia 0 2017-03-01 2017-03-31 2017 3 146748590 161610 0 TBC monthly  
28 Russia Russia 0 2017-04-01 2017-04-30 2017 4 146748590 142226 0 TBC monthly  
29 Russia Russia 0 2017-05-01 2017-05-31 2017 5 146748590 161000 0 TBC monthly  
30 Russia Russia 0 2017-06-01 2017-06-30 2017 6 146748590 149314 0 TBC monthly  
31 Russia Russia 0 2017-07-01 2017-07-31 2017 7 146748590 143413 0 TBC monthly  
32 Russia Russia 0 2017-08-01 2017-08-31 2017 8 146748590 152367 0 TBC monthly  
33 Russia Russia 0 2017-09-01 2017-09-30 2017 9 146748590 141652 0 TBC monthly  
34 Russia Russia 0 2017-10-01 2017-10-31 2017 10 146748590 155161 0 TBC monthly  
35 Russia Russia 0 2017-11-01 2017-11-30 2017 11 146748590 145248 0 TBC monthly  
36 Russia Russia 0 2017-12-01 2017-12-31 2017 12 146748590 146137 0 TBC monthly  
37 Russia Russia 0 2018-01-01 2018-01-31 2018 1 146748590 165836 0 TBC monthly  
38 Russia Russia 0 2018-02-01 2018-02-28 2018 2 146748590 142931 0 TBC monthly  
39 Russia Russia 0 2018-03-01 2018-03-31 2018 3 146748590 169408 0 TBC monthly  
40 Russia Russia 0 2018-04-01 2018-04-30 2018 4 146748590 157368 0 TBC monthly  
41 Russia Russia 0 2018-05-01 2018-05-31 2018 5 146748590 162805 0 TBC monthly  
42 Russia Russia 0 2018-06-01 2018-06-30 2018 6 146748590 148590 0 TBC monthly  
43 Russia Russia 0 2018-07-01 2018-07-31 2018 7 146748590 152478 0 TBC monthly  
44 Russia Russia 0 2018-08-01 2018-08-31 2018 8 146748590 147822 0 TBC monthly  
45 Russia Russia 0 2018-09-01 2018-09-30 2018 9 146748590 136140 0 TBC monthly  
46 Russia Russia 0 2018-10-01 2018-10-31 2018 10 146748590 153705 0 TBC monthly  
47 Russia Russia 0 2018-11-01 2018-11-30 2018 11 146748590 143519 0 TBC monthly  
48 Russia Russia 0 2018-12-01 2018-12-31 2018 12 146748590 147225 0 TBC monthly  
49 Russia Russia 0 2019-01-01 2019-01-31 2019 1 146748590 172451 0 TBC monthly  
50 Russia Russia 0 2019-02-01 2019-02-28 2019 2 146748590 148496 0 TBC monthly  
51 Russia Russia 0 2019-03-01 2019-03-31 2019 3 146748590 151913 0 TBC monthly  
52 Russia Russia 0 2019-04-01 2019-04-30 2019 4 146748590 153867 0 TBC monthly  
53 Russia Russia 0 2019-05-01 2019-05-31 2019 5 146748590 154539 0 TBC monthly  
54 Russia Russia 0 2019-06-01 2019-06-30 2019 6 146748590 137237 0 TBC monthly  
55 Russia Russia 0 2019-07-01 2019-07-31 2019 7 146748590 151554 0 TBC monthly  
56 Russia Russia 0 2019-08-01 2019-08-31 2019 8 146748590 143394 0 TBC monthly  
57 Russia Russia 0 2019-09-01 2019-09-30 2019 9 146748590 139051 0 TBC monthly  
58 Russia Russia 0 2019-10-01 2019-10-31 2019 10 146748590 157679 0 TBC monthly  
59 Russia Russia 0 2019-11-01 2019-11-30 2019 11 146748590 141331 0 TBC monthly  
60 Russia Russia 0 2019-12-01 2019-12-31 2019 12 146748590 149165 0 TBC monthly  
61 Russia Russia 0 2020-01-01 2020-01-31 2020 1 146748590 164075 0 TBC monthly  
62 Russia Russia 0 2020-02-01 2020-02-29 2020 2 146748590 143179 0 TBC monthly  
63 Russia Russia 0 2020-03-01 2020-03-31 2020 3 146748590 152740 17 TBC monthly  
64 Russia Russia 0 2020-04-01 2020-04-30 2020 4 146748590 150873 1056 TBC monthly  
65 Russia Russia 0 2020-05-01 2020-05-31 2020 5 146748590 172914 3620 TBC monthly  
66 Russia Russia 0 2020-06-01 2020-06-30 2020 6 146748590 162758 4613 TBC monthly  
67 Russia Russia 0 2020-07-01 2020-07-31 2020 7 146748590 181479 4633 TBC monthly  
68 Russia Russia 0 2020-08-01 2020-08-31 2020 8 146748590 157181 3189 TBC monthly  
69 Russia Russia 0 2020-09-01 2020-09-30 2020 9 146748590 170717 3502 TBC monthly  
70 Russia Russia 0 2020-10-01 2020-10-31 2020 10 146748590 205456 7157 TBC monthly  
71 Russia Russia 0 2020-11-01 2020-11-30 2020 11 146748590 219872 11704 TBC monthly  
72 Chile Tarapacá CL-TA 2015-01-01 2015-01-07 2015   330558 25 0 TBC weekly 1
73 Chile Tarapacá CL-TA 2015-01-08 2015-01-14 2015   330558 23 0 TBC weekly 2
74 Chile Tarapacá CL-TA 2015-01-15 2015-01-21 2015   330558 19 0 TBC weekly 3
75 Chile Tarapacá CL-TA 2015-01-22 2015-01-28 2015   330558 21 0 TBC weekly 4
76 Chile Tarapacá CL-TA 2015-01-29 2015-02-04 2015   330558 30 0 TBC weekly 5
77 Chile Tarapacá CL-TA 2015-02-05 2015-02-11 2015   330558 32 0 TBC weekly 6
78 Chile Tarapacá CL-TA 2015-02-12 2015-02-18 2015   330558 34 0 TBC weekly 7
79 Chile Tarapacá CL-TA 2015-02-19 2015-02-25 2015   330558 23 0 TBC weekly 8
80 Chile Tarapacá CL-TA 2015-02-26 2015-03-04 2015   330558 32 0 TBC weekly 9
81 Chile Tarapacá CL-TA 2015-03-05 2015-03-11 2015   330558 29 0 TBC weekly 10
82 Chile Tarapacá CL-TA 2015-03-12 2015-03-18 2015   330558 36 0 TBC weekly 11
83 Chile Tarapacá CL-TA 2015-03-19 2015-03-25 2015   330558 26 0 TBC weekly 12
84 Chile Tarapacá CL-TA 2015-03-26 2015-04-01 2015   330558 27 0 TBC weekly 13
85 Chile Tarapacá CL-TA 2015-04-02 2015-04-08 2015   330558 19 0 TBC weekly 14
86 Chile Tarapacá CL-TA 2015-04-09 2015-04-15 2015   330558 25 0 TBC weekly 15
87 Chile Tarapacá CL-TA 2015-04-16 2015-04-22 2015   330558 29 0 TBC weekly 16
88 Chile Tarapacá CL-TA 2015-04-23 2015-04-29 2015   330558 30 0 TBC weekly 17
89 Chile Tarapacá CL-TA 2015-04-30 2015-05-06 2015   330558 30 0 TBC weekly 18
90 Chile Tarapacá CL-TA 2015-05-07 2015-05-13 2015   330558 24 0 TBC weekly 19
91 Chile Tarapacá CL-TA 2015-05-14 2015-05-20 2015   330558 25 0 TBC weekly 20
92 Chile Tarapacá CL-TA 2015-05-21 2015-05-27 2015   330558 32 0 TBC weekly 21
93 Chile Tarapacá CL-TA 2015-05-28 2015-06-03 2015   330558 25 0 TBC weekly 22
94 Chile Tarapacá CL-TA 2015-06-04 2015-06-10 2015   330558 27 0 TBC weekly 23
95 Chile Tarapacá CL-TA 2015-06-11 2015-06-17 2015   330558 26 0 TBC weekly 24
96 Chile Tarapacá CL-TA 2015-06-18 2015-06-24 2015   330558 18 0 TBC weekly 25
97 Chile Tarapacá CL-TA 2015-06-25 2015-07-01 2015   330558 26 0 TBC weekly 26
98 Chile Tarapacá CL-TA 2015-07-02 2015-07-08 2015   330558 24 0 TBC weekly 27
99 Chile Tarapacá CL-TA 2015-07-09 2015-07-15 2015   330558 29 0 TBC weekly 28
100 Chile Tarapacá CL-TA 2015-07-16 2015-07-22 2015   330558 29 0 TBC weekly 29

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,
   [year] INTEGER,
   [month] INTEGER,
   [population] INTEGER,
   [total_deaths] INTEGER,
   [covid_deaths] INTEGER,
   [expected_deaths] TEXT,
   [cadence] TEXT
, [week] INTEGER);