economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where "start_date" is on date 2022-06-05 and week = 23 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date), end_date (date)
country 3
- United States 51
- Canada 1
- South Africa 1
cadence 1
- weekly 53
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2405 | 2405 | United States | Alabama | AL | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 4903185 | 1070 | 28 | 1025.38345862964 | 44.6165413703552 | 1042 | 0.571057384128888 | 0.909950192994048 | 0.0435120549242936 | weekly | |||||||||
| 2557 | 2557 | United States | Alaska | AK | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 731545 | 112 | 0 | 95.150375944725 | 16.849624055275 | 112 | 0.0 | 2.30329290136287 | 0.177084156399585 | weekly | |||||||||
| 2709 | 2709 | United States | Arizona | AZ | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 7278717 | 1317 | 0 | 1195.06516291986 | 121.934837080135 | 1317 | 0.0 | 1.67522431604547 | 0.102031956803272 | weekly | |||||||||
| 2861 | 2861 | United States | Arkansas | AR | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 3017825 | 688 | 14 | 584.243107771258 | 103.756892228742 | 674 | 0.46391026649988 | 3.4381348232168 | 0.177591983283379 | weekly | |||||||||
| 3013 | 3013 | United States | California | CA | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 39512223 | 5634 | 193 | 4991.76190476218 | 642.238095237823 | 5441 | 0.488456445490298 | 1.62541625470636 | 0.128659601056918 | weekly | |||||||||
| 3165 | 3165 | United States | Colorado | CO | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 5758736 | 866 | 0 | 776.621553885719 | 89.3784461142811 | 866 | 0.0 | 1.55204972261762 | 0.115086229151236 | weekly | |||||||||
| 3317 | 3317 | United States | Connecticut | CT | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 3565287 | 574 | 27 | 605.192982456586 | -31.192982456586 | 547 | 0.757302287305342 | -0.874908035638815 | -0.0515422077929063 | weekly | |||||||||
| 3469 | 3469 | United States | Delaware | DE | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 973764 | 191 | 9 | 171.421052636276 | 19.5789473637237 | 182 | 0.924248585899664 | 2.01064604603618 | 0.114215535738581 | weekly | |||||||||
| 3621 | 3621 | United States | District of Columbia | DC | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 705749 | 129 | 1 | 108.042606516776 | 20.9573934832244 | 128 | 0.14169343491808 | 2.96952506956785 | 0.193973416218632 | weekly | |||||||||
| 3773 | 3773 | United States | Florida | FL | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 21477737 | 4548 | 300 | 4028.48120300844 | 519.518796991562 | 4248 | 1.39679520239958 | 2.41887121064739 | 0.128961454903548 | weekly | |||||||||
| 3925 | 3925 | United States | Georgia | GA | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 10617423 | 1786 | 48 | 1648.72681704318 | 137.273182956815 | 1738 | 0.452087102491819 | 1.29290490693283 | 0.0832601141303688 | weekly | |||||||||
| 4077 | 4077 | United States | Hawaii | HI | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 1415872 | 265 | 8 | 225.062656642465 | 39.9373433575348 | 257 | 0.565022826922208 | 2.82068883045464 | 0.17744988863692 | weekly | |||||||||
| 4229 | 4229 | United States | Idaho | ID | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 1787065 | 357 | 9 | 275.395989975641 | 81.6040100243586 | 348 | 0.503619062541094 | 4.5663705586735 | 0.296315171588288 | weekly | |||||||||
| 4381 | 4381 | United States | Illinois | IL | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 12671821 | 2040 | 0 | 1888.40350877241 | 151.596491227594 | 2040 | 0.0 | 1.19632759354471 | 0.0802775945518879 | weekly | |||||||||
| 4533 | 4533 | United States | Indiana | IN | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 6732219 | 1285 | 38 | 1226.58897243297 | 58.4110275670289 | 1247 | 0.564449849299317 | 0.867634097569151 | 0.0476207017018659 | weekly | |||||||||
| 4685 | 4685 | United States | Iowa | IA | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 3155070 | 625 | 12 | 568.796992481714 | 56.2030075182857 | 613 | 0.380340214321711 | 1.78135532708579 | 0.0988103106401228 | weekly | |||||||||
| 4837 | 4837 | United States | Kansas | KS | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 2913314 | 544 | 3 | 496.786967419256 | 47.213032580744 | 541 | 0.102975511736806 | 1.62059539688286 | 0.0950367776876466 | weekly | |||||||||
| 4989 | 4989 | United States | Kentucky | KY | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 4467673 | 978 | 59 | 910.54636591646 | 67.4536340835398 | 919 | 1.32059799363114 | 1.5098158276924 | 0.0740803945943467 | weekly | |||||||||
| 5141 | 5141 | United States | Louisiana | LA | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 4648794 | 917 | 15 | 885.233082707614 | 31.7669172923858 | 902 | 0.322664329716481 | 0.68333673835377 | 0.0358853706587896 | weekly | |||||||||
| 5293 | 5293 | United States | Maine | ME | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 1344212 | 319 | 21 | 270.824561404185 | 48.1754385958155 | 298 | 1.5622535730971 | 3.58391671818251 | 0.177884303942128 | weekly | |||||||||
| 5445 | 5445 | United States | Maryland | MD | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 6045680 | 957 | 44 | 945.548872181339 | 11.451127818661 | 913 | 0.727792407140305 | 0.189410088173059 | 0.0121105615537818 | weekly | |||||||||
| 5597 | 5597 | United States | Massachusetts | MA | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 6949503 | 1139 | 72 | 1054.91729323384 | 84.0827067661594 | 1067 | 1.0360453114417 | 1.20990964053342 | 0.0797054966351007 | weekly | |||||||||
| 5749 | 5749 | United States | Michigan | MI | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 9986857 | 1927 | 131 | 1786.72932330902 | 140.27067669098 | 1796 | 1.31172399885169 | 1.40455277061622 | 0.0785069539415175 | weekly | |||||||||
| 5901 | 5901 | United States | Minnesota | MN | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 5639632 | 871 | 49 | 834.879699248894 | 36.1203007511058 | 822 | 0.868851017229493 | 0.640472654086398 | 0.043264078385906 | weekly | |||||||||
| 6053 | 6053 | United States | Mississippi | MS | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 2976149 | 641 | 6 | 600.581453634777 | 40.4185463652229 | 635 | 0.201602809536754 | 1.35808208410341 | 0.0672990251707009 | weekly | |||||||||
| 6205 | 6205 | United States | Missouri | MO | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 6137428 | 1262 | 0 | 1178.45363408602 | 83.5463659139834 | 1262 | 0.0 | 1.361260220307 | 0.0708949113460711 | weekly | |||||||||
| 6357 | 6357 | United States | Montana | MT | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 1068778 | 188 | 11 | 201.180451128659 | -13.1804511286594 | 177 | 1.02921280191022 | -1.23322627605166 | -0.065515566024008 | weekly | |||||||||
| 6509 | 6509 | United States | Nebraska | NE | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 1934408 | 302 | 29 | 307.18796992592 | -5.18796992591979 | 273 | 1.49916667011303 | -0.2681941930513 | -0.0168885842996095 | weekly | |||||||||
| 6661 | 6661 | United States | Nevada | NV | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 3080156 | 580 | 39 | 519.709273183813 | 60.2907268161865 | 541 | 1.26616963556391 | 1.95739198976242 | 0.116008564647763 | weekly | |||||||||
| 6813 | 6813 | United States | New Hampshire | NH | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 1359711 | 282 | 19 | 205.977443609857 | 76.0225563901427 | 263 | 1.39735576162876 | 5.59108195713227 | 0.369081949255266 | weekly | |||||||||
| 6965 | 6965 | United States | New Jersey | NJ | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 8882190 | 1384 | 91 | 1360.23558897344 | 23.7644110265562 | 1293 | 1.02452210547174 | 0.267551257365089 | 0.0174708052187422 | weekly | |||||||||
| 7117 | 7117 | United States | New Mexico | NM | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 2096829 | 456 | 48 | 374.949874687593 | 81.0501253124071 | 408 | 2.28917093382436 | 3.86536648016634 | 0.216162561408876 | weekly | |||||||||
| 7269 | 7269 | United States | New York | NY | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 19453561 | 2920 | 150 | 2806.46616541439 | 113.533834585612 | 2770 | 0.771067055538058 | 0.583614663585817 | 0.0404543749661945 | weekly | |||||||||
| 7421 | 7421 | United States | North Carolina | NC | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 10488084 | 2072 | 441 | 1860.07518797063 | 211.924812029367 | 1631 | 4.20477181532871 | 2.0206246634692 | 0.113933465378128 | weekly | |||||||||
| 7573 | 7573 | United States | North Dakota | ND | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 762062 | 147 | 0 | 143.902255640043 | 3.09774435995706 | 147 | 0.0 | 0.406495056827012 | 0.0215267255275398 | weekly | |||||||||
| 7725 | 7725 | United States | Ohio | OH | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 11689100 | 2378 | 0 | 2224.96741854883 | 153.032581451171 | 2378 | 0.0 | 1.30919045479268 | 0.0687796954577347 | weekly | |||||||||
| 7877 | 7877 | United States | Oklahoma | OK | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 3956971 | 795 | 95 | 711.864661654863 | 83.1353383451375 | 700 | 2.40082628859297 | 2.10098427168502 | 0.116785314433047 | weekly | |||||||||
| 8029 | 8029 | United States | Oregon | OR | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 4217737 | 778 | 36 | 687.443609023538 | 90.5563909764618 | 742 | 0.85353828368151 | 2.14703740362336 | 0.131729191729763 | weekly | |||||||||
| 8181 | 8181 | United States | Pennsylvania | PA | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 12801989 | 2544 | 159 | 2412.57142857259 | 131.428571427407 | 2385 | 1.24199450569751 | 1.0266261861919 | 0.054476551396933 | weekly | |||||||||
| 8333 | 8333 | United States | Rhode Island | RI | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 1059361 | 194 | 7 | 200.711779449548 | -6.71177944954758 | 187 | 0.660775694026871 | -0.633568674847156 | -0.0334398881219361 | weekly | |||||||||
| 8485 | 8485 | United States | South Carolina | SC | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 5148714 | 1099 | 0 | 969.275689224054 | 129.724310775946 | 1099 | 0.0 | 2.51954780894698 | 0.133836340081733 | weekly | |||||||||
| 8637 | 8637 | United States | South Dakota | SD | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 884659 | 159 | 0 | 168.551378446834 | -9.55137844683361 | 159 | 0.0 | -1.07966780949876 | -0.0566674597078208 | weekly | |||||||||
| 8789 | 8789 | United States | Tennessee | TN | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 6833174 | 1626 | 48 | 1474.72180451223 | 151.278195487769 | 1578 | 0.702455403594289 | 2.21387887221618 | 0.102580835941328 | weekly | |||||||||
| 8941 | 8941 | United States | Texas | TX | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 28995881 | 4263 | 60 | 3918.23558897302 | 344.764411026975 | 4203 | 0.206925942343328 | 1.18901167730332 | 0.0879897094491295 | weekly | |||||||||
| 9093 | 9093 | United States | Utah | UT | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 3205958 | 419 | 12 | 394.882205514657 | 24.1177944853435 | 407 | 0.374303094426065 | 0.752280425549664 | 0.061075921245705 | weekly | |||||||||
| 9245 | 9245 | United States | Vermont | VT | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 623989 | 132 | 3 | 98.8295739357405 | 33.1704260642595 | 129 | 0.480777706017254 | 5.31586711692986 | 0.33563259197927 | weekly | |||||||||
| 9397 | 9397 | United States | Virginia | VA | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 8535519 | 1468 | 17 | 1325.48370927388 | 142.516290726125 | 1451 | 0.199167736607463 | 1.6696851208008 | 0.107520212982624 | weekly | |||||||||
| 9549 | 9549 | United States | Washington | WA | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 7614893 | 1215 | 78 | 1080.24561403595 | 134.754385964051 | 1137 | 1.02430854904987 | 1.76961627647363 | 0.124744210217702 | weekly | |||||||||
| 9701 | 9701 | United States | West Virginia | WV | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 1792147 | 472 | 25 | 423.383458647672 | 48.6165413523278 | 447 | 1.39497485418328 | 2.71275410735435 | 0.114828627239273 | weekly | |||||||||
| 9853 | 9853 | United States | Wisconsin | WI | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 5822434 | 1059 | 40 | 1003.82706767006 | 55.1729323299371 | 1019 | 0.686997911869847 | 0.947592232560079 | 0.0549625867909664 | weekly | |||||||||
| 10005 | 10005 | United States | Wyoming | WY | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 578759 | 103 | 4 | 92.2230576450062 | 10.7769423549938 | 99 | 0.691133960767781 | 1.86207771369323 | 0.116857352490713 | weekly | |||||||||
| 12053 | 12053 | Canada | Canada | 0 | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 38454328 | 5460 | 220 | 5453.47018030517 | 6.52981969482698 | 5240 | 0.572107254091139 | 0.0169807146150805 | 0.00119736965252182 | weekly | |||||||||
| 17104 | 17104 | South Africa | South Africa | 0 | 2022-06-05 | 2022-06-11 | 7 | 2022 | 23 | 59893884 | 12354 | 164 | 11451.1765690375 | 902.823430962466 | 12190 | 0.273817607153345 | 1.50737165578119 | 0.078841106459193 | 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);