economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
26 rows where cadence = "weekly" and "start_date" is on date 2022-11-21 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, population, total_deaths, covid_deaths, expected_deaths, non_covid_deaths, covid_deaths_per_100k, excess_deaths_pct_change, start_date (date)
country 14
- Austria 2
- Chile 2
- Denmark 2
- Ecuador 2
- Germany 2
- Latvia 2
- Netherlands 2
- New Zealand 2
- Norway 2
- Poland 2
- Portugal 2
- United States 2
- Britain 1
- South Africa 1
cadence 1
- weekly · 26 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
598 | 598 | Portugal | Portugal | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 10270857 | 2491 | 55 | 2163.2098314607 | 327.790168539304 | 2436 | 0.535495723482471 | 3.19145879004356 | 0.151529529762707 | weekly | |||||||||
784 | 784 | Norway | Norway | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 5434324 | 908 | 59 | 769.262640449453 | 138.737359550547 | 849 | 1.08569161500124 | 2.5529828466346 | 0.180351095003766 | weekly | |||||||||
1292 | 1292 | Ecuador | Ecuador | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 18001002 | 1589 | 5 | 1471.75730337072 | 117.24269662928 | 1584 | 0.0277762315675539 | 0.65131205823587 | 0.0796617053373969 | weekly | |||||||||
1594 | 1594 | Latvia | Latvia | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 1850654 | 585 | 4 | 517.811797752817 | 67.1882022471833 | 581 | 0.216139807873325 | 3.63051128126507 | 0.129754097026689 | weekly | |||||||||
2277 | 2277 | United States | United States | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 338289856 | 62001 | 2125 | 57624.5144067795 | 4376.48559322046 | 59876 | 0.628159539019698 | 1.29370878718292 | 0.0759483292531757 | weekly | |||||||||
11471 | 11471 | Austria | Austria | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 8939617 | 1731 | 43 | 1554.17415730333 | 176.825842696669 | 1688 | 0.481004946856224 | 1.97800244346787 | 0.113774792783508 | weekly | |||||||||
12212 | 12212 | Chile | Chile | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 19603736 | 2584 | 190 | 2113.81065573779 | 470.189344262215 | 2394 | 0.969203013139944 | 2.3984680484486 | 0.222436831315006 | weekly | |||||||||
12962 | 12962 | Denmark | Denmark | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 5882259 | 1141 | 43 | 1055.00477528089 | 85.9952247191081 | 1098 | 0.731011674256438 | 1.46194216744125 | 0.0815116923960977 | weekly | |||||||||
13116 | 13116 | Ecuador | Ecuador | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 18001002 | 1589 | 5 | 1471.75730337072 | 117.24269662928 | 1584 | 0.0277762315675539 | 0.651312058235869 | 0.0796617053373969 | weekly | |||||||||
13719 | 13719 | Germany | Germany | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 83369840 | 20908 | 978 | 18213.5904494379 | 2694.40955056214 | 19930 | 1.17308609444375 | 3.23187564059394 | 0.14793401433078 | weekly | |||||||||
14892 | 14892 | Latvia | Latvia | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 1850654 | 585 | 4 | 517.811797752817 | 67.1882022471833 | 581 | 0.216139807873325 | 3.63051128126507 | 0.129754097026688 | weekly | |||||||||
15773 | 15773 | Netherlands | Netherlands | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 17564020 | 3365 | 15 | 2996.67331460673 | 368.326685393271 | 3350 | 0.0854018613050999 | 2.09705230006155 | 0.122911858158822 | weekly | |||||||||
15927 | 15927 | New Zealand | New Zealand | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 5185289 | 713 | 30 | 673.612078651666 | 39.3879213483344 | 683 | 0.578559844976818 | 0.759608988975048 | 0.058472706468053 | weekly | |||||||||
16080 | 16080 | Norway | Norway | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 5434324 | 908 | 59 | 769.262640449453 | 138.737359550547 | 849 | 1.08569161500124 | 2.5529828466346 | 0.180351095003766 | weekly | |||||||||
16378 | 16378 | Poland | Poland | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 39857144 | 7440 | 32 | 8019.45252808956 | -579.452528089558 | 7408 | 0.0802867360491259 | -1.45382350549141 | -0.0722558710909409 | weekly | |||||||||
16530 | 16530 | Portugal | Portugal | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 10270857 | 2491 | 55 | 2163.2098314607 | 327.790168539304 | 2436 | 0.535495723482471 | 3.19145879004356 | 0.151529529762705 | weekly | |||||||||
17924 | 17924 | United States | United States | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 338289856 | 62001 | 2125 | 57624.5144067795 | 4376.48559322046 | 59876 | 0.628159539019698 | 1.29370878718292 | 0.0759483292531764 | weekly | |||||||||
19071 | 19071 | Denmark | Denmark | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 5882259 | 1141 | 43 | 1055.00477528089 | 85.9952247191081 | 1098 | 0.731011674256438 | 1.46194216744125 | 0.0815116923960957 | weekly | |||||||||
19471 | 19471 | South Africa | South Africa | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 59893884 | 9533 | 33 | 9273.23389830497 | 259.766101695033 | 9500 | 0.0550974453418316 | 0.433710563327356 | 0.0280124608678873 | weekly | |||||||||
19870 | 19870 | Chile | Chile | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 19603736 | 2584 | 190 | 2113.81065573779 | 470.189344262215 | 2394 | 0.969203013139944 | 2.3984680484486 | 0.222436831315009 | weekly | |||||||||
20258 | 20258 | New Zealand | New Zealand | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 5185289 | 713 | 30 | 673.612078651666 | 39.3879213483344 | 683 | 0.578559844976818 | 0.759608988975049 | 0.0584727064680539 | weekly | |||||||||
20947 | 20947 | Poland | Poland | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 39857144 | 7440 | 32 | 8019.45252808956 | -579.452528089558 | 7408 | 0.0802867360491259 | -1.45382350549141 | -0.0722558710909407 | weekly | |||||||||
21121 | 21121 | Austria | Austria | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 8939617 | 1731 | 43 | 1554.17415730333 | 176.825842696669 | 1688 | 0.481004946856224 | 1.97800244346787 | 0.113774792783508 | weekly | |||||||||
23462 | 23462 | Germany | Germany | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 83369840 | 20908 | 978 | 18213.5904494379 | 2694.40955056214 | 19930 | 1.17308609444375 | 3.23187564059393 | 0.147934014330782 | weekly | |||||||||
23820 | 23820 | Netherlands | Netherlands | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 17564020 | 3365 | 15 | 2996.67331460673 | 368.326685393271 | 3350 | 0.0854018613050999 | 2.09705230006155 | 0.122911858158823 | weekly | |||||||||
24183 | 24183 | Britain | Britain | 0 | 2022-11-21 | 2022-11-27 | 7 | 2022 | 47 | 67508936 | 13114 | 336 | 11804.0519662916 | 1309.94803370842 | 12778 | 0.497711888097303 | 1.94040687251895 | 0.110974438053068 | 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);