economist_historical_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
46 rows where country = "Switzerland" and year = 2022 sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10479 | 10479 | Switzerland | Switzerland | 0 | 2022-11-14 | 2022-11-20 | 7 | 2022 | 46 | 8740471 | 1365 | 13 | TBC | weekly | |
10478 | 10478 | Switzerland | Switzerland | 0 | 2022-11-07 | 2022-11-13 | 7 | 2022 | 45 | 8740471 | 1339 | 16 | TBC | weekly | |
10477 | 10477 | Switzerland | Switzerland | 0 | 2022-10-31 | 2022-11-06 | 7 | 2022 | 44 | 8740471 | 1356 | 19 | TBC | weekly | |
10476 | 10476 | Switzerland | Switzerland | 0 | 2022-10-24 | 2022-10-30 | 7 | 2022 | 43 | 8740471 | 1400 | 20 | TBC | weekly | |
10475 | 10475 | Switzerland | Switzerland | 0 | 2022-10-17 | 2022-10-23 | 7 | 2022 | 42 | 8740471 | 1324 | 20 | TBC | weekly | |
10474 | 10474 | Switzerland | Switzerland | 0 | 2022-10-10 | 2022-10-16 | 7 | 2022 | 41 | 8740471 | 1416 | 5 | TBC | weekly | |
10473 | 10473 | Switzerland | Switzerland | 0 | 2022-10-03 | 2022-10-09 | 7 | 2022 | 40 | 8740471 | 1402 | 8 | TBC | weekly | |
10472 | 10472 | Switzerland | Switzerland | 0 | 2022-09-26 | 2022-10-02 | 7 | 2022 | 39 | 8740471 | 1441 | 11 | TBC | weekly | |
10471 | 10471 | Switzerland | Switzerland | 0 | 2022-09-19 | 2022-09-25 | 7 | 2022 | 38 | 8740471 | 1205 | 6 | TBC | weekly | |
10470 | 10470 | Switzerland | Switzerland | 0 | 2022-09-12 | 2022-09-18 | 7 | 2022 | 37 | 8740471 | 1287 | 5 | TBC | weekly | |
10469 | 10469 | Switzerland | Switzerland | 0 | 2022-09-05 | 2022-09-11 | 7 | 2022 | 36 | 8740471 | 1252 | 12 | TBC | weekly | |
10468 | 10468 | Switzerland | Switzerland | 0 | 2022-08-29 | 2022-09-04 | 7 | 2022 | 35 | 8740471 | 1212 | 9 | TBC | weekly | |
10467 | 10467 | Switzerland | Switzerland | 0 | 2022-08-22 | 2022-08-28 | 7 | 2022 | 34 | 8740471 | 1322 | 13 | TBC | weekly | |
10466 | 10466 | Switzerland | Switzerland | 0 | 2022-08-15 | 2022-08-21 | 7 | 2022 | 33 | 8740471 | 1306 | 14 | TBC | weekly | |
10465 | 10465 | Switzerland | Switzerland | 0 | 2022-08-08 | 2022-08-14 | 7 | 2022 | 32 | 8740471 | 1334 | 21 | TBC | weekly | |
10464 | 10464 | Switzerland | Switzerland | 0 | 2022-08-01 | 2022-08-07 | 7 | 2022 | 31 | 8740471 | 1350 | 27 | TBC | weekly | |
10463 | 10463 | Switzerland | Switzerland | 0 | 2022-07-25 | 2022-07-31 | 7 | 2022 | 30 | 8740471 | 1489 | 15 | TBC | weekly | |
10462 | 10462 | Switzerland | Switzerland | 0 | 2022-07-18 | 2022-07-24 | 7 | 2022 | 29 | 8740471 | 1483 | 19 | TBC | weekly | |
10461 | 10461 | Switzerland | Switzerland | 0 | 2022-07-11 | 2022-07-17 | 7 | 2022 | 28 | 8740471 | 1347 | 15 | TBC | weekly | |
10460 | 10460 | Switzerland | Switzerland | 0 | 2022-07-04 | 2022-07-10 | 7 | 2022 | 27 | 8740471 | 1336 | 10 | TBC | weekly | |
10459 | 10459 | Switzerland | Switzerland | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 8740471 | 1344 | 10 | TBC | weekly | |
10458 | 10458 | Switzerland | Switzerland | 0 | 2022-06-20 | 2022-06-26 | 7 | 2022 | 25 | 8740471 | 1379 | 5 | TBC | weekly | |
10457 | 10457 | Switzerland | Switzerland | 0 | 2022-06-13 | 2022-06-19 | 7 | 2022 | 24 | 8740471 | 1355 | 3 | TBC | weekly | |
10456 | 10456 | Switzerland | Switzerland | 0 | 2022-06-06 | 2022-06-12 | 7 | 2022 | 23 | 8740471 | 1207 | 10 | TBC | weekly | |
10455 | 10455 | Switzerland | Switzerland | 0 | 2022-05-30 | 2022-06-05 | 7 | 2022 | 22 | 8740471 | 1200 | 10 | TBC | weekly | |
10454 | 10454 | Switzerland | Switzerland | 0 | 2022-05-23 | 2022-05-29 | 7 | 2022 | 21 | 8740471 | 1208 | 4 | TBC | weekly | |
10453 | 10453 | Switzerland | Switzerland | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 8740471 | 1283 | 10 | TBC | weekly | |
10452 | 10452 | Switzerland | Switzerland | 0 | 2022-05-09 | 2022-05-15 | 7 | 2022 | 19 | 8740471 | 1233 | 55 | TBC | weekly | |
10451 | 10451 | Switzerland | Switzerland | 0 | 2022-05-02 | 2022-05-08 | 7 | 2022 | 18 | 8740471 | 1265 | 14 | TBC | weekly | |
10450 | 10450 | Switzerland | Switzerland | 0 | 2022-04-25 | 2022-05-01 | 7 | 2022 | 17 | 8740471 | 1290 | 36 | TBC | weekly | |
10449 | 10449 | Switzerland | Switzerland | 0 | 2022-04-18 | 2022-04-24 | 7 | 2022 | 16 | 8740471 | 1372 | 29 | TBC | weekly | |
10448 | 10448 | Switzerland | Switzerland | 0 | 2022-04-11 | 2022-04-17 | 7 | 2022 | 15 | 8740471 | 1345 | 40 | TBC | weekly | |
10447 | 10447 | Switzerland | Switzerland | 0 | 2022-04-04 | 2022-04-10 | 7 | 2022 | 14 | 8740471 | 1465 | 34 | TBC | weekly | |
10446 | 10446 | Switzerland | Switzerland | 0 | 2022-03-28 | 2022-04-03 | 7 | 2022 | 13 | 8740471 | 1552 | 66 | TBC | weekly | |
10445 | 10445 | Switzerland | Switzerland | 0 | 2022-03-21 | 2022-03-27 | 7 | 2022 | 12 | 8740471 | 1561 | 84 | TBC | weekly | |
10444 | 10444 | Switzerland | Switzerland | 0 | 2022-03-14 | 2022-03-20 | 7 | 2022 | 11 | 8740471 | 1551 | 157 | TBC | weekly | |
10443 | 10443 | Switzerland | Switzerland | 0 | 2022-03-07 | 2022-03-13 | 7 | 2022 | 10 | 8740471 | 1487 | 93 | TBC | weekly | |
10442 | 10442 | Switzerland | Switzerland | 0 | 2022-02-28 | 2022-03-06 | 7 | 2022 | 9 | 8740471 | 1469 | 94 | TBC | weekly | |
10441 | 10441 | Switzerland | Switzerland | 0 | 2022-02-21 | 2022-02-27 | 7 | 2022 | 8 | 8740471 | 1445 | 66 | TBC | weekly | |
10440 | 10440 | Switzerland | Switzerland | 0 | 2022-02-14 | 2022-02-20 | 7 | 2022 | 7 | 8740471 | 1568 | 80 | TBC | weekly | |
10439 | 10439 | Switzerland | Switzerland | 0 | 2022-02-07 | 2022-02-13 | 7 | 2022 | 6 | 8740471 | 1462 | 150 | TBC | weekly | |
10438 | 10438 | Switzerland | Switzerland | 0 | 2022-01-31 | 2022-02-06 | 7 | 2022 | 5 | 8740471 | 1471 | 102 | TBC | weekly | |
10437 | 10437 | Switzerland | Switzerland | 0 | 2022-01-24 | 2022-01-30 | 7 | 2022 | 4 | 8740471 | 1480 | 98 | TBC | weekly | |
10436 | 10436 | Switzerland | Switzerland | 0 | 2022-01-17 | 2022-01-23 | 7 | 2022 | 3 | 8740471 | 1487 | 117 | TBC | weekly | |
10435 | 10435 | Switzerland | Switzerland | 0 | 2022-01-10 | 2022-01-16 | 7 | 2022 | 2 | 8740471 | 1513 | 120 | TBC | weekly | |
10434 | 10434 | Switzerland | Switzerland | 0 | 2022-01-03 | 2022-01-09 | 7 | 2022 | 1 | 8740471 | 1544 | 163 | 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]);