economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where "end_date" is on date 2021-10-09 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2370 | 2370 | United States | Alabama | AL | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 4903185 | 1371 | 363 | 963.370927304496 | 407.629072695504 | 1008 | 7.40335108709951 | 8.31355685529924 | 0.423127853604683 | weekly | |||||||||
2522 | 2522 | United States | Alaska | AK | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 731545 | 150 | 16 | 95.9461152920732 | 54.0538847079268 | 134 | 2.18715184985203 | 7.38900337066439 | 0.56337752230384 | weekly | |||||||||
2674 | 2674 | United States | Arizona | AZ | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 7278717 | 1559 | 280 | 1123.21553885744 | 435.784461142562 | 1279 | 3.84683179741705 | 5.98710543551236 | 0.387979373563379 | weekly | |||||||||
2826 | 2826 | United States | Arkansas | AR | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 3017825 | 830 | 92 | 572.432330828658 | 257.567669171342 | 738 | 3.04855317985635 | 8.53487757478785 | 0.449953043005946 | weekly | |||||||||
2978 | 2978 | United States | California | CA | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 39512223 | 6098 | 699 | 4843.90476190522 | 1254.09523809478 | 5399 | 1.76907282589491 | 3.17394249899525 | 0.258901712510448 | weekly | |||||||||
3130 | 3130 | United States | Colorado | CO | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 5758736 | 991 | 139 | 785.132832081248 | 205.867167918752 | 852 | 2.41372412279361 | 3.5748672611273 | 0.262206800565243 | weekly | |||||||||
3282 | 3282 | United States | Connecticut | CT | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 3565287 | 627 | 17 | 585.394736842719 | 41.6052631572813 | 610 | 0.476819958673734 | 1.16695410936851 | 0.0710721510440564 | weekly | |||||||||
3434 | 3434 | United States | Delaware | DE | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 973764 | 205 | 23 | 173.482456144184 | 31.5175438558163 | 182 | 2.36196860841025 | 3.23667170441877 | 0.181675683849102 | weekly | |||||||||
3586 | 3586 | United States | District of Columbia | DC | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 705749 | 158 | 6 | 102.615288221007 | 55.3847117789929 | 152 | 0.85016060950848 | 7.84765005391335 | 0.539731581318648 | weekly | |||||||||
3738 | 3738 | United States | Florida | FL | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 21477737 | 5104 | 794 | 3933.36090225661 | 1170.63909774339 | 4310 | 3.69685130235089 | 5.45047691823113 | 0.297618023576677 | weekly | |||||||||
3890 | 3890 | United States | Georgia | GA | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 10617423 | 2210 | 900 | 1647.37844611582 | 562.621553884175 | 1310 | 8.47663317172161 | 5.29904058531129 | 0.341525382470992 | weekly | |||||||||
4042 | 4042 | United States | Hawaii | HI | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 1415872 | 272 | 37 | 224.130325815422 | 47.8696741845783 | 235 | 2.61323057451521 | 3.38093232895193 | 0.21357963948172 | weekly | |||||||||
4194 | 4194 | United States | Idaho | ID | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 1787065 | 499 | 186 | 271.463659148628 | 227.536340851372 | 313 | 10.4081272925159 | 12.7324042970665 | 0.83818342965308 | weekly | |||||||||
4346 | 4346 | United States | Illinois | IL | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 12671821 | 2332 | 253 | 1974.05263157946 | 357.947368420535 | 2079 | 1.99655598039145 | 2.82475082642452 | 0.181326152451233 | weekly | |||||||||
4498 | 4498 | United States | Indiana | IN | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 6732219 | 1627 | 296 | 1223.19172932495 | 403.808270675054 | 1331 | 4.39676724717363 | 5.99814519811453 | 0.330126717663393 | weekly | |||||||||
4650 | 4650 | United States | Iowa | IA | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 3155070 | 721 | 88 | 610.097744361499 | 110.902255638501 | 633 | 2.78916157169255 | 3.51504897319239 | 0.181777848981505 | weekly | |||||||||
4802 | 4802 | United States | Kansas | KS | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 2913314 | 582 | 60 | 505.92355889799 | 76.0764411020096 | 522 | 2.05951023473611 | 2.6113368178648 | 0.150371414345124 | weekly | |||||||||
4954 | 4954 | United States | Kentucky | KY | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 4467673 | 1290 | 249 | 894.909774437567 | 395.090225562433 | 1041 | 5.57337119346022 | 8.8433111725597 | 0.441486099322962 | weekly | |||||||||
5106 | 5106 | United States | Louisiana | LA | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 4648794 | 1101 | 185 | 811.258145364297 | 289.741854635703 | 916 | 3.97952673316994 | 6.23262408778929 | 0.357151242537718 | weekly | |||||||||
5258 | 5258 | United States | Maine | ME | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 1344212 | 363 | 49 | 288.201754386684 | 74.7982456133163 | 314 | 3.64525833722657 | 5.56446792718086 | 0.259534317452345 | weekly | |||||||||
5410 | 5410 | United States | Maryland | MD | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 6045680 | 1166 | 108 | 932.161654136232 | 233.838345863768 | 1058 | 1.78639954479893 | 3.86785846858861 | 0.250856002095955 | weekly | |||||||||
5562 | 5562 | United States | Massachusetts | MA | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 6949503 | 1191 | 99 | 1109.02130325893 | 81.9786967410701 | 1092 | 1.42456230323233 | 1.17963394995398 | 0.0739198575358024 | weekly | |||||||||
5714 | 5714 | United States | Michigan | MI | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 9986857 | 2161 | 263 | 1843.46365914869 | 317.536340851305 | 1898 | 2.63346115799996 | 3.17954228093288 | 0.172249851129662 | weekly | |||||||||
5866 | 5866 | United States | Minnesota | MN | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 5639632 | 1047 | 125 | 893.909774436887 | 153.090225563113 | 922 | 2.21645667660585 | 2.71454282057966 | 0.171259147109731 | weekly | |||||||||
6018 | 6018 | United States | Mississippi | MS | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 2976149 | 670 | 165 | 593.269423559619 | 76.7305764403811 | 505 | 5.54407726226073 | 2.57818329795925 | 0.129335127335566 | weekly | |||||||||
6170 | 6170 | United States | Missouri | MO | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 6137428 | 1411 | 171 | 1172.25689223139 | 238.74310776861 | 1240 | 2.78618339799669 | 3.88995370322242 | 0.20366108260977 | weekly | |||||||||
6322 | 6322 | United States | Montana | MT | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 1068778 | 346 | 62 | 216.135338346714 | 129.864661653286 | 284 | 5.80101761076669 | 12.1507611172092 | 0.600848813741712 | weekly | |||||||||
6474 | 6474 | United States | Nebraska | NE | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 1934408 | 399 | 15 | 320.390977444709 | 78.6090225552908 | 384 | 0.775431036265359 | 4.06372505465708 | 0.245353421567112 | weekly | |||||||||
6626 | 6626 | United States | Nevada | NV | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 3080156 | 677 | 119 | 494.781954888084 | 182.218045111916 | 558 | 3.8634406828745 | 5.91587066083394 | 0.368279488190172 | weekly | |||||||||
6778 | 6778 | United States | New Hampshire | NH | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 1359711 | 277 | 16 | 244.066416040943 | 32.9335839590569 | 261 | 1.17672064137159 | 2.4221017524354 | 0.134936975325324 | weekly | |||||||||
6930 | 6930 | United States | New Jersey | NJ | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 8882190 | 1594 | 0 | 1348.84335839701 | 245.156641602995 | 1594 | 0.0 | 2.76009229258769 | 0.181753233299339 | weekly | |||||||||
7082 | 7082 | United States | New Mexico | NM | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 2096829 | 470 | 57 | 361.29573934924 | 108.70426065076 | 413 | 2.71839048391643 | 5.18422153884555 | 0.300873353354668 | weekly | |||||||||
7234 | 7234 | United States | New York | NY | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 19453561 | 3423 | 217 | 2889.51629072766 | 533.483709272339 | 3206 | 1.11547700701172 | 2.74234475257429 | 0.184627340909711 | weekly | |||||||||
7386 | 7386 | United States | North Carolina | NC | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 10488084 | 2450 | 499 | 1837.38972431142 | 612.610275688575 | 1951 | 4.75778035339915 | 5.8410122925081 | 0.333413356776094 | weekly | |||||||||
7538 | 7538 | United States | North Dakota | ND | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 762062 | 178 | 24 | 151.67669173024 | 26.3233082697601 | 154 | 3.14935005288284 | 3.45422134547584 | 0.17354880284821 | weekly | |||||||||
7690 | 7690 | United States | Ohio | OH | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 11689100 | 3152 | 546 | 2241.39223057868 | 910.607769421318 | 2606 | 4.67101829909916 | 7.79022995287335 | 0.406268816764042 | weekly | |||||||||
7842 | 7842 | United States | Oklahoma | OK | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 3956971 | 982 | 163 | 728.065162908026 | 253.934837091974 | 819 | 4.11931247411214 | 6.41740455242088 | 0.348780370259321 | weekly | |||||||||
7994 | 7994 | United States | Oregon | OR | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 4217737 | 981 | 167 | 714.4160401012 | 266.5839598988 | 814 | 3.95946926041145 | 6.3205448774734 | 0.373149460447497 | weekly | |||||||||
8146 | 8146 | United States | Pennsylvania | PA | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 12801989 | 3130 | 419 | 2457.09523809639 | 672.904761903611 | 2711 | 3.27292891752992 | 5.25625168013823 | 0.273861896547786 | weekly | |||||||||
8298 | 8298 | United States | Rhode Island | RI | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 1059361 | 220 | 16 | 194.20050125404 | 25.79949874596 | 204 | 1.51034444348999 | 2.43538309848673 | 0.132849805120795 | weekly | |||||||||
8450 | 8450 | United States | South Carolina | SC | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 5148714 | 1379 | 359 | 966.540100251604 | 412.459899748396 | 1020 | 6.97261490927637 | 8.01093049154402 | 0.426738528118002 | weekly | |||||||||
8602 | 8602 | United States | South Dakota | SD | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 884659 | 176 | 34 | 164.746867168652 | 11.2531328313475 | 142 | 3.84328877002325 | 1.27203055994994 | 0.0683055952731872 | weekly | |||||||||
8754 | 8754 | United States | Tennessee | TN | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 6833174 | 2085 | 353 | 1426.70802005105 | 658.291979948952 | 1732 | 5.165974113933 | 9.63376580120676 | 0.461406237784658 | weekly | |||||||||
8906 | 8906 | United States | Texas | TX | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 28995881 | 5505 | 636 | 3911.34335839653 | 1593.65664160347 | 4869 | 2.19341498883928 | 5.49614837225837 | 0.407444833034756 | weekly | |||||||||
9058 | 9058 | United States | Utah | UT | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 3205958 | 489 | 51 | 370.661654136202 | 118.338345863798 | 438 | 1.59078815131078 | 3.69120075384013 | 0.31926244472085 | weekly | |||||||||
9210 | 9210 | United States | Vermont | VT | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 623989 | 132 | 14 | 101.872180452022 | 30.1278195479778 | 118 | 2.24362929474718 | 4.82826132319284 | 0.29574138311653 | weekly | |||||||||
9362 | 9362 | United States | Virginia | VA | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 8535519 | 1854 | 269 | 1312.27944862224 | 541.720551377761 | 1585 | 3.1515365380828 | 6.34666212303858 | 0.412808835760183 | weekly | |||||||||
9514 | 9514 | United States | Washington | WA | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 7614893 | 1431 | 257 | 1064.68421052718 | 366.315789472824 | 1174 | 3.37496534751046 | 4.81051788216623 | 0.344060507191559 | weekly | |||||||||
9666 | 9666 | United States | West Virginia | WV | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 1792147 | 662 | 144 | 439.537593985973 | 222.462406014027 | 518 | 8.03505516009568 | 12.4131784956271 | 0.506128279032092 | weekly | |||||||||
9818 | 9818 | United States | Wisconsin | WI | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 5822434 | 1272 | 119 | 1024.78696741942 | 247.213032580583 | 1153 | 2.04381878781279 | 4.24587092924683 | 0.241233583603338 | weekly | |||||||||
9970 | 9970 | United States | Wyoming | WY | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 578759 | 160 | 45 | 86.7506265672997 | 73.2493734327003 | 115 | 7.77525705863753 | 12.6562823960751 | 0.844367082189021 | weekly | |||||||||
12018 | 12018 | Canada | Canada | 0 | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 38454328 | 6015 | 250 | 5604.17614424422 | 410.82385575578 | 5765 | 0.650121879649022 | 1.06834230923442 | 0.0733067350457421 | weekly | |||||||||
17069 | 17069 | South Africa | South Africa | 0 | 2021-10-03 | 2021-10-09 | 7 | 2021 | 40 | 59893884 | 11159 | 539 | 10383.1012552301 | 775.898744769944 | 10620 | 0.899924940583249 | 1.29545571759872 | 0.0747270710067545 | 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);