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 2021-02-28 sorted by week
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region_code, total_deaths, covid_deaths, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2339 | 2339 | United States | Alabama | AL | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 4903185 | 1162 | 218 | 1080.86466164263 | 81.1353383573698 | 944 | 4.44608963357491 | 1.65474764581328 | 0.0750652151343958 | weekly | |||||||||
2491 | 2491 | United States | Alaska | AK | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 731545 | 97 | 5 | 90.0939849657441 | 6.90601503425593 | 92 | 0.683484953078758 | 0.944031472329922 | 0.0766534529123311 | weekly | |||||||||
2643 | 2643 | United States | Arizona | AZ | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 7278717 | 1495 | 289 | 1322.37406015956 | 172.625939840437 | 1206 | 3.97047996233402 | 2.37165340870427 | 0.130542442597224 | weekly | |||||||||
2795 | 2795 | United States | Arkansas | AR | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 3017825 | 742 | 19 | 651.69360902402 | 90.3063909759798 | 723 | 0.629592504535551 | 2.99243299316494 | 0.138571852977388 | weekly | |||||||||
2947 | 2947 | United States | California | CA | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 39512223 | 6452 | 919 | 5698.8928571434 | 753.107142856596 | 5533 | 2.32586255650562 | 1.90601055996418 | 0.132149728330582 | weekly | |||||||||
3099 | 3099 | United States | Colorado | CO | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 5758736 | 867 | 40 | 831.471804512346 | 35.5281954876542 | 827 | 0.694596869868666 | 0.616944334445167 | 0.0427292847392358 | weekly | |||||||||
3251 | 3251 | United States | Connecticut | CT | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 3565287 | 648 | 77 | 634.078947369111 | 13.9210526308892 | 571 | 2.15971393046338 | 0.390460925891498 | 0.0219547623977263 | weekly | |||||||||
3403 | 3403 | United States | Delaware | DE | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 973764 | 217 | 42 | 178.013157898131 | 38.9868421018688 | 175 | 4.31316006753176 | 4.00372596459397 | 0.219011013355424 | weekly | |||||||||
3555 | 3555 | United States | District of Columbia | DC | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 705749 | 134 | 25 | 122.984962406452 | 11.0150375935482 | 109 | 3.542335872952 | 1.56075851238162 | 0.0895641009926456 | weekly | |||||||||
3707 | 3707 | United States | Florida | FL | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 21477737 | 4821 | 886 | 4347.30075188071 | 473.699248119288 | 3935 | 4.12520183108677 | 2.20553612384437 | 0.108963992867151 | weekly | |||||||||
3859 | 3859 | United States | Georgia | GA | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 10617423 | 1939 | 536 | 1751.28759398548 | 187.712406014519 | 1403 | 5.04830597782532 | 1.76796578618483 | 0.107185368445016 | weekly | |||||||||
4011 | 4011 | United States | Hawaii | HI | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 1415872 | 231 | 5 | 238.580827068563 | -7.5808270685626 | 226 | 0.35313926682638 | -0.535417542585954 | -0.0317746700843821 | weekly | |||||||||
4163 | 4163 | United States | Idaho | ID | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 1787065 | 307 | 17 | 299.33082706845 | 7.66917293154989 | 290 | 0.951280451466511 | 0.429149075805855 | 0.0256210595034909 | weekly | |||||||||
4315 | 4315 | United States | Illinois | IL | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 12671821 | 2179 | 291 | 2118.96052631631 | 60.0394736836897 | 1888 | 2.29643395373088 | 0.473803044437652 | 0.0283343993142076 | weekly | |||||||||
4467 | 4467 | United States | Indiana | IN | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 6732219 | 1415 | 168 | 1363.9097744376 | 51.0902255624046 | 1247 | 2.49546249163909 | 0.758891318930721 | 0.0374586549051394 | weekly | |||||||||
4619 | 4619 | United States | Iowa | IA | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 3155070 | 618 | 79 | 624.248120301387 | -6.24812030138719 | 539 | 2.50390641095126 | -0.198034284544786 | -0.0100090334246751 | weekly | |||||||||
4771 | 4771 | United States | Kansas | KS | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 2913314 | 553 | 94 | 555.325187970687 | -2.32518797068701 | 459 | 3.22656603441991 | -0.0798124737219198 | -0.00418707456649658 | weekly | |||||||||
4923 | 4923 | United States | Kentucky | KY | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 4467673 | 1075 | 181 | 1015.67481203145 | 59.3251879685492 | 894 | 4.05132604825823 | 1.32787668140773 | 0.0584096280283775 | weekly | |||||||||
5075 | 5075 | United States | Louisiana | LA | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 4648794 | 1078 | 127 | 908.770676692634 | 169.229323307366 | 951 | 2.73189132493288 | 3.64028441155634 | 0.18621785192636 | weekly | |||||||||
5227 | 5227 | United States | Maine | ME | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 1344212 | 327 | 4 | 294.723684211263 | 32.2763157887369 | 323 | 0.297572109161353 | 2.40113284130308 | 0.109513817578368 | weekly | |||||||||
5379 | 5379 | United States | Maryland | MD | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 6045680 | 1146 | 86 | 1047.96804511367 | 98.0319548863254 | 1060 | 1.42250334122878 | 1.62152073689519 | 0.0935447939881522 | weekly | |||||||||
5531 | 5531 | United States | Massachusetts | MA | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 6949503 | 1220 | 307 | 1242.57330827147 | -22.5733082714682 | 913 | 4.41758209184168 | -0.324819030533094 | -0.0181665806928283 | weekly | |||||||||
5683 | 5683 | United States | Michigan | MI | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 9986857 | 2023 | 151 | 2009.08082706853 | 13.9191729314682 | 1872 | 1.51198720478325 | 0.139374909758578 | 0.00692812989100977 | weekly | |||||||||
5835 | 5835 | United States | Minnesota | MN | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 5639632 | 931 | 69 | 911.424812030884 | 19.5751879691162 | 862 | 1.22348408548643 | 0.347100448559697 | 0.021477567552169 | weekly | |||||||||
5987 | 5987 | United States | Mississippi | MS | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 2976149 | 719 | 136 | 631.280075188702 | 87.7199248112981 | 583 | 4.56966368283308 | 2.94743054905175 | 0.138955636743449 | weekly | |||||||||
6139 | 6139 | United States | Missouri | MO | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 6137428 | 1366 | 248 | 1317.57518797074 | 48.4248120292605 | 1118 | 4.04078060060338 | 0.789008229982665 | 0.0367529781005074 | weekly | |||||||||
6291 | 6291 | United States | Montana | MT | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 1068778 | 190 | 24 | 216.362781955739 | -26.3627819557394 | 166 | 2.24555520416775 | -2.46662842571043 | -0.121845271711899 | weekly | |||||||||
6443 | 6443 | United States | Nebraska | NE | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 1934408 | 354 | 31 | 340.9924812041 | 13.0075187959004 | 323 | 1.60255747494841 | 0.672428918609746 | 0.0381460575024082 | weekly | |||||||||
6595 | 6595 | United States | Nevada | NV | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 3080156 | 558 | 77 | 562.234962406882 | -4.234962406882 | 481 | 2.49987338303644 | -0.137491815573043 | -0.00753237114382299 | weekly | |||||||||
6747 | 6747 | United States | New Hampshire | NH | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 1359711 | 246 | 11 | 239.110902256485 | 6.88909774351487 | 235 | 0.808995440942965 | 0.506658969701272 | 0.0288113075501895 | weekly | |||||||||
6899 | 6899 | United States | New Jersey | NJ | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 8882190 | 1715 | 318 | 1521.06390977545 | 193.936090224551 | 1397 | 3.58019812681332 | 2.18342649982213 | 0.127500290407378 | weekly | |||||||||
7051 | 7051 | United States | New Mexico | NM | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 2096829 | 453 | 97 | 406.885338346729 | 46.1146616532711 | 356 | 4.62603292877006 | 2.19925714749611 | 0.113335766387272 | weekly | |||||||||
7203 | 7203 | United States | New York | NY | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 19453561 | 3643 | 755 | 3155.04135338429 | 487.95864661571 | 2888 | 3.88103751287489 | 2.50832557913541 | 0.154659984438015 | weekly | |||||||||
7355 | 7355 | United States | North Carolina | NC | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 10488084 | 2144 | 290 | 1985.04699248183 | 158.953007518172 | 1854 | 2.76504269035221 | 1.51555810878491 | 0.0800751861896425 | weekly | |||||||||
7507 | 7507 | United States | North Dakota | ND | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 762062 | 154 | 4 | 151.063909775337 | 2.93609022466291 | 150 | 0.524891675480473 | 0.385282329346287 | 0.0194360799282203 | weekly | |||||||||
7659 | 7659 | United States | Ohio | OH | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 11689100 | 2572 | 637 | 2468.68796992692 | 103.312030073075 | 1935 | 5.44952134894902 | 0.883832203275489 | 0.0418489624171228 | weekly | |||||||||
7811 | 7811 | United States | Oklahoma | OK | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 3956971 | 882 | 118 | 818.165413534606 | 63.8345864653938 | 764 | 2.98207896898916 | 1.61321845586925 | 0.0780216144674439 | weekly | |||||||||
7963 | 7963 | United States | Oregon | OR | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 4217737 | 793 | 87 | 746.902255640029 | 46.0977443599712 | 706 | 2.06271751889698 | 1.0929497111833 | 0.0617185769782815 | weekly | |||||||||
8115 | 8115 | United States | Pennsylvania | PA | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 12801989 | 2770 | 381 | 2722.60714285827 | 47.3928571417318 | 2389 | 2.97610004195442 | 0.370199170939233 | 0.0174071596286116 | weekly | |||||||||
8267 | 8267 | United States | Rhode Island | RI | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 1059361 | 227 | 55 | 218.778195489617 | 8.22180451038253 | 172 | 5.19180902449684 | 0.776109797357325 | 0.0375805481528104 | weekly | |||||||||
8419 | 8419 | United States | South Carolina | SC | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 5148714 | 1196 | 221 | 1009.75563909872 | 186.244360901276 | 975 | 4.29233396922028 | 3.61729862838131 | 0.184444982221156 | weekly | |||||||||
8571 | 8571 | United States | South Dakota | SD | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 884659 | 168 | 8 | 173.761278196223 | -5.76127819622283 | 160 | 0.904303240005471 | -0.651242817427148 | -0.0331562834713774 | weekly | |||||||||
8723 | 8723 | United States | Tennessee | TN | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 6833174 | 1662 | 158 | 1524.95112782047 | 137.048872179531 | 1504 | 2.3122490368312 | 2.0056400170628 | 0.0898709930300567 | weekly | |||||||||
8875 | 8875 | United States | Texas | TX | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 28995881 | 5191 | 756 | 4194.06390977497 | 996.936090225026 | 4435 | 2.60726687352593 | 3.43819899876478 | 0.237701692599748 | weekly | |||||||||
9027 | 9027 | United States | Utah | UT | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 3205958 | 415 | 62 | 413.468045113641 | 1.5319548863589 | 353 | 1.93389932120134 | 0.0477846212071057 | 0.00370513490574065 | weekly | |||||||||
9179 | 9179 | United States | Vermont | VT | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 623989 | 108 | 3 | 111.810150376825 | -3.81015037682458 | 105 | 0.480777706017254 | -0.610611785916832 | -0.0340769631735898 | weekly | |||||||||
9331 | 9331 | United States | Virginia | VA | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 8535519 | 1590 | 1140 | 1442.34398496309 | 147.656015036913 | 450 | 13.3559541019123 | 1.72990084184585 | 0.102372261108498 | weekly | |||||||||
9483 | 9483 | United States | Washington | WA | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 7614893 | 1245 | 89 | 1177.48684210612 | 67.5131578938799 | 1156 | 1.16876231878767 | 0.886593651334036 | 0.0573366559010733 | weekly | |||||||||
9635 | 9635 | United States | West Virginia | WV | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 1792147 | 504 | 27 | 458.364661655121 | 45.6353383448794 | 477 | 1.50657284251794 | 2.54640597813011 | 0.0995612056568531 | weekly | |||||||||
9787 | 9787 | United States | Wisconsin | WI | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 5822434 | 1075 | 45 | 1096.7669172941 | -21.7669172940959 | 1030 | 0.772872650853578 | -0.373845668222189 | -0.0198464386104921 | weekly | |||||||||
9939 | 9939 | United States | Wyoming | WY | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 578759 | 86 | 13 | 100.347744361776 | -14.3477443617756 | 73 | 2.24618537249529 | -2.4790533472094 | -0.142980237901999 | weekly | |||||||||
11987 | 11987 | Canada | Canada | 0 | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 38454328 | 5990 | 253 | 6031.86245954708 | -41.8624595470774 | 5737 | 0.65792334220481 | -0.108862803549908 | -0.00694022117179105 | weekly | |||||||||
17038 | 17038 | South Africa | South Africa | 0 | 2021-02-28 | 2021-03-06 | 7 | 2021 | 9 | 59893884 | 10965 | 706 | 9327.79693165965 | 1637.20306834035 | 10259 | 1.17875140640403 | 2.73350625973822 | 0.17551872969956 | 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);