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-07-19 and week = 30 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2307 | 2307 | United States | Alabama | AL | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 4903185 | 1333 | 168 | 941.358395981949 | 391.641604018051 | 1165 | 3.42634430477333 | 7.98749392523535 | 0.416038785748038 | weekly | |||||||||
2459 | 2459 | United States | Alaska | AK | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 731545 | 93 | 3 | 76.7418546394189 | 16.2581453605811 | 90 | 0.410090971847255 | 2.22243954378487 | 0.211854996689511 | weekly | |||||||||
2611 | 2611 | United States | Arizona | AZ | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 7278717 | 1863 | 556 | 1101.03258146169 | 761.967418538312 | 1307 | 7.63870885487099 | 10.468430336532 | 0.692048020528832 | weekly | |||||||||
2763 | 2763 | United States | Arkansas | AR | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 3017825 | 714 | 42 | 558.621553886054 | 155.378446113946 | 672 | 1.39173079949964 | 5.1486897389327 | 0.278146170753804 | weekly | |||||||||
2915 | 2915 | United States | California | CA | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 39512223 | 6250 | 962 | 4802.38095238159 | 1447.61904761841 | 5288 | 2.43468964021589 | 3.66372463431988 | 0.301437778879351 | weekly | |||||||||
3067 | 3067 | United States | Colorado | CO | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 5758736 | 833 | 42 | 721.644110276789 | 111.355889723211 | 791 | 0.729326713362099 | 1.93368631107956 | 0.154308596352986 | weekly | |||||||||
3219 | 3219 | United States | Connecticut | CT | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 3565287 | 586 | 18 | 559.929824562174 | 26.0701754378264 | 568 | 0.504868191536894 | 0.731222351463609 | 0.0465597192616261 | weekly | |||||||||
3371 | 3371 | United States | Delaware | DE | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 973764 | 201 | 56 | 164.21052631875 | 36.7894736812502 | 145 | 5.75088009004235 | 3.77806878065426 | 0.224038461516395 | weekly | |||||||||
3523 | 3523 | United States | District of Columbia | DC | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 705749 | 123 | 3 | 105.521303258566 | 17.4786967414344 | 120 | 0.42508030475424 | 2.47661657918529 | 0.165641403220781 | weekly | |||||||||
3675 | 3675 | United States | Florida | FL | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 21477737 | 5704 | 882 | 3780.90726817149 | 1923.09273182851 | 4822 | 4.10657789505477 | 8.95388900529191 | 0.508632609960454 | weekly | |||||||||
3827 | 3827 | United States | Georgia | GA | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 10617423 | 2177 | 326 | 1594.03007518848 | 582.969924811516 | 1851 | 3.07042490442361 | 5.49069133641483 | 0.365720781486876 | weekly | |||||||||
3979 | 3979 | United States | Hawaii | HI | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 1415872 | 219 | 2 | 227.531328321709 | -8.53132832170888 | 217 | 0.141255706730552 | -0.602549405716681 | -0.0374951809257947 | weekly | |||||||||
4131 | 4131 | United States | Idaho | ID | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 1787065 | 328 | 27 | 255.531328321613 | 72.4686716783867 | 301 | 1.51085718762328 | 4.05517827714083 | 0.283599948994032 | weekly | |||||||||
4283 | 4283 | United States | Illinois | IL | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 12671821 | 2034 | 108 | 1856.03508771983 | 177.964912280173 | 1926 | 0.85228476633311 | 1.40441466368704 | 0.0958844546946613 | weekly | |||||||||
4435 | 4435 | United States | Indiana | IN | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 6732219 | 1318 | 71 | 1171.46115288358 | 146.538847116415 | 1247 | 1.05462998158557 | 2.17667974135148 | 0.125090658581128 | weekly | |||||||||
4587 | 4587 | United States | Iowa | IA | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 3155070 | 651 | 39 | 552.39849624128 | 98.6015037587198 | 612 | 1.23610569654556 | 3.12517642266954 | 0.178497053177444 | weekly | |||||||||
4739 | 4739 | United States | Kansas | KS | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 2913314 | 540 | 21 | 478.726817043389 | 61.2731829566114 | 519 | 0.720828582157639 | 2.10321245689999 | 0.127991958618558 | weekly | |||||||||
4891 | 4891 | United States | Kentucky | KY | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 4467673 | 968 | 27 | 866.939849625339 | 101.060150374661 | 941 | 0.604341454712554 | 2.26203104781082 | 0.116571121304824 | weekly | |||||||||
5043 | 5043 | United States | Louisiana | LA | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 4648794 | 1213 | 205 | 826.283208020972 | 386.716791979028 | 1008 | 4.40974583945858 | 8.31864763160139 | 0.468019667137193 | weekly | |||||||||
5195 | 5195 | United States | Maine | ME | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 1344212 | 282 | 2 | 260.578947369181 | 21.4210526308188 | 280 | 0.148786054580676 | 1.59357695295228 | 0.0822056150241104 | weekly | |||||||||
5347 | 5347 | United States | Maryland | MD | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 6045680 | 1002 | 63 | 893.107769424456 | 108.892230575544 | 939 | 1.04206640113271 | 1.80115769566936 | 0.121925073662406 | weekly | |||||||||
5499 | 5499 | United States | Massachusetts | MA | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 6949503 | 1089 | 95 | 1053.12531328401 | 35.8746867159946 | 994 | 1.36700423037446 | 0.516219457938137 | 0.0340649742850878 | weekly | |||||||||
5651 | 5651 | United States | Michigan | MI | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 9986857 | 1891 | 28 | 1701.19799498837 | 189.802005011625 | 1863 | 0.280368488304178 | 1.90051790079327 | 0.111569614807195 | weekly | |||||||||
5803 | 5803 | United States | Minnesota | MN | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 5639632 | 878 | 7 | 837.939849624882 | 40.0601503751177 | 871 | 0.124121573889928 | 0.710332702118112 | 0.0478079069673691 | weekly | |||||||||
5955 | 5955 | United States | Mississippi | MS | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 2976149 | 885 | 134 | 552.29072681779 | 332.70927318221 | 751 | 4.50246274632083 | 11.1791873720775 | 0.60241691020095 | weekly | |||||||||
6107 | 6107 | United States | Missouri | MO | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 6137428 | 1355 | 52 | 1172.39348371009 | 182.606516289911 | 1303 | 0.847260448513612 | 2.97529382487113 | 0.155755314940889 | weekly | |||||||||
6259 | 6259 | United States | Montana | MT | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 1068778 | 224 | 9 | 210.756892231433 | 13.2431077685667 | 215 | 0.842083201562906 | 1.23908873204413 | 0.0628359415834636 | weekly | |||||||||
6411 | 6411 | United States | Nebraska | NE | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 1934408 | 361 | 20 | 296.59398496349 | 64.4060150365102 | 341 | 1.03390804835381 | 3.32949486543223 | 0.21715212816753 | weekly | |||||||||
6563 | 6563 | United States | Nevada | NV | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 3080156 | 657 | 86 | 465.521303259022 | 191.478696740978 | 571 | 2.79206637585889 | 6.21652594027633 | 0.411321018824431 | weekly | |||||||||
6715 | 6715 | United States | New Hampshire | NH | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 1359711 | 266 | 13 | 227.488721805361 | 38.5112781946395 | 253 | 0.956085521114413 | 2.83231349857723 | 0.169288736114091 | weekly | |||||||||
6867 | 6867 | United States | New Jersey | NJ | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 8882190 | 1370 | 86 | 1321.11779448722 | 48.8822055127766 | 1284 | 0.968229682094168 | 0.550339561670901 | 0.0370006412121258 | weekly | |||||||||
7019 | 7019 | United States | New Mexico | NM | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 2096829 | 435 | 38 | 332.308270677556 | 102.691729322444 | 397 | 1.81226032261095 | 4.89747753977287 | 0.309025499464886 | weekly | |||||||||
7171 | 7171 | United States | New York | NY | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 19453561 | 2834 | 127 | 2729.56641604093 | 104.433583959072 | 2707 | 0.652836773688889 | 0.536835307217389 | 0.0382601366082702 | weekly | |||||||||
7323 | 7323 | United States | North Carolina | NC | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 10488084 | 2147 | 149 | 1733.3709273189 | 413.629072681098 | 1998 | 1.42065986504303 | 3.94380015149667 | 0.238626981774109 | weekly | |||||||||
7475 | 7475 | United States | North Dakota | ND | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 762062 | 132 | 9 | 131.117794487103 | 0.882205512896633 | 123 | 1.18100626983106 | 0.115765582445606 | 0.00672834313868353 | weekly | |||||||||
7627 | 7627 | United States | Ohio | OH | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 11689100 | 2504 | 163 | 2162.8170426085 | 341.182957391496 | 2341 | 1.39446150687393 | 2.91881288885796 | 0.157749338325911 | weekly | |||||||||
7779 | 7779 | United States | Oklahoma | OK | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 3956971 | 904 | 68 | 708.598997494519 | 195.401002505481 | 836 | 1.71848618551918 | 4.93814593297451 | 0.275756814780129 | weekly | |||||||||
7931 | 7931 | United States | Oregon | OR | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 4217737 | 740 | 29 | 663.055137845527 | 76.9448621544725 | 711 | 0.687572506298994 | 1.82431626615108 | 0.11604594816125 | weekly | |||||||||
8083 | 8083 | United States | Pennsylvania | PA | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 12801989 | 2535 | 107 | 2340.9523809535 | 194.047619046503 | 2428 | 0.835807623331031 | 1.51576148867573 | 0.0828925956056679 | weekly | |||||||||
8235 | 8235 | United States | Rhode Island | RI | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 1059361 | 173 | 8 | 179.689223058536 | -6.6892230585355 | 165 | 0.755172221744995 | -0.631439429857764 | -0.0372266235263115 | weekly | |||||||||
8387 | 8387 | United States | South Carolina | SC | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 5148714 | 1352 | 294 | 933.137844612502 | 418.862155387498 | 1058 | 5.71016374185865 | 8.13527718547773 | 0.448874898607757 | weekly | |||||||||
8539 | 8539 | United States | South Dakota | SD | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 884659 | 173 | 6 | 151.275689223801 | 21.7243107761992 | 167 | 0.678227430004103 | 2.45567057772533 | 0.143607415624197 | weekly | |||||||||
8691 | 8691 | United States | Tennessee | TN | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 6833174 | 1710 | 123 | 1398.36090225655 | 311.639097743449 | 1587 | 1.80004197171036 | 4.56067850377363 | 0.222860276800183 | weekly | |||||||||
8843 | 8843 | United States | Texas | TX | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 28995881 | 6310 | 1817 | 3755.11779448675 | 2554.88220551325 | 4493 | 6.26640728729712 | 8.81119013253384 | 0.680373385160999 | weekly | |||||||||
8995 | 8995 | United States | Utah | UT | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 3205958 | 437 | 31 | 352.441102757748 | 84.5588972422516 | 406 | 0.966949660600669 | 2.63755474158587 | 0.239923483897318 | weekly | |||||||||
9147 | 9147 | United States | Vermont | VT | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 623989 | 116 | 0 | 97.581453634966 | 18.418546365034 | 116 | 0.0 | 2.95174215651782 | 0.188750481561121 | weekly | |||||||||
9299 | 9299 | United States | Virginia | VA | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 8535519 | 1463 | 50 | 1242.40852130395 | 220.591478696054 | 1413 | 0.585787460610187 | 2.58439444275215 | 0.177551485613231 | weekly | |||||||||
9451 | 9451 | United States | Washington | WA | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 7614893 | 1180 | 49 | 1028.45614035174 | 151.543859648265 | 1131 | 0.643475883377482 | 1.99009834607347 | 0.147350823921802 | weekly | |||||||||
9603 | 9603 | United States | West Virginia | WV | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 1792147 | 501 | 3 | 418.358395990939 | 82.6416040090611 | 498 | 0.167396982501993 | 4.61131838008049 | 0.197537816381845 | weekly | |||||||||
9755 | 9755 | United States | Wisconsin | WI | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 5822434 | 1101 | 56 | 1006.41353383545 | 94.5864661645548 | 1045 | 0.961797076617786 | 1.62451761865493 | 0.0939836985340265 | weekly | |||||||||
9907 | 9907 | United States | Wyoming | WY | 2020-07-19 | 2020-07-25 | 7 | 2020 | 30 | 578759 | 95 | 1 | 90.9448621562584 | 4.05513784374162 | 94 | 0.172783490191945 | 0.700660869851116 | 0.0445889712469323 | 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);