economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where "start_date" is on date 2022-05-08 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date)
country 3
- United States 51
- Canada 1
- South Africa 1
cadence 1
- weekly 53
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2401 | 2401 | United States | Alabama | AL | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 4903185 | 1005 | 27 | 1025.05012529621 | -20.0501252962097 | 978 | 0.550662477552856 | -0.408920432253926 | -0.0195601413056905 | weekly | |||||||||
2553 | 2553 | United States | Alaska | AK | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 731545 | 93 | 0 | 88.1503759446604 | 4.8496240553396 | 93 | 0.0 | 0.662929013982681 | 0.0550153530642243 | weekly | |||||||||
2705 | 2705 | United States | Arizona | AZ | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 7278717 | 1318 | 0 | 1246.06516291981 | 71.9348370801861 | 1318 | 0.0 | 0.988290066507409 | 0.0577295949046728 | weekly | |||||||||
2857 | 2857 | United States | Arkansas | AR | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 3017825 | 677 | 11 | 611.909774437859 | 65.0902255621409 | 666 | 0.364500923678477 | 2.15685884907643 | 0.106372259900468 | weekly | |||||||||
3009 | 3009 | United States | California | CA | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 39512223 | 5387 | 158 | 4943.76190476212 | 443.238095237877 | 5229 | 0.399876261074959 | 1.12177463474499 | 0.0896560359856577 | weekly | |||||||||
3161 | 3161 | United States | Colorado | CO | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 5758736 | 869 | 11 | 798.954887218997 | 70.045112781003 | 858 | 0.191014139213883 | 1.21632790218206 | 0.0876709234795674 | weekly | |||||||||
3313 | 3313 | United States | Connecticut | CT | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 3565287 | 661 | 40 | 577.859649123186 | 83.1403508768144 | 621 | 1.12192931452643 | 2.33193992171779 | 0.143876373792438 | weekly | |||||||||
3465 | 3465 | United States | Delaware | DE | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 973764 | 201 | 3 | 166.087719302875 | 34.9122806971245 | 198 | 0.308082861966554 | 3.58529178498327 | 0.210203866027318 | weekly | |||||||||
3617 | 3617 | United States | District of Columbia | DC | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 705749 | 124 | 1 | 106.709273183374 | 17.2907268166264 | 123 | 0.14169343491808 | 2.44998247487796 | 0.162035840942458 | weekly | |||||||||
3769 | 3769 | United States | Florida | FL | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 21477737 | 4306 | 110 | 4065.48120300841 | 240.518796991593 | 4196 | 0.512158240879847 | 1.11985167241592 | 0.0591612124079217 | weekly | |||||||||
3921 | 3921 | United States | Georgia | GA | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 10617423 | 1781 | 117 | 1676.72681704314 | 104.273182956857 | 1664 | 1.10196231232381 | 0.982095023970105 | 0.0621885341708437 | weekly | |||||||||
4073 | 4073 | United States | Hawaii | HI | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 1415872 | 252 | 6 | 236.729323309067 | 15.270676690933 | 246 | 0.423767120191656 | 1.07853511411576 | 0.0645069080478724 | weekly | |||||||||
4225 | 4225 | United States | Idaho | ID | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 1787065 | 277 | 5 | 271.062656642242 | 5.93734335775815 | 272 | 0.279788368078385 | 0.332239921757639 | 0.0219039517700679 | weekly | |||||||||
4377 | 4377 | United States | Illinois | IL | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 12671821 | 2108 | 49 | 1897.40350877232 | 210.596491227679 | 2059 | 0.386684755095578 | 1.66192760478292 | 0.110991937273238 | weekly | |||||||||
4529 | 4529 | United States | Indiana | IN | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 6732219 | 1267 | 22 | 1278.25563909957 | -11.2556390995724 | 1245 | 0.326786754857499 | -0.167190626145293 | -0.00880546797939497 | weekly | |||||||||
4681 | 4681 | United States | Iowa | IA | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 3155070 | 608 | 22 | 565.796992481649 | 42.2030075183505 | 586 | 0.697290392923136 | 1.33762507704585 | 0.0745903708912332 | weekly | |||||||||
4833 | 4833 | United States | Kansas | KS | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 2913314 | 537 | 29 | 506.786967419191 | 30.2130325808088 | 508 | 0.995429946789121 | 1.03706749704319 | 0.0596168301933027 | weekly | |||||||||
4985 | 4985 | United States | Kentucky | KY | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 4467673 | 949 | 166 | 923.213032583064 | 25.7869674169365 | 783 | 3.71558079564015 | 0.577190125976912 | 0.0279317627750411 | weekly | |||||||||
5137 | 5137 | United States | Louisiana | LA | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 4648794 | 945 | 19 | 882.233082707545 | 62.7669172924552 | 926 | 0.40870815097421 | 1.35017635310266 | 0.0711455039747837 | weekly | |||||||||
5289 | 5289 | United States | Maine | ME | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 1344212 | 313 | 11 | 285.157894737454 | 27.842105262546 | 302 | 0.818323300193719 | 2.07125849661705 | 0.0976375046118936 | weekly | |||||||||
5441 | 5441 | United States | Maryland | MD | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 6045680 | 968 | 29 | 920.882205514606 | 47.1177944853936 | 939 | 0.479681359251565 | 0.779363024265154 | 0.0511659300214877 | weekly | |||||||||
5593 | 5593 | United States | Massachusetts | MA | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 6949503 | 1214 | 59 | 1061.58395990043 | 152.416040099571 | 1155 | 0.848981574653612 | 2.19319338518987 | 0.143574173929556 | weekly | |||||||||
5745 | 5745 | United States | Michigan | MI | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 9986857 | 2043 | 76 | 1858.06265664229 | 184.937343357705 | 1967 | 0.761000182539912 | 1.85180726386395 | 0.0995323503739673 | weekly | |||||||||
5897 | 5897 | United States | Minnesota | MN | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 5639632 | 920 | 34 | 895.879699248836 | 24.1203007511643 | 886 | 0.602876216036791 | 0.427692813133274 | 0.0269235933924927 | weekly | |||||||||
6049 | 6049 | United States | Mississippi | MS | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 2976149 | 635 | 8 | 601.248120301377 | 33.7518796986232 | 627 | 0.268803746049005 | 1.13407896239816 | 0.0561363579510319 | weekly | |||||||||
6201 | 6201 | United States | Missouri | MO | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 6137428 | 1345 | 0 | 1179.12030075262 | 165.879699247384 | 1345 | 0.0 | 2.70275593045465 | 0.140680895021064 | weekly | |||||||||
6353 | 6353 | United States | Montana | MT | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 1068778 | 201 | 3 | 194.513784461926 | 6.48621553807402 | 198 | 0.280694400520969 | 0.60688146070316 | 0.0333457886083319 | weekly | |||||||||
6505 | 6505 | United States | Nebraska | NE | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 1934408 | 346 | 18 | 310.187969925853 | 35.8120300741474 | 328 | 0.93051724351843 | 1.85131730607749 | 0.115452672399603 | weekly | |||||||||
6657 | 6657 | United States | Nevada | NV | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 3080156 | 547 | 46 | 506.042606517084 | 40.9573934829157 | 501 | 1.49343085220359 | 1.32971815333105 | 0.0809366503046278 | weekly | |||||||||
6809 | 6809 | United States | New Hampshire | NH | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 1359711 | 259 | 13 | 239.97744360979 | 19.0225563902101 | 246 | 0.956085521114413 | 1.39901467225095 | 0.0792681016351739 | weekly | |||||||||
6961 | 6961 | United States | New Jersey | NJ | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 8882190 | 1444 | 56 | 1342.56892230671 | 101.431077693291 | 1388 | 0.630475141828761 | 1.14196023383075 | 0.0755499967323983 | weekly | |||||||||
7113 | 7113 | United States | New Mexico | NM | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 2096829 | 439 | 51 | 388.283208020864 | 50.7167919791358 | 388 | 2.43224411718838 | 2.4187376261553 | 0.130618040985204 | weekly | |||||||||
7265 | 7265 | United States | New York | NY | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 19453561 | 3276 | 155 | 2786.79949874765 | 489.200501252349 | 3121 | 0.79676929072266 | 2.51470926712261 | 0.175542051544142 | weekly | |||||||||
7417 | 7417 | United States | North Carolina | NC | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 10488084 | 1901 | 11 | 1837.40852130392 | 63.5914786960839 | 1890 | 0.104880929634049 | 0.606321218404466 | 0.0346093304557857 | weekly | |||||||||
7569 | 7569 | United States | North Dakota | ND | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 762062 | 134 | 0 | 149.902255639978 | -15.9022556399779 | 134 | 0.0 | -2.08674040169669 | -0.106084165125377 | weekly | |||||||||
7721 | 7721 | United States | Ohio | OH | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 11689100 | 2337 | 57 | 2275.30075188209 | 61.6992481179136 | 2280 | 0.487633778477385 | 0.527835745420209 | 0.0271169637978088 | weekly | |||||||||
7873 | 7873 | United States | Oklahoma | OK | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 3956971 | 824 | 53 | 717.864661654794 | 106.135338345206 | 771 | 1.33940835047818 | 2.68223695208294 | 0.147848674011264 | weekly | |||||||||
8025 | 8025 | United States | Oregon | OR | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 4217737 | 811 | 32 | 705.443609023474 | 105.556390976526 | 779 | 0.758700696605786 | 2.50267835515885 | 0.149631224418696 | weekly | |||||||||
8177 | 8177 | United States | Pennsylvania | PA | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 12801989 | 2620 | 81 | 2358.23809523917 | 261.761904760831 | 2539 | 0.63271418214779 | 2.04469715417527 | 0.110998929789693 | weekly | |||||||||
8329 | 8329 | United States | Rhode Island | RI | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 1059361 | 218 | 8 | 194.711779449477 | 23.2882205505225 | 210 | 0.755172221744995 | 2.1983271567032 | 0.119603552575848 | weekly | |||||||||
8481 | 8481 | United States | South Carolina | SC | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 5148714 | 1061 | 22 | 964.275689224003 | 96.7243107759971 | 1039 | 0.427291164356769 | 1.87861106241281 | 0.100307735491948 | weekly | |||||||||
8633 | 8633 | United States | South Dakota | SD | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 884659 | 179 | 2 | 162.551378446768 | 16.4486215532318 | 177 | 0.226075810001368 | 1.85931772052641 | 0.101190292634881 | weekly | |||||||||
8785 | 8785 | United States | Tennessee | TN | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 6833174 | 1530 | 54 | 1450.72180451218 | 79.2781954878217 | 1476 | 0.790262329043575 | 1.16019576682551 | 0.054647414301793 | weekly | |||||||||
8937 | 8937 | United States | Texas | TX | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 28995881 | 4213 | 51 | 3883.56892230633 | 329.431077693674 | 4162 | 0.175887050991829 | 1.13613060314903 | 0.0848268910077783 | weekly | |||||||||
9089 | 9089 | United States | Utah | UT | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 3205958 | 395 | 1 | 389.548872181264 | 5.45112781873615 | 394 | 0.0311919245355055 | 0.170031167555413 | 0.0139934375582011 | weekly | |||||||||
9241 | 9241 | United States | Vermont | VT | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 623989 | 157 | 6 | 89.1629072690064 | 67.8370927309936 | 151 | 0.961555412034507 | 10.8715206086956 | 0.760821902389608 | weekly | |||||||||
9393 | 9393 | United States | Virginia | VA | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 8535519 | 1405 | 37 | 1333.81704260715 | 71.1829573928487 | 1368 | 0.433482720851538 | 0.833961676997599 | 0.0533678571490666 | weekly | |||||||||
9545 | 9545 | United States | Washington | WA | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 7614893 | 1222 | 75 | 1099.24561403589 | 122.754385964114 | 1147 | 0.984912066394104 | 1.6120303458514 | 0.11167148123832 | weekly | |||||||||
9697 | 9697 | United States | West Virginia | WV | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 1792147 | 465 | 13 | 421.050125314274 | 43.9498746857256 | 452 | 0.725386924175305 | 2.45235880124374 | 0.104381573697244 | weekly | |||||||||
9849 | 9849 | United States | Wisconsin | WI | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 5822434 | 1077 | 18 | 1083.82706767 | -6.82706767000377 | 1059 | 0.309149060341431 | -0.117254530837168 | -0.00629903780192587 | weekly | |||||||||
10001 | 10001 | United States | Wyoming | WY | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 578759 | 96 | 3 | 107.556390978275 | -11.5563909782751 | 93 | 0.518350470575835 | -1.99675356724907 | -0.10744494932532 | weekly | |||||||||
12049 | 12049 | Canada | Canada | 0 | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 38454328 | 6300 | 477 | 5727.47018030517 | 572.529819694825 | 5823 | 1.24043254637033 | 1.48885665014046 | 0.0999620777884738 | weekly | |||||||||
17100 | 17100 | South Africa | South Africa | 0 | 2022-05-08 | 2022-05-14 | 7 | 2022 | 19 | 59893884 | 11604 | 237 | 10134.9765690375 | 1469.02343096246 | 11367 | 0.395699834727699 | 2.45271024828255 | 0.1449459128944 | 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);