economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where "end_date" is on date 2022-09-17 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date)
country 2
cadence 1
- weekly 52
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2419 | 2419 | United States | Alabama | AL | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 4903185 | 1120 | 83 | 977.383458626686 | 142.616541373314 | 1037 | 1.69277724581063 | 2.90865103750549 | 0.145916671818554 | weekly | |||||||||
2571 | 2571 | United States | Alaska | AK | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 731545 | 97 | 0 | 89.8170426114111 | 7.1829573885889 | 97 | 0.0 | 0.981888658741281 | 0.0799732119845629 | weekly | |||||||||
2723 | 2723 | United States | Arizona | AZ | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 7278717 | 1233 | 0 | 1152.06516291989 | 80.9348370801088 | 1233 | 0.0 | 1.11193823142332 | 0.0702519611607564 | weekly | |||||||||
2875 | 2875 | United States | Arkansas | AR | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 3017825 | 713 | 30 | 629.243107771276 | 83.7568922287243 | 683 | 0.994093428214028 | 2.77540587107351 | 0.133107365331952 | weekly | |||||||||
3027 | 3027 | United States | California | CA | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 39512223 | 5554 | 192 | 4735.42857142886 | 818.571428571138 | 5362 | 0.485925583078431 | 2.07169165999883 | 0.172861107759069 | weekly | |||||||||
3179 | 3179 | United States | Colorado | CO | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 5758736 | 863 | 29 | 789.621553885739 | 73.378446114261 | 834 | 0.503582730654783 | 1.27421097466981 | 0.0929286260654418 | weekly | |||||||||
3331 | 3331 | United States | Connecticut | CT | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 3565287 | 601 | 0 | 573.526315789937 | 27.4736842100634 | 601 | 0.0 | 0.770588292332803 | 0.0479030925934463 | weekly | |||||||||
3483 | 3483 | United States | Delaware | DE | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 973764 | 214 | 6 | 170.421052636293 | 43.5789473637071 | 208 | 0.616165723933109 | 4.47530894176691 | 0.255713403300659 | weekly | |||||||||
3635 | 3635 | United States | District of Columbia | DC | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 705749 | 128 | 0 | 109.709273183458 | 18.2907268165421 | 128 | 0.0 | 2.59167590978409 | 0.166719970753575 | weekly | |||||||||
3787 | 3787 | United States | Florida | FL | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 21477737 | 4455 | 309 | 3954.8145363418 | 500.185463658202 | 4146 | 1.43869905847157 | 2.32885551982596 | 0.126475074636717 | weekly | |||||||||
3939 | 3939 | United States | Georgia | GA | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 10617423 | 1876 | 150 | 1660.39348370987 | 215.606516290126 | 1726 | 1.41277219528694 | 2.03068594224913 | 0.12985266348335 | weekly | |||||||||
4091 | 4091 | United States | Hawaii | HI | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 1415872 | 261 | 10 | 248.729323309149 | 12.2706766908507 | 251 | 0.706278533652759 | 0.866651554014111 | 0.0493334542449555 | weekly | |||||||||
4243 | 4243 | United States | Idaho | ID | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 1787065 | 297 | 25 | 269.39598997566 | 27.6040100243405 | 272 | 1.39894184039193 | 1.54465618342592 | 0.102466298874139 | weekly | |||||||||
4395 | 4395 | United States | Illinois | IL | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 12671821 | 2070 | 0 | 1935.07017543908 | 134.929824560916 | 2070 | 0.0 | 1.06480216664137 | 0.069728646678304 | weekly | |||||||||
4547 | 4547 | United States | Indiana | IN | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 6732219 | 1377 | 56 | 1223.25563909966 | 153.744360900345 | 1321 | 0.831820830546362 | 2.28371003528472 | 0.125684571553256 | weekly | |||||||||
4699 | 4699 | United States | Iowa | IA | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 3155070 | 597 | 26 | 560.796992481733 | 36.2030075182672 | 571 | 0.824070464363707 | 1.14745496988235 | 0.0645563510568337 | weekly | |||||||||
4851 | 4851 | United States | Kansas | KS | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 2913314 | 563 | 45 | 491.786967419274 | 71.2130325807261 | 518 | 1.54463267605208 | 2.44439949077669 | 0.144804635540521 | weekly | |||||||||
5003 | 5003 | United States | Kentucky | KY | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 4467673 | 978 | 65 | 918.213032583145 | 59.7869674168547 | 913 | 1.45489609467837 | 1.33821269857608 | 0.0651123054185587 | weekly | |||||||||
5155 | 5155 | United States | Louisiana | LA | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 4648794 | 948 | 54 | 885.23308270763 | 62.76691729237 | 894 | 1.16159158697933 | 1.35017635310082 | 0.0709043962753708 | weekly | |||||||||
5307 | 5307 | United States | Maine | ME | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 1344212 | 325 | 15 | 290.157894737536 | 34.8421052624641 | 310 | 1.11589540935507 | 2.59200968764333 | 0.120079811352301 | weekly | |||||||||
5459 | 5459 | United States | Maryland | MD | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 6045680 | 971 | 54 | 915.548872181357 | 55.4511278186433 | 917 | 0.893199772399465 | 0.917202495313071 | 0.0605659943488623 | weekly | |||||||||
5611 | 5611 | United States | Massachusetts | MA | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 6949503 | 1119 | 0 | 1054.58395990052 | 64.4160400994813 | 1119 | 0.0 | 0.926915782315387 | 0.0610819456286418 | weekly | |||||||||
5763 | 5763 | United States | Michigan | MI | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 9986857 | 1954 | 196 | 1797.39598997571 | 156.604010024294 | 1758 | 1.96257941812925 | 1.56810105546013 | 0.0871282738459933 | weekly | |||||||||
5915 | 5915 | United States | Minnesota | MN | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 5639632 | 947 | 0 | 864.546365915582 | 82.4536340844179 | 947 | 0.0 | 1.46203926221459 | 0.0953721365737243 | weekly | |||||||||
6067 | 6067 | United States | Mississippi | MS | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 2976149 | 624 | 32 | 593.914786968126 | 30.0852130318741 | 592 | 1.07521498419602 | 1.01087724545626 | 0.0506557736766515 | weekly | |||||||||
6219 | 6219 | United States | Missouri | MO | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 6137428 | 1335 | 0 | 1183.78696741936 | 151.213032580635 | 1335 | 0.0 | 2.4637850347187 | 0.127736693123322 | weekly | |||||||||
6371 | 6371 | United States | Montana | MT | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 1068778 | 271 | 3 | 189.513784462009 | 81.4862155379913 | 268 | 0.280694400520969 | 7.62424147371964 | 0.429975137530572 | weekly | |||||||||
6523 | 6523 | United States | Nebraska | NE | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 1934408 | 338 | 2 | 309.854636592602 | 28.1453634073981 | 336 | 0.103390804835381 | 1.45498588753759 | 0.0908340882579843 | weekly | |||||||||
6675 | 6675 | United States | Nevada | NV | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 3080156 | 534 | 0 | 493.709273183833 | 40.2907268161666 | 534 | 0.0 | 1.30807422793412 | 0.0816082034601855 | weekly | |||||||||
6827 | 6827 | United States | New Hampshire | NH | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 1359711 | 262 | 11 | 235.644110276538 | 26.3558897234622 | 251 | 0.808995440942965 | 1.93834496620695 | 0.111846163659819 | weekly | |||||||||
6979 | 6979 | United States | New Jersey | NJ | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 8882190 | 1396 | 45 | 1307.56892230679 | 88.4310776932061 | 1351 | 0.506631810398111 | 0.995599933048112 | 0.0676301464378621 | weekly | |||||||||
7131 | 7131 | United States | New Mexico | NM | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 2096829 | 388 | 32 | 355.949874687612 | 32.0501253123879 | 356 | 1.52611395588291 | 1.52850448521973 | 0.0900411198079947 | weekly | |||||||||
7283 | 7283 | United States | New York | NY | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 19453561 | 3044 | 194 | 2741.4661654144 | 302.533834585598 | 2850 | 0.997246725162555 | 1.5551591535637 | 0.110354757757832 | weekly | |||||||||
7435 | 7435 | United States | North Carolina | NC | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 10488084 | 2008 | 49 | 1766.40852130399 | 241.591478696012 | 1959 | 0.467196868369857 | 2.30348535248203 | 0.136769878418422 | weekly | |||||||||
7587 | 7587 | United States | North Dakota | ND | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 762062 | 143 | 0 | 154.568922306726 | -11.5689223067257 | 143 | 0.0 | -1.51810775327017 | -0.0748463671356161 | weekly | |||||||||
7739 | 7739 | United States | Ohio | OH | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 11689100 | 2445 | 99 | 2252.30075188218 | 192.699248117822 | 2346 | 0.84694287840809 | 1.64853793806043 | 0.085556623802034 | weekly | |||||||||
7891 | 7891 | United States | Oklahoma | OK | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 3956971 | 880 | 39 | 728.86466165488 | 151.13533834512 | 841 | 0.985602371106586 | 3.81947045720376 | 0.207357204013663 | weekly | |||||||||
8043 | 8043 | United States | Oregon | OR | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 4217737 | 759 | 21 | 655.443609023556 | 103.556390976444 | 738 | 0.497897332147547 | 2.45525956161904 | 0.157994356113589 | weekly | |||||||||
8195 | 8195 | United States | Pennsylvania | PA | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 12801989 | 2601 | 139 | 2356.57142857261 | 244.428571427392 | 2462 | 1.0857687817104 | 1.90930152671895 | 0.103722114451436 | weekly | |||||||||
8347 | 8347 | United States | Rhode Island | RI | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 1059361 | 204 | 9 | 191.045112782898 | 12.9548872171021 | 195 | 0.84956874946312 | 1.22289637027435 | 0.0678106182795886 | weekly | |||||||||
8499 | 8499 | United States | South Carolina | SC | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 5148714 | 1047 | 0 | 961.275689224074 | 85.7243107759264 | 1047 | 0.0 | 1.66496548023305 | 0.0891776539622278 | weekly | |||||||||
8651 | 8651 | United States | South Dakota | SD | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 884659 | 155 | 12 | 162.218045113518 | -7.21804511351817 | 143 | 1.35645486000821 | -0.815912697832518 | -0.0444959443844061 | weekly | |||||||||
8803 | 8803 | United States | Tennessee | TN | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 6833174 | 1612 | 93 | 1463.72180451225 | 148.278195487754 | 1519 | 1.36100734446393 | 2.16997540949132 | 0.101302170283079 | weekly | |||||||||
8955 | 8955 | United States | Texas | TX | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 28995881 | 4323 | 143 | 3852.90225563971 | 470.097744360286 | 4180 | 0.493173495918265 | 1.62125697908708 | 0.122011334098127 | weekly | |||||||||
9107 | 9107 | United States | Utah | UT | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 3205958 | 419 | 12 | 367.54887218134 | 51.4511278186599 | 407 | 0.374303094426065 | 1.60485969618629 | 0.139984452987997 | weekly | |||||||||
9259 | 9259 | United States | Vermont | VT | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 623989 | 138 | 0 | 95.8295739357569 | 42.1704260642431 | 138 | 0.0 | 6.75820023497901 | 0.440056491250955 | weekly | |||||||||
9411 | 9411 | United States | Virginia | VA | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 8535519 | 1470 | 92 | 1300.81704260722 | 169.182957392778 | 1378 | 1.07784892752274 | 1.98210509979273 | 0.130058995117165 | weekly | |||||||||
9563 | 9563 | United States | Washington | WA | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 7614893 | 1245 | 77 | 1025.24561403597 | 219.754385964034 | 1168 | 1.01117638816461 | 2.88584995172006 | 0.214343161244019 | weekly | |||||||||
9715 | 9715 | United States | West Virginia | WV | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 1792147 | 459 | 42 | 429.716791981022 | 29.2832080189779 | 417 | 2.34355775502791 | 1.63397355345169 | 0.068145365890824 | weekly | |||||||||
9867 | 9867 | United States | Wisconsin | WI | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 5822434 | 1065 | 53 | 1048.16040100341 | 16.8395989965882 | 1012 | 0.910272233227547 | 0.289219233684541 | 0.016065860702682 | weekly | |||||||||
10019 | 10019 | United States | Wyoming | WY | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 578759 | 114 | 4 | 102.556390978356 | 11.4436090216435 | 110 | 0.691133960767781 | 1.9772667071516 | 0.111583577702715 | weekly | |||||||||
17118 | 17118 | South Africa | South Africa | 0 | 2022-09-11 | 2022-09-17 | 7 | 2022 | 37 | 59893884 | 10427 | 17 | 10144.5765690375 | 282.423430962464 | 10410 | 0.0283835324488223 | 0.471539683354755 | 0.0278398441808299 | 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);