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-07-10 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2410 | 2410 | United States | Alabama | AL | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 4903185 | 1113 | 36 | 1010.7167919629 | 102.283208037098 | 1077 | 0.734216636737141 | 2.08605647221343 | 0.101198682806541 | weekly | |||||||||
2562 | 2562 | United States | Alaska | AK | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 731545 | 131 | 0 | 98.4837092780077 | 32.5162907219923 | 131 | 0.0 | 4.44487908768324 | 0.330169232661645 | weekly | |||||||||
2714 | 2714 | United States | Arizona | AZ | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 7278717 | 1468 | 0 | 1188.06516291983 | 279.934837080171 | 1468 | 0.0 | 3.84593654458844 | 0.235622460633552 | weekly | |||||||||
2866 | 2866 | United States | Arkansas | AR | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 3017825 | 664 | 21 | 596.909774437875 | 67.0902255621248 | 643 | 0.69586539974982 | 2.22313174429017 | 0.11239592386522 | weekly | |||||||||
3018 | 3018 | United States | California | CA | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 39512223 | 5573 | -248 | 4843.42857142879 | 729.571428571207 | 5821 | -0.627653878142974 | 1.84644490534285 | 0.150631193959362 | weekly | |||||||||
3170 | 3170 | United States | Colorado | CO | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 5758736 | 823 | 63 | 746.621553885677 | 76.3784461143226 | 760 | 1.09399007004315 | 1.32630573991103 | 0.102298742538067 | weekly | |||||||||
3322 | 3322 | United States | Connecticut | CT | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 3565287 | 605 | 0 | 572.526315789867 | 32.4736842101328 | 605 | 0.0 | 0.910829456650552 | 0.0567199852906874 | weekly | |||||||||
3474 | 3474 | United States | Delaware | DE | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 973764 | 210 | 10 | 168.087719302892 | 41.9122806971081 | 200 | 1.02694287322185 | 4.30415179623688 | 0.249347667223581 | weekly | |||||||||
3626 | 3626 | United States | District of Columbia | DC | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 705749 | 120 | 0 | 110.375939850056 | 9.62406014994369 | 120 | 0.0 | 1.36366614050373 | 0.0871934604862055 | weekly | |||||||||
3778 | 3778 | United States | Florida | FL | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 21477737 | 4466 | 201 | 3882.48120300841 | 583.518796991588 | 4265 | 0.93585278560772 | 2.71685418715942 | 0.150295330867137 | weekly | |||||||||
3930 | 3930 | United States | Georgia | GA | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 10617423 | 1821 | 136 | 1619.06015037649 | 201.939849623513 | 1685 | 1.28091345706015 | 1.90196669779016 | 0.124726588803112 | weekly | |||||||||
4082 | 4082 | United States | Hawaii | HI | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 1415872 | 228 | 11 | 240.395989975748 | -12.3959899757479 | 217 | 0.776906387018036 | -0.875502162324554 | -0.0515648783367745 | weekly | |||||||||
4234 | 4234 | United States | Idaho | ID | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 1787065 | 364 | 1 | 270.395989975591 | 93.6040100244093 | 363 | 0.0559576736156771 | 5.23786264206446 | 0.346173809873656 | weekly | |||||||||
4386 | 4386 | United States | Illinois | IL | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 12671821 | 2057 | 77 | 1853.07017543901 | 203.929824560994 | 1980 | 0.607647472293051 | 1.60931743402147 | 0.110049704141767 | weekly | |||||||||
4538 | 4538 | United States | Indiana | IN | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 6732219 | 1431 | 52 | 1165.58897243292 | 265.411027567079 | 1379 | 0.772405056935908 | 3.94240038191091 | 0.227705506695975 | weekly | |||||||||
4690 | 4690 | United States | Iowa | IA | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 3155070 | 612 | 16 | 564.796992481664 | 47.2030075183362 | 596 | 0.507120285762281 | 1.49610016634611 | 0.0835751750570248 | weekly | |||||||||
4842 | 4842 | United States | Kansas | KS | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 2913314 | 531 | -4 | 486.120300752539 | 44.8796992474606 | 535 | -0.137300682315741 | 1.54050333220039 | 0.0923222074412124 | weekly | |||||||||
4994 | 4994 | United States | Kentucky | KY | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 4467673 | 952 | 62 | 883.213032583078 | 68.7869674169219 | 890 | 1.38774704415475 | 1.53965985014843 | 0.0778826453859551 | weekly | |||||||||
5146 | 5146 | United States | Louisiana | LA | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 4648794 | 983 | 43 | 841.566416040893 | 141.433583959107 | 940 | 0.92497107852058 | 3.04237150450433 | 0.168059919292496 | weekly | |||||||||
5298 | 5298 | United States | Maine | ME | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 1344212 | 298 | 3 | 276.491228070802 | 21.5087719291982 | 295 | 0.223179081871014 | 1.6001026571105 | 0.0777918781701474 | weekly | |||||||||
5450 | 5450 | United States | Maryland | MD | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 6045680 | 960 | 44 | 909.548872181288 | 50.4511278187116 | 916 | 0.727792407140305 | 0.834498812684621 | 0.0554682979241339 | weekly | |||||||||
5602 | 5602 | United States | Massachusetts | MA | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 6949503 | 1144 | 0 | 1063.25062656711 | 80.7493734328855 | 1144 | 0.0 | 1.16194457981938 | 0.0759457567343258 | weekly | |||||||||
5754 | 5754 | United States | Michigan | MI | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 9986857 | 1969 | 160 | 1777.06265664231 | 191.937343357692 | 1809 | 1.60210564745245 | 1.92189938593986 | 0.108008202547202 | weekly | |||||||||
5906 | 5906 | United States | Minnesota | MN | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 5639632 | 860 | 0 | 851.546365915518 | 8.45363408448179 | 860 | 0.0 | 0.14989690966506 | 0.00992739141736942 | weekly | |||||||||
6058 | 6058 | United States | Mississippi | MS | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 2976149 | 668 | 34 | 605.581453634724 | 62.4185463652761 | 634 | 1.14241592070827 | 2.09729238573997 | 0.103072090452304 | weekly | |||||||||
6210 | 6210 | United States | Missouri | MO | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 6137428 | 1332 | 0 | 1167.12030075263 | 164.879699247372 | 1332 | 0.0 | 2.68646246029072 | 0.141270526389651 | weekly | |||||||||
6362 | 6362 | United States | Montana | MT | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 1068778 | 224 | 5 | 185.513784461938 | 38.4862155380617 | 219 | 0.467824000868281 | 3.60095506625901 | 0.20745744392896 | weekly | |||||||||
6514 | 6514 | United States | Nebraska | NE | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 1934408 | 327 | 18 | 308.854636592531 | 18.1453634074688 | 309 | 0.93051724351843 | 0.938031863364336 | 0.0587504970223509 | weekly | |||||||||
6666 | 6666 | United States | Nevada | NV | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 3080156 | 642 | 67 | 515.375939850434 | 126.624060149566 | 575 | 2.17521450212262 | 4.11096256649229 | 0.245692610691748 | weekly | |||||||||
6818 | 6818 | United States | New Hampshire | NH | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 1359711 | 269 | 7 | 216.977443609802 | 52.022556390198 | 262 | 0.514815280600069 | 3.82600099507896 | 0.239760205137968 | weekly | |||||||||
6970 | 6970 | United States | New Jersey | NJ | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 8882190 | 1436 | 52 | 1331.56892230672 | 104.431077693278 | 1384 | 0.585441203126706 | 1.17573568785713 | 0.078427091488714 | weekly | |||||||||
7122 | 7122 | United States | New Mexico | NM | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 2096829 | 377 | 93 | 368.283208020879 | 8.7167919791205 | 284 | 4.4352686842847 | 0.415713059058249 | 0.0236687195866565 | weekly | |||||||||
7274 | 7274 | United States | New York | NY | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 19453561 | 2973 | 119 | 2755.79949874766 | 217.200501252335 | 2854 | 0.611713197393526 | 1.11650767308019 | 0.0788157851654443 | weekly | |||||||||
7426 | 7426 | United States | North Carolina | NC | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 10488084 | 1947 | 138 | 1752.0751879706 | 194.924812029399 | 1809 | 1.31577893540898 | 1.85853595403507 | 0.111253679846455 | weekly | |||||||||
7578 | 7578 | United States | North Dakota | ND | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 762062 | 118 | 0 | 144.568922306657 | -26.5689223066575 | 118 | 0.0 | -3.48645153631299 | -0.18378031656278 | weekly | |||||||||
7730 | 7730 | United States | Ohio | OH | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 11689100 | 2404 | 39 | 2232.96741854877 | 171.032581451233 | 2365 | 0.333644164221369 | 1.46318006904923 | 0.0765943022860538 | weekly | |||||||||
7882 | 7882 | United States | Oklahoma | OK | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 3956971 | 911 | 30 | 735.531328321475 | 175.468671678525 | 881 | 0.758155670081989 | 4.43441894516096 | 0.238560432332576 | weekly | |||||||||
8034 | 8034 | United States | Oregon | OR | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 4217737 | 839 | 59 | 695.110275690154 | 143.889724309846 | 780 | 1.39885440936692 | 3.41153856463421 | 0.207002729411506 | weekly | |||||||||
8186 | 8186 | United States | Pennsylvania | PA | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 12801989 | 2492 | 128 | 2290.57142857252 | 201.42857142748 | 2364 | 0.999844633517495 | 1.57341622014736 | 0.0879381314701067 | weekly | |||||||||
8338 | 8338 | United States | Rhode Island | RI | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 1059361 | 214 | 6 | 185.711779449491 | 28.2882205505086 | 208 | 0.566379166308747 | 2.6703097952925 | 0.152323243223256 | weekly | |||||||||
8490 | 8490 | United States | South Carolina | SC | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 5148714 | 1047 | 0 | 927.609022557349 | 119.390977442651 | 1047 | 0.0 | 2.31885044387105 | 0.128708296857116 | weekly | |||||||||
8642 | 8642 | United States | South Dakota | SD | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 884659 | 166 | 5 | 150.218045113447 | 15.781954886553 | 161 | 0.565189525003419 | 1.78395911719125 | 0.105060313324103 | weekly | |||||||||
8794 | 8794 | United States | Tennessee | TN | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 6833174 | 1525 | 81 | 1428.38847117886 | 96.611528821139 | 1444 | 1.18539349356536 | 1.41386021812322 | 0.0676367324229414 | weekly | |||||||||
8946 | 8946 | United States | Texas | TX | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 28995881 | 4528 | 86 | 3783.23558897301 | 744.76441102699 | 4442 | 0.296593850692103 | 2.56851795959223 | 0.196859115302719 | weekly | |||||||||
9098 | 9098 | United States | Utah | UT | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 3205958 | 435 | 22 | 366.215538847942 | 68.7844611520578 | 413 | 0.68622233978112 | 2.14551972147039 | 0.187825075277917 | weekly | |||||||||
9250 | 9250 | United States | Vermont | VT | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 623989 | 133 | 1 | 88.8295739356867 | 44.1704260643133 | 132 | 0.160259235339084 | 7.07871870566842 | 0.497249104181148 | weekly | |||||||||
9402 | 9402 | United States | Virginia | VA | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 8535519 | 1542 | 61 | 1328.81704260717 | 213.182957392834 | 1481 | 0.714660701944428 | 2.49759806513036 | 0.160430631574806 | weekly | |||||||||
9554 | 9554 | United States | Washington | WA | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 7614893 | 1249 | 60 | 1088.91228070257 | 160.087719297432 | 1189 | 0.787929653115284 | 2.10229768556738 | 0.147016175806323 | weekly | |||||||||
9706 | 9706 | United States | West Virginia | WV | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 1792147 | 464 | 11 | 410.38345864762 | 53.6165413523798 | 453 | 0.613788935840643 | 2.99174907819391 | 0.130649859838572 | weekly | |||||||||
9858 | 9858 | United States | Wisconsin | WI | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 5822434 | 1093 | -66 | 1030.82706767002 | 62.1729323299787 | 1159 | -1.13354655458525 | 1.06781686713802 | 0.0603136396781938 | weekly | |||||||||
10010 | 10010 | United States | Wyoming | WY | 2022-07-10 | 2022-07-16 | 7 | 2022 | 28 | 578759 | 99 | 11 | 95.2230576449569 | 3.77694235504313 | 88 | 1.9006183921114 | 0.652593282358137 | 0.0396641574893091 | 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);