economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where "end_date" is on date 2021-09-18 sorted by covid_deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: non_covid_deaths, covid_deaths_per_100k, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6927 | 6927 | United States | New Jersey | NJ | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 8882190 | 1576 | 0 | 1309.84335839703 | 266.156641602967 | 1576 | 0.0 | 2.99652047077317 | 0.203197305919607 | weekly | |||||||||
9967 | 9967 | United States | Wyoming | WY | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 578759 | 127 | 0 | 99.4172932339941 | 27.5827067660059 | 127 | 0.0 | 4.76583634397147 | 0.277443751169987 | weekly | |||||||||
3583 | 3583 | United States | District of Columbia | DC | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 705749 | 132 | 2 | 110.615288221033 | 21.3847117789672 | 130 | 0.28338686983616 | 3.03007326669499 | 0.193325101103891 | weekly | |||||||||
9207 | 9207 | United States | Vermont | VT | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 623989 | 155 | 11 | 97.2055137853829 | 57.7944862146171 | 144 | 1.76285158872993 | 9.26210016756979 | 0.594559752466508 | weekly | |||||||||
3431 | 3431 | United States | Delaware | DE | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 973764 | 211 | 13 | 169.815789477543 | 41.1842105224573 | 198 | 1.3350257351884 | 4.22938314853058 | 0.242522857557387 | weekly | |||||||||
2519 | 2519 | United States | Alaska | AK | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 731545 | 147 | 14 | 87.2794486254363 | 59.7205513745637 | 133 | 1.91375786862052 | 8.16361965081625 | 0.684245287007451 | weekly | |||||||||
7535 | 7535 | United States | North Dakota | ND | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 762062 | 174 | 15 | 151.343358396935 | 22.656641603065 | 159 | 1.96834378305177 | 2.97307064294834 | 0.149703573668839 | weekly | |||||||||
8599 | 8599 | United States | South Dakota | SD | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 884659 | 177 | 15 | 160.413533835348 | 16.5864661646522 | 162 | 1.69556857501026 | 1.87489938661701 | 0.103398172012574 | weekly | |||||||||
6775 | 6775 | United States | New Hampshire | NH | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 1359711 | 285 | 16 | 235.399749374303 | 49.6002506256965 | 269 | 1.17672064137159 | 3.64785242052881 | 0.210706471682892 | weekly | |||||||||
6471 | 6471 | United States | Nebraska | NE | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 1934408 | 366 | 17 | 311.057644111402 | 54.9423558885977 | 349 | 0.87882184110074 | 2.84026719743703 | 0.17663078509307 | weekly | |||||||||
8295 | 8295 | United States | Rhode Island | RI | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 1059361 | 201 | 19 | 190.533834587405 | 10.4661654125949 | 182 | 1.79353402664436 | 0.987969673472493 | 0.0549307446378702 | weekly | |||||||||
5255 | 5255 | United States | Maine | ME | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 1344212 | 331 | 21 | 285.868421053378 | 45.1315789466216 | 310 | 1.5622535730971 | 3.35747478423207 | 0.157875356712431 | weekly | |||||||||
3279 | 3279 | United States | Connecticut | CT | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 3565287 | 685 | 39 | 573.394736842744 | 111.605263157256 | 646 | 1.09388108166327 | 3.13033040978907 | 0.194639496992566 | weekly | |||||||||
6319 | 6319 | United States | Montana | MT | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 1068778 | 313 | 43 | 188.468671680076 | 124.531328319924 | 270 | 4.02328640746722 | 11.6517488496137 | 0.660753467458586 | weekly | |||||||||
4039 | 4039 | United States | Hawaii | HI | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 1415872 | 267 | 53 | 245.796992482116 | 21.2030075178845 | 214 | 3.74327622835963 | 1.49752290587599 | 0.0862622740163399 | weekly | |||||||||
9055 | 9055 | United States | Utah | UT | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 3205958 | 479 | 63 | 360.66165413623 | 118.33834586377 | 416 | 1.96509124573684 | 3.69120075383925 | 0.328114576380972 | weekly | |||||||||
4647 | 4647 | United States | Iowa | IA | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 3155070 | 672 | 64 | 558.097744361527 | 113.902255638473 | 608 | 2.02848114304912 | 3.61013402677193 | 0.204090155871852 | weekly | |||||||||
7079 | 7079 | United States | New Mexico | NM | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 2096829 | 489 | 70 | 349.29573934927 | 139.70426065073 | 419 | 3.33837427849386 | 6.66264443360571 | 0.399959818894431 | weekly | |||||||||
9815 | 9815 | United States | Wisconsin | WI | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 5822434 | 1263 | 90 | 1035.45363408611 | 227.546365913885 | 1173 | 1.54574530170716 | 3.90809695591028 | 0.219755243907871 | weekly | |||||||||
5863 | 5863 | United States | Minnesota | MN | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 5639632 | 989 | 91 | 853.576441103585 | 135.423558896415 | 898 | 1.61358046056906 | 2.40128361028548 | 0.158654283758496 | weekly | |||||||||
5559 | 5559 | United States | Massachusetts | MA | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 6949503 | 1156 | 96 | 1060.35463659229 | 95.6453634077136 | 1060 | 1.38139374858893 | 1.37629069888471 | 0.090201296912412 | weekly | |||||||||
4799 | 4799 | United States | Kansas | KS | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 2913314 | 650 | 99 | 488.256892231351 | 161.743107768649 | 551 | 3.39819188731458 | 5.55185976412596 | 0.331266409839044 | weekly | |||||||||
3127 | 3127 | United States | Colorado | CO | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 5758736 | 979 | 100 | 776.132832081278 | 202.867167918722 | 879 | 1.73649217467166 | 3.52277249588663 | 0.261382020619735 | weekly | |||||||||
5407 | 5407 | United States | Maryland | MD | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 6045680 | 1131 | 114 | 912.16165413626 | 218.83834586374 | 1017 | 1.88564396395443 | 3.6197474206994 | 0.239911801676163 | weekly | |||||||||
4191 | 4191 | United States | Idaho | ID | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 1787065 | 465 | 140 | 266.463659148656 | 198.536340851344 | 325 | 7.8340743061948 | 11.1096317622103 | 0.745078490198857 | weekly | |||||||||
6623 | 6623 | United States | Nevada | NV | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 3080156 | 702 | 143 | 487.115288221447 | 214.884711778553 | 559 | 4.64262199706768 | 6.97642300515145 | 0.441137276892168 | weekly | |||||||||
7991 | 7991 | United States | Oregon | OR | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 4217737 | 996 | 157 | 652.082706767896 | 343.917293232104 | 839 | 3.72237529272214 | 8.15407156093667 | 0.5274136082166 | weekly | |||||||||
7231 | 7231 | United States | New York | NY | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 19453561 | 3280 | 163 | 2740.84962406102 | 539.15037593898 | 3117 | 0.837892867018023 | 2.77147395245004 | 0.196709214254571 | weekly | |||||||||
9663 | 9663 | United States | West Virginia | WV | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 1792147 | 652 | 163 | 427.870927319334 | 224.129072680666 | 489 | 9.09523604927498 | 12.5061768192378 | 0.523824028159292 | weekly | |||||||||
5711 | 5711 | United States | Michigan | MI | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 9986857 | 2172 | 176 | 1787.46365914872 | 384.536340851276 | 1996 | 1.76231621219769 | 3.8504240208033 | 0.215129599353315 | weekly | |||||||||
6167 | 6167 | United States | Missouri | MO | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 6137428 | 1523 | 188 | 1184.25689223142 | 338.743107768584 | 1335 | 3.06317239077998 | 5.51930071959433 | 0.286038536056407 | weekly | |||||||||
12015 | 12015 | Canada | Canada | 0 | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 38454328 | 5990 | 198 | 5346.17614424422 | 643.823855755776 | 5792 | 0.514896528682025 | 1.6742559010673 | 0.120426981525652 | weekly | |||||||||
9359 | 9359 | United States | Virginia | VA | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 8535519 | 1769 | 206 | 1284.27944862227 | 484.720551377732 | 1563 | 2.41344433771397 | 5.67886441794263 | 0.377426074907392 | weekly | |||||||||
2823 | 2823 | United States | Arkansas | AR | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 3017825 | 882 | 213 | 625.765664162019 | 256.234335837981 | 669 | 7.0580633403196 | 8.49069564464411 | 0.409473306882556 | weekly | |||||||||
2671 | 2671 | United States | Arizona | AZ | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 7278717 | 1617 | 232 | 1128.21553885747 | 488.784461142527 | 1385 | 3.18737491785984 | 6.71525574002296 | 0.433236774630415 | weekly | |||||||||
4951 | 4951 | United States | Kentucky | KY | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 4467673 | 1421 | 248 | 913.243107770929 | 507.756892229071 | 1173 | 5.55098817661901 | 11.3651310700016 | 0.555993128126003 | weekly | |||||||||
7839 | 7839 | United States | Oklahoma | OK | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 3956971 | 1108 | 279 | 728.398496241389 | 379.601503758611 | 829 | 7.0508477317625 | 9.59323441487468 | 0.521145369900396 | weekly | |||||||||
8143 | 8143 | United States | Pennsylvania | PA | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 12801989 | 2945 | 279 | 2380.42857142975 | 564.57142857025 | 2666 | 2.17934884962016 | 4.41002900854117 | 0.237172177878521 | weekly | |||||||||
9511 | 9511 | United States | Washington | WA | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 7614893 | 1492 | 283 | 1020.35087719387 | 471.649122806129 | 1209 | 3.71640153052709 | 6.19377216207935 | 0.46224209078277 | weekly | |||||||||
4343 | 4343 | United States | Illinois | IL | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 12671821 | 2289 | 297 | 1946.38596491282 | 342.61403508718 | 1992 | 2.34378310741605 | 2.70374743367334 | 0.17602574271672 | weekly | |||||||||
4495 | 4495 | United States | Indiana | IN | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 6732219 | 1705 | 300 | 1219.19172932497 | 485.808270675027 | 1405 | 4.45618302078408 | 7.21616855712844 | 0.398467492019489 | weekly | |||||||||
6015 | 6015 | United States | Mississippi | MS | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 2976149 | 953 | 309 | 592.602756892978 | 360.397243107022 | 644 | 10.3825446911428 | 12.1095161266127 | 0.608159916427975 | weekly | |||||||||
7687 | 7687 | United States | Ohio | OH | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 11689100 | 3131 | 317 | 2263.72556391204 | 867.274436087965 | 2814 | 2.71192820661984 | 7.41951421484943 | 0.383118187961438 | weekly | |||||||||
5103 | 5103 | United States | Louisiana | LA | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 4648794 | 1312 | 362 | 884.92481203099 | 427.07518796901 | 950 | 7.78696582382442 | 9.18679528430405 | 0.482611835675428 | weekly | |||||||||
2367 | 2367 | United States | Alabama | AL | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 4903185 | 1586 | 443 | 973.037593969521 | 612.962406030479 | 1143 | 9.03494361318204 | 12.5013110056112 | 0.629947300936123 | weekly | |||||||||
8751 | 8751 | United States | Tennessee | TN | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 6833174 | 2397 | 451 | 1446.04135338441 | 950.958646615588 | 1946 | 6.60015389627134 | 13.9167924981215 | 0.657628942899801 | weekly | |||||||||
8447 | 8447 | United States | South Carolina | SC | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 5148714 | 1563 | 465 | 945.873433584969 | 617.126566415031 | 1098 | 9.0313814284499 | 11.9860331417715 | 0.652440955103316 | weekly | |||||||||
7383 | 7383 | United States | North Carolina | NC | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 10488084 | 2711 | 540 | 1746.38972431146 | 964.610275688541 | 2171 | 5.14870018203515 | 9.19720204079735 | 0.552345368425054 | weekly | |||||||||
3887 | 3887 | United States | Georgia | GA | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 10617423 | 2818 | 836 | 1638.37844611586 | 1179.62155388414 | 1982 | 7.87385036839919 | 11.1102435485912 | 0.719993330405866 | weekly | |||||||||
2975 | 2975 | United States | California | CA | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 39512223 | 6313 | 870 | 4737.57142857192 | 1575.42857142808 | 5443 | 2.20185029832414 | 3.98719295400839 | 0.332539275698683 | weekly | |||||||||
17066 | 17066 | South Africa | South Africa | 0 | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 59893884 | 12181 | 1365 | 10177.3012552301 | 2003.69874476995 | 10816 | 2.27903069368485 | 3.34541460822602 | 0.196879181869575 | weekly | |||||||||
8903 | 8903 | United States | Texas | TX | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 28995881 | 6275 | 1792 | 3813.6766917299 | 2461.3233082701 | 4483 | 6.18018814465406 | 8.48852741625646 | 0.645393804253928 | weekly | |||||||||
3735 | 3735 | United States | Florida | FL | 2021-09-12 | 2021-09-18 | 7 | 2021 | 37 | 21477737 | 6285 | 2633 | 3921.69423558998 | 2363.30576441002 | 3652 | 12.2592058930603 | 11.003513845104 | 0.602623667843007 | 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);