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 2022-04-17 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2398 | 2398 | United States | Alabama | AL | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 4903185 | 1038 | 39 | 1001.71679196302 | 36.2832080369761 | 999 | 0.795401356465236 | 0.739992638192851 | 0.0362210240739536 | weekly | |||||||||
2550 | 2550 | United States | Alaska | AK | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 731545 | 93 | 16 | 88.1503759446937 | 4.84962405530625 | 77 | 2.18715184985203 | 0.662929013978122 | 0.0550153530638251 | weekly | |||||||||
2702 | 2702 | United States | Arizona | AZ | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 7278717 | 1294 | 29 | 1246.06516291985 | 47.9348370801501 | 1265 | 0.39842186473248 | 0.658561626728311 | 0.0384689649519023 | weekly | |||||||||
2854 | 2854 | United States | Arkansas | AR | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 3017825 | 643 | 33 | 600.909774437893 | 42.0902255621065 | 610 | 1.09350277103543 | 1.39472055411121 | 0.0700441686132978 | weekly | |||||||||
3006 | 3006 | United States | California | CA | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 39512223 | 5299 | 546 | 5080.76190476214 | 218.238095237855 | 4753 | 1.38185087687929 | 0.552330592074901 | 0.0429538127014579 | weekly | |||||||||
3158 | 3158 | United States | Colorado | CO | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 5758736 | 861 | 103 | 825.621553885694 | 35.3784461143056 | 758 | 1.78858693991181 | 0.614343948295348 | 0.0428506813415916 | weekly | |||||||||
3310 | 3310 | United States | Connecticut | CT | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 3565287 | 638 | 21 | 594.192982456553 | 43.8070175434468 | 617 | 0.589012890126377 | 1.22870942909917 | 0.0737252354653144 | weekly | |||||||||
3462 | 3462 | United States | Delaware | DE | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 973764 | 212 | 2 | 193.754385969578 | 18.245614030422 | 210 | 0.20538857464437 | 1.87372032960985 | 0.0941687794013955 | weekly | |||||||||
3614 | 3614 | United States | District of Columbia | DC | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 705749 | 104 | 2 | 115.04260651674 | -11.0426065167404 | 102 | 0.28338686983616 | -1.56466484780572 | -0.0959871029620101 | weekly | |||||||||
3766 | 3766 | United States | Florida | FL | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 21477737 | 4293 | 158 | 4146.48120300843 | 146.518796991565 | 4135 | 0.73564547326378 | 0.682189175663922 | 0.0353356954531134 | weekly | |||||||||
3918 | 3918 | United States | Georgia | GA | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 10617423 | 1753 | 136 | 1722.06015037651 | 30.9398496234942 | 1617 | 1.28091345706015 | 0.291406395162877 | 0.0179667647594828 | weekly | |||||||||
4070 | 4070 | United States | Hawaii | HI | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 1415872 | 252 | 17 | 220.062656642434 | 31.9373433575657 | 235 | 1.20067350720969 | 2.25566600353462 | 0.145128409539555 | weekly | |||||||||
4222 | 4222 | United States | Idaho | ID | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 1787065 | 314 | 9 | 290.729323308944 | 23.2706766910556 | 305 | 0.503619062541094 | 1.30217293109403 | 0.0800424134249675 | weekly | |||||||||
4374 | 4374 | United States | Illinois | IL | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 12671821 | 2050 | 44 | 1956.73684210569 | 93.2631578943051 | 2006 | 0.347227127024601 | 0.735988599383665 | 0.0476625961587875 | weekly | |||||||||
4526 | 4526 | United States | Indiana | IN | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 6732219 | 1329 | 0 | 1271.25563909961 | 57.7443609003931 | 1329 | 0.0 | 0.857731468634533 | 0.0454230912527489 | weekly | |||||||||
4678 | 4678 | United States | Iowa | IA | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 3155070 | 615 | 35 | 591.130325815017 | 23.8696741849833 | 580 | 1.10932562510499 | 0.756549749608829 | 0.0403797151703782 | weekly | |||||||||
4830 | 4830 | United States | Kansas | KS | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 2913314 | 537 | 73 | 502.453634085892 | 34.5463659141079 | 464 | 2.50573745226227 | 1.18580990288406 | 0.0687553309808528 | weekly | |||||||||
4982 | 4982 | United States | Kentucky | KY | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 4467673 | 1039 | 97 | 957.213032583097 | 81.7869674169033 | 942 | 2.17115263359695 | 1.83063906908369 | 0.0854428059720376 | weekly | |||||||||
5134 | 5134 | United States | Louisiana | LA | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 4648794 | 870 | 29 | 848.899749374247 | 21.100250625753 | 841 | 0.623817704118531 | 0.453886548333891 | 0.0248559981803584 | weekly | |||||||||
5286 | 5286 | United States | Maine | ME | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 1344212 | 275 | 4 | 292.824561404154 | -17.8245614041543 | 271 | 0.297572109161353 | -1.32602308297756 | -0.0608711281549672 | weekly | |||||||||
5438 | 5438 | United States | Maryland | MD | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 6045680 | 992 | 24 | 964.215538847975 | 27.7844611520245 | 968 | 0.396977676621985 | 0.459575451430187 | 0.0288156123113519 | weekly | |||||||||
5590 | 5590 | United States | Massachusetts | MA | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 6949503 | 1073 | 46 | 1126.58395990047 | -53.5839599004685 | 1027 | 0.661917837865528 | -0.771047366991114 | -0.0475632192608196 | weekly | |||||||||
5742 | 5742 | United States | Michigan | MI | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 9986857 | 1917 | 78 | 1886.72932330899 | 30.2706766910067 | 1839 | 0.781026503133068 | 0.303105137992931 | 0.0160439954566016 | weekly | |||||||||
5894 | 5894 | United States | Minnesota | MN | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 5639632 | 957 | 28 | 894.213032582201 | 62.7869674177992 | 929 | 0.49648629555971 | 1.11331674509612 | 0.0702147755960238 | weekly | |||||||||
6046 | 6046 | United States | Mississippi | MS | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 2976149 | 644 | 10 | 599.248120301412 | 44.7518796985877 | 634 | 0.336004682561256 | 1.50368411321435 | 0.0746800501870213 | weekly | |||||||||
6198 | 6198 | United States | Missouri | MO | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 6137428 | 1241 | 0 | 1223.12030075265 | 17.8796992473503 | 1241 | 0.0 | 0.291322346223049 | 0.0146181035801205 | weekly | |||||||||
6350 | 6350 | United States | Montana | MT | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 1068778 | 198 | 2 | 207.51378446196 | -9.51378446196026 | 196 | 0.187129600347313 | -0.890155342078547 | -0.0458465180355488 | weekly | |||||||||
6502 | 6502 | United States | Nebraska | NE | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 1934408 | 330 | 6 | 314.854636592553 | 15.1453634074475 | 324 | 0.310172414506144 | 0.782945656110162 | 0.0481027167690937 | weekly | |||||||||
6654 | 6654 | United States | Nevada | NV | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 3080156 | 559 | 183 | 528.375939850453 | 30.6240601495472 | 376 | 5.94125752072298 | 0.994237309718962 | 0.0579588467980103 | weekly | |||||||||
6806 | 6806 | United States | New Hampshire | NH | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 1359711 | 245 | 11 | 240.644110276489 | 4.35588972351093 | 234 | 0.808995440942965 | 0.320354084324605 | 0.0181009612847214 | weekly | |||||||||
6958 | 6958 | United States | New Jersey | NJ | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 8882190 | 1348 | 37 | 1408.90225564008 | -60.902255640078 | 1311 | 0.416563932994003 | -0.685667111828029 | -0.0432267429456343 | weekly | |||||||||
7110 | 7110 | United States | New Mexico | NM | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 2096829 | 373 | 32 | 373.949874687565 | -0.949874687565114 | 341 | 1.52611395588291 | -0.0453005317822824 | -0.00254011233018525 | weekly | |||||||||
7262 | 7262 | United States | New York | NY | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 19453561 | 2911 | 98 | 2952.46616541435 | -41.4661654143533 | 2813 | 0.503763809618198 | -0.213154627136663 | -0.0140445861497397 | weekly | |||||||||
7414 | 7414 | United States | North Carolina | NC | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 10488084 | 1908 | 29 | 1857.07518797061 | 50.9248120293862 | 1879 | 0.276504269035221 | 0.485549238825568 | 0.0274220518152721 | weekly | |||||||||
7566 | 7566 | United States | North Dakota | ND | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 762062 | 132 | 0 | 155.568922306677 | -23.5689223066765 | 132 | 0.0 | -3.09278277970513 | -0.151501482154736 | weekly | |||||||||
7718 | 7718 | United States | Ohio | OH | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 11689100 | 2298 | 94 | 2321.30075188213 | -23.300751882126 | 2204 | 0.804167985559196 | -0.199337433011318 | -0.0100377996531615 | weekly | |||||||||
7870 | 7870 | United States | Oklahoma | OK | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 3956971 | 827 | 96 | 743.864661654828 | 83.1353383451716 | 731 | 2.42609814426237 | 2.10098427168588 | 0.111761376270014 | weekly | |||||||||
8022 | 8022 | United States | Oregon | OR | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 4217737 | 879 | 34 | 735.776942356841 | 143.223057643159 | 845 | 0.806119490143648 | 3.39573230012111 | 0.194655539468779 | weekly | |||||||||
8174 | 8174 | United States | Pennsylvania | PA | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 12801989 | 2542 | 114 | 2544.23809523921 | -2.23809523920727 | 2428 | 0.890486626726519 | -0.0174824024548628 | -0.00087967208862849 | weekly | |||||||||
8326 | 8326 | United States | Rhode Island | RI | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 1059361 | 178 | 5 | 209.37844611618 | -31.3784461161795 | 173 | 0.471982638590622 | -2.96201635855761 | -0.149864738697928 | weekly | |||||||||
8478 | 8478 | United States | South Carolina | SC | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 5148714 | 1016 | 36 | 974.275689224032 | 41.7243107759676 | 980 | 0.699203723492896 | 0.810383151520314 | 0.0428259795840735 | weekly | |||||||||
8630 | 8630 | United States | South Dakota | SD | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 884659 | 163 | 3 | 166.884711780134 | -3.88471178013441 | 160 | 0.339113715002052 | -0.439119681157871 | -0.0232778169953183 | weekly | |||||||||
8782 | 8782 | United States | Tennessee | TN | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 6833174 | 1504 | 118 | 1475.38847117888 | 28.6115288211242 | 1386 | 1.72686953383596 | 0.418715063031093 | 0.0193925392396912 | weekly | |||||||||
8934 | 8934 | United States | Texas | TX | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 28995881 | 4148 | 118 | 3969.90225563969 | 178.097744360313 | 4030 | 0.406954353275212 | 0.614217393016316 | 0.0448619973217994 | weekly | |||||||||
9086 | 9086 | United States | Utah | UT | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 3205958 | 453 | 4 | 408.215538847962 | 44.7844611520383 | 449 | 0.124767698142022 | 1.39691353261765 | 0.109707879514891 | weekly | |||||||||
9238 | 9238 | United States | Vermont | VT | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 623989 | 110 | 6 | 108.496240602374 | 1.50375939762628 | 104 | 0.961555412034507 | 0.24099133119755 | 0.0138600138518845 | weekly | |||||||||
9390 | 9390 | United States | Virginia | VA | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 8535519 | 1402 | 102 | 1369.15037594051 | 32.8496240594866 | 1300 | 1.19500641964478 | 0.384857957196119 | 0.0239927071830377 | weekly | |||||||||
9542 | 9542 | United States | Washington | WA | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 7614893 | 1219 | 38 | 1097.24561403592 | 121.754385964081 | 1181 | 0.499022113639679 | 1.59889818496572 | 0.11096365700314 | weekly | |||||||||
9694 | 9694 | United States | West Virginia | WV | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 1792147 | 501 | 29 | 442.716791980975 | 58.2832080190253 | 472 | 1.6181708308526 | 3.25214438430694 | 0.131648966279847 | weekly | |||||||||
9846 | 9846 | United States | Wisconsin | WI | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 5822434 | 1048 | 14 | 1055.4937343367 | -7.49373433669916 | 1034 | 0.240449269154446 | -0.128704496035492 | -0.00709974308034 | weekly | |||||||||
9998 | 9998 | United States | Wyoming | WY | 2022-04-17 | 2022-04-23 | 7 | 2022 | 16 | 578759 | 97 | 6 | 98.223057644976 | -1.22305764497604 | 91 | 1.03670094115167 | -0.211324168604901 | -0.0124518384409976 | 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);