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-11-01 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: end_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2322 | 2322 | United States | Alabama | AL | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 4903185 | 1277 | 115 | 1008.02506265007 | 268.974937349934 | 1162 | 2.34541425624365 | 5.48571871854589 | 0.266833581144112 | weekly | |||||||||
2474 | 2474 | United States | Alaska | AK | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 731545 | 114 | 4 | 95.0751879727066 | 18.9248120272934 | 110 | 0.546787962463006 | 2.58696485209979 | 0.199051008268595 | weekly | |||||||||
2626 | 2626 | United States | Arizona | AZ | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 7278717 | 1399 | 169 | 1177.69924812829 | 221.300751871709 | 1230 | 2.321837763441 | 3.0403813181871 | 0.187909393865556 | weekly | |||||||||
2778 | 2778 | United States | Arkansas | AR | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 3017825 | 845 | 142 | 608.288220552675 | 236.711779447325 | 703 | 4.70537556021307 | 7.84378747764781 | 0.389144112033363 | weekly | |||||||||
2930 | 2930 | United States | California | CA | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 39512223 | 5872 | 341 | 5082.38095238155 | 789.619047618446 | 5531 | 0.863024082446589 | 1.99841716731161 | 0.155364002623305 | weekly | |||||||||
3082 | 3082 | United States | Colorado | CO | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 5758736 | 1007 | 111 | 785.977443610068 | 221.022556389932 | 896 | 1.92750631388555 | 3.83803939597043 | 0.281207251158194 | weekly | |||||||||
3234 | 3234 | United States | Connecticut | CT | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 3565287 | 727 | 55 | 591.263157895463 | 135.736842104537 | 672 | 1.54265280747384 | 3.80717855545813 | 0.229570945342979 | weekly | |||||||||
3386 | 3386 | United States | Delaware | DE | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 973764 | 199 | 7 | 176.210526318706 | 22.7894736812939 | 192 | 0.718860011255294 | 2.34034875814817 | 0.129330943828381 | weekly | |||||||||
3538 | 3538 | United States | District of Columbia | DC | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 705749 | 137 | 8 | 127.521303258522 | 9.47869674147836 | 129 | 1.13354747934464 | 1.34306909984688 | 0.074330300108856 | weekly | |||||||||
3690 | 3690 | United States | Florida | FL | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 21477737 | 4305 | 339 | 3965.24060150475 | 339.759398495249 | 3966 | 1.57837857871153 | 1.58191432596111 | 0.0856844344744971 | weekly | |||||||||
3842 | 3842 | United States | Georgia | GA | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 10617423 | 2020 | 219 | 1676.36340852176 | 343.636591478245 | 1801 | 2.06264740511893 | 3.23653481149093 | 0.20498931778836 | weekly | |||||||||
3994 | 3994 | United States | Hawaii | HI | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 1415872 | 236 | 1 | 227.864661654989 | 8.13533834501067 | 235 | 0.070627853365276 | 0.57458148370832 | 0.0357025011510053 | weekly | |||||||||
4146 | 4146 | United States | Idaho | ID | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 1787065 | 365 | 54 | 280.864661654897 | 84.1353383451026 | 311 | 3.02171437524656 | 4.70801780265982 | 0.299558292059116 | weekly | |||||||||
4298 | 4298 | United States | Illinois | IL | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 12671821 | 2699 | 731 | 2049.70175438646 | 649.298245613544 | 1968 | 5.76870522397688 | 5.12395373651146 | 0.316776938022332 | weekly | |||||||||
4450 | 4450 | United States | Indiana | IN | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 6732219 | 1655 | 260 | 1242.1278195502 | 412.872180449795 | 1395 | 3.86202528467954 | 6.13278000091494 | 0.332391058272331 | weekly | |||||||||
4602 | 4602 | United States | Iowa | IA | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 3155070 | 860 | 100 | 593.398496241233 | 266.601503758767 | 760 | 3.16950178601426 | 8.44993942317498 | 0.449279034995036 | weekly | |||||||||
4754 | 4754 | United States | Kansas | KS | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 2913314 | 679 | 137 | 517.060150376675 | 161.939849623325 | 542 | 4.70254836931412 | 5.55861296184776 | 0.313193444718866 | weekly | |||||||||
4906 | 4906 | United States | Kentucky | KY | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 4467673 | 1181 | 76 | 901.606516291958 | 279.393483708042 | 1105 | 1.70110927993163 | 6.25366905116024 | 0.309884055471455 | weekly | |||||||||
5058 | 5058 | United States | Louisiana | LA | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 4648794 | 1052 | 82 | 926.616541354264 | 125.383458645736 | 970 | 1.76389833578343 | 2.69711797609738 | 0.135313209995676 | weekly | |||||||||
5210 | 5210 | United States | Maine | ME | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 1344212 | 334 | 5 | 289.2456140358 | 44.7543859642004 | 329 | 0.371965136451691 | 3.32941425639709 | 0.154727967486695 | weekly | |||||||||
5362 | 5362 | United States | Maryland | MD | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 6045680 | 1088 | 56 | 978.441102757742 | 109.558897242258 | 1032 | 0.926281245451298 | 1.81218485335409 | 0.111972909696317 | weekly | |||||||||
5514 | 5514 | United States | Massachusetts | MA | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 6949503 | 1218 | 134 | 1094.4586466173 | 123.541353382702 | 1084 | 1.92819544073871 | 1.77770055474042 | 0.11287895962496 | weekly | |||||||||
5666 | 5666 | United States | Michigan | MI | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 9986857 | 2347 | 181 | 1899.19799498832 | 447.802005011676 | 2166 | 1.81238201368058 | 4.48391325731084 | 0.235784792419407 | weekly | |||||||||
5818 | 5818 | United States | Minnesota | MN | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 5639632 | 1145 | 149 | 922.606516291499 | 222.393483708501 | 996 | 2.64201635851417 | 3.94340417439472 | 0.241049114418172 | weekly | |||||||||
5970 | 5970 | United States | Mississippi | MS | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 2976149 | 750 | 94 | 618.624060151078 | 131.375939848922 | 656 | 3.15844401607581 | 4.41429309651237 | 0.212367976468354 | weekly | |||||||||
6122 | 6122 | United States | Missouri | MO | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 6137428 | 1790 | 127 | 1219.06015037671 | 570.939849623286 | 1663 | 2.06927071079286 | 9.30259140511769 | 0.468344280999469 | weekly | |||||||||
6274 | 6274 | United States | Montana | MT | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 1068778 | 299 | 70 | 197.090225564722 | 101.909774435278 | 229 | 6.54953601215594 | 9.53516768077918 | 0.517071681983601 | weekly | |||||||||
6426 | 6426 | United States | Nebraska | NE | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 1934408 | 498 | 56 | 329.593984963448 | 168.406015036552 | 442 | 2.89494253539067 | 8.70581671687418 | 0.510949904183559 | weekly | |||||||||
6578 | 6578 | United States | Nevada | NV | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 3080156 | 555 | 71 | 495.854636592306 | 59.1453634076944 | 484 | 2.30507805448815 | 1.92020674951835 | 0.11927964173969 | weekly | |||||||||
6730 | 6730 | United States | New Hampshire | NH | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 1359711 | 263 | 6 | 232.822055138654 | 30.1779448613456 | 257 | 0.441270240514345 | 2.21943816453243 | 0.129618067512433 | weekly | |||||||||
6882 | 6882 | United States | New Jersey | NJ | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 8882190 | 1567 | 77 | 1389.11779448718 | 177.882205512817 | 1490 | 0.866903320014546 | 2.00268408481261 | 0.128054083115742 | weekly | |||||||||
7034 | 7034 | United States | New Mexico | NM | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 2096829 | 519 | 86 | 359.974937344174 | 159.025062655826 | 433 | 4.10143125643531 | 7.58407398294407 | 0.441767040308647 | weekly | |||||||||
7186 | 7186 | United States | New York | NY | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 19453561 | 3317 | 134 | 3002.89974937422 | 314.100250625783 | 3183 | 0.688819902947332 | 1.61461570262526 | 0.104598979933059 | weekly | |||||||||
7338 | 7338 | United States | North Carolina | NC | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 10488084 | 2382 | 381 | 1848.70426065218 | 533.295739347823 | 2001 | 3.6326940173248 | 5.08477753751613 | 0.288470011509407 | weekly | |||||||||
7490 | 7490 | United States | North Dakota | ND | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 762062 | 269 | 104 | 149.784461153725 | 119.215538846275 | 165 | 13.6471835624923 | 15.6438109820822 | 0.795913928107161 | weekly | |||||||||
7642 | 7642 | United States | Ohio | OH | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 11689100 | 3028 | 205 | 2405.81704260846 | 622.182957391537 | 2823 | 1.75377060680463 | 5.32276186696612 | 0.258616073613372 | weekly | |||||||||
7794 | 7794 | United States | Oklahoma | OK | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 3956971 | 1028 | 193 | 773.598997494476 | 254.401002505524 | 835 | 4.87746814419413 | 6.42918541747018 | 0.328853842015663 | weekly | |||||||||
7946 | 7946 | United States | Oregon | OR | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 4217737 | 835 | 41 | 730.721804512149 | 104.278195487851 | 794 | 0.972085267526164 | 2.47237311116959 | 0.142705739508444 | weekly | |||||||||
8098 | 8098 | United States | Pennsylvania | PA | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 12801989 | 2984 | 203 | 2525.95238095345 | 458.047619046548 | 2781 | 1.58569109846915 | 3.57794104530591 | 0.181336600998651 | weekly | |||||||||
8250 | 8250 | United States | Rhode Island | RI | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 1059361 | 228 | 23 | 190.355889725155 | 37.6441102748445 | 205 | 2.17112013751686 | 3.55347329898349 | 0.197756477770122 | weekly | |||||||||
8402 | 8402 | United States | South Carolina | SC | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 5148714 | 1185 | 83 | 966.471177945792 | 218.528822054208 | 1102 | 1.61205302916418 | 4.24433794641163 | 0.226110024841802 | weekly | |||||||||
8554 | 8554 | United States | South Dakota | SD | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 884659 | 356 | 98 | 162.609022557086 | 193.390977442914 | 258 | 11.077714690067 | 21.8605109361816 | 1.18930041151328 | weekly | |||||||||
8706 | 8706 | United States | Tennessee | TN | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 6833174 | 1815 | 200 | 1453.69423558984 | 361.30576441016 | 1615 | 2.9268975149762 | 5.28752471999338 | 0.248543163730411 | weekly | |||||||||
8858 | 8858 | United States | Texas | TX | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 28995881 | 5402 | 927 | 4015.78446115339 | 1386.21553884661 | 4475 | 3.19700580920442 | 4.78073261111332 | 0.345191718394286 | weekly | |||||||||
9010 | 9010 | United States | Utah | UT | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 3205958 | 453 | 54 | 368.774436091035 | 84.2255639089651 | 399 | 1.68436392491729 | 2.62715743340883 | 0.228393173891732 | weekly | |||||||||
9162 | 9162 | United States | Vermont | VT | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 623989 | 114 | 1 | 116.58145363492 | -2.58145363491973 | 113 | 0.160259235339084 | -0.413701785595535 | -0.0221429185726545 | weekly | |||||||||
9314 | 9314 | United States | Virginia | VA | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 8535519 | 1652 | 60 | 1325.07518797056 | 326.924812029439 | 1592 | 0.702944952732224 | 3.83016910898375 | 0.246721706811328 | weekly | |||||||||
9466 | 9466 | United States | Washington | WA | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 7614893 | 1274 | 72 | 1107.45614035169 | 166.543859648312 | 1202 | 0.94551558373834 | 2.18708075935291 | 0.150384158414999 | weekly | |||||||||
9618 | 9618 | United States | West Virginia | WV | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 1792147 | 531 | 48 | 457.358395990891 | 73.6416040091087 | 483 | 2.67835172003189 | 4.10912743257717 | 0.161015091566342 | weekly | |||||||||
9770 | 9770 | United States | Wisconsin | WI | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 5822434 | 1601 | 434 | 1066.74686716874 | 534.253132831265 | 1167 | 7.45392734378784 | 9.17576966662507 | 0.500824656039752 | weekly | |||||||||
9922 | 9922 | United States | Wyoming | WY | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 578759 | 136 | 17 | 87.9448621562099 | 48.0551378437901 | 119 | 2.93731933326307 | 8.30313443830508 | 0.546423482459195 | weekly | |||||||||
11970 | 11970 | Canada | Canada | 0 | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 38454328 | 6260 | 311 | 5631.88210818327 | 628.117891816734 | 5949 | 0.808751618283383 | 1.6334127378763 | 0.111528948893312 | weekly | |||||||||
17021 | 17021 | South Africa | South Africa | 0 | 2020-11-01 | 2020-11-07 | 7 | 2020 | 45 | 59893884 | 10480 | 513 | 9734.42594142257 | 745.574058577426 | 9967 | 0.856514832132109 | 1.2448250285078 | 0.0765914767921561 | 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);