economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where cadence = "weekly" and "start_date" is on date 2020-12-06 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2327 | 2327 | United States | Alabama | AL | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 4903185 | 1598 | 205 | 1093.35839598188 | 504.641604018118 | 1393 | 4.1809558480865 | 10.2921183683283 | 0.461551862475001 | weekly | |||||||||
2479 | 2479 | United States | Alaska | AK | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 731545 | 135 | 28 | 105.075187972733 | 29.9248120272668 | 107 | 3.82751573724104 | 4.09063174886942 | 0.284794275457611 | weekly | |||||||||
2631 | 2631 | United States | Arizona | AZ | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 7278717 | 2004 | 397 | 1214.36591479499 | 789.634085205008 | 1607 | 5.45425794133774 | 10.8485339546105 | 0.650243946725327 | weekly | |||||||||
2783 | 2783 | United States | Arkansas | AR | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 3017825 | 912 | 290 | 684.288220552702 | 227.711779447298 | 622 | 9.60956980606894 | 7.54555944918271 | 0.332771736540159 | weekly | |||||||||
2935 | 2935 | United States | California | CA | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 39512223 | 8149 | 1823 | 5370.38095238158 | 2778.61904761842 | 6326 | 4.61376217683323 | 7.03230250451467 | 0.517397010054976 | weekly | |||||||||
3087 | 3087 | United States | Colorado | CO | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 5758736 | 1258 | 515 | 803.310776943428 | 454.689223056572 | 743 | 8.94293469955907 | 7.89564277745275 | 0.56601907519111 | weekly | |||||||||
3239 | 3239 | United States | Connecticut | CT | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 3565287 | 846 | 217 | 641.596491228824 | 204.403508771176 | 629 | 6.08646653130589 | 5.73315721206108 | 0.318585764675381 | weekly | |||||||||
3391 | 3391 | United States | Delaware | DE | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 973764 | 277 | 22 | 195.8771929854 | 81.1228070145996 | 255 | 2.25927432108807 | 8.33084885193945 | 0.414151365854248 | weekly | |||||||||
3543 | 3543 | United States | District of Columbia | DC | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 705749 | 175 | 18 | 121.187969925217 | 53.8120300747832 | 157 | 2.55048182852544 | 7.62481138121105 | 0.444037721796889 | weekly | |||||||||
3695 | 3695 | United States | Florida | FL | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 21477737 | 5085 | 716 | 4296.24060150477 | 788.75939849523 | 4369 | 3.333684549727 | 3.67245114555239 | 0.183592929646204 | weekly | |||||||||
3847 | 3847 | United States | Georgia | GA | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 10617423 | 2241 | 236 | 1774.03007518844 | 466.969924811556 | 2005 | 2.22276158725145 | 4.39814750539332 | 0.263225483796803 | weekly | |||||||||
3999 | 3999 | United States | Hawaii | HI | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 1415872 | 212 | 8 | 230.864661655023 | -18.8646616550233 | 204 | 0.565022826922208 | -1.33237055715653 | -0.0817130760497784 | weekly | |||||||||
4151 | 4151 | United States | Idaho | ID | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 1787065 | 373 | 137 | 292.197994988259 | 80.8020050117405 | 236 | 7.66620128534776 | 4.52149222393928 | 0.276531688778313 | weekly | |||||||||
4303 | 4303 | United States | Illinois | IL | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 12671821 | 3345 | 1215 | 2124.03508771982 | 1220.96491228018 | 2130 | 9.58820362124749 | 9.63527587929294 | 0.57483274138889 | weekly | |||||||||
4455 | 4455 | United States | Indiana | IN | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 6732219 | 2118 | 550 | 1343.12781955023 | 774.872180449768 | 1568 | 8.16966887143749 | 11.5099075126607 | 0.576916187105146 | weekly | |||||||||
4607 | 4607 | United States | Iowa | IA | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 3155070 | 950 | 582 | 602.065162907928 | 347.934837092072 | 368 | 18.446500394603 | 11.027800875799 | 0.577902291193156 | weekly | |||||||||
4759 | 4759 | United States | Kansas | KS | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 2913314 | 880 | 286 | 553.726817043369 | 326.273182956631 | 594 | 9.81699878557547 | 11.1993826603185 | 0.589231319333188 | weekly | |||||||||
4911 | 4911 | United States | Kentucky | KY | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 4467673 | 1410 | 130 | 1001.27318295865 | 408.726817041347 | 1280 | 2.90979218935674 | 9.14853922928887 | 0.408207094724742 | weekly | |||||||||
5063 | 5063 | United States | Louisiana | LA | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 4648794 | 1238 | 220 | 948.283208020958 | 289.716791979042 | 1018 | 4.73241016917506 | 6.2320849661018 | 0.305517159355457 | weekly | |||||||||
5215 | 5215 | United States | Maine | ME | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 1344212 | 353 | 31 | 293.912280702495 | 59.0877192975053 | 322 | 2.30618384600048 | 4.39571431422315 | 0.201038619945641 | weekly | |||||||||
5367 | 5367 | United States | Maryland | MD | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 6045680 | 1378 | 276 | 1014.7744360911 | 363.225563908896 | 1102 | 4.56524328115282 | 6.00801835209432 | 0.357937242987748 | weekly | |||||||||
5519 | 5519 | United States | Massachusetts | MA | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 6949503 | 1351 | 354 | 1146.45864661733 | 204.541353382674 | 997 | 5.09388944792167 | 2.94325153011192 | 0.178411453379659 | weekly | |||||||||
5671 | 5671 | United States | Michigan | MI | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 9986857 | 2958 | 878 | 1962.86466165502 | 995.135338344982 | 2080 | 8.7915547403953 | 9.96444965963748 | 0.506981127015614 | weekly | |||||||||
5823 | 5823 | United States | Minnesota | MN | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 5639632 | 1382 | 440 | 904.939849624859 | 477.060150375141 | 942 | 7.80192750165259 | 8.45906524353257 | 0.527173326020404 | weekly | |||||||||
5975 | 5975 | United States | Mississippi | MS | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 2976149 | 959 | 231 | 658.624060151105 | 300.375939848895 | 728 | 7.76170816716502 | 10.0927722317967 | 0.45606584700228 | weekly | |||||||||
6127 | 6127 | United States | Missouri | MO | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 6137428 | 2017 | 329 | 1270.72681704341 | 746.273182956591 | 1688 | 5.36055168386497 | 12.15937984049 | 0.587280580646704 | weekly | |||||||||
6279 | 6279 | United States | Montana | MT | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 1068778 | 303 | 83 | 195.090225564751 | 107.909774435249 | 220 | 7.76587841441347 | 10.0965564818184 | 0.553127529187428 | weekly | |||||||||
6431 | 6431 | United States | Nebraska | NE | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 1934408 | 501 | 171 | 350.927318296812 | 150.072681703188 | 330 | 8.83991381342509 | 7.7580676725483 | 0.427646050559841 | weekly | |||||||||
6583 | 6583 | United States | Nevada | NV | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 3080156 | 908 | 214 | 530.854636592333 | 377.145363407667 | 694 | 6.94770005155583 | 12.2443591625771 | 0.710449410084542 | weekly | |||||||||
6735 | 6735 | United States | New Hampshire | NH | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 1359711 | 312 | 41 | 254.822055138679 | 57.1779448613211 | 271 | 3.01534664351469 | 4.20515424684518 | 0.22438381493393 | weekly | |||||||||
6887 | 6887 | United States | New Jersey | NJ | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 8882190 | 2026 | 427 | 1528.45112782055 | 497.548872179453 | 1599 | 4.8073729564443 | 5.60164635275144 | 0.325524881445781 | weekly | |||||||||
7039 | 7039 | United States | New Mexico | NM | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 2096829 | 687 | 175 | 366.308270677533 | 320.691729322467 | 512 | 8.34593569623465 | 15.2941288642263 | 0.875469529337427 | weekly | |||||||||
7191 | 7191 | United States | New York | NY | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 19453561 | 3872 | 591 | 3105.89974937425 | 766.100250625753 | 3281 | 3.03800419881995 | 3.93809776331312 | 0.246659683970837 | weekly | |||||||||
7343 | 7343 | United States | North Carolina | NC | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 10488084 | 2459 | 278 | 1972.7042606522 | 486.2957393478 | 2181 | 2.65062713075143 | 4.63664992907951 | 0.246512236551375 | weekly | |||||||||
7495 | 7495 | United States | North Dakota | ND | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 762062 | 231 | 57 | 143.451127820419 | 87.5488721795811 | 174 | 7.47970637559674 | 11.4884185511915 | 0.6103045232881 | weekly | |||||||||
7647 | 7647 | United States | Ohio | OH | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 11689100 | 4230 | 530 | 2464.15037594183 | 1765.84962405817 | 3700 | 4.5341386419827 | 15.1068056912694 | 0.716616015523499 | weekly | |||||||||
7799 | 7799 | United States | Oklahoma | OK | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 3956971 | 1212 | 444 | 796.598997494505 | 415.401002505495 | 768 | 11.2207039172134 | 10.4979541802428 | 0.521468146221664 | weekly | |||||||||
7951 | 7951 | United States | Oregon | OR | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 4217737 | 941 | 110 | 719.721804512176 | 221.278195487824 | 831 | 2.60803364458239 | 5.24637253313385 | 0.307449620256823 | weekly | |||||||||
8103 | 8103 | United States | Pennsylvania | PA | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 12801989 | 4355 | 1174 | 2724.28571428683 | 1630.71428571317 | 3181 | 9.17044999804327 | 12.7379759950831 | 0.598584163607109 | weekly | |||||||||
8255 | 8255 | United States | Rhode Island | RI | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 1059361 | 325 | 74 | 206.355889725185 | 118.644110274815 | 251 | 6.98534305114121 | 11.1995920441488 | 0.574948989499742 | weekly | |||||||||
8407 | 8407 | United States | South Carolina | SC | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 5148714 | 1281 | 168 | 1058.13784461248 | 222.862155387519 | 1113 | 3.26295070963351 | 4.32850135757238 | 0.210617318454513 | weekly | |||||||||
8559 | 8559 | United States | South Dakota | SD | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 884659 | 283 | 153 | 148.942355890448 | 134.057644109552 | 130 | 17.2947994651046 | 15.153595239471 | 0.900063942913294 | weekly | |||||||||
8711 | 8711 | United States | Tennessee | TN | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 6833174 | 2188 | 451 | 1589.02756892319 | 598.972431076808 | 1737 | 6.60015389627134 | 8.76565460028982 | 0.376942755928837 | weekly | |||||||||
8863 | 8863 | United States | Texas | TX | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 28995881 | 6057 | 1517 | 4243.45112782003 | 1813.54887217997 | 4540 | 5.23177757558048 | 6.25450515602533 | 0.427375930004321 | weekly | |||||||||
9015 | 9015 | United States | Utah | UT | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 3205958 | 552 | 101 | 373.441102757726 | 178.558897242274 | 451 | 3.15038437808605 | 5.56959564792407 | 0.478144735337597 | weekly | |||||||||
9167 | 9167 | United States | Vermont | VT | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 623989 | 117 | 16 | 95.9147869682852 | 21.0852130317148 | 101 | 2.56414776542535 | 3.37910011742431 | 0.219832767169537 | weekly | |||||||||
9319 | 9319 | United States | Virginia | VA | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 8535519 | 1795 | 215 | 1430.07518797058 | 364.924812029416 | 1580 | 2.5188860806238 | 4.27536757904723 | 0.255178759200263 | weekly | |||||||||
9471 | 9471 | United States | Washington | WA | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 7614893 | 1412 | 47 | 1154.12280701838 | 257.877192981618 | 1365 | 0.617211561606972 | 3.38648478687248 | 0.223439993918698 | weekly | |||||||||
9623 | 9623 | United States | West Virginia | WV | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 1792147 | 647 | 137 | 470.35839599092 | 176.64160400908 | 510 | 7.64446220092437 | 9.85642383181067 | 0.37554682878987 | weekly | |||||||||
9775 | 9775 | United States | Wisconsin | WI | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 5822434 | 1569 | 449 | 1128.74686716876 | 440.253132831241 | 1120 | 7.71155156073903 | 7.56132457373052 | 0.390037080621565 | weekly | |||||||||
9927 | 9927 | United States | Wyoming | WY | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 578759 | 143 | 64 | 98.9448621562396 | 44.0551378437604 | 79 | 11.0581433722845 | 7.61200047753217 | 0.445249373071993 | weekly | |||||||||
11975 | 11975 | Canada | Canada | 0 | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 38454328 | 6565 | 764 | 5852.88210818327 | 712.117891816734 | 5801 | 1.98677246420741 | 1.85185368943837 | 0.121669611424613 | weekly | |||||||||
17026 | 17026 | South Africa | South Africa | 0 | 2020-12-06 | 2020-12-12 | 7 | 2020 | 50 | 59893884 | 12805 | 1039 | 9633.82594142257 | 3171.17405857743 | 11766 | 1.73473471848979 | 5.294654223088 | 0.329170786129977 | 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);