economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
51 rows where country = "United States" and "start_date" is on date 2020-08-09 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: total_deaths, covid_deaths, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2310 | 2310 | United States | Alabama | AL | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 4903185 | 1305 | 139 | 958.025062648582 | 346.974937351418 | 1166 | 2.83489201406841 | 7.07652143150661 | 0.36217730712823 | weekly | |||||||||
2462 | 2462 | United States | Alaska | AK | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 731545 | 74 | 6 | 95.7418546393989 | -21.7418546393989 | 68 | 0.82018194369451 | -2.97204609961095 | -0.227088296140567 | weekly | |||||||||
2614 | 2614 | United States | Arizona | AZ | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 7278717 | 1526 | 355 | 1068.03258146165 | 457.967418538348 | 1171 | 4.87723317172518 | 6.29187009933684 | 0.428795363069915 | weekly | |||||||||
2766 | 2766 | United States | Arkansas | AR | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 3017825 | 766 | 62 | 575.621553886033 | 190.378446113967 | 704 | 2.05445975164232 | 6.30846540518311 | 0.330735436900718 | weekly | |||||||||
2918 | 2918 | United States | California | CA | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 39512223 | 6291 | 910 | 4700.7142857149 | 1590.2857142851 | 5381 | 2.30308479479881 | 4.02479433841296 | 0.338307248138406 | weekly | |||||||||
3070 | 3070 | United States | Colorado | CO | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 5758736 | 836 | 39 | 729.644110276759 | 106.355889723241 | 797 | 0.677231948121949 | 1.84686170234651 | 0.145764062541257 | weekly | |||||||||
3222 | 3222 | United States | Connecticut | CT | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 3565287 | 574 | 12 | 541.59649122882 | 32.4035087711802 | 562 | 0.33657879435793 | 0.908861159597536 | 0.059829613551706 | weekly | |||||||||
3374 | 3374 | United States | Delaware | DE | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 973764 | 189 | 2 | 169.21052631873 | 19.7894736812697 | 187 | 0.20538857464437 | 2.03226589617913 | 0.116951788472034 | weekly | |||||||||
3526 | 3526 | United States | District of Columbia | DC | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 705749 | 117 | 7 | 113.521303258544 | 3.47869674145598 | 110 | 0.99185404442656 | 0.492908490335229 | 0.0306435588880904 | weekly | |||||||||
3678 | 3678 | United States | Florida | FL | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 21477737 | 5510 | 1236 | 3746.24060150479 | 1763.75939849521 | 4274 | 5.75479623388628 | 8.21203555335096 | 0.470807827395483 | weekly | |||||||||
3830 | 3830 | United States | Georgia | GA | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 10617423 | 2245 | 482 | 1636.36340852179 | 608.636591478214 | 1763 | 4.53970798752202 | 5.73243235649756 | 0.37194463546947 | weekly | |||||||||
3982 | 3982 | United States | Hawaii | HI | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 1415872 | 223 | 9 | 212.864661655018 | 10.1353383449818 | 214 | 0.635650680287484 | 0.715837190436832 | 0.0476140016204651 | weekly | |||||||||
4134 | 4134 | United States | Idaho | ID | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 1787065 | 319 | 34 | 251.864661654922 | 67.1353383450783 | 285 | 1.90256090293302 | 3.75673735119194 | 0.266553227054377 | weekly | |||||||||
4286 | 4286 | United States | Illinois | IL | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 12671821 | 2126 | 96 | 1831.03508771981 | 294.964912280189 | 2030 | 0.757586458962765 | 2.32772316054803 | 0.161091895102627 | weekly | |||||||||
4438 | 4438 | United States | Indiana | IN | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 6732219 | 1372 | 87 | 1193.7944862169 | 178.205513783104 | 1285 | 1.29229307602738 | 2.64705461576791 | 0.149276542856077 | weekly | |||||||||
4590 | 4590 | United States | Iowa | IA | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 3155070 | 669 | 48 | 521.398496241257 | 147.601503758743 | 621 | 1.52136085728684 | 4.67823229781725 | 0.283087705129179 | weekly | |||||||||
4742 | 4742 | United States | Kansas | KS | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 2913314 | 577 | 27 | 474.060150376699 | 102.939849623301 | 550 | 0.92677960563125 | 3.53342789768975 | 0.21714512291637 | weekly | |||||||||
4894 | 4894 | United States | Kentucky | KY | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 4467673 | 1015 | 38 | 869.939849625317 | 145.060150374683 | 977 | 0.850554639965817 | 3.24688378882437 | 0.16674733366584 | weekly | |||||||||
5046 | 5046 | United States | Louisiana | LA | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 4648794 | 1181 | 218 | 841.949874687619 | 339.050125312381 | 963 | 4.6893882585462 | 7.29329209494724 | 0.402696330869075 | weekly | |||||||||
5198 | 5198 | United States | Maine | ME | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 1344212 | 280 | 2 | 276.245614035825 | 3.75438596417541 | 278 | 0.148786054580676 | 0.279300137491364 | 0.0135907532044601 | weekly | |||||||||
5350 | 5350 | United States | Maryland | MD | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 6045680 | 1064 | 65 | 916.441102757767 | 147.558897242233 | 999 | 1.07514787418454 | 2.4407328413385 | 0.161012962860567 | weekly | |||||||||
5502 | 5502 | United States | Massachusetts | MA | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 6949503 | 1049 | 99 | 1048.12531328398 | 0.874686716019369 | 950 | 1.42456230323233 | 0.0125863204321139 | 0.00083452494175406 | weekly | |||||||||
5654 | 5654 | United States | Michigan | MI | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 9986857 | 2025 | 71 | 1772.53132832169 | 252.468671678314 | 1954 | 0.710934381057023 | 2.52800927937903 | 0.142433968666361 | weekly | |||||||||
5806 | 5806 | United States | Minnesota | MN | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 5639632 | 888 | 50 | 812.273182958196 | 75.7268170418042 | 838 | 0.88658267064234 | 1.34276167384333 | 0.0932282619081635 | weekly | |||||||||
5958 | 5958 | United States | Mississippi | MS | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 2976149 | 860 | 230 | 568.290726817769 | 291.709273182231 | 630 | 7.72810769890889 | 9.80156817357704 | 0.513309929964373 | weekly | |||||||||
6110 | 6110 | United States | Missouri | MO | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 6137428 | 1380 | 45 | 1177.39348371007 | 202.60651628993 | 1335 | 0.733206157367549 | 3.30116322814589 | 0.172080548340984 | weekly | |||||||||
6262 | 6262 | United States | Montana | MT | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 1068778 | 204 | 7 | 186.423558898079 | 17.5764411019208 | 197 | 0.654953601215594 | 1.64453619946526 | 0.0942822956809346 | weekly | |||||||||
6414 | 6414 | United States | Nebraska | NE | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 1934408 | 354 | 16 | 301.927318296807 | 52.0726817031933 | 338 | 0.827126438683049 | 2.69191823561489 | 0.172467605769955 | weekly | |||||||||
6566 | 6566 | United States | Nevada | NV | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 3080156 | 662 | 120 | 469.187969925664 | 192.812030074336 | 542 | 3.89590657096589 | 6.25981379106564 | 0.410948367036955 | weekly | |||||||||
6718 | 6718 | United States | New Hampshire | NH | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 1359711 | 230 | 4 | 229.822055138675 | 0.177944861324931 | 226 | 0.294180160342896 | 0.0130869619591907 | 0.00077427234395566 | weekly | |||||||||
6870 | 6870 | United States | New Jersey | NJ | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 8882190 | 1308 | 42 | 1295.45112782054 | 12.5488721794582 | 1266 | 0.472856356371571 | 0.141281285127408 | 0.00968687425558867 | weekly | |||||||||
7022 | 7022 | United States | New Mexico | NM | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 2096829 | 394 | 30 | 351.641604010866 | 42.3583959891344 | 364 | 1.43073183364023 | 2.02011685211977 | 0.120459000032958 | weekly | |||||||||
7174 | 7174 | United States | New York | NY | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 19453561 | 2811 | 69 | 2790.56641604091 | 20.433583959094 | 2742 | 0.354690845547507 | 0.105037756116189 | 0.00732237865461172 | weekly | |||||||||
7326 | 7326 | United States | North Carolina | NC | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 10488084 | 2160 | 183 | 1758.70426065221 | 401.295739347787 | 1977 | 1.74483728391191 | 3.82620638190719 | 0.228176930212796 | weekly | |||||||||
7478 | 7478 | United States | North Dakota | ND | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 762062 | 136 | 9 | 149.784461153748 | -13.784461153748 | 127 | 1.18100626983106 | -1.80883722764657 | -0.0920286460128783 | weekly | |||||||||
7630 | 7630 | United States | Ohio | OH | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 11689100 | 2588 | 157 | 2196.48370927515 | 391.516290724851 | 2431 | 1.34313163545525 | 3.34941347687034 | 0.17824684475081 | weekly | |||||||||
7782 | 7782 | United States | Oklahoma | OK | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 3956971 | 860 | 92 | 707.932330827832 | 152.067669172168 | 768 | 2.32501072158477 | 3.84303218730104 | 0.214805374115835 | weekly | |||||||||
7934 | 7934 | United States | Oregon | OR | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 4217737 | 777 | 31 | 668.388471178839 | 108.611528821161 | 746 | 0.734991299836856 | 2.57511383050106 | 0.162497609555716 | weekly | |||||||||
8086 | 8086 | United States | Pennsylvania | PA | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 12801989 | 2661 | 152 | 2352.95238095347 | 308.047619046528 | 2509 | 1.18731550230203 | 2.40624811540244 | 0.130919614667977 | weekly | |||||||||
8238 | 8238 | United States | Rhode Island | RI | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 1059361 | 211 | -5 | 186.355889725178 | 24.6441102748222 | 216 | -0.471982638590622 | 2.32631843864577 | 0.132242186233906 | weekly | |||||||||
8390 | 8390 | United States | South Carolina | SC | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 5148714 | 1319 | 343 | 921.471177945814 | 397.528822054186 | 976 | 6.66185769883509 | 7.72093423822309 | 0.43140668050017 | weekly | |||||||||
8542 | 8542 | United States | South Dakota | SD | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 884659 | 162 | 6 | 151.609022557108 | 10.3909774428918 | 156 | 0.678227430004103 | 1.17457432105385 | 0.0685379884892914 | weekly | |||||||||
8694 | 8694 | United States | Tennessee | TN | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 6833174 | 1678 | 120 | 1335.36090225653 | 342.639097743466 | 1558 | 1.75613850898572 | 5.0143476185952 | 0.256589134191711 | weekly | |||||||||
8846 | 8846 | United States | Texas | TX | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 28995881 | 5782 | 1304 | 3741.11779448674 | 2040.88220551326 | 4478 | 4.49719048026166 | 7.03852455979269 | 0.545527384494789 | weekly | |||||||||
8998 | 8998 | United States | Utah | UT | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 3205958 | 450 | 27 | 354.774436091059 | 95.2255639089412 | 423 | 0.842181962458647 | 2.97026860329865 | 0.268411571471006 | weekly | |||||||||
9150 | 9150 | United States | Vermont | VT | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 623989 | 107 | 0 | 103.581453634942 | 3.41854636505815 | 107 | 0.0 | 0.547853626435426 | 0.0330034600316225 | weekly | |||||||||
9302 | 9302 | United States | Virginia | VA | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 8535519 | 1457 | 58 | 1260.40852130392 | 196.591478696076 | 1399 | 0.679513454307817 | 2.30321646165952 | 0.155974412560062 | weekly | |||||||||
9454 | 9454 | United States | Washington | WA | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 7614893 | 1174 | 92 | 1043.45614035171 | 130.543859648287 | 1082 | 1.20815880144343 | 1.71432296748342 | 0.125107184288824 | weekly | |||||||||
9606 | 9606 | United States | West Virginia | WV | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 1792147 | 462 | 28 | 418.025062657581 | 43.974937342419 | 434 | 1.56237183668527 | 2.45375727227839 | 0.10519689193478 | weekly | |||||||||
9758 | 9758 | United States | Wisconsin | WI | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 5822434 | 1126 | 52 | 967.413533835429 | 158.586466164571 | 1074 | 0.893097285430801 | 2.72371427764697 | 0.163928310508368 | weekly | |||||||||
9910 | 9910 | United States | Wyoming | WY | 2020-08-09 | 2020-08-15 | 7 | 2020 | 33 | 578759 | 113 | 1 | 86.2781954895676 | 26.7218045104324 | 112 | 0.172783490191945 | 4.61708664753937 | 0.309716775586289 | 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);