economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
18 rows where country = "Switzerland" and covid_deaths = 0 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date, week, total_deaths, expected_deaths, non_covid_deaths, 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 | excess_deaths | non_covid_deaths | covid_deaths_per_100k | excess_deaths_per_100k | excess_deaths_pct_change | cadence | month | total_deaths_per_7_days | covid_deaths_per_7_days | expected_deaths_per_7_days | excess_deaths_per_7_days | non_covid_deaths_per_7_days | covid_deaths_per_100k_per_7_days | excess_deaths_per_100k_per_7_days | quarter |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17572 | 17572 | Switzerland | Switzerland | 0 | 2020-02-24 | 2020-03-01 | 7 | 2020 | 9 | 8740471 | 1349 | 0 | 1522.95393258426 | -173.953932584262 | 1349 | 0.0 | -1.9902123419237 | -0.114221401489855 | weekly | |||||||||
23124 | 23124 | Switzerland | Switzerland | 0 | 2020-02-24 | 2020-03-01 | 7 | 2020 | 9 | 8740471 | 1349 | 0 | 1522.95393258426 | -173.953932584262 | 1349 | 0.0 | -1.99021234192371 | -0.114221401489856 | weekly | |||||||||
17571 | 17571 | Switzerland | Switzerland | 0 | 2020-02-17 | 2020-02-23 | 7 | 2020 | 8 | 8740471 | 1369 | 0 | 1486.12827715355 | -117.128277153552 | 1369 | 0.0 | -1.34006825437155 | -0.0788143789161264 | weekly | |||||||||
23123 | 23123 | Switzerland | Switzerland | 0 | 2020-02-17 | 2020-02-23 | 7 | 2020 | 8 | 8740471 | 1369 | 0 | 1486.12827715355 | -117.128277153552 | 1369 | 0.0 | -1.34006825437155 | -0.0788143789161275 | weekly | |||||||||
17570 | 17570 | Switzerland | Switzerland | 0 | 2020-02-10 | 2020-02-16 | 7 | 2020 | 7 | 8740471 | 1384 | 0 | 1487.46161048689 | -103.461610486885 | 1384 | 0.0 | -1.18370749684868 | -0.0695558189585975 | weekly | |||||||||
23122 | 23122 | Switzerland | Switzerland | 0 | 2020-02-10 | 2020-02-16 | 7 | 2020 | 7 | 8740471 | 1384 | 0 | 1487.46161048689 | -103.461610486885 | 1384 | 0.0 | -1.18370749684869 | -0.0695558189585945 | weekly | |||||||||
17569 | 17569 | Switzerland | Switzerland | 0 | 2020-02-03 | 2020-02-09 | 7 | 2020 | 6 | 8740471 | 1396 | 0 | 1485.62827715355 | -89.6282771535512 | 1396 | 0.0 | -1.02543990081943 | -0.0603302175462606 | weekly | |||||||||
23121 | 23121 | Switzerland | Switzerland | 0 | 2020-02-03 | 2020-02-09 | 7 | 2020 | 6 | 8740471 | 1396 | 0 | 1485.62827715355 | -89.6282771535512 | 1396 | 0.0 | -1.02543990081943 | -0.0603302175462613 | weekly | |||||||||
17568 | 17568 | Switzerland | Switzerland | 0 | 2020-01-27 | 2020-02-02 | 7 | 2020 | 5 | 8740471 | 1426 | 0 | 1461.46161048689 | -35.4616104868858 | 1426 | 0.0 | -0.4057173862471 | -0.0242644830575303 | weekly | |||||||||
23120 | 23120 | Switzerland | Switzerland | 0 | 2020-01-27 | 2020-02-02 | 7 | 2020 | 5 | 8740471 | 1426 | 0 | 1461.46161048689 | -35.4616104868858 | 1426 | 0.0 | -0.4057173862471 | -0.0242644830575274 | weekly | |||||||||
17567 | 17567 | Switzerland | Switzerland | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 8740471 | 1417 | 0 | 1452.12827715355 | -35.1282771535516 | 1417 | 0.0 | -0.401903709234338 | -0.0241908911948249 | weekly | |||||||||
23119 | 23119 | Switzerland | Switzerland | 0 | 2020-01-20 | 2020-01-26 | 7 | 2020 | 4 | 8740471 | 1417 | 0 | 1452.12827715355 | -35.1282771535516 | 1417 | 0.0 | -0.401903709234338 | -0.024190891194826 | weekly | |||||||||
17566 | 17566 | Switzerland | Switzerland | 0 | 2020-01-13 | 2020-01-19 | 7 | 2020 | 3 | 8740471 | 1418 | 0 | 1478.46161048688 | -60.4616104868846 | 1418 | 0.0 | -0.691743162203554 | -0.040894947868798 | weekly | |||||||||
23118 | 23118 | Switzerland | Switzerland | 0 | 2020-01-13 | 2020-01-19 | 7 | 2020 | 3 | 8740471 | 1418 | 0 | 1478.46161048688 | -60.4616104868846 | 1418 | 0.0 | -0.691743162203554 | -0.040894947868801 | weekly | |||||||||
17565 | 17565 | Switzerland | Switzerland | 0 | 2020-01-06 | 2020-01-12 | 7 | 2020 | 2 | 8740471 | 1366 | 0 | 1461.96161048688 | -95.9616104868849 | 1366 | 0.0 | -1.09789976406174 | -0.0656389400368192 | weekly | |||||||||
23117 | 23117 | Switzerland | Switzerland | 0 | 2020-01-06 | 2020-01-12 | 7 | 2020 | 2 | 8740471 | 1366 | 0 | 1461.96161048688 | -95.9616104868849 | 1366 | 0.0 | -1.09789976406174 | -0.0656389400368224 | weekly | |||||||||
17564 | 17564 | Switzerland | Switzerland | 0 | 2019-12-30 | 2020-01-05 | 7 | 2020 | 1 | 8740471 | 1314 | 0 | 1444.12827715354 | -130.128277153545 | 1314 | 0.0 | -1.48880165786884 | -0.0901085306701634 | weekly | |||||||||
23116 | 23116 | Switzerland | Switzerland | 0 | 2019-12-30 | 2020-01-05 | 7 | 2020 | 1 | 8740471 | 1314 | 0 | 1444.12827715354 | -130.128277153545 | 1314 | 0.0 | -1.48880165786884 | -0.0901085306701664 | weekly |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [economist_excess_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] FLOAT, [excess_deaths] FLOAT, [non_covid_deaths] INTEGER, [covid_deaths_per_100k] FLOAT, [excess_deaths_per_100k] FLOAT, [excess_deaths_pct_change] FLOAT, [cadence] TEXT , [month] INTEGER, [total_deaths_per_7_days] FLOAT, [covid_deaths_per_7_days] FLOAT, [expected_deaths_per_7_days] FLOAT, [excess_deaths_per_7_days] FLOAT, [non_covid_deaths_per_7_days] FLOAT, [covid_deaths_per_100k_per_7_days] FLOAT, [excess_deaths_per_100k_per_7_days] FLOAT, [quarter] INTEGER);