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-15 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2324 | 2324 | United States | Alabama | AL | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 4903185 | 1275 | 211 | 1027.69172931509 | 247.308270684908 | 1064 | 4.30332528754269 | 5.04382907609865 | 0.240644410799848 | weekly | |||||||||
2476 | 2476 | United States | Alaska | AK | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 731545 | 122 | 11 | 92.0751879727444 | 29.9248120272556 | 111 | 1.50366689677327 | 4.09063174886789 | 0.325004082925292 | weekly | |||||||||
2628 | 2628 | United States | Arizona | AZ | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 7278717 | 1525 | 157 | 1198.03258146167 | 326.967418538331 | 1368 | 2.1569735435517 | 4.49210236554507 | 0.272920305839606 | weekly | |||||||||
2780 | 2780 | United States | Arkansas | AR | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 3017825 | 876 | 174 | 633.95488721938 | 242.04511278062 | 702 | 5.76574188364136 | 8.02051519821793 | 0.381801793251041 | weekly | |||||||||
2932 | 2932 | United States | California | CA | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 39512223 | 6350 | 619 | 5163.04761904826 | 1186.95238095174 | 5731 | 1.56660383294557 | 3.00401316562661 | 0.229893750461001 | weekly | |||||||||
3084 | 3084 | United States | Colorado | CO | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 5758736 | 1132 | 263 | 786.310776943439 | 345.689223056561 | 869 | 4.56697441938648 | 6.00286630706046 | 0.439634344578527 | weekly | |||||||||
3236 | 3236 | United States | Connecticut | CT | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 3565287 | 759 | 91 | 615.929824562168 | 143.070175437832 | 668 | 2.55238919054763 | 4.01286559645357 | 0.232283240285584 | weekly | |||||||||
3388 | 3388 | United States | Delaware | DE | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 973764 | 232 | 12 | 183.543859652078 | 48.4561403479217 | 220 | 1.23233144786622 | 4.97616879941358 | 0.264003058668234 | weekly | |||||||||
3540 | 3540 | United States | District of Columbia | DC | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 705749 | 135 | 12 | 116.854636591895 | 18.1453634081055 | 123 | 1.70032121901696 | 2.57107886913131 | 0.155281501336372 | weekly | |||||||||
3692 | 3692 | United States | Florida | FL | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 21477737 | 4561 | 442 | 4014.24060150478 | 546.759398495221 | 4119 | 2.05794493153538 | 2.54570301561669 | 0.136204939557002 | weekly | |||||||||
3844 | 3844 | United States | Georgia | GA | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 10617423 | 1978 | 166 | 1751.36340852179 | 226.636591478214 | 1812 | 1.56346789611754 | 2.13457249916683 | 0.129405804857772 | weekly | |||||||||
3996 | 3996 | United States | Hawaii | HI | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 1415872 | 224 | 9 | 220.197994988368 | 3.80200501163247 | 215 | 0.635650680287484 | 0.268527452455623 | 0.0172663016837793 | weekly | |||||||||
4148 | 4148 | United States | Idaho | ID | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 1787065 | 391 | 95 | 246.864661654937 | 144.135338345063 | 296 | 5.31597899348932 | 8.06547821959824 | 0.583863795566387 | weekly | |||||||||
4300 | 4300 | United States | Illinois | IL | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 12671821 | 3186 | 864 | 2033.36842105317 | 1152.63157894683 | 2322 | 6.81827813066488 | 9.09602162898944 | 0.566858207795824 | weekly | |||||||||
4452 | 4452 | United States | Indiana | IN | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 6732219 | 1936 | 359 | 1290.79448621691 | 645.205513783092 | 1577 | 5.33256568153829 | 9.58384618478828 | 0.499851464096407 | weekly | |||||||||
4604 | 4604 | United States | Iowa | IA | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 3155070 | 998 | 186 | 617.398496241272 | 380.601503758728 | 812 | 5.89527332198652 | 12.06317145923 | 0.616460043352606 | weekly | |||||||||
4756 | 4756 | United States | Kansas | KS | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 2913314 | 782 | 156 | 531.726817043379 | 250.273182956621 | 626 | 5.35472661031389 | 8.59066969631906 | 0.470680008859141 | weekly | |||||||||
4908 | 4908 | United States | Kentucky | KY | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 4467673 | 1289 | 125 | 953.606516291996 | 335.393483708004 | 1164 | 2.79787710515071 | 7.50711799426691 | 0.351710561932975 | weekly | |||||||||
5060 | 5060 | United States | Louisiana | LA | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 4648794 | 1068 | 348 | 895.949874687634 | 172.050125312366 | 720 | 7.48581244942237 | 3.70096255743674 | 0.19203097201431 | weekly | |||||||||
5212 | 5212 | United States | Maine | ME | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 1344212 | 307 | 13 | 301.245614035838 | 5.75438596416177 | 294 | 0.967109354774396 | 0.428086192071025 | 0.019101974256386 | weekly | |||||||||
5364 | 5364 | United States | Maryland | MD | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 6045680 | 1224 | 130 | 984.774436091114 | 239.225563908886 | 1094 | 2.15029574836908 | 3.95696702288057 | 0.242924222178684 | weekly | |||||||||
5516 | 5516 | United States | Massachusetts | MA | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 6949503 | 1214 | 195 | 1164.79197995067 | 49.2080200493281 | 1019 | 2.80595605182126 | 0.708079700797713 | 0.0422461872131126 | weekly | |||||||||
5668 | 5668 | United States | Michigan | MI | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 9986857 | 2623 | 503 | 1940.86466165503 | 682.135338344971 | 2120 | 5.03661962917863 | 6.83033048680853 | 0.351459507621359 | weekly | |||||||||
5820 | 5820 | United States | Minnesota | MN | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 5639632 | 1326 | 336 | 896.606516291535 | 429.393483708465 | 990 | 5.95783554671652 | 7.61385643085337 | 0.478909617436737 | weekly | |||||||||
5972 | 5972 | United States | Mississippi | MS | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 2976149 | 793 | 117 | 636.957393484449 | 156.042606515551 | 676 | 3.9312547859667 | 5.24310464682886 | 0.244981231259325 | weekly | |||||||||
6124 | 6124 | United States | Missouri | MO | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 6137428 | 1858 | 180 | 1249.72681704342 | 608.273182956581 | 1678 | 2.9328246294702 | 9.91088095789605 | 0.486724918327048 | weekly | |||||||||
6276 | 6276 | United States | Montana | MT | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 1068778 | 332 | 87 | 199.090225564759 | 132.909774435241 | 245 | 8.1401376151081 | 12.435676486159 | 0.667585633891445 | weekly | |||||||||
6428 | 6428 | United States | Nebraska | NE | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 1934408 | 574 | 122 | 327.927318296822 | 246.072681703178 | 452 | 6.30683909495825 | 12.7208263046461 | 0.750387869425526 | weekly | |||||||||
6580 | 6580 | United States | Nevada | NV | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 3080156 | 663 | 102 | 505.187969925676 | 157.812030074324 | 561 | 3.311520585321 | 5.12350770786687 | 0.312382795056544 | weekly | |||||||||
6732 | 6732 | United States | New Hampshire | NH | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 1359711 | 259 | 9 | 243.488721805358 | 15.5112781946421 | 250 | 0.661905360771517 | 1.14077757660577 | 0.0637042984152736 | weekly | |||||||||
6884 | 6884 | United States | New Jersey | NJ | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 8882190 | 1677 | 198 | 1481.11779448722 | 195.882205512776 | 1479 | 2.22917996575169 | 2.20533680897139 | 0.132252955329993 | weekly | |||||||||
7036 | 7036 | United States | New Mexico | NM | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 2096829 | 587 | 142 | 351.97493734421 | 235.02506265579 | 445 | 6.7721306792304 | 11.2085946281643 | 0.667732380121003 | weekly | |||||||||
7188 | 7188 | United States | New York | NY | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 19453561 | 3288 | 230 | 3034.23308270759 | 253.766917292412 | 3058 | 1.18230281849169 | 1.3044753980642 | 0.0836346155272829 | weekly | |||||||||
7340 | 7340 | United States | North Carolina | NC | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 10488084 | 2176 | 286 | 1859.03759398554 | 316.96240601446 | 1890 | 2.72690417048529 | 3.02211925471287 | 0.170498115282829 | weekly | |||||||||
7492 | 7492 | United States | North Dakota | ND | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 762062 | 273 | 108 | 154.117794487093 | 118.882205512907 | 165 | 14.1720752379728 | 15.6000700091209 | 0.771372351314455 | weekly | |||||||||
7644 | 7644 | United States | Ohio | OH | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 11689100 | 3256 | 28 | 2378.15037594185 | 877.849624058152 | 3228 | 0.239539399953803 | 7.50998472130576 | 0.369131251303016 | weekly | |||||||||
7796 | 7796 | United States | Oklahoma | OK | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 3956971 | 1148 | 304 | 770.598997494513 | 377.401002505487 | 844 | 7.68264412349749 | 9.53762366480539 | 0.489750186196127 | weekly | |||||||||
7948 | 7948 | United States | Oregon | OR | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 4217737 | 835 | 60 | 702.721804512186 | 132.278195487814 | 775 | 1.42256380613585 | 3.13623622069878 | 0.188236930515681 | weekly | |||||||||
8100 | 8100 | United States | Pennsylvania | PA | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 12801989 | 3355 | 415 | 2547.28571428684 | 807.714285713158 | 2940 | 3.2416837727325 | 6.30928745301342 | 0.317088217149325 | weekly | |||||||||
8252 | 8252 | United States | Rhode Island | RI | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 1059361 | 226 | 31 | 206.689223058528 | 19.3107769414721 | 195 | 2.92629235926186 | 1.82287029081419 | 0.0934290460611191 | weekly | |||||||||
8404 | 8404 | United States | South Carolina | SC | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 5148714 | 1192 | 90 | 977.804511279151 | 214.195488720849 | 1102 | 1.74800930873224 | 4.16017453524995 | 0.219057578738966 | weekly | |||||||||
8556 | 8556 | United States | South Dakota | SD | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 884659 | 335 | 120 | 179.275689223789 | 155.724310776211 | 215 | 13.5645486000821 | 17.6027498478183 | 0.868630384021674 | weekly | |||||||||
8708 | 8708 | United States | Tennessee | TN | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 6833174 | 2001 | 350 | 1518.36090225653 | 482.639097743465 | 1651 | 5.12207065120836 | 7.06317587907852 | 0.317868496894371 | weekly | |||||||||
8860 | 8860 | United States | Texas | TX | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 28995881 | 5431 | 1169 | 4122.45112782005 | 1308.54887217995 | 4262 | 4.03160710998917 | 4.51287847463558 | 0.317420105565183 | weekly | |||||||||
9012 | 9012 | United States | Utah | UT | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 3205958 | 544 | 64 | 402.107769424404 | 141.892230575596 | 480 | 1.99628317027235 | 4.42589174828853 | 0.352871148893013 | weekly | |||||||||
9164 | 9164 | United States | Vermont | VT | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 623989 | 116 | 3 | 100.248120301625 | 15.7518796983752 | 113 | 0.480777706017254 | 2.52438419561486 | 0.15712892821313 | weekly | |||||||||
9316 | 9316 | United States | Virginia | VA | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 8535519 | 1614 | 120 | 1357.74185463726 | 256.25814536274 | 1494 | 1.40588990546445 | 3.00225616465431 | 0.188738488459725 | weekly | |||||||||
9468 | 9468 | United States | Washington | WA | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 7614893 | 1325 | 100 | 1099.12280701839 | 225.877192981609 | 1225 | 1.31321608852547 | 2.96625563854422 | 0.205506783718145 | weekly | |||||||||
9620 | 9620 | United States | West Virginia | WV | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 1792147 | 524 | 65 | 442.691729324262 | 81.3082706757377 | 459 | 3.62693462087652 | 4.53691972119127 | 0.183667923500285 | weekly | |||||||||
9772 | 9772 | United States | Wisconsin | WI | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 5822434 | 1657 | 562 | 1088.41353383544 | 568.586466164564 | 1095 | 9.65232066177135 | 9.76544287431276 | 0.522399298142623 | weekly | |||||||||
9924 | 9924 | United States | Wyoming | WY | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 578759 | 135 | 41 | 93.9448621562478 | 41.0551378437522 | 94 | 7.08412309786975 | 7.09365000695492 | 0.437013125587112 | weekly | |||||||||
11972 | 11972 | Canada | Canada | 0 | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 38454328 | 6140 | 521 | 5686.88210818327 | 453.117891816734 | 5619 | 1.35485399718856 | 1.17832742212199 | 0.0796777360945649 | weekly | |||||||||
17023 | 17023 | South Africa | South Africa | 0 | 2020-11-15 | 2020-11-21 | 7 | 2020 | 47 | 59893884 | 10743 | 639 | 9330.02594142257 | 1412.97405857743 | 10104 | 1.06688689616456 | 2.35912912005745 | 0.151443743827575 | 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);