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

34,904 rows

View and edit SQL

country

cadence

Link rowid ▼ country region region_code start_date end_date year week population total_deaths covid_deaths expected_deaths cadence month
101 Mexico Mexico City MX-CMX 2017-12-04 2017-12-10 2017 49 8918653 1537 0 TBC weekly  
102 Mexico Mexico City MX-CMX 2017-12-11 2017-12-17 2017 50 8918653 1659 0 TBC weekly  
103 Mexico Mexico City MX-CMX 2017-12-18 2017-12-24 2017 51 8918653 1634 0 TBC weekly  
104 Mexico Mexico City MX-CMX 2017-12-25 2017-12-31 2017 52 8918653 1651 0 TBC weekly  
105 Mexico Mexico City MX-CMX 2018-01-01 2018-01-07 2018 1 8918653 1935 0 TBC weekly  
106 Mexico Mexico City MX-CMX 2018-01-08 2018-01-14 2018 2 8918653 1771 0 TBC weekly  
107 Mexico Mexico City MX-CMX 2018-01-15 2018-01-21 2018 3 8918653 1914 0 TBC weekly  
108 Mexico Mexico City MX-CMX 2018-01-22 2018-01-28 2018 4 8918653 1850 0 TBC weekly  
109 Mexico Mexico City MX-CMX 2018-01-29 2018-02-04 2018 5 8918653 1790 0 TBC weekly  
110 Mexico Mexico City MX-CMX 2018-02-05 2018-02-11 2018 6 8918653 1748 0 TBC weekly  
111 Mexico Mexico City MX-CMX 2018-02-12 2018-02-18 2018 7 8918653 1581 0 TBC weekly  
112 Mexico Mexico City MX-CMX 2018-02-19 2018-02-25 2018 8 8918653 1657 0 TBC weekly  
113 Mexico Mexico City MX-CMX 2018-02-26 2018-03-04 2018 9 8918653 1575 0 TBC weekly  
114 Mexico Mexico City MX-CMX 2018-03-05 2018-03-11 2018 10 8918653 1410 0 TBC weekly  
115 Mexico Mexico City MX-CMX 2018-03-12 2018-03-18 2018 11 8918653 1457 0 TBC weekly  
116 Mexico Mexico City MX-CMX 2018-03-19 2018-03-25 2018 12 8918653 1393 0 TBC weekly  
117 Mexico Mexico City MX-CMX 2018-03-26 2018-04-01 2018 13 8918653 1350 0 TBC weekly  
118 Mexico Mexico City MX-CMX 2018-04-02 2018-04-08 2018 14 8918653 1415 0 TBC weekly  
119 Mexico Mexico City MX-CMX 2018-04-09 2018-04-15 2018 15 8918653 1403 0 TBC weekly  
120 Mexico Mexico City MX-CMX 2018-04-16 2018-04-22 2018 16 8918653 1357 0 TBC weekly  
121 Mexico Mexico City MX-CMX 2018-04-23 2018-04-29 2018 17 8918653 1377 0 TBC weekly  
122 Mexico Mexico City MX-CMX 2018-04-30 2018-05-06 2018 18 8918653 1389 0 TBC weekly  
123 Mexico Mexico City MX-CMX 2018-05-07 2018-05-13 2018 19 8918653 1401 0 TBC weekly  
124 Mexico Mexico City MX-CMX 2018-05-14 2018-05-20 2018 20 8918653 1408 0 TBC weekly  
125 Mexico Mexico City MX-CMX 2018-05-21 2018-05-27 2018 21 8918653 1317 0 TBC weekly  
126 Mexico Mexico City MX-CMX 2018-05-28 2018-06-03 2018 22 8918653 1416 0 TBC weekly  
127 Mexico Mexico City MX-CMX 2018-06-04 2018-06-10 2018 23 8918653 1386 0 TBC weekly  
128 Mexico Mexico City MX-CMX 2018-06-11 2018-06-17 2018 24 8918653 1333 0 TBC weekly  
129 Mexico Mexico City MX-CMX 2018-06-18 2018-06-24 2018 25 8918653 1399 0 TBC weekly  
130 Mexico Mexico City MX-CMX 2018-06-25 2018-07-01 2018 26 8918653 1386 0 TBC weekly  
131 Mexico Mexico City MX-CMX 2018-07-02 2018-07-08 2018 27 8918653 1286 0 TBC weekly  
132 Mexico Mexico City MX-CMX 2018-07-09 2018-07-15 2018 28 8918653 1366 0 TBC weekly  
133 Mexico Mexico City MX-CMX 2018-07-16 2018-07-22 2018 29 8918653 1369 0 TBC weekly  
134 Mexico Mexico City MX-CMX 2018-07-23 2018-07-29 2018 30 8918653 1361 0 TBC weekly  
135 Mexico Mexico City MX-CMX 2018-07-30 2018-08-05 2018 31 8918653 1315 0 TBC weekly  
136 Mexico Mexico City MX-CMX 2018-08-06 2018-08-12 2018 32 8918653 1397 0 TBC weekly  
137 Mexico Mexico City MX-CMX 2018-08-13 2018-08-19 2018 33 8918653 1369 0 TBC weekly  
138 Mexico Mexico City MX-CMX 2018-08-20 2018-08-26 2018 34 8918653 1319 0 TBC weekly  
139 Mexico Mexico City MX-CMX 2018-08-27 2018-09-02 2018 35 8918653 1324 0 TBC weekly  
140 Mexico Mexico City MX-CMX 2018-09-03 2018-09-09 2018 36 8918653 1399 0 TBC weekly  
141 Mexico Mexico City MX-CMX 2018-09-10 2018-09-16 2018 37 8918653 1393 0 TBC weekly  
142 Mexico Mexico City MX-CMX 2018-09-17 2018-09-23 2018 38 8918653 1397 0 TBC weekly  
143 Mexico Mexico City MX-CMX 2018-09-24 2018-09-30 2018 39 8918653 1354 0 TBC weekly  
144 Mexico Mexico City MX-CMX 2018-10-01 2018-10-07 2018 40 8918653 1323 0 TBC weekly  
145 Mexico Mexico City MX-CMX 2018-10-08 2018-10-14 2018 41 8918653 1441 0 TBC weekly  
146 Mexico Mexico City MX-CMX 2018-10-15 2018-10-21 2018 42 8918653 1403 0 TBC weekly  
147 Mexico Mexico City MX-CMX 2018-10-22 2018-10-28 2018 43 8918653 1495 0 TBC weekly  
148 Mexico Mexico City MX-CMX 2018-10-29 2018-11-04 2018 44 8918653 1420 0 TBC weekly  
149 Mexico Mexico City MX-CMX 2018-11-05 2018-11-11 2018 45 8918653 1455 0 TBC weekly  
150 Mexico Mexico City MX-CMX 2018-11-12 2018-11-18 2018 46 8918653 1519 0 TBC weekly  
151 Mexico Mexico City MX-CMX 2018-11-19 2018-11-25 2018 47 8918653 1538 0 TBC weekly  
152 Mexico Mexico City MX-CMX 2018-11-26 2018-12-02 2018 48 8918653 1563 0 TBC weekly  
153 Mexico Mexico City MX-CMX 2018-12-03 2018-12-09 2018 49 8918653 1608 0 TBC weekly  
154 Mexico Mexico City MX-CMX 2018-12-10 2018-12-16 2018 50 8918653 1556 0 TBC weekly  
155 Mexico Mexico City MX-CMX 2018-12-17 2018-12-23 2018 51 8918653 1708 0 TBC weekly  
156 Mexico Mexico City MX-CMX 2018-12-24 2018-12-30 2018 52 8918653 1876 0 TBC weekly  
157 Mexico Mexico City MX-CMX 2019-03-04 2019-03-10 2019 10 8918653 1498 0 TBC weekly  
158 Mexico Mexico City MX-CMX 2019-03-11 2019-03-17 2019 11 8918653 1495 0 TBC weekly  
159 Mexico Mexico City MX-CMX 2019-03-18 2019-03-24 2019 12 8918653 1484 0 TBC weekly  
160 Mexico Mexico City MX-CMX 2019-03-25 2019-03-31 2019 13 8918653 1519 0 TBC weekly  
161 Mexico Mexico City MX-CMX 2019-04-01 2019-04-07 2019 14 8918653 1466 0 TBC weekly  
162 Mexico Mexico City MX-CMX 2019-04-08 2019-04-14 2019 15 8918653 1489 0 TBC weekly  
163 Mexico Mexico City MX-CMX 2019-04-15 2019-04-21 2019 16 8918653 1468 0 TBC weekly  
164 Mexico Mexico City MX-CMX 2019-04-22 2019-04-28 2019 17 8918653 1377 0 TBC weekly  
165 Mexico Mexico City MX-CMX 2019-04-29 2019-05-05 2019 18 8918653 1379 0 TBC weekly  
166 Mexico Mexico City MX-CMX 2019-05-06 2019-05-12 2019 19 8918653 1463 0 TBC weekly  
167 Mexico Mexico City MX-CMX 2019-05-13 2019-05-19 2019 20 8918653 1430 0 TBC weekly  
168 Mexico Mexico City MX-CMX 2019-05-20 2019-05-26 2019 21 8918653 1430 0 TBC weekly  
169 Mexico Mexico City MX-CMX 2019-05-27 2019-06-02 2019 22 8918653 1437 0 TBC weekly  
170 Mexico Mexico City MX-CMX 2019-06-03 2019-06-09 2019 23 8918653 1315 0 TBC weekly  
171 Mexico Mexico City MX-CMX 2020-03-02 2020-03-08 2020 10 8918653 1430 0 TBC weekly  
172 Mexico Mexico City MX-CMX 2020-03-09 2020-03-15 2020 11 8918653 1550 0 TBC weekly  
173 Mexico Mexico City MX-CMX 2020-03-16 2020-03-22 2020 12 8918653 1407 1 TBC weekly  
174 Mexico Mexico City MX-CMX 2020-03-23 2020-03-29 2020 13 8918653 1499 6 TBC weekly  
175 Mexico Mexico City MX-CMX 2020-03-30 2020-04-05 2020 14 8918653 1491 12 TBC weekly  
176 Mexico Mexico City MX-CMX 2020-04-06 2020-04-12 2020 15 8918653 1624 37 TBC weekly  
177 Mexico Mexico City MX-CMX 2020-04-13 2020-04-19 2020 16 8918653 1828 127 TBC weekly  
178 Mexico Mexico City MX-CMX 2020-04-20 2020-04-26 2020 17 8918653 2475 126 TBC weekly  
179 Mexico Mexico City MX-CMX 2020-04-27 2020-05-03 2020 18 8918653 3508 163 TBC weekly  
180 Mexico Mexico City MX-CMX 2020-05-04 2020-05-10 2020 19 8918653 4127 324 TBC weekly  
181 Mexico Mexico City MX-CMX 2020-05-11 2020-05-17 2020 20 8918653 4188 536 TBC weekly  
182 Mexico Mexico City MX-CMX 2020-05-18 2020-05-24 2020 21 8918653 4313 631 TBC weekly  
183 Mexico Mexico City MX-CMX 2020-05-25 2020-05-31 2020 22 8918653 3840 695 TBC weekly  
184 Mexico Mexico City MX-CMX 2020-06-01 2020-06-07 2020 23 8918653 3815 1071 TBC weekly  
185 Sweden Sweden 0 2015-01-01 2015-01-07 2015 1 10338368 1937 0 TBC weekly  
186 Sweden Sweden 0 2015-01-08 2015-01-14 2015 2 10338368 1954 0 TBC weekly  
187 Sweden Sweden 0 2015-01-15 2015-01-21 2015 3 10338368 1937 0 TBC weekly  
188 Sweden Sweden 0 2015-01-22 2015-01-28 2015 4 10338368 1929 0 TBC weekly  
189 Sweden Sweden 0 2015-01-29 2015-02-04 2015 5 10338368 1966 0 TBC weekly  
190 Sweden Sweden 0 2015-02-05 2015-02-11 2015 6 10338368 1918 0 TBC weekly  
191 Sweden Sweden 0 2015-02-12 2015-02-18 2015 7 10338368 2050 0 TBC weekly  
192 Sweden Sweden 0 2015-02-19 2015-02-25 2015 8 10338368 2149 0 TBC weekly  
193 Sweden Sweden 0 2015-02-26 2015-03-04 2015 9 10338368 2041 0 TBC weekly  
194 Sweden Sweden 0 2015-03-05 2015-03-11 2015 10 10338368 1993 0 TBC weekly  
195 Sweden Sweden 0 2015-03-12 2015-03-18 2015 11 10338368 1881 0 TBC weekly  
196 Sweden Sweden 0 2015-03-19 2015-03-25 2015 12 10338368 1809 0 TBC weekly  
197 Sweden Sweden 0 2015-03-26 2015-04-01 2015 13 10338368 2044 0 TBC weekly  
198 Sweden Sweden 0 2015-04-02 2015-04-08 2015 14 10338368 1799 0 TBC weekly  
199 Sweden Sweden 0 2015-04-09 2015-04-15 2015 15 10338368 1813 0 TBC weekly  
200 Sweden Sweden 0 2015-04-16 2015-04-22 2015 16 10338368 1843 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] TEXT,
   [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 69.953ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette