economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
37 rows where cadence = "weekly" and covid_deaths = 112 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, region_code, start_date, end_date, week, population, expected_deaths, excess_deaths_per_100k, end_date (date)
country 11
- United States 15
- Guatemala 6
- Austria 2
- Chile 2
- Finland 2
- Latvia 2
- New Zealand 2
- Peru 2
- South Korea 2
- Canada 1
- South Africa 1
cadence 1
- weekly · 37 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2417 | 2417 | United States | Alabama | AL | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 4903185 | 1091 | 112 | 972.050125298636 | 118.949874701364 | 979 | 2.28422953651555 | 2.42597158176499 | 0.122370103768897 | weekly | |||||||||
15912 | 15912 | New Zealand | New Zealand | 0 | 2022-08-08 | 2022-08-14 | 7 | 2022 | 32 | 5185289 | 760 | 112 | 799.212078651666 | -39.2120786516657 | 648 | 2.15995675458012 | -0.756217804864217 | -0.049063420960579 | weekly | |||||||||
20243 | 20243 | New Zealand | New Zealand | 0 | 2022-08-08 | 2022-08-14 | 7 | 2022 | 32 | 5185289 | 760 | 112 | 799.212078651666 | -39.2120786516657 | 648 | 2.15995675458012 | -0.756217804864217 | -0.0490634209605786 | weekly | |||||||||
1948 | 1948 | Guatemala | Guatemala | 0 | 2022-07-18 | 2022-07-24 | 7 | 2022 | 29 | 17843914 | 1776 | 112 | 1693.35589887642 | 82.6441011235811 | 1664 | 0.627664984262982 | 0.463150075278221 | 0.0488049211500177 | weekly | |||||||||
14002 | 14002 | Guatemala | Guatemala | 0 | 2022-07-18 | 2022-07-24 | 7 | 2022 | 29 | 17843914 | 1776 | 112 | 1693.35589887642 | 82.6441011235811 | 1664 | 0.627664984262982 | 0.463150075278221 | 0.048804921150017 | weekly | |||||||||
3931 | 3931 | United States | Georgia | GA | 2022-07-17 | 2022-07-23 | 7 | 2022 | 29 | 10617423 | 1866 | 112 | 1645.72681704316 | 220.273182956838 | 1754 | 1.05486990581425 | 2.07463885499182 | 0.133845532974056 | weekly | |||||||||
8035 | 8035 | United States | Oregon | OR | 2022-07-17 | 2022-07-23 | 7 | 2022 | 29 | 4217737 | 772 | 112 | 679.110275690171 | 92.8897243098286 | 660 | 2.65545243812025 | 2.20235932941833 | 0.136781503144575 | weekly | |||||||||
3015 | 3015 | United States | California | CA | 2022-06-19 | 2022-06-25 | 7 | 2022 | 25 | 39512223 | 5607 | 112 | 4972.09523809547 | 634.90476190453 | 5495 | 0.283456590129085 | 1.60685659701943 | 0.127693604305883 | weekly | |||||||||
17105 | 17105 | South Africa | South Africa | 0 | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 59893884 | 12458 | 112 | 11470.5765690375 | 987.423430962463 | 12346 | 0.186997390251065 | 1.64862147020297 | 0.0860831558919062 | weekly | |||||||||
17257 | 17257 | South Korea | South Korea | 0 | 2022-05-30 | 2022-06-05 | 7 | 2022 | 22 | 51815808 | 6004 | 112 | 5863.30308988729 | 140.696910112714 | 5892 | 0.216150252834039 | 0.271532791909207 | 0.023996185760101 | weekly | |||||||||
20574 | 20574 | South Korea | South Korea | 0 | 2022-05-30 | 2022-06-05 | 7 | 2022 | 22 | 51815808 | 6004 | 112 | 5863.30308988729 | 140.696910112714 | 5892 | 0.216150252834039 | 0.271532791909207 | 0.0239961857601019 | weekly | |||||||||
9391 | 9391 | United States | Virginia | VA | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 8535519 | 1441 | 112 | 1346.48370927384 | 94.5162907261565 | 1329 | 1.31216391176682 | 1.10732915861539 | 0.0701949010412677 | weekly | |||||||||
12181 | 12181 | Chile | Chile | 0 | 2022-04-18 | 2022-04-24 | 7 | 2022 | 16 | 19603736 | 2419 | 112 | 2080.56065573778 | 338.439344262215 | 2307 | 0.571319670903546 | 1.7264022748634 | 0.162667376857709 | weekly | |||||||||
16202 | 16202 | Peru | Peru | 0 | 2022-04-18 | 2022-04-24 | 7 | 2022 | 16 | 34049588 | 2980 | 112 | 2995.62615384535 | -15.6261538453491 | 2868 | 0.328932027018947 | -0.0458923433826838 | -0.00521632307999831 | weekly | |||||||||
19839 | 19839 | Chile | Chile | 0 | 2022-04-18 | 2022-04-24 | 7 | 2022 | 16 | 19603736 | 2419 | 112 | 2080.56065573778 | 338.439344262215 | 2307 | 0.571319670903546 | 1.7264022748634 | 0.162667376857707 | weekly | |||||||||
24830 | 24830 | Peru | Peru | 0 | 2022-04-18 | 2022-04-24 | 7 | 2022 | 16 | 34049588 | 2980 | 112 | 2995.62615384535 | -15.6261538453491 | 2868 | 0.328932027018947 | -0.0458923433826838 | -0.00521632307999798 | weekly | |||||||||
8019 | 8019 | United States | Oregon | OR | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 4217737 | 756 | 112 | 741.110275690188 | 14.8897243098116 | 644 | 2.65545243812025 | 0.353026381441319 | 0.020091104924898 | weekly | |||||||||
2850 | 2850 | United States | Arkansas | AR | 2022-03-20 | 2022-03-26 | 7 | 2022 | 12 | 3017825 | 715 | 112 | 642.243107771173 | 72.7568922288269 | 603 | 3.71128213199904 | 2.41090494739844 | 0.113285594424393 | weekly | |||||||||
111 | 111 | Finland | Finland | 0 | 2022-02-07 | 2022-02-13 | 7 | 2022 | 6 | 5540745 | 1353 | 112 | 1139.50486891382 | 213.495131086177 | 1241 | 2.02138882045645 | 3.8531845642811 | 0.187357805052365 | weekly | |||||||||
13379 | 13379 | Finland | Finland | 0 | 2022-02-07 | 2022-02-13 | 7 | 2022 | 6 | 5540745 | 1353 | 112 | 1139.50486891382 | 213.495131086177 | 1241 | 2.02138882045645 | 3.8531845642811 | 0.187357805052368 | weekly | |||||||||
7397 | 7397 | United States | North Carolina | NC | 2021-12-19 | 2021-12-25 | 7 | 2021 | 51 | 10488084 | 2419 | 112 | 1999.05639097807 | 419.943609021933 | 2307 | 1.06787855627396 | 4.00400691891801 | 0.210070916917191 | weekly | |||||||||
12029 | 12029 | Canada | Canada | 0 | 2021-12-19 | 2021-12-25 | 7 | 2021 | 51 | 38454328 | 6355 | 112 | 6027.17614424422 | 327.82385575578 | 6243 | 0.291254602082762 | 0.85250184519095 | 0.0543909532275479 | weekly | |||||||||
5867 | 5867 | United States | Minnesota | MN | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 5639632 | 1020 | 112 | 901.909774436867 | 118.090225563133 | 908 | 1.98594518223884 | 2.09393495113037 | 0.130933524516757 | weekly | |||||||||
2966 | 2966 | United States | California | CA | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 39512223 | 5297 | 112 | 4845.57142857185 | 451.428571428151 | 5185 | 0.283456590129085 | 1.14250360307025 | 0.0931631239127564 | weekly | |||||||||
1501 | 1501 | Latvia | Latvia | 0 | 2021-02-08 | 2021-02-14 | 7 | 2021 | 6 | 1850654 | 709 | 112 | 565.568258426975 | 143.431741573025 | 597 | 6.05191462045309 | 7.7503272666325 | 0.253606420508736 | weekly | |||||||||
14799 | 14799 | Latvia | Latvia | 0 | 2021-02-08 | 2021-02-14 | 7 | 2021 | 6 | 1850654 | 709 | 112 | 565.568258426975 | 143.431741573025 | 597 | 6.05191462045309 | 7.7503272666325 | 0.253606420508736 | weekly | |||||||||
1866 | 1866 | Guatemala | Guatemala | 0 | 2020-12-21 | 2020-12-27 | 7 | 2020 | 52 | 17843914 | 1898 | 112 | 1694.89353932583 | 203.106460674174 | 1786 | 0.627664984262982 | 1.13823940573897 | 0.119834347091182 | weekly | |||||||||
13920 | 13920 | Guatemala | Guatemala | 0 | 2020-12-21 | 2020-12-27 | 7 | 2020 | 52 | 17843914 | 1898 | 112 | 1694.89353932583 | 203.106460674174 | 1786 | 0.627664984262982 | 1.13823940573898 | 0.11983434709118 | weekly | |||||||||
11362 | 11362 | Austria | Austria | 0 | 2020-10-19 | 2020-10-25 | 7 | 2020 | 43 | 8939617 | 1772 | 112 | 1518.70449438199 | 253.295505618006 | 1660 | 1.25285009413714 | 2.83340444694673 | 0.166783931011598 | weekly | |||||||||
21012 | 21012 | Austria | Austria | 0 | 2020-10-19 | 2020-10-25 | 7 | 2020 | 43 | 8939617 | 1772 | 112 | 1518.70449438199 | 253.295505618006 | 1660 | 1.25285009413714 | 2.83340444694673 | 0.166783931011595 | weekly | |||||||||
2776 | 2776 | United States | Arkansas | AR | 2020-10-18 | 2020-10-24 | 7 | 2020 | 43 | 3017825 | 794 | 112 | 633.954887219384 | 160.045112780616 | 682 | 3.71128213199904 | 5.30332649443279 | 0.252455050047168 | weekly | |||||||||
4446 | 4446 | United States | Indiana | IN | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 6732219 | 1442 | 112 | 1207.7944862169 | 234.205513783098 | 1330 | 1.66364166109272 | 3.47887544631418 | 0.193911726254592 | weekly | |||||||||
1850 | 1850 | Guatemala | Guatemala | 0 | 2020-08-31 | 2020-09-06 | 7 | 2020 | 36 | 17843914 | 2029 | 112 | 1612.09353932583 | 416.906460674174 | 1917 | 0.627664984262982 | 2.33640702748384 | 0.258611830209631 | weekly | |||||||||
13904 | 13904 | Guatemala | Guatemala | 0 | 2020-08-31 | 2020-09-06 | 7 | 2020 | 36 | 17843914 | 2029 | 112 | 1612.09353932583 | 416.906460674174 | 1917 | 0.627664984262982 | 2.33640702748385 | 0.258611830209628 | weekly | |||||||||
2769 | 2769 | United States | Arkansas | AR | 2020-08-30 | 2020-09-05 | 7 | 2020 | 36 | 3017825 | 713 | 112 | 569.621553886014 | 143.378446113986 | 601 | 3.71128213199904 | 4.75105236764843 | 0.25170825284936 | weekly | |||||||||
7317 | 7317 | United States | North Carolina | NC | 2020-06-07 | 2020-06-13 | 7 | 2020 | 24 | 10488084 | 1878 | 112 | 1798.37092731893 | 79.6290726810748 | 1766 | 1.06787855627396 | 0.759233742608038 | 0.0442784474945825 | weekly | |||||||||
7316 | 7316 | United States | North Carolina | NC | 2020-05-31 | 2020-06-06 | 7 | 2020 | 23 | 10488084 | 1967 | 112 | 1820.03759398557 | 146.962406014425 | 1855 | 1.06787855627396 | 1.40123216036814 | 0.0807469068221842 | 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);