economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
57 rows where cadence = "weekly" and covid_deaths = 72 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region_code, year, week, start_date (date), end_date (date)
country 12
cadence 1
- weekly · 57 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8965 | 8965 | United States | Texas | TX | 2022-11-20 | 2022-11-26 | 7 | 2022 | 47 | 28995881 | 4516 | 72 | 4200.90225563966 | 315.097744360339 | 4444 | 0.248311130811994 | 1.08669829470034 | 0.0750071592209325 | weekly | |||||||||
8807 | 8807 | United States | Tennessee | TN | 2022-10-09 | 2022-10-15 | 7 | 2022 | 41 | 6833174 | 1595 | 72 | 1424.7218045122 | 170.278195487802 | 1523 | 1.05368310539143 | 2.4919341361394 | 0.119516803174149 | weekly | |||||||||
4545 | 4545 | United States | Indiana | IN | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 6732219 | 1400 | 72 | 1219.58897243289 | 180.411027567106 | 1328 | 1.06948392498818 | 2.67981519268915 | 0.147927729460536 | weekly | |||||||||
4544 | 4544 | United States | Indiana | IN | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 6732219 | 1420 | 72 | 1183.25563909959 | 236.744360900408 | 1348 | 1.06948392498818 | 3.51658733770259 | 0.200078793692088 | weekly | |||||||||
11610 | 11610 | Belgium | Belgium | 0 | 2022-08-15 | 2022-08-21 | 7 | 2022 | 33 | 11655923 | 2098 | 72 | 1820.39382022478 | 277.606179775222 | 2026 | 0.617711699022034 | 2.38167479122178 | 0.152497869796625 | weekly | |||||||||
20434 | 20434 | Belgium | Belgium | 0 | 2022-08-15 | 2022-08-21 | 7 | 2022 | 33 | 11655923 | 2098 | 72 | 1820.39382022478 | 277.606179775222 | 2026 | 0.617711699022034 | 2.38167479122178 | 0.152497869796626 | weekly | |||||||||
4391 | 4391 | United States | Illinois | IL | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 12671821 | 2092 | 72 | 1808.40350877235 | 283.596491227654 | 2020 | 0.568189844222074 | 2.23800897461899 | 0.156821467029876 | weekly | |||||||||
582 | 582 | Portugal | Portugal | 0 | 2022-08-01 | 2022-08-07 | 7 | 2022 | 31 | 10270857 | 2196 | 72 | 1948.6098314607 | 247.390168539302 | 2124 | 0.701012583467962 | 2.40866140517098 | 0.126957261810516 | weekly | |||||||||
16514 | 16514 | Portugal | Portugal | 0 | 2022-08-01 | 2022-08-07 | 7 | 2022 | 31 | 10270857 | 2196 | 72 | 1948.6098314607 | 247.390168539302 | 2124 | 0.701012583467962 | 2.40866140517098 | 0.126957261810515 | weekly | |||||||||
6664 | 6664 | United States | Nevada | NV | 2022-06-26 | 2022-07-02 | 7 | 2022 | 26 | 3080156 | 568 | 72 | 530.709273183799 | 37.2907268162012 | 496 | 2.33754394257953 | 1.2106765636611 | 0.0702658285816053 | weekly | |||||||||
5597 | 5597 | United States | Massachusetts | MA | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 6949503 | 1139 | 72 | 1054.91729323384 | 84.0827067661594 | 1067 | 1.0360453114417 | 1.20990964053342 | 0.0797054966351007 | weekly | |||||||||
9546 | 9546 | United States | Washington | WA | 2022-05-15 | 2022-05-21 | 7 | 2022 | 20 | 7614893 | 1232 | 72 | 1112.91228070257 | 119.087719297425 | 1160 | 0.94551558373834 | 1.56387908927184 | 0.107005485843184 | weekly | |||||||||
2851 | 2851 | United States | Arkansas | AR | 2022-03-27 | 2022-04-02 | 7 | 2022 | 13 | 3017825 | 654 | 72 | 644.576441104577 | 9.42355889542341 | 582 | 2.38582422771367 | 0.312263265610942 | 0.0146197693469448 | weekly | |||||||||
3149 | 3149 | United States | Colorado | CO | 2022-02-13 | 2022-02-19 | 7 | 2022 | 7 | 5758736 | 963 | 72 | 866.960526316811 | 96.0394736831894 | 891 | 1.2502743657636 | 1.66771794510444 | 0.110777216225983 | weekly | |||||||||
1549 | 1549 | Latvia | Latvia | 0 | 2022-01-10 | 2022-01-16 | 7 | 2022 | 2 | 1850654 | 680 | 72 | 597.397284644203 | 82.6027153557968 | 608 | 3.89051654171985 | 4.46343375670422 | 0.13827099231794 | weekly | |||||||||
14847 | 14847 | Latvia | Latvia | 0 | 2022-01-10 | 2022-01-16 | 7 | 2022 | 2 | 1850654 | 680 | 72 | 597.397284644203 | 82.6027153557968 | 608 | 3.89051654171985 | 4.46343375670421 | 0.13827099231794 | weekly | |||||||||
6488 | 6488 | United States | Nebraska | NE | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 1934408 | 487 | 72 | 385.289473685276 | 101.710526314724 | 415 | 3.72206897407372 | 5.25796658795476 | 0.263984700495104 | weekly | |||||||||
5271 | 5271 | United States | Maine | ME | 2022-01-02 | 2022-01-08 | 7 | 2022 | 1 | 1344212 | 385 | 72 | 317.513157895407 | 67.4868421045926 | 313 | 5.35629796490435 | 5.0205504864257 | 0.212548174544702 | weekly | |||||||||
5567 | 5567 | United States | Massachusetts | MA | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 6949503 | 1285 | 72 | 1088.68796992553 | 196.312030074467 | 1213 | 1.0360453114417 | 2.82483553247573 | 0.180319830380687 | weekly | |||||||||
11566 | 11566 | Belgium | Belgium | 0 | 2021-10-11 | 2021-10-17 | 7 | 2021 | 41 | 11655923 | 2221 | 72 | 1992.15505617983 | 228.844943820172 | 2149 | 0.617711699022034 | 1.96333609805223 | 0.114873058254313 | weekly | |||||||||
20390 | 20390 | Belgium | Belgium | 0 | 2021-10-11 | 2021-10-17 | 7 | 2021 | 41 | 11655923 | 2221 | 72 | 1992.15505617983 | 228.844943820172 | 2149 | 0.617711699022034 | 1.96333609805223 | 0.114873058254314 | weekly | |||||||||
1086 | 1086 | Slovakia | Slovakia | 0 | 2021-09-27 | 2021-10-03 | 7 | 2021 | 39 | 5643455 | 1103 | 72 | 987.542696629197 | 115.457303370803 | 1031 | 1.27581419538208 | 2.04586203612509 | 0.116913733213659 | weekly | |||||||||
16771 | 16771 | Slovakia | Slovakia | 0 | 2021-09-27 | 2021-10-03 | 7 | 2021 | 39 | 5643455 | 1103 | 72 | 987.542696629197 | 115.457303370803 | 1031 | 1.27581419538208 | 2.04586203612509 | 0.116913733213659 | weekly | |||||||||
6321 | 6321 | United States | Montana | MT | 2021-09-26 | 2021-10-02 | 7 | 2021 | 39 | 1068778 | 297 | 72 | 183.802005013349 | 113.197994986651 | 225 | 6.73666561250325 | 10.5913477809845 | 0.61586920653248 | weekly | |||||||||
17503 | 17503 | Sweden | Sweden | 0 | 2021-09-13 | 2021-09-19 | 7 | 2021 | 37 | 10549349 | 1707.2 | 72 | 1551.14505617977 | 156.054943820232 | 1635.2 | 0.682506569836679 | 1.47928506128892 | 0.100606286432404 | weekly | |||||||||
24649 | 24649 | Sweden | Sweden | 0 | 2021-09-13 | 2021-09-19 | 7 | 2021 | 37 | 10549349 | 1707.2 | 72 | 1551.14505617977 | 156.054943820232 | 1635.2 | 0.682506569836679 | 1.47928506128892 | 0.100606286432406 | weekly | |||||||||
5095 | 5095 | United States | Louisiana | LA | 2021-07-18 | 2021-07-24 | 7 | 2021 | 29 | 4648794 | 1095 | 72 | 824.924812030938 | 270.075187969062 | 1023 | 1.54878878263911 | 5.80957529993934 | 0.327393701862531 | weekly | |||||||||
3878 | 3878 | United States | Georgia | GA | 2021-07-11 | 2021-07-17 | 7 | 2021 | 28 | 10617423 | 1744 | 72 | 1597.04511278247 | 146.95488721753 | 1672 | 0.678130653737729 | 1.38409185748303 | 0.0920167414441391 | weekly | |||||||||
12439 | 12439 | Croatia | Croatia | 0 | 2021-05-31 | 2021-06-06 | 7 | 2021 | 22 | 4030361 | 1143 | 72 | 886.423595505637 | 256.576404494363 | 1071 | 1.78644047022091 | 6.36608989850693 | 0.289451235047512 | weekly | |||||||||
17488 | 17488 | Sweden | Sweden | 0 | 2021-05-31 | 2021-06-06 | 7 | 2021 | 22 | 10549349 | 1560.7 | 72 | 1561.86505617977 | -1.16505617976759 | 1488.7 | 0.682506569836679 | -0.0110438680127806 | -0.000745939077873681 | weekly | |||||||||
23957 | 23957 | Croatia | Croatia | 0 | 2021-05-31 | 2021-06-06 | 7 | 2021 | 22 | 4030361 | 1143 | 72 | 886.423595505637 | 256.576404494363 | 1071 | 1.78644047022091 | 6.36608989850692 | 0.289451235047512 | weekly | |||||||||
24634 | 24634 | Sweden | Sweden | 0 | 2021-05-31 | 2021-06-06 | 7 | 2021 | 22 | 10549349 | 1560.7 | 72 | 1561.86505617977 | -1.16505617976759 | 1488.7 | 0.682506569836679 | -0.0110438680127806 | -0.000745939077872237 | weekly | |||||||||
2656 | 2656 | United States | Arizona | AZ | 2021-05-30 | 2021-06-05 | 7 | 2021 | 22 | 7278717 | 1335 | 72 | 1187.21553885741 | 147.784461142592 | 1263 | 0.989185319335812 | 2.03036415816953 | 0.124479891229205 | weekly | |||||||||
14966 | 14966 | Lithuania | Lithuania | 0 | 2021-05-24 | 2021-05-30 | 7 | 2021 | 21 | 2750058 | 817 | 72 | 702.028089887664 | 114.971910112336 | 745 | 2.61812659951172 | 4.18070855641357 | 0.163771096582095 | weekly | |||||||||
18381 | 18381 | Lithuania | Lithuania | 0 | 2021-05-24 | 2021-05-30 | 7 | 2021 | 21 | 2750058 | 817 | 72 | 702.028089887664 | 114.971910112336 | 745 | 2.61812659951172 | 4.18070855641356 | 0.163771096582094 | weekly | |||||||||
2344 | 2344 | United States | Alabama | AL | 2021-04-04 | 2021-04-10 | 7 | 2021 | 14 | 4903185 | 1209 | 72 | 1044.03759397221 | 164.96240602779 | 1137 | 1.46843327347428 | 3.36439285949418 | 0.158004277796323 | weekly | |||||||||
14957 | 14957 | Lithuania | Lithuania | 0 | 2021-03-22 | 2021-03-28 | 7 | 2021 | 12 | 2750058 | 832 | 72 | 730.028089887664 | 101.971910112336 | 760 | 2.61812659951172 | 3.70799125372396 | 0.139682173227098 | weekly | |||||||||
18372 | 18372 | Lithuania | Lithuania | 0 | 2021-03-22 | 2021-03-28 | 7 | 2021 | 12 | 2750058 | 832 | 72 | 730.028089887664 | 101.971910112336 | 760 | 2.61812659951172 | 3.70799125372395 | 0.139682173227097 | weekly | |||||||||
1505 | 1505 | Latvia | Latvia | 0 | 2021-03-08 | 2021-03-14 | 7 | 2021 | 10 | 1850654 | 610 | 72 | 605.049438202255 | 4.95056179774474 | 538 | 3.89051654171985 | 0.267503368957392 | 0.00818207816613148 | weekly | |||||||||
14803 | 14803 | Latvia | Latvia | 0 | 2021-03-08 | 2021-03-14 | 7 | 2021 | 10 | 1850654 | 610 | 72 | 605.049438202255 | 4.95056179774474 | 538 | 3.89051654171985 | 0.267503368957392 | 0.0081820781661317 | weekly | |||||||||
2794 | 2794 | United States | Arkansas | AR | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 3017825 | 789 | 72 | 695.693609024018 | 93.3063909759817 | 717 | 2.38582422771367 | 3.0918423359864 | 0.134119948445236 | weekly | |||||||||
9619 | 9619 | United States | West Virginia | WV | 2020-11-08 | 2020-11-14 | 7 | 2020 | 46 | 1792147 | 554 | 72 | 431.025062657601 | 122.974937342399 | 482 | 4.01752758004784 | 6.86187781149641 | 0.285308089938351 | weekly | |||||||||
9466 | 9466 | United States | Washington | WA | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 7614893 | 1274 | 72 | 1107.45614035169 | 166.543859648312 | 1202 | 0.94551558373834 | 2.18708075935291 | 0.150384158414999 | weekly | |||||||||
13607 | 13607 | Germany | Germany | 0 | 2020-09-28 | 2020-10-04 | 7 | 2020 | 40 | 83369840 | 17614 | 72 | 16870.6342696626 | 743.365730337417 | 17542 | 0.0863621664621163 | 0.891648263133787 | 0.0440627019977635 | weekly | |||||||||
23350 | 23350 | Germany | Germany | 0 | 2020-09-28 | 2020-10-04 | 7 | 2020 | 40 | 83369840 | 17614 | 72 | 16870.6342696626 | 743.365730337417 | 17542 | 0.0863621664621163 | 0.891648263133786 | 0.0440627019977646 | weekly | |||||||||
2770 | 2770 | United States | Arkansas | AR | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 3017825 | 722 | 72 | 622.288220552762 | 99.7117794472375 | 650 | 2.38582422771367 | 3.30409415546751 | 0.16023407828396 | weekly | |||||||||
13448 | 13448 | France | France | 0 | 2020-07-27 | 2020-08-02 | 7 | 2020 | 31 | 67813000 | 10866 | 72 | 10349.5581460671 | 516.441853932874 | 10794 | 0.106174332355153 | 0.761567625577506 | 0.0498998939514292 | weekly | |||||||||
19987 | 19987 | France | France | 0 | 2020-07-27 | 2020-08-02 | 7 | 2020 | 31 | 67813000 | 10866 | 72 | 10349.5581460671 | 516.441853932874 | 10794 | 0.106174332355153 | 0.761567625577506 | 0.0498998939514268 | weekly | |||||||||
5348 | 5348 | United States | Maryland | MD | 2020-07-26 | 2020-08-01 | 7 | 2020 | 31 | 6045680 | 1067 | 72 | 907.107769424415 | 159.892230575585 | 995 | 1.19093302986595 | 2.64473525849177 | 0.176265969673087 | weekly | |||||||||
5952 | 5952 | United States | Mississippi | MS | 2020-06-28 | 2020-07-04 | 7 | 2020 | 27 | 2976149 | 711 | 72 | 572.624060151126 | 138.375939848874 | 639 | 2.41923371444104 | 4.64949637430365 | 0.241652332618288 | weekly | |||||||||
3367 | 3367 | United States | Delaware | DE | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 973764 | 201 | 72 | 172.877192985424 | 28.1228070145763 | 129 | 7.39398868719731 | 2.88805162386125 | 0.162675055794939 | weekly | |||||||||
24877 | 24877 | Turkey | Istanbul | 0 | 2020-06-03 | 2020-06-10 | 7 | 2020 | 23 | 15519267 | 1465 | 72 | 1380.50000000015 | 84.4999999998472 | 1393 | 0.463939437345849 | 0.544484478550741 | 0.0612097066279158 | weekly | |||||||||
9741 | 9741 | United States | Wisconsin | WI | 2020-04-12 | 2020-04-18 | 7 | 2020 | 16 | 5822434 | 1152 | 72 | 1030.08020050211 | 121.919799497895 | 1080 | 1.23659624136572 | 2.09396619176611 | 0.118359521363935 | weekly | |||||||||
16240 | 16240 | Poland | Poland | 0 | 2020-03-30 | 2020-04-05 | 7 | 2020 | 14 | 39857144 | 7991 | 72 | 8188.11151685363 | -197.11151685363 | 7919 | 0.180645156110533 | -0.494545010183444 | -0.0240728910992375 | weekly | |||||||||
20809 | 20809 | Poland | Poland | 0 | 2020-03-30 | 2020-04-05 | 7 | 2020 | 14 | 39857144 | 7991 | 72 | 8188.11151685363 | -197.11151685363 | 7919 | 0.180645156110533 | -0.494545010183444 | -0.0240728910992375 | weekly | |||||||||
13428 | 13428 | France | France | 0 | 2020-03-09 | 2020-03-15 | 7 | 2020 | 11 | 67813000 | 12554 | 72 | 12229.7581460671 | 324.241853932874 | 12482 | 0.106174332355153 | 0.478141143929444 | 0.0265125319781707 | weekly | |||||||||
19967 | 19967 | France | France | 0 | 2020-03-09 | 2020-03-15 | 7 | 2020 | 11 | 67813000 | 12554 | 72 | 12229.7581460671 | 324.241853932874 | 12482 | 0.106174332355153 | 0.478141143929444 | 0.0265125319781687 | 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);