economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
51 rows where country = "United States", "start_date" is on date 2021-04-25 and week = 17 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2347 | 2347 | United States | Alabama | AL | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 4903185 | 1192 | 62 | 1016.03759397238 | 175.962406027624 | 1130 | 1.26448420771397 | 3.58873683182715 | 0.173184936336527 | weekly | |||||||||
2499 | 2499 | United States | Alaska | AK | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 731545 | 115 | 4 | 86.2794486253764 | 28.7205513746236 | 111 | 0.546787962463006 | 3.92601294173613 | 0.332878244265649 | weekly | |||||||||
2651 | 2651 | United States | Arizona | AZ | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 7278717 | 1279 | 70 | 1239.21553885742 | 39.7844611425796 | 1209 | 0.961707949354261 | 0.546586179165636 | 0.0321045531588973 | weekly | |||||||||
2803 | 2803 | United States | Arkansas | AR | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 3017825 | 651 | 24 | 601.432330828626 | 49.5676691713738 | 627 | 0.795274742571223 | 1.64249647250499 | 0.0824160369015776 | weekly | |||||||||
2955 | 2955 | United States | California | CA | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 39512223 | 5392 | 164 | 5158.90476190519 | 233.09523809481 | 5228 | 0.41506143554616 | 0.589931976479304 | 0.0451830861108449 | weekly | |||||||||
3107 | 3107 | United States | Colorado | CO | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 5758736 | 844 | 53 | 778.132832081226 | 65.8671679187743 | 791 | 0.920340852575982 | 1.14377821658736 | 0.0846477172060756 | weekly | |||||||||
3259 | 3259 | United States | Connecticut | CT | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 3565287 | 635 | 50 | 627.061403509349 | 7.93859649065109 | 585 | 1.40241164315804 | 0.222663602976453 | 0.0126599986001734 | weekly | |||||||||
3411 | 3411 | United States | Delaware | DE | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 973764 | 205 | 11 | 168.149122810816 | 36.8508771891841 | 194 | 1.12963716054403 | 3.78437457014062 | 0.219155928815906 | weekly | |||||||||
3563 | 3563 | United States | District of Columbia | DC | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 705749 | 121 | 7 | 124.948621554305 | -3.94862155430481 | 114 | 0.99185404442656 | -0.559493751221016 | -0.0316019617118278 | weekly | |||||||||
3715 | 3715 | United States | Florida | FL | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 21477737 | 4476 | 427 | 4080.69423558994 | 395.305764410061 | 4049 | 1.98810517141541 | 1.84053731736291 | 0.0968721843852907 | weekly | |||||||||
3867 | 3867 | United States | Georgia | GA | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 10617423 | 1824 | 239 | 1719.71177944915 | 104.288220550854 | 1585 | 2.25101703115718 | 0.98223665526799 | 0.0606428482941832 | weekly | |||||||||
4019 | 4019 | United States | Hawaii | HI | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 1415872 | 234 | 5 | 225.463659148724 | 8.53634085127567 | 229 | 0.35313926682638 | 0.602903429919913 | 0.0378612716723663 | weekly | |||||||||
4171 | 4171 | United States | Idaho | ID | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 1787065 | 274 | 15 | 269.130325815264 | 4.86967418473603 | 259 | 0.839365104235157 | 0.272495638644147 | 0.0180941117281546 | weekly | |||||||||
4323 | 4323 | United States | Illinois | IL | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 12671821 | 2224 | 216 | 1972.05263157942 | 251.94736842058 | 2008 | 1.70456953266622 | 1.98824911132015 | 0.127758947396244 | weekly | |||||||||
4475 | 4475 | United States | Indiana | IN | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 6732219 | 1362 | 67 | 1255.19172932492 | 106.808270675085 | 1295 | 0.995214207975112 | 1.58652400753875 | 0.0850931918843427 | weekly | |||||||||
4627 | 4627 | United States | Iowa | IA | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 3155070 | 633 | 43 | 587.764411028134 | 45.2355889718658 | 590 | 1.36288576798613 | 1.43374280037735 | 0.0769621095172102 | weekly | |||||||||
4779 | 4779 | United States | Kansas | KS | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 2913314 | 513 | 14 | 492.256892231293 | 20.7431077687075 | 499 | 0.480552388105093 | 0.71201071249812 | 0.0421387858576923 | weekly | |||||||||
4931 | 4931 | United States | Kentucky | KY | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 4467673 | 1017 | 77 | 952.576441104204 | 64.4235588957961 | 940 | 1.72349229677284 | 1.44199360373501 | 0.0676308547176727 | weekly | |||||||||
5083 | 5083 | United States | Louisiana | LA | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 4648794 | 1002 | 46 | 904.258145364262 | 97.7418546357377 | 956 | 0.989503944463876 | 2.10252066741907 | 0.108090654352209 | weekly | |||||||||
5235 | 5235 | United States | Maine | ME | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 1344212 | 303 | 17 | 307.201754386653 | -4.20175438665308 | 286 | 1.26468146393575 | -0.31258122875358 | -0.0136775077832552 | weekly | |||||||||
5387 | 5387 | United States | Maryland | MD | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 6045680 | 1080 | 97 | 946.828320802867 | 133.171679197133 | 983 | 1.60445144301385 | 2.20275765831359 | 0.140650291368777 | weekly | |||||||||
5539 | 5539 | United States | Massachusetts | MA | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 6949503 | 1114 | 73 | 1094.02130325889 | 19.9786967411094 | 1041 | 1.05043482965616 | 0.287483820657526 | 0.0182617072278177 | weekly | |||||||||
5691 | 5691 | United States | Michigan | MI | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 9986857 | 2324 | 484 | 1908.13032581534 | 415.869674184664 | 1840 | 4.84636958354365 | 4.16416971009662 | 0.217946158372052 | weekly | |||||||||
5843 | 5843 | United States | Minnesota | MN | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 5639632 | 967 | 82 | 857.243107770196 | 109.756892229804 | 885 | 1.45399557985344 | 1.94617117269006 | 0.128034732778775 | weekly | |||||||||
5995 | 5995 | United States | Mississippi | MS | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 2976149 | 694 | 24 | 595.60275689292 | 98.3972431070805 | 670 | 0.806411238147015 | 3.30619344350973 | 0.165206157910332 | weekly | |||||||||
6147 | 6147 | United States | Missouri | MO | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 6137428 | 1306 | 50 | 1226.59022556469 | 79.4097744353128 | 1256 | 0.814673508186165 | 1.29386079046977 | 0.0647402635209773 | weekly | |||||||||
6299 | 6299 | United States | Montana | MT | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 1068778 | 222 | 11 | 195.802005013349 | 26.1979949866513 | 211 | 1.02921280191022 | 2.45121016587648 | 0.133798399995267 | weekly | |||||||||
6451 | 6451 | United States | Nebraska | NE | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 1934408 | 368 | 3 | 310.057644111341 | 57.9423558886588 | 365 | 0.155086207253072 | 2.99535340469326 | 0.186876076075234 | weekly | |||||||||
6603 | 6603 | United States | Nevada | NV | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 3080156 | 551 | 42 | 534.11528822139 | 16.8847117786104 | 509 | 1.36356729983806 | 0.548177163059611 | 0.0316124854520392 | weekly | |||||||||
6755 | 6755 | United States | New Hampshire | NH | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 1359711 | 246 | 22 | 248.399749374246 | -2.39974937424569 | 224 | 1.61799088188593 | -0.17648966392459 | -0.00966083653582983 | weekly | |||||||||
6907 | 6907 | United States | New Jersey | NJ | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 8882190 | 1649 | 221 | 1356.84335839697 | 292.156641603029 | 1428 | 2.4881251132885 | 3.28924107233721 | 0.215320832574362 | weekly | |||||||||
7059 | 7059 | United States | New Mexico | NM | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 2096829 | 396 | 43 | 377.96240601588 | 18.0375939841201 | 353 | 2.05071562821766 | 0.860231997178603 | 0.0477232489184711 | weekly | |||||||||
7211 | 7211 | United States | New York | NY | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 19453561 | 3196 | 314 | 2893.18295739429 | 302.817042605707 | 2882 | 1.614100369593 | 1.5566149693915 | 0.10466570799879 | weekly | |||||||||
7363 | 7363 | United States | North Carolina | NC | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 10488084 | 2067 | 128 | 1821.72305764474 | 245.276942355258 | 1939 | 1.22043263574167 | 2.33862488472879 | 0.134640082270447 | weekly | |||||||||
7515 | 7515 | United States | North Dakota | ND | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 762062 | 144 | 8 | 140.676691730209 | 3.32330826979103 | 136 | 1.04978335096095 | 0.436094211467181 | 0.0236237306188896 | weekly | |||||||||
7667 | 7667 | United States | Ohio | OH | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 11689100 | 2471 | 162 | 2263.0588972453 | 207.941102754699 | 2309 | 1.38590652830415 | 1.7789316778426 | 0.0918849717114367 | weekly | |||||||||
7819 | 7819 | United States | Oklahoma | OK | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 3956971 | 739 | 14 | 742.731829574659 | -3.73182957465906 | 725 | 0.353805979371595 | -0.0943102583935808 | -0.00502446431681292 | weekly | |||||||||
7971 | 7971 | United States | Oregon | OR | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 4217737 | 776 | 19 | 707.41604010117 | 68.5839598988297 | 757 | 0.450478538609686 | 1.62608431722579 | 0.0969499643929777 | weekly | |||||||||
8123 | 8123 | United States | Pennsylvania | PA | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 12801989 | 2706 | 315 | 2503.42857142965 | 202.571428570345 | 2391 | 2.46055515279696 | 1.58234340437525 | 0.0809175987212853 | weekly | |||||||||
8275 | 8275 | United States | Rhode Island | RI | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 1059361 | 208 | 11 | 203.20050125401 | 4.79949874599001 | 197 | 1.03836180489937 | 0.453056016408949 | 0.0236195221781978 | weekly | |||||||||
8427 | 8427 | United States | South Carolina | SC | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 5148714 | 1152 | 92 | 963.540100251589 | 188.459899748411 | 1060 | 1.7868539600374 | 3.66032954536629 | 0.195591132843565 | weekly | |||||||||
8579 | 8579 | United States | South Dakota | SD | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 884659 | 158 | 14 | 149.74686716862 | 8.25313283137959 | 144 | 1.58253067000957 | 0.932916844951511 | 0.0551138931146136 | weekly | |||||||||
8731 | 8731 | United States | Tennessee | TN | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 6833174 | 1648 | 58 | 1509.04135338437 | 138.95864661563 | 1590 | 0.848800279343099 | 2.03358858731872 | 0.0920840547570041 | weekly | |||||||||
8883 | 8883 | United States | Texas | TX | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 28995881 | 4444 | 260 | 3918.34335839654 | 525.656641603462 | 4184 | 0.896679083487755 | 1.81286659854709 | 0.134152776702696 | weekly | |||||||||
9035 | 9035 | United States | Utah | UT | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 3205958 | 427 | 23 | 374.99498746951 | 52.0050125304903 | 404 | 0.717414264316625 | 1.62213642631907 | 0.138681887140475 | weekly | |||||||||
9187 | 9187 | United States | Vermont | VT | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 623989 | 161 | 3 | 111.872180451988 | 49.127819548012 | 158 | 0.480777706017254 | 7.87318679464094 | 0.439142415473846 | weekly | |||||||||
9339 | 9339 | United States | Virginia | VA | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 8535519 | 1492 | 102 | 1329.94611528889 | 162.053884711111 | 1390 | 1.19500641964478 | 1.89858267213875 | 0.121849962827937 | weekly | |||||||||
9491 | 9491 | United States | Washington | WA | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 7614893 | 1225 | 65 | 1045.35087719381 | 179.649122806186 | 1160 | 0.853590457541557 | 2.35918118358572 | 0.171855332717034 | weekly | |||||||||
9643 | 9643 | United States | West Virginia | WV | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 1792147 | 520 | -138 | 424.870927319275 | 95.1290726807247 | 658 | -7.7002611950917 | 5.30810657165538 | 0.223901111052578 | weekly | |||||||||
9795 | 9795 | United States | Wisconsin | WI | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 5822434 | 1022 | 44 | 1038.12030075273 | -16.1203007527342 | 978 | 0.755697703056832 | -0.276865323896059 | -0.0155283551829644 | weekly | |||||||||
9947 | 9947 | United States | Wyoming | WY | 2021-04-25 | 2021-05-01 | 7 | 2021 | 17 | 578759 | 89 | 2 | 88.4172932339342 | 0.582706766065797 | 87 | 0.34556698038389 | 0.10068210879931 | 0.00659041624950074 | 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);