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

36,171 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 Sweden Sweden 0 2015-01-01 2015-01-07 2015 1 10338368 1937 0 TBC weekly  
2 Sweden Sweden 0 2015-01-08 2015-01-14 2015 2 10338368 1954 0 TBC weekly  
3 Sweden Sweden 0 2015-01-15 2015-01-21 2015 3 10338368 1937 0 TBC weekly  
4 Sweden Sweden 0 2015-01-22 2015-01-28 2015 4 10338368 1929 0 TBC weekly  
5 Sweden Sweden 0 2015-01-29 2015-02-04 2015 5 10338368 1966 0 TBC weekly  
6 Sweden Sweden 0 2015-02-05 2015-02-11 2015 6 10338368 1918 0 TBC weekly  
7 Sweden Sweden 0 2015-02-12 2015-02-18 2015 7 10338368 2050 0 TBC weekly  
8 Sweden Sweden 0 2015-02-19 2015-02-25 2015 8 10338368 2149 0 TBC weekly  
9 Sweden Sweden 0 2015-02-26 2015-03-04 2015 9 10338368 2041 0 TBC weekly  
10 Sweden Sweden 0 2015-03-05 2015-03-11 2015 10 10338368 1993 0 TBC weekly  
11 Sweden Sweden 0 2015-03-12 2015-03-18 2015 11 10338368 1881 0 TBC weekly  
12 Sweden Sweden 0 2015-03-19 2015-03-25 2015 12 10338368 1809 0 TBC weekly  
13 Sweden Sweden 0 2015-03-26 2015-04-01 2015 13 10338368 2044 0 TBC weekly  
14 Sweden Sweden 0 2015-04-02 2015-04-08 2015 14 10338368 1799 0 TBC weekly  
15 Sweden Sweden 0 2015-04-09 2015-04-15 2015 15 10338368 1813 0 TBC weekly  
16 Sweden Sweden 0 2015-04-16 2015-04-22 2015 16 10338368 1843 0 TBC weekly  
17 Sweden Sweden 0 2015-04-23 2015-04-29 2015 17 10338368 1724 0 TBC weekly  
18 Sweden Sweden 0 2015-04-30 2015-05-06 2015 18 10338368 1634 0 TBC weekly  
19 Sweden Sweden 0 2015-05-07 2015-05-13 2015 19 10338368 1662 0 TBC weekly  
20 Sweden Sweden 0 2015-05-14 2015-05-20 2015 20 10338368 1667 0 TBC weekly  
21 Sweden Sweden 0 2015-05-21 2015-05-27 2015 21 10338368 1623 0 TBC weekly  
22 Sweden Sweden 0 2015-05-28 2015-06-03 2015 22 10338368 1659 0 TBC weekly  
23 Sweden Sweden 0 2015-06-04 2015-06-10 2015 23 10338368 1571 0 TBC weekly  
24 Sweden Sweden 0 2015-06-11 2015-06-17 2015 24 10338368 1613 0 TBC weekly  
25 Sweden Sweden 0 2015-06-18 2015-06-24 2015 25 10338368 1594 0 TBC weekly  
26 Sweden Sweden 0 2015-06-25 2015-07-01 2015 26 10338368 1506 0 TBC weekly  
27 Sweden Sweden 0 2015-07-02 2015-07-08 2015 27 10338368 1711 0 TBC weekly  
28 Sweden Sweden 0 2015-07-09 2015-07-15 2015 28 10338368 1559 0 TBC weekly  
29 Sweden Sweden 0 2015-07-16 2015-07-22 2015 29 10338368 1508 0 TBC weekly  
30 Sweden Sweden 0 2015-07-23 2015-07-29 2015 30 10338368 1572 0 TBC weekly  
31 Sweden Sweden 0 2015-07-30 2015-08-05 2015 31 10338368 1562 0 TBC weekly  
32 Sweden Sweden 0 2015-08-06 2015-08-12 2015 32 10338368 1510 0 TBC weekly  
33 Sweden Sweden 0 2015-08-13 2015-08-19 2015 33 10338368 1542 0 TBC weekly  
34 Sweden Sweden 0 2015-08-20 2015-08-26 2015 34 10338368 1550 0 TBC weekly  
35 Sweden Sweden 0 2015-08-27 2015-09-02 2015 35 10338368 1534 0 TBC weekly  
36 Sweden Sweden 0 2015-09-03 2015-09-09 2015 36 10338368 1563 0 TBC weekly  
37 Sweden Sweden 0 2015-09-10 2015-09-16 2015 37 10338368 1584 0 TBC weekly  
38 Sweden Sweden 0 2015-09-17 2015-09-23 2015 38 10338368 1577 0 TBC weekly  
39 Sweden Sweden 0 2015-09-24 2015-09-30 2015 39 10338368 1671 0 TBC weekly  
40 Sweden Sweden 0 2015-10-01 2015-10-07 2015 40 10338368 1572 0 TBC weekly  
41 Sweden Sweden 0 2015-10-08 2015-10-14 2015 41 10338368 1565 0 TBC weekly  
42 Sweden Sweden 0 2015-10-15 2015-10-21 2015 42 10338368 1620 0 TBC weekly  
43 Sweden Sweden 0 2015-10-22 2015-10-28 2015 43 10338368 1643 0 TBC weekly  
44 Sweden Sweden 0 2015-10-29 2015-11-04 2015 44 10338368 1686 0 TBC weekly  
45 Sweden Sweden 0 2015-11-05 2015-11-11 2015 45 10338368 1721 0 TBC weekly  
46 Sweden Sweden 0 2015-11-12 2015-11-18 2015 46 10338368 1664 0 TBC weekly  
47 Sweden Sweden 0 2015-11-19 2015-11-25 2015 47 10338368 1683 0 TBC weekly  
48 Sweden Sweden 0 2015-11-26 2015-12-02 2015 48 10338368 1729 0 TBC weekly  
49 Sweden Sweden 0 2015-12-03 2015-12-09 2015 49 10338368 1761 0 TBC weekly  
50 Sweden Sweden 0 2015-12-10 2015-12-16 2015 50 10338368 1701 0 TBC weekly  
51 Sweden Sweden 0 2015-12-17 2015-12-23 2015 51 10338368 1744 0 TBC weekly  
52 Sweden Sweden 0 2015-12-24 2015-12-30 2015 52 10338368 1844 0 TBC weekly  
53 Sweden Sweden 0 2016-01-01 2016-01-07 2016 1 10338368 1846 0 TBC weekly  
54 Sweden Sweden 0 2016-01-08 2016-01-14 2016 2 10338368 1904 0 TBC weekly  
55 Sweden Sweden 0 2016-01-15 2016-01-21 2016 3 10338368 1969 0 TBC weekly  
56 Sweden Sweden 0 2016-01-22 2016-01-28 2016 4 10338368 1977 0 TBC weekly  
57 Sweden Sweden 0 2016-01-29 2016-02-04 2016 5 10338368 1931 0 TBC weekly  
58 Sweden Sweden 0 2016-02-05 2016-02-11 2016 6 10338368 1913 0 TBC weekly  
59 Sweden Sweden 0 2016-02-12 2016-02-18 2016 7 10338368 1783 0 TBC weekly  
60 Sweden Sweden 0 2016-02-19 2016-02-25 2016 8 10338368 1874 0 TBC weekly  
61 Sweden Sweden 0 2016-02-26 2016-03-03 2016 9 10338368 1806 0 TBC weekly  
62 Sweden Sweden 0 2016-03-04 2016-03-10 2016 10 10338368 1897 0 TBC weekly  
63 Sweden Sweden 0 2016-03-11 2016-03-17 2016 11 10338368 1751 0 TBC weekly  
64 Sweden Sweden 0 2016-03-18 2016-03-24 2016 12 10338368 1839 0 TBC weekly  
65 Sweden Sweden 0 2016-03-25 2016-03-31 2016 13 10338368 1739 0 TBC weekly  
66 Sweden Sweden 0 2016-04-01 2016-04-07 2016 14 10338368 1780 0 TBC weekly  
67 Sweden Sweden 0 2016-04-08 2016-04-14 2016 15 10338368 1710 0 TBC weekly  
68 Sweden Sweden 0 2016-04-15 2016-04-21 2016 16 10338368 1755 0 TBC weekly  
69 Sweden Sweden 0 2016-04-22 2016-04-28 2016 17 10338368 1723 0 TBC weekly  
70 Sweden Sweden 0 2016-04-29 2016-05-05 2016 18 10338368 1644 0 TBC weekly  
71 Sweden Sweden 0 2016-05-06 2016-05-12 2016 19 10338368 1572 0 TBC weekly  
72 Sweden Sweden 0 2016-05-13 2016-05-19 2016 20 10338368 1577 0 TBC weekly  
73 Sweden Sweden 0 2016-05-20 2016-05-26 2016 21 10338368 1504 0 TBC weekly  
74 Sweden Sweden 0 2016-05-27 2016-06-02 2016 22 10338368 1567 0 TBC weekly  
75 Sweden Sweden 0 2016-06-03 2016-06-09 2016 23 10338368 1494 0 TBC weekly  
76 Sweden Sweden 0 2016-06-10 2016-06-16 2016 24 10338368 1522 0 TBC weekly  
77 Sweden Sweden 0 2016-06-17 2016-06-23 2016 25 10338368 1522 0 TBC weekly  
78 Sweden Sweden 0 2016-06-24 2016-06-30 2016 26 10338368 1569 0 TBC weekly  
79 Sweden Sweden 0 2016-07-01 2016-07-07 2016 27 10338368 1543 0 TBC weekly  
80 Sweden Sweden 0 2016-07-08 2016-07-14 2016 28 10338368 1623 0 TBC weekly  
81 Sweden Sweden 0 2016-07-15 2016-07-21 2016 29 10338368 1575 0 TBC weekly  
82 Sweden Sweden 0 2016-07-22 2016-07-28 2016 30 10338368 1678 0 TBC weekly  
83 Sweden Sweden 0 2016-07-29 2016-08-04 2016 31 10338368 1574 0 TBC weekly  
84 Sweden Sweden 0 2016-08-05 2016-08-11 2016 32 10338368 1536 0 TBC weekly  
85 Sweden Sweden 0 2016-08-12 2016-08-18 2016 33 10338368 1612 0 TBC weekly  
86 Sweden Sweden 0 2016-08-19 2016-08-25 2016 34 10338368 1555 0 TBC weekly  
87 Sweden Sweden 0 2016-08-26 2016-09-01 2016 35 10338368 1628 0 TBC weekly  
88 Sweden Sweden 0 2016-09-02 2016-09-08 2016 36 10338368 1650 0 TBC weekly  
89 Sweden Sweden 0 2016-09-09 2016-09-15 2016 37 10338368 1507 0 TBC weekly  
90 Sweden Sweden 0 2016-09-16 2016-09-22 2016 38 10338368 1531 0 TBC weekly  
91 Sweden Sweden 0 2016-09-23 2016-09-29 2016 39 10338368 1594 0 TBC weekly  
92 Sweden Sweden 0 2016-09-30 2016-10-06 2016 40 10338368 1582 0 TBC weekly  
93 Sweden Sweden 0 2016-10-07 2016-10-13 2016 41 10338368 1606 0 TBC weekly  
94 Sweden Sweden 0 2016-10-14 2016-10-20 2016 42 10338368 1760 0 TBC weekly  
95 Sweden Sweden 0 2016-10-21 2016-10-27 2016 43 10338368 1649 0 TBC weekly  
96 Sweden Sweden 0 2016-10-28 2016-11-03 2016 44 10338368 1700 0 TBC weekly  
97 Sweden Sweden 0 2016-11-04 2016-11-10 2016 45 10338368 1698 0 TBC weekly  
98 Sweden Sweden 0 2016-11-11 2016-11-17 2016 46 10338368 1768 0 TBC weekly  
99 Sweden Sweden 0 2016-11-18 2016-11-24 2016 47 10338368 1739 0 TBC weekly  
100 Sweden Sweden 0 2016-11-25 2016-12-01 2016 48 10338368 1744 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] INTEGER,
   [covid_deaths] INTEGER,
   [expected_deaths] TEXT,
   [cadence] TEXT
, [month] INTEGER);
Powered by Datasette · Query took 730.511ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette