economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where "start_date" is on date 2020-11-22 sorted by covid_deaths_per_100k
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6733 | 6733 | United States | New Hampshire | NH | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 1359711 | 284 | 6 | 244.155388472011 | 39.8446115279885 | 278 | 0.441270240514345 | 2.93037355202602 | 0.163193660305212 | weekly | |||||||||
3997 | 3997 | United States | Hawaii | HI | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 1415872 | 216 | 9 | 233.864661655022 | -17.8646616550224 | 207 | 0.635650680287484 | -1.26174270379119 | -0.0763888888923923 | weekly | |||||||||
9165 | 9165 | United States | Vermont | VT | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 623989 | 129 | 5 | 105.248120301613 | 23.7518796983872 | 124 | 0.801296176695423 | 3.80645807832945 | 0.225675096432323 | weekly | |||||||||
17024 | 17024 | South Africa | South Africa | 0 | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 59893884 | 10603 | 594 | 9990.62594142257 | 612.374058577427 | 10009 | 0.991754016152968 | 1.0224317036735 | 0.0612948640223272 | weekly | |||||||||
9469 | 9469 | United States | Washington | WA | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 7614893 | 1246 | 81 | 1112.78947368505 | 133.210526314952 | 1165 | 1.06370503170563 | 1.74934206317741 | 0.119708650616383 | weekly | |||||||||
5213 | 5213 | United States | Maine | ME | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 1344212 | 349 | 15 | 300.578947369162 | 48.4210526308385 | 334 | 1.11589540935507 | 3.60218868979286 | 0.16109262825839 | weekly | |||||||||
3541 | 3541 | United States | District of Columbia | DC | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 705749 | 120 | 8 | 112.521303258546 | 7.47869674145392 | 112 | 1.13354747934464 | 1.05968223000726 | 0.066464718456644 | weekly | |||||||||
7341 | 7341 | United States | North Carolina | NC | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 10488084 | 2320 | 133 | 1850.70426065221 | 469.295739347795 | 2187 | 1.26810578557533 | 4.47456121964502 | 0.253576840625206 | weekly | |||||||||
11973 | 11973 | Canada | Canada | 0 | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 38454328 | 6305 | 561 | 5707.88210818327 | 597.117891816734 | 5744 | 1.4588734979324 | 1.55279762479982 | 0.104612863492863 | weekly | |||||||||
3845 | 3845 | United States | Georgia | GA | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 10617423 | 2070 | 158 | 1728.03007518846 | 341.969924811544 | 1912 | 1.48812004570224 | 3.22083734265409 | 0.197895817741627 | weekly | |||||||||
9317 | 9317 | United States | Virginia | VA | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 8535519 | 1595 | 144 | 1408.74185463725 | 186.258145362747 | 1451 | 1.68706788655734 | 2.18215371980013 | 0.132215951950053 | weekly | |||||||||
7189 | 7189 | United States | New York | NY | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 19453561 | 3375 | 338 | 3053.23308270758 | 321.766917292424 | 3037 | 1.73747109847909 | 1.65402579657485 | 0.105385638297579 | weekly | |||||||||
7949 | 7949 | United States | Oregon | OR | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 4217737 | 880 | 77 | 703.721804512176 | 176.278195487824 | 803 | 1.82562355120767 | 4.17944967853196 | 0.250494150326947 | weekly | |||||||||
2933 | 2933 | United States | California | CA | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 39512223 | 6390 | 767 | 5069.38095238158 | 1320.61904761842 | 5623 | 1.94117146990186 | 3.34230510801283 | 0.260508937880867 | weekly | |||||||||
3389 | 3389 | United States | Delaware | DE | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 973764 | 199 | 21 | 181.877192985399 | 17.1228070146006 | 178 | 2.15658003376588 | 1.75841446331971 | 0.0941448827834896 | weekly | |||||||||
4909 | 4909 | United States | Kentucky | KY | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 4467673 | 1332 | 102 | 948.273182958653 | 383.726817041347 | 1230 | 2.28306771780298 | 8.58896380825872 | 0.404658513957025 | weekly | |||||||||
2629 | 2629 | United States | Arizona | AZ | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 7278717 | 1531 | 168 | 1183.69924812832 | 347.300751871679 | 1363 | 2.30809907845023 | 4.77145562702437 | 0.293402865990525 | weekly | |||||||||
2325 | 2325 | United States | Alabama | AL | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 4903185 | 1326 | 115 | 1060.35839598264 | 265.641604017364 | 1211 | 2.34541425624365 | 5.41773569664134 | 0.250520583440274 | weekly | |||||||||
3693 | 3693 | United States | Florida | FL | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 21477737 | 4634 | 507 | 4058.90726817145 | 575.092731828553 | 4127 | 2.36058389205529 | 2.67762256250998 | 0.141686590461978 | weekly | |||||||||
6885 | 6885 | United States | New Jersey | NJ | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 8882190 | 1697 | 219 | 1429.11779448721 | 267.882205512788 | 1478 | 2.46560814393747 | 3.01594770560851 | 0.18744585404096 | weekly | |||||||||
5365 | 5365 | United States | Maryland | MD | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 6045680 | 1185 | 161 | 1009.7744360911 | 175.225563908897 | 1024 | 2.66305858067248 | 2.89835988522213 | 0.173529411763687 | weekly | |||||||||
5517 | 5517 | United States | Massachusetts | MA | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 6949503 | 1261 | 188 | 1151.79197995065 | 109.208020049346 | 1073 | 2.70522942431998 | 1.57145079366605 | 0.0948157496755837 | weekly | |||||||||
9013 | 9013 | United States | Utah | UT | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 3205958 | 487 | 88 | 389.107769424393 | 97.892230575607 | 399 | 2.74488935912448 | 3.05344706872663 | 0.251581279706696 | weekly | |||||||||
8405 | 8405 | United States | South Carolina | SC | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 5148714 | 1214 | 153 | 1014.47117794581 | 199.528822054186 | 1061 | 2.97161582484481 | 3.87531375901218 | 0.196682593248444 | weekly | |||||||||
8253 | 8253 | United States | Rhode Island | RI | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 1059361 | 268 | 33 | 203.022556391849 | 64.9774436081505 | 235 | 3.11508541469811 | 6.13364505660965 | 0.320050366633838 | weekly | |||||||||
3085 | 3085 | United States | Colorado | CO | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 5758736 | 1216 | 196 | 774.644110276766 | 441.355889723234 | 1020 | 3.40352466235646 | 7.66411048749645 | 0.569753108386179 | weekly | |||||||||
6581 | 6581 | United States | Nevada | NV | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 3080156 | 744 | 105 | 518.187969925667 | 225.812030074333 | 639 | 3.40891824959515 | 7.33118809808118 | 0.435772428500657 | weekly | |||||||||
2781 | 2781 | United States | Arkansas | AR | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 3017825 | 833 | 107 | 644.954887219369 | 188.045112780631 | 726 | 3.54559989396337 | 6.23114702743303 | 0.29156320311233 | weekly | |||||||||
2477 | 2477 | United States | Alaska | AK | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 731545 | 114 | 26 | 100.408521306068 | 13.5914786939322 | 88 | 3.55412175600954 | 1.85791423547864 | 0.135361805125108 | weekly | |||||||||
3237 | 3237 | United States | Connecticut | CT | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 3565287 | 757 | 133 | 633.596491228822 | 123.403508771178 | 624 | 3.73041497080039 | 3.46125035014511 | 0.194766717429013 | weekly | |||||||||
5061 | 5061 | United States | Louisiana | LA | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 4648794 | 1084 | 174 | 927.949874687623 | 156.050125312377 | 910 | 3.74290622471118 | 3.35678727240607 | 0.16816654602697 | weekly | |||||||||
4149 | 4149 | United States | Idaho | ID | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 1787065 | 424 | 68 | 274.19799498826 | 149.80200501174 | 356 | 3.80512180586604 | 8.38257170342096 | 0.546327864352741 | weekly | |||||||||
4757 | 4757 | United States | Kansas | KS | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 2913314 | 814 | 119 | 510.060150376702 | 303.939849623298 | 695 | 4.08469529889329 | 10.4327871840556 | 0.595890209025004 | weekly | |||||||||
5973 | 5973 | United States | Mississippi | MS | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 2976149 | 820 | 122 | 623.290726817771 | 196.709273182229 | 698 | 4.09925712724733 | 6.60952368924502 | 0.315597946060475 | weekly | |||||||||
6429 | 6429 | United States | Nebraska | NE | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 1934408 | 565 | 81 | 297.593984963475 | 267.406015036525 | 484 | 4.18732759583294 | 13.8236615562242 | 0.898559878719811 | weekly | |||||||||
6125 | 6125 | United States | Missouri | MO | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 6137428 | 1908 | 269 | 1225.72681704341 | 682.273182956594 | 1639 | 4.38294347404157 | 11.1165977500118 | 0.556627442159025 | weekly | |||||||||
8861 | 8861 | United States | Texas | TX | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 28995881 | 5595 | 1277 | 4120.78446115339 | 1474.21553884661 | 4318 | 4.40407380620716 | 5.08422399321686 | 0.357751188576842 | weekly | |||||||||
9621 | 9621 | United States | West Virginia | WV | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 1792147 | 570 | 80 | 426.691729324251 | 143.308270675749 | 490 | 4.46391953338649 | 7.99645735956643 | 0.335859030834053 | weekly | |||||||||
8101 | 8101 | United States | Pennsylvania | PA | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 12801989 | 3659 | 586 | 2638.61904762016 | 1020.38095237984 | 3073 | 4.57741371282228 | 7.97048765140982 | 0.386710219991838 | weekly | |||||||||
8709 | 8709 | United States | Tennessee | TN | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 6833174 | 1919 | 324 | 1506.69423558986 | 412.305764410139 | 1595 | 4.74157397426145 | 6.033883586312 | 0.273649261191156 | weekly | |||||||||
5821 | 5821 | United States | Minnesota | MN | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 5639632 | 1397 | 280 | 888.273182958197 | 508.726817041803 | 1117 | 4.9648629555971 | 9.02056760160598 | 0.572714370761033 | weekly | |||||||||
7645 | 7645 | United States | Ohio | OH | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 11689100 | 3568 | 657 | 2406.81704260849 | 1161.18295739151 | 2911 | 5.62062092034459 | 9.93389531607659 | 0.482455848049433 | weekly | |||||||||
5669 | 5669 | United States | Michigan | MI | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 9986857 | 2661 | 588 | 1919.19799498835 | 741.802005011647 | 2073 | 5.88773825438774 | 7.42778238450442 | 0.386516663183649 | weekly | |||||||||
4605 | 4605 | United States | Iowa | IA | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 3155070 | 976 | 192 | 588.065162907927 | 387.934837092073 | 784 | 6.08544342914737 | 12.2956015902047 | 0.659680017727579 | weekly | |||||||||
4453 | 4453 | United States | Indiana | IN | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 6732219 | 2015 | 417 | 1273.12781955023 | 741.872180449769 | 1598 | 6.19409439888988 | 11.0197273803744 | 0.582716180620307 | weekly | |||||||||
6277 | 6277 | United States | Montana | MT | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 1068778 | 307 | 71 | 204.423558898081 | 102.576441101919 | 236 | 6.6431008123296 | 9.59754421422587 | 0.501783853362323 | weekly | |||||||||
4301 | 4301 | United States | Illinois | IL | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 12671821 | 3151 | 885 | 2057.70175438648 | 1093.29824561352 | 2266 | 6.98400016856299 | 8.62779110921405 | 0.531320072640699 | weekly | |||||||||
9773 | 9773 | United States | Wisconsin | WI | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 5822434 | 1636 | 484 | 1035.41353383543 | 600.586466164571 | 1152 | 8.31267473362515 | 10.3150412038088 | 0.580045022146707 | weekly | |||||||||
7037 | 7037 | United States | New Mexico | NM | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 2096829 | 601 | 177 | 392.974937344202 | 208.025062655798 | 424 | 8.44131781847733 | 9.92093597788842 | 0.529359617846548 | weekly | |||||||||
9925 | 9925 | United States | Wyoming | WY | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 578759 | 138 | 51 | 110.944862156236 | 27.0551378437637 | 87 | 8.8119579997892 | 4.67468114426967 | 0.243861115494143 | weekly | |||||||||
7797 | 7797 | United States | Oklahoma | OK | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 3956971 | 1148 | 374 | 790.932330827836 | 357.067669172164 | 774 | 9.45167402035547 | 9.02376259952787 | 0.451451603702223 | weekly | |||||||||
7493 | 7493 | United States | North Dakota | ND | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 762062 | 248 | 81 | 150.451127820419 | 97.5488721795811 | 167 | 10.6290564284796 | 12.8006477398927 | 0.648375812084421 | weekly | |||||||||
8557 | 8557 | United States | South Dakota | SD | 2020-11-22 | 2020-11-28 | 7 | 2020 | 48 | 884659 | 335 | 201 | 160.942355890446 | 174.057644109554 | 134 | 22.7206189051375 | 19.6751114394986 | 1.08149059423509 | 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);