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-11-14 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2376 | 2376 | United States | Alabama | AL | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 4903185 | 1115 | 129 | 1049.37092730557 | 65.629072694428 | 986 | 2.63094294830809 | 1.33849880627445 | 0.0625413483323205 | weekly | |||||||||
2528 | 2528 | United States | Alaska | AK | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 731545 | 131 | 24 | 93.2794486253891 | 37.7205513746109 | 107 | 3.28072777477804 | 5.15628585727617 | 0.404382229209962 | weekly | |||||||||
2680 | 2680 | United States | Arizona | AZ | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 7278717 | 1769 | 286 | 1218.21553885743 | 550.784461142568 | 1483 | 3.9292639073617 | 7.56705420945158 | 0.452123982640338 | weekly | |||||||||
2832 | 2832 | United States | Arkansas | AR | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 3017825 | 748 | 48 | 655.098997495307 | 92.9010025046932 | 700 | 1.59054948514245 | 3.07840920214702 | 0.141812157948477 | weekly | |||||||||
2984 | 2984 | United States | California | CA | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 39512223 | 6076 | 620 | 4997.57142857187 | 1078.42857142813 | 5456 | 1.56913469535743 | 2.7293543353107 | 0.215790526827209 | weekly | |||||||||
3136 | 3136 | United States | Colorado | CO | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 5758736 | 1165 | 260 | 811.466165414569 | 353.533834585431 | 905 | 4.51487965414633 | 6.13908737239268 | 0.43567292100813 | weekly | |||||||||
3288 | 3288 | United States | Connecticut | CT | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 3565287 | 680 | 41 | 627.394736842699 | 52.605263157301 | 639 | 1.14997754738959 | 1.47548467086383 | 0.0838471540613039 | weekly | |||||||||
3440 | 3440 | United States | Delaware | DE | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 973764 | 193 | 29 | 198.482456144165 | -5.4824561441655 | 164 | 2.97813433234336 | -0.563016926500209 | -0.0276218676988931 | weekly | |||||||||
3592 | 3592 | United States | District of Columbia | DC | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 705749 | 121 | 2 | 105.615288220989 | 15.3847117790114 | 119 | 0.28338686983616 | 2.17991265719278 | 0.145667469531689 | weekly | |||||||||
3744 | 3744 | United States | Florida | FL | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 21477737 | 4576 | 303 | 4092.69423558994 | 483.30576441006 | 4273 | 1.41076315442358 | 2.25026391006678 | 0.118089878351343 | weekly | |||||||||
3896 | 3896 | United States | Georgia | GA | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 10617423 | 1982 | 301 | 1699.71177944914 | 282.288220550859 | 1681 | 2.83496287187578 | 2.65872632700853 | 0.166080051902885 | weekly | |||||||||
4048 | 4048 | United States | Hawaii | HI | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 1415872 | 238 | 22 | 221.796992482069 | 16.2030075179308 | 216 | 1.55381277403607 | 1.14438363905288 | 0.0730533238372952 | weekly | |||||||||
4200 | 4200 | United States | Idaho | ID | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 1787065 | 401 | 110 | 281.46365914861 | 119.53634085139 | 291 | 6.15534409772448 | 6.68897554657443 | 0.424695469436345 | weekly | |||||||||
4352 | 4352 | United States | Illinois | IL | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 12671821 | 2392 | 171 | 2044.05263157944 | 347.947368420562 | 2221 | 1.34945088002742 | 2.74583557028277 | 0.170224270669441 | weekly | |||||||||
4504 | 4504 | United States | Indiana | IN | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 6732219 | 1652 | 159 | 1297.19172932493 | 354.808270675072 | 1493 | 2.36177700101556 | 5.27030197138673 | 0.273520299778443 | weekly | |||||||||
4656 | 4656 | United States | Iowa | IA | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 3155070 | 775 | 102 | 610.097744361481 | 164.902255638519 | 673 | 3.23289182173454 | 5.22657993764065 | 0.270288256533554 | weekly | |||||||||
4808 | 4808 | United States | Kansas | KS | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 2913314 | 575 | 16 | 514.256892231306 | 60.7431077686938 | 559 | 0.549202729262963 | 2.08501753565506 | 0.118118218124673 | weekly | |||||||||
4960 | 4960 | United States | Kentucky | KY | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 4467673 | 1185 | 392 | 965.243107770884 | 219.756892229116 | 793 | 8.77414260175263 | 4.91882221973534 | 0.227669993662653 | weekly | |||||||||
5112 | 5112 | United States | Louisiana | LA | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 4648794 | 1012 | 64 | 899.924812030945 | 112.075187969055 | 948 | 1.37670114012365 | 2.41084436025892 | 0.124538390841924 | weekly | |||||||||
5264 | 5264 | United States | Maine | ME | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 1344212 | 374 | 41 | 308.201754386667 | 65.7982456133332 | 333 | 3.05011411890386 | 4.89493068156907 | 0.213490821115779 | weekly | |||||||||
5416 | 5416 | United States | Maryland | MD | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 6045680 | 1070 | 85 | 996.828320802881 | 73.1716791971189 | 985 | 1.40596260470286 | 1.21031346675839 | 0.0734044947059529 | weekly | |||||||||
5568 | 5568 | United States | Massachusetts | MA | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 6949503 | 1267 | 109 | 1143.35463659224 | 123.645363407761 | 1158 | 1.56845748537701 | 1.77919720889049 | 0.10814261774132 | weekly | |||||||||
5720 | 5720 | United States | Michigan | MI | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 9986857 | 2622 | 533 | 1917.79699248202 | 704.203007517985 | 2089 | 5.33701443807596 | 7.05129759560976 | 0.367193717728488 | weekly | |||||||||
5872 | 5872 | United States | Minnesota | MN | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 5639632 | 1196 | 159 | 937.909774436875 | 258.090225563125 | 1037 | 2.81933289264264 | 4.57636642892879 | 0.275175963186953 | weekly | |||||||||
6024 | 6024 | United States | Mississippi | MS | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 2976149 | 696 | 42 | 628.269423559601 | 67.7305764403987 | 654 | 1.41121966675728 | 2.27577908365471 | 0.10780498604668 | weekly | |||||||||
6176 | 6176 | United States | Missouri | MO | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 6137428 | 1456 | 1 | 1259.25689223137 | 196.743107768628 | 1455 | 0.0162934701637233 | 3.20562795634634 | 0.156237467495615 | weekly | |||||||||
6328 | 6328 | United States | Montana | MT | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 1068778 | 303 | 68 | 199.135338346698 | 103.864661653302 | 235 | 6.36240641180863 | 9.71807631269562 | 0.521578251834297 | weekly | |||||||||
6480 | 6480 | United States | Nebraska | NE | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 1934408 | 437 | 60 | 319.390977444692 | 117.609022555308 | 377 | 3.10172414506143 | 6.07984574894791 | 0.368229007269544 | weekly | |||||||||
6632 | 6632 | United States | Nevada | NV | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 3080156 | 669 | 110 | 505.115288221401 | 163.884711778599 | 559 | 3.57124769005206 | 5.32066271249247 | 0.324450111885677 | weekly | |||||||||
6784 | 6784 | United States | New Hampshire | NH | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 1359711 | 298 | 40 | 225.399749374262 | 72.6002506257385 | 258 | 2.94180160342896 | 5.33938834250355 | 0.322095525071727 | weekly | |||||||||
6936 | 6936 | United States | New Jersey | NJ | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 8882190 | 1492 | 0 | 1447.51002506366 | 44.4899749363417 | 1492 | 0.0 | 0.500889701034786 | 0.0307355211128055 | weekly | |||||||||
7088 | 7088 | United States | New Mexico | NM | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 2096829 | 560 | 94 | 367.629072682556 | 192.370927317444 | 466 | 4.48295974540604 | 9.17437365266524 | 0.523274522098405 | weekly | |||||||||
7240 | 7240 | United States | New York | NY | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 19453561 | 3453 | 229 | 3008.18295739431 | 444.817042605688 | 3224 | 1.17716237145477 | 2.2865584486341 | 0.147869012259476 | weekly | |||||||||
7392 | 7392 | United States | North Carolina | NC | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 10488084 | 2109 | 186 | 1907.3897243114 | 201.610275688598 | 1923 | 1.77344117381211 | 1.92227937618156 | 0.105699571051942 | weekly | |||||||||
7544 | 7544 | United States | North Dakota | ND | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 762062 | 170 | 48 | 149.676691730225 | 20.3233082697749 | 122 | 6.29870010576567 | 2.66688383225707 | 0.13578138342612 | weekly | |||||||||
7696 | 7696 | United States | Ohio | OH | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 11689100 | 3111 | 420 | 2377.05889724533 | 733.941102754672 | 2691 | 3.59309099930705 | 6.27885040554595 | 0.308760167282857 | weekly | |||||||||
7848 | 7848 | United States | Oklahoma | OK | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 3956971 | 913 | 54 | 790.731829574679 | 122.268170425321 | 859 | 1.36468020614758 | 3.08994355595027 | 0.154626595075965 | weekly | |||||||||
8000 | 8000 | United States | Oregon | OR | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 4217737 | 892 | 184 | 725.749373434518 | 166.250626565482 | 708 | 4.36252900548327 | 3.94170206832437 | 0.229074433476562 | weekly | |||||||||
8152 | 8152 | United States | Pennsylvania | PA | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 12801989 | 3227 | 552 | 2571.09523809638 | 655.904761903625 | 2675 | 4.3118299820442 | 5.12345981474929 | 0.255107143518049 | weekly | |||||||||
8304 | 8304 | United States | Rhode Island | RI | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 1059361 | 247 | 16 | 207.533834587357 | 39.4661654126428 | 231 | 1.51034444348999 | 3.72546897730262 | 0.190167379170312 | weekly | |||||||||
8456 | 8456 | United States | South Carolina | SC | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 5148714 | 1152 | 113 | 1006.20676691826 | 145.793233081739 | 1039 | 2.19472279874159 | 2.8316436508561 | 0.144893910352307 | weekly | |||||||||
8608 | 8608 | United States | South Dakota | SD | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 884659 | 219 | 26 | 157.746867168634 | 61.2531328313657 | 193 | 2.93898553001778 | 6.92392580998619 | 0.388300154106294 | weekly | |||||||||
8760 | 8760 | United States | Tennessee | TN | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 6833174 | 1780 | 161 | 1510.04135338437 | 269.958646615629 | 1619 | 2.35615249955584 | 3.95070645962811 | 0.178775664660167 | weekly | |||||||||
8912 | 8912 | United States | Texas | TX | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 28995881 | 4786 | 579 | 4075.0100250632 | 710.989974936805 | 4207 | 1.99683534361312 | 2.45203784267429 | 0.174475638234971 | weekly | |||||||||
9064 | 9064 | United States | Utah | UT | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 3205958 | 486 | 81 | 371.994987469519 | 114.005012530481 | 405 | 2.52654588737594 | 3.55603574752011 | 0.30646921698057 | weekly | |||||||||
9216 | 9216 | United States | Vermont | VT | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 623989 | 160 | 11 | 113.205513785336 | 46.7944862146639 | 149 | 1.76285158872993 | 7.49924857884736 | 0.413358719464823 | weekly | |||||||||
9368 | 9368 | United States | Virginia | VA | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 8535519 | 1601 | 171 | 1358.27944862223 | 242.720551377772 | 1430 | 2.00339311528684 | 2.84365310858978 | 0.178697065338046 | weekly | |||||||||
9520 | 9520 | United States | Washington | WA | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 7614893 | 1341 | 176 | 1111.01754386049 | 229.982456139508 | 1165 | 2.31126031580483 | 3.02016661481006 | 0.207001642242642 | weekly | |||||||||
9672 | 9672 | United States | West Virginia | WV | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 1792147 | 620 | 116 | 432.870927319289 | 187.129072680711 | 504 | 6.47268332341041 | 10.4416140350491 | 0.432297622387292 | weekly | |||||||||
9824 | 9824 | United States | Wisconsin | WI | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 5822434 | 1357 | 99 | 1077.78696741941 | 279.213032580593 | 1258 | 1.70031983187787 | 4.79546925874287 | 0.259061429596912 | weekly | |||||||||
9976 | 9976 | United States | Wyoming | WY | 2021-11-14 | 2021-11-20 | 7 | 2021 | 46 | 578759 | 139 | 49 | 108.750626567282 | 30.2493734327179 | 90 | 8.46639101940531 | 5.22659231782451 | 0.278153555409662 | 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);