economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where cadence = "weekly" and "end_date" is on date 2021-08-28 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date)
country 3
- United States 51
- Canada 1
- South Africa 1
cadence 1
- weekly · 53 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2364 | 2364 | United States | Alabama | AL | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 4903185 | 1619 | 211 | 946.037593972612 | 672.962406027388 | 1408 | 4.30332528754269 | 13.7250054001101 | 0.711348481619506 | weekly | |||||||||
2516 | 2516 | United States | Alaska | AK | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 731545 | 135 | 34 | 92.2794486253727 | 42.7205513746273 | 101 | 4.64769768093555 | 5.83977081035716 | 0.462947622802344 | weekly | |||||||||
2668 | 2668 | United States | Arizona | AZ | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 7278717 | 1592 | 216 | 1120.54887219074 | 471.451127809259 | 1376 | 2.96755595800743 | 6.47711853351709 | 0.420732321016524 | weekly | |||||||||
2820 | 2820 | United States | Arkansas | AR | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 3017825 | 903 | 222 | 579.432330828623 | 323.567669171377 | 681 | 7.35629136878381 | 10.7218831168599 | 0.558421841440321 | weekly | |||||||||
2972 | 2972 | United States | California | CA | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 39512223 | 6353 | 589 | 4672.90476190519 | 1680.09523809481 | 5764 | 1.49067796058956 | 4.25208988645061 | 0.359539798840201 | weekly | |||||||||
3124 | 3124 | United States | Colorado | CO | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 5758736 | 926 | 44 | 763.466165414552 | 162.533834585448 | 882 | 0.764056556855532 | 2.82238731877009 | 0.212889374733711 | weekly | |||||||||
3276 | 3276 | United States | Connecticut | CT | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 3565287 | 630 | 21 | 552.728070176015 | 77.2719298239853 | 609 | 0.589012890126377 | 2.16734108148896 | 0.139800987128043 | weekly | |||||||||
3428 | 3428 | United States | Delaware | DE | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 973764 | 202 | 24 | 174.149122810814 | 27.8508771891859 | 178 | 2.46466289573244 | 2.86012598424114 | 0.159925452047448 | weekly | |||||||||
3580 | 3580 | United States | District of Columbia | DC | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 705749 | 119 | 4 | 106.948621554305 | 12.0513784456951 | 115 | 0.56677373967232 | 1.70760120746824 | 0.112683812755602 | weekly | |||||||||
3732 | 3732 | United States | Florida | FL | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 21477737 | 7349 | 1838 | 3781.36090225659 | 3567.63909774341 | 5511 | 8.55769860670144 | 16.6108705854039 | 0.943480188736906 | weekly | |||||||||
3884 | 3884 | United States | Georgia | GA | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 10617423 | 2828 | 354 | 1606.04511278247 | 1221.95488721753 | 2474 | 3.33414238087717 | 11.5089592570394 | 0.760847175145971 | weekly | |||||||||
4036 | 4036 | United States | Hawaii | HI | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 1415872 | 315 | 20 | 216.796992482055 | 98.2030075179452 | 295 | 1.41255706730552 | 6.93586761500653 | 0.452972185608497 | weekly | |||||||||
4188 | 4188 | United States | Idaho | ID | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 1787065 | 361 | 44 | 262.463659148593 | 98.5363408514074 | 317 | 2.46213763908979 | 5.51386440064616 | 0.375428511402493 | weekly | |||||||||
4340 | 4340 | United States | Illinois | IL | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 12671821 | 2301 | 206 | 1853.38596491276 | 447.614035087245 | 2095 | 1.62565427652427 | 3.53235762316438 | 0.24151150573125 | weekly | |||||||||
4492 | 4492 | United States | Indiana | IN | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 6732219 | 1547 | 145 | 1179.19172932491 | 367.808270675089 | 1402 | 2.15382179337897 | 5.46340323562097 | 0.31191557872074 | weekly | |||||||||
4644 | 4644 | United States | Iowa | IA | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 3155070 | 680 | 42 | 551.76441102813 | 128.23558897187 | 638 | 1.33119075012599 | 4.06442928276931 | 0.232410040243302 | weekly | |||||||||
4796 | 4796 | United States | Kansas | KS | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 2913314 | 628 | 53 | 468.590225564622 | 159.409774435378 | 575 | 1.81923404068357 | 5.47176769944392 | 0.340190139995555 | weekly | |||||||||
4948 | 4948 | United States | Kentucky | KY | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 4467673 | 1266 | 168 | 873.243107770866 | 392.756892229134 | 1098 | 3.76034682932256 | 8.79108413326433 | 0.449768098636046 | weekly | |||||||||
5100 | 5100 | United States | Louisiana | LA | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 4648794 | 1419 | 441 | 837.258145364258 | 581.741854635742 | 978 | 9.48633129366455 | 12.5138230396043 | 0.694817790494769 | weekly | |||||||||
5252 | 5252 | United States | Maine | ME | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 1344212 | 303 | 6 | 274.20175438665 | 28.7982456133496 | 297 | 0.446358163742029 | 2.14238867182778 | 0.105025752580494 | weekly | |||||||||
5404 | 5404 | United States | Maryland | MD | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 6045680 | 998 | 41 | 898.49498746953 | 99.5050125304697 | 957 | 0.678170197562557 | 1.64588619527447 | 0.110746319031461 | weekly | |||||||||
5556 | 5556 | United States | Massachusetts | MA | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 6949503 | 1132 | 45 | 1025.35463659222 | 106.645363407781 | 1087 | 0.64752831965106 | 1.53457539924482 | 0.104008271481775 | weekly | |||||||||
5708 | 5708 | United States | Michigan | MI | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 9986857 | 1990 | 127 | 1715.13032581533 | 274.869674184669 | 1863 | 1.27167135766538 | 2.7523141082792 | 0.160261683935886 | weekly | |||||||||
5860 | 5860 | United States | Minnesota | MN | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 5639632 | 912 | 39 | 845.24310777019 | 66.7568922298096 | 873 | 0.691534483101025 | 1.18371007593775 | 0.0789795167995146 | weekly | |||||||||
6012 | 6012 | United States | Mississippi | MS | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 2976149 | 1041 | 288 | 574.602756892916 | 466.397243107084 | 753 | 9.67693485776418 | 15.6711657617641 | 0.811686399886178 | weekly | |||||||||
6164 | 6164 | United States | Missouri | MO | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 6137428 | 1670 | 247 | 1164.25689223135 | 505.743107768648 | 1423 | 4.02448713043966 | 8.24031023693717 | 0.434391336777374 | weekly | |||||||||
6316 | 6316 | United States | Montana | MT | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 1068778 | 270 | 28 | 190.802005013346 | 79.1979949866542 | 242 | 2.61981440486238 | 7.41014457508053 | 0.415079469322739 | weekly | |||||||||
6468 | 6468 | United States | Nebraska | NE | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 1934408 | 359 | 13 | 307.390977444671 | 51.6090225553286 | 346 | 0.672040231429978 | 2.66794918938138 | 0.167893745562581 | weekly | |||||||||
6620 | 6620 | United States | Nevada | NV | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 3080156 | 737 | 153 | 466.448621554717 | 270.551378445283 | 584 | 4.9672808779815 | 8.78369077557379 | 0.580023963933068 | weekly | |||||||||
6772 | 6772 | United States | New Hampshire | NH | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 1359711 | 242 | 18 | 223.066416040907 | 18.9335839590927 | 224 | 1.32381072154303 | 1.3924711912379 | 0.0848786845421885 | weekly | |||||||||
6924 | 6924 | United States | New Jersey | NJ | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 8882190 | 1489 | 0 | 1349.1766917303 | 139.823308269697 | 1489 | 0.0 | 1.574198573434 | 0.103636024196635 | weekly | |||||||||
7076 | 7076 | United States | New Mexico | NM | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 2096829 | 463 | 33 | 332.295739349207 | 130.704260650793 | 430 | 1.57380501700425 | 6.23342488351664 | 0.393337154748882 | weekly | |||||||||
7228 | 7228 | United States | New York | NY | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 19453561 | 3150 | 180 | 2745.51629072763 | 404.483709272372 | 2970 | 0.92528046664567 | 2.07922708481173 | 0.147325190033811 | weekly | |||||||||
7380 | 7380 | United States | North Carolina | NC | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 10488084 | 2554 | 260 | 1757.72305764473 | 796.276942355274 | 2294 | 2.47900379135026 | 7.59220599639814 | 0.453016155697616 | weekly | |||||||||
7532 | 7532 | United States | North Dakota | ND | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 762062 | 139 | 9 | 141.676691730206 | -2.6766917302057 | 130 | 1.18100626983106 | -0.351243301753099 | -0.0188929576030962 | weekly | |||||||||
7684 | 7684 | United States | Ohio | OH | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 11689100 | 2715 | 110 | 2171.72556391197 | 543.274436088027 | 2605 | 0.941047642675655 | 4.64770115824167 | 0.250157959696075 | weekly | |||||||||
7836 | 7836 | United States | Oklahoma | OK | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 3956971 | 1120 | 266 | 697.065162907993 | 422.934837092007 | 854 | 6.72231360806031 | 10.6883481605503 | 0.606736442440506 | weekly | |||||||||
7988 | 7988 | United States | Oregon | OR | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 4217737 | 983 | 103 | 667.082706767833 | 315.917293232167 | 880 | 2.44206786719988 | 7.4902084514081 | 0.473580397193711 | weekly | |||||||||
8140 | 8140 | United States | Pennsylvania | PA | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 12801989 | 2742 | 133 | 2318.42857142968 | 423.571428570316 | 2609 | 1.03890106451427 | 3.30863765443257 | 0.182697640026545 | weekly | |||||||||
8292 | 8292 | United States | Rhode Island | RI | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 1059361 | 220 | 11 | 196.200501254006 | 23.799498745994 | 209 | 1.03836180489937 | 2.24659004305369 | 0.121301926314564 | weekly | |||||||||
8444 | 8444 | United States | South Carolina | SC | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 5148714 | 1415 | 239 | 905.206766918245 | 509.793233081755 | 1176 | 4.64193583096672 | 9.90137018839569 | 0.563178769439975 | weekly | |||||||||
8596 | 8596 | United States | South Dakota | SD | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 884659 | 182 | 3 | 148.413533835283 | 33.5864661647167 | 179 | 0.339113715002052 | 3.79654377163593 | 0.226303257504754 | weekly | |||||||||
8748 | 8748 | United States | Tennessee | TN | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 6833174 | 2128 | 203 | 1403.37468671769 | 724.625313282312 | 1925 | 2.97080097770085 | 10.6045201436743 | 0.516344865088822 | weekly | |||||||||
8900 | 8900 | United States | Texas | TX | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 28995881 | 6609 | 2044 | 3842.67669172985 | 2766.32330827015 | 4565 | 7.04927710249604 | 9.54040095650189 | 0.719894888431231 | weekly | |||||||||
9052 | 9052 | United States | Utah | UT | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 3205958 | 459 | 51 | 373.994987469502 | 85.0050125304981 | 408 | 1.59078815131078 | 2.65146993599099 | 0.227289176001136 | weekly | |||||||||
9204 | 9204 | United States | Vermont | VT | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 623989 | 115 | 5 | 91.2055137853191 | 23.7944862146809 | 110 | 0.801296176695423 | 3.81328616605114 | 0.260888681255485 | weekly | |||||||||
9356 | 9356 | United States | Virginia | VA | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 8535519 | 1603 | 131 | 1276.94611528888 | 326.053884711125 | 1472 | 1.53476314679869 | 3.81996554294033 | 0.255338796842938 | weekly | |||||||||
9508 | 9508 | United States | Washington | WA | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 7614893 | 1413 | 177 | 1017.35087719381 | 395.649122806193 | 1236 | 2.32439247669009 | 5.19572793480082 | 0.388901343357097 | weekly | |||||||||
9660 | 9660 | United States | West Virginia | WV | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 1792147 | 559 | 46 | 404.204260652603 | 154.795739347397 | 513 | 2.56675373169723 | 8.6374465569731 | 0.382964145646246 | weekly | |||||||||
9812 | 9812 | United States | Wisconsin | WI | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 5822434 | 1178 | 35 | 980.786967419392 | 197.213032580608 | 1143 | 0.601123172886116 | 3.38712353940995 | 0.201076318437946 | weekly | |||||||||
9964 | 9964 | United States | Wyoming | WY | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 578759 | 125 | 26 | 91.4172932339306 | 33.5827067660694 | 99 | 4.49237074499058 | 5.80253728513413 | 0.367356170567571 | weekly | |||||||||
12012 | 12012 | Canada | Canada | 0 | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 38454328 | 5655 | 108 | 5273.17614424422 | 381.823855755778 | 5547 | 0.280852652008377 | 0.992928171195133 | 0.0724087049837219 | weekly | |||||||||
17063 | 17063 | South Africa | South Africa | 0 | 2021-08-22 | 2021-08-28 | 7 | 2021 | 34 | 59893884 | 14887 | 2210 | 10439.5012552301 | 4447.49874476994 | 12677 | 3.6898592183469 | 7.42563087872201 | 0.426025979214452 | 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);