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 2021-01-09 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2331 | 2331 | United States | Alabama | AL | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 4903185 | 1811 | 428 | 1142.86466166558 | 668.135338334419 | 1383 | 8.72902001454157 | 13.6265578054758 | 0.584614574888242 | weekly | |||||||||
2483 | 2483 | United States | Alaska | AK | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 731545 | 113 | 12 | 95.8439849657212 | 17.1560150342788 | 101 | 1.64036388738902 | 2.3451756261445 | 0.17899939198495 | weekly | |||||||||
2635 | 2635 | United States | Arizona | AZ | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 7278717 | 2426 | 975 | 1398.12406015953 | 1027.87593984047 | 1451 | 13.3952178660058 | 14.1216637470651 | 0.735182212459156 | weekly | |||||||||
2787 | 2787 | United States | Arkansas | AR | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 3017825 | 963 | 281 | 695.943609024003 | 267.056390975997 | 682 | 9.31134177760473 | 8.84930010772648 | 0.383732801786223 | weekly | |||||||||
2939 | 2939 | United States | California | CA | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 39512223 | 11908 | 4762 | 6165.39285714339 | 5742.60714285661 | 7146 | 12.0519668053098 | 14.5337485639738 | 0.931425989538213 | weekly | |||||||||
3091 | 3091 | United States | Colorado | CO | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 5758736 | 1080 | 278 | 871.221804512333 | 208.778195487667 | 802 | 4.82744824558723 | 3.62541702706404 | 0.239638395648891 | weekly | |||||||||
3243 | 3243 | United States | Connecticut | CT | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 3565287 | 860 | 225 | 653.328947369097 | 206.671052630903 | 635 | 6.31085239421118 | 5.79675781026613 | 0.316335367448742 | weekly | |||||||||
3395 | 3395 | United States | Delaware | DE | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 973764 | 276 | 39 | 202.013157898108 | 73.9868421018921 | 237 | 4.00507720556521 | 7.59802602087283 | 0.366247638875136 | weekly | |||||||||
3547 | 3547 | United States | District of Columbia | DC | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 705749 | 173 | 21 | 135.234962406438 | 37.7650375935618 | 152 | 2.97556213327968 | 5.3510578964422 | 0.279254986443978 | weekly | |||||||||
3699 | 3699 | United States | Florida | FL | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 21477737 | 5495 | 917 | 4381.30075188069 | 1113.69924811931 | 4578 | 4.26953733533472 | 5.18536588896356 | 0.254193745462748 | weekly | |||||||||
3851 | 3851 | United States | Georgia | GA | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 10617423 | 2873 | 389 | 1894.03759398547 | 978.962406014532 | 2484 | 3.66378922644412 | 9.22033911632354 | 0.516865351101391 | weekly | |||||||||
4003 | 4003 | United States | Hawaii | HI | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 1415872 | 215 | 38 | 250.580827068551 | -35.5808270685512 | 177 | 2.68385842788049 | -2.51299743681288 | -0.141993413801038 | weekly | |||||||||
4155 | 4155 | United States | Idaho | ID | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 1787065 | 389 | 80 | 298.830827068439 | 90.1691729315608 | 309 | 4.47661388925417 | 5.04565714909983 | 0.301739863373968 | weekly | |||||||||
4307 | 4307 | United States | Illinois | IL | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 12671821 | 2794 | 992 | 2255.2105263163 | 538.7894736837 | 1802 | 7.8283934092819 | 4.25187093223381 | 0.238908725990991 | weekly | |||||||||
4459 | 4459 | United States | Indiana | IN | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 6732219 | 1984 | 556 | 1453.90977443758 | 530.09022556242 | 1428 | 8.25879253185317 | 7.87393020878287 | 0.364596369652633 | weekly | |||||||||
4611 | 4611 | United States | Iowa | IA | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 3155070 | 801 | 183 | 660.498120301373 | 140.501879698627 | 618 | 5.80018826840609 | 4.45320958643159 | 0.212721089402221 | weekly | |||||||||
4763 | 4763 | United States | Kansas | KS | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 2913314 | 789 | 270 | 597.825187970677 | 191.174812029323 | 519 | 9.2677960563125 | 6.56210803330239 | 0.319783802817456 | weekly | |||||||||
4915 | 4915 | United States | Kentucky | KY | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 4467673 | 1295 | 178 | 1057.67481203143 | 237.325187968568 | 1117 | 3.98417699773462 | 5.31205367914276 | 0.224383889328656 | weekly | |||||||||
5067 | 5067 | United States | Louisiana | LA | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 4648794 | 1403 | 347 | 972.27067669262 | 430.72932330738 | 1056 | 7.46430149410793 | 9.26539922628063 | 0.443013796088755 | weekly | |||||||||
5219 | 5219 | United States | Maine | ME | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 1344212 | 345 | 42 | 313.22368421125 | 31.7763157887501 | 303 | 3.1245071461942 | 2.36393632765889 | 0.101449275359774 | weekly | |||||||||
5371 | 5371 | United States | Maryland | MD | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 6045680 | 1364 | 288 | 1065.71804511366 | 298.28195488634 | 1076 | 4.76373211946381 | 4.93380322621012 | 0.279888246477545 | weekly | |||||||||
5523 | 5523 | United States | Massachusetts | MA | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 6949503 | 1557 | 572 | 1252.82330827145 | 304.176691728549 | 985 | 8.2308044186757 | 4.37695604604457 | 0.242792969862788 | weekly | |||||||||
5675 | 5675 | United States | Michigan | MI | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 9986857 | 2356 | 841 | 2095.83082706852 | 260.169172931481 | 1515 | 8.42106780942192 | 2.60511563279099 | 0.124136533145371 | weekly | |||||||||
5827 | 5827 | United States | Minnesota | MN | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 5639632 | 1140 | 286 | 982.174812030869 | 157.825187969131 | 854 | 5.07125287607418 | 2.79850153288603 | 0.160689508665766 | weekly | |||||||||
5979 | 5979 | United States | Mississippi | MS | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 2976149 | 1050 | 261 | 704.280075188689 | 345.719924811311 | 789 | 8.76972221484879 | 11.6163513591326 | 0.490884148211472 | weekly | |||||||||
6131 | 6131 | United States | Missouri | MO | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 6137428 | 1754 | 401 | 1407.07518797073 | 346.924812029275 | 1353 | 6.53368153565305 | 5.6526090738543 | 0.246557408584262 | weekly | |||||||||
6283 | 6283 | United States | Montana | MT | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 1068778 | 248 | 82 | 216.112781955725 | 31.8872180442748 | 166 | 7.67231361423981 | 2.98352118440638 | 0.147548968440042 | weekly | |||||||||
6435 | 6435 | United States | Nebraska | NE | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 1934408 | 447 | 71 | 377.242481204085 | 69.7575187959148 | 376 | 3.67037357165603 | 3.60614300581443 | 0.184914272043971 | weekly | |||||||||
6587 | 6587 | United States | Nevada | NV | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 3080156 | 889 | 278 | 582.984962406868 | 306.015037593132 | 611 | 9.0255168894043 | 9.93504996477879 | 0.524910687798431 | weekly | |||||||||
6739 | 6739 | United States | New Hampshire | NH | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 1359711 | 323 | 77 | 250.36090225647 | 72.6390977435299 | 246 | 5.66296808660076 | 5.34224535533874 | 0.290137545794264 | weekly | |||||||||
6891 | 6891 | United States | New Jersey | NJ | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 8882190 | 2056 | 667 | 1584.56390977544 | 471.436090224565 | 1389 | 7.50940927856756 | 5.3076559972773 | 0.297517876884736 | weekly | |||||||||
7043 | 7043 | United States | New Mexico | NM | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 2096829 | 592 | 198 | 415.385338346715 | 176.614661653285 | 394 | 9.44283010202549 | 8.42294062383176 | 0.425182704705548 | weekly | |||||||||
7195 | 7195 | United States | New York | NY | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 19453561 | 4549 | 1190 | 3387.79135338428 | 1161.20864661572 | 3359 | 6.11713197393526 | 5.96913154674212 | 0.34276273993548 | weekly | |||||||||
7347 | 7347 | United States | North Carolina | NC | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 10488084 | 2951 | 534 | 2070.29699248181 | 880.703007518188 | 2417 | 5.09149240223476 | 8.39717728727371 | 0.425399356090658 | weekly | |||||||||
7499 | 7499 | United States | North Dakota | ND | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 762062 | 157 | 42 | 148.563909775321 | 8.43609022467859 | 115 | 5.51136259254496 | 1.107008383134 | 0.0567842502087943 | weekly | |||||||||
7651 | 7651 | United States | Ohio | OH | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 11689100 | 3680 | 582 | 2636.18796992691 | 1043.81203007309 | 3098 | 4.97899752761119 | 8.92978954815248 | 0.395955084379674 | weekly | |||||||||
7803 | 7803 | United States | Oklahoma | OK | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 3956971 | 1259 | 493 | 865.915413534592 | 393.084586465408 | 766 | 12.459024845014 | 9.93397693501944 | 0.453952638238498 | weekly | |||||||||
7955 | 7955 | United States | Oregon | OR | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 4217737 | 885 | 98 | 804.152255640013 | 80.8477443599872 | 787 | 2.32352088335522 | 1.91685124890403 | 0.100537856846079 | weekly | |||||||||
8107 | 8107 | United States | Pennsylvania | PA | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 12801989 | 4009 | 1428 | 2812.85714285826 | 1196.14285714174 | 2581 | 11.1545166926796 | 9.34341419244882 | 0.425241239207152 | weekly | |||||||||
8259 | 8259 | United States | Rhode Island | RI | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 1059361 | 295 | 132 | 226.778195489604 | 68.2218045103959 | 163 | 12.4603416587924 | 6.43990146044606 | 0.300830528980567 | weekly | |||||||||
8411 | 8411 | United States | South Carolina | SC | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 5148714 | 1590 | 374 | 1060.75563909871 | 529.244360901293 | 1216 | 7.26394979406508 | 10.2791563272167 | 0.498931461114811 | weekly | |||||||||
8563 | 8563 | United States | South Dakota | SD | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 884659 | 220 | 69 | 172.761278196208 | 47.2387218037923 | 151 | 7.79961544504719 | 5.3397661476108 | 0.273433504874527 | weekly | |||||||||
8715 | 8715 | United States | Tennessee | TN | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 6833174 | 2427 | 663 | 1667.95112782045 | 759.048872179548 | 1764 | 9.70266526214611 | 11.108291288639 | 0.455078604833832 | weekly | |||||||||
8867 | 8867 | United States | Texas | TX | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 28995881 | 6972 | 2360 | 4524.56390977498 | 2447.43609022502 | 4612 | 8.13908706550423 | 8.44063365491473 | 0.540921984754713 | weekly | |||||||||
9019 | 9019 | United States | Utah | UT | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 3205958 | 533 | 97 | 426.718045113626 | 106.281954886374 | 436 | 3.02561667994403 | 3.31513871630177 | 0.249068339395099 | weekly | |||||||||
9171 | 9171 | United States | Vermont | VT | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 623989 | 108 | 17 | 113.310150376809 | -5.31015037680868 | 91 | 2.72440700076444 | -0.85100063892291 | -0.0468638542897523 | weekly | |||||||||
9323 | 9323 | United States | Virginia | VA | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 8535519 | 2016 | 266 | 1473.34398496308 | 542.656015036921 | 1750 | 3.11638929044619 | 6.35762178066642 | 0.368315899460857 | weekly | |||||||||
9475 | 9475 | United States | Washington | WA | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 7614893 | 1427 | 447 | 1245.73684210611 | 181.263157893895 | 980 | 5.87007591570886 | 2.38037695203196 | 0.145506781020815 | weekly | |||||||||
9627 | 9627 | United States | West Virginia | WV | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 1792147 | 722 | 197 | 510.114661655103 | 211.885338344897 | 525 | 10.9924018509642 | 11.8229887584499 | 0.415368061873422 | weekly | |||||||||
9779 | 9779 | United States | Wisconsin | WI | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 5822434 | 1378 | 277 | 1167.76691729408 | 210.233082705916 | 1101 | 4.75746053969869 | 3.61074222062313 | 0.180030003926693 | weekly | |||||||||
9931 | 9931 | United States | Wyoming | WY | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 578759 | 127 | 51 | 113.847744361761 | 13.1522556382387 | 76 | 8.8119579997892 | 2.27249263307157 | 0.115524955825618 | weekly | |||||||||
11979 | 11979 | Canada | Canada | 0 | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 38454328 | 6810 | 1027 | 6467.69579288156 | 342.304207118435 | 5783 | 2.67070068159818 | 0.89015781817442 | 0.0529252175860195 | weekly | |||||||||
17030 | 17030 | South Africa | South Africa | 0 | 2021-01-03 | 2021-01-09 | 7 | 2021 | 1 | 59893884 | 23511 | 3649 | 10221.4635983266 | 13289.5364016734 | 19862 | 6.09244175916192 | 22.1884698639237 | 1.30015983267299 | 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);