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 "end_date" is on date 2020-10-31 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2321 | 2321 | United States | Alabama | AL | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 4903185 | 1169 | 101 | 961.35839598157 | 207.64160401843 | 1068 | 2.0598855641792 | 4.23483111525325 | 0.215987715805428 | weekly | |||||||||
2473 | 2473 | United States | Alaska | AK | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 731545 | 107 | 12 | 79.7418546394114 | 27.2581453605886 | 95 | 1.64036388738902 | 3.72610644055918 | 0.341829839346584 | weekly | |||||||||
2625 | 2625 | United States | Arizona | AZ | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 7278717 | 1312 | 109 | 1125.365914795 | 186.634085204998 | 1203 | 1.49751666399449 | 2.56410690517296 | 0.165843022923788 | weekly | |||||||||
2777 | 2777 | United States | Arkansas | AR | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 3017825 | 790 | 130 | 613.288220552714 | 176.711779447286 | 660 | 4.30773818892746 | 5.85560062121845 | 0.288138225267114 | weekly | |||||||||
2929 | 2929 | United States | California | CA | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 39512223 | 5529 | 316 | 4990.38095238159 | 538.619047618415 | 5213 | 0.799752522149918 | 1.36317070193296 | 0.107931449073315 | weekly | |||||||||
3081 | 3081 | United States | Colorado | CO | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 5758736 | 907 | 58 | 763.977443610108 | 143.022556389892 | 849 | 1.00716546130957 | 2.48357549972584 | 0.187207826076712 | weekly | |||||||||
3233 | 3233 | United States | Connecticut | CT | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 3565287 | 639 | 38 | 605.929824562171 | 33.0701754378292 | 601 | 1.06583284880011 | 0.927559981505815 | 0.0545775667367503 | weekly | |||||||||
3385 | 3385 | United States | Delaware | DE | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 973764 | 195 | 28 | 168.877192985414 | 26.1228070145859 | 167 | 2.87544004502118 | 2.68266304921787 | 0.154685227488606 | weekly | |||||||||
3537 | 3537 | United States | District of Columbia | DC | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 705749 | 128 | 4 | 116.521303258562 | 11.478696741438 | 124 | 0.56677373967232 | 1.62645596967732 | 0.098511571879407 | weekly | |||||||||
3689 | 3689 | United States | Florida | FL | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 21477737 | 4265 | 345 | 3939.90726817145 | 325.092731828547 | 3920 | 1.60631448275952 | 1.51362656051029 | 0.0825127876624936 | weekly | |||||||||
3841 | 3841 | United States | Georgia | GA | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 10617423 | 1944 | 169 | 1682.3634085218 | 261.636591478201 | 1775 | 1.59172334002328 | 2.46421934473366 | 0.155517286070842 | weekly | |||||||||
3993 | 3993 | United States | Hawaii | HI | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 1415872 | 238 | 7 | 216.864661655037 | 21.1353383449633 | 231 | 0.494394973556932 | 1.49274357745356 | 0.0974586554751042 | weekly | |||||||||
4145 | 4145 | United States | Idaho | ID | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 1787065 | 351 | 59 | 274.197994988273 | 76.8020050117272 | 292 | 3.30150274332495 | 4.29766152947583 | 0.280096887707045 | weekly | |||||||||
4297 | 4297 | United States | Illinois | IL | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 12671821 | 2455 | 276 | 2027.03508771983 | 427.964912280167 | 2179 | 2.17806106951795 | 3.37729606723586 | 0.211128517149437 | weekly | |||||||||
4449 | 4449 | United States | Indiana | IN | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 6732219 | 1600 | 213 | 1296.79448621691 | 303.20551378309 | 1387 | 3.1638899447567 | 4.50379754109439 | 0.233811538378467 | weekly | |||||||||
4601 | 4601 | United States | Iowa | IA | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 3155070 | 759 | 86 | 608.398496241274 | 150.601503758726 | 673 | 2.72577153597226 | 4.77331735139714 | 0.247537600255674 | weekly | |||||||||
4753 | 4753 | United States | Kansas | KS | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 2913314 | 577 | 54 | 520.060150376716 | 56.9398496232844 | 523 | 1.8535592112625 | 1.95447005105816 | 0.109487046031193 | weekly | |||||||||
4905 | 4905 | United States | Kentucky | KY | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 4467673 | 1125 | 80 | 932.273182958665 | 192.726817041335 | 1045 | 1.79064134729646 | 4.31380759158817 | 0.206727835321506 | weekly | |||||||||
5057 | 5057 | United States | Louisiana | LA | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 4648794 | 951 | 91 | 865.283208020968 | 85.7167919790317 | 860 | 1.95749693361332 | 1.84385008195742 | 0.0990621234579123 | weekly | |||||||||
5209 | 5209 | United States | Maine | ME | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 1344212 | 275 | 1 | 294.245614035841 | -19.2456140358407 | 274 | 0.0743930272903381 | -1.43173949018761 | -0.0654066301001738 | weekly | |||||||||
5361 | 5361 | United States | Maryland | MD | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 6045680 | 1071 | 58 | 958.107769424449 | 112.892230575551 | 1013 | 0.959362718503129 | 1.86732064177315 | 0.117828321800759 | weekly | |||||||||
5513 | 5513 | United States | Massachusetts | MA | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 6949503 | 1089 | 152 | 1133.125313284 | -44.1253132840009 | 937 | 2.18720676859914 | -0.634941999219237 | -0.0389412475096137 | weekly | |||||||||
5665 | 5665 | United States | Michigan | MI | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 9986857 | 2176 | 174 | 1917.5313283217 | 258.468671678302 | 2002 | 1.74228989160454 | 2.58808824115837 | 0.134792411399361 | weekly | |||||||||
5817 | 5817 | United States | Minnesota | MN | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 5639632 | 1075 | 147 | 895.939849624875 | 179.060150375125 | 928 | 2.60655305168848 | 3.17503252650394 | 0.199857334674974 | weekly | |||||||||
5969 | 5969 | United States | Mississippi | MS | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 2976149 | 716 | 93 | 591.290726817784 | 124.709273182216 | 623 | 3.12484354781968 | 4.19028997480355 | 0.21091024689898 | weekly | |||||||||
6121 | 6121 | United States | Missouri | MO | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 6137428 | 1611 | 221 | 1238.06015037675 | 372.939849623248 | 1390 | 3.60085690618285 | 6.07648431269985 | 0.30122918463191 | weekly | |||||||||
6273 | 6273 | United States | Montana | MT | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 1068778 | 317 | 81 | 186.423558898095 | 130.576441101905 | 236 | 7.57874881406616 | 12.2173586190869 | 0.700428861425621 | weekly | |||||||||
6425 | 6425 | United States | Nebraska | NE | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 1934408 | 442 | 49 | 311.927318296822 | 130.072681703178 | 393 | 2.53307471846684 | 6.72415962419399 | 0.416996761980959 | weekly | |||||||||
6577 | 6577 | United States | Nevada | NV | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 3080156 | 604 | 34 | 489.521303259012 | 114.478696740988 | 570 | 1.103840195107 | 3.71665255724021 | 0.23385845718836 | weekly | |||||||||
6729 | 6729 | United States | New Hampshire | NH | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 1359711 | 257 | 10 | 249.822055138692 | 7.17794486130825 | 247 | 0.735450400857241 | 0.527902242558032 | 0.0287322304562874 | weekly | |||||||||
6881 | 6881 | United States | New Jersey | NJ | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 8882190 | 1434 | 67 | 1379.11779448722 | 54.882205512776 | 1367 | 0.75431847325941 | 0.617890469723975 | 0.0397951543603874 | weekly | |||||||||
7033 | 7033 | United States | New Mexico | NM | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 2096829 | 460 | 53 | 358.308270677547 | 101.691729322453 | 407 | 2.52762623943106 | 4.84978647865196 | 0.283810722901143 | weekly | |||||||||
7185 | 7185 | United States | New York | NY | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 19453561 | 3076 | 116 | 2944.23308270759 | 131.76691729241 | 2960 | 0.596291856282765 | 0.677340859559904 | 0.0447542411184492 | weekly | |||||||||
7337 | 7337 | United States | North Carolina | NC | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 10488084 | 2159 | 177 | 1851.37092731888 | 307.629072681121 | 1982 | 1.68762950411152 | 2.93312937502333 | 0.166162851615383 | weekly | |||||||||
7489 | 7489 | United States | North Dakota | ND | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 762062 | 246 | 76 | 155.784461153766 | 90.2155388462344 | 170 | 9.97294183412898 | 11.8383463348434 | 0.579104861794835 | weekly | |||||||||
7641 | 7641 | United States | Ohio | OH | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 11689100 | 2763 | 95 | 2351.81704260851 | 411.182957391486 | 2668 | 0.812722964128975 | 3.51766138874238 | 0.174836286131945 | weekly | |||||||||
7793 | 7793 | United States | Oklahoma | OK | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 3956971 | 1025 | 165 | 750.598997494517 | 274.401002505483 | 860 | 4.16985618545094 | 6.93462253085714 | 0.365576031171675 | weekly | |||||||||
7945 | 7945 | United States | Oregon | OR | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 4217737 | 782 | 35 | 692.721804512189 | 89.2781954878112 | 747 | 0.829828886912579 | 2.11673215963469 | 0.128880302173656 | weekly | |||||||||
8097 | 8097 | United States | Pennsylvania | PA | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 12801989 | 2758 | 158 | 2548.95238095351 | 209.047619046493 | 2600 | 1.23418321949816 | 1.63293078166598 | 0.0820131519947394 | weekly | |||||||||
8249 | 8249 | United States | Rhode Island | RI | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 1059361 | 204 | 27 | 197.022556391865 | 6.97744360813533 | 177 | 2.54870624838936 | 0.658646448956997 | 0.0354144405387657 | weekly | |||||||||
8401 | 8401 | United States | South Carolina | SC | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 5148714 | 1225 | 140 | 985.471177945827 | 239.528822054173 | 1085 | 2.71912559136126 | 4.65220678511514 | 0.243060200455036 | weekly | |||||||||
8553 | 8553 | United States | South Dakota | SD | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 884659 | 243 | 59 | 172.609022557127 | 70.3909774428731 | 184 | 6.66923639504035 | 7.95684862109277 | 0.407805897977184 | weekly | |||||||||
8705 | 8705 | United States | Tennessee | TN | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 6833174 | 1841 | 265 | 1407.69423558987 | 433.305764410126 | 1576 | 3.87813920734347 | 6.34120782538431 | 0.307812416542685 | weekly | |||||||||
8857 | 8857 | United States | Texas | TX | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 28995881 | 5165 | 806 | 4023.11779448673 | 1141.88220551327 | 4359 | 2.77970515881204 | 3.93808419034851 | 0.283830169496428 | weekly | |||||||||
9009 | 9009 | United States | Utah | UT | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 3205958 | 460 | 36 | 381.44110275774 | 78.5588972422601 | 424 | 1.1229092832782 | 2.45040319437311 | 0.205952889382648 | weekly | |||||||||
9161 | 9161 | United States | Vermont | VT | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 623989 | 120 | 0 | 112.914786968295 | 7.08521303170477 | 120 | 0.0 | 1.13547082267552 | 0.0627483186386757 | weekly | |||||||||
9313 | 9313 | United States | Virginia | VA | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 8535519 | 1546 | 76 | 1363.74185463727 | 182.258145362732 | 1470 | 0.890396940127484 | 2.13529072295114 | 0.133645634430726 | weekly | |||||||||
9465 | 9465 | United States | Washington | WA | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 7614893 | 1194 | 69 | 1118.45614035173 | 75.5438596482713 | 1125 | 0.906119101082576 | 0.992054118794201 | 0.067542979042982 | weekly | |||||||||
9617 | 9617 | United States | West Virginia | WV | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 1792147 | 485 | 31 | 447.358395990932 | 37.6416040090677 | 454 | 1.72976881918727 | 2.10036364255096 | 0.0841419415537934 | weekly | |||||||||
9769 | 9769 | United States | Wisconsin | WI | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 5822434 | 1454 | 349 | 1064.41353383544 | 389.586466164558 | 1105 | 5.99405678106441 | 6.69112721869511 | 0.366010440285128 | weekly | |||||||||
9921 | 9921 | United States | Wyoming | WY | 2020-10-25 | 2020-10-31 | 7 | 2020 | 44 | 578759 | 114 | 20 | 93.6115288229193 | 20.3884711770807 | 94 | 3.4556698038389 | 3.52279120965388 | 0.217798720237212 | 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);