economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
52 rows where "start_date" is on date 2022-08-14 sorted by covid_deaths_per_100k
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: covid_deaths_per_100k, end_date (date)
country 2
cadence 1
- weekly 52
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2719 | 2719 | United States | Arizona | AZ | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 7278717 | 1275 | 0 | 1115.73182958649 | 159.268170413505 | 1275 | 0.0 | 2.18813522236824 | 0.142747716064112 | weekly | |||||||||
3327 | 3327 | United States | Connecticut | CT | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 3565287 | 628 | 0 | 541.859649123206 | 86.1403508767942 | 628 | 0.0 | 2.4160846203067 | 0.158971702388579 | weekly | |||||||||
5607 | 5607 | United States | Massachusetts | MA | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 6949503 | 1129 | 0 | 1036.58395990045 | 92.4160400995515 | 1129 | 0.0 | 1.3298222923215 | 0.0891544184307338 | weekly | |||||||||
5911 | 5911 | United States | Minnesota | MN | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 5639632 | 908 | 0 | 834.213032582192 | 73.7869674178085 | 908 | 0.0 | 1.3083649326376 | 0.0884509885795131 | weekly | |||||||||
6215 | 6215 | United States | Missouri | MO | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 6137428 | 1310 | 0 | 1176.45363408597 | 133.546365914032 | 1310 | 0.0 | 2.17593372849396 | 0.113516046909736 | weekly | |||||||||
7583 | 7583 | United States | North Dakota | ND | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 762062 | 152 | 0 | 156.235588973329 | -4.23558897332902 | 152 | 0.0 | -0.555806348214321 | -0.0271102698249633 | weekly | |||||||||
8495 | 8495 | United States | South Carolina | SC | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 5148714 | 1088 | 0 | 952.27568922402 | 135.72431077598 | 1088 | 0.0 | 2.63608176286312 | 0.142526279219181 | weekly | |||||||||
17114 | 17114 | South Africa | South Africa | 0 | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 59893884 | 10762 | 84 | 10605.9765690375 | 156.023430962463 | 10678 | 0.140248042688299 | 0.26049977149998 | 0.014710897195265 | weekly | |||||||||
3631 | 3631 | United States | District of Columbia | DC | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 705749 | 116 | 2 | 111.709273183394 | 4.29072681660575 | 114 | 0.28338686983616 | 0.607967820939988 | 0.0384097639733241 | weekly | |||||||||
2415 | 2415 | United States | Alabama | AL | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 4903185 | 1107 | 15 | 966.716791962913 | 140.283208037087 | 1092 | 0.305923598640476 | 2.86106292210241 | 0.14511303538262 | weekly | |||||||||
3479 | 3479 | United States | Delaware | DE | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 973764 | 189 | 3 | 170.421052636231 | 18.5789473637694 | 186 | 0.308082861966554 | 1.90795175871868 | 0.109017912261267 | weekly | |||||||||
7431 | 7431 | United States | North Carolina | NC | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 10488084 | 2027 | 36 | 1798.74185463727 | 228.258145362729 | 1991 | 0.343246678802344 | 2.17635695292609 | 0.126898779151808 | weekly | |||||||||
8343 | 8343 | United States | Rhode Island | RI | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 1059361 | 178 | 4 | 187.378446116162 | -9.37844611616197 | 174 | 0.377586110872498 | -0.88529274875722 | -0.0500508266054676 | weekly | |||||||||
3175 | 3175 | United States | Colorado | CO | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 5758736 | 805 | 23 | 756.621553885678 | 48.3784461143223 | 782 | 0.399393200174483 | 0.840087931002954 | 0.0639400845321836 | weekly | |||||||||
9103 | 9103 | United States | Utah | UT | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 3205958 | 394 | 13 | 368.548872181279 | 25.4511278187215 | 381 | 0.405495018961571 | 0.793869658265064 | 0.0690576738658497 | weekly | |||||||||
4847 | 4847 | United States | Kansas | KS | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 2913314 | 564 | 12 | 481.120300752544 | 82.879699247456 | 552 | 0.411902046947222 | 2.84485981419977 | 0.172263982870438 | weekly | |||||||||
5303 | 5303 | United States | Maine | ME | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 1344212 | 289 | 6 | 284.82456140414 | 4.17543859586044 | 283 | 0.446358163742029 | 0.310623517410977 | 0.0146596858616272 | weekly | |||||||||
8951 | 8951 | United States | Texas | TX | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 28995881 | 4313 | 135 | 3819.56892230635 | 493.431077693653 | 4178 | 0.465583370272488 | 1.70172817888738 | 0.129185017401311 | weekly | |||||||||
9255 | 9255 | United States | Vermont | VT | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 623989 | 104 | 3 | 100.82957393569 | 3.17042606431033 | 101 | 0.480777706017254 | 0.508090056765477 | 0.0314434142737969 | weekly | |||||||||
6823 | 6823 | United States | New Hampshire | NH | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 1359711 | 268 | 7 | 230.310776943142 | 37.6892230568578 | 261 | 0.514815280600069 | 2.77185542051641 | 0.163645069315025 | weekly | |||||||||
9863 | 9863 | United States | Wisconsin | WI | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 5822434 | 1021 | 30 | 992.827067670023 | 28.1729323299774 | 991 | 0.515248433902385 | 0.483868642048624 | 0.0283764748639397 | weekly | |||||||||
4391 | 4391 | United States | Illinois | IL | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 12671821 | 2092 | 72 | 1808.40350877235 | 283.596491227654 | 2020 | 0.568189844222074 | 2.23800897461899 | 0.156821467029876 | weekly | |||||||||
6975 | 6975 | United States | New Jersey | NJ | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 8882190 | 1379 | 54 | 1290.90225564006 | 88.0977443599363 | 1325 | 0.607958172477734 | 0.991847104823656 | 0.0682450928991949 | weekly | |||||||||
8647 | 8647 | United States | South Dakota | SD | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 884659 | 160 | 6 | 155.21804511345 | 4.78195488655027 | 154 | 0.678227430004103 | 0.540542162183425 | 0.0308079829446062 | weekly | |||||||||
7735 | 7735 | United States | Ohio | OH | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 11689100 | 2446 | 90 | 2173.63408521543 | 272.365914784566 | 2356 | 0.769948071280081 | 2.33008456412013 | 0.125304399961859 | weekly | |||||||||
3023 | 3023 | United States | California | CA | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 39512223 | 5792 | 323 | 4696.42857142879 | 1095.57142857121 | 5469 | 0.817468559032986 | 2.77274054808612 | 0.233277566539867 | weekly | |||||||||
7279 | 7279 | United States | New York | NY | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 19453561 | 3118 | 160 | 2791.79949874767 | 326.20050125233 | 2958 | 0.822471525907262 | 1.67681640010448 | 0.116842381194873 | weekly | |||||||||
6367 | 6367 | United States | Montana | MT | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 1068778 | 235 | 9 | 188.513784461945 | 46.4862155380553 | 226 | 0.842083201562906 | 4.34947346764766 | 0.246593190363963 | weekly | |||||||||
5455 | 5455 | United States | Maryland | MD | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 6045680 | 993 | 51 | 923.215538847959 | 69.7844611520406 | 942 | 0.843577562821717 | 1.15428638551893 | 0.0755884820126853 | weekly | |||||||||
4087 | 4087 | United States | Hawaii | HI | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 1415872 | 258 | 13 | 218.729323309085 | 39.2706766909146 | 245 | 0.918162093748587 | 2.77360359488107 | 0.179540063932907 | weekly | |||||||||
8191 | 8191 | United States | Pennsylvania | PA | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 12801989 | 2590 | 120 | 2305.23809523919 | 284.761904760812 | 2470 | 0.937354343922651 | 2.2243567367603 | 0.123528196653051 | weekly | |||||||||
4695 | 4695 | United States | Iowa | IA | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 3155070 | 633 | 32 | 526.796992481668 | 106.203007518332 | 601 | 1.01424057152456 | 3.36610622009438 | 0.201601393011042 | weekly | |||||||||
5759 | 5759 | United States | Michigan | MI | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 9986857 | 1925 | 103 | 1792.39598997565 | 132.604010024351 | 1822 | 1.03135551054751 | 1.32778520834284 | 0.0739814252910445 | weekly | |||||||||
10015 | 10015 | United States | Wyoming | WY | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 578759 | 109 | 6 | 92.5563909782919 | 16.4436090217081 | 103 | 1.03670094115167 | 2.84118415812249 | 0.177660438656956 | weekly | |||||||||
2567 | 2567 | United States | Alaska | AK | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 731545 | 106 | 8 | 100.817042611349 | 5.18295738865149 | 98 | 1.09357592492601 | 0.708494677518333 | 0.0514095360705222 | weekly | |||||||||
6063 | 6063 | United States | Mississippi | MS | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 2976149 | 638 | 34 | 570.914786968064 | 67.0852130319363 | 604 | 1.14241592070827 | 2.254094570935 | 0.117504774028018 | weekly | |||||||||
4543 | 4543 | United States | Indiana | IN | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 6732219 | 1374 | 77 | 1201.92230576626 | 172.077694233741 | 1297 | 1.14375364200125 | 2.55603233100024 | 0.143168733459886 | weekly | |||||||||
9407 | 9407 | United States | Virginia | VA | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 8535519 | 1476 | 104 | 1293.48370927384 | 182.516290726164 | 1372 | 1.21843791806919 | 2.1383150892894 | 0.141104437124012 | weekly | |||||||||
9559 | 9559 | United States | Washington | WA | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 7614893 | 1294 | 96 | 1053.2456140359 | 240.754385964097 | 1198 | 1.26068744498445 | 3.16162533031123 | 0.228583326391987 | weekly | |||||||||
2871 | 2871 | United States | Arkansas | AR | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 3017825 | 669 | 39 | 582.576441104546 | 86.4235588954541 | 630 | 1.29232145667824 | 2.8637697313613 | 0.14834715721013 | weekly | |||||||||
8799 | 8799 | United States | Tennessee | TN | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 6833174 | 1501 | 95 | 1370.7218045122 | 130.278195487802 | 1406 | 1.3902763196137 | 1.90655463314416 | 0.0950434982933421 | weekly | |||||||||
3935 | 3935 | United States | Georgia | GA | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 10617423 | 1842 | 153 | 1680.39348370982 | 161.606516290179 | 1689 | 1.44102763919267 | 1.52208795194634 | 0.0961718299058141 | weekly | |||||||||
7127 | 7127 | United States | New Mexico | NM | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 2096829 | 382 | 35 | 364.94987468755 | 17.0501253124498 | 347 | 1.66918713924693 | 0.813138568402566 | 0.0467190880036532 | weekly | |||||||||
5151 | 5151 | United States | Louisiana | LA | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 4648794 | 951 | 78 | 842.566416040898 | 108.433583959102 | 873 | 1.6778545145257 | 2.33250997912796 | 0.128694405443569 | weekly | |||||||||
4239 | 4239 | United States | Idaho | ID | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 1787065 | 340 | 30 | 257.729323308928 | 82.2706766910723 | 310 | 1.67873020847031 | 4.60367567441992 | 0.319213489698487 | weekly | |||||||||
4999 | 4999 | United States | Kentucky | KY | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 4467673 | 1010 | 76 | 879.879699249749 | 130.120300750251 | 934 | 1.70110927993163 | 2.91248488307561 | 0.14788419469298 | weekly | |||||||||
9711 | 9711 | United States | West Virginia | WV | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 1792147 | 451 | 31 | 421.716791980956 | 29.2832080190437 | 420 | 1.72976881918727 | 1.63397355345537 | 0.069438088726536 | weekly | |||||||||
8039 | 8039 | United States | Oregon | OR | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 4217737 | 825 | 75 | 675.110275690159 | 149.889724309841 | 750 | 1.77820475766981 | 3.55379494524768 | 0.222022578691474 | weekly | |||||||||
6671 | 6671 | United States | Nevada | NV | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 3080156 | 526 | 56 | 482.375939850437 | 43.624060149563 | 470 | 1.81808973311741 | 1.41629385490745 | 0.0904358127046903 | weekly | |||||||||
3783 | 3783 | United States | Florida | FL | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 21477737 | 4629 | 522 | 3812.48120300841 | 816.518796991586 | 4107 | 2.43042365217527 | 3.80169846102309 | 0.214169920719156 | weekly | |||||||||
6519 | 6519 | United States | Nebraska | NE | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 1934408 | 328 | 51 | 299.521303259206 | 28.4786967407941 | 277 | 2.63646552330222 | 1.47221768834673 | 0.0950807052149765 | weekly | |||||||||
7887 | 7887 | United States | Oklahoma | OK | 2022-08-14 | 2022-08-20 | 7 | 2022 | 33 | 3956971 | 823 | 147 | 708.864661654814 | 114.135338345186 | 676 | 3.71496278340175 | 2.88441179743765 | 0.16101146596692 | 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);