economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
51 rows where country = "United States", "start_date" is on date 2020-06-21 and week = 26 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2303 | 2303 | United States | Alabama | AL | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 4903185 | 1151 | 80 | 939.358395982286 | 211.641604017714 | 1071 | 1.63159252608254 | 4.31641074154278 | 0.225304425789904 | weekly | |||||||||
2455 | 2455 | United States | Alaska | AK | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 731545 | 90 | 1 | 82.4085213060911 | 7.59147869390885 | 89 | 0.136696990615752 | 1.03773229178094 | 0.0921200693034123 | weekly | |||||||||
2607 | 2607 | United States | Arizona | AZ | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 7278717 | 1617 | 242 | 1159.69924812835 | 457.300751871648 | 1375 | 3.32476176776759 | 6.2827109760092 | 0.394327022811896 | weekly | |||||||||
2759 | 2759 | United States | Arkansas | AR | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 3017825 | 663 | 35 | 578.954887219393 | 84.0451127806069 | 628 | 1.1597756662497 | 2.78495647629027 | 0.145166945881154 | weekly | |||||||||
2911 | 2911 | United States | California | CA | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 39512223 | 5701 | 535 | 4814.04761904827 | 886.952380951732 | 5166 | 1.35401139034875 | 2.24475444206653 | 0.184242544141489 | weekly | |||||||||
3063 | 3063 | United States | Colorado | CO | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 5758736 | 877 | 25 | 714.310776943455 | 162.689223056545 | 852 | 0.434123043667916 | 2.82508562741102 | 0.227756920807906 | weekly | |||||||||
3215 | 3215 | United States | Connecticut | CT | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 3565287 | 598 | 60 | 568.596491228847 | 29.4035087711529 | 538 | 1.68289397178965 | 0.824716461007289 | 0.0517124344323798 | weekly | |||||||||
3367 | 3367 | United States | Delaware | DE | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 973764 | 201 | 72 | 172.877192985424 | 28.1228070145763 | 129 | 7.39398868719731 | 2.88805162386125 | 0.162675055794939 | weekly | |||||||||
3519 | 3519 | United States | District of Columbia | DC | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 705749 | 130 | 17 | 111.521303258573 | 18.478696741427 | 113 | 2.40878839360736 | 2.61831001410232 | 0.165696563808821 | weekly | |||||||||
3671 | 3671 | United States | Florida | FL | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 21477737 | 4504 | 246 | 3850.2406015048 | 653.759398495195 | 4258 | 1.14537206596766 | 3.04389330447242 | 0.169797024694946 | weekly | |||||||||
3823 | 3823 | United States | Georgia | GA | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 10617423 | 1823 | 143 | 1563.36340852181 | 259.636591478187 | 1680 | 1.34684282617355 | 2.44538238212971 | 0.166075648222878 | weekly | |||||||||
3975 | 3975 | United States | Hawaii | HI | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 1415872 | 236 | 1 | 219.864661655047 | 16.135338344953 | 235 | 0.070627853365276 | 1.13960431062646 | 0.0733875931834298 | weekly | |||||||||
4127 | 4127 | United States | Idaho | ID | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 1787065 | 296 | 2 | 259.197994988285 | 36.8020050117151 | 294 | 0.111915347231354 | 2.05935458484807 | 0.141984142328641 | weekly | |||||||||
4279 | 4279 | United States | Illinois | IL | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 12671821 | 2134 | 249 | 1867.03508771985 | 266.964912280154 | 1885 | 1.96498987793467 | 2.10676044335028 | 0.142988695839772 | weekly | |||||||||
4431 | 4431 | United States | Indiana | IN | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 6732219 | 1380 | 78 | 1225.12781955026 | 154.872180449744 | 1302 | 1.15860758540386 | 2.30046260303986 | 0.126413079499409 | weekly | |||||||||
4583 | 4583 | United States | Iowa | IA | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 3155070 | 552 | 22 | 552.065162907953 | -0.0651629079528675 | 530 | 0.697290392923136 | -0.00206533953138496 | -0.00011803481242977 | weekly | |||||||||
4735 | 4735 | United States | Kansas | KS | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 2913314 | 521 | 6 | 505.726817043394 | 15.2731829566064 | 515 | 0.205951023473611 | 0.524254610268802 | 0.030200460884984 | weekly | |||||||||
4887 | 4887 | United States | Kentucky | KY | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 4467673 | 937 | 30 | 882.939849625344 | 54.060150374656 | 907 | 0.671490505236171 | 1.21002925627404 | 0.0612274441997325 | weekly | |||||||||
5039 | 5039 | United States | Louisiana | LA | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 4648794 | 998 | 87 | 836.283208020982 | 161.716791979018 | 911 | 1.87145311235559 | 3.47868268585397 | 0.193375629724423 | weekly | |||||||||
5191 | 5191 | United States | Maine | ME | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 1344212 | 299 | 2 | 276.912280702519 | 22.0877192974814 | 297 | 0.148786054580676 | 1.64317230447886 | 0.0797643182940297 | weekly | |||||||||
5343 | 5343 | United States | Maryland | MD | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 6045680 | 1031 | 107 | 933.774436091127 | 97.2255639088729 | 924 | 1.76985880827301 | 1.60818243620028 | 0.104121038391101 | weekly | |||||||||
5495 | 5495 | United States | Massachusetts | MA | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 6949503 | 1084 | 204 | 1058.45864661734 | 25.5413533826556 | 880 | 2.93546171575147 | 0.367527769721887 | 0.0241307050249733 | weekly | |||||||||
5647 | 5647 | United States | Michigan | MI | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 9986857 | 1918 | 67 | 1778.53132832171 | 139.468671678289 | 1851 | 0.670881739870712 | 1.39652216586549 | 0.0784178886575457 | weekly | |||||||||
5799 | 5799 | United States | Minnesota | MN | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 5639632 | 840 | 45 | 818.939849624888 | 21.0601503751122 | 795 | 0.797924403578106 | 0.373431287273926 | 0.0257163580264885 | weekly | |||||||||
5951 | 5951 | United States | Mississippi | MS | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 2976149 | 721 | 97 | 581.290726817796 | 139.709273182204 | 624 | 3.25924542084418 | 4.69429699864502 | 0.240343199601729 | weekly | |||||||||
6103 | 6103 | United States | Missouri | MO | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 6137428 | 1284 | 41 | 1191.72681704343 | 92.2731829565673 | 1243 | 0.668032276712656 | 1.50345035341461 | 0.0774281333917524 | weekly | |||||||||
6255 | 6255 | United States | Montana | MT | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 1068778 | 199 | 2 | 183.423558898108 | 15.5764411018917 | 197 | 0.187129600347313 | 1.45740659911523 | 0.0849206132269216 | weekly | |||||||||
6407 | 6407 | United States | Nebraska | NE | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 1934408 | 320 | 21 | 315.260651630169 | 4.73934836983142 | 299 | 1.0856034507715 | 0.245002521176061 | 0.0150331109998185 | weekly | |||||||||
6559 | 6559 | United States | Nevada | NV | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 3080156 | 557 | 15 | 517.521303259026 | 39.478696740974 | 542 | 0.486988321370736 | 1.28171095038608 | 0.076284196403823 | weekly | |||||||||
6711 | 6711 | United States | New Hampshire | NH | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 1359711 | 250 | 28 | 220.155388472038 | 29.8446115279622 | 222 | 2.05926112240028 | 2.19492315116684 | 0.135561576462403 | weekly | |||||||||
6863 | 6863 | United States | New Jersey | NJ | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 8882190 | 1445 | 2091 | 1330.7844611539 | 114.215538846097 | -646 | 23.5414914564989 | 1.28589389380431 | 0.0858257232332447 | weekly | |||||||||
7015 | 7015 | United States | New Mexico | NM | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 2096829 | 399 | 25 | 350.308270677561 | 48.6917293224388 | 374 | 1.19227652803352 | 2.32216023922021 | 0.138996801954633 | weekly | |||||||||
7167 | 7167 | United States | New York | NY | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 19453561 | 3004 | 266 | 2806.2330827076 | 197.7669172924 | 2738 | 1.36735891182082 | 1.0166103639966 | 0.0704741592959857 | weekly | |||||||||
7319 | 7319 | United States | North Carolina | NC | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 10488084 | 1946 | 105 | 1779.3709273189 | 166.629072681097 | 1841 | 1.00113614650684 | 1.58874654971391 | 0.0936449337925105 | weekly | |||||||||
7471 | 7471 | United States | North Dakota | ND | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 762062 | 131 | 2 | 140.117794487111 | -9.11779448711081 | 129 | 0.262445837740236 | -1.19646360625655 | -0.0650723523053279 | weekly | |||||||||
7623 | 7623 | United States | Ohio | OH | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 11689100 | 2429 | 106 | 2226.81704260852 | 202.182957391478 | 2323 | 0.90682772839654 | 1.72967086765857 | 0.0907945976354836 | weekly | |||||||||
7775 | 7775 | United States | Oklahoma | OK | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 3956971 | 765 | 18 | 701.598997494526 | 63.4010025054736 | 747 | 0.454893402049194 | 1.60226098461357 | 0.0903664382815317 | weekly | |||||||||
7927 | 7927 | United States | Oregon | OR | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 4217737 | 689 | 13 | 676.055137845535 | 12.9448621544651 | 676 | 0.308222157996101 | 0.30691487293933 | 0.019147642595718 | weekly | |||||||||
8079 | 8079 | United States | Pennsylvania | PA | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 12801989 | 2561 | 183 | 2387.61904762018 | 173.380952379821 | 2378 | 1.42946537448204 | 1.3543282405556 | 0.0726166733142106 | weekly | |||||||||
8231 | 8231 | United States | Rhode Island | RI | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 1059361 | 200 | 33 | 194.35588972521 | 5.64411027478974 | 167 | 3.11508541469811 | 0.53278441199834 | 0.0290400783982911 | weekly | |||||||||
8383 | 8383 | United States | South Carolina | SC | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 5148714 | 1099 | 64 | 921.804511279172 | 177.195488720828 | 1035 | 1.24302884176515 | 3.44154848610407 | 0.19222675366921 | weekly | |||||||||
8535 | 8535 | United States | South Dakota | SD | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 884659 | 163 | 10 | 152.942355890473 | 10.057644109527 | 153 | 1.13037905000684 | 1.13689501938341 | 0.0657610120556118 | weekly | |||||||||
8687 | 8687 | United States | Tennessee | TN | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 6833174 | 1562 | 53 | 1359.36090225656 | 202.639097743444 | 1509 | 0.775627841468694 | 2.96551935811153 | 0.149069387980087 | weekly | |||||||||
8839 | 8839 | United States | Texas | TX | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 28995881 | 4566 | 412 | 3763.11779448675 | 802.882205513251 | 4154 | 1.42089147075752 | 2.76895261610865 | 0.213355586872549 | weekly | |||||||||
8991 | 8991 | United States | Utah | UT | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 3205958 | 388 | 12 | 363.774436091088 | 24.2255639089121 | 376 | 0.374303094426065 | 0.755641961276852 | 0.0665950146723508 | weekly | |||||||||
9143 | 9143 | United States | Vermont | VT | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 623989 | 125 | 0 | 96.5814536349758 | 28.4185463650242 | 125 | 0.0 | 4.5543345099071 | 0.294244342940111 | weekly | |||||||||
9295 | 9295 | United States | Virginia | VA | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 8535519 | 1456 | 117 | 1260.07518797061 | 195.92481202939 | 1339 | 1.37074265782784 | 2.29540596218449 | 0.155486604212034 | weekly | |||||||||
9447 | 9447 | United States | Washington | WA | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 7614893 | 1084 | 46 | 1054.45614035174 | 29.5438596482586 | 1038 | 0.604079400721717 | 0.387974718072317 | 0.0280181019557659 | weekly | |||||||||
9599 | 9599 | United States | West Virginia | WV | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 1792147 | 464 | 5 | 421.691729324279 | 42.3082706757212 | 459 | 0.278994970836656 | 2.36075894866444 | 0.100329856465329 | weekly | |||||||||
9751 | 9751 | United States | Wisconsin | WI | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 5822434 | 1034 | 35 | 1015.74686716878 | 18.2531328312159 | 999 | 0.601123172886116 | 0.313496603503207 | 0.0179701591225119 | weekly | |||||||||
9903 | 9903 | United States | Wyoming | WY | 2020-06-21 | 2020-06-27 | 7 | 2020 | 26 | 578759 | 89 | 0 | 86.9448621562654 | 2.05513784373458 | 89 | 0.0 | 0.35509388946601 | 0.0236372546090291 | 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);