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 2021-10-10 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2371 | 2371 | United States | Alabama | AL | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 4903185 | 1278 | 386 | 958.704260638939 | 319.295739361061 | 892 | 7.87243393834824 | 6.51200677439381 | 0.333049254572274 | weekly | |||||||||
2523 | 2523 | United States | Alaska | AK | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 731545 | 162 | 84 | 92.6127819587115 | 69.3872180412885 | 78 | 11.4825472117231 | 9.48502389344313 | 0.74921859136272 | weekly | |||||||||
2675 | 2675 | United States | Arizona | AZ | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 7278717 | 1554 | 172 | 1141.21553885742 | 412.784461142578 | 1382 | 2.36305381841333 | 5.67111568072475 | 0.361705959205441 | weekly | |||||||||
2827 | 2827 | United States | Arkansas | AR | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 3017825 | 743 | 382 | 574.098997495295 | 168.901002504705 | 361 | 12.6581229859253 | 5.5967792202896 | 0.294201876752256 | weekly | |||||||||
2979 | 2979 | United States | California | CA | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 39512223 | 5996 | 682 | 4856.90476190519 | 1139.09523809481 | 5314 | 1.72604816489318 | 2.88289332163064 | 0.234531104465795 | weekly | |||||||||
3131 | 3131 | United States | Colorado | CO | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 5758736 | 1035 | 107 | 795.79949874789 | 239.20050125211 | 928 | 1.85804662689868 | 4.15369798601828 | 0.300578853880239 | weekly | |||||||||
3283 | 3283 | United States | Connecticut | CT | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 3565287 | 630 | 51 | 582.72807017602 | 47.2719298239804 | 579 | 1.4304598760212 | 1.325894095594 | 0.0811217654397554 | weekly | |||||||||
3435 | 3435 | United States | Delaware | DE | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 973764 | 233 | 44 | 179.482456144155 | 53.5175438558451 | 189 | 4.51854864217613 | 5.49594602550978 | 0.298177019668493 | weekly | |||||||||
3587 | 3587 | United States | District of Columbia | DC | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 705749 | 130 | 1 | 121.948621554311 | 8.05137844568937 | 129 | 0.14169343491808 | 1.14082746779512 | 0.0660227097532515 | weekly | |||||||||
3739 | 3739 | United States | Florida | FL | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 21477737 | 4924 | 1727 | 3921.69423558994 | 1002.30576441006 | 3197 | 8.0408843818136 | 4.66671961021808 | 0.255579783684816 | weekly | |||||||||
3891 | 3891 | United States | Georgia | GA | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 10617423 | 2159 | 632 | 1627.04511278247 | 531.954887217526 | 1527 | 5.95248018280896 | 5.01020715871946 | 0.32694538279139 | weekly | |||||||||
4043 | 4043 | United States | Hawaii | HI | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 1415872 | 262 | 36 | 206.463659148726 | 55.5363408512741 | 226 | 2.54260272114993 | 3.92241253808777 | 0.268988455790511 | weekly | |||||||||
4195 | 4195 | United States | Idaho | ID | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 1787065 | 477 | 134 | 260.463659148599 | 216.536340851401 | 343 | 7.49832826450073 | 12.1168698872957 | 0.831349530906588 | weekly | |||||||||
4347 | 4347 | United States | Illinois | IL | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 12671821 | 2184 | 235 | 1903.05263157942 | 280.94736842058 | 1949 | 1.85450851933593 | 2.21710335413181 | 0.147629846783276 | weekly | |||||||||
4499 | 4499 | United States | Indiana | IN | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 6732219 | 1607 | 263 | 1211.85839599158 | 395.141604008416 | 1344 | 3.90658711488738 | 5.86941102195897 | 0.326062521261073 | weekly | |||||||||
4651 | 4651 | United States | Iowa | IA | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 3155070 | 674 | 97 | 567.431077694803 | 106.568922305197 | 577 | 3.07441673243383 | 3.37770389579938 | 0.187809456503749 | weekly | |||||||||
4803 | 4803 | United States | Kansas | KS | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 2913314 | 601 | 37 | 479.256892231295 | 121.743107768705 | 564 | 1.2700313114206 | 4.17885294097051 | 0.254024740681144 | weekly | |||||||||
4955 | 4955 | United States | Kentucky | KY | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 4467673 | 1291 | 240 | 907.909774437539 | 383.090225562461 | 1051 | 5.37192404188937 | 8.57471497046586 | 0.421947462565639 | weekly | |||||||||
5107 | 5107 | United States | Louisiana | LA | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 4648794 | 1039 | 148 | 848.591478697598 | 190.408521302402 | 891 | 3.18362138653595 | 4.09586919322306 | 0.224381844600463 | weekly | |||||||||
5259 | 5259 | United States | Maine | ME | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 1344212 | 380 | 20 | 298.868421053322 | 81.1315789466782 | 360 | 1.48786054580676 | 6.03562376668846 | 0.27146253411699 | weekly | |||||||||
5411 | 5411 | United States | Maryland | MD | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 6045680 | 1093 | 126 | 925.828320802869 | 167.171679197131 | 967 | 2.08413280226542 | 2.7651427001947 | 0.180564447469225 | weekly | |||||||||
5563 | 5563 | United States | Massachusetts | MA | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 6949503 | 1241 | 70 | 1065.68796992556 | 175.312030074444 | 1171 | 1.00726627501276 | 2.52265564997158 | 0.164505967057778 | weekly | |||||||||
5715 | 5715 | United States | Michigan | MI | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 9986857 | 2194 | 267 | 1811.79699248201 | 382.203007517993 | 1927 | 2.67351379918627 | 3.82705998011179 | 0.210952446164737 | weekly | |||||||||
5867 | 5867 | United States | Minnesota | MN | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 5639632 | 1020 | 112 | 901.909774436867 | 118.090225563133 | 908 | 1.98594518223884 | 2.09393495113037 | 0.130933524516757 | weekly | |||||||||
6019 | 6019 | United States | Mississippi | MS | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 2976149 | 701 | 106 | 591.602756892921 | 109.397243107079 | 595 | 3.56164963514932 | 3.67579859432707 | 0.184916722974095 | weekly | |||||||||
6171 | 6171 | United States | Missouri | MO | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 6137428 | 1479 | 140 | 1147.25689223136 | 331.743107768643 | 1339 | 2.28108582292126 | 5.40524642844923 | 0.28916200897553 | weekly | |||||||||
6323 | 6323 | United States | Montana | MT | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 1068778 | 352 | 49 | 199.802005013351 | 152.197994986649 | 303 | 4.58467520850916 | 14.240374987757 | 0.761744082480449 | weekly | |||||||||
6475 | 6475 | United States | Nebraska | NE | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 1934408 | 409 | 50 | 335.057644111343 | 73.9423558886574 | 359 | 2.58477012088453 | 3.82247984337624 | 0.220685476628272 | weekly | |||||||||
6627 | 6627 | United States | Nevada | NV | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 3080156 | 685 | 137 | 504.115288221389 | 180.884711778611 | 548 | 4.44782666851939 | 5.87258281004633 | 0.358816159725695 | weekly | |||||||||
6779 | 6779 | United States | New Hampshire | NH | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 1359711 | 288 | 23 | 243.066416040912 | 44.9335839590875 | 265 | 1.69153592197165 | 3.30464223346634 | 0.184861342389334 | weekly | |||||||||
6931 | 6931 | United States | New Jersey | NJ | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 8882190 | 1546 | 0 | 1354.51002506364 | 191.489974936362 | 1546 | 0.0 | 2.15588694833551 | 0.141372135601112 | weekly | |||||||||
7083 | 7083 | United States | New Mexico | NM | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 2096829 | 465 | 61 | 371.295739349212 | 93.7042606507881 | 404 | 2.90915472840179 | 4.46885562202679 | 0.252370955872071 | weekly | |||||||||
7235 | 7235 | United States | New York | NY | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 19453561 | 3251 | 368 | 2914.84962406096 | 336.150375939038 | 2883 | 1.8916845095867 | 1.7279632039555 | 0.115323402334119 | weekly | |||||||||
7387 | 7387 | United States | North Carolina | NC | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 10488084 | 2390 | 352 | 1829.05639097807 | 560.943609021928 | 2038 | 3.35618974828958 | 5.34838974422715 | 0.306684699164452 | weekly | |||||||||
7539 | 7539 | United States | North Dakota | ND | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 762062 | 207 | 45 | 133.343358396876 | 73.6566416031237 | 162 | 5.90503134915532 | 9.66543950533207 | 0.552383279442354 | weekly | |||||||||
7691 | 7691 | United States | Ohio | OH | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 11689100 | 3109 | 202 | 2251.0588972453 | 857.941102754699 | 2907 | 1.72810567109529 | 7.33966774819874 | 0.381127790038986 | weekly | |||||||||
7843 | 7843 | United States | Oklahoma | OK | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 3956971 | 964 | 140 | 701.065162907995 | 262.934837092005 | 824 | 3.53805979371595 | 6.64485125344626 | 0.375050496021454 | weekly | |||||||||
7995 | 7995 | United States | Oregon | OR | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 4217737 | 963 | 179 | 710.082706767838 | 252.917293232162 | 784 | 4.24398202163862 | 5.99651645496535 | 0.356180048917673 | weekly | |||||||||
8147 | 8147 | United States | Pennsylvania | PA | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 12801989 | 3130 | 511 | 2413.09523809634 | 716.904761903656 | 2619 | 3.99156724787062 | 5.59994827291022 | 0.297089294523333 | weekly | |||||||||
8299 | 8299 | United States | Rhode Island | RI | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 1059361 | 231 | 6 | 190.533834587341 | 40.466165412659 | 225 | 0.566379166308747 | 3.81986550502228 | 0.212383094584229 | weekly | |||||||||
8451 | 8451 | United States | South Carolina | SC | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 5148714 | 1320 | 303 | 934.873433584921 | 385.126566415079 | 1017 | 5.88496467273187 | 7.48005359037381 | 0.41195583549556 | weekly | |||||||||
8603 | 8603 | United States | South Dakota | SD | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 884659 | 198 | 10 | 174.080200501952 | 23.9197994980478 | 188 | 1.13037905000684 | 2.70384402329573 | 0.137406778192328 | weekly | |||||||||
8755 | 8755 | United States | Tennessee | TN | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 6833174 | 1851 | 271 | 1407.04135338436 | 443.958646615636 | 1580 | 3.96594613279275 | 6.49710729765752 | 0.315526367116205 | weekly | |||||||||
8907 | 8907 | United States | Texas | TX | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 28995881 | 5281 | 322 | 3916.67669172987 | 1364.32330827013 | 4959 | 1.11050255724253 | 4.70523143707938 | 0.348336974341262 | weekly | |||||||||
9059 | 9059 | United States | Utah | UT | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 3205958 | 503 | 73 | 387.32832080284 | 115.67167919716 | 430 | 2.2770104910919 | 3.60802228841302 | 0.298639869548915 | weekly | |||||||||
9211 | 9211 | United States | Vermont | VT | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 623989 | 129 | 10 | 101.872180451987 | 27.1278195480127 | 119 | 1.60259235339085 | 4.34748361718119 | 0.266292715318861 | weekly | |||||||||
9363 | 9363 | United States | Virginia | VA | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 8535519 | 1698 | 316 | 1309.61278195555 | 388.387218044452 | 1382 | 3.70217675105638 | 4.55024724383428 | 0.296566453379068 | weekly | |||||||||
9515 | 9515 | United States | Washington | WA | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 7614893 | 1437 | 212 | 1104.01754386048 | 332.982456139521 | 1225 | 2.784018107674 | 4.37277918599146 | 0.301609750670413 | weekly | |||||||||
9667 | 9667 | United States | West Virginia | WV | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 1792147 | 637 | 242 | 443.537593985942 | 193.462406014058 | 395 | 13.5033565884941 | 10.7950076647762 | 0.436180401925951 | weekly | |||||||||
9819 | 9819 | United States | Wisconsin | WI | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 5822434 | 1270 | 122 | 1064.45363408606 | 205.546365913939 | 1148 | 2.09534363120303 | 3.53024810438279 | 0.193100346818226 | weekly | |||||||||
9971 | 9971 | United States | Wyoming | WY | 2021-10-10 | 2021-10-16 | 7 | 2021 | 41 | 578759 | 150 | 39 | 97.4172932339354 | 52.5827067660646 | 111 | 6.73855611748586 | 9.08542359878025 | 0.539767684160489 | 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);