economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where country = "Switzerland" and year = 2020
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date), end_date (date)
Link | rowid ▼ | country | region | region_code | start_date | end_date | days | year | week | population | total_deaths | covid_deaths | expected_deaths | cadence | month |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10329 | 10329 | Switzerland | Switzerland | 0 | 2019-12-30 | 2020-01-05 | 7 | 2020 | 1 | 8740471 | 1314 | 0 | TBC | weekly | |
10330 | 10330 | Switzerland | Switzerland | 0 | 2020-01-06 | 2020-01-12 | 7 | 2020 | 2 | 8740471 | 1366 | 0 | TBC | weekly | |
10331 | 10331 | Switzerland | Switzerland | 0 | 2020-01-13 | 2020-01-19 | 7 | 2020 | 3 | 8740471 | 1418 | 0 | TBC | weekly | |
10332 | 10332 | Switzerland | Switzerland | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 8740471 | 1417 | 0 | TBC | weekly | |
10333 | 10333 | Switzerland | Switzerland | 0 | 2020-01-27 | 2020-02-02 | 7 | 2020 | 5 | 8740471 | 1426 | 0 | TBC | weekly | |
10334 | 10334 | Switzerland | Switzerland | 0 | 2020-02-03 | 2020-02-09 | 7 | 2020 | 6 | 8740471 | 1396 | 0 | TBC | weekly | |
10335 | 10335 | Switzerland | Switzerland | 0 | 2020-02-10 | 2020-02-16 | 7 | 2020 | 7 | 8740471 | 1384 | 0 | TBC | weekly | |
10336 | 10336 | Switzerland | Switzerland | 0 | 2020-02-17 | 2020-02-23 | 7 | 2020 | 8 | 8740471 | 1369 | 0 | TBC | weekly | |
10337 | 10337 | Switzerland | Switzerland | 0 | 2020-02-24 | 2020-03-01 | 7 | 2020 | 9 | 8740471 | 1349 | 0 | TBC | weekly | |
10338 | 10338 | Switzerland | Switzerland | 0 | 2020-03-02 | 2020-03-08 | 7 | 2020 | 10 | 8740471 | 1357 | 2 | TBC | weekly | |
10339 | 10339 | Switzerland | Switzerland | 0 | 2020-03-09 | 2020-03-15 | 7 | 2020 | 11 | 8740471 | 1396 | 20 | TBC | weekly | |
10340 | 10340 | Switzerland | Switzerland | 0 | 2020-03-16 | 2020-03-22 | 7 | 2020 | 12 | 8740471 | 1530 | 91 | TBC | weekly | |
10341 | 10341 | Switzerland | Switzerland | 0 | 2020-03-23 | 2020-03-29 | 7 | 2020 | 13 | 8740471 | 1630 | 263 | TBC | weekly | |
10342 | 10342 | Switzerland | Switzerland | 0 | 2020-03-30 | 2020-04-05 | 7 | 2020 | 14 | 8740471 | 1879 | 395 | TBC | weekly | |
10343 | 10343 | Switzerland | Switzerland | 0 | 2020-04-06 | 2020-04-12 | 7 | 2020 | 15 | 8740471 | 1647 | 370 | TBC | weekly | |
10344 | 10344 | Switzerland | Switzerland | 0 | 2020-04-13 | 2020-04-19 | 7 | 2020 | 16 | 8740471 | 1576 | 250 | TBC | weekly | |
10345 | 10345 | Switzerland | Switzerland | 0 | 2020-04-20 | 2020-04-26 | 7 | 2020 | 17 | 8740471 | 1377 | 203 | TBC | weekly | |
10346 | 10346 | Switzerland | Switzerland | 0 | 2020-04-27 | 2020-05-03 | 7 | 2020 | 18 | 8740471 | 1250 | 101 | TBC | weekly | |
10347 | 10347 | Switzerland | Switzerland | 0 | 2020-05-04 | 2020-05-10 | 7 | 2020 | 19 | 8740471 | 1184 | 59 | TBC | weekly | |
10348 | 10348 | Switzerland | Switzerland | 0 | 2020-05-11 | 2020-05-17 | 7 | 2020 | 20 | 8740471 | 1153 | 18 | TBC | weekly | |
10349 | 10349 | Switzerland | Switzerland | 0 | 2020-05-18 | 2020-05-24 | 7 | 2020 | 21 | 8740471 | 1190 | 18 | TBC | weekly | |
10350 | 10350 | Switzerland | Switzerland | 0 | 2020-05-25 | 2020-05-31 | 7 | 2020 | 22 | 8740471 | 1102 | 6 | TBC | weekly | |
10351 | 10351 | Switzerland | Switzerland | 0 | 2020-06-01 | 2020-06-07 | 7 | 2020 | 23 | 8740471 | 1171 | 2 | TBC | weekly | |
10352 | 10352 | Switzerland | Switzerland | 0 | 2020-06-08 | 2020-06-14 | 7 | 2020 | 24 | 8740471 | 1152 | 4 | TBC | weekly | |
10353 | 10353 | Switzerland | Switzerland | 0 | 2020-06-15 | 2020-06-21 | 7 | 2020 | 25 | 8740471 | 1149 | 4 | TBC | weekly | |
10354 | 10354 | Switzerland | Switzerland | 0 | 2020-06-22 | 2020-06-28 | 7 | 2020 | 26 | 8740471 | 1180 | 2 | TBC | weekly | |
10355 | 10355 | Switzerland | Switzerland | 0 | 2020-06-29 | 2020-07-05 | 7 | 2020 | 27 | 8740471 | 1180 | 2 | TBC | weekly | |
10356 | 10356 | Switzerland | Switzerland | 0 | 2020-07-06 | 2020-07-12 | 7 | 2020 | 28 | 8740471 | 1174 | 3 | TBC | weekly | |
10357 | 10357 | Switzerland | Switzerland | 0 | 2020-07-13 | 2020-07-19 | 7 | 2020 | 29 | 8740471 | 1114 | 2 | TBC | weekly | |
10358 | 10358 | Switzerland | Switzerland | 0 | 2020-07-20 | 2020-07-26 | 7 | 2020 | 30 | 8740471 | 1156 | 8 | TBC | weekly | |
10359 | 10359 | Switzerland | Switzerland | 0 | 2020-07-27 | 2020-08-02 | 7 | 2020 | 31 | 8740471 | 1280 | 5 | TBC | weekly | |
10360 | 10360 | Switzerland | Switzerland | 0 | 2020-08-03 | 2020-08-09 | 7 | 2020 | 32 | 8740471 | 1172 | 5 | TBC | weekly | |
10361 | 10361 | Switzerland | Switzerland | 0 | 2020-08-10 | 2020-08-16 | 7 | 2020 | 33 | 8740471 | 1230 | 5 | TBC | weekly | |
10362 | 10362 | Switzerland | Switzerland | 0 | 2020-08-17 | 2020-08-23 | 7 | 2020 | 34 | 8740471 | 1219 | 5 | TBC | weekly | |
10363 | 10363 | Switzerland | Switzerland | 0 | 2020-08-24 | 2020-08-30 | 7 | 2020 | 35 | 8740471 | 1173 | 4 | TBC | weekly | |
10364 | 10364 | Switzerland | Switzerland | 0 | 2020-08-31 | 2020-09-06 | 7 | 2020 | 36 | 8740471 | 1167 | 10 | TBC | weekly | |
10365 | 10365 | Switzerland | Switzerland | 0 | 2020-09-07 | 2020-09-13 | 7 | 2020 | 37 | 8740471 | 1259 | 13 | TBC | weekly | |
10366 | 10366 | Switzerland | Switzerland | 0 | 2020-09-14 | 2020-09-20 | 7 | 2020 | 38 | 8740471 | 1243 | 20 | TBC | weekly | |
10367 | 10367 | Switzerland | Switzerland | 0 | 2020-09-21 | 2020-09-27 | 7 | 2020 | 39 | 8740471 | 1255 | 14 | TBC | weekly | |
10368 | 10368 | Switzerland | Switzerland | 0 | 2020-09-28 | 2020-10-04 | 7 | 2020 | 40 | 8740471 | 1243 | 10 | TBC | weekly | |
10369 | 10369 | Switzerland | Switzerland | 0 | 2020-10-05 | 2020-10-11 | 7 | 2020 | 41 | 8740471 | 1334 | 16 | TBC | weekly | |
10370 | 10370 | Switzerland | Switzerland | 0 | 2020-10-12 | 2020-10-18 | 7 | 2020 | 42 | 8740471 | 1289 | 51 | TBC | weekly | |
10371 | 10371 | Switzerland | Switzerland | 0 | 2020-10-19 | 2020-10-25 | 7 | 2020 | 43 | 8740471 | 1492 | 140 | TBC | weekly | |
10372 | 10372 | Switzerland | Switzerland | 0 | 2020-10-26 | 2020-11-01 | 7 | 2020 | 44 | 8740471 | 1694 | 316 | TBC | weekly | |
10373 | 10373 | Switzerland | Switzerland | 0 | 2020-11-02 | 2020-11-08 | 7 | 2020 | 45 | 8740471 | 2068 | 557 | TBC | weekly | |
10374 | 10374 | Switzerland | Switzerland | 0 | 2020-11-09 | 2020-11-15 | 7 | 2020 | 46 | 8740471 | 2149 | 664 | TBC | weekly | |
10375 | 10375 | Switzerland | Switzerland | 0 | 2020-11-16 | 2020-11-22 | 7 | 2020 | 47 | 8740471 | 2157 | 663 | TBC | weekly | |
10376 | 10376 | Switzerland | Switzerland | 0 | 2020-11-23 | 2020-11-29 | 7 | 2020 | 48 | 8740471 | 2123 | 625 | TBC | weekly | |
10377 | 10377 | Switzerland | Switzerland | 0 | 2020-11-30 | 2020-12-06 | 7 | 2020 | 49 | 8740471 | 2179 | 638 | TBC | weekly | |
10378 | 10378 | Switzerland | Switzerland | 0 | 2020-12-07 | 2020-12-13 | 7 | 2020 | 50 | 8740471 | 2215 | 651 | TBC | weekly | |
10379 | 10379 | Switzerland | Switzerland | 0 | 2020-12-14 | 2020-12-20 | 7 | 2020 | 51 | 8740471 | 2187 | 677 | TBC | weekly | |
10380 | 10380 | Switzerland | Switzerland | 0 | 2020-12-21 | 2020-12-27 | 7 | 2020 | 52 | 8740471 | 2121 | 624 | TBC | weekly | |
10381 | 10381 | Switzerland | Switzerland | 0 | 2020-12-28 | 2021-01-03 | 7 | 2020 | 53 | 8740471 | 1987 | 549 | TBC | weekly |
Advanced export
JSON shape: default, array, newline-delimited
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]);