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-01-16 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2385 | 2385 | United States | Alabama | AL | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 4903185 | 1500 | 183 | 1134.21052630148 | 365.789473698524 | 1317 | 3.7322679034138 | 7.46024214257721 | 0.322505800480727 | weekly | |||||||||
2537 | 2537 | United States | Alaska | AK | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 731545 | 119 | 21 | 104.131578951691 | 14.8684210483092 | 98 | 2.87063680293078 | 2.03246841251176 | 0.142784938036971 | weekly | |||||||||
2689 | 2689 | United States | Arizona | AZ | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 7278717 | 1891 | 434 | 1354.97368422195 | 536.026315778049 | 1457 | 5.96258928599642 | 7.36429669924038 | 0.395599059981629 | weekly | |||||||||
2841 | 2841 | United States | Arkansas | AR | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 3017825 | 899 | 71 | 696.421052633247 | 202.578947366753 | 828 | 2.35268778010653 | 6.71274667572681 | 0.290885731556762 | weekly | |||||||||
2993 | 2993 | United States | California | CA | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 39512223 | 8223 | 791 | 5943.50000000032 | 2279.49999999968 | 7432 | 2.00191216778666 | 5.76910086784963 | 0.383528224110299 | weekly | |||||||||
3145 | 3145 | United States | Colorado | CO | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 5758736 | 1196 | 264 | 867.710526316777 | 328.289473683223 | 932 | 4.58433934113319 | 5.70072102077995 | 0.378339853818223 | weekly | |||||||||
3297 | 3297 | United States | Connecticut | CT | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 3565287 | 987 | 213 | 661.710526316275 | 325.289473683725 | 774 | 5.97427359985325 | 9.12379490581615 | 0.491588785045636 | weekly | |||||||||
3449 | 3449 | United States | Delaware | DE | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 973764 | 347 | 61 | 202.868421056854 | 144.131578943146 | 286 | 6.26435152665328 | 14.8014897801876 | 0.710468283788499 | weekly | |||||||||
3601 | 3601 | United States | District of Columbia | DC | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 705749 | 200 | 12 | 119.578947368848 | 80.4210526311516 | 188 | 1.70032121901696 | 11.3951351870356 | 0.672535211261628 | weekly | |||||||||
3753 | 3753 | United States | Florida | FL | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 21477737 | 5996 | 549 | 4501.42105263249 | 1494.57894736751 | 5447 | 2.55613522039124 | 6.9587356776345 | 0.332023805347748 | weekly | |||||||||
3905 | 3905 | United States | Georgia | GA | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 10617423 | 2808 | 366 | 1888.30263157947 | 919.697368420532 | 2442 | 3.44716415650012 | 8.66215246788728 | 0.487049773187708 | weekly | |||||||||
4057 | 4057 | United States | Hawaii | HI | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 1415872 | 324 | 20 | 253.763157895567 | 70.2368421044333 | 304 | 1.41255706730552 | 4.96067738499196 | 0.276781084720495 | weekly | |||||||||
4209 | 4209 | United States | Idaho | ID | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 1787065 | 350 | 53 | 285.513157895425 | 64.4868421045749 | 297 | 2.96575670163089 | 3.6085336629935 | 0.225862942989809 | weekly | |||||||||
4361 | 4361 | United States | Illinois | IL | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 12671821 | 3309 | 914 | 2243.39473684255 | 1065.60526315745 | 2395 | 7.21285441137466 | 8.40925122882849 | 0.474996774155414 | weekly | |||||||||
4513 | 4513 | United States | Indiana | IN | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 6732219 | 1989 | 525 | 1416.97368421225 | 572.026315787752 | 1464 | 7.79832028637215 | 8.49684651951684 | 0.403695793479583 | weekly | |||||||||
4665 | 4665 | United States | Iowa | IA | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 3155070 | 786 | 116 | 651.697368421564 | 134.302631578436 | 670 | 3.67662207177654 | 4.25672430654269 | 0.206081285710456 | weekly | |||||||||
4817 | 4817 | United States | Kansas | KS | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 2913314 | 840 | 159 | 570.35526315858 | 269.64473684142 | 681 | 5.4577021220507 | 9.25560158779383 | 0.472766281401788 | weekly | |||||||||
4969 | 4969 | United States | Kentucky | KY | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 4467673 | 1374 | 169 | 1047.39473684364 | 326.605263156363 | 1205 | 3.78272984616376 | 7.31041110565529 | 0.311826336019789 | weekly | |||||||||
5121 | 5121 | United States | Louisiana | LA | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 4648794 | 1381 | 187 | 998.078947369245 | 382.921052630755 | 1194 | 4.0225486437988 | 8.23699765209548 | 0.38365807999464 | weekly | |||||||||
5273 | 5273 | United States | Maine | ME | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 1344212 | 421 | 40 | 319.013157895391 | 101.986842104609 | 381 | 2.97572109161353 | 7.58710992794359 | 0.319694782426661 | weekly | |||||||||
5425 | 5425 | United States | Maryland | MD | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 6045680 | 1603 | 403 | 1050.60526315874 | 552.394736841258 | 1200 | 6.66591681994416 | 9.13701580039397 | 0.525787140243742 | weekly | |||||||||
5577 | 5577 | United States | Massachusetts | MA | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 6949503 | 1704 | 463 | 1248.05263157967 | 455.947368420334 | 1241 | 6.66234693329868 | 6.56086296272315 | 0.36532703580236 | weekly | |||||||||
5729 | 5729 | United States | Michigan | MI | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 9986857 | 2794 | 793 | 2065.51315789549 | 728.486842104515 | 2001 | 7.94043611518619 | 7.29445552394026 | 0.352690487262137 | weekly | |||||||||
5881 | 5881 | United States | Minnesota | MN | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 5639632 | 1195 | 180 | 983.14473684285 | 211.85526315715 | 1015 | 3.19169761431242 | 3.75654409999003 | 0.21548735930528 | weekly | |||||||||
6033 | 6033 | United States | Mississippi | MS | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 2976149 | 1004 | 97 | 660.59210526382 | 343.40789473618 | 907 | 3.25924542084418 | 11.5386660659859 | 0.51984862065379 | weekly | |||||||||
6185 | 6185 | United States | Missouri | MO | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 6137428 | 1941 | 412 | 1431.10526315866 | 509.894736841341 | 1529 | 6.712909707454 | 8.30795468136393 | 0.356294362104384 | weekly | |||||||||
6337 | 6337 | United States | Montana | MT | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 1068778 | 278 | 31 | 206.657894737642 | 71.3421052623576 | 247 | 2.90050880538334 | 6.67510982284044 | 0.345218387872035 | weekly | |||||||||
6489 | 6489 | United States | Nebraska | NE | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 1934408 | 420 | 29 | 359.539473685269 | 60.4605263147309 | 391 | 1.49916667011303 | 3.12553123822539 | 0.168161024699214 | weekly | |||||||||
6641 | 6641 | United States | Nevada | NV | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 3080156 | 892 | 109 | 592.828947369239 | 299.171052630761 | 783 | 3.53878180196068 | 9.71285391489137 | 0.504649872376129 | weekly | |||||||||
6793 | 6793 | United States | New Hampshire | NH | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 1359711 | 337 | 56 | 247.105263158689 | 89.8947368413108 | 281 | 4.11852224480055 | 6.61131202448982 | 0.363791267301259 | weekly | |||||||||
6945 | 6945 | United States | New Jersey | NJ | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 8882190 | 2451 | 667 | 1544.53947368518 | 906.460526314822 | 1784 | 7.50940927856756 | 10.2053719444734 | 0.586880776929619 | weekly | |||||||||
7097 | 7097 | United States | New Mexico | NM | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 2096829 | 573 | 114 | 420.03947368504 | 152.96052631496 | 459 | 5.43678096783286 | 7.29484980963921 | 0.364157503991291 | weekly | |||||||||
7249 | 7249 | United States | New York | NY | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 19453561 | 4729 | 1428 | 3282.40789473764 | 1446.59210526236 | 3301 | 7.34055836872231 | 7.4361301011283 | 0.440710646468262 | weekly | |||||||||
7401 | 7401 | United States | North Carolina | NC | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 10488084 | 2729 | 205 | 2008.81578947432 | 720.184210525679 | 2524 | 1.95459914318001 | 6.8666899552452 | 0.358511822885532 | weekly | |||||||||
7553 | 7553 | United States | North Dakota | ND | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 762062 | 169 | 23 | 168.789473685096 | 0.210526314903575 | 146 | 3.01812713401272 | 0.0276258775406168 | 0.00124727158813442 | weekly | |||||||||
7705 | 7705 | United States | Ohio | OH | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 11689100 | 3854 | 1065 | 2615.51315789704 | 1238.48684210296 | 2789 | 9.1110521768143 | 10.5952283931437 | 0.473515814043447 | weekly | |||||||||
7857 | 7857 | United States | Oklahoma | OK | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 3956971 | 1303 | 261 | 859.881578948066 | 443.118421051934 | 1042 | 6.59595432971331 | 11.1984247812767 | 0.515324937643183 | weekly | |||||||||
8009 | 8009 | United States | Oregon | OR | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 4217737 | 971 | 33 | 809.763157895658 | 161.236842104342 | 938 | 0.782410093374717 | 3.82282826322129 | 0.199116050825713 | weekly | |||||||||
8161 | 8161 | United States | Pennsylvania | PA | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 12801989 | 4054 | 876 | 2841.0000000011 | 1212.9999999989 | 3178 | 6.84268671063536 | 9.47509015980952 | 0.426962337204656 | weekly | |||||||||
8313 | 8313 | United States | Rhode Island | RI | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 1059361 | 299 | 65 | 211.039473685081 | 87.9605263149189 | 234 | 6.13577430167809 | 8.30316826038706 | 0.416796558383083 | weekly | |||||||||
8465 | 8465 | United States | South Carolina | SC | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 5148714 | 1535 | 194 | 1099.15789473779 | 435.842105262208 | 1341 | 3.7679311766006 | 8.46506730150885 | 0.396523654471117 | weekly | |||||||||
8617 | 8617 | United States | South Dakota | SD | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 884659 | 215 | 39 | 169.065789474363 | 45.9342105256368 | 176 | 4.40847829502667 | 5.19230692567834 | 0.271694295270789 | weekly | |||||||||
8769 | 8769 | United States | Tennessee | TN | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 6833174 | 2151 | 599 | 1649.38157894827 | 501.618421051734 | 1552 | 8.76605805735373 | 7.34092855021304 | 0.304125150574067 | weekly | |||||||||
8921 | 8921 | United States | Texas | TX | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 28995881 | 6740 | 1423 | 4506.03947368475 | 2233.96052631525 | 5317 | 4.9075935992426 | 7.70440645109299 | 0.495770296590069 | weekly | |||||||||
9073 | 9073 | United States | Utah | UT | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 3205958 | 549 | 79 | 408.605263158718 | 140.394736841282 | 470 | 2.46416203830493 | 4.37918203673541 | 0.343595028013007 | weekly | |||||||||
9225 | 9225 | United States | Vermont | VT | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 623989 | 144 | 17 | 113.184210527168 | 30.8157894728318 | 127 | 2.72440700076444 | 4.93851485728623 | 0.272262264580048 | weekly | |||||||||
9377 | 9377 | United States | Virginia | VA | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 8535519 | 2166 | 49 | 1506.63157894801 | 659.368421051988 | 2117 | 0.574071711397983 | 7.72499505949185 | 0.437644099768826 | weekly | |||||||||
9529 | 9529 | United States | Washington | WA | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 7614893 | 1615 | 209 | 1266.13157894818 | 348.868421051817 | 1406 | 2.74462162501824 | 4.58139623303725 | 0.275538835656902 | weekly | |||||||||
9681 | 9681 | United States | West Virginia | WV | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 1792147 | 639 | 93 | 521.460526316777 | 117.539473683223 | 546 | 5.1893064575618 | 6.55858440648135 | 0.225404355174184 | weekly | |||||||||
9833 | 9833 | United States | Wisconsin | WI | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 5822434 | 1504 | 378 | 1187.47368421136 | 316.526315788638 | 1126 | 6.49213026717005 | 5.43632294996625 | 0.266554383475751 | weekly | |||||||||
9985 | 9985 | United States | Wyoming | WY | 2022-01-16 | 2022-01-22 | 7 | 2022 | 3 | 578759 | 125 | 13 | 102.736842106107 | 22.2631578938927 | 112 | 2.24618537249529 | 3.84670612360114 | 0.216700819662134 | 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);