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

285 rows where country = "Sweden"

View and edit SQL

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

country

  • Sweden · 285

cadence

Link rowid ▼ country region region_code start_date end_date year week population total_deaths covid_deaths expected_deaths cadence month
191 Sweden Sweden 0 2015-01-01 2015-01-07 2015 1 10338368 1937 0 TBC weekly  
192 Sweden Sweden 0 2015-01-08 2015-01-14 2015 2 10338368 1954 0 TBC weekly  
193 Sweden Sweden 0 2015-01-15 2015-01-21 2015 3 10338368 1937 0 TBC weekly  
194 Sweden Sweden 0 2015-01-22 2015-01-28 2015 4 10338368 1929 0 TBC weekly  
195 Sweden Sweden 0 2015-01-29 2015-02-04 2015 5 10338368 1966 0 TBC weekly  
196 Sweden Sweden 0 2015-02-05 2015-02-11 2015 6 10338368 1918 0 TBC weekly  
197 Sweden Sweden 0 2015-02-12 2015-02-18 2015 7 10338368 2050 0 TBC weekly  
198 Sweden Sweden 0 2015-02-19 2015-02-25 2015 8 10338368 2149 0 TBC weekly  
199 Sweden Sweden 0 2015-02-26 2015-03-04 2015 9 10338368 2041 0 TBC weekly  
200 Sweden Sweden 0 2015-03-05 2015-03-11 2015 10 10338368 1993 0 TBC weekly  
201 Sweden Sweden 0 2015-03-12 2015-03-18 2015 11 10338368 1881 0 TBC weekly  
202 Sweden Sweden 0 2015-03-19 2015-03-25 2015 12 10338368 1809 0 TBC weekly  
203 Sweden Sweden 0 2015-03-26 2015-04-01 2015 13 10338368 2044 0 TBC weekly  
204 Sweden Sweden 0 2015-04-02 2015-04-08 2015 14 10338368 1799 0 TBC weekly  
205 Sweden Sweden 0 2015-04-09 2015-04-15 2015 15 10338368 1813 0 TBC weekly  
206 Sweden Sweden 0 2015-04-16 2015-04-22 2015 16 10338368 1843 0 TBC weekly  
207 Sweden Sweden 0 2015-04-23 2015-04-29 2015 17 10338368 1724 0 TBC weekly  
208 Sweden Sweden 0 2015-04-30 2015-05-06 2015 18 10338368 1634 0 TBC weekly  
209 Sweden Sweden 0 2015-05-07 2015-05-13 2015 19 10338368 1662 0 TBC weekly  
210 Sweden Sweden 0 2015-05-14 2015-05-20 2015 20 10338368 1667 0 TBC weekly  
211 Sweden Sweden 0 2015-05-21 2015-05-27 2015 21 10338368 1623 0 TBC weekly  
212 Sweden Sweden 0 2015-05-28 2015-06-03 2015 22 10338368 1659 0 TBC weekly  
213 Sweden Sweden 0 2015-06-04 2015-06-10 2015 23 10338368 1571 0 TBC weekly  
214 Sweden Sweden 0 2015-06-11 2015-06-17 2015 24 10338368 1613 0 TBC weekly  
215 Sweden Sweden 0 2015-06-18 2015-06-24 2015 25 10338368 1594 0 TBC weekly  
216 Sweden Sweden 0 2015-06-25 2015-07-01 2015 26 10338368 1506 0 TBC weekly  
217 Sweden Sweden 0 2015-07-02 2015-07-08 2015 27 10338368 1711 0 TBC weekly  
218 Sweden Sweden 0 2015-07-09 2015-07-15 2015 28 10338368 1559 0 TBC weekly  
219 Sweden Sweden 0 2015-07-16 2015-07-22 2015 29 10338368 1508 0 TBC weekly  
220 Sweden Sweden 0 2015-07-23 2015-07-29 2015 30 10338368 1572 0 TBC weekly  
221 Sweden Sweden 0 2015-07-30 2015-08-05 2015 31 10338368 1562 0 TBC weekly  
222 Sweden Sweden 0 2015-08-06 2015-08-12 2015 32 10338368 1510 0 TBC weekly  
223 Sweden Sweden 0 2015-08-13 2015-08-19 2015 33 10338368 1542 0 TBC weekly  
224 Sweden Sweden 0 2015-08-20 2015-08-26 2015 34 10338368 1550 0 TBC weekly  
225 Sweden Sweden 0 2015-08-27 2015-09-02 2015 35 10338368 1534 0 TBC weekly  
226 Sweden Sweden 0 2015-09-03 2015-09-09 2015 36 10338368 1563 0 TBC weekly  
227 Sweden Sweden 0 2015-09-10 2015-09-16 2015 37 10338368 1584 0 TBC weekly  
228 Sweden Sweden 0 2015-09-17 2015-09-23 2015 38 10338368 1577 0 TBC weekly  
229 Sweden Sweden 0 2015-09-24 2015-09-30 2015 39 10338368 1671 0 TBC weekly  
230 Sweden Sweden 0 2015-10-01 2015-10-07 2015 40 10338368 1572 0 TBC weekly  
231 Sweden Sweden 0 2015-10-08 2015-10-14 2015 41 10338368 1565 0 TBC weekly  
232 Sweden Sweden 0 2015-10-15 2015-10-21 2015 42 10338368 1620 0 TBC weekly  
233 Sweden Sweden 0 2015-10-22 2015-10-28 2015 43 10338368 1643 0 TBC weekly  
234 Sweden Sweden 0 2015-10-29 2015-11-04 2015 44 10338368 1686 0 TBC weekly  
235 Sweden Sweden 0 2015-11-05 2015-11-11 2015 45 10338368 1721 0 TBC weekly  
236 Sweden Sweden 0 2015-11-12 2015-11-18 2015 46 10338368 1664 0 TBC weekly  
237 Sweden Sweden 0 2015-11-19 2015-11-25 2015 47 10338368 1683 0 TBC weekly  
238 Sweden Sweden 0 2015-11-26 2015-12-02 2015 48 10338368 1729 0 TBC weekly  
239 Sweden Sweden 0 2015-12-03 2015-12-09 2015 49 10338368 1761 0 TBC weekly  
240 Sweden Sweden 0 2015-12-10 2015-12-16 2015 50 10338368 1701 0 TBC weekly  
241 Sweden Sweden 0 2015-12-17 2015-12-23 2015 51 10338368 1744 0 TBC weekly  
242 Sweden Sweden 0 2015-12-24 2015-12-30 2015 52 10338368 1844 0 TBC weekly  
243 Sweden Sweden 0 2016-01-01 2016-01-07 2016 1 10338368 1846 0 TBC weekly  
244 Sweden Sweden 0 2016-01-08 2016-01-14 2016 2 10338368 1904 0 TBC weekly  
245 Sweden Sweden 0 2016-01-15 2016-01-21 2016 3 10338368 1969 0 TBC weekly  
246 Sweden Sweden 0 2016-01-22 2016-01-28 2016 4 10338368 1977 0 TBC weekly  
247 Sweden Sweden 0 2016-01-29 2016-02-04 2016 5 10338368 1931 0 TBC weekly  
248 Sweden Sweden 0 2016-02-05 2016-02-11 2016 6 10338368 1913 0 TBC weekly  
249 Sweden Sweden 0 2016-02-12 2016-02-18 2016 7 10338368 1783 0 TBC weekly  
250 Sweden Sweden 0 2016-02-19 2016-02-25 2016 8 10338368 1874 0 TBC weekly  
251 Sweden Sweden 0 2016-02-26 2016-03-03 2016 9 10338368 1806 0 TBC weekly  
252 Sweden Sweden 0 2016-03-04 2016-03-10 2016 10 10338368 1897 0 TBC weekly  
253 Sweden Sweden 0 2016-03-11 2016-03-17 2016 11 10338368 1751 0 TBC weekly  
254 Sweden Sweden 0 2016-03-18 2016-03-24 2016 12 10338368 1839 0 TBC weekly  
255 Sweden Sweden 0 2016-03-25 2016-03-31 2016 13 10338368 1739 0 TBC weekly  
256 Sweden Sweden 0 2016-04-01 2016-04-07 2016 14 10338368 1780 0 TBC weekly  
257 Sweden Sweden 0 2016-04-08 2016-04-14 2016 15 10338368 1710 0 TBC weekly  
258 Sweden Sweden 0 2016-04-15 2016-04-21 2016 16 10338368 1755 0 TBC weekly  
259 Sweden Sweden 0 2016-04-22 2016-04-28 2016 17 10338368 1723 0 TBC weekly  
260 Sweden Sweden 0 2016-04-29 2016-05-05 2016 18 10338368 1644 0 TBC weekly  
261 Sweden Sweden 0 2016-05-06 2016-05-12 2016 19 10338368 1572 0 TBC weekly  
262 Sweden Sweden 0 2016-05-13 2016-05-19 2016 20 10338368 1577 0 TBC weekly  
263 Sweden Sweden 0 2016-05-20 2016-05-26 2016 21 10338368 1504 0 TBC weekly  
264 Sweden Sweden 0 2016-05-27 2016-06-02 2016 22 10338368 1567 0 TBC weekly  
265 Sweden Sweden 0 2016-06-03 2016-06-09 2016 23 10338368 1494 0 TBC weekly  
266 Sweden Sweden 0 2016-06-10 2016-06-16 2016 24 10338368 1522 0 TBC weekly  
267 Sweden Sweden 0 2016-06-17 2016-06-23 2016 25 10338368 1522 0 TBC weekly  
268 Sweden Sweden 0 2016-06-24 2016-06-30 2016 26 10338368 1569 0 TBC weekly  
269 Sweden Sweden 0 2016-07-01 2016-07-07 2016 27 10338368 1543 0 TBC weekly  
270 Sweden Sweden 0 2016-07-08 2016-07-14 2016 28 10338368 1623 0 TBC weekly  
271 Sweden Sweden 0 2016-07-15 2016-07-21 2016 29 10338368 1575 0 TBC weekly  
272 Sweden Sweden 0 2016-07-22 2016-07-28 2016 30 10338368 1678 0 TBC weekly  
273 Sweden Sweden 0 2016-07-29 2016-08-04 2016 31 10338368 1574 0 TBC weekly  
274 Sweden Sweden 0 2016-08-05 2016-08-11 2016 32 10338368 1536 0 TBC weekly  
275 Sweden Sweden 0 2016-08-12 2016-08-18 2016 33 10338368 1612 0 TBC weekly  
276 Sweden Sweden 0 2016-08-19 2016-08-25 2016 34 10338368 1555 0 TBC weekly  
277 Sweden Sweden 0 2016-08-26 2016-09-01 2016 35 10338368 1628 0 TBC weekly  
278 Sweden Sweden 0 2016-09-02 2016-09-08 2016 36 10338368 1650 0 TBC weekly  
279 Sweden Sweden 0 2016-09-09 2016-09-15 2016 37 10338368 1507 0 TBC weekly  
280 Sweden Sweden 0 2016-09-16 2016-09-22 2016 38 10338368 1531 0 TBC weekly  
281 Sweden Sweden 0 2016-09-23 2016-09-29 2016 39 10338368 1594 0 TBC weekly  
282 Sweden Sweden 0 2016-09-30 2016-10-06 2016 40 10338368 1582 0 TBC weekly  
283 Sweden Sweden 0 2016-10-07 2016-10-13 2016 41 10338368 1606 0 TBC weekly  
284 Sweden Sweden 0 2016-10-14 2016-10-20 2016 42 10338368 1760 0 TBC weekly  
285 Sweden Sweden 0 2016-10-21 2016-10-27 2016 43 10338368 1649 0 TBC weekly  
286 Sweden Sweden 0 2016-10-28 2016-11-03 2016 44 10338368 1700 0 TBC weekly  
287 Sweden Sweden 0 2016-11-04 2016-11-10 2016 45 10338368 1698 0 TBC weekly  
288 Sweden Sweden 0 2016-11-11 2016-11-17 2016 46 10338368 1768 0 TBC weekly  
289 Sweden Sweden 0 2016-11-18 2016-11-24 2016 47 10338368 1739 0 TBC weekly  
290 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] 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 273.85ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette