economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where "start_date" is on date 2022-08-28 sorted by country
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: end_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17116 | 17116 | South Africa | South Africa | 0 | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 59893884 | 10800 | 24 | 10385.9765690375 | 414.023430962463 | 10776 | 0.0400708693395139 | 0.691261616899754 | 0.0398636977669273 | weekly | |||||||||
2417 | 2417 | United States | Alabama | AL | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 4903185 | 1091 | 112 | 972.050125298636 | 118.949874701364 | 979 | 2.28422953651555 | 2.42597158176499 | 0.122370103768897 | weekly | |||||||||
2569 | 2569 | United States | Alaska | AK | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 731545 | 113 | 0 | 89.8170426113152 | 23.1829573886848 | 113 | 0.0 | 3.16904050860642 | 0.258113123241092 | weekly | |||||||||
2721 | 2721 | United States | Arizona | AZ | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 7278717 | 1349 | 0 | 1187.0651629198 | 161.9348370802 | 1349 | 0.0 | 2.22477171567737 | 0.136416131260977 | weekly | |||||||||
2873 | 2873 | United States | Arkansas | AR | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 3017825 | 694 | 34 | 572.243107771182 | 121.756892228818 | 660 | 1.12663921864257 | 4.03459088014772 | 0.21277126902069 | weekly | |||||||||
3025 | 3025 | United States | California | CA | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 39512223 | 5560 | 120 | 4825.42857142878 | 734.571428571222 | 5440 | 0.303703489424019 | 1.85909921740223 | 0.152229261649545 | weekly | |||||||||
3177 | 3177 | United States | Colorado | CO | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 5758736 | 841 | 23 | 759.621553885647 | 81.3784461143526 | 818 | 0.399393200174483 | 1.41313034864513 | 0.10713024886943 | weekly | |||||||||
3329 | 3329 | United States | Connecticut | CT | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 3565287 | 573 | 0 | 562.526315789843 | 10.4736842101568 | 573 | 0.0 | 0.293768333661687 | 0.0186190119753786 | weekly | |||||||||
3481 | 3481 | United States | Delaware | DE | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 973764 | 193 | 28 | 173.087719302867 | 19.9122806971335 | 165 | 2.87544004502118 | 2.04487747515142 | 0.115041556832182 | weekly | |||||||||
3633 | 3633 | United States | District of Columbia | DC | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 705749 | 134 | 1 | 106.709273183363 | 27.2907268166367 | 133 | 0.14169343491808 | 3.86691682406021 | 0.255748408760519 | weekly | |||||||||
3785 | 3785 | United States | Florida | FL | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 21477737 | 4401 | 224 | 3802.48120300837 | 598.518796991626 | 4177 | 1.04294041779169 | 2.78669394727958 | 0.157402171118716 | weekly | |||||||||
3937 | 3937 | United States | Georgia | GA | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 10617423 | 1789 | 140 | 1638.06015037645 | 150.939849623546 | 1649 | 1.31858738226781 | 1.42162415139292 | 0.0921454865920877 | weekly | |||||||||
4089 | 4089 | United States | Hawaii | HI | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 1415872 | 276 | 12 | 228.729323309056 | 47.2706766909442 | 264 | 0.847534240383311 | 3.33862642180538 | 0.206666447515663 | weekly | |||||||||
4241 | 4241 | United States | Idaho | ID | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 1787065 | 314 | 11 | 269.062656642231 | 44.9373433577694 | 303 | 0.615534409772448 | 2.51458919276968 | 0.167014419312458 | weekly | |||||||||
4393 | 4393 | United States | Illinois | IL | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 12671821 | 2100 | 86 | 1844.07017543899 | 255.929824561013 | 2014 | 0.67867120282081 | 2.01967676595979 | 0.138785295684362 | weekly | |||||||||
4545 | 4545 | United States | Indiana | IN | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 6732219 | 1400 | 72 | 1219.58897243289 | 180.411027567106 | 1328 | 1.06948392498818 | 2.67981519268915 | 0.147927729460536 | weekly | |||||||||
4697 | 4697 | United States | Iowa | IA | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 3155070 | 601 | 33 | 546.130325814971 | 54.8696741850291 | 568 | 1.0459355893847 | 1.7390953032747 | 0.100469927399012 | weekly | |||||||||
4849 | 4849 | United States | Kansas | KS | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 2913314 | 551 | 61 | 467.120300752513 | 83.8796992474869 | 490 | 2.09383540531505 | 2.87918498477977 | 0.179567659792049 | weekly | |||||||||
5001 | 5001 | United States | Kentucky | KY | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 4467673 | 982 | 76 | 890.213032583051 | 91.7869674169486 | 906 | 1.70110927993163 | 2.05446923749676 | 0.103106744180793 | weekly | |||||||||
5153 | 5153 | United States | Louisiana | LA | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 4648794 | 903 | 34 | 831.566416040869 | 71.4335839591312 | 869 | 0.731372480690691 | 1.5366046324946 | 0.0859024397584864 | weekly | |||||||||
5305 | 5305 | United States | Maine | ME | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 1344212 | 331 | 5 | 279.491228070776 | 51.5087719292245 | 326 | 0.371965136451691 | 3.8318934758226 | 0.184294771198261 | weekly | |||||||||
5457 | 5457 | United States | Maryland | MD | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 6045680 | 979 | 47 | 908.215538847929 | 70.7844611520711 | 932 | 0.777414616718053 | 1.17082712204535 | 0.0779379542898608 | weekly | |||||||||
5609 | 5609 | United States | Massachusetts | MA | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 6949503 | 1140 | 0 | 1030.91729323376 | 109.082706766241 | 1140 | 0.0 | 1.56964759589629 | 0.105811307543472 | weekly | |||||||||
5761 | 5761 | United States | Michigan | MI | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 9986857 | 2027 | 129 | 1795.39598997562 | 231.604010024385 | 1898 | 1.29169767825854 | 2.31908807770438 | 0.128998845556924 | weekly | |||||||||
5913 | 5913 | United States | Minnesota | MN | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 5639632 | 918 | 0 | 866.213032582157 | 51.7869674178428 | 918 | 0.0 | 0.918268557555578 | 0.0597854863294625 | weekly | |||||||||
6065 | 6065 | United States | Mississippi | MS | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 2976149 | 720 | 28 | 555.248120301366 | 164.751879698634 | 692 | 0.940813111171517 | 5.53574030395098 | 0.296717582059014 | weekly | |||||||||
6217 | 6217 | United States | Missouri | MO | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 6137428 | 1238 | 0 | 1150.78696741927 | 87.2130325807291 | 1238 | 0.0 | 1.42100294424194 | 0.0757855581005675 | weekly | |||||||||
6369 | 6369 | United States | Montana | MT | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 1068778 | 226 | -2 | 184.847117795248 | 41.1528822047522 | 228 | -0.187129600347313 | 3.85046120005766 | 0.222631992836029 | weekly | |||||||||
6521 | 6521 | United States | Nebraska | NE | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 1934408 | 359 | 0 | 297.521303259175 | 61.4786967408251 | 359 | 0.0 | 3.17816596813211 | 0.206636284754608 | weekly | |||||||||
6673 | 6673 | United States | Nevada | NV | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 3080156 | 562 | 25 | 511.042606517072 | 50.9573934829281 | 537 | 0.81164720228456 | 1.65437703424528 | 0.0997126126727865 | weekly | |||||||||
6825 | 6825 | United States | New Hampshire | NH | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 1359711 | 267 | 5 | 243.310776943112 | 23.6892230568877 | 262 | 0.367725200428621 | 1.74222485931847 | 0.0973619966797705 | weekly | |||||||||
6977 | 6977 | United States | New Jersey | NJ | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 8882190 | 1406 | 54 | 1356.90225564003 | 49.0977443599666 | 1352 | 0.607958172477734 | 0.552766202478967 | 0.0361837001566541 | weekly | |||||||||
7129 | 7129 | United States | New Mexico | NM | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 2096829 | 390 | 70 | 366.283208020852 | 23.7167919791484 | 320 | 3.33837427849386 | 1.13107897587969 | 0.0647498751233997 | weekly | |||||||||
7281 | 7281 | United States | New York | NY | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 19453561 | 3026 | 181 | 2750.46616541431 | 275.533834585693 | 2845 | 0.93042091368259 | 1.41636708356734 | 0.100177140170052 | weekly | |||||||||
7433 | 7433 | United States | North Carolina | NC | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 10488084 | 2054 | 492 | 1813.07518797057 | 240.924812029433 | 1562 | 4.69103794363203 | 2.29712893250506 | 0.132881864816157 | weekly | |||||||||
7585 | 7585 | United States | North Dakota | ND | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 762062 | 154 | 0 | 126.235588973299 | 27.7644110267011 | 154 | 0.0 | 3.64332705563341 | 0.219941232520203 | weekly | |||||||||
7737 | 7737 | United States | Ohio | OH | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 11689100 | 2485 | 84 | 2193.30075188209 | 291.699248117915 | 2401 | 0.718618199861409 | 2.49548081646932 | 0.132995553786961 | weekly | |||||||||
7889 | 7889 | United States | Oklahoma | OK | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 3956971 | 821 | 76 | 733.531328321451 | 87.4686716785491 | 745 | 1.92066103087437 | 2.2104956462544 | 0.119243266512836 | weekly | |||||||||
8041 | 8041 | United States | Oregon | OR | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 4217737 | 763 | 44 | 660.443609023462 | 102.556390976538 | 719 | 1.04321345783296 | 2.43155016485234 | 0.155284099316487 | weekly | |||||||||
8193 | 8193 | United States | Pennsylvania | PA | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 12801989 | 2519 | 120 | 2318.23809523917 | 200.761904760835 | 2399 | 0.937354343922651 | 1.56820869601462 | 0.0866010722423758 | weekly | |||||||||
8345 | 8345 | United States | Rhode Island | RI | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 1059361 | 155 | 2 | 195.378446116134 | -40.3784461161341 | 153 | 0.188793055436249 | -3.81158510801644 | -0.206667863926673 | weekly | |||||||||
8497 | 8497 | United States | South Carolina | SC | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 5148714 | 1039 | 0 | 963.609022557324 | 75.3909774426764 | 1039 | 0.0 | 1.46426811515801 | 0.0782381398241749 | weekly | |||||||||
8649 | 8649 | United States | South Dakota | SD | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 884659 | 145 | 9 | 158.218045113422 | -13.2180451134217 | 136 | 1.01734114500615 | -1.49414012782572 | -0.083543221027324 | weekly | |||||||||
8801 | 8801 | United States | Tennessee | TN | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 6833174 | 1648 | 94 | 1420.0551378455 | 227.944862154504 | 1554 | 1.37564183203882 | 3.33585625295806 | 0.160518317972034 | weekly | |||||||||
8953 | 8953 | United States | Texas | TX | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 28995881 | 4310 | 0 | 3792.23558897298 | 517.764411027025 | 4310 | 0.0 | 1.78564814439342 | 0.136532765140587 | weekly | |||||||||
9105 | 9105 | United States | Utah | UT | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 3205958 | 401 | 13 | 368.548872181248 | 32.4511278187518 | 388 | 0.405495018961571 | 1.01221313001455 | 0.0880510843153326 | weekly | |||||||||
9257 | 9257 | United States | Vermont | VT | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 623989 | 87 | 0 | 97.496240602328 | -10.496240602328 | 87 | 0.0 | -1.68211949286413 | -0.107657900832715 | weekly | |||||||||
9409 | 9409 | United States | Virginia | VA | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 8535519 | 1434 | 107 | 1309.81704260714 | 124.182957392865 | 1327 | 1.2535851657058 | 1.45489638524458 | 0.0948093919633872 | weekly | |||||||||
9561 | 9561 | United States | Washington | WA | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 7614893 | 1276 | 61 | 1040.91228070254 | 235.087719297461 | 1215 | 0.801061814000538 | 3.08720975196186 | 0.225847771859118 | weekly | |||||||||
9713 | 9713 | United States | West Virginia | WV | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 1792147 | 499 | 26 | 405.383458647594 | 93.6165413524057 | 473 | 1.45077384835061 | 5.2237088448886 | 0.230933303654572 | weekly | |||||||||
9865 | 9865 | United States | Wisconsin | WI | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 5822434 | 1072 | 15 | 1059.49373433665 | 12.5062656633454 | 1057 | 0.257624216951193 | 0.214794459900196 | 0.0118040015320859 | weekly | |||||||||
10017 | 10017 | United States | Wyoming | WY | 2022-08-28 | 2022-09-03 | 7 | 2022 | 35 | 578759 | 90 | 4 | 91.8897243115962 | -1.88972431159624 | 86 | 0.691133960767781 | -0.326513162058169 | -0.0205651320183334 | 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);