economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where "end_date" is on date 2022-07-09 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: covid_deaths, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2409 | 2409 | United States | Alabama | AL | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 4903185 | 1057 | 27 | 1002.05012529622 | 54.9498747037821 | 1030 | 0.550662477552856 | 1.12069756094828 | 0.0548374510581877 | weekly | |||||||||
2561 | 2561 | United States | Alaska | AK | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 731545 | 90 | 21 | 93.8170426113721 | -3.81704261137213 | 69 | 2.87063680293078 | -0.52177823802666 | -0.0406860257489021 | weekly | |||||||||
2713 | 2713 | United States | Arizona | AZ | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 7278717 | 1338 | 0 | 1209.06516291985 | 128.93483708015 | 1338 | 0.0 | 1.7713951109811 | 0.106640105954899 | weekly | |||||||||
2865 | 2865 | United States | Arkansas | AR | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 3017825 | 702 | 23 | 598.909774437903 | 103.090225562097 | 679 | 0.762138294964088 | 3.41604385814607 | 0.172129809801235 | weekly | |||||||||
3017 | 3017 | United States | California | CA | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 39512223 | 5718 | 284 | 4869.76190476216 | 848.238095237842 | 5434 | 0.718764924970179 | 2.14677391155097 | 0.174184716178495 | weekly | |||||||||
3169 | 3169 | United States | Colorado | CO | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 5758736 | 880 | 70 | 774.621553885702 | 105.378446114298 | 810 | 1.21554452227016 | 1.82988847056538 | 0.1360386185818 | weekly | |||||||||
3321 | 3321 | United States | Connecticut | CT | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 3565287 | 618 | 0 | 583.526315789897 | 34.4736842101026 | 618 | 0.0 | 0.966925922376029 | 0.0590781996925656 | weekly | |||||||||
3473 | 3473 | United States | Delaware | DE | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 973764 | 191 | 14 | 182.087719302921 | 8.91228069707935 | 177 | 1.43772002251059 | 0.915240314601829 | 0.0489449850390673 | weekly | |||||||||
3625 | 3625 | United States | District of Columbia | DC | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 705749 | 120 | 4 | 100.375939850087 | 19.6240601499132 | 116 | 0.56677373967232 | 2.78060048968021 | 0.195505617972017 | weekly | |||||||||
3777 | 3777 | United States | Florida | FL | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 21477737 | 4373 | 425 | 4029.1478696751 | 343.8521303249 | 3948 | 1.97879320339941 | 1.60097001990899 | 0.0853411543698515 | weekly | |||||||||
3929 | 3929 | United States | Georgia | GA | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 10617423 | 1914 | 106 | 1603.72681704318 | 310.273182956822 | 1808 | 0.998359018002768 | 2.92230217216383 | 0.193470097063587 | weekly | |||||||||
4081 | 4081 | United States | Hawaii | HI | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 1415872 | 241 | 20 | 218.729323309112 | 22.2706766908885 | 221 | 1.41255706730552 | 1.57293008766954 | 0.101818431813165 | weekly | |||||||||
4233 | 4233 | United States | Idaho | ID | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 1787065 | 325 | 12 | 275.39598997562 | 49.60401002438 | 313 | 0.671492083388125 | 2.77572500297303 | 0.180118853686909 | weekly | |||||||||
4385 | 4385 | United States | Illinois | IL | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 12671821 | 2069 | 59 | 1853.40350877237 | 215.596491227632 | 2010 | 0.465600011237532 | 1.70138523285353 | 0.1163246374614 | weekly | |||||||||
4537 | 4537 | United States | Indiana | IN | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 6732219 | 1350 | 66 | 1217.58897243295 | 132.41102756705 | 1284 | 0.980360264572498 | 1.96682590936287 | 0.108748543691612 | weekly | |||||||||
4689 | 4689 | United States | Iowa | IA | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 3155070 | 600 | 15 | 537.796992481693 | 62.2030075183065 | 585 | 0.475425267902138 | 1.97152543424731 | 0.115662616912875 | weekly | |||||||||
4841 | 4841 | United States | Kansas | KS | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 2913314 | 533 | 9 | 493.120300752569 | 39.8796992474312 | 524 | 0.308926535210417 | 1.36887747930471 | 0.0808721506426917 | weekly | |||||||||
4993 | 4993 | United States | Kentucky | KY | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 4467673 | 1019 | 38 | 915.54636591644 | 103.45363408356 | 981 | 0.850554639965817 | 2.31560443397625 | 0.112996608293022 | weekly | |||||||||
5145 | 5145 | United States | Louisiana | LA | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 4648794 | 979 | 13 | 827.233082707589 | 151.766917292411 | 966 | 0.279642419087617 | 3.26465137608615 | 0.183463307337355 | weekly | |||||||||
5297 | 5297 | United States | Maine | ME | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 1344212 | 310 | 42 | 281.491228070831 | 28.5087719291691 | 268 | 3.1245071461942 | 2.1208538481407 | 0.101277656588274 | weekly | |||||||||
5449 | 5449 | United States | Maryland | MD | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 6045680 | 926 | 33 | 926.215538847984 | -0.215538847983908 | 893 | 0.545844305355229 | -0.00356517129560128 | -0.00023270916859374 | weekly | |||||||||
5601 | 5601 | United States | Massachusetts | MA | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 6949503 | 1161 | 82 | 1092.58395990048 | 68.4160400995222 | 1079 | 1.17994049358638 | 0.984473855173848 | 0.0626185653556126 | weekly | |||||||||
5753 | 5753 | United States | Michigan | MI | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 9986857 | 1905 | 64 | 1821.06265664234 | 83.937343357662 | 1841 | 0.640842258980979 | 0.840478073909159 | 0.0460925070598204 | weekly | |||||||||
5905 | 5905 | United States | Minnesota | MN | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 5639632 | 926 | 0 | 846.213032582212 | 79.7869674177879 | 926 | 0.0 | 1.41475485311431 | 0.0942870936108353 | weekly | |||||||||
6057 | 6057 | United States | Mississippi | MS | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 2976149 | 694 | 0 | 575.248120301421 | 118.751879698579 | 694 | 0.0 | 3.99011876416736 | 0.206435928267537 | weekly | |||||||||
6209 | 6209 | United States | Missouri | MO | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 6137428 | 1288 | 0 | 1203.78696741933 | 84.2130325806745 | 1288 | 0.0 | 1.37212253374988 | 0.0699567571837152 | weekly | |||||||||
6361 | 6361 | United States | Montana | MT | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 1068778 | 235 | 5 | 198.180451128635 | 36.8195488713648 | 230 | 0.467824000868281 | 3.44501373263341 | 0.185787996049448 | weekly | |||||||||
6513 | 6513 | United States | Nebraska | NE | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 1934408 | 360 | 3 | 315.187969925895 | 44.8120300741053 | 357 | 0.155086207253072 | 2.31657592783453 | 0.142175572515161 | weekly | |||||||||
6665 | 6665 | United States | Nevada | NV | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 3080156 | 554 | 35 | 510.042606517128 | 43.9573934828722 | 519 | 1.13630608319838 | 1.42711581760379 | 0.0861837676327459 | weekly | |||||||||
6817 | 6817 | United States | New Hampshire | NH | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 1359711 | 266 | 16 | 219.644110276499 | 46.3558897235015 | 250 | 1.17672064137159 | 3.40924576792432 | 0.211050001136595 | weekly | |||||||||
6969 | 6969 | United States | New Jersey | NJ | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 8882190 | 1356 | 43 | 1363.23558897342 | -7.23558897341718 | 1313 | 0.484114841047084 | -0.0814617675755324 | -0.00530765850887593 | weekly | |||||||||
7121 | 7121 | United States | New Mexico | NM | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 2096829 | 428 | 17 | 361.616541354242 | 66.3834586457576 | 411 | 0.810748039062794 | 3.16589758372083 | 0.183574176106971 | weekly | |||||||||
7273 | 7273 | United States | New York | NY | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 19453561 | 2955 | 111 | 2854.13283208103 | 100.867167918973 | 2844 | 0.570589621098163 | 0.518502334451635 | 0.035340740551808 | weekly | |||||||||
7425 | 7425 | United States | North Carolina | NC | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 10488084 | 2046 | 48 | 1848.40852130395 | 197.591478696046 | 1998 | 0.457662238403125 | 1.88396163394616 | 0.106898164782672 | weekly | |||||||||
7577 | 7577 | United States | North Dakota | ND | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 762062 | 122 | 0 | 135.235588973353 | -13.2355889733531 | 122 | 0.0 | -1.73681261804855 | -0.0978706054658518 | weekly | |||||||||
7729 | 7729 | United States | Ohio | OH | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 11689100 | 2385 | 68 | 2195.63408521546 | 189.36591478454 | 2317 | 0.58173854274495 | 1.62002134282828 | 0.0862465727143042 | weekly | |||||||||
7881 | 7881 | United States | Oklahoma | OK | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 3956971 | 825 | 14 | 703.864661654837 | 121.135338345163 | 811 | 0.353805979371595 | 3.06131478712285 | 0.172100326873017 | weekly | |||||||||
8033 | 8033 | United States | Oregon | OR | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 4217737 | 835 | 33 | 665.110275690182 | 169.889724309818 | 802 | 0.782410093374717 | 4.02798288062574 | 0.255430912014589 | weekly | |||||||||
8185 | 8185 | United States | Pennsylvania | PA | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 12801989 | 2578 | 55 | 2336.57142857253 | 241.428571427468 | 2523 | 0.429620740964549 | 1.88586766812148 | 0.103325996575659 | weekly | |||||||||
8337 | 8337 | United States | Rhode Island | RI | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 1059361 | 212 | 4 | 191.378446116185 | 20.6215538838152 | 208 | 0.377586110872498 | 1.94660308278436 | 0.107752750125769 | weekly | |||||||||
8489 | 8489 | United States | South Carolina | SC | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 5148714 | 1070 | 0 | 945.609022557379 | 124.390977442621 | 1070 | 0.0 | 2.41596207213337 | 0.131545886804473 | weekly | |||||||||
8641 | 8641 | United States | South Dakota | SD | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 884659 | 190 | 2 | 161.884711780143 | 28.115288219857 | 188 | 0.226075810001368 | 3.17809327886304 | 0.173674758478988 | weekly | |||||||||
8793 | 8793 | United States | Tennessee | TN | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 6833174 | 1567 | 50 | 1467.05513784555 | 99.94486215445 | 1517 | 0.731724378744051 | 1.46264184337249 | 0.0681261798389012 | weekly | |||||||||
8945 | 8945 | United States | Texas | TX | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 28995881 | 4453 | 101 | 3825.90225563969 | 627.097744360308 | 4352 | 0.348325336277935 | 2.16271319488554 | 0.163908459353846 | weekly | |||||||||
9097 | 9097 | United States | Utah | UT | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 3205958 | 396 | 13 | 376.882205514637 | 19.117794485363 | 383 | 0.405495018961571 | 0.596320802872745 | 0.0507261797071512 | weekly | |||||||||
9249 | 9249 | United States | Vermont | VT | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 623989 | 113 | 4 | 107.162907269048 | 5.83709273095178 | 109 | 0.641036941356338 | 0.935448017665661 | 0.0544693390624136 | weekly | |||||||||
9401 | 9401 | United States | Virginia | VA | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 8535519 | 1309 | 110 | 1302.48370927386 | 6.5162907261406 | 1199 | 1.28873241334241 | 0.0763432279412722 | 0.00500297291992502 | weekly | |||||||||
9553 | 9553 | United States | Washington | WA | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 7614893 | 1354 | 69 | 1083.91228070259 | 270.087719297406 | 1285 | 0.906119101082576 | 3.54683538294506 | 0.249178576630145 | weekly | |||||||||
9705 | 9705 | United States | West Virginia | WV | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 1792147 | 517 | 27 | 422.050125314316 | 94.9498746856844 | 490 | 1.50657284251794 | 5.29810750377533 | 0.224972980673734 | weekly | |||||||||
9857 | 9857 | United States | Wisconsin | WI | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 5822434 | 995 | 27 | 1008.49373433672 | -13.4937343367174 | 968 | 0.463723590512147 | -0.231754182816282 | -0.013380087428696 | weekly | |||||||||
10009 | 10009 | United States | Wyoming | WY | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 578759 | 91 | 0 | 100.556390978317 | -9.55639097831687 | 91 | 0.0 | -1.65118658687241 | -0.095035142822275 | weekly | |||||||||
12057 | 12057 | Canada | Canada | 0 | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 38454328 | 5275 | 168 | 5452.47018030517 | -177.47018030517 | 5107 | 0.436881903124143 | -0.461508988806592 | -0.0325485833826674 | weekly | |||||||||
17108 | 17108 | South Africa | South Africa | 0 | 2022-07-03 | 2022-07-09 | 7 | 2022 | 27 | 59893884 | 11931 | 67 | 11582.3765690375 | 348.623430962465 | 11864 | 0.111864510239476 | 0.582068497949582 | 0.0300994730126851 | 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);