economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
51 rows where country = "United States" and start_date = "2021-11-07" sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2375 | 2375 | United States | Alabama | AL | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 4903185 | 1177 | 148 | 1012.37092730723 | 164.629072692769 | 1029 | 3.01844617325269 | 3.35759455726776 | 0.162617345334738 | weekly | |||||||||
2527 | 2527 | United States | Alaska | AK | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 731545 | 115 | 16 | 97.6127819586814 | 17.3872180413186 | 99 | 2.18715184985203 | 2.37678038142815 | 0.178124398182591 | weekly | |||||||||
2679 | 2679 | United States | Arizona | AZ | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 7278717 | 1698 | 252 | 1201.54887219072 | 496.451127809284 | 1446 | 3.46214861767534 | 6.82058565828682 | 0.413175975858671 | weekly | |||||||||
2831 | 2831 | United States | Arkansas | AR | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 3017825 | 757 | 88 | 611.765664161931 | 145.234335838069 | 669 | 2.91600738942782 | 4.8125499602551 | 0.237401907864554 | weekly | |||||||||
2983 | 2983 | United States | California | CA | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 39512223 | 6076 | 608 | 5080.2380952385 | 995.761904761499 | 5468 | 1.53876434641503 | 2.52013637592979 | 0.196006936307727 | weekly | |||||||||
3135 | 3135 | United States | Colorado | CO | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 5758736 | 1120 | 232 | 799.466165414526 | 320.533834585474 | 888 | 4.02866184523826 | 5.56604495475177 | 0.400934834333203 | weekly | |||||||||
3287 | 3287 | United States | Connecticut | CT | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 3565287 | 685 | 19 | 591.394736842656 | 93.6052631573436 | 666 | 0.532916424400055 | 2.62546221825462 | 0.158278823475982 | weekly | |||||||||
3439 | 3439 | United States | Delaware | DE | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 973764 | 241 | 24 | 176.815789477456 | 64.1842105225438 | 217 | 2.46466289573244 | 6.59135175694971 | 0.363000446465937 | weekly | |||||||||
3591 | 3591 | United States | District of Columbia | DC | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 705749 | 143 | 1 | 126.615288220947 | 16.3847117790532 | 142 | 0.14169343491808 | 2.32160609211678 | 0.129405477089477 | weekly | |||||||||
3743 | 3743 | United States | Florida | FL | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 21477737 | 4547 | 426 | 3998.36090225657 | 548.639097743435 | 4121 | 1.98344918740741 | 2.55445486525622 | 0.137216002045688 | weekly | |||||||||
3895 | 3895 | United States | Georgia | GA | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 10617423 | 2127 | 378 | 1698.37844611577 | 428.621553884227 | 1749 | 3.56018593212308 | 4.03696409085545 | 0.252371051260391 | weekly | |||||||||
4047 | 4047 | United States | Hawaii | HI | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 1415872 | 251 | 32 | 230.796992482023 | 20.2030075179773 | 219 | 2.26009130768883 | 1.42689505251727 | 0.0875358352841227 | weekly | |||||||||
4199 | 4199 | United States | Idaho | ID | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 1787065 | 415 | 91 | 283.7969924819 | 131.2030075181 | 324 | 5.09214829902662 | 7.34181507209306 | 0.462312889120795 | weekly | |||||||||
4351 | 4351 | United States | Illinois | IL | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 12671821 | 2401 | 154 | 2038.38596491273 | 362.614035087274 | 2247 | 1.2152949445861 | 2.86157794595799 | 0.177892725582419 | weekly | |||||||||
4503 | 4503 | United States | Indiana | IN | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 6732219 | 1619 | 190 | 1246.19172932489 | 372.808270675114 | 1429 | 2.82224924649659 | 5.53767295263439 | 0.299158036361772 | weekly | |||||||||
4655 | 4655 | United States | Iowa | IA | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 3155070 | 717 | 97 | 596.097744361439 | 120.902255638561 | 620 | 3.07441673243383 | 3.83199915179573 | 0.202822870547978 | weekly | |||||||||
4807 | 4807 | United States | Kansas | KS | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 2913314 | 622 | 123 | 520.590225564597 | 101.409774435403 | 499 | 4.22199598120903 | 3.48090780586655 | 0.194797692033923 | weekly | |||||||||
4959 | 4959 | United States | Kentucky | KY | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 4467673 | 1132 | 275 | 906.576441104174 | 225.423558895826 | 857 | 6.15532963133157 | 5.0456593151698 | 0.248653669646731 | weekly | |||||||||
5111 | 5111 | United States | Louisiana | LA | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 4648794 | 991 | 70 | 926.924812030903 | 64.0751879690965 | 921 | 1.50576687201025 | 1.37831850516707 | 0.0691266294066581 | weekly | |||||||||
5263 | 5263 | United States | Maine | ME | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 1344212 | 390 | 23 | 293.535087719957 | 96.4649122800429 | 367 | 1.71103962767778 | 7.17631685180931 | 0.3286316229836 | weekly | |||||||||
5415 | 5415 | United States | Maryland | MD | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 6045680 | 1102 | 68 | 981.828320802839 | 120.171679197161 | 1034 | 1.12477008376229 | 1.98772808347715 | 0.122395816713554 | weekly | |||||||||
5567 | 5567 | United States | Massachusetts | MA | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 6949503 | 1285 | 72 | 1088.68796992553 | 196.312030074467 | 1213 | 1.0360453114417 | 2.82483553247573 | 0.180319830380687 | weekly | |||||||||
5719 | 5719 | United States | Michigan | MI | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 9986857 | 2591 | 333 | 1909.13032581531 | 681.869674184695 | 2258 | 3.3343823787604 | 6.82767034898662 | 0.357162455053192 | weekly | |||||||||
5871 | 5871 | United States | Minnesota | MN | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 5639632 | 1179 | 168 | 933.576441103498 | 245.423558896502 | 1011 | 2.97891777335826 | 4.35176548570017 | 0.262885338672866 | weekly | |||||||||
6023 | 6023 | United States | Mississippi | MS | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 2976149 | 722 | 39 | 619.936090226225 | 102.063909773775 | 683 | 1.3104182619889 | 3.42939516044978 | 0.164636180056124 | weekly | |||||||||
6175 | 6175 | United States | Missouri | MO | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 6137428 | 1495 | 118 | 1218.59022556466 | 276.409774435338 | 1377 | 1.92262947931935 | 4.50367441272366 | 0.226827500037805 | weekly | |||||||||
6327 | 6327 | United States | Montana | MT | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 1068778 | 286 | 64 | 198.135338346655 | 87.8646616533454 | 222 | 5.988147211114 | 8.22103950992118 | 0.443457802058604 | weekly | |||||||||
6479 | 6479 | United States | Nebraska | NE | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 1934408 | 422 | 47 | 328.390977444648 | 93.6090225553519 | 375 | 2.42968391363146 | 4.83915609092559 | 0.285053576330763 | weekly | |||||||||
6631 | 6631 | United States | Nevada | NV | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 3080156 | 659 | 96 | 502.448621554692 | 156.551378445308 | 563 | 3.11672525677271 | 5.08257953315701 | 0.311576889117342 | weekly | |||||||||
6783 | 6783 | United States | New Hampshire | NH | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 1359711 | 306 | 30 | 233.066416040887 | 72.9335839591128 | 276 | 2.20635120257172 | 5.36390335586848 | 0.312930473630821 | weekly | |||||||||
6935 | 6935 | United States | New Jersey | NJ | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 8882190 | 1560 | 0 | 1386.84335839694 | 173.156641603056 | 1560 | 0.0 | 1.94948139595141 | 0.12485666860258 | weekly | |||||||||
7087 | 7087 | United States | New Mexico | NM | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 2096829 | 504 | 56 | 366.629072682516 | 137.370927317484 | 448 | 2.67069942279509 | 6.5513652909934 | 0.374686399832893 | weekly | |||||||||
7239 | 7239 | United States | New York | NY | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 19453561 | 3520 | 256 | 3003.5162907276 | 516.4837092724 | 3264 | 1.31595444145162 | 2.65495715294696 | 0.171959683011169 | weekly | |||||||||
7391 | 7391 | United States | North Carolina | NC | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 10488084 | 2268 | 160 | 1868.72305764471 | 399.276942355294 | 2108 | 1.52554079467708 | 3.80695789960582 | 0.213662982709986 | weekly | |||||||||
7543 | 7543 | United States | North Dakota | ND | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 762062 | 183 | 13 | 153.010025063515 | 29.9899749364851 | 170 | 1.70589794531154 | 3.93537204800726 | 0.196000065512283 | weekly | |||||||||
7695 | 7695 | United States | Ohio | OH | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 11689100 | 3069 | 576 | 2394.39223057861 | 674.607769421394 | 2493 | 4.92766765619252 | 5.77125501040622 | 0.281744887410687 | weekly | |||||||||
7847 | 7847 | United States | Oklahoma | OK | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 3956971 | 868 | 67 | 774.065162907967 | 93.9348370920331 | 801 | 1.69321432984978 | 2.37390764531843 | 0.121352621966791 | weekly | |||||||||
7999 | 7999 | United States | Oregon | OR | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 4217737 | 881 | 168 | 734.082706767809 | 146.917293232191 | 713 | 3.98317865718038 | 3.48332039745938 | 0.200137248674707 | weekly | |||||||||
8151 | 8151 | United States | Pennsylvania | PA | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 12801989 | 3262 | 461 | 2502.09523809631 | 759.90476190369 | 2801 | 3.60100293790285 | 5.93583357948277 | 0.303707369061561 | weekly | |||||||||
8303 | 8303 | United States | Rhode Island | RI | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 1059361 | 220 | 9 | 190.867167920647 | 29.1328320793532 | 211 | 0.84956874946312 | 2.75003819088613 | 0.152634066910163 | weekly | |||||||||
8455 | 8455 | United States | South Carolina | SC | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 5148714 | 1226 | 142 | 981.873433584893 | 244.126566415107 | 1084 | 2.75797024266642 | 4.74150567336052 | 0.248633436922499 | weekly | |||||||||
8607 | 8607 | United States | South Dakota | SD | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 884659 | 200 | 24 | 164.413533835257 | 35.5864661647432 | 176 | 2.71290972001641 | 4.02261958164029 | 0.216444871262246 | weekly | |||||||||
8759 | 8759 | United States | Tennessee | TN | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 6833174 | 1805 | 159 | 1471.37468671767 | 333.62531328233 | 1646 | 2.32688352440608 | 4.88243550189604 | 0.226743953320672 | weekly | |||||||||
8911 | 8911 | United States | Texas | TX | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 28995881 | 4802 | 860 | 4055.01002506319 | 746.989974936812 | 3942 | 2.96593850692103 | 2.57619340808031 | 0.184214088330194 | weekly | |||||||||
9063 | 9063 | United States | Utah | UT | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 3205958 | 492 | 61 | 375.661654136145 | 116.338345863855 | 431 | 1.90270739666583 | 3.6288169047709 | 0.309689169982978 | weekly | |||||||||
9215 | 9215 | United States | Vermont | VT | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 623989 | 128 | 9 | 115.205513785294 | 12.7944862147064 | 119 | 1.44233311805176 | 2.0504345773253 | 0.111057932856853 | weekly | |||||||||
9367 | 9367 | United States | Virginia | VA | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 8535519 | 1740 | 196 | 1341.61278195552 | 398.387218044481 | 1544 | 2.29628684559193 | 4.66740473595666 | 0.296946498574497 | weekly | |||||||||
9519 | 9519 | United States | Washington | WA | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 7614893 | 1397 | 136 | 1112.35087719378 | 284.649122806217 | 1261 | 1.78597388039464 | 3.73805807653787 | 0.255898681470296 | weekly | |||||||||
9671 | 9671 | United States | West Virginia | WV | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 1792147 | 616 | 92 | 459.204260652579 | 156.795739347421 | 524 | 5.13350746339446 | 8.74904454530912 | 0.341450968082477 | weekly | |||||||||
9823 | 9823 | United States | Wisconsin | WI | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 5822434 | 1313 | 139 | 1079.45363408603 | 233.546365913968 | 1174 | 2.38731774374772 | 4.01114664269217 | 0.21635608843145 | weekly | |||||||||
9975 | 9975 | United States | Wyoming | WY | 2021-11-07 | 2021-11-13 | 7 | 2021 | 45 | 578759 | 142 | 55 | 91.0839599005719 | 50.9160400994281 | 87 | 9.50309196055698 | 8.79745111513223 | 0.559001169415653 | 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);