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-07-31 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: covid_deaths, covid_deaths_per_100k
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2413 | 2413 | United States | Alabama | AL | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 4903185 | 1107 | 83 | 982.383458629619 | 124.616541370381 | 1024 | 1.69277724581063 | 2.54154271907712 | 0.126851221155755 | weekly | |||||||||
2565 | 2565 | United States | Alaska | AK | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 731545 | 109 | 21 | 85.8170426113289 | 23.1829573886711 | 88 | 2.87063680293078 | 3.16904050860454 | 0.270143979368623 | weekly | |||||||||
2717 | 2717 | United States | Arizona | AZ | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 7278717 | 1326 | 0 | 1172.06516291981 | 153.934837080187 | 1326 | 0.0 | 2.11486223575098 | 0.131336415371914 | weekly | |||||||||
2869 | 2869 | United States | Arkansas | AR | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 3017825 | 641 | 46 | 557.576441104528 | 83.4235588954723 | 595 | 1.52427658992818 | 2.7643603885405 | 0.149618155907403 | weekly | |||||||||
3021 | 3021 | United States | California | CA | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 39512223 | 5903 | 301 | 4718.76190476212 | 1184.23809523788 | 5602 | 0.761789585971915 | 2.99714368193833 | 0.250963731406487 | weekly | |||||||||
3173 | 3173 | United States | Colorado | CO | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 5758736 | 863 | 48 | 765.954887218994 | 97.0451127810062 | 815 | 0.833516243842399 | 1.68518078934346 | 0.126698209516431 | weekly | |||||||||
3325 | 3325 | United States | Connecticut | CT | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 3565287 | 603 | 0 | 578.19298245652 | 24.8070175434796 | 603 | 0.0 | 0.69579300470003 | 0.0429043905688444 | weekly | |||||||||
3477 | 3477 | United States | Delaware | DE | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 973764 | 197 | 2 | 159.754385969545 | 37.2456140304545 | 195 | 0.20538857464437 | 3.82491178873469 | 0.233142982613039 | weekly | |||||||||
3629 | 3629 | United States | District of Columbia | DC | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 705749 | 127 | 5 | 108.042606516709 | 18.9573934832911 | 122 | 0.7084671745904 | 2.68613819974115 | 0.17546220046403 | weekly | |||||||||
3781 | 3781 | United States | Florida | FL | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 21477737 | 4540 | 521 | 3890.14786967506 | 649.85213032494 | 4019 | 2.42576766816727 | 3.02570112635675 | 0.16705075284946 | weekly | |||||||||
3933 | 3933 | United States | Georgia | GA | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 10617423 | 1878 | 123 | 1632.72681704313 | 245.273182956869 | 1755 | 1.15847320013529 | 2.31010088753993 | 0.150223038169397 | weekly | |||||||||
4085 | 4085 | United States | Hawaii | HI | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 1415872 | 244 | 21 | 212.729323309069 | 31.2706766909307 | 223 | 1.4831849206708 | 2.20858076796001 | 0.146997490541059 | weekly | |||||||||
4237 | 4237 | United States | Idaho | ID | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 1787065 | 329 | 18 | 260.395989975578 | 68.6040100244216 | 311 | 1.00723812508219 | 3.83892080167322 | 0.263460316846107 | weekly | |||||||||
4389 | 4389 | United States | Illinois | IL | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 12671821 | 2193 | 84 | 1851.73684210567 | 341.263157894334 | 2109 | 0.662888151592419 | 2.69308695170437 | 0.184293550862375 | weekly | |||||||||
4541 | 4541 | United States | Indiana | IN | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 6732219 | 1404 | 78 | 1196.58897243291 | 207.411027567093 | 1326 | 1.15860758540386 | 3.08087166455953 | 0.173335232352497 | weekly | |||||||||
4693 | 4693 | United States | Iowa | IA | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 3155070 | 616 | 35 | 533.463659148318 | 82.5363408516824 | 581 | 1.10932562510499 | 2.61599079740489 | 0.154717832107726 | weekly | |||||||||
4845 | 4845 | United States | Kansas | KS | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 2913314 | 605 | -1 | 469.786967419193 | 135.213032580807 | 606 | -0.0343251705789352 | 4.64121040783133 | 0.287817759874458 | weekly | |||||||||
4997 | 4997 | United States | Kentucky | KY | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 4467673 | 1063 | 45 | 870.213032583063 | 192.786967416937 | 1018 | 1.00723575785426 | 4.31515393845827 | 0.221539968029076 | weekly | |||||||||
5149 | 5149 | United States | Louisiana | LA | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 4648794 | 972 | 62 | 831.233082707546 | 140.766917292454 | 910 | 1.33367922949479 | 3.02803086762833 | 0.169347106390351 | weekly | |||||||||
5301 | 5301 | United States | Maine | ME | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 1344212 | 317 | 26 | 286.491228070788 | 30.5087719292119 | 291 | 1.93421870954879 | 2.26963990272457 | 0.106491120634499 | weekly | |||||||||
5453 | 5453 | United States | Maryland | MD | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 6045680 | 993 | 31 | 913.882205514607 | 79.1177944853926 | 962 | 0.512762832303397 | 1.30866659309445 | 0.0865732957792316 | weekly | |||||||||
5605 | 5605 | United States | Massachusetts | MA | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 6949503 | 1224 | 0 | 1051.58395990043 | 172.416040099566 | 1224 | 0.0 | 2.48098374947914 | 0.163958415755876 | weekly | |||||||||
5757 | 5757 | United States | Michigan | MI | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 9986857 | 1954 | 106 | 1807.06265664229 | 146.937343357708 | 1848 | 1.06139499143725 | 1.47130717259402 | 0.081312810498078 | weekly | |||||||||
5909 | 5909 | United States | Minnesota | MN | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 5639632 | 949 | 0 | 866.879699248834 | 82.1203007511662 | 949 | 0.0 | 1.45612871107842 | 0.0947309076707239 | weekly | |||||||||
6061 | 6061 | United States | Mississippi | MS | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 2976149 | 712 | 49 | 579.914786968045 | 132.085213031955 | 663 | 1.64642294455016 | 4.4381250075838 | 0.227766589161372 | weekly | |||||||||
6213 | 6213 | United States | Missouri | MO | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 6137428 | 1248 | 0 | 1121.78696741928 | 126.213032580717 | 1248 | 0.0 | 2.05644828062695 | 0.112510696100415 | weekly | |||||||||
6365 | 6365 | United States | Montana | MT | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 1068778 | 242 | 8 | 207.847117795259 | 34.1528822047406 | 234 | 0.74851840138925 | 3.19550759884097 | 0.164317324036136 | weekly | |||||||||
6517 | 6517 | United States | Nebraska | NE | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 1934408 | 340 | 4 | 301.854636592519 | 38.145363407481 | 336 | 0.206781609670762 | 1.97193991171878 | 0.126369976748028 | weekly | |||||||||
6669 | 6669 | United States | Nevada | NV | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 3080156 | 575 | 36 | 509.70927318375 | 65.2907268162495 | 539 | 1.16877197128977 | 2.11972143022138 | 0.128094053318728 | weekly | |||||||||
6821 | 6821 | United States | New Hampshire | NH | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 1359711 | 247 | 6 | 230.310776943123 | 16.689223056877 | 241 | 0.441270240514345 | 1.22740957871761 | 0.0724639258240121 | weekly | |||||||||
6973 | 6973 | United States | New Jersey | NJ | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 8882190 | 1452 | 70 | 1319.56892230671 | 132.431077693288 | 1382 | 0.788093927285951 | 1.49097325877163 | 0.10035934876504 | weekly | |||||||||
7125 | 7125 | United States | New Mexico | NM | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 2096829 | 366 | 36 | 330.616541354197 | 35.3834586458034 | 330 | 1.71687820036827 | 1.68747468896145 | 0.107022650775045 | weekly | |||||||||
7277 | 7277 | United States | New York | NY | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 19453561 | 3026 | 221 | 2777.46616541432 | 248.533834585679 | 2805 | 1.13603879515941 | 1.27757501357042 | 0.0894822186064705 | weekly | |||||||||
7429 | 7429 | United States | North Carolina | NC | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 10488084 | 2022 | 204 | 1769.4085213039 | 252.5914786961 | 1818 | 1.94506451321328 | 2.40836628211693 | 0.142754754289282 | weekly | |||||||||
7581 | 7581 | United States | North Dakota | ND | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 762062 | 159 | 0 | 139.902255639977 | 19.0977443600233 | 159 | 0.0 | 2.5060617587576 | 0.136507765887416 | weekly | |||||||||
7733 | 7733 | United States | Ohio | OH | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 11689100 | 2411 | 98 | 2166.3007518821 | 244.699248117902 | 2313 | 0.838387899838311 | 2.09339682368961 | 0.112957191149616 | weekly | |||||||||
7885 | 7885 | United States | Oklahoma | OK | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 3956971 | 801 | 84 | 702.864661654795 | 98.1353383452046 | 717 | 2.12283587622957 | 2.48006210672771 | 0.139621955262566 | weekly | |||||||||
8037 | 8037 | United States | Oregon | OR | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 4217737 | 813 | 110 | 677.776942356806 | 135.223057643194 | 703 | 2.60803364458239 | 3.2060571259705 | 0.199509675222926 | weekly | |||||||||
8189 | 8189 | United States | Pennsylvania | PA | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 12801989 | 2509 | 97 | 2291.23809523918 | 217.761904760819 | 2412 | 0.757694761337477 | 1.70100056140353 | 0.0950411505523117 | weekly | |||||||||
8341 | 8341 | United States | Rhode Island | RI | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 1059361 | 202 | 2 | 178.045112782812 | 23.9548872171883 | 200 | 0.188793055436249 | 2.26125817518186 | 0.134543918913459 | weekly | |||||||||
8493 | 8493 | United States | South Carolina | SC | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 5148714 | 1135 | 0 | 958.275689223996 | 176.724310776004 | 1135 | 0.0 | 3.43239711461937 | 0.184419069338087 | weekly | |||||||||
8645 | 8645 | United States | South Dakota | SD | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 884659 | 174 | 7 | 159.551378446766 | 14.4486215532336 | 167 | 0.791265335004787 | 1.63324191052525 | 0.0905577983336214 | weekly | |||||||||
8797 | 8797 | United States | Tennessee | TN | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 6833174 | 1620 | 88 | 1459.72180451217 | 160.278195487833 | 1532 | 1.28783490658953 | 2.34558926039104 | 0.109800507872387 | weekly | |||||||||
8949 | 8949 | United States | Texas | TX | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 28995881 | 4424 | 178 | 3903.90225563964 | 520.097744360356 | 4246 | 0.61388029561854 | 1.79369526437343 | 0.133225093842709 | weekly | |||||||||
9101 | 9101 | United States | Utah | UT | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 3205958 | 422 | 28 | 378.882205514592 | 43.1177944854077 | 394 | 0.873373886994153 | 1.34492699172627 | 0.11380263801739 | weekly | |||||||||
9253 | 9253 | United States | Vermont | VT | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 623989 | 139 | 0 | 101.162907269006 | 37.8370927309942 | 139 | 0.0 | 6.06374354852316 | 0.374021405201219 | weekly | |||||||||
9405 | 9405 | United States | Virginia | VA | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 8535519 | 1512 | 136 | 1284.15037594047 | 227.849624059528 | 1376 | 1.59334189285971 | 2.66942905357633 | 0.177432198228855 | weekly | |||||||||
9557 | 9557 | United States | Washington | WA | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 7614893 | 1255 | 121 | 1054.57894736922 | 200.421052630785 | 1134 | 1.58899146711582 | 2.63196150793957 | 0.190048410439789 | weekly | |||||||||
9709 | 9709 | United States | West Virginia | WV | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 1792147 | 472 | 28 | 392.383458647606 | 79.6165413523942 | 444 | 1.56237183668527 | 4.44252292654532 | 0.202904938008349 | weekly | |||||||||
9861 | 9861 | United States | Wisconsin | WI | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 5822434 | 1052 | 23 | 985.49373433666 | 66.5062656633401 | 1029 | 0.395023799325162 | 1.1422416409244 | 0.0674852242547292 | weekly | |||||||||
10013 | 10013 | United States | Wyoming | WY | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 578759 | 93 | -1 | 95.8897243116064 | -2.8897243116064 | 94 | -0.172783490191945 | -0.49929665225187 | -0.0301359121882118 | weekly | |||||||||
17112 | 17112 | South Africa | South Africa | 0 | 2022-07-31 | 2022-08-06 | 7 | 2022 | 31 | 59893884 | 11177 | 0 | 11025.1765690375 | 151.823430962462 | 11177 | 0.0 | 0.253487369365563 | 0.0137706121994339 | 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);