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-09-06 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2314 | 2314 | United States | Alabama | AL | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 4903185 | 1232 | 75 | 968.691729312356 | 263.308270687644 | 1157 | 1.52961799320238 | 5.37014758137097 | 0.271818435855294 | weekly | |||||||||
2466 | 2466 | United States | Alaska | AK | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 731545 | 87 | 2 | 84.7418546394615 | 2.25814536053852 | 85 | 0.273393981231503 | 0.308681675158537 | 0.0266473441034056 | weekly | |||||||||
2618 | 2618 | United States | Arizona | AZ | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 7278717 | 1282 | 103 | 1104.36591479505 | 177.634085204951 | 1179 | 1.41508455404984 | 2.44045874025534 | 0.160847127591689 | weekly | |||||||||
2770 | 2770 | United States | Arkansas | AR | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 3017825 | 722 | 72 | 622.288220552762 | 99.7117794472375 | 650 | 2.38582422771367 | 3.30409415546751 | 0.16023407828396 | weekly | |||||||||
2922 | 2922 | United States | California | CA | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 39512223 | 5874 | 557 | 4739.71428571497 | 1134.28571428503 | 5317 | 1.40969036340982 | 2.87072107860149 | 0.23931520887317 | weekly | |||||||||
3074 | 3074 | United States | Colorado | CO | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 5758736 | 850 | 22 | 762.64411027682 | 87.3558897231798 | 828 | 0.382028278427766 | 1.51692818915783 | 0.114543452897672 | weekly | |||||||||
3226 | 3226 | United States | Connecticut | CT | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 3565287 | 571 | 12 | 573.263157895551 | -2.26315789555053 | 559 | 0.33657879435793 | -0.0634775796605024 | -0.00394785163564071 | weekly | |||||||||
3378 | 3378 | United States | Delaware | DE | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 973764 | 198 | 5 | 169.210526318793 | 28.7894736812075 | 193 | 0.513471436610924 | 2.9565144820724 | 0.170139968875034 | weekly | |||||||||
3530 | 3530 | United States | District of Columbia | DC | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 705749 | 125 | 5 | 111.521303258608 | 13.4786967413923 | 120 | 0.7084671745904 | 1.90984283950701 | 0.120862080585056 | weekly | |||||||||
3682 | 3682 | United States | Florida | FL | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 21477737 | 4513 | 785 | 3888.57393483817 | 624.42606516183 | 3728 | 3.65494744627891 | 2.90731777357098 | 0.16057970752916 | weekly | |||||||||
3834 | 3834 | United States | Georgia | GA | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 10617423 | 2073 | 313 | 1616.36340852184 | 456.636591478161 | 1760 | 2.94798464749874 | 4.3008231986063 | 0.282508617227208 | weekly | |||||||||
3986 | 3986 | United States | Hawaii | HI | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 1415872 | 274 | 13 | 242.864661655082 | 31.1353383449179 | 261 | 0.918162093748587 | 2.19902211110311 | 0.128200365309369 | weekly | |||||||||
4138 | 4138 | United States | Idaho | ID | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 1787065 | 321 | 31 | 263.531328321654 | 57.4686716783465 | 290 | 1.73468788208599 | 3.21581317290342 | 0.218071498536231 | weekly | |||||||||
4290 | 4290 | United States | Illinois | IL | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 12671821 | 2080 | 129 | 1957.70175438655 | 122.29824561345 | 1951 | 1.01800680423121 | 0.965119737829709 | 0.0624703151741173 | weekly | |||||||||
4442 | 4442 | United States | Indiana | IN | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 6732219 | 1343 | 74 | 1215.12781955029 | 127.872180449708 | 1269 | 1.09919181179341 | 1.89940613116876 | 0.105233522261907 | weekly | |||||||||
4594 | 4594 | United States | Iowa | IA | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 3155070 | 637 | 48 | 555.398496241322 | 81.6015037586783 | 589 | 1.52136085728684 | 2.5863611190458 | 0.14692424324322 | weekly | |||||||||
4746 | 4746 | United States | Kansas | KS | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 2913314 | 581 | 40 | 484.726817043429 | 96.2731829565711 | 541 | 1.37300682315741 | 3.30459342716134 | 0.198613279834166 | weekly | |||||||||
4898 | 4898 | United States | Kentucky | KY | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 4467673 | 1020 | 63 | 908.273182958713 | 111.726817041287 | 957 | 1.41013006099596 | 2.50078322744944 | 0.123010146217612 | weekly | |||||||||
5050 | 5050 | United States | Louisiana | LA | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 4648794 | 1027 | 159 | 884.616541354351 | 142.383458645649 | 868 | 3.4202418949947 | 3.06280421644085 | 0.160955003653515 | weekly | |||||||||
5202 | 5202 | United States | Maine | ME | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 1344212 | 319 | 0 | 281.578947369221 | 37.4210526307792 | 319 | 0.0 | 2.78386538959473 | 0.132897196258464 | weekly | |||||||||
5354 | 5354 | United States | Maryland | MD | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 6045680 | 996 | 39 | 908.774436091164 | 87.225563908836 | 957 | 0.645088724510725 | 1.44277507094051 | 0.0959815334199012 | weekly | |||||||||
5506 | 5506 | United States | Massachusetts | MA | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 6949503 | 1012 | 80 | 1066.12531328405 | -54.1253132840509 | 932 | 1.15116145715744 | -0.778837181364637 | -0.0507682470434225 | weekly | |||||||||
5658 | 5658 | United States | Michigan | MI | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 9986857 | 1942 | 107 | 1777.53132832174 | 164.468671678257 | 1835 | 1.07140815173382 | 1.64685117327961 | 0.0925264545596165 | weekly | |||||||||
5810 | 5810 | United States | Minnesota | MN | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 5639632 | 893 | 55 | 842.606516291586 | 50.3934837084137 | 838 | 0.975240937706574 | 0.893559787383533 | 0.0598066626996923 | weekly | |||||||||
5962 | 5962 | United States | Mississippi | MS | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 2976149 | 745 | 109 | 591.290726817831 | 153.709273182169 | 636 | 3.66245103991769 | 5.16470355422961 | 0.259955494329146 | weekly | |||||||||
6114 | 6114 | United States | Missouri | MO | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 6137428 | 1369 | 65 | 1184.72681704347 | 184.273182956533 | 1304 | 1.05907556064201 | 3.00244960847659 | 0.155540653174707 | weekly | |||||||||
6266 | 6266 | United States | Montana | MT | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 1068778 | 221 | 17 | 187.423558898143 | 33.5764411018568 | 204 | 1.59060160295216 | 3.14157300223777 | 0.179147388403313 | weekly | |||||||||
6418 | 6418 | United States | Nebraska | NE | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 1934408 | 339 | 31 | 312.260651630203 | 26.7393483697973 | 308 | 1.60255747494841 | 1.38230137436349 | 0.0856315012160531 | weekly | |||||||||
6570 | 6570 | United States | Nevada | NV | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 3080156 | 559 | 63 | 480.521303259061 | 78.4786967409394 | 496 | 2.04535094975709 | 2.54788058594887 | 0.163319911539135 | weekly | |||||||||
6722 | 6722 | United States | New Hampshire | NH | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 1359711 | 228 | 3 | 235.155388472071 | -7.15538847207074 | 225 | 0.220635120257172 | -0.526243332007371 | -0.0304283415258442 | weekly | |||||||||
6874 | 6874 | United States | New Jersey | NJ | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 8882190 | 1389 | 39 | 1312.11779448727 | 76.882205512728 | 1350 | 0.43908090234503 | 0.865577132584734 | 0.0585939812993472 | weekly | |||||||||
7026 | 7026 | United States | New Mexico | NM | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 2096829 | 400 | 21 | 342.641604010928 | 57.3583959890724 | 379 | 1.00151228354816 | 2.73548276893693 | 0.167400558827769 | weekly | |||||||||
7178 | 7178 | United States | New York | NY | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 19453561 | 2757 | 45 | 2740.23308270764 | 16.7669172923625 | 2712 | 0.231320116661417 | 0.0861894503138138 | 0.00611879237506141 | weekly | |||||||||
7330 | 7330 | United States | North Carolina | NC | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 10488084 | 2124 | 159 | 1726.37092731893 | 397.62907268107 | 1965 | 1.51600616471035 | 3.79124607202869 | 0.230326557513681 | weekly | |||||||||
7482 | 7482 | United States | North Dakota | ND | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 762062 | 143 | 12 | 148.117794487145 | -5.11779448714469 | 131 | 1.57467502644142 | -0.671571930780526 | -0.0345521920905247 | weekly | |||||||||
7634 | 7634 | United States | Ohio | OH | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 11689100 | 2557 | 156 | 2275.15037594189 | 281.849624058108 | 2401 | 1.33457665688547 | 2.41121749371729 | 0.12388175614169 | weekly | |||||||||
7786 | 7786 | United States | Oklahoma | OK | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 3956971 | 802 | 80 | 727.932330827898 | 74.0676691721015 | 722 | 2.02174845355197 | 1.87182744508619 | 0.101750761760866 | weekly | |||||||||
7938 | 7938 | United States | Oregon | OR | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 4217737 | 737 | 28 | 648.721804512237 | 88.2781954877632 | 709 | 0.663863109530063 | 2.09302276286462 | 0.13608020398534 | weekly | |||||||||
8090 | 8090 | United States | Pennsylvania | PA | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 12801989 | 2619 | 77 | 2404.28571428689 | 214.714285713108 | 2542 | 0.601469037350368 | 1.67719473679526 | 0.0893048128336911 | weekly | |||||||||
8242 | 8242 | United States | Rhode Island | RI | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 1059361 | 190 | 11 | 190.022556391914 | -0.0225563919137812 | 179 | 1.03836180489937 | -0.00212924507451013 | -0.0001187037599224 | weekly | |||||||||
8394 | 8394 | United States | South Carolina | SC | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 5148714 | 1186 | 163 | 930.471177945868 | 255.528822054132 | 1023 | 3.16583908137061 | 4.96296399555562 | 0.274623038424729 | weekly | |||||||||
8546 | 8546 | United States | South Dakota | SD | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 884659 | 182 | 10 | 158.609022557177 | 23.3909774428234 | 172 | 1.13037905000684 | 2.64406708605501 | 0.147475705137715 | weekly | |||||||||
8698 | 8698 | United States | Tennessee | TN | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 6833174 | 1727 | 188 | 1428.36090225658 | 298.639097743419 | 1539 | 2.75128366407763 | 4.37043016529974 | 0.20907817994151 | weekly | |||||||||
8850 | 8850 | United States | Texas | TX | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 28995881 | 4654 | 529 | 3774.4511278201 | 879.548872179896 | 4125 | 1.82439705832701 | 3.0333579868806 | 0.23302696005177 | weekly | |||||||||
9002 | 9002 | United States | Utah | UT | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 3205958 | 382 | 13 | 353.77443609112 | 28.2255639088797 | 369 | 0.405495018961571 | 0.880409659417861 | 0.0797840686872291 | weekly | |||||||||
9154 | 9154 | United States | Vermont | VT | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 623989 | 117 | 0 | 98.581453635009 | 18.418546364991 | 117 | 0.0 | 2.95174215651093 | 0.186835816330974 | weekly | |||||||||
9306 | 9306 | United States | Virginia | VA | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 8535519 | 1469 | 44 | 1267.74185463731 | 201.25814536269 | 1425 | 0.515492965336964 | 2.35788995798252 | 0.158753254557702 | weekly | |||||||||
9458 | 9458 | United States | Washington | WA | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 7614893 | 1146 | 41 | 1015.45614035178 | 130.543859648224 | 1105 | 0.538418596295444 | 1.71432296748259 | 0.12855686667373 | weekly | |||||||||
9610 | 9610 | United States | West Virginia | WV | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 1792147 | 468 | 22 | 426.025062657647 | 41.9749373423531 | 446 | 1.22757787168129 | 2.34215928394005 | 0.0985269201781307 | weekly | |||||||||
9762 | 9762 | United States | Wisconsin | WI | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 5822434 | 1066 | 44 | 1022.74686716882 | 43.2531328311823 | 1022 | 0.755697703056832 | 0.742870298421283 | 0.0422911418452117 | weekly | |||||||||
9914 | 9914 | United States | Wyoming | WY | 2020-09-06 | 2020-09-12 | 7 | 2020 | 37 | 578759 | 121 | 0 | 96.2781954896322 | 24.7218045103678 | 121 | 0.0 | 4.27151966714432 | 0.25677469737195 | 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);