economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
165 rows where "end_date" is on date 2021-07-31 sorted by cadence
This data as json, yaml, Notebook, copyable, CSV (advanced)
country 15
- United States 51
- Aruba 1
- Azerbaijan 1
- Belize 1
- Bolivia 1
- Bosnia and Herzegovina 1
- Canada 1
- Macao 1
- Mongolia 1
- Paraguay 1
- Russia 1
- Seychelles 1
- South Africa 1
- Uruguay 1
- Uzbekistan 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23285 | 23285 | Uruguay | Uruguay | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 3422796 | 3702 | 371 | 3598.105719151 | 103.894280848997 | 3331 | 10.8390917834425 | 3.0353629269462 | 0.0288747160196037 | monthly | 7 | 835.935483870968 | 83.7741935483871 | 812.475484969581 | 23.4599989013865 | 752.161290322581 | 2.44753685432573 | 0.685404531891077 | ||
23629 | 23629 | Seychelles | Seychelles | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 107135 | 98 | 23 | 72.2224435930176 | 25.7775564069824 | 75 | 21.4682410043403 | 24.060817106438 | 0.356918917784645 | monthly | 7 | 22.1290322580645 | 5.19354838709677 | 16.3082937145524 | 5.82073854351215 | 16.9354838709677 | 4.84766732356072 | 5.43308773371182 | ||
23653 | 23653 | Paraguay | Paraguay | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 6780745 | 5174 | 2086 | 3367.51340023108 | 1806.48659976892 | 3088 | 30.7635812878968 | 26.6414177169163 | 0.536445259473936 | monthly | 7 | 1168.32258064516 | 471.032258064516 | 760.406251665083 | 407.916328980079 | 697.290322580645 | 6.94661512952509 | 6.01580400059401 | ||
23841 | 23841 | Bolivia | Bolivia | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 12224114 | 7631 | 1054 | 4729.02360639784 | 2901.97639360216 | 6577 | 8.62230178808869 | 23.7397687358132 | 0.613652338228153 | monthly | 7 | 1723.12903225806 | 238.0 | 1067.84404015435 | 655.284992103714 | 1485.12903225806 | 1.9469713715039 | 5.36059294034492 | ||
23866 | 23866 | Mongolia | Mongolia | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 3398373 | 1819 | 217 | 1454.7075180928 | 364.292481907204 | 1602 | 6.38540854697233 | 10.7196144127559 | 0.2504231794889 | monthly | 7 | 410.741935483871 | 49.0 | 328.482342795147 | 82.2595926887235 | 361.741935483871 | 1.44186644609053 | 2.42055809320294 | ||
24203 | 24203 | Azerbaijan | Azerbaijan | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 10358078 | 5087 | 49 | 5021.05968862129 | 65.9403113787093 | 5038 | 0.473060735785152 | 0.636607596300292 | 0.0131327479591894 | monthly | 7 | 1148.67741935484 | 11.0645161290323 | 1133.78767162416 | 14.8897477306763 | 1137.61290322581 | 0.106820166145034 | 0.143750102390388 | ||
24396 | 24396 | Russia | Russia | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 144713312 | 218472.9 | 22979 | 140326.544584444 | 78146.3554155564 | 195493.9 | 15.8789814720017 | 54.0008063774785 | 0.556889330147587 | monthly | 7 | 49332.5903225806 | 5188.8064516129 | 31686.6390997131 | 17645.9512228676 | 44143.7838709677 | 3.58557646141974 | 12.1937304723339 | ||
24430 | 24430 | Belize | Belize | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 405285 | 165 | 8 | 166.694878063613 | -1.69487806361303 | 157 | 1.97391958745081 | -0.418194126013307 | -0.0101675473373948 | monthly | 7 | 37.258064516129 | 1.80645161290323 | 37.64077891759 | -0.382714401461007 | 35.4516129032258 | 0.445723777811472 | -0.0944309316804242 | ||
24454 | 24454 | Macao | Macao | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 695180 | 178 | 0 | 176.905176670924 | 1.09482332907612 | 178 | 0.0 | 0.157487748363894 | 0.00618875800968044 | monthly | 7 | 40.1935483870968 | 0.0 | 39.9463302160151 | 0.247218171081705 | 40.1935483870968 | 0.0 | 0.0355617496305568 | ||
24488 | 24488 | Uzbekistan | Uzbekistan | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 34627648 | 17670 | 138 | 13962.438614608 | 3707.561385392 | 17532 | 0.398525478831251 | 10.7069396841275 | 0.265538240684762 | monthly | 7 | 3990.0 | 31.1612903225806 | 3152.80871942761 | 837.191280572386 | 3958.83870967742 | 0.0899896242522179 | 2.41769605770622 | ||
24521 | 24521 | Aruba | Aruba | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 106459 | 70 | 3 | 54.319857690202 | 15.680142309798 | 67 | 2.81798626701359 | 14.7288085646099 | 0.288663169907869 | monthly | 7 | 15.8064516129032 | 0.67741935483871 | 12.2657743171424 | 3.54067729576084 | 15.1290322580645 | 0.636319479648231 | 3.32585999846029 | ||
24545 | 24545 | Bosnia and Herzegovina | Bosnia and Herzegovina | 0 | 2021-07-01 | 2021-07-31 | 31 | 2021 | 3233530 | 3067 | 33 | 2732.54241561763 | 334.457584382375 | 3034 | 1.02055648161607 | 10.3434198656693 | 0.122397947958945 | monthly | 7 | 692.548387096774 | 7.45161290322581 | 617.025706752367 | 75.5226803444073 | 685.096774193548 | 0.230448237784273 | 2.33561093740919 | ||
2360 | 2360 | United States | Alabama | AL | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 4903185 | 1170 | 59 | 945.704260639115 | 224.295739360885 | 1111 | 1.20329948798587 | 4.57449064966722 | 0.237173235541209 | weekly | |||||||||
2512 | 2512 | United States | Alaska | AK | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 731545 | 115 | 5 | 79.2794486253938 | 35.7205513746062 | 110 | 0.683484953078758 | 4.88289187604402 | 0.450565083309178 | weekly | |||||||||
2664 | 2664 | United States | Arizona | AZ | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 7278717 | 1302 | 80 | 1124.88220552411 | 177.117794475887 | 1222 | 1.09909479926201 | 2.43336558456507 | 0.157454525999336 | weekly | |||||||||
2816 | 2816 | United States | Arkansas | AR | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 3017825 | 841 | 82 | 562.098997495311 | 278.901002504689 | 759 | 2.71718870378501 | 9.24178845707386 | 0.496177726250109 | weekly | |||||||||
2968 | 2968 | United States | California | CA | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 39512223 | 5508 | 159 | 4800.23809523854 | 707.761904761461 | 5349 | 0.402407123486826 | 1.79124800131205 | 0.147443083180292 | weekly | |||||||||
3120 | 3120 | United States | Colorado | CO | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 5758736 | 835 | 35 | 735.132832081247 | 99.8671679187528 | 800 | 0.607772261135082 | 1.73418555597535 | 0.135849146658322 | weekly | |||||||||
3272 | 3272 | United States | Connecticut | CT | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 3565287 | 572 | 7 | 560.061403509367 | 11.9385964906334 | 565 | 0.196337630042126 | 0.334856534428599 | 0.0213165849598378 | weekly | |||||||||
3424 | 3424 | United States | Delaware | DE | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 973764 | 180 | 2 | 164.8157894775 | 15.1842105225 | 178 | 0.20538857464437 | 1.55933167815816 | 0.092128372958908 | weekly | |||||||||
3576 | 3576 | United States | District of Columbia | DC | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 705749 | 104 | 3 | 104.615288220991 | -0.61528822099072 | 101 | 0.42508030475424 | -0.0871823014968098 | -0.00588143694343202 | weekly | |||||||||
3728 | 3728 | United States | Florida | FL | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 21477737 | 5326 | 756 | 3814.0275689233 | 1511.9724310767 | 4570 | 3.51992391004695 | 7.03971945962789 | 0.396424095986157 | weekly | |||||||||
3880 | 3880 | United States | Georgia | GA | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 10617423 | 1941 | 62 | 1616.0451127825 | 324.954887217498 | 1879 | 0.5839458407186 | 3.06058152922323 | 0.201080331636282 | weekly | |||||||||
4032 | 4032 | United States | Hawaii | HI | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 1415872 | 232 | 10 | 230.463659148742 | 1.53634085125771 | 222 | 0.706278533652759 | 0.108508456361712 | 0.00666630416670655 | weekly | |||||||||
4184 | 4184 | United States | Idaho | ID | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 1787065 | 337 | 14 | 258.463659148616 | 78.536340851384 | 323 | 0.783407430619479 | 4.39471092833131 | 0.303858349410064 | weekly | |||||||||
4336 | 4336 | United States | Illinois | IL | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 12671821 | 2071 | 54 | 1844.7192982461 | 226.280701753903 | 2017 | 0.426142383166555 | 1.78569995388905 | 0.122664029139308 | weekly | |||||||||
4488 | 4488 | United States | Indiana | IN | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 6732219 | 1349 | 40 | 1175.52506265827 | 173.474937341733 | 1309 | 0.594157736104544 | 2.57678690104605 | 0.147572300117061 | weekly | |||||||||
4640 | 4640 | United States | Iowa | IA | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 3155070 | 551 | 12 | 555.097744361486 | -4.09774436148552 | 539 | 0.380340214321711 | -0.129878080723582 | -0.00738202308171698 | weekly | |||||||||
4792 | 4792 | United States | Kansas | KS | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 2913314 | 532 | 16 | 482.256892231311 | 49.743107768689 | 516 | 0.549202729262963 | 1.70744065928661 | 0.103146494264783 | weekly | |||||||||
4944 | 4944 | United States | Kentucky | KY | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 4467673 | 1026 | 22 | 871.909774437555 | 154.090225562445 | 1004 | 0.492426370506525 | 3.44900411382939 | 0.176727260182218 | weekly | |||||||||
5096 | 5096 | United States | Louisiana | LA | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 4648794 | 1185 | 99 | 826.591478697612 | 358.408521302388 | 1086 | 2.12958457612878 | 7.70970968604735 | 0.433598132256457 | weekly | |||||||||
5248 | 5248 | United States | Maine | ME | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 1344212 | 285 | 3 | 264.868421053339 | 20.1315789466614 | 282 | 0.223179081871014 | 1.49764910197658 | 0.0760059612489905 | weekly | |||||||||
5400 | 5400 | United States | Maryland | MD | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 6045680 | 958 | 15 | 896.494987469553 | 61.5050125304473 | 943 | 0.24811104788874 | 1.01733820728929 | 0.0686060863586659 | weekly | |||||||||
5552 | 5552 | United States | Massachusetts | MA | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 6949503 | 1118 | 36 | 1047.35463659224 | 70.6453634077591 | 1082 | 0.518022655720848 | 1.01655274352366 | 0.0674512347008045 | weekly | |||||||||
5704 | 5704 | United States | Michigan | MI | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 9986857 | 1862 | 42 | 1711.13032581536 | 150.869674184645 | 1820 | 0.420552732456267 | 1.51068223150331 | 0.0881695987199309 | weekly | |||||||||
5856 | 5856 | United States | Minnesota | MN | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 5639632 | 911 | 18 | 848.909774436881 | 62.090225563119 | 893 | 0.319169761431242 | 1.10096236001071 | 0.073141136352572 | weekly | |||||||||
6008 | 6008 | United States | Mississippi | MS | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 2976149 | 760 | 41 | 553.602756892938 | 206.397243107062 | 719 | 1.37761919850115 | 6.93504401517069 | 0.372825533357989 | weekly | |||||||||
6160 | 6160 | United States | Missouri | MO | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 6137428 | 1515 | 110 | 1171.92355889804 | 343.076441101963 | 1405 | 1.79228171800956 | 5.58990575697121 | 0.292746432561317 | weekly | |||||||||
6312 | 6312 | United States | Montana | MT | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 1068778 | 255 | 9 | 211.802005013366 | 43.1979949866339 | 246 | 0.842083201562906 | 4.04181176882701 | 0.203954608380161 | weekly | |||||||||
6464 | 6464 | United States | Nebraska | NE | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 1934408 | 361 | -4 | 295.390977444689 | 65.6090225553106 | 365 | -0.206781609670762 | 3.39168482322812 | 0.222109094606979 | weekly | |||||||||
6616 | 6616 | United States | Nevada | NV | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 3080156 | 672 | 95 | 472.115288221409 | 199.884711778591 | 577 | 3.08425936868133 | 6.48943468378196 | 0.423381146015442 | weekly | |||||||||
6768 | 6768 | United States | New Hampshire | NH | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 1359711 | 230 | 2 | 227.733082707593 | 2.26691729240673 | 228 | 0.147090080171448 | 0.166720523141074 | 0.00995427307027419 | weekly | |||||||||
6920 | 6920 | United States | New Jersey | NJ | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 8882190 | 1373 | 34 | 1318.84335839698 | 54.1566416030157 | 1339 | 0.382788478967462 | 0.609721719564834 | 0.041063740631671 | weekly | |||||||||
7072 | 7072 | United States | New Mexico | NM | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 2096829 | 389 | 13 | 338.962406015898 | 50.0375939841019 | 376 | 0.619983794577431 | 2.38634595306064 | 0.147619892637165 | weekly | |||||||||
7224 | 7224 | United States | New York | NY | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 19453561 | 2906 | 41 | 2730.18295739431 | 175.817042605689 | 2865 | 0.210758328513736 | 0.90377819570252 | 0.0643975313557335 | weekly | |||||||||
7376 | 7376 | United States | North Carolina | NC | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 10488084 | 2008 | 65 | 1753.38972431143 | 254.610275688569 | 1943 | 0.619750947837565 | 2.42761476441807 | 0.145210315857506 | weekly | |||||||||
7528 | 7528 | United States | North Dakota | ND | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 762062 | 128 | 1 | 134.343358396894 | -6.34335839689368 | 127 | 0.131222918870118 | -0.832394004279662 | -0.0472175064892553 | weekly | |||||||||
7680 | 7680 | United States | Ohio | OH | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 11689100 | 2355 | 25 | 2151.39223057865 | 203.607769421353 | 2330 | 0.213874464244467 | 1.74186010404012 | 0.0946400040529058 | weekly | |||||||||
7832 | 7832 | United States | Oklahoma | OK | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 3956971 | 934 | 92 | 709.06516290801 | 224.93483709199 | 842 | 2.32501072158477 | 5.6845207380087 | 0.317227314016514 | weekly | |||||||||
7984 | 7984 | United States | Oregon | OR | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 4217737 | 824 | 22 | 666.416040101187 | 157.583959898813 | 802 | 0.521606728916478 | 3.73622062966024 | 0.236464836402926 | weekly | |||||||||
8136 | 8136 | United States | Pennsylvania | PA | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 12801989 | 2499 | 27 | 2317.09523809635 | 181.904761903646 | 2472 | 0.210904727382597 | 1.42091015625498 | 0.0785055179920409 | weekly | |||||||||
8288 | 8288 | United States | Rhode Island | RI | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 1059361 | 183 | 1 | 180.200501254027 | 2.79949874597321 | 182 | 0.0943965277181244 | 0.264262960971115 | 0.0155354659198577 | weekly | |||||||||
8440 | 8440 | United States | South Carolina | SC | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 5148714 | 1110 | 26 | 948.540100251603 | 161.459899748397 | 1084 | 0.504980466967091 | 3.13592675274635 | 0.170219371543248 | weekly | |||||||||
8592 | 8592 | United States | South Dakota | SD | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 884659 | 164 | 2 | 153.080200501972 | 10.919799498028 | 162 | 0.226075810001368 | 1.2343512582846 | 0.0713338463251316 | weekly | |||||||||
8744 | 8744 | United States | Tennessee | TN | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 6833174 | 1600 | 59 | 1416.04135338438 | 183.958646615618 | 1541 | 0.86343476691798 | 2.69214052818819 | 0.129910504503242 | weekly | |||||||||
8896 | 8896 | United States | Texas | TX | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 28995881 | 4805 | 440 | 3794.34335839654 | 1010.65664160346 | 4365 | 1.51745691051774 | 3.4855179658223 | 0.266358773084403 | weekly | |||||||||
9048 | 9048 | United States | Utah | UT | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 3205958 | 447 | 26 | 359.328320802858 | 87.6716791971417 | 421 | 0.810990037923142 | 2.73464840141829 | 0.243987668439978 | weekly | |||||||||
9200 | 9200 | United States | Vermont | VT | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 623989 | 113 | 1 | 96.2055137853399 | 16.7944862146601 | 112 | 0.160259235339084 | 2.69147151867422 | 0.17456885321701 | weekly | |||||||||
9352 | 9352 | United States | Virginia | VA | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 8535519 | 1484 | 32 | 1258.9461152889 | 225.053884711096 | 1452 | 0.374903974790519 | 2.63667487250741 | 0.178763715124893 | weekly | |||||||||
9504 | 9504 | United States | Washington | WA | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 7614893 | 1227 | 44 | 1033.35087719383 | 193.64912280617 | 1183 | 0.577815078951208 | 2.54303143597907 | 0.187399195258868 | weekly | |||||||||
9656 | 9656 | United States | West Virginia | WV | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 1792147 | 467 | 10 | 420.204260652627 | 46.7957393473735 | 457 | 0.557989941673311 | 2.61115518690004 | 0.111364266689477 | weekly | |||||||||
9808 | 9808 | United States | Wisconsin | WI | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 5822434 | 1103 | 11 | 1019.12030075274 | 83.8796992472578 | 1092 | 0.188924425764208 | 1.44062945577842 | 0.0823059840779372 | weekly | |||||||||
9960 | 9960 | United States | Wyoming | WY | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 578759 | 94 | 10 | 94.0839599006203 | -0.0839599006203287 | 84 | 1.72783490191945 | -0.0145068846653492 | -0.00089239335492485 | weekly | |||||||||
12008 | 12008 | Canada | Canada | 0 | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 38454328 | 5525 | 54 | 5274.17614424422 | 250.823855755778 | 5471 | 0.140426326004189 | 0.652264306259046 | 0.0475569736193788 | weekly | |||||||||
17059 | 17059 | South Africa | South Africa | 0 | 2021-07-25 | 2021-07-31 | 7 | 2021 | 30 | 59893884 | 19075 | 2525 | 10562.1012552301 | 8512.89874476994 | 16550 | 4.21578937842802 | 14.2133022209245 | 0.805985337487133 | 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);