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

39,432 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 week population total_deaths covid_deaths expected_deaths cadence month
1 Brazil Brazil 0 2019-12-29 2020-01-04 2020 1 210147125 23671.5111772738 0 22066 weekly  
2 Brazil Brazil 0 2020-01-05 2020-01-11 2020 2 210147125 22758.067115867 0 20970 weekly  
3 Brazil Brazil 0 2020-01-12 2020-01-18 2020 3 210147125 22417.749709802 0 21986 weekly  
4 Brazil Brazil 0 2020-01-19 2020-01-25 2020 4 210147125 22183.288448209 0 22056 weekly  
5 Brazil Brazil 0 2020-01-26 2020-02-01 2020 5 210147125 22479.588777643 0 21896 weekly  
6 Brazil Brazil 0 2020-02-02 2020-02-08 2020 6 210147125 22458.775431111 0 21558 weekly  
7 Brazil Brazil 0 2020-02-09 2020-02-15 2020 7 210147125 22209.463721156 0 21140 weekly  
8 Brazil Brazil 0 2020-02-16 2020-02-22 2020 8 210147125 22541.753100755 0 21118 weekly  
9 Brazil Brazil 0 2020-02-23 2020-02-29 2020 9 210147125 22840.94102936 0 21932 weekly  
10 Brazil Brazil 0 2020-03-01 2020-03-07 2020 10 210147125 23125.754728245 0 22063 weekly  
11 Brazil Brazil 0 2020-03-08 2020-03-14 2020 11 210147125 23854.889045064 0 22642 weekly  
12 Brazil Brazil 0 2020-03-15 2020-03-21 2020 12 210147125 24584.063329766 18 22340 weekly  
13 Brazil Brazil 0 2020-03-22 2020-03-28 2020 13 210147125 23774.214541388 96 21412 weekly  
14 Brazil Brazil 0 2020-03-29 2020-04-04 2020 14 210147125 24116.528555237 318 21818 weekly  
15 Brazil Brazil 0 2020-04-05 2020-04-11 2020 15 210147125 24563.738391342 692 22414 weekly  
16 Brazil Brazil 0 2020-04-12 2020-04-18 2020 16 210147125 25417.117952793 1223 22683 weekly  
17 Brazil Brazil 0 2020-04-19 2020-04-25 2020 17 210147125 28392.768063395 1669 23326 weekly  
18 Brazil Brazil 0 2020-04-26 2020-05-02 2020 18 210147125 31309.983317462 2734 23154 weekly  
19 Brazil Brazil 0 2020-05-03 2020-05-09 2020 19 210147125 32812.615095571 3877 23578 weekly  
20 Brazil Brazil 0 2020-05-10 2020-05-16 2020 20 210147125 33090.750714532 5006 23679 weekly  
21 Brazil Brazil 0 2020-05-17 2020-05-23 2020 21 210147125 32110.364795273 6380 24407 weekly  
22 Brazil Brazil 0 2020-05-24 2020-05-30 2020 22 210147125 31722.293412287 6821 24955 weekly  
23 Brazil Brazil 0 2020-05-31 2020-06-06 2020 23 210147125 31370.70473437 7096 25195 weekly  
24 Brazil Brazil 0 2020-06-07 2020-06-13 2020 24 210147125 30519.323562089 6790 25466 weekly  
25 Brazil Brazil 0 2020-06-14 2020-06-20 2020 25 210147125 29423.773981997 7256 24958 weekly  
26 Brazil Brazil 0 2020-06-21 2020-06-27 2020 26 210147125 28953.340371989 7094 24983 weekly  
27 Brazil Brazil 0 2020-06-28 2020-07-04 2020 27 210147125 29318.668960448 7195 24801 weekly  
28 Brazil Brazil 0 2020-07-05 2020-07-11 2020 28 210147125 30019.841002943 7204 25906 weekly  
29 Brazil Brazil 0 2020-07-12 2020-07-18 2020 29 210147125 30242.969955557 7303 25976 weekly  
30 Brazil Brazil 0 2020-07-19 2020-07-25 2020 30 210147125 29606.784772609 7677 24905 weekly  
31 Brazil Brazil 0 2020-07-26 2020-08-01 2020 31 210147125 28585.781393508 7114 24518 weekly  
32 Brazil Brazil 0 2020-08-02 2020-08-08 2020 32 210147125 28493.536703417 6914 24702 weekly  
33 Brazil Brazil 0 2020-08-09 2020-08-15 2020 33 210147125 27807.310708485 6755 24483 weekly  
34 Turkey Istanbul 0 2017-01-01 2017-01-07 2017 1 15519267 1952.0 0 TBC weekly  
35 Turkey Istanbul 0 2017-01-08 2017-01-14 2017 2 15519267 1957.0 0 TBC weekly  
36 Turkey Istanbul 0 2017-01-15 2017-01-21 2017 3 15519267 1824.0 0 TBC weekly  
37 Turkey Istanbul 0 2017-01-22 2017-01-28 2017 4 15519267 1800.0 0 TBC weekly  
38 Turkey Istanbul 0 2017-01-29 2017-02-04 2017 5 15519267 1591.0 0 TBC weekly  
39 Turkey Istanbul 0 2017-02-05 2017-02-11 2017 6 15519267 1608.0 0 TBC weekly  
40 Turkey Istanbul 0 2017-02-12 2017-02-18 2017 7 15519267 1508.0 0 TBC weekly  
41 Turkey Istanbul 0 2017-02-19 2017-02-25 2017 8 15519267 1536.0 0 TBC weekly  
42 Turkey Istanbul 0 2017-02-26 2017-03-04 2017 9 15519267 1487.5 0 TBC weekly  
43 Turkey Istanbul 0 2017-03-05 2017-03-11 2017 10 15519267 1487.0 0 TBC weekly  
44 Turkey Istanbul 0 2017-03-12 2017-03-18 2017 11 15519267 1441.0 0 TBC weekly  
45 Turkey Istanbul 0 2017-03-19 2017-03-25 2017 12 15519267 1491.0 0 TBC weekly  
46 Turkey Istanbul 0 2017-03-26 2017-04-01 2017 13 15519267 1422.0 0 TBC weekly  
47 Turkey Istanbul 0 2017-04-02 2017-04-08 2017 14 15519267 1405.0 0 TBC weekly  
48 Turkey Istanbul 0 2017-04-09 2017-04-15 2017 15 15519267 1507.0 0 TBC weekly  
49 Turkey Istanbul 0 2017-04-16 2017-04-22 2017 16 15519267 1409.0 0 TBC weekly  
50 Turkey Istanbul 0 2017-04-23 2017-04-29 2017 17 15519267 1419.0 0 TBC weekly  
51 Turkey Istanbul 0 2017-04-30 2017-05-06 2017 18 15519267 1355.0 0 TBC weekly  
52 Turkey Istanbul 0 2017-05-07 2017-05-13 2017 19 15519267 1357.0 0 TBC weekly  
53 Turkey Istanbul 0 2017-05-14 2017-05-20 2017 20 15519267 1346.0 0 TBC weekly  
54 Turkey Istanbul 0 2017-05-21 2017-05-27 2017 21 15519267 1418.0 0 TBC weekly  
55 Turkey Istanbul 0 2017-05-28 2017-06-03 2017 22 15519267 1379.0 0 TBC weekly  
56 Turkey Istanbul 0 2017-06-04 2017-06-10 2017 23 15519267 1241.0 0 TBC weekly  
57 Turkey Istanbul 0 2017-06-11 2017-06-17 2017 24 15519267 1327.0 0 TBC weekly  
58 Turkey Istanbul 0 2017-06-18 2017-06-24 2017 25 15519267 1262.0 0 TBC weekly  
59 Turkey Istanbul 0 2017-06-25 2017-07-01 2017 26 15519267 1378.0 0 TBC weekly  
60 Turkey Istanbul 0 2017-07-02 2017-07-08 2017 27 15519267 1540.0 0 TBC weekly  
61 Turkey Istanbul 0 2017-07-09 2017-07-15 2017 28 15519267 1364.0 0 TBC weekly  
62 Turkey Istanbul 0 2017-07-16 2017-07-22 2017 29 15519267 1246.0 0 TBC weekly  
63 Turkey Istanbul 0 2017-07-23 2017-07-29 2017 30 15519267 1308.0 0 TBC weekly  
64 Turkey Istanbul 0 2017-07-30 2017-08-05 2017 31 15519267 1302.0 0 TBC weekly  
65 Turkey Istanbul 0 2017-08-06 2017-08-12 2017 32 15519267 1253.0 0 TBC weekly  
66 Turkey Istanbul 0 2017-08-13 2017-08-19 2017 33 15519267 1270.0 0 TBC weekly  
67 Turkey Istanbul 0 2017-08-20 2017-08-26 2017 34 15519267 1301.0 0 TBC weekly  
68 Turkey Istanbul 0 2018-01-01 2018-01-07 2018 1 15519267 1552.0 0 TBC weekly  
69 Turkey Istanbul 0 2018-01-08 2018-01-14 2018 2 15519267 1517.0 0 TBC weekly  
70 Turkey Istanbul 0 2018-01-15 2018-01-21 2018 3 15519267 1643.0 0 TBC weekly  
71 Turkey Istanbul 0 2018-01-22 2018-01-28 2018 4 15519267 1633.0 0 TBC weekly  
72 Turkey Istanbul 0 2018-01-29 2018-02-04 2018 5 15519267 1618.0 0 TBC weekly  
73 Turkey Istanbul 0 2018-02-05 2018-02-11 2018 6 15519267 1539.0 0 TBC weekly  
74 Turkey Istanbul 0 2018-02-12 2018-02-18 2018 7 15519267 1458.0 0 TBC weekly  
75 Turkey Istanbul 0 2018-02-19 2018-02-25 2018 8 15519267 1511.0 0 TBC weekly  
76 Turkey Istanbul 0 2018-02-26 2018-03-04 2018 9 15519267 1614.0 0 TBC weekly  
77 Turkey Istanbul 0 2018-03-05 2018-03-11 2018 10 15519267 1498.0 0 TBC weekly  
78 Turkey Istanbul 0 2018-03-12 2018-03-18 2018 11 15519267 1479.0 0 TBC weekly  
79 Turkey Istanbul 0 2018-03-19 2018-03-25 2018 12 15519267 1464.0 0 TBC weekly  
80 Turkey Istanbul 0 2018-03-26 2018-04-01 2018 13 15519267 1408.0 0 TBC weekly  
81 Turkey Istanbul 0 2018-04-02 2018-04-08 2018 14 15519267 1465.0 0 TBC weekly  
82 Turkey Istanbul 0 2018-04-09 2018-04-15 2018 15 15519267 1463.0 0 TBC weekly  
83 Turkey Istanbul 0 2018-04-16 2018-04-22 2018 16 15519267 1398.0 0 TBC weekly  
84 Turkey Istanbul 0 2018-04-23 2018-04-29 2018 17 15519267 1468.0 0 TBC weekly  
85 Turkey Istanbul 0 2018-04-30 2018-05-06 2018 18 15519267 1351.0 0 TBC weekly  
86 Turkey Istanbul 0 2018-05-07 2018-05-13 2018 19 15519267 1441.0 0 TBC weekly  
87 Turkey Istanbul 0 2018-05-14 2018-05-20 2018 20 15519267 1379.0 0 TBC weekly  
88 Turkey Istanbul 0 2018-05-21 2018-05-27 2018 21 15519267 1417.0 0 TBC weekly  
89 Turkey Istanbul 0 2018-05-28 2018-06-03 2018 22 15519267 1282.0 0 TBC weekly  
90 Turkey Istanbul 0 2018-06-04 2018-06-10 2018 23 15519267 1402.0 0 TBC weekly  
91 Turkey Istanbul 0 2018-06-11 2018-06-17 2018 24 15519267 1294.0 0 TBC weekly  
92 Turkey Istanbul 0 2018-06-18 2018-06-24 2018 25 15519267 1398.0 0 TBC weekly  
93 Turkey Istanbul 0 2018-06-25 2018-07-01 2018 26 15519267 1333.0 0 TBC weekly  
94 Turkey Istanbul 0 2018-07-02 2018-07-08 2018 27 15519267 1354.0 0 TBC weekly  
95 Turkey Istanbul 0 2018-07-09 2018-07-15 2018 28 15519267 1403.0 0 TBC weekly  
96 Turkey Istanbul 0 2018-07-16 2018-07-22 2018 29 15519267 1389.0 0 TBC weekly  
97 Turkey Istanbul 0 2018-07-23 2018-07-29 2018 30 15519267 1301.0 0 TBC weekly  
98 Turkey Istanbul 0 2018-07-30 2018-08-05 2018 31 15519267 1330.0 0 TBC weekly  
99 Turkey Istanbul 0 2018-08-06 2018-08-12 2018 32 15519267 1403.0 0 TBC weekly  
100 Turkey Istanbul 0 2018-08-13 2018-08-19 2018 33 15519267 1413.0 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,
   [year] INTEGER,
   [week] INTEGER,
   [population] INTEGER,
   [total_deaths] FLOAT,
   [covid_deaths] INTEGER,
   [expected_deaths] INTEGER,
   [cadence] TEXT
, [month] INTEGER);
Powered by Datasette · Query took 790.867ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette