economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
14 rows where cadence = "weekly", country = "Switzerland" and covid_deaths_per_100k = "0.114410310382587" sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: end_date, year, week, expected_deaths, excess_deaths, start_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17695 | 17695 | Switzerland | Switzerland | 0 | 2022-07-04 | 2022-07-10 | 7 | 2022 | 27 | 8740471 | 1336 | 10 | 1193.58988764044 | 142.410112359561 | 1326 | 0.114410310382587 | 1.62931851566765 | 0.119312432045721 | weekly | |||||||||
23247 | 23247 | Switzerland | Switzerland | 0 | 2022-07-04 | 2022-07-10 | 7 | 2022 | 27 | 8740471 | 1336 | 10 | 1193.58988764044 | 142.410112359561 | 1326 | 0.114410310382587 | 1.62931851566765 | 0.119312432045723 | weekly | |||||||||
17694 | 17694 | Switzerland | Switzerland | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 8740471 | 1344 | 10 | 1194.38988764044 | 149.610112359561 | 1334 | 0.114410310382587 | 1.71169393914311 | 0.12526069912993 | weekly | |||||||||
23246 | 23246 | Switzerland | Switzerland | 0 | 2022-06-27 | 2022-07-03 | 7 | 2022 | 26 | 8740471 | 1344 | 10 | 1194.38988764044 | 149.610112359561 | 1334 | 0.114410310382587 | 1.71169393914311 | 0.125260699129931 | weekly | |||||||||
17691 | 17691 | Switzerland | Switzerland | 0 | 2022-06-06 | 2022-06-12 | 7 | 2022 | 23 | 8740471 | 1207 | 10 | 1164.98988764044 | 42.0101123595609 | 1197 | 0.114410310382587 | 0.480638999426471 | 0.0360604952929222 | weekly | |||||||||
23243 | 23243 | Switzerland | Switzerland | 0 | 2022-06-06 | 2022-06-12 | 7 | 2022 | 23 | 8740471 | 1207 | 10 | 1164.98988764044 | 42.0101123595609 | 1197 | 0.114410310382587 | 0.480638999426472 | 0.0360604952929229 | weekly | |||||||||
17690 | 17690 | Switzerland | Switzerland | 0 | 2022-05-30 | 2022-06-05 | 7 | 2022 | 22 | 8740471 | 1200 | 10 | 1158.38988764044 | 41.6101123595611 | 1190 | 0.114410310382587 | 0.47606258701117 | 0.0359206453746905 | weekly | |||||||||
23242 | 23242 | Switzerland | Switzerland | 0 | 2022-05-30 | 2022-06-05 | 7 | 2022 | 22 | 8740471 | 1200 | 10 | 1158.38988764044 | 41.6101123595611 | 1190 | 0.114410310382587 | 0.47606258701117 | 0.0359206453746916 | weekly | |||||||||
17688 | 17688 | Switzerland | Switzerland | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 8740471 | 1283 | 10 | 1176.58988764044 | 106.410112359562 | 1273 | 0.114410310382587 | 1.21744139829034 | 0.0904394245415088 | weekly | |||||||||
23240 | 23240 | Switzerland | Switzerland | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 8740471 | 1283 | 10 | 1176.58988764044 | 106.410112359562 | 1273 | 0.114410310382587 | 1.21744139829035 | 0.0904394245415112 | weekly | |||||||||
17603 | 17603 | Switzerland | Switzerland | 0 | 2020-09-28 | 2020-10-04 | 7 | 2020 | 40 | 8740471 | 1243 | 10 | 1256.55393258426 | -13.5539325842624 | 1233 | 0.114410310382587 | -0.155070963387012 | -0.01078659039838 | weekly | |||||||||
23155 | 23155 | Switzerland | Switzerland | 0 | 2020-09-28 | 2020-10-04 | 7 | 2020 | 40 | 8740471 | 1243 | 10 | 1256.55393258426 | -13.5539325842624 | 1233 | 0.114410310382587 | -0.155070963387012 | -0.0107865903983819 | weekly | |||||||||
17599 | 17599 | Switzerland | Switzerland | 0 | 2020-08-31 | 2020-09-06 | 7 | 2020 | 36 | 8740471 | 1167 | 10 | 1169.15393258426 | -2.15393258426229 | 1157 | 0.114410310382587 | -0.0246432095508616 | -0.0018423002516863 | weekly | |||||||||
23151 | 23151 | Switzerland | Switzerland | 0 | 2020-08-31 | 2020-09-06 | 7 | 2020 | 36 | 8740471 | 1167 | 10 | 1169.15393258426 | -2.15393258426229 | 1157 | 0.114410310382587 | -0.0246432095508617 | -0.0018423002516883 | 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);