economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
51 rows where cadence = "weekly", country = "United States" and "start_date" is on date 2021-02-21 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: end_date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2338 | 2338 | United States | Alabama | AL | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 4903185 | 1315 | 343 | 1100.86466164316 | 214.13533835684 | 972 | 6.99545295557887 | 4.36727022041469 | 0.194515589261644 | weekly | |||||||||
2490 | 2490 | United States | Alaska | AK | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 731545 | 94 | 7 | 87.8439849657433 | 6.15601503425673 | 87 | 0.956878934310261 | 0.841508729368217 | 0.0700789591530644 | weekly | |||||||||
2642 | 2642 | United States | Arizona | AZ | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 7278717 | 1516 | 501 | 1297.62406015956 | 218.375939840439 | 1015 | 6.88308118037836 | 3.00019824703225 | 0.168289065026727 | weekly | |||||||||
2794 | 2794 | United States | Arkansas | AR | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 3017825 | 789 | 72 | 695.693609024018 | 93.3063909759817 | 717 | 2.38582422771367 | 3.0918423359864 | 0.134119948445236 | weekly | |||||||||
2946 | 2946 | United States | California | CA | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 39512223 | 6725 | 1210 | 5658.1428571434 | 1066.8571428566 | 5515 | 3.06234351835886 | 2.7000686416874 | 0.188552528593316 | weekly | |||||||||
3098 | 3098 | United States | Colorado | CO | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 5758736 | 872 | 62 | 857.221804512347 | 14.7781954876527 | 810 | 1.07662514829643 | 0.256622208200771 | 0.0172396402073087 | weekly | |||||||||
3250 | 3250 | United States | Connecticut | CT | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 3565287 | 676 | 104 | 661.328947369108 | 14.6710526308916 | 572 | 2.91701621776872 | 0.411497100538936 | 0.0221841984828517 | weekly | |||||||||
3402 | 3402 | United States | Delaware | DE | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 973764 | 214 | 56 | 195.01315789813 | 18.9868421018699 | 158 | 5.75088009004235 | 1.94984021815038 | 0.0973618514079351 | weekly | |||||||||
3554 | 3554 | United States | District of Columbia | DC | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 705749 | 144 | 11 | 106.98496240645 | 37.0150375935502 | 133 | 1.55862778409888 | 5.24478782025199 | 0.345983554706738 | weekly | |||||||||
3706 | 3706 | United States | Florida | FL | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 21477737 | 4894 | 926 | 4374.30075188071 | 519.69924811929 | 3968 | 4.31144119140671 | 2.41971138821232 | 0.118807388334204 | weekly | |||||||||
3858 | 3858 | United States | Georgia | GA | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 10617423 | 2108 | 438 | 1754.28759398548 | 353.712406014519 | 1670 | 4.12529481023785 | 3.33143368230237 | 0.201627376963281 | weekly | |||||||||
4010 | 4010 | United States | Hawaii | HI | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 1415872 | 262 | 9 | 243.580827068562 | 18.4191729314383 | 253 | 0.635650680287484 | 1.30090664491128 | 0.0756183200176661 | weekly | |||||||||
4162 | 4162 | United States | Idaho | ID | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 1787065 | 302 | 34 | 303.83082706845 | -1.83082706844988 | 268 | 1.90256090293302 | -0.102448823543065 | -0.00602581076487485 | weekly | |||||||||
4314 | 4314 | United States | Illinois | IL | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 12671821 | 2333 | 284 | 2170.46052631631 | 162.539473683691 | 2049 | 2.24119327443151 | 1.28268441989269 | 0.0748870904183416 | weekly | |||||||||
4466 | 4466 | United States | Indiana | IN | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 6732219 | 1439 | 222 | 1395.15977443759 | 43.8402255624051 | 1217 | 3.29757543538022 | 0.651200229261779 | 0.0314230859903322 | weekly | |||||||||
4618 | 4618 | United States | Iowa | IA | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 3155070 | 585 | 135 | 648.498120301387 | -63.4981203013867 | 450 | 4.27882741111925 | -2.01257405703793 | -0.0979156582163665 | weekly | |||||||||
4770 | 4770 | United States | Kansas | KS | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 2913314 | 595 | 122 | 575.075187970685 | 19.9248120293146 | 473 | 4.18767081063009 | 0.683922571659443 | 0.0346473164659127 | weekly | |||||||||
4922 | 4922 | United States | Kentucky | KY | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 4467673 | 1113 | 199 | 1013.42481203145 | 99.5751879685507 | 914 | 4.45422035139994 | 2.22879310926629 | 0.0982561180527526 | weekly | |||||||||
5074 | 5074 | United States | Louisiana | LA | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 4648794 | 1107 | 148 | 936.020676692633 | 170.979323307367 | 959 | 3.18362138653595 | 3.67792858335661 | 0.182666182024431 | weekly | |||||||||
5226 | 5226 | United States | Maine | ME | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 1344212 | 280 | 44 | 311.723684211262 | -31.723684211262 | 236 | 3.27329320077488 | -2.36002090527848 | -0.101768604113386 | weekly | |||||||||
5378 | 5378 | United States | Maryland | MD | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 6045680 | 1176 | 164 | 1025.71804511367 | 150.281954886326 | 1012 | 2.71268079025023 | 2.48577422037432 | 0.146513903701159 | weekly | |||||||||
5530 | 5530 | United States | Massachusetts | MA | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 6949503 | 1269 | 288 | 1205.32330827146 | 63.6766917285361 | 981 | 4.14418124576678 | 0.916276915464833 | 0.052829553109575 | weekly | |||||||||
5682 | 5682 | United States | Michigan | MI | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 9986857 | 2065 | 166 | 2011.83082706853 | 53.1691729314684 | 1899 | 1.66218460923191 | 0.532391451399258 | 0.0264282524236603 | weekly | |||||||||
5834 | 5834 | United States | Minnesota | MN | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 5639632 | 968 | 53 | 932.424812030882 | 35.575187969118 | 915 | 0.93977763088088 | 0.630806903165278 | 0.0381534119535418 | weekly | |||||||||
5986 | 5986 | United States | Mississippi | MS | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 2976149 | 845 | 116 | 645.530075188702 | 199.469924811298 | 729 | 3.89765431771057 | 6.70228287667379 | 0.309001752943872 | weekly | |||||||||
6138 | 6138 | United States | Missouri | MO | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 6137428 | 1403 | 199 | 1342.57518797074 | 60.4248120292614 | 1204 | 3.24240056258094 | 0.984529871947359 | 0.0450066503318831 | weekly | |||||||||
6290 | 6290 | United States | Montana | MT | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 1068778 | 224 | 16 | 225.362781955739 | -1.36278195573931 | 208 | 1.4970368027785 | -0.127508421369013 | -0.00604705863103405 | weekly | |||||||||
6442 | 6442 | United States | Nebraska | NE | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 1934408 | 318 | 31 | 346.992481204099 | -28.9924812040995 | 287 | 1.60255747494841 | -1.49877798293325 | -0.0835536294720064 | weekly | |||||||||
6594 | 6594 | United States | Nevada | NV | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 3080156 | 667 | 90 | 535.984962406883 | 131.015037593117 | 577 | 2.92192992822441 | 4.25351954878638 | 0.24443789804248 | weekly | |||||||||
6746 | 6746 | United States | New Hampshire | NH | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 1359711 | 244 | 17 | 267.110902256485 | -23.1109022564849 | 227 | 1.25026568145731 | -1.69969223287043 | -0.0865217483122175 | weekly | |||||||||
6898 | 6898 | United States | New Jersey | NJ | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 8882190 | 1798 | 404 | 1521.81390977545 | 276.186090224551 | 1394 | 4.54842780890749 | 3.10943686438312 | 0.181484798141518 | weekly | |||||||||
7050 | 7050 | United States | New Mexico | NM | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 2096829 | 463 | 90 | 405.635338346728 | 57.3646616532719 | 373 | 4.29219550092068 | 2.73578158511123 | 0.14141929025976 | weekly | |||||||||
7202 | 7202 | United States | New York | NY | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 19453561 | 3907 | 822 | 3156.0413533843 | 750.958646615705 | 3085 | 4.22544746434856 | 3.86026314984544 | 0.237943221437968 | weekly | |||||||||
7354 | 7354 | United States | North Carolina | NC | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 10488084 | 2233 | 316 | 2018.79699248182 | 214.20300751818 | 1917 | 3.01294306948724 | 2.04234641444691 | 0.106104283053666 | weekly | |||||||||
7506 | 7506 | United States | North Dakota | ND | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 762062 | 162 | 8 | 163.563909775337 | -1.56390977533661 | 154 | 1.04978335096095 | -0.205220805569181 | -0.00956145996683944 | weekly | |||||||||
7658 | 7658 | United States | Ohio | OH | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 11689100 | 2779 | 484 | 2494.68796992693 | 284.312030073072 | 2295 | 4.14060962777288 | 2.4322833244054 | 0.113966970418909 | weekly | |||||||||
7810 | 7810 | United States | Oklahoma | OK | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 3956971 | 924 | 152 | 829.665413534606 | 94.3345864653936 | 772 | 3.84132206174875 | 2.38401005378593 | 0.113701963377625 | weekly | |||||||||
7962 | 7962 | United States | Oregon | OR | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 4217737 | 800 | 57 | 739.15225564003 | 60.8477443599697 | 743 | 1.35143561582906 | 1.442663313525 | 0.0823209885320337 | weekly | |||||||||
8114 | 8114 | United States | Pennsylvania | PA | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 12801989 | 2894 | 370 | 2739.60714285828 | 154.392857141718 | 2524 | 2.89017589376151 | 1.20600679427016 | 0.0563558382975442 | weekly | |||||||||
8266 | 8266 | United States | Rhode Island | RI | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 1059361 | 226 | 137 | 203.278195489618 | 22.7218045103817 | 89 | 12.932324297383 | 2.14485944927005 | 0.111776890067593 | weekly | |||||||||
8418 | 8418 | United States | South Carolina | SC | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 5148714 | 1239 | 241 | 1037.00563909872 | 201.994360901281 | 998 | 4.68078048227188 | 3.92320025740953 | 0.194786174043217 | weekly | |||||||||
8570 | 8570 | United States | South Dakota | SD | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 884659 | 180 | 29 | 173.511278196223 | 6.48872180377671 | 151 | 3.27809924501983 | 0.733471518831178 | 0.0373965420071347 | weekly | |||||||||
8722 | 8722 | United States | Tennessee | TN | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 6833174 | 1756 | 313 | 1547.20112782047 | 208.798872179533 | 1443 | 4.58059461093776 | 3.05566450056054 | 0.134952637006972 | weekly | |||||||||
8874 | 8874 | United States | Texas | TX | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 28995881 | 5661 | 984 | 4261.31390977499 | 1399.68609022501 | 4677 | 3.39358545443058 | 4.82718938674432 | 0.328463502070168 | weekly | |||||||||
9026 | 9026 | United States | Utah | UT | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 3205958 | 379 | 65 | 398.718045113641 | -19.7180451136412 | 314 | 2.02747509480785 | -0.615043775172389 | -0.0494536060137967 | weekly | |||||||||
9178 | 9178 | United States | Vermont | VT | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 623989 | 168 | 9 | 112.310150376824 | 55.6898496231757 | 159 | 1.44233311805176 | 8.92481271675874 | 0.495857671246316 | weekly | |||||||||
9330 | 9330 | United States | Virginia | VA | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 8535519 | 1711 | 1173 | 1449.59398496309 | 261.406015036908 | 538 | 13.742573825915 | 3.06256731473397 | 0.180330504781698 | weekly | |||||||||
9482 | 9482 | United States | Washington | WA | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 7614893 | 1234 | 134 | 1169.48684210612 | 64.5131578938795 | 1100 | 1.75970955862413 | 0.847197168678266 | 0.0551636457727889 | weekly | |||||||||
9634 | 9634 | United States | West Virginia | WV | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 1792147 | 492 | 75 | 446.364661655119 | 45.6353383448808 | 417 | 4.18492456254984 | 2.54640597813019 | 0.102237794039665 | weekly | |||||||||
9786 | 9786 | United States | Wisconsin | WI | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 5822434 | 1104 | 76 | 1095.7669172941 | 8.23308270589723 | 1028 | 1.30529603255271 | 0.141402765680079 | 0.00751353465409244 | weekly | |||||||||
9938 | 9938 | United States | Wyoming | WY | 2021-02-21 | 2021-02-27 | 7 | 2021 | 8 | 578759 | 102 | 9 | 98.0977443617763 | 3.90225563822369 | 93 | 1.55505141172751 | 0.674245348793486 | 0.0397792595906437 | 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);