economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
43 rows where cadence = "weekly" and covid_deaths = 93 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, end_date, year, population, excess_deaths, start_date (date)
country 14
- United States 15
- Switzerland 4
- Belgium 2
- Chile 2
- Czech Republic 2
- Finland 2
- Iran 2
- Israel 2
- Italy 2
- New Zealand 2
- Peru 2
- Poland 2
- Spain 2
- Sweden 2
cadence 1
- weekly · 43 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
146 | 146 | Finland | Finland | 0 | 2022-10-10 | 2022-10-16 | 7 | 2022 | 41 | 5540745 | 1205 | 93 | 1042.62022471906 | 162.379775280935 | 1112 | 1.67847464555759 | 2.93064877161709 | 0.155742015578768 | weekly | |||||||||
13414 | 13414 | Finland | Finland | 0 | 2022-10-10 | 2022-10-16 | 7 | 2022 | 41 | 5540745 | 1205 | 93 | 1042.62022471906 | 162.379775280935 | 1112 | 1.67847464555759 | 2.93064877161708 | 0.155742015578773 | weekly | |||||||||
3942 | 3942 | United States | Georgia | GA | 2022-10-02 | 2022-10-08 | 7 | 2022 | 40 | 10617423 | 1888 | 93 | 1669.39348370984 | 218.606516290158 | 1795 | 0.8759187610779 | 2.05894138615517 | 0.130949664308234 | weekly | |||||||||
14444 | 14444 | Iran | Iran | 0 | 2022-09-19 | 2022-09-25 | 7 | 2022 | 38 | 88550568 | 7225.6 | 93 | 7110.15558988747 | 115.444410112529 | 7132.6 | 0.105024735696783 | 0.130371168384294 | 0.0162365518803447 | weekly | |||||||||
24360 | 24360 | Iran | Iran | 0 | 2022-09-19 | 2022-09-25 | 7 | 2022 | 38 | 88550568 | 7225.6 | 93 | 7110.15558988747 | 115.444410112529 | 7132.6 | 0.105024735696783 | 0.130371168384294 | 0.0162365518803445 | weekly | |||||||||
8803 | 8803 | United States | Tennessee | TN | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 6833174 | 1612 | 93 | 1463.72180451225 | 148.278195487754 | 1519 | 1.36100734446393 | 2.16997540949132 | 0.101302170283079 | weekly | |||||||||
7122 | 7122 | United States | New Mexico | NM | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 2096829 | 377 | 93 | 368.283208020879 | 8.7167919791205 | 284 | 4.4352686842847 | 0.415713059058249 | 0.0236687195866565 | weekly | |||||||||
3012 | 3012 | United States | California | CA | 2022-05-29 | 2022-06-04 | 7 | 2022 | 22 | 39512223 | 5582 | 93 | 4944.09523809546 | 637.904761904541 | 5489 | 0.235370204303615 | 1.61444918425506 | 0.129023558646146 | weekly | |||||||||
16206 | 16206 | Peru | Peru | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 34049588 | 2948.1 | 93 | 3005.79282051202 | -57.6928205120153 | 2855.1 | 0.273131058149661 | -0.169437646388013 | -0.0191938779407267 | weekly | |||||||||
24834 | 24834 | Peru | Peru | 0 | 2022-05-16 | 2022-05-22 | 7 | 2022 | 20 | 34049588 | 2948.1 | 93 | 3005.79282051202 | -57.6928205120153 | 2855.1 | 0.273131058149661 | -0.169437646388013 | -0.019193877940725 | weekly | |||||||||
12184 | 12184 | Chile | Chile | 0 | 2022-05-09 | 2022-05-15 | 7 | 2022 | 19 | 19603736 | 2518 | 93 | 2127.06065573779 | 390.939344262214 | 2425 | 0.474399369589552 | 1.99420837059943 | 0.183793228090437 | weekly | |||||||||
19842 | 19842 | Chile | Chile | 0 | 2022-05-09 | 2022-05-15 | 7 | 2022 | 19 | 19603736 | 2518 | 93 | 2127.06065573779 | 390.939344262214 | 2425 | 0.474399369589552 | 1.99420837059943 | 0.18379322809044 | weekly | |||||||||
3768 | 3768 | United States | Florida | FL | 2022-05-01 | 2022-05-07 | 7 | 2022 | 18 | 21477737 | 4353 | 93 | 4104.14786967508 | 248.852130324917 | 4260 | 0.433006512743871 | 1.1586515391492 | 0.0606342993057456 | weekly | |||||||||
10150 | 10150 | Czech Republic | Czech Republic | 0 | 2022-04-18 | 2022-04-24 | 7 | 2022 | 16 | 10493990 | 2304 | 93 | 2114.96769662921 | 189.032303370787 | 2211 | 0.886221542044542 | 1.8013387031128 | 0.0893783407056583 | weekly | |||||||||
12783 | 12783 | Czech Republic | Czech Republic | 0 | 2022-04-18 | 2022-04-24 | 7 | 2022 | 16 | 10493990 | 2304 | 93 | 2114.96769662921 | 189.032303370787 | 2211 | 0.886221542044542 | 1.8013387031128 | 0.0893783407056599 | weekly | |||||||||
9690 | 9690 | United States | West Virginia | WV | 2022-03-20 | 2022-03-26 | 7 | 2022 | 12 | 1792147 | 516 | 93 | 481.050125314255 | 34.949874685745 | 423 | 5.1893064575618 | 1.95016785373884 | 0.0726532908871262 | weekly | |||||||||
15891 | 15891 | New Zealand | New Zealand | 0 | 2022-03-14 | 2022-03-20 | 7 | 2022 | 11 | 5185289 | 776 | 93 | 651.212078651665 | 124.787921348335 | 683 | 1.79353551942814 | 2.4065760143424 | 0.191624089047471 | weekly | |||||||||
20222 | 20222 | New Zealand | New Zealand | 0 | 2022-03-14 | 2022-03-20 | 7 | 2022 | 11 | 5185289 | 776 | 93 | 651.212078651665 | 124.787921348335 | 683 | 1.79353551942814 | 2.4065760143424 | 0.19162408904747 | weekly | |||||||||
17678 | 17678 | Switzerland | Switzerland | 0 | 2022-03-07 | 2022-03-13 | 7 | 2022 | 10 | 8740471 | 1487 | 93 | 1449.78988764044 | 37.2101123595612 | 1394 | 1.06401588655806 | 0.425722050442833 | 0.0256658655690585 | weekly | |||||||||
23230 | 23230 | Switzerland | Switzerland | 0 | 2022-03-07 | 2022-03-13 | 7 | 2022 | 10 | 8740471 | 1487 | 93 | 1449.78988764044 | 37.2101123595612 | 1394 | 1.06401588655806 | 0.425722050442833 | 0.0256658655690594 | weekly | |||||||||
9681 | 9681 | United States | West Virginia | WV | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 1792147 | 639 | 93 | 521.460526316777 | 117.539473683223 | 546 | 5.1893064575618 | 6.55858440648135 | 0.225404355174184 | weekly | |||||||||
5864 | 5864 | United States | Minnesota | MN | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 5639632 | 988 | 93 | 872.576441103532 | 115.423558896468 | 895 | 1.64904376739475 | 2.04665054202949 | 0.132279022741542 | weekly | |||||||||
2666 | 2666 | United States | Arizona | AZ | 2021-08-08 | 2021-08-14 | 7 | 2021 | 32 | 7278717 | 1472 | 93 | 1135.21553885746 | 336.784461142542 | 1379 | 1.27769770414209 | 4.62697562142534 | 0.296670059221969 | weekly | |||||||||
6617 | 6617 | United States | Nevada | NV | 2021-08-01 | 2021-08-07 | 7 | 2021 | 31 | 3080156 | 662 | 93 | 503.115288221364 | 158.884711778636 | 569 | 3.01932759249856 | 5.15833327203673 | 0.31580179632452 | weekly | |||||||||
17346 | 17346 | Spain | Spain | 0 | 2021-07-12 | 2021-07-18 | 7 | 2021 | 28 | 47558632 | 7563 | 93 | 7541.96629213482 | 21.0337078651846 | 7470 | 0.19554809734645 | 0.0442268984212679 | 0.002788889137189 | weekly | |||||||||
18140 | 18140 | Spain | Spain | 0 | 2021-07-12 | 2021-07-18 | 7 | 2021 | 28 | 47558632 | 7563 | 93 | 7541.96629213482 | 21.0337078651846 | 7470 | 0.19554809734645 | 0.0442268984212679 | 0.00278888913718967 | weekly | |||||||||
11547 | 11547 | Belgium | Belgium | 0 | 2021-05-31 | 2021-06-06 | 7 | 2021 | 22 | 11655923 | 1992 | 93 | 1903.55505617983 | 88.4449438201707 | 1899 | 0.797877611236793 | 0.75879828495925 | 0.0464630342752821 | weekly | |||||||||
20371 | 20371 | Belgium | Belgium | 0 | 2021-05-31 | 2021-06-06 | 7 | 2021 | 22 | 11655923 | 1992 | 93 | 1903.55505617983 | 88.4449438201707 | 1899 | 0.797877611236793 | 0.758798284959249 | 0.0464630342752825 | weekly | |||||||||
8426 | 8426 | United States | South Carolina | SC | 2021-04-18 | 2021-04-24 | 7 | 2021 | 16 | 5148714 | 1067 | 93 | 958.873433584928 | 108.126566415072 | 974 | 1.80627628568998 | 2.10006938460889 | 0.112764169522166 | weekly | |||||||||
14511 | 14511 | Israel | Israel | 0 | 2021-03-22 | 2021-03-28 | 7 | 2021 | 12 | 9449000 | 998 | 93 | 888.708988763996 | 109.291011236004 | 905 | 0.984231135569901 | 1.15664103329457 | 0.122977276721376 | weekly | |||||||||
20680 | 20680 | Israel | Israel | 0 | 2021-03-22 | 2021-03-28 | 7 | 2021 | 12 | 9449000 | 998 | 93 | 888.708988763996 | 109.291011236004 | 905 | 0.984231135569901 | 1.15664103329457 | 0.122977276721376 | weekly | |||||||||
17623 | 17623 | Switzerland | Switzerland | 0 | 2021-02-15 | 2021-02-21 | 7 | 2021 | 7 | 8740471 | 1299 | 93 | 1487.97958801497 | -188.979588014973 | 1206 | 1.06401588655806 | -2.16212133207665 | -0.127004153509308 | weekly | |||||||||
23175 | 23175 | Switzerland | Switzerland | 0 | 2021-02-15 | 2021-02-21 | 7 | 2021 | 7 | 8740471 | 1299 | 93 | 1487.97958801497 | -188.979588014973 | 1206 | 1.06401588655806 | -2.16212133207665 | -0.12700415350931 | weekly | |||||||||
5969 | 5969 | United States | Mississippi | MS | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 2976149 | 716 | 93 | 591.290726817784 | 124.709273182216 | 623 | 3.12484354781968 | 4.19028997480355 | 0.21091024689898 | weekly | |||||||||
9455 | 9455 | United States | Washington | WA | 2020-08-16 | 2020-08-22 | 7 | 2020 | 34 | 7614893 | 1199 | 93 | 1012.45614035171 | 186.543859648288 | 1106 | 1.22129096232869 | 2.44972397705769 | 0.184248830357713 | weekly | |||||||||
17442 | 17442 | Sweden | Sweden | 0 | 2020-07-13 | 2020-07-19 | 7 | 2020 | 29 | 10549349 | 1569.3 | 93 | 1585.43879213483 | -16.1387921348314 | 1476.3 | 0.881570986039044 | -0.15298377307293 | -0.0101793851739296 | weekly | |||||||||
24588 | 24588 | Sweden | Sweden | 0 | 2020-07-13 | 2020-07-19 | 7 | 2020 | 29 | 10549349 | 1569.3 | 93 | 1585.43879213483 | -16.1387921348314 | 1476.3 | 0.881570986039044 | -0.15298377307293 | -0.0101793851739304 | weekly | |||||||||
10851 | 10851 | Italy | Italy | 0 | 2020-07-06 | 2020-07-12 | 7 | 2020 | 28 | 59037472 | 11484 | 93 | 11622.8370786518 | -138.837078651821 | 11391 | 0.157527070264797 | -0.235167723055318 | -0.011945197004166 | weekly | |||||||||
14624 | 14624 | Italy | Italy | 0 | 2020-07-06 | 2020-07-12 | 7 | 2020 | 28 | 59037472 | 11484 | 93 | 11622.8370786518 | -138.837078651821 | 11391 | 0.157527070264797 | -0.235167723055318 | -0.0119451970041643 | weekly | |||||||||
7321 | 7321 | United States | North Carolina | NC | 2020-07-05 | 2020-07-11 | 7 | 2020 | 28 | 10488084 | 1979 | 93 | 1712.03759398554 | 266.962406014458 | 1886 | 0.886720586906054 | 2.54538775637626 | 0.155932560682258 | weekly | |||||||||
5040 | 5040 | United States | Louisiana | LA | 2020-06-28 | 2020-07-04 | 7 | 2020 | 27 | 4648794 | 985 | 93 | 826.61654135431 | 158.38345864569 | 892 | 2.00051884424218 | 3.40697950147264 | 0.19160451155042 | weekly | |||||||||
16249 | 16249 | Poland | Poland | 0 | 2020-06-01 | 2020-06-07 | 7 | 2020 | 23 | 39857144 | 7808 | 93 | 7438.11151685363 | 369.888483146369 | 7715 | 0.233333326642772 | 0.928035594187002 | 0.0497288165562266 | weekly | |||||||||
20818 | 20818 | Poland | Poland | 0 | 2020-06-01 | 2020-06-07 | 7 | 2020 | 23 | 39857144 | 7808 | 93 | 7438.11151685363 | 369.888483146369 | 7715 | 0.233333326642772 | 0.928035594187003 | 0.0497288165562264 | 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);