economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
51 rows where cadence = "weekly", country = "United States" and "start_date" is on date 2022-08-21 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2416 | 2416 | United States | Alabama | AL | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 4903185 | 1064 | 7 | 950.383458629777 | 113.616541370223 | 1057 | 0.142764346032222 | 2.31719874673753 | 0.119548104860779 | weekly | |||||||||
2568 | 2568 | United States | Alaska | AK | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 731545 | 105 | 0 | 94.8170426113475 | 10.1829573886525 | 105 | 0.0 | 1.39197963059723 | 0.107395855304116 | weekly | |||||||||
2720 | 2720 | United States | Arizona | AZ | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 7278717 | 1261 | 0 | 1144.39849625316 | 116.601503746841 | 1261 | 0.0 | 1.60195132942854 | 0.101888899826942 | weekly | |||||||||
2872 | 2872 | United States | Arkansas | AR | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 3017825 | 640 | 44 | 582.90977443788 | 57.0902255621203 | 596 | 1.45800369471391 | 1.89176726821868 | 0.0979400724875035 | weekly | |||||||||
3024 | 3024 | United States | California | CA | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 39512223 | 5460 | 272 | 4670.76190476213 | 789.238095237866 | 5188 | 0.688394576027778 | 1.99745302925089 | 0.168974165528153 | weekly | |||||||||
3176 | 3176 | United States | Colorado | CO | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 5758736 | 821 | 44 | 776.954887219013 | 44.0451127809868 | 777 | 0.764056556855532 | 0.764839936767144 | 0.0566894082340343 | weekly | |||||||||
3328 | 3328 | United States | Connecticut | CT | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 3565287 | 633 | 0 | 552.859649123208 | 80.1403508767922 | 633 | 0.0 | 2.24779522312768 | 0.144956049883345 | weekly | |||||||||
3480 | 3480 | United States | Delaware | DE | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 973764 | 196 | 3 | 174.754385969564 | 21.2456140304357 | 193 | 0.308082861966554 | 2.18180319157781 | 0.1215741391128 | weekly | |||||||||
3632 | 3632 | United States | District of Columbia | DC | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 705749 | 114 | 5 | 106.04260651673 | 7.95739348326994 | 109 | 0.7084671745904 | 1.12751041563926 | 0.0750395878095897 | weekly | |||||||||
3784 | 3784 | United States | Florida | FL | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 21477737 | 4524 | 620 | 3814.48120300841 | 709.518796991592 | 3904 | 2.88671008495914 | 3.30350817216726 | 0.186006630844585 | weekly | |||||||||
3936 | 3936 | United States | Georgia | GA | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 10617423 | 1868 | 160 | 1628.06015037648 | 239.939849623515 | 1708 | 1.50695700830606 | 2.25986898726287 | 0.147377754788746 | weekly | |||||||||
4088 | 4088 | United States | Hawaii | HI | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 1415872 | 241 | 13 | 219.729323309089 | 21.2706766909114 | 228 | 0.918162093748587 | 1.50230223430588 | 0.096803996710946 | weekly | |||||||||
4240 | 4240 | United States | Idaho | ID | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 1787065 | 313 | 17 | 265.395989975596 | 47.6040100244042 | 296 | 0.951280451466511 | 2.66380965574303 | 0.17936974115088 | weekly | |||||||||
4392 | 4392 | United States | Illinois | IL | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 12671821 | 2105 | 104 | 1842.07017543902 | 262.929824560981 | 2001 | 0.820718663876329 | 2.0749174452589 | 0.142736052115016 | 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 | |||||||||
4696 | 4696 | United States | Iowa | IA | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 3155070 | 630 | 25 | 554.463659148336 | 75.5363408516641 | 605 | 0.792375446503564 | 2.39412567238331 | 0.136233168045114 | weekly | |||||||||
4848 | 4848 | United States | Kansas | KS | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 2913314 | 499 | 11 | 472.120300752545 | 26.8796992474551 | 488 | 0.377576876368287 | 0.922650261779372 | 0.0569340043302728 | weekly | |||||||||
5000 | 5000 | United States | Kentucky | KY | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 4467673 | 1012 | 63 | 878.213032583082 | 133.786967416918 | 949 | 1.41013006099596 | 2.99455594482672 | 0.152339993205762 | weekly | |||||||||
5152 | 5152 | United States | Louisiana | LA | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 4648794 | 964 | 66 | 837.566416040898 | 126.433583959102 | 898 | 1.41972305075252 | 2.71970717478774 | 0.150953502358347 | weekly | |||||||||
5304 | 5304 | United States | Maine | ME | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 1344212 | 305 | 9 | 278.491228070808 | 26.5087719291922 | 296 | 0.669537245613043 | 1.97206779356174 | 0.0951870983974124 | weekly | |||||||||
5456 | 5456 | United States | Maryland | MD | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 6045680 | 1004 | 45 | 901.882205514627 | 102.117794485373 | 959 | 0.744333143666221 | 1.6891035331902 | 0.11322741912521 | weekly | |||||||||
5608 | 5608 | United States | Massachusetts | MA | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 6949503 | 1155 | 0 | 1019.58395990045 | 135.416040099548 | 1155 | 0.0 | 1.94857157554358 | 0.132814996533262 | weekly | |||||||||
5760 | 5760 | United States | Michigan | MI | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 9986857 | 2018 | 135 | 1725.06265664231 | 292.937343357687 | 1883 | 1.351776640038 | 2.93322857589417 | 0.169812581722605 | weekly | |||||||||
5912 | 5912 | United States | Minnesota | MN | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 5639632 | 919 | 0 | 856.213032582187 | 62.7869674178125 | 919 | 0.0 | 1.11331674509636 | 0.0733310111251848 | weekly | |||||||||
6064 | 6064 | United States | Mississippi | MS | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 2976149 | 618 | 37 | 575.914786968064 | 42.0852130319363 | 581 | 1.24321732547665 | 1.41408286453186 | 0.073075416683597 | weekly | |||||||||
6216 | 6216 | United States | Missouri | MO | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 6137428 | 1341 | 0 | 1163.7869674193 | 177.213032580699 | 1341 | 0.0 | 2.88741525897655 | 0.15227274195523 | weekly | |||||||||
6368 | 6368 | United States | Montana | MT | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 1068778 | 201 | 14 | 191.847117795279 | 9.15288220472144 | 187 | 1.30990720243119 | 0.856387594497776 | 0.0477092505214936 | weekly | |||||||||
6520 | 6520 | United States | Nebraska | NE | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 1934408 | 334 | 10 | 306.187969925871 | 27.812030074129 | 324 | 0.516954024176906 | 1.43775408673501 | 0.0908331900853663 | weekly | |||||||||
6672 | 6672 | United States | Nevada | NV | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 3080156 | 582 | 22 | 473.042606517103 | 108.957393482897 | 560 | 0.714249538010412 | 3.53739854354444 | 0.230333149660922 | weekly | |||||||||
6824 | 6824 | United States | New Hampshire | NH | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 1359711 | 277 | 10 | 223.310776943142 | 53.6892230568584 | 267 | 0.735450400857241 | 3.94857606188803 | 0.240423788729769 | weekly | |||||||||
6976 | 6976 | United States | New Jersey | NJ | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 8882190 | 1414 | 73 | 1346.90225564006 | 67.0977443599365 | 1341 | 0.821869381312492 | 0.755418926637874 | 0.0498163427071039 | weekly | |||||||||
7128 | 7128 | United States | New Mexico | NM | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 2096829 | 388 | 52 | 338.949874687549 | 49.0501253124509 | 336 | 2.47993517830972 | 2.33925252428552 | 0.144712032590855 | weekly | |||||||||
7280 | 7280 | United States | New York | NY | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 19453561 | 3021 | 153 | 2746.13283208101 | 274.867167918991 | 2868 | 0.786488396648819 | 1.41294011887587 | 0.100092451722627 | weekly | |||||||||
7432 | 7432 | United States | North Carolina | NC | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 10488084 | 2036 | 83 | 1777.74185463726 | 258.258145362744 | 1953 | 0.791374287238737 | 2.46239585192819 | 0.145273142267015 | weekly | |||||||||
7584 | 7584 | United States | North Dakota | ND | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 762062 | 144 | 0 | 144.902255639996 | -0.902255639996412 | 144 | 0.0 | -0.118396618647356 | -0.00622665006842982 | weekly | |||||||||
7736 | 7736 | United States | Ohio | OH | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 11689100 | 2428 | 96 | 2160.30075188212 | 267.699248117884 | 2332 | 0.821277942698753 | 2.29016133079436 | 0.123917583181257 | weekly | |||||||||
7888 | 7888 | United States | Oklahoma | OK | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 3956971 | 839 | 125 | 697.531328321483 | 141.468671678517 | 714 | 3.15898195867496 | 3.57517585240116 | 0.202813358962589 | weekly | |||||||||
8040 | 8040 | United States | Oregon | OR | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 4217737 | 764 | 41 | 670.443609023493 | 93.5563909765069 | 723 | 0.972085267526164 | 2.21816559393122 | 0.139544011930806 | weekly | |||||||||
8192 | 8192 | United States | Pennsylvania | PA | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 12801989 | 2618 | 102 | 2294.57142857254 | 323.428571427458 | 2516 | 0.796751192334254 | 2.52639313646855 | 0.14095380400891 | weekly | |||||||||
8344 | 8344 | United States | Rhode Island | RI | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 1059361 | 210 | 7 | 196.711779449499 | 13.2882205505012 | 203 | 0.660775694026871 | 1.25436187951993 | 0.0675517276478739 | weekly | |||||||||
8496 | 8496 | United States | South Carolina | SC | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 5148714 | 1116 | 0 | 920.609022557349 | 195.390977442651 | 1116 | 0.0 | 3.79494719346716 | 0.212240997703756 | weekly | |||||||||
8648 | 8648 | United States | South Dakota | SD | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 884659 | 151 | 5 | 150.218045113454 | 0.781954886546316 | 146 | 0.565189525003419 | 0.088390542180243 | 0.00520546573453107 | weekly | |||||||||
8800 | 8800 | United States | Tennessee | TN | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 6833174 | 1586 | 109 | 1421.05513784552 | 164.944862154479 | 1477 | 1.59515914566203 | 2.41388353574018 | 0.116072105692221 | weekly | |||||||||
8952 | 8952 | United States | Texas | TX | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 28995881 | 4321 | 352 | 3881.90225563966 | 439.09774436034 | 3969 | 1.21396552841419 | 1.51434524220989 | 0.11311406507529 | weekly | |||||||||
9104 | 9104 | United States | Utah | UT | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 3205958 | 405 | 15 | 380.882205514612 | 24.1177944853882 | 390 | 0.467878868032582 | 0.752280425551059 | 0.0633208748956979 | weekly | |||||||||
9256 | 9256 | United States | Vermont | VT | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 623989 | 144 | 5 | 89.829573935693 | 54.170426064307 | 139 | 0.801296176695423 | 8.68131105905825 | 0.603035544876193 | weekly | |||||||||
9408 | 9408 | United States | Virginia | VA | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 8535519 | 1519 | 107 | 1293.48370927383 | 225.51629072617 | 1412 | 1.2535851657058 | 2.64209230541424 | 0.174347994574108 | weekly | |||||||||
9560 | 9560 | United States | Washington | WA | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 7614893 | 1240 | 85 | 1022.2456140359 | 217.754385964098 | 1155 | 1.11623367524665 | 2.85958562995038 | 0.213015720463096 | weekly | |||||||||
9712 | 9712 | United States | West Virginia | WV | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 1792147 | 482 | 34 | 406.050125314291 | 75.9498746857091 | 448 | 1.89716580168926 | 4.23792661459741 | 0.187045563960662 | weekly | |||||||||
9864 | 9864 | United States | Wisconsin | WI | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 5822434 | 1051 | 56 | 993.493734336689 | 57.5062656633114 | 995 | 0.961797076617786 | 0.98766711075319 | 0.0578828669731932 | weekly | |||||||||
10016 | 10016 | United States | Wyoming | WY | 2022-08-21 | 2022-08-27 | 7 | 2022 | 34 | 578759 | 103 | 6 | 94.5563909782929 | 8.4436090217071 | 97 | 1.03670094115167 | 1.45891623658675 | 0.0892970737815648 | 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);