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

40,255 rows

✎ View and edit SQL

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

Suggested facets: year, month, 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
1 1 United States United States 0 2014-12-29 2015-01-04 7 2015 1 338289856 61889 0 TBC weekly  
2 2 United States United States 0 2015-01-05 2015-01-11 7 2015 2 338289856 61273 0 TBC weekly  
3 3 United States United States 0 2015-01-12 2015-01-18 7 2015 3 338289856 58754 0 TBC weekly  
4 4 United States United States 0 2015-01-19 2015-01-25 7 2015 4 338289856 57407 0 TBC weekly  
5 5 United States United States 0 2015-01-26 2015-02-01 7 2015 5 338289856 57474 0 TBC weekly  
6 6 United States United States 0 2015-02-02 2015-02-08 7 2015 6 338289856 56751 0 TBC weekly  
7 7 United States United States 0 2015-02-09 2015-02-15 7 2015 7 338289856 56788 0 TBC weekly  
8 8 United States United States 0 2015-02-16 2015-02-22 7 2015 8 338289856 56435 0 TBC weekly  
9 9 United States United States 0 2015-02-23 2015-03-01 7 2015 9 338289856 56602 0 TBC weekly  
10 10 United States United States 0 2015-03-02 2015-03-08 7 2015 10 338289856 55844 0 TBC weekly  
11 11 United States United States 0 2015-03-09 2015-03-15 7 2015 11 338289856 54567 0 TBC weekly  
12 12 United States United States 0 2015-03-16 2015-03-22 7 2015 12 338289856 53498 0 TBC weekly  
13 13 United States United States 0 2015-03-23 2015-03-29 7 2015 13 338289856 53316 0 TBC weekly  
14 14 United States United States 0 2015-03-30 2015-04-05 7 2015 14 338289856 52919 0 TBC weekly  
15 15 United States United States 0 2015-04-06 2015-04-12 7 2015 15 338289856 52972 0 TBC weekly  
16 16 United States United States 0 2015-04-13 2015-04-19 7 2015 16 338289856 51709 0 TBC weekly  
17 17 United States United States 0 2015-04-20 2015-04-26 7 2015 17 338289856 51597 0 TBC weekly  
18 18 United States United States 0 2015-04-27 2015-05-03 7 2015 18 338289856 51776 0 TBC weekly  
19 19 United States United States 0 2015-05-04 2015-05-10 7 2015 19 338289856 50808 0 TBC weekly  
20 20 United States United States 0 2015-05-11 2015-05-17 7 2015 20 338289856 49495 0 TBC weekly  
21 21 United States United States 0 2015-05-18 2015-05-24 7 2015 21 338289856 49942 0 TBC weekly  
22 22 United States United States 0 2015-05-25 2015-05-31 7 2015 22 338289856 49350 0 TBC weekly  
23 23 United States United States 0 2015-06-01 2015-06-07 7 2015 23 338289856 49902 0 TBC weekly  
24 24 United States United States 0 2015-06-08 2015-06-14 7 2015 24 338289856 49227 0 TBC weekly  
25 25 United States United States 0 2015-06-15 2015-06-21 7 2015 25 338289856 49174 0 TBC weekly  
26 26 United States United States 0 2015-06-22 2015-06-28 7 2015 26 338289856 49357 0 TBC weekly  
27 27 United States United States 0 2015-06-29 2015-07-05 7 2015 27 338289856 49048 0 TBC weekly  
28 28 United States United States 0 2015-07-06 2015-07-12 7 2015 28 338289856 49366 0 TBC weekly  
29 29 United States United States 0 2015-07-13 2015-07-19 7 2015 29 338289856 48759 0 TBC weekly  
30 30 United States United States 0 2015-07-20 2015-07-26 7 2015 30 338289856 48825 0 TBC weekly  
31 31 United States United States 0 2015-07-27 2015-08-02 7 2015 31 338289856 48448 0 TBC weekly  
32 32 United States United States 0 2015-08-03 2015-08-09 7 2015 32 338289856 48285 0 TBC weekly  
33 33 United States United States 0 2015-08-10 2015-08-16 7 2015 33 338289856 48570 0 TBC weekly  
34 34 United States United States 0 2015-08-17 2015-08-23 7 2015 34 338289856 48636 0 TBC weekly  
35 35 United States United States 0 2015-08-24 2015-08-30 7 2015 35 338289856 48849 0 TBC weekly  
36 36 United States United States 0 2015-08-31 2015-09-06 7 2015 36 338289856 48932 0 TBC weekly  
37 37 United States United States 0 2015-09-07 2015-09-13 7 2015 37 338289856 49045 0 TBC weekly  
38 38 United States United States 0 2015-09-14 2015-09-20 7 2015 38 338289856 49399 0 TBC weekly  
39 39 United States United States 0 2015-09-21 2015-09-27 7 2015 39 338289856 48993 0 TBC weekly  
40 40 United States United States 0 2015-09-28 2015-10-04 7 2015 40 338289856 51191 0 TBC weekly  
41 41 United States United States 0 2015-10-05 2015-10-11 7 2015 41 338289856 50145 0 TBC weekly  
42 42 United States United States 0 2015-10-12 2015-10-18 7 2015 42 338289856 51018 0 TBC weekly  
43 43 United States United States 0 2015-10-19 2015-10-25 7 2015 43 338289856 50569 0 TBC weekly  
44 44 United States United States 0 2015-10-26 2015-11-01 7 2015 44 338289856 51288 0 TBC weekly  
45 45 United States United States 0 2015-11-02 2015-11-08 7 2015 45 338289856 50834 0 TBC weekly  
46 46 United States United States 0 2015-11-09 2015-11-15 7 2015 46 338289856 51917 0 TBC weekly  
47 47 United States United States 0 2015-11-16 2015-11-22 7 2015 47 338289856 51590 0 TBC weekly  
48 48 United States United States 0 2015-11-23 2015-11-29 7 2015 48 338289856 52160 0 TBC weekly  
49 49 United States United States 0 2015-11-30 2015-12-06 7 2015 49 338289856 53846 0 TBC weekly  
50 50 United States United States 0 2015-12-07 2015-12-13 7 2015 50 338289856 52379 0 TBC weekly  
51 51 United States United States 0 2015-12-14 2015-12-20 7 2015 51 338289856 53313 0 TBC weekly  
52 52 United States United States 0 2015-12-21 2015-12-27 7 2015 52 338289856 52746 0 TBC weekly  
53 53 United States United States 0 2016-01-04 2016-01-10 7 2016 1 338289856 55989 0 TBC weekly  
54 54 United States United States 0 2016-01-11 2016-01-17 7 2016 2 338289856 55710 0 TBC weekly  
55 55 United States United States 0 2016-01-18 2016-01-24 7 2016 3 338289856 55318 0 TBC weekly  
56 56 United States United States 0 2016-01-25 2016-01-31 7 2016 4 338289856 55769 0 TBC weekly  
57 57 United States United States 0 2016-02-01 2016-02-07 7 2016 5 338289856 55238 0 TBC weekly  
58 58 United States United States 0 2016-02-08 2016-02-14 7 2016 6 338289856 55582 0 TBC weekly  
59 59 United States United States 0 2016-02-15 2016-02-21 7 2016 7 338289856 56279 0 TBC weekly  
60 60 United States United States 0 2016-02-22 2016-02-28 7 2016 8 338289856 55308 0 TBC weekly  
61 61 United States United States 0 2016-02-29 2016-03-06 7 2016 9 338289856 56033 0 TBC weekly  
62 62 United States United States 0 2016-03-07 2016-03-13 7 2016 10 338289856 56323 0 TBC weekly  
63 63 United States United States 0 2016-03-14 2016-03-20 7 2016 11 338289856 54670 0 TBC weekly  
64 64 United States United States 0 2016-03-21 2016-03-27 7 2016 12 338289856 54922 0 TBC weekly  
65 65 United States United States 0 2016-03-28 2016-04-03 7 2016 13 338289856 54043 0 TBC weekly  
66 66 United States United States 0 2016-04-04 2016-04-10 7 2016 14 338289856 54173 0 TBC weekly  
67 67 United States United States 0 2016-04-11 2016-04-17 7 2016 15 338289856 53601 0 TBC weekly  
68 68 United States United States 0 2016-04-18 2016-04-24 7 2016 16 338289856 53257 0 TBC weekly  
69 69 United States United States 0 2016-04-25 2016-05-01 7 2016 17 338289856 51166 0 TBC weekly  
70 70 United States United States 0 2016-05-02 2016-05-08 7 2016 18 338289856 51374 0 TBC weekly  
71 71 United States United States 0 2016-05-09 2016-05-15 7 2016 19 338289856 51107 0 TBC weekly  
72 72 United States United States 0 2016-05-16 2016-05-22 7 2016 20 338289856 50555 0 TBC weekly  
73 73 United States United States 0 2016-05-23 2016-05-29 7 2016 21 338289856 50587 0 TBC weekly  
74 74 United States United States 0 2016-05-30 2016-06-05 7 2016 22 338289856 49820 0 TBC weekly  
75 75 United States United States 0 2016-06-06 2016-06-12 7 2016 23 338289856 50026 0 TBC weekly  
76 76 United States United States 0 2016-06-13 2016-06-19 7 2016 24 338289856 49998 0 TBC weekly  
77 77 United States United States 0 2016-06-20 2016-06-26 7 2016 25 338289856 49720 0 TBC weekly  
78 78 United States United States 0 2016-06-27 2016-07-03 7 2016 26 338289856 49846 0 TBC weekly  
79 79 United States United States 0 2016-07-04 2016-07-10 7 2016 27 338289856 49795 0 TBC weekly  
80 80 United States United States 0 2016-07-11 2016-07-17 7 2016 28 338289856 49734 0 TBC weekly  
81 81 United States United States 0 2016-07-18 2016-07-24 7 2016 29 338289856 49378 0 TBC weekly  
82 82 United States United States 0 2016-07-25 2016-07-31 7 2016 30 338289856 49800 0 TBC weekly  
83 83 United States United States 0 2016-08-01 2016-08-07 7 2016 31 338289856 49640 0 TBC weekly  
84 84 United States United States 0 2016-08-08 2016-08-14 7 2016 32 338289856 49833 0 TBC weekly  
85 85 United States United States 0 2016-08-15 2016-08-21 7 2016 33 338289856 49924 0 TBC weekly  
86 86 United States United States 0 2016-08-22 2016-08-28 7 2016 34 338289856 49608 0 TBC weekly  
87 87 United States United States 0 2016-08-29 2016-09-04 7 2016 35 338289856 49695 0 TBC weekly  
88 88 United States United States 0 2016-09-05 2016-09-11 7 2016 36 338289856 50200 0 TBC weekly  
89 89 United States United States 0 2016-09-12 2016-09-18 7 2016 37 338289856 50037 0 TBC weekly  
90 90 United States United States 0 2016-09-19 2016-09-25 7 2016 38 338289856 49990 0 TBC weekly  
91 91 United States United States 0 2016-09-26 2016-10-02 7 2016 39 338289856 50365 0 TBC weekly  
92 92 United States United States 0 2016-10-03 2016-10-09 7 2016 40 338289856 51518 0 TBC weekly  
93 93 United States United States 0 2016-10-10 2016-10-16 7 2016 41 338289856 52245 0 TBC weekly  
94 94 United States United States 0 2016-10-17 2016-10-23 7 2016 42 338289856 51568 0 TBC weekly  
95 95 United States United States 0 2016-10-24 2016-10-30 7 2016 43 338289856 51969 0 TBC weekly  
96 96 United States United States 0 2016-10-31 2016-11-06 7 2016 44 338289856 51876 0 TBC weekly  
97 97 United States United States 0 2016-11-07 2016-11-13 7 2016 45 338289856 52649 0 TBC weekly  
98 98 United States United States 0 2016-11-14 2016-11-20 7 2016 46 338289856 53568 0 TBC weekly  
99 99 United States United States 0 2016-11-21 2016-11-27 7 2016 47 338289856 53264 0 TBC weekly  
100 100 United States United States 0 2016-11-28 2016-12-04 7 2016 48 338289856 54716 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);
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]);