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-06-12 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2406 | 2406 | United States | Alabama | AL | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 4903185 | 1078 | 4 | 965.383458628688 | 112.616541371312 | 1074 | 0.0815796263041268 | 2.29680384018371 | 0.116654724466982 | weekly | |||||||||
2558 | 2558 | United States | Alaska | AK | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 731545 | 107 | 0 | 92.4837092780877 | 14.5162907219123 | 107 | 0.0 | 1.98433325658877 | 0.156960515913819 | weekly | |||||||||
2710 | 2710 | United States | Arizona | AZ | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 7278717 | 1440 | 0 | 1223.73182958656 | 216.268170413443 | 1440 | 0.0 | 2.97124026684158 | 0.176728401750006 | weekly | |||||||||
2862 | 2862 | United States | Arkansas | AR | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 3017825 | 649 | 21 | 626.909774437951 | 22.0902255620489 | 628 | 0.69586539974982 | 0.731991601966611 | 0.035236690290646 | weekly | |||||||||
3014 | 3014 | United States | California | CA | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 39512223 | 5445 | 396 | 4958.09523809554 | 486.904761904461 | 5049 | 1.00222151509926 | 1.23228896006297 | 0.0982039953898681 | weekly | |||||||||
3166 | 3166 | United States | Colorado | CO | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 5758736 | 851 | 159 | 765.621553885746 | 85.378446114254 | 692 | 2.76102255772795 | 1.48259003563028 | 0.111515207064031 | weekly | |||||||||
3318 | 3318 | United States | Connecticut | CT | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 3565287 | 607 | 15 | 554.526315789947 | 52.4736842100533 | 592 | 0.420723492947412 | 1.47179411391154 | 0.0946279422921565 | weekly | |||||||||
3470 | 3470 | United States | Delaware | DE | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 973764 | 206 | 7 | 163.754385969637 | 42.2456140303635 | 199 | 0.718860011255294 | 4.33838322533627 | 0.257981572708512 | weekly | |||||||||
3622 | 3622 | United States | District of Columbia | DC | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 705749 | 132 | 1 | 104.042606516803 | 27.9573934831974 | 131 | 0.14169343491808 | 3.96137911399058 | 0.26871100618459 | weekly | |||||||||
3774 | 3774 | United States | Florida | FL | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 21477737 | 4445 | 545 | 3892.81453634179 | 552.185463658207 | 3900 | 2.53751128435924 | 2.57096668824191 | 0.141847359668235 | weekly | |||||||||
3926 | 3926 | United States | Georgia | GA | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 10617423 | 1818 | 70 | 1622.06015037655 | 195.939849623453 | 1748 | 0.659293691133903 | 1.84545580997812 | 0.120796907302092 | weekly | |||||||||
4078 | 4078 | United States | Hawaii | HI | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 1415872 | 243 | 9 | 249.729323309159 | -6.72932330915924 | 234 | 0.635650680287484 | -0.475277659926832 | -0.0269464683601793 | weekly | |||||||||
4230 | 4230 | United States | Idaho | ID | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 1787065 | 293 | 3 | 278.395989975668 | 14.6040100243319 | 290 | 0.167873020847031 | 0.817206426421641 | 0.0524576881499201 | weekly | |||||||||
4382 | 4382 | United States | Illinois | IL | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 12671821 | 2113 | 249 | 1838.40350877243 | 274.596491227573 | 1864 | 1.96498987793467 | 2.16698524409059 | 0.149366822853233 | weekly | |||||||||
4534 | 4534 | United States | Indiana | IN | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 6732219 | 1267 | 28 | 1217.92230576633 | 49.0776942336699 | 1239 | 0.415910415273181 | 0.72899729247771 | 0.0402962438583385 | weekly | |||||||||
4686 | 4686 | United States | Iowa | IA | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 3155070 | 608 | 0 | 576.463659148408 | 31.5363408515924 | 608 | 0.0 | 0.999544886534765 | 0.0547065549599086 | weekly | |||||||||
4838 | 4838 | United States | Kansas | KS | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 2913314 | 529 | -3 | 482.786967419282 | 46.2130325807175 | 532 | -0.102975511736806 | 1.58627022630302 | 0.0957213754707327 | weekly | |||||||||
4990 | 4990 | United States | Kentucky | KY | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 4467673 | 1034 | 59 | 928.546365916486 | 105.453634083514 | 975 | 1.32059799363114 | 2.36037046765763 | 0.113568517366852 | weekly | |||||||||
5142 | 5142 | United States | Louisiana | LA | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 4648794 | 904 | 17 | 831.233082707639 | 72.7669172923606 | 887 | 0.365686240345345 | 1.56528590624495 | 0.0875409302230024 | weekly | |||||||||
5294 | 5294 | United States | Maine | ME | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 1344212 | 318 | 5 | 278.491228070878 | 39.5087719291224 | 313 | 0.371965136451691 | 2.93917714833095 | 0.141867204230459 | weekly | |||||||||
5446 | 5446 | United States | Maryland | MD | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 6045680 | 995 | 51 | 934.215538848031 | 60.7844611519695 | 944 | 0.843577562821717 | 1.00541975678451 | 0.0650647079012645 | weekly | |||||||||
5598 | 5598 | United States | Massachusetts | MA | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 6949503 | 1094 | 83 | 1050.58395990053 | 43.4160400994706 | 1011 | 1.19433001180084 | 0.624735899811405 | 0.0413256262770101 | weekly | |||||||||
5750 | 5750 | United States | Michigan | MI | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 9986857 | 1934 | 137 | 1843.06265664238 | 90.9373433576184 | 1797 | 1.37180296063116 | 0.910570195984767 | 0.0493403428417807 | weekly | |||||||||
5902 | 5902 | United States | Minnesota | MN | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 5639632 | 892 | 31 | 827.213032582254 | 64.7869674177458 | 861 | 0.549681255798251 | 1.14878005192087 | 0.0783195680748703 | weekly | |||||||||
6054 | 6054 | United States | Mississippi | MS | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 2976149 | 603 | 10 | 598.24812030147 | 4.75187969852959 | 593 | 0.336004682561256 | 0.159665382967371 | 0.00794299143996469 | weekly | |||||||||
6206 | 6206 | United States | Missouri | MO | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 6137428 | 1305 | 0 | 1158.78696741938 | 146.213032580624 | 1305 | 0.0 | 2.3823176838999 | 0.126177663963758 | weekly | |||||||||
6358 | 6358 | United States | Montana | MT | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 1068778 | 197 | 6 | 196.180451128684 | 0.819548871316243 | 191 | 0.561388801041938 | 0.0766809263772498 | 0.00417752567394536 | weekly | |||||||||
6510 | 6510 | United States | Nebraska | NE | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 1934408 | 286 | 7 | 302.854636592612 | -16.8546365926123 | 279 | 0.361867816923834 | -0.871307221259025 | -0.0556525625040519 | weekly | |||||||||
6662 | 6662 | United States | Nevada | NV | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 3080156 | 602 | 32 | 529.709273183838 | 72.2907268161624 | 570 | 1.03890841892424 | 2.34698264685822 | 0.136472458527404 | weekly | |||||||||
6814 | 6814 | United States | New Hampshire | NH | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 1359711 | 274 | 8 | 215.644110276549 | 58.3558897234513 | 266 | 0.588360320685793 | 4.29178624894932 | 0.270612026679578 | weekly | |||||||||
6966 | 6966 | United States | New Jersey | NJ | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 8882190 | 1439 | 75 | 1327.23558897347 | 111.764411026527 | 1364 | 0.844386350663519 | 1.25829790880996 | 0.084208419330414 | weekly | |||||||||
7118 | 7118 | United States | New Mexico | NM | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 2096829 | 387 | 10 | 371.949874687618 | 15.0501253123825 | 377 | 0.476910611213408 | 0.717756446156672 | 0.0404627782843652 | weekly | |||||||||
7270 | 7270 | United States | New York | NY | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 19453561 | 2979 | 165 | 2837.13283208108 | 141.867167918922 | 2814 | 0.848173761091864 | 0.729260662965112 | 0.0500037101945843 | weekly | |||||||||
7422 | 7422 | United States | North Carolina | NC | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 10488084 | 1961 | 46 | 1838.40852130398 | 122.591478696017 | 1915 | 0.438592978469661 | 1.168864386441 | 0.0666834804535514 | weekly | |||||||||
7574 | 7574 | United States | North Dakota | ND | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 762062 | 114 | 0 | 145.2355889734 | -31.2355889733998 | 114 | 0.0 | -4.09882515771681 | -0.215068422238579 | weekly | |||||||||
7726 | 7726 | United States | Ohio | OH | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 11689100 | 2327 | 0 | 2193.30075188219 | 133.699248117805 | 2327 | 0.0 | 1.14379420244335 | 0.0609580095219822 | weekly | |||||||||
7878 | 7878 | United States | Oklahoma | OK | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 3956971 | 816 | 0 | 729.19799498822 | 86.8020050117799 | 816 | 0.0 | 2.19364774247221 | 0.119037635331378 | weekly | |||||||||
8030 | 8030 | United States | Oregon | OR | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 4217737 | 803 | 34 | 690.776942356895 | 112.223057643105 | 769 | 0.806119490143648 | 2.66074100028296 | 0.162459182931332 | weekly | |||||||||
8182 | 8182 | United States | Pennsylvania | PA | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 12801989 | 2551 | 139 | 2402.90476190596 | 148.095238094042 | 2412 | 1.0857687817104 | 1.15681428951424 | 0.0616317552163717 | weekly | |||||||||
8334 | 8334 | United States | Rhode Island | RI | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 1059361 | 193 | 6 | 187.378446116235 | 5.62155388376493 | 187 | 0.566379166308747 | 0.530655167007746 | 0.0300010700285014 | weekly | |||||||||
8486 | 8486 | United States | South Carolina | SC | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 5148714 | 1019 | 0 | 955.27568922408 | 63.7243107759203 | 1019 | 0.0 | 1.23767431587617 | 0.0667077698037937 | weekly | |||||||||
8638 | 8638 | United States | South Dakota | SD | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 884659 | 138 | 3 | 156.551378446855 | -18.5513784468546 | 135 | 0.339113715002052 | -2.09700895450729 | -0.118500256151704 | weekly | |||||||||
8790 | 8790 | United States | Tennessee | TN | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 6833174 | 1633 | 77 | 1415.38847117892 | 217.611528821076 | 1556 | 1.12685554326584 | 3.1846332146829 | 0.153746856959927 | weekly | |||||||||
8942 | 8942 | United States | Texas | TX | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 28995881 | 4366 | 103 | 3844.90225563973 | 521.097744360274 | 4263 | 0.35522286768938 | 1.79714403007887 | 0.135529516672608 | weekly | |||||||||
9094 | 9094 | United States | Utah | UT | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 3205958 | 444 | 13 | 384.215538848014 | 59.7844611519865 | 431 | 0.405495018961571 | 1.86479240064862 | 0.155601362014762 | weekly | |||||||||
9246 | 9246 | United States | Vermont | VT | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 623989 | 112 | 6 | 110.829573935765 | 1.17042606423469 | 106 | 0.961555412034507 | 0.187571586075186 | 0.0105605933747706 | weekly | |||||||||
9398 | 9398 | United States | Virginia | VA | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 8535519 | 1381 | 12 | 1334.15037594056 | 46.8496240594434 | 1369 | 0.140588990546445 | 0.548878446166465 | 0.0351156997774071 | weekly | |||||||||
9550 | 9550 | United States | Washington | WA | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 7614893 | 1234 | 69 | 1047.57894736931 | 186.421052630695 | 1165 | 0.906119101082576 | 2.44811125554482 | 0.177954180063314 | weekly | |||||||||
9702 | 9702 | United States | West Virginia | WV | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 1792147 | 519 | 18 | 422.050125314362 | 96.9498746856377 | 501 | 1.00438189501196 | 5.40970549210738 | 0.229711754293225 | weekly | |||||||||
9854 | 9854 | United States | Wisconsin | WI | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 5822434 | 1038 | 64 | 984.493734336751 | 53.5062656632491 | 974 | 1.09919665899176 | 0.918967319565136 | 0.0543490159429973 | weekly | |||||||||
10006 | 10006 | United States | Wyoming | WY | 2022-06-12 | 2022-06-18 | 7 | 2022 | 24 | 578759 | 104 | 0 | 90.5563909783634 | 13.4436090216366 | 104 | 0.0 | 2.3228336875343 | 0.14845566255891 | 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);