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 2022-01-09 and week = 2 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2384 | 2384 | United States | Alabama | AL | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 4903185 | 1520 | 56 | 1177.21052630105 | 342.789473698948 | 1464 | 1.14211476825778 | 6.99115929133712 | 0.291187910777554 | weekly | |||||||||
2536 | 2536 | United States | Alaska | AK | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 731545 | 121 | 64 | 103.631578951698 | 17.3684210483021 | 57 | 8.7486073994081 | 2.37421088905018 | 0.167597765314349 | weekly | |||||||||
2688 | 2688 | United States | Arizona | AZ | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 7278717 | 1864 | 452 | 1448.47368422196 | 415.526315778038 | 1412 | 6.20988561583037 | 5.70878515785184 | 0.286871843309487 | weekly | |||||||||
2840 | 2840 | United States | Arkansas | AR | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 3017825 | 863 | 115 | 689.171052633257 | 173.828947366743 | 748 | 3.81069147482044 | 5.7600738070214 | 0.252229031823899 | weekly | |||||||||
2992 | 2992 | United States | California | CA | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 39512223 | 7958 | 660 | 6188.00000000033 | 1769.99999999967 | 7298 | 1.67036919183211 | 4.47962646900346 | 0.286037491919777 | weekly | |||||||||
3144 | 3144 | United States | Colorado | CO | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 5758736 | 1187 | 138 | 899.960526316788 | 287.039473683212 | 1049 | 2.3963592010469 | 4.98441799872771 | 0.318946737428541 | weekly | |||||||||
3296 | 3296 | United States | Connecticut | CT | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 3565287 | 911 | 179 | 678.960526316282 | 232.039473683718 | 732 | 5.02063368250578 | 6.50829719132621 | 0.341756942693937 | weekly | |||||||||
3448 | 3448 | United States | Delaware | DE | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 973764 | 298 | 66 | 199.36842105686 | 98.6315789431401 | 232 | 6.7778229632642 | 10.1288997070276 | 0.494720168922893 | weekly | |||||||||
3600 | 3600 | United States | District of Columbia | DC | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 705749 | 171 | 30 | 130.328947368855 | 40.6710526311448 | 141 | 4.2508030475424 | 5.76282114904092 | 0.312064613827028 | weekly | |||||||||
3752 | 3752 | United States | Florida | FL | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 21477737 | 5751 | 643 | 4527.17105263251 | 1223.82894736749 | 5108 | 2.99379771714311 | 5.69812800746881 | 0.270329734206938 | weekly | |||||||||
3904 | 3904 | United States | Georgia | GA | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 10617423 | 2707 | 407 | 1920.55263157948 | 786.447368420517 | 2300 | 3.83332188987855 | 7.40713983440725 | 0.409490141269252 | weekly | |||||||||
4056 | 4056 | United States | Hawaii | HI | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 1415872 | 305 | 16 | 251.263157895575 | 53.7368421044251 | 289 | 1.13004565384442 | 3.79531780446433 | 0.213866778378859 | weekly | |||||||||
4208 | 4208 | United States | Idaho | ID | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 1787065 | 414 | 35 | 312.513157895432 | 101.486842104568 | 379 | 1.9585185765487 | 5.67896758677315 | 0.324744221292997 | weekly | |||||||||
4360 | 4360 | United States | Illinois | IL | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 12671821 | 3454 | 872 | 2300.64473684255 | 1153.35526315745 | 2582 | 6.88141033557845 | 9.10173260147415 | 0.501318280344463 | weekly | |||||||||
4512 | 4512 | United States | Indiana | IN | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 6732219 | 2122 | 612 | 1445.72368421226 | 676.276315787744 | 1510 | 9.09061336239953 | 10.0453701192392 | 0.467777019338403 | weekly | |||||||||
4664 | 4664 | United States | Iowa | IA | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 3155070 | 852 | 182 | 668.197368421571 | 183.802631578429 | 670 | 5.76849325054595 | 5.82562769061952 | 0.275072366735912 | weekly | |||||||||
4816 | 4816 | United States | Kansas | KS | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 2913314 | 876 | 66 | 587.105263158587 | 288.894736841413 | 810 | 2.26546125820972 | 9.9163611214381 | 0.492066337963279 | weekly | |||||||||
4968 | 4968 | United States | Kentucky | KY | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 4467673 | 1415 | 160 | 1108.14473684365 | 306.855263156355 | 1255 | 3.58128269459291 | 6.86834652304129 | 0.27690901102899 | weekly | |||||||||
5120 | 5120 | United States | Louisiana | LA | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 4648794 | 1252 | 83 | 989.328947369252 | 262.671052630748 | 1169 | 1.78540929109786 | 5.65030527553487 | 0.26550426259054 | weekly | |||||||||
5272 | 5272 | United States | Maine | ME | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 1344212 | 352 | 55 | 314.263157895399 | 37.7368421046008 | 297 | 4.0916165009686 | 2.80735792453875 | 0.120080388542272 | weekly | |||||||||
5424 | 5424 | United States | Maryland | MD | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 6045680 | 1635 | 455 | 1087.10526315875 | 547.894736841251 | 1180 | 7.52603511929179 | 9.06258248602723 | 0.503994190267518 | weekly | |||||||||
5576 | 5576 | United States | Massachusetts | MA | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 6949503 | 1611 | 371 | 1304.05263157967 | 306.947368420328 | 1240 | 5.33851125756763 | 4.41682474876733 | 0.235379585905597 | weekly | |||||||||
5728 | 5728 | United States | Michigan | MI | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 9986857 | 2831 | 754 | 2082.2631578955 | 748.736842104504 | 2077 | 7.54992286361966 | 7.49722201994586 | 0.359578393953451 | weekly | |||||||||
5880 | 5880 | United States | Minnesota | MN | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 5639632 | 1231 | 205 | 1000.39473684286 | 230.605263157138 | 1026 | 3.63498894963359 | 4.0890126014807 | 0.230514270681694 | weekly | |||||||||
6032 | 6032 | United States | Mississippi | MS | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 2976149 | 940 | 97 | 686.342105263827 | 253.657894736173 | 843 | 3.25924542084418 | 8.52302403999842 | 0.369579387292096 | weekly | |||||||||
6184 | 6184 | United States | Missouri | MO | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 6137428 | 1932 | 279 | 1403.85526315866 | 528.144736841336 | 1653 | 4.5458781756788 | 8.6053105118518 | 0.376210248094248 | weekly | |||||||||
6336 | 6336 | United States | Montana | MT | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 1068778 | 250 | 28 | 212.907894737649 | 37.0921052623507 | 222 | 2.61981440486238 | 3.47051541689207 | 0.174216673872317 | weekly | |||||||||
6488 | 6488 | United States | Nebraska | NE | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 1934408 | 487 | 72 | 385.289473685276 | 101.710526314724 | 415 | 3.72206897407372 | 5.25796658795476 | 0.263984700495104 | weekly | |||||||||
6640 | 6640 | United States | Nevada | NV | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 3080156 | 809 | 117 | 593.82894736925 | 215.17105263075 | 692 | 3.79850890669174 | 6.98571931521488 | 0.362345172939092 | weekly | |||||||||
6792 | 6792 | United States | New Hampshire | NH | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 1359711 | 330 | 60 | 264.105263158698 | 65.8947368413019 | 270 | 4.41270240514345 | 4.84623106243179 | 0.249501793539444 | weekly | |||||||||
6944 | 6944 | United States | New Jersey | NJ | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 8882190 | 2522 | 635 | 1627.78947368519 | 894.210526314815 | 1887 | 7.14913776895113 | 10.0674555071983 | 0.54934040351692 | weekly | |||||||||
7096 | 7096 | United States | New Mexico | NM | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 2096829 | 603 | 162 | 429.039473685051 | 173.960526314949 | 441 | 7.72595190165722 | 8.29636209318686 | 0.405465084181625 | weekly | |||||||||
7248 | 7248 | United States | New York | NY | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 19453561 | 4982 | 1281 | 3371.15789473765 | 1610.84210526235 | 3701 | 6.58491265429502 | 8.28044852694243 | 0.477830512708069 | weekly | |||||||||
7400 | 7400 | United States | North Carolina | NC | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 10488084 | 2751 | 284 | 2107.06578947434 | 643.934210525656 | 2467 | 2.70783491055182 | 6.13967442028168 | 0.305607073942528 | weekly | |||||||||
7552 | 7552 | United States | North Dakota | ND | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 762062 | 184 | 17 | 158.539473685105 | 25.4605263148945 | 167 | 2.23078962079201 | 3.34100457900991 | 0.160594240179356 | weekly | |||||||||
7704 | 7704 | United States | Ohio | OH | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 11689100 | 4050 | 850 | 2695.51315789704 | 1354.48684210296 | 3200 | 7.27173178431188 | 11.587605907238 | 0.502496839288179 | weekly | |||||||||
7856 | 7856 | United States | Oklahoma | OK | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 3956971 | 1262 | 154 | 855.381578948074 | 406.618421051926 | 1108 | 3.89186577308755 | 10.2760020493435 | 0.475364949467319 | weekly | |||||||||
8008 | 8008 | United States | Oregon | OR | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 4217737 | 1022 | 122 | 826.513157895668 | 195.486842104332 | 900 | 2.89254640580956 | 4.63487510255694 | 0.236519939503502 | weekly | |||||||||
8160 | 8160 | United States | Pennsylvania | PA | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 12801989 | 4079 | 969 | 2836.25000000109 | 1242.74999999891 | 3110 | 7.56913632717541 | 9.70747592424041 | 0.438166593212314 | weekly | |||||||||
8312 | 8312 | United States | Rhode Island | RI | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 1059361 | 284 | 54 | 221.539473685089 | 62.4605263149108 | 230 | 5.09741249677872 | 5.89605680357412 | 0.281938587629292 | weekly | |||||||||
8464 | 8464 | United States | South Carolina | SC | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 5148714 | 1508 | 168 | 1103.90789473781 | 404.092105262192 | 1340 | 3.26295070963351 | 7.84840846203911 | 0.36605599723351 | weekly | |||||||||
8616 | 8616 | United States | South Dakota | SD | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 884659 | 234 | 27 | 173.065789474372 | 60.9342105256282 | 207 | 3.05202343501846 | 6.88787550068763 | 0.352086976349832 | weekly | |||||||||
8768 | 8768 | United States | Tennessee | TN | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 6833174 | 2188 | 143 | 1695.63157894829 | 492.368421051715 | 2045 | 2.09273172320799 | 7.20555954014511 | 0.290374646924839 | weekly | |||||||||
8920 | 8920 | United States | Texas | TX | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 28995881 | 6106 | 126 | 4697.28947368478 | 1408.71052631522 | 5980 | 0.434544478920989 | 4.85831255244572 | 0.29989859773538 | weekly | |||||||||
9072 | 9072 | United States | Utah | UT | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 3205958 | 494 | 64 | 431.35526315873 | 62.6447368412695 | 430 | 1.99628317027235 | 1.95400990409948 | 0.145227709481355 | weekly | |||||||||
9224 | 9224 | United States | Vermont | VT | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 623989 | 148 | 14 | 115.434210527177 | 32.5657894728228 | 134 | 2.24362929474718 | 5.21896851912819 | 0.282115581889441 | weekly | |||||||||
9376 | 9376 | United States | Virginia | VA | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 8535519 | 2185 | 152 | 1536.88157894803 | 648.118421051972 | 2033 | 1.78079388025497 | 7.59319288085436 | 0.421710058816372 | weekly | |||||||||
9528 | 9528 | United States | Washington | WA | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 7614893 | 1631 | 192 | 1307.38157894819 | 323.618421051805 | 1439 | 2.52137488996891 | 4.24980917068441 | 0.247531727739472 | weekly | |||||||||
9680 | 9680 | United States | West Virginia | WV | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 1792147 | 660 | 95 | 521.460526316788 | 138.539473683212 | 565 | 5.30090444589646 | 7.73036328399465 | 0.265675859804293 | weekly | |||||||||
9832 | 9832 | United States | Wisconsin | WI | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 5822434 | 1593 | 239 | 1137.47368421138 | 455.526315788621 | 1354 | 4.10481252342234 | 7.82364069371368 | 0.40047196002116 | weekly | |||||||||
9984 | 9984 | United States | Wyoming | WY | 2022-01-09 | 2022-01-15 | 7 | 2022 | 2 | 578759 | 122 | 16 | 101.236842106118 | 20.763157893882 | 106 | 2.76453584307112 | 3.58753088831138 | 0.205094879116417 | 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);