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 2021-10-24 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: end_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2373 | 2373 | United States | Alabama | AL | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 4903185 | 1121 | 154 | 983.704260639144 | 137.295739360856 | 967 | 3.14081561270888 | 2.80013377755185 | 0.139570137951472 | weekly | |||||||||
2525 | 2525 | United States | Alaska | AK | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 731545 | 169 | 20 | 93.2794486253889 | 75.7205513746111 | 149 | 2.73393981231503 | 10.3507715006747 | 0.811760280431175 | weekly | |||||||||
2677 | 2677 | United States | Arizona | AZ | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 7278717 | 1592 | 275 | 1115.8822055241 | 476.117794475896 | 1317 | 3.77813837246317 | 6.54123239680696 | 0.426673883783526 | weekly | |||||||||
2829 | 2829 | United States | Arkansas | AR | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 3017825 | 739 | 98 | 637.43233082864 | 101.56766917136 | 641 | 3.24737186549916 | 3.36559174807551 | 0.159338747439003 | weekly | |||||||||
2981 | 2981 | United States | California | CA | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 39512223 | 6100 | 395 | 4974.9047619052 | 1125.0952380948 | 5705 | 0.999690652687398 | 2.84746124786449 | 0.226154125946309 | weekly | |||||||||
3133 | 3133 | United States | Colorado | CO | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 5758736 | 1069 | 317 | 818.132832081241 | 250.867167918759 | 752 | 5.50468019370918 | 4.35628873972967 | 0.306633786203861 | weekly | |||||||||
3285 | 3285 | United States | Connecticut | CT | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 3565287 | 659 | 25 | 570.728070176029 | 88.2719298239708 | 634 | 0.70120582157902 | 2.47587164298332 | 0.154665478073902 | weekly | |||||||||
3437 | 3437 | United States | Delaware | DE | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 973764 | 240 | 44 | 165.149122810829 | 74.8508771891711 | 196 | 4.51854864217613 | 7.68675748838231 | 0.453232060305337 | weekly | |||||||||
3589 | 3589 | United States | District of Columbia | DC | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 705749 | 142 | 4 | 120.615288220986 | 21.384711779014 | 138 | 0.56677373967232 | 3.03007326670162 | 0.177296859249169 | weekly | |||||||||
3741 | 3741 | United States | Florida | FL | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 21477737 | 4587 | 564 | 3916.36090225662 | 670.639097743383 | 4023 | 2.62597498051122 | 3.12248491423181 | 0.171240371988434 | weekly | |||||||||
3893 | 3893 | United States | Georgia | GA | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 10617423 | 2058 | 546 | 1650.71177944916 | 407.288220550844 | 1512 | 5.14249079084445 | 3.83603648974751 | 0.246734908917144 | weekly | |||||||||
4045 | 4045 | United States | Hawaii | HI | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 1415872 | 244 | 13 | 202.79699248207 | 41.2030075179297 | 231 | 0.918162093748587 | 2.9100799731847 | 0.203173661569821 | weekly | |||||||||
4197 | 4197 | United States | Idaho | ID | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 1787065 | 443 | 131 | 278.796992481944 | 164.203007518056 | 312 | 7.3304552436537 | 9.18841830140797 | 0.588969795033535 | weekly | |||||||||
4349 | 4349 | United States | Illinois | IL | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 12671821 | 2336 | 173 | 2019.05263157943 | 316.947368420566 | 2163 | 1.36523393125582 | 2.50119827624274 | 0.156978259735918 | weekly | |||||||||
4501 | 4501 | United States | Indiana | IN | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 6732219 | 1631 | 213 | 1290.85839599159 | 340.141604008406 | 1418 | 3.1638899447567 | 5.05244413481507 | 0.263500322781044 | weekly | |||||||||
4653 | 4653 | United States | Iowa | IA | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 3155070 | 747 | 117 | 600.431077694814 | 146.568922305186 | 630 | 3.70831708963668 | 4.64550461020473 | 0.244106155976963 | weekly | |||||||||
4805 | 4805 | United States | Kansas | KS | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 2913314 | 600 | 204 | 499.923558897973 | 100.076441102027 | 396 | 7.00233479810278 | 3.43514091175985 | 0.200183486696716 | weekly | |||||||||
4957 | 4957 | United States | Kentucky | KY | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 4467673 | 1143 | 207 | 941.243107770884 | 201.756892229116 | 936 | 4.63328448612958 | 4.51592791659364 | 0.214351521475606 | weekly | |||||||||
5109 | 5109 | United States | Louisiana | LA | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 4648794 | 986 | 85 | 845.258145364275 | 140.741854635725 | 901 | 1.82843120172673 | 3.02749174593937 | 0.166507540220237 | weekly | |||||||||
5261 | 5261 | United States | Maine | ME | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 1344212 | 357 | 45 | 282.868421053332 | 74.1315789466677 | 312 | 3.34768622806522 | 5.5148725756553 | 0.262070890312252 | weekly | |||||||||
5413 | 5413 | United States | Maryland | MD | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 6045680 | 1075 | 94 | 990.161654136214 | 84.838345863786 | 981 | 1.55482923343611 | 1.40328872622742 | 0.0856813082079979 | weekly | |||||||||
5565 | 5565 | United States | Massachusetts | MA | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 6949503 | 1250 | 85 | 1112.68796992557 | 137.312030074432 | 1165 | 1.22310904822978 | 1.97585395782162 | 0.123405693047636 | weekly | |||||||||
5717 | 5717 | United States | Michigan | MI | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 9986857 | 2356 | 353 | 1867.13032581535 | 488.869674184649 | 2003 | 3.53464558469196 | 4.89513041174665 | 0.261829432806822 | weekly | |||||||||
5869 | 5869 | United States | Minnesota | MN | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 5639632 | 1105 | 132 | 909.243107770211 | 195.756892229789 | 973 | 2.34057825049578 | 3.47109336619462 | 0.21529653681935 | weekly | |||||||||
6021 | 6021 | United States | Mississippi | MS | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 2976149 | 688 | 85 | 595.936090226265 | 92.0639097737351 | 603 | 2.85603980177068 | 3.0933904778872 | 0.154486213007808 | weekly | |||||||||
6173 | 6173 | United States | Missouri | MO | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 6137428 | 1432 | 102 | 1235.5902255647 | 196.409774435299 | 1330 | 1.66193395669978 | 3.20019679962517 | 0.158960285029395 | weekly | |||||||||
6325 | 6325 | United States | Montana | MT | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 1068778 | 300 | 99 | 198.135338346695 | 101.864661653305 | 201 | 9.26291521719197 | 9.53094671234861 | 0.514116575585641 | weekly | |||||||||
6477 | 6477 | United States | Nebraska | NE | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 1934408 | 415 | 37 | 330.390977444687 | 84.6090225553131 | 378 | 1.91272988945455 | 4.37389746916437 | 0.25608756997451 | weekly | |||||||||
6629 | 6629 | United States | Nevada | NV | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 3080156 | 639 | 108 | 485.448621554735 | 153.551378445265 | 531 | 3.5063159138693 | 4.98518186888148 | 0.316308197463801 | weekly | |||||||||
6781 | 6781 | United States | New Hampshire | NH | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 1359711 | 296 | 9 | 236.733082707588 | 59.2669172924118 | 287 | 0.661905360771517 | 4.35878780802772 | 0.250353337246142 | weekly | |||||||||
6933 | 6933 | United States | New Jersey | NJ | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 8882190 | 1570 | 0 | 1405.51002506365 | 164.489974936351 | 1570 | 0.0 | 1.85190786209652 | 0.117032231718804 | weekly | |||||||||
7085 | 7085 | United States | New Mexico | NM | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 2096829 | 466 | 62 | 366.962406015891 | 99.0375939841089 | 404 | 2.95684578952313 | 4.72320794800667 | 0.269884850220379 | weekly | |||||||||
7237 | 7237 | United States | New York | NY | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 19453561 | 3323 | 215 | 2976.18295739431 | 346.817042605694 | 3108 | 1.10519611293788 | 1.78279463901593 | 0.116530820709134 | weekly | |||||||||
7389 | 7389 | United States | North Carolina | NC | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 10488084 | 2246 | 285 | 1845.72305764476 | 400.276942355241 | 1961 | 2.71736954051855 | 3.81649252957204 | 0.216867281739448 | weekly | |||||||||
7541 | 7541 | United States | North Dakota | ND | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 762062 | 195 | 44 | 154.676691730221 | 40.3233082697788 | 151 | 5.7738084302852 | 5.29134220965995 | 0.260694147377477 | weekly | |||||||||
7693 | 7693 | United States | Ohio | OH | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 11689100 | 3051 | 572 | 2240.72556391198 | 810.27443608802 | 2479 | 4.89344774191341 | 6.93188043637252 | 0.361612528164047 | weekly | |||||||||
7845 | 7845 | United States | Oklahoma | OK | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 3956971 | 921 | 107 | 711.065162908004 | 209.934837091996 | 814 | 2.70408855662576 | 5.30544290296786 | 0.29523994148924 | weekly | |||||||||
7997 | 7997 | United States | Oregon | OR | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 4217737 | 926 | 88 | 709.749373434515 | 216.250626565485 | 838 | 2.08642691566591 | 5.12717190677097 | 0.304685899924133 | weekly | |||||||||
8149 | 8149 | United States | Pennsylvania | PA | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 12801989 | 3245 | 449 | 2542.761904763 | 702.238095236995 | 2796 | 3.50726750351059 | 5.48538274198638 | 0.276171392186421 | weekly | |||||||||
8301 | 8301 | United States | Rhode Island | RI | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 1059361 | 213 | 6 | 192.20050125402 | 20.7994987459798 | 207 | 0.566379166308747 | 1.96340045989798 | 0.108217713326826 | weekly | |||||||||
8453 | 8453 | United States | South Carolina | SC | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 5148714 | 1140 | 244 | 987.540100251602 | 152.459899748398 | 896 | 4.73904745922963 | 2.96112582187316 | 0.154383502715034 | weekly | |||||||||
8605 | 8605 | United States | South Dakota | SD | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 884659 | 198 | 26 | 164.746867168632 | 33.2531328313681 | 172 | 2.93898553001778 | 3.75886446996731 | 0.201843794682486 | weekly | |||||||||
8757 | 8757 | United States | Tennessee | TN | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 6833174 | 1760 | 193 | 1504.04135338437 | 255.958646615626 | 1567 | 2.82445610195204 | 3.74582363357974 | 0.170180591138449 | weekly | |||||||||
8909 | 8909 | United States | Texas | TX | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 28995881 | 4879 | 874 | 3975.01002506319 | 903.989974936808 | 4005 | 3.01422122680114 | 3.11764962387868 | 0.227418288063924 | weekly | |||||||||
9061 | 9061 | United States | Utah | UT | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 3205958 | 570 | 80 | 375.994987469519 | 194.005012530481 | 490 | 2.49535396284044 | 6.05138971036054 | 0.515977656606946 | weekly | |||||||||
9213 | 9213 | United States | Vermont | VT | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 623989 | 149 | 13 | 109.205513785335 | 39.7944862146654 | 136 | 2.0833700594081 | 6.37743393147402 | 0.364399972449097 | weekly | |||||||||
9365 | 9365 | United States | Virginia | VA | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 8535519 | 1701 | 239 | 1353.94611528889 | 347.053884711107 | 1462 | 2.80006406171669 | 4.0659962763964 | 0.256327693393511 | weekly | |||||||||
9517 | 9517 | United States | Washington | WA | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 7614893 | 1396 | 177 | 1129.35087719382 | 266.649122806175 | 1219 | 2.32439247669009 | 3.50167918060274 | 0.236108306276555 | weekly | |||||||||
9669 | 9669 | United States | West Virginia | WV | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 1792147 | 531 | 163 | 437.870927319287 | 93.1290726807125 | 368 | 9.09523604927498 | 5.19650858332004 | 0.212686129336932 | weekly | |||||||||
9821 | 9821 | United States | Wisconsin | WI | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 5822434 | 1325 | 97 | 1091.78696741941 | 233.213032580592 | 1228 | 1.66596993628438 | 4.00542166009254 | 0.213606719570782 | weekly | |||||||||
9973 | 9973 | United States | Wyoming | WY | 2021-10-24 | 2021-10-30 | 7 | 2021 | 43 | 578759 | 155 | 25 | 100.083959900613 | 54.9160400993867 | 130 | 4.31958725479863 | 9.48858507589285 | 0.548699713259948 | 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);