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 2020-12-05 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region_code, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2326 | 2326 | United States | Alabama | AL | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 4903185 | 1355 | 304 | 1072.02506264856 | 282.974937351441 | 1051 | 6.20005159911364 | 5.77124741064106 | 0.263962986697643 | weekly | |||||||||
2478 | 2478 | United States | Alaska | AK | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 731545 | 118 | 27 | 86.4085213060804 | 31.5914786939196 | 91 | 3.69081874662529 | 4.31846006656045 | 0.365606056166784 | weekly | |||||||||
2630 | 2630 | United States | Arizona | AZ | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 7278717 | 1696 | 301 | 1215.03258146167 | 480.967418538329 | 1395 | 4.13534418222332 | 6.60785985412441 | 0.395847342595316 | weekly | |||||||||
2782 | 2782 | United States | Arkansas | AR | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 3017825 | 944 | 184 | 646.621553886049 | 297.378446113951 | 760 | 6.09710635971271 | 9.85406529914593 | 0.459895659720548 | weekly | |||||||||
2934 | 2934 | United States | California | CA | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 39512223 | 7164 | 1198 | 5384.04761904825 | 1779.95238095175 | 5966 | 3.03197316941646 | 4.50481457586364 | 0.330597443948015 | weekly | |||||||||
3086 | 3086 | United States | Colorado | CO | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 5758736 | 1256 | 373 | 771.310776943445 | 484.689223056555 | 883 | 6.47711581152531 | 8.41659042985396 | 0.62839679872915 | weekly | |||||||||
3238 | 3238 | United States | Connecticut | CT | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 3565287 | 844 | 185 | 635.596491228837 | 208.403508771163 | 659 | 5.18892307968475 | 5.84535014351336 | 0.32788649976378 | weekly | |||||||||
3390 | 3390 | United States | Delaware | DE | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 973764 | 231 | 24 | 188.877192985413 | 42.1228070145871 | 207 | 2.46466289573244 | 4.32577164637295 | 0.223016905052376 | weekly | |||||||||
3542 | 3542 | United States | District of Columbia | DC | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 705749 | 153 | 17 | 121.854636591893 | 31.1453634081074 | 136 | 2.40878839360736 | 4.41309352306662 | 0.255594405590141 | weekly | |||||||||
3694 | 3694 | United States | Florida | FL | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 21477737 | 4911 | 632 | 4161.90726817148 | 749.092731828525 | 4279 | 2.94258189305512 | 3.4877637799016 | 0.179987847772888 | weekly | |||||||||
3846 | 3846 | United States | Georgia | GA | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 10617423 | 2171 | 196 | 1738.69674185513 | 432.303258144865 | 1975 | 1.84602233517493 | 4.07164015359344 | 0.248636376740208 | weekly | |||||||||
3998 | 3998 | United States | Hawaii | HI | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 1415872 | 237 | 21 | 235.531328321703 | 1.46867167829745 | 216 | 1.4831849206708 | 0.103729127936526 | 0.00623556827349714 | weekly | |||||||||
4150 | 4150 | United States | Idaho | ID | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 1787065 | 397 | 119 | 265.86466165494 | 131.13533834506 | 278 | 6.65896316026557 | 7.33802846259425 | 0.493240950221725 | weekly | |||||||||
4302 | 4302 | United States | Illinois | IL | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 12671821 | 3282 | 1180 | 2101.36842105316 | 1180.63157894684 | 2102 | 9.31200022475065 | 9.316984346187 | 0.561839402894961 | weekly | |||||||||
4454 | 4454 | United States | Indiana | IN | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 6732219 | 1943 | 544 | 1347.46115288358 | 595.538847116421 | 1399 | 8.08054521102181 | 8.84610032912508 | 0.441971069697975 | weekly | |||||||||
4606 | 4606 | United States | Iowa | IA | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 3155070 | 1002 | 279 | 620.398496241275 | 381.601503758725 | 723 | 8.84290998297977 | 12.09486647709 | 0.615090955362855 | weekly | |||||||||
4758 | 4758 | United States | Kansas | KS | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 2913314 | 870 | 257 | 526.393483710049 | 343.606516289951 | 613 | 8.82156883878634 | 11.7943522836862 | 0.652756021727689 | weekly | |||||||||
4910 | 4910 | United States | Kentucky | KY | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 4467673 | 1357 | 178 | 951.273182958666 | 405.726817041334 | 1179 | 3.98417699773462 | 9.08139017876495 | 0.426509255500544 | weekly | |||||||||
5062 | 5062 | United States | Louisiana | LA | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 4648794 | 1103 | 139 | 976.28320802097 | 126.71679197903 | 964 | 2.99002278870606 | 2.7257992498491 | 0.129795115738904 | weekly | |||||||||
5214 | 5214 | United States | Maine | ME | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 1344212 | 342 | 35 | 298.245614035841 | 43.7543859641585 | 307 | 2.60375595516183 | 3.25502122910363 | 0.146705882350043 | weekly | |||||||||
5366 | 5366 | United States | Maryland | MD | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 6045680 | 1258 | 221 | 991.774436091117 | 266.225563908883 | 1037 | 3.65550277222744 | 4.40356690908025 | 0.268433581488708 | weekly | |||||||||
5518 | 5518 | United States | Massachusetts | MA | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 6949503 | 1331 | 277 | 1219.45864661733 | 111.541353382667 | 1054 | 3.98589654540764 | 1.6050263361663 | 0.0914679261097311 | weekly | |||||||||
5670 | 5670 | United States | Michigan | MI | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 9986857 | 2805 | 855 | 1949.19799498837 | 855.802005011634 | 1950 | 8.56125205357401 | 8.56928265831417 | 0.439053398993847 | weekly | |||||||||
5822 | 5822 | United States | Minnesota | MN | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 5639632 | 1334 | 398 | 907.939849624874 | 426.060150375126 | 936 | 7.05719805831303 | 7.55475091947712 | 0.469260326607713 | weekly | |||||||||
5974 | 5974 | United States | Mississippi | MS | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 2976149 | 850 | 170 | 631.624060151118 | 218.375939848882 | 680 | 5.71207960354136 | 7.33753383479397 | 0.345737209245378 | weekly | |||||||||
6126 | 6126 | United States | Missouri | MO | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 6137428 | 1962 | 360 | 1252.39348371009 | 709.606516289913 | 1602 | 5.86564925894039 | 11.5619526011533 | 0.566600294172544 | weekly | |||||||||
6278 | 6278 | United States | Montana | MT | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 1068778 | 270 | 64 | 187.090225564761 | 82.9097744352393 | 206 | 5.988147211114 | 7.75743647747608 | 0.443153960528742 | weekly | |||||||||
6430 | 6430 | United States | Nebraska | NE | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 1934408 | 514 | 210 | 328.260651630155 | 185.739348369845 | 304 | 10.856034507715 | 9.60187035877878 | 0.565828854136056 | weekly | |||||||||
6582 | 6582 | United States | Nevada | NV | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 3080156 | 773 | 170 | 496.187969925681 | 276.812030074319 | 603 | 5.51920097553501 | 8.98694839074121 | 0.557877350625368 | weekly | |||||||||
6734 | 6734 | United States | New Hampshire | NH | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 1359711 | 313 | 45 | 238.155388472025 | 74.8446115279754 | 268 | 3.30952680385758 | 5.5044499550254 | 0.314267974401793 | weekly | |||||||||
6886 | 6886 | United States | New Jersey | NJ | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 8882190 | 1904 | 339 | 1518.11779448722 | 385.882205512775 | 1565 | 3.8166263049991 | 4.34444889731896 | 0.254184627117894 | weekly | |||||||||
7038 | 7038 | United States | New Mexico | NM | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 2096829 | 662 | 211 | 377.641604010882 | 284.358395989118 | 451 | 10.0628138966029 | 13.5613536434835 | 0.752984822034927 | weekly | |||||||||
7190 | 7190 | United States | New York | NY | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 19453561 | 3569 | 461 | 3077.23308270759 | 491.766917292409 | 3108 | 2.3697460840203 | 2.52790179285124 | 0.159808147148774 | weekly | |||||||||
7342 | 7342 | United States | North Carolina | NC | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 10488084 | 2378 | 377 | 1982.70426065222 | 395.29573934778 | 2001 | 3.59455549745788 | 3.76899860210673 | 0.199372012857704 | weekly | |||||||||
7494 | 7494 | United States | North Dakota | ND | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 762062 | 283 | 92 | 148.117794487097 | 134.882205512903 | 191 | 12.0725085360509 | 17.6996367110423 | 0.910641466003281 | weekly | |||||||||
7646 | 7646 | United States | Ohio | OH | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 11689100 | 3910 | 544 | 2446.48370927518 | 1463.51629072482 | 3366 | 4.6539083419596 | 12.5203505036728 | 0.598212154520505 | weekly | |||||||||
7798 | 7798 | United States | Oklahoma | OK | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 3956971 | 1321 | 477 | 766.598997494515 | 554.401002505485 | 844 | 12.0546751543036 | 14.0107421182891 | 0.723195574632161 | weekly | |||||||||
7950 | 7950 | United States | Oregon | OR | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 4217737 | 936 | 131 | 715.388471178856 | 220.611528821144 | 805 | 3.10593097672994 | 5.23056626862093 | 0.308380044841383 | weekly | |||||||||
8102 | 8102 | United States | Pennsylvania | PA | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 12801989 | 3903 | 987 | 2670.9523809535 | 1232.0476190465 | 2916 | 7.70973947876381 | 9.6238765636066 | 0.461276519878151 | weekly | |||||||||
8254 | 8254 | United States | Rhode Island | RI | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 1059361 | 289 | 62 | 223.68922305853 | 65.3107769414703 | 227 | 5.85258471852371 | 6.16511056584774 | 0.291971048262711 | weekly | |||||||||
8406 | 8406 | United States | South Carolina | SC | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 5148714 | 1287 | 164 | 1011.1378446125 | 275.862155387503 | 1123 | 3.18526140702319 | 5.35788461715883 | 0.272823489752006 | weekly | |||||||||
8558 | 8558 | United States | South Dakota | SD | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 884659 | 305 | 148 | 160.275689223792 | 144.724310776208 | 157 | 16.7296099401012 | 16.3593328928105 | 0.902971071140617 | weekly | |||||||||
8710 | 8710 | United States | Tennessee | TN | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 6833174 | 2200 | 350 | 1561.02756892321 | 638.972431076787 | 1850 | 5.12207065120836 | 9.35103410328475 | 0.40932808862405 | weekly | |||||||||
8862 | 8862 | United States | Texas | TX | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 28995881 | 5636 | 1348 | 4110.11779448675 | 1525.88220551325 | 4288 | 4.64893617131344 | 5.26241022134575 | 0.371250237051611 | weekly | |||||||||
9014 | 9014 | United States | Utah | UT | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 3205958 | 538 | 76 | 385.441102757743 | 152.558897242257 | 462 | 2.37058626469841 | 4.75860561000042 | 0.395803395514213 | weekly | |||||||||
9166 | 9166 | United States | Vermont | VT | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 623989 | 133 | 12 | 106.248120301624 | 26.7518796983763 | 121 | 1.92311082406901 | 4.28723578434496 | 0.251786851592587 | weekly | |||||||||
9318 | 9318 | United States | Virginia | VA | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 8535519 | 1629 | 143 | 1397.40852130394 | 231.591478696063 | 1486 | 1.67535213734513 | 2.7132676840865 | 0.165729258957118 | weekly | |||||||||
9470 | 9470 | United States | Washington | WA | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 7614893 | 1354 | 137 | 1102.12280701839 | 251.877192981605 | 1217 | 1.7991060412799 | 3.30769182156079 | 0.228538227661776 | weekly | |||||||||
9622 | 9622 | United States | West Virginia | WV | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 1792147 | 637 | 111 | 463.35839599093 | 173.64160400907 | 526 | 6.19368835257376 | 9.68902684930811 | 0.374745781044332 | weekly | |||||||||
9774 | 9774 | United States | Wisconsin | WI | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 5822434 | 1652 | 517 | 1075.74686716878 | 576.253132831223 | 1135 | 8.87944801091777 | 9.89711747408769 | 0.535677258673171 | weekly | |||||||||
9926 | 9926 | United States | Wyoming | WY | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 578759 | 123 | 42 | 90.6115288229166 | 32.3884711770834 | 81 | 7.2569065880617 | 5.59619309195769 | 0.357443159803436 | weekly | |||||||||
11974 | 11974 | Canada | Canada | 0 | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 38454328 | 6500 | 633 | 5746.88210818327 | 753.117891816734 | 5867 | 1.64610859927132 | 1.95847367770081 | 0.131048084446404 | weekly | |||||||||
17025 | 17025 | South Africa | South Africa | 0 | 2020-11-29 | 2020-12-05 | 7 | 2020 | 49 | 59893884 | 11881 | 628 | 10049.6259414226 | 1831.37405857743 | 11253 | 1.04852108105061 | 3.05769794220964 | 0.182233057155773 | 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);