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 2020-10-04 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2318 | 2318 | United States | Alabama | AL | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 4903185 | 1204 | 107 | 954.358395981773 | 249.641604018227 | 1097 | 2.18225500363539 | 5.09141719144243 | 0.261580560373667 | weekly | |||||||||
2470 | 2470 | United States | Alaska | AK | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 731545 | 117 | 4 | 90.0751879727367 | 26.9248120272633 | 113 | 0.546787962463006 | 3.68054077702169 | 0.29891485805628 | weekly | |||||||||
2622 | 2622 | United States | Arizona | AZ | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 7278717 | 1241 | 54 | 1117.365914795 | 123.634085205002 | 1187 | 0.741888989501859 | 1.69856975075418 | 0.110647804419276 | weekly | |||||||||
2774 | 2774 | United States | Arkansas | AR | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 3017825 | 785 | 143 | 570.621553886039 | 214.378446113961 | 642 | 4.7385120078202 | 7.10374014775413 | 0.375692864480853 | weekly | |||||||||
2926 | 2926 | United States | California | CA | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 39512223 | 5568 | 385 | 4859.04761904825 | 708.952380951752 | 5183 | 0.974382028568729 | 1.79426093275428 | 0.145903567228389 | weekly | |||||||||
3078 | 3078 | United States | Colorado | CO | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 5758736 | 801 | 55 | 782.310776943433 | 18.6892230565675 | 746 | 0.955070696069415 | 0.324536895884227 | 0.0238897681169472 | weekly | |||||||||
3230 | 3230 | United States | Connecticut | CT | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 3565287 | 637 | 17 | 582.596491228827 | 54.4035087711734 | 620 | 0.476819958673734 | 1.52592228258688 | 0.0933811129834032 | weekly | |||||||||
3382 | 3382 | United States | Delaware | DE | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 973764 | 203 | 8 | 178.877192985405 | 24.1228070145953 | 195 | 0.821554298577479 | 2.47727447457446 | 0.134856806572113 | weekly | |||||||||
3534 | 3534 | United States | District of Columbia | DC | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 705749 | 146 | 7 | 122.854636591886 | 23.1453634081145 | 139 | 0.99185404442656 | 3.27954604372298 | 0.188396336110632 | weekly | |||||||||
3686 | 3686 | United States | Florida | FL | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 21477737 | 4525 | 561 | 3888.57393483812 | 636.426065161879 | 3964 | 2.61200702848722 | 2.96318958166719 | 0.163665671741528 | weekly | |||||||||
3838 | 3838 | United States | Georgia | GA | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 10617423 | 1886 | 267 | 1605.03007518846 | 280.969924811544 | 1619 | 2.51473450761075 | 2.6463099832374 | 0.175055862911823 | weekly | |||||||||
3990 | 3990 | United States | Hawaii | HI | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 1415872 | 231 | 15 | 203.531328321692 | 27.4686716783075 | 216 | 1.05941780047914 | 1.94005331543441 | 0.134960410786942 | weekly | |||||||||
4142 | 4142 | United States | Idaho | ID | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 1787065 | 300 | 27 | 257.531328321596 | 42.468671678404 | 273 | 1.51085718762328 | 2.37644806867148 | 0.16490681718292 | weekly | |||||||||
4294 | 4294 | United States | Illinois | IL | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 12671821 | 2333 | 201 | 1914.36842105315 | 418.63157894685 | 2132 | 1.58619664845329 | 3.30364182817016 | 0.218678690236934 | weekly | |||||||||
4446 | 4446 | United States | Indiana | IN | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 6732219 | 1442 | 112 | 1207.7944862169 | 234.205513783098 | 1330 | 1.66364166109272 | 3.47887544631418 | 0.193911726254592 | weekly | |||||||||
4598 | 4598 | United States | Iowa | IA | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 3155070 | 733 | 76 | 564.731829574597 | 168.268170425403 | 657 | 2.40882135737083 | 5.33326266692665 | 0.297961194346273 | weekly | |||||||||
4750 | 4750 | United States | Kansas | KS | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 2913314 | 638 | 65 | 475.726817043372 | 162.273182956628 | 573 | 2.23113608763079 | 5.57005468537301 | 0.341105813553146 | weekly | |||||||||
4902 | 4902 | United States | Kentucky | KY | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 4467673 | 1068 | 45 | 902.939849625322 | 165.060150374678 | 1023 | 1.00723575785426 | 3.69454412564835 | 0.182803041025568 | weekly | |||||||||
5054 | 5054 | United States | Louisiana | LA | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 4648794 | 1044 | 53 | 848.283208020958 | 195.716791979042 | 991 | 1.1400806316649 | 4.21005516654516 | 0.230721049442495 | weekly | |||||||||
5206 | 5206 | United States | Maine | ME | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 1344212 | 302 | 1 | 294.578947369164 | 7.42105263083573 | 301 | 0.0743930272903381 | 0.552074570888798 | 0.0251920671762593 | weekly | |||||||||
5358 | 5358 | United States | Maryland | MD | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 6045680 | 1086 | 35 | 922.441102757773 | 163.558897242227 | 1051 | 0.578925778407061 | 2.70538462575305 | 0.177310938067746 | weekly | |||||||||
5510 | 5510 | United States | Massachusetts | MA | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 6949503 | 1101 | 80 | 1071.45864661732 | 29.5413533826797 | 1021 | 1.15116145715744 | 0.425085842580106 | 0.0275711558966314 | weekly | |||||||||
5662 | 5662 | United States | Michigan | MI | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 9986857 | 2146 | 97 | 1801.86466165503 | 344.135338344974 | 2049 | 0.971276548768046 | 3.44588230656526 | 0.190988449725676 | weekly | |||||||||
5814 | 5814 | United States | Minnesota | MN | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 5639632 | 1013 | 57 | 890.939849624869 | 122.060150375131 | 956 | 1.01070424453227 | 2.16432828197179 | 0.137001561246278 | weekly | |||||||||
5966 | 5966 | United States | Mississippi | MS | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 2976149 | 761 | 84 | 590.290726817773 | 170.709273182227 | 677 | 2.82243933351455 | 5.73591151458568 | 0.289195248081418 | weekly | |||||||||
6118 | 6118 | United States | Missouri | MO | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 6137428 | 1531 | 253 | 1147.72681704341 | 383.273182956592 | 1278 | 4.122247951422 | 6.24485017105849 | 0.333941123676032 | weekly | |||||||||
6270 | 6270 | United States | Montana | MT | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 1068778 | 282 | 22 | 198.756892231418 | 83.2431077685818 | 260 | 2.05842560382044 | 7.78862474420149 | 0.418818722883126 | weekly | |||||||||
6422 | 6422 | United States | Nebraska | NE | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 1934408 | 406 | 21 | 336.260651630143 | 69.739348369857 | 385 | 1.0856034507715 | 3.60520367832727 | 0.207396696674948 | weekly | |||||||||
6574 | 6574 | United States | Nevada | NV | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 3080156 | 558 | 39 | 497.521303259002 | 60.4786967409975 | 519 | 1.26616963556391 | 1.96349460030588 | 0.12156001430458 | weekly | |||||||||
6726 | 6726 | United States | New Hampshire | NH | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 1359711 | 255 | 13 | 242.82205513868 | 12.1779448613203 | 242 | 0.956085521114413 | 0.895627442987537 | 0.0501517247037764 | weekly | |||||||||
6878 | 6878 | United States | New Jersey | NJ | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 8882190 | 1401 | 36 | 1356.78446115388 | 44.2155388461231 | 1365 | 0.405305448318489 | 0.497799966518652 | 0.0325884767345581 | weekly | |||||||||
7030 | 7030 | United States | New Mexico | NM | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 2096829 | 389 | 17 | 364.64160401087 | 24.3583959891304 | 372 | 0.810748039062794 | 1.16167775193544 | 0.0668009237596603 | weekly | |||||||||
7182 | 7182 | United States | New York | NY | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 19453561 | 3108 | 84 | 2914.23308270758 | 193.76691729242 | 3024 | 0.431797551101313 | 0.996048575849019 | 0.0664898488875822 | weekly | |||||||||
7334 | 7334 | United States | North Carolina | NC | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 10488084 | 2117 | 136 | 1809.03759398554 | 307.962406014457 | 1981 | 1.29670967547552 | 2.93630758501226 | 0.170235492638921 | weekly | |||||||||
7486 | 7486 | United States | North Dakota | ND | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 762062 | 239 | 64 | 130.117794487086 | 108.882205512914 | 175 | 8.39826680768756 | 14.2878408204206 | 0.836797195511337 | weekly | |||||||||
7638 | 7638 | United States | Ohio | OH | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 11689100 | 2665 | 71 | 2262.48370927516 | 402.516290724842 | 2594 | 0.607403478454286 | 3.44351824113783 | 0.1779090338086 | weekly | |||||||||
7790 | 7790 | United States | Oklahoma | OK | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 3956971 | 970 | 121 | 700.598997494504 | 269.401002505496 | 849 | 3.05789453599736 | 6.80826325251046 | 0.384529528972968 | weekly | |||||||||
7942 | 7942 | United States | Oregon | OR | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 4217737 | 761 | 36 | 706.721804512178 | 54.2781954878217 | 725 | 0.85353828368151 | 1.28690327272236 | 0.0768027746438187 | weekly | |||||||||
8094 | 8094 | United States | Pennsylvania | PA | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 12801989 | 2769 | 73 | 2436.95238095349 | 332.047619046514 | 2696 | 0.570223892552946 | 2.59371898418686 | 0.136255275910068 | weekly | |||||||||
8246 | 8246 | United States | Rhode Island | RI | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 1059361 | 214 | 12 | 190.02255639185 | 23.9774436081503 | 202 | 1.13275833261749 | 2.26338742016653 | 0.126182091554994 | weekly | |||||||||
8398 | 8398 | United States | South Carolina | SC | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 5148714 | 1133 | 111 | 919.47117794582 | 213.52882205418 | 1022 | 2.15587814743643 | 4.14722631814818 | 0.23223003306229 | weekly | |||||||||
8550 | 8550 | United States | South Dakota | SD | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 884659 | 215 | 38 | 172.275689223781 | 42.724310776219 | 177 | 4.29544039002599 | 4.82946658274193 | 0.247999650842908 | weekly | |||||||||
8702 | 8702 | United States | Tennessee | TN | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 6833174 | 1769 | 217 | 1389.36090225653 | 379.639097743467 | 1552 | 3.17568380374918 | 5.5558236588658 | 0.273247287387226 | weekly | |||||||||
8854 | 8854 | United States | Texas | TX | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 28995881 | 4720 | 452 | 3877.45112782007 | 842.548872179927 | 4268 | 1.5588420989864 | 2.90575365576899 | 0.217294517559429 | weekly | |||||||||
9006 | 9006 | United States | Utah | UT | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 3205958 | 443 | 35 | 380.44110275773 | 62.5588972422701 | 408 | 1.09171735874269 | 1.95133240180533 | 0.164437798094883 | weekly | |||||||||
9158 | 9158 | United States | Vermont | VT | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 623989 | 121 | 0 | 103.248120301613 | 17.7518796983866 | 121 | 0.0 | 2.84490266629486 | 0.171934168356082 | weekly | |||||||||
9310 | 9310 | United States | Virginia | VA | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 8535519 | 1478 | 79 | 1293.07518797059 | 184.924812029409 | 1399 | 0.925544187764095 | 2.16653272085048 | 0.143011646770238 | weekly | |||||||||
9462 | 9462 | United States | Washington | WA | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 7614893 | 1162 | 47 | 1099.12280701838 | 62.877192981616 | 1115 | 0.617211561606972 | 0.82571341424779 | 0.0572067039098063 | weekly | |||||||||
9614 | 9614 | United States | West Virginia | WV | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 1792147 | 500 | 24 | 441.691729324255 | 58.3082706757452 | 476 | 1.33917586001595 | 3.25354285534307 | 0.132011234996298 | weekly | |||||||||
9766 | 9766 | United States | Wisconsin | WI | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 5822434 | 1163 | 128 | 1051.74686716876 | 111.253132831236 | 1035 | 2.19839331798351 | 1.91076674860095 | 0.105779381240966 | weekly | |||||||||
9918 | 9918 | United States | Wyoming | WY | 2020-10-04 | 2020-10-10 | 7 | 2020 | 41 | 578759 | 102 | 0 | 94.2781954895734 | 7.72180451042657 | 102 | 0.0 | 1.33420033389141 | 0.0819044580809838 | 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);