economist_excess_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

46 rows where country = "Switzerland"

View and edit SQL

Suggested facets: start_date, end_date, total_deaths, covid_deaths, expected_deaths, excess_deaths, non_covid_deaths, covid_deaths_per_100k, week, start_date (date), end_date (date)

country

  • Switzerland · 46

cadence

Link rowid ▼ country region region_code start_date end_date year month 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 week
643 Switzerland Switzerland 0 2020-01-06 2020-01-12 2020   8570146 1349 0 1477.0 -128.0 1349       weekly 1
644 Switzerland Switzerland 0 2020-01-13 2020-01-19 2020   8570146 1391 0 1468.0 -77.0 1391       weekly 2
645 Switzerland Switzerland 0 2020-01-20 2020-01-26 2020   8570146 1396 0 1481.2 -85.2 1396       weekly 3
646 Switzerland Switzerland 0 2020-01-27 2020-02-02 2020   8570146 1409 0 1474.2 -65.2 1409       weekly 4
647 Switzerland Switzerland 0 2020-02-03 2020-02-09 2020   8570146 1368 0 1477.0 -109.0 1368       weekly 5
648 Switzerland Switzerland 0 2020-02-10 2020-02-16 2020   8570146 1364 0 1538.4 -174.4 1364       weekly 6
649 Switzerland Switzerland 0 2020-02-17 2020-02-23 2020   8570146 1347 0 1483.4 -136.4 1347       weekly 7
650 Switzerland Switzerland 0 2020-02-24 2020-03-01 2020   8570146 1320 0 1489.6 -169.6 1320       weekly 8
651 Switzerland Switzerland 0 2020-03-02 2020-03-08 2020   8570146 1335 2 1461.6 -126.6 1333       weekly 9
652 Switzerland Switzerland 0 2020-03-09 2020-03-15 2020   8570146 1378 11 1419.2 -41.2 1367       weekly 10
653 Switzerland Switzerland 0 2020-03-16 2020-03-22 2020   8570146 1507 47 1349.8 157.2 1460       weekly 11
654 Switzerland Switzerland 0 2020-03-23 2020-03-29 2020   8570146 1596 197 1295.4 300.6 1399       weekly 12
655 Switzerland Switzerland 0 2020-03-30 2020-04-05 2020   8570146 1850 302 1286.8 563.2 1548       weekly 13
656 Switzerland Switzerland 0 2020-04-06 2020-04-12 2020   8570146 1613 299 1245.0 368.0 1314       weekly 14
657 Switzerland Switzerland 0 2020-04-13 2020-04-19 2020   8570146 1542 276 1252.2 289.8 1266       weekly 15
658 Switzerland Switzerland 0 2020-04-20 2020-04-26 2020   8570146 1344 202 1188.4 155.6 1142       weekly 16
659 Switzerland Switzerland 0 2020-04-27 2020-05-03 2020   8570146 1216 136 1203.8 12.2 1080       weekly 17
660 Switzerland Switzerland 0 2020-05-04 2020-05-10 2020   8570146 1147 65 1195.0 -48.0 1082       weekly 18
661 Switzerland Switzerland 0 2020-05-11 2020-05-17 2020   8570146 1127.3 65 1171.0 -43.7 1062.3       weekly 19
662 Switzerland Switzerland 0 2020-05-18 2020-05-24 2020   8570146 1180 39 1168.2 11.8 1141       weekly 20
663 Switzerland Switzerland 0 2020-05-25 2020-05-31 2020   8570146 1072.2 15 1184.0 -111.8 1057.2       weekly 21
664 Switzerland Switzerland 0 2020-06-01 2020-06-07 2020   8570146 1148.8 4 1156.8 -8.0 1144.8       weekly 22
665 Switzerland Switzerland 0 2020-06-08 2020-06-14 2020   8570146 1088.7 16 1132.2 -43.5 1072.7       weekly 23
3308 Switzerland Switzerland 0 2020-01-06 2020-01-12 2020   8570146 1349 0 1477.0 -128.0 1349 0.0 -1.49355681921872 -0.086662153012864 weekly 1
3309 Switzerland Switzerland 0 2020-01-13 2020-01-19 2020   8570146 1391 0 1468.0 -77.0 1391 0.0 -0.898467774061259 -0.0524523160762943 weekly 2
3310 Switzerland Switzerland 0 2020-01-20 2020-01-26 2020   8570146 1396 0 1481.2 -85.2 1396 0.0 -0.994148757792458 -0.0575209289765055 weekly 3
3311 Switzerland Switzerland 0 2020-01-27 2020-02-02 2020   8570146 1409 0 1474.2 -65.2 1409 0.0 -0.760780504789534 -0.0442273775607109 weekly 4
3312 Switzerland Switzerland 0 2020-02-03 2020-02-09 2020   8570146 1368 0 1477.0 -109.0 1368 0.0 -1.27185697886594 -0.073798239675017 weekly 5
3313 Switzerland Switzerland 0 2020-02-10 2020-02-16 2020   8570146 1364 0 1538.4 -174.4 1364 0.0 -2.0349711661855 -0.113364534581383 weekly 6
3314 Switzerland Switzerland 0 2020-02-17 2020-02-23 2020   8570146 1347 0 1483.4 -136.4 1347 0.0 -1.59157148547994 -0.0919509235539976 weekly 7
3315 Switzerland Switzerland 0 2020-02-24 2020-03-01 2020   8570146 1320 0 1489.6 -169.6 1320 0.0 -1.9789627854648 -0.113856068743287 weekly 8
3316 Switzerland Switzerland 0 2020-03-02 2020-03-08 2020   8570146 1335 2 1461.6 -126.6 1333 0.0233368253002924 -1.47722104150851 -0.0866174055829227 weekly 9
3317 Switzerland Switzerland 0 2020-03-09 2020-03-15 2020   8570146 1378 11 1419.2 -41.2 1367 0.128352539151608 -0.480738601186025 -0.0290304396843293 weekly 10
3318 Switzerland Switzerland 0 2020-03-16 2020-03-22 2020   8570146 1507 47 1349.8 157.2 1460 0.548415394556872 1.83427446860299 0.116461698029338 weekly 11
3319 Switzerland Switzerland 0 2020-03-23 2020-03-29 2020   8570146 1596 197 1295.4 300.6 1399 2.2986772920788 3.50752484263395 0.232051875868458 weekly 12
3320 Switzerland Switzerland 0 2020-03-30 2020-04-05 2020   8570146 1850 302 1286.8 563.2 1548 3.52386062034416 6.57165000456235 0.437674852346907 weekly 13
3321 Switzerland Switzerland 0 2020-04-06 2020-04-12 2020   8570146 1613 299 1245.0 368.0 1314 3.48885538239372 4.29397585525381 0.295582329317269 weekly 14
3322 Switzerland Switzerland 0 2020-04-13 2020-04-19 2020   8570146 1542 276 1252.2 289.8 1266 3.22048189144036 3.38150598601237 0.231432678485865 weekly 15
3323 Switzerland Switzerland 0 2020-04-20 2020-04-26 2020   8570146 1344 202 1188.4 155.6 1142 2.35701935532954 1.81560500836275 0.130932346011444 weekly 16
3324 Switzerland Switzerland 0 2020-04-27 2020-05-03 2020   8570146 1216 136 1203.8 12.2 1080 1.58690412041989 0.142354634331784 0.0101345738494767 weekly 17
3325 Switzerland Switzerland 0 2020-05-04 2020-05-10 2020   8570146 1147 65 1195.0 -48.0 1082 0.758446822259504 -0.560083807207018 -0.0401673640167364 weekly 18
3326 Switzerland Switzerland 0 2020-05-11 2020-05-17 2020   8570146 1127.3 65 1171.0 -43.7 1062.3 0.758446822259504 -0.50990963281139 -0.0373185311699402 weekly 19
3327 Switzerland Switzerland 0 2020-05-18 2020-05-24 2020   8570146 1180 39 1168.2 11.8 1141 0.455068093355702 0.137687269271725 0.0101010101010102 weekly 20
3328 Switzerland Switzerland 0 2020-05-25 2020-05-31 2020   8570146 1072.2 15 1184.0 -111.8 1057.2 0.175026189752193 -1.30452853428635 -0.0944256756756756 weekly 21
3329 Switzerland Switzerland 0 2020-06-01 2020-06-07 2020   8570146 1148.8 4 1156.8 -8.0 1144.8 0.0466736506005849 -0.0933473012011697 -0.0069156293222683 weekly 22
3330 Switzerland Switzerland 0 2020-06-08 2020-06-14 2020   8570146 1088.7 16 1132.2 -43.5 1072.7 0.186694602402339 -0.50757595028136 -0.0384207737148914 weekly 23

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [economist_excess_deaths] (
   [country] TEXT,
   [region] TEXT,
   [region_code] TEXT,
   [start_date] TEXT,
   [end_date] TEXT,
   [year] INTEGER,
   [month] 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
, [week] INTEGER);
Powered by Datasette · Query took 67.708ms · Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette