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-04-24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2399 | 2399 | United States | Alabama | AL | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 4903185 | 1051 | 26 | 1020.38345862954 | 30.6165413704585 | 1025 | 0.530267570976824 | 0.624421500931712 | 0.0300049369788677 | weekly | |||||||||
2551 | 2551 | United States | Alaska | AK | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 731545 | 92 | 1 | 88.8170426113512 | 3.18295738864879 | 91 | 0.136696990615752 | 0.435100696286461 | 0.0358372368079951 | weekly | |||||||||
2703 | 2703 | United States | Arizona | AZ | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 7278717 | 1355 | 0 | 1263.06516291984 | 91.9348370801615 | 1355 | 0.0 | 1.26306376632257 | 0.0727870895177214 | weekly | |||||||||
2855 | 2855 | United States | Arkansas | AR | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 3017825 | 616 | 16 | 604.909774437883 | 11.0902255621171 | 600 | 0.530183161714148 | 0.367490678290395 | 0.0183336855028053 | weekly | |||||||||
3007 | 3007 | United States | California | CA | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 39512223 | 5498 | 366 | 5156.76190476213 | 341.238095237865 | 5132 | 0.92629564274326 | 0.863626668734547 | 0.0661729398293027 | weekly | |||||||||
3159 | 3159 | United States | Colorado | CO | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 5758736 | 831 | 322 | 791.621553885687 | 39.3784461143133 | 509 | 5.59150480244276 | 0.683803635282349 | 0.0497440297336822 | weekly | |||||||||
3311 | 3311 | United States | Connecticut | CT | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 3565287 | 615 | 16 | 627.192982456542 | -12.1929824565419 | 599 | 0.448771725810573 | -0.341991611237522 | -0.0194405594411873 | weekly | |||||||||
3463 | 3463 | United States | Delaware | DE | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 973764 | 209 | 11 | 168.754385969566 | 40.245614030434 | 198 | 1.12963716054403 | 4.13299465069914 | 0.238486329106089 | weekly | |||||||||
3615 | 3615 | United States | District of Columbia | DC | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 705749 | 113 | 5 | 124.04260651673 | -11.0426065167299 | 108 | 0.7084671745904 | -1.56466484780424 | -0.0890226900806101 | weekly | |||||||||
3767 | 3767 | United States | Florida | FL | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 21477737 | 4358 | 142 | 4113.81453634175 | 244.185463658247 | 4216 | 0.661149729135802 | 1.13692361377852 | 0.0593574312845397 | weekly | |||||||||
3919 | 3919 | United States | Georgia | GA | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 10617423 | 1825 | 147 | 1741.72681704316 | 83.2731829568368 | 1678 | 1.3845167513812 | 0.784306916629739 | 0.0478107026555434 | weekly | |||||||||
4071 | 4071 | United States | Hawaii | HI | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 1415872 | 224 | 11 | 228.395989975758 | -4.39598997575814 | 213 | 0.776906387018036 | -0.310479335403069 | -0.0192472292364885 | weekly | |||||||||
4223 | 4223 | United States | Idaho | ID | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 1787065 | 302 | 5 | 272.062656642267 | 29.9373433577329 | 297 | 0.279788368078385 | 1.67522408853247 | 0.110038414412373 | weekly | |||||||||
4375 | 4375 | United States | Illinois | IL | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 12671821 | 2054 | 39 | 1960.73684210568 | 93.2631578943156 | 2015 | 0.307769498953623 | 0.735988599383747 | 0.0475653621085417 | weekly | |||||||||
4527 | 4527 | United States | Indiana | IN | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 6732219 | 1296 | 214 | 1259.2556390996 | 36.7443609004031 | 1082 | 3.17874388815931 | 0.545798657179796 | 0.029179429306885 | weekly | |||||||||
4679 | 4679 | United States | Iowa | IA | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 3155070 | 570 | 19 | 590.46365914834 | -20.46365914834 | 551 | 0.602205339342709 | -0.648596042190505 | -0.0346569324484014 | weekly | |||||||||
4831 | 4831 | United States | Kansas | KS | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 2913314 | 464 | 38 | 495.786967419215 | -31.7869674192151 | 426 | 1.30435648199954 | -1.09109307885161 | -0.0641141649702491 | weekly | |||||||||
4983 | 4983 | United States | Kentucky | KY | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 4467673 | 1026 | 116 | 957.54636591642 | 68.4536340835797 | 910 | 2.59642995357986 | 1.5321988445345 | 0.0714885842818338 | weekly | |||||||||
5135 | 5135 | United States | Louisiana | LA | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 4648794 | 907 | 25 | 904.566416040902 | 2.43358395909797 | 882 | 0.537773882860802 | 0.0523487157980752 | 0.00269033198219892 | weekly | |||||||||
5287 | 5287 | United States | Maine | ME | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 1344212 | 326 | 6 | 311.491228070811 | 14.5087719291894 | 320 | 0.446358163742029 | 1.07935146607748 | 0.0465784286095248 | weekly | |||||||||
5439 | 5439 | United States | Maryland | MD | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 6045680 | 939 | 37 | 950.215538847963 | -11.215538847963 | 902 | 0.612007251458893 | -0.185513273080332 | -0.011803152431669 | weekly | |||||||||
5591 | 5591 | United States | Massachusetts | MA | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 6949503 | 1158 | 41 | 1088.25062656712 | 69.7493734328771 | 1117 | 0.589970246793188 | 1.00365987946011 | 0.0640931158044915 | weekly | |||||||||
5743 | 5743 | United States | Michigan | MI | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 9986857 | 1948 | 67 | 1918.06265664232 | 29.9373433576811 | 1881 | 0.670881739870712 | 0.29976741789415 | 0.0156081154356491 | weekly | |||||||||
5895 | 5895 | United States | Minnesota | MN | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 5639632 | 917 | 16 | 868.213032582193 | 48.7869674178067 | 901 | 0.283706454605549 | 0.865073597316399 | 0.0561923924047847 | weekly | |||||||||
6047 | 6047 | United States | Mississippi | MS | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 2976149 | 563 | 12 | 596.914786968067 | -33.914786968067 | 551 | 0.403205619073507 | -1.1395527229338 | -0.0568167981569559 | weekly | |||||||||
6199 | 6199 | United States | Missouri | MO | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 6137428 | 1282 | 0 | 1226.12030075264 | 55.879699247364 | 1282 | 0.0 | 0.910474212444757 | 0.0455744018046704 | weekly | |||||||||
6351 | 6351 | United States | Montana | MT | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 1068778 | 184 | 98 | 196.847117795281 | -12.8471177952814 | 86 | 9.16935041701831 | -1.20203800932293 | -0.0652644445048073 | weekly | |||||||||
6503 | 6503 | United States | Nebraska | NE | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 1934408 | 337 | 0 | 308.854636592541 | 28.1453634074592 | 337 | 0.0 | 1.45498588754074 | 0.0911281880627559 | weekly | |||||||||
6655 | 6655 | United States | Nevada | NV | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 3080156 | 610 | 68 | 540.709273183776 | 69.2907268162244 | 542 | 2.207680390214 | 2.24958498258609 | 0.128147842570242 | weekly | |||||||||
6807 | 6807 | United States | New Hampshire | NH | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 1359711 | 256 | 4 | 248.64411027648 | 7.35588972351997 | 252 | 0.294180160342896 | 0.540989204582442 | 0.0295840095119912 | weekly | |||||||||
6959 | 6959 | United States | New Jersey | NJ | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 8882190 | 1345 | 55 | 1354.56892230673 | -9.56892230673225 | 1290 | 0.619216657153247 | -0.107731565151525 | -0.00706418267033404 | weekly | |||||||||
7111 | 7111 | United States | New Mexico | NM | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 2096829 | 398 | 57 | 384.616541354222 | 13.3834586457779 | 341 | 2.71839048391643 | 0.63827134429073 | 0.0347968878266522 | weekly | |||||||||
7263 | 7263 | United States | New York | NY | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 19453561 | 3066 | 106 | 2893.79949874767 | 172.200501252325 | 2960 | 0.544887385913561 | 0.885187556418722 | 0.0595067147281099 | weekly | |||||||||
7415 | 7415 | United States | North Carolina | NC | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 10488084 | 2052 | 42 | 1841.74185463727 | 210.258145362729 | 2010 | 0.400454458602734 | 2.00473361352492 | 0.11416265793891 | weekly | |||||||||
7567 | 7567 | United States | North Dakota | ND | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 762062 | 129 | 0 | 143.90225564 | -14.9022556399997 | 129 | 0.0 | -1.95551748282944 | -0.103558179638828 | weekly | |||||||||
7719 | 7719 | United States | Ohio | OH | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 11689100 | 2408 | 68 | 2251.63408521544 | 156.365914784556 | 2340 | 0.58173854274495 | 1.33770705002572 | 0.0694455266116629 | weekly | |||||||||
7871 | 7871 | United States | Oklahoma | OK | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 3956971 | 783 | 79 | 743.19799498815 | 39.8020050118503 | 704 | 1.99647659788257 | 1.0058705260122 | 0.0535550489644214 | weekly | |||||||||
8023 | 8023 | United States | Oregon | OR | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 4217737 | 784 | 25 | 710.77694235683 | 73.22305764317 | 759 | 0.592734919223271 | 1.73607452629621 | 0.103018335682603 | weekly | |||||||||
8175 | 8175 | United States | Pennsylvania | PA | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 12801989 | 2544 | 75 | 2479.57142857251 | 64.4285714274874 | 2469 | 0.585846464951657 | 0.503270010835718 | 0.0259837529522506 | weekly | |||||||||
8327 | 8327 | United States | Rhode Island | RI | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 1059361 | 209 | 8 | 203.711779449503 | 5.28822055049713 | 201 | 0.755172221744995 | 0.499189657774557 | 0.0259593262833777 | weekly | |||||||||
8479 | 8479 | United States | South Carolina | SC | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 5148714 | 1015 | 0 | 978.942355890694 | 36.0576441093065 | 1015 | 0.0 | 0.700323306155799 | 0.0368332659143136 | weekly | |||||||||
8631 | 8631 | United States | South Dakota | SD | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 884659 | 177 | 11 | 151.551378446791 | 25.4486215532092 | 166 | 1.24341695500752 | 2.87665886553002 | 0.167920752777212 | weekly | |||||||||
8783 | 8783 | United States | Tennessee | TN | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 6833174 | 1498 | 23 | 1526.7218045122 | -28.7218045122038 | 1475 | 0.336593214222263 | -0.420328891262008 | -0.018812729619317 | weekly | |||||||||
8935 | 8935 | United States | Texas | TX | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 28995881 | 4162 | 75 | 3957.56892230635 | 204.431077693651 | 4087 | 0.25865742792916 | 0.70503488993368 | 0.051655721405482 | weekly | |||||||||
9087 | 9087 | United States | Utah | UT | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 3205958 | 412 | 7 | 381.88220551462 | 30.1177944853804 | 405 | 0.218343471748538 | 0.939431972763847 | 0.0788667134798648 | weekly | |||||||||
9239 | 9239 | United States | Vermont | VT | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 623989 | 116 | 8 | 110.496240602362 | 5.50375939763812 | 108 | 1.28207388271268 | 0.882028272555786 | 0.0498094719570077 | weekly | |||||||||
9391 | 9391 | United States | Virginia | VA | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 8535519 | 1441 | 112 | 1346.48370927384 | 94.5162907261565 | 1329 | 1.31216391176682 | 1.10732915861539 | 0.0701949010412677 | weekly | |||||||||
9543 | 9543 | United States | Washington | WA | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 7614893 | 1250 | 46 | 1050.24561403591 | 199.754385964091 | 1204 | 0.604079400721717 | 2.62320673401571 | 0.19019778163745 | weekly | |||||||||
9695 | 9695 | United States | West Virginia | WV | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 1792147 | 460 | 33 | 426.716791980963 | 33.2832080190371 | 427 | 1.84136680752193 | 1.85716953012432 | 0.0779983554538017 | weekly | |||||||||
9847 | 9847 | United States | Wisconsin | WI | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 5822434 | 1039 | 10 | 1050.82706767003 | -11.8270676700313 | 1029 | 0.171749477967462 | -0.203129269821372 | -0.0112550085869553 | weekly | |||||||||
9999 | 9999 | United States | Wyoming | WY | 2022-04-24 | 2022-04-30 | 7 | 2022 | 17 | 578759 | 110 | 5 | 91.5563909782965 | 18.4436090217035 | 105 | 0.863917450959726 | 3.18675113850557 | 0.201445347775619 | 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);