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 2021-11-21 sorted by country
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region_code, covid_deaths, covid_deaths_per_100k, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12025 | 12025 | Canada | Canada | 0 | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 38454328 | 5950 | 137 | 5792.17614424422 | 157.823855755781 | 5813 | 0.356266790047664 | 0.410418967029618 | 0.0272477652311407 | weekly | |||||||||
17076 | 17076 | South Africa | South Africa | 0 | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 59893884 | 10173 | 219 | 9297.30125523006 | 875.698744769945 | 9954 | 0.365646682723064 | 1.46208374926887 | 0.0941884876837058 | weekly | |||||||||
2377 | 2377 | United States | Alabama | AL | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 4903185 | 1188 | 52 | 1032.03759397226 | 155.962406027742 | 1136 | 1.06053514195365 | 3.18083870030893 | 0.151120857358937 | weekly | |||||||||
2529 | 2529 | United States | Alaska | AK | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 731545 | 154 | 12 | 94.6127819587192 | 59.3872180412808 | 142 | 1.64036388738902 | 8.11805398728456 | 0.627687050436718 | weekly | |||||||||
2681 | 2681 | United States | Arizona | AZ | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 7278717 | 1814 | 291 | 1221.88220552409 | 592.117794475907 | 1523 | 3.99795733231557 | 8.13491985573704 | 0.484594825752401 | weekly | |||||||||
2833 | 2833 | United States | Arkansas | AR | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 3017825 | 755 | 44 | 637.432330828636 | 117.567669171364 | 711 | 1.45800369471391 | 3.89577490978979 | 0.184439451037149 | weekly | |||||||||
2985 | 2985 | United States | California | CA | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 39512223 | 6013 | 436 | 5160.9047619052 | 852.095238094799 | 5577 | 1.10345601157394 | 2.15653580942484 | 0.16510578617619 | weekly | |||||||||
3137 | 3137 | United States | Colorado | CO | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 5758736 | 1182 | 182 | 799.799498747896 | 382.200501252104 | 1000 | 3.16041575790243 | 6.63688179579865 | 0.47787039358045 | weekly | |||||||||
3289 | 3289 | United States | Connecticut | CT | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 3565287 | 712 | 15 | 616.061403509361 | 95.9385964906386 | 697 | 0.420723492947412 | 2.69090809493425 | 0.155728951601463 | weekly | |||||||||
3441 | 3441 | United States | Delaware | DE | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 973764 | 234 | 19 | 184.149122810829 | 49.8508771891715 | 215 | 1.95119145912151 | 5.11940030532773 | 0.270709284020766 | weekly | |||||||||
3593 | 3593 | United States | District of Columbia | DC | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 705749 | 133 | 0 | 115.94862155432 | 17.0513784456804 | 133 | 0.0 | 2.41606838205656 | 0.147059777141828 | weekly | |||||||||
3745 | 3745 | United States | Florida | FL | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 21477737 | 4344 | 391 | 4047.36090225659 | 296.639097743407 | 3953 | 1.82048974712746 | 1.38114689524044 | 0.0732919808505381 | weekly | |||||||||
3897 | 3897 | United States | Georgia | GA | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 10617423 | 1949 | 196 | 1773.3784461158 | 175.621553884196 | 1753 | 1.84602233517493 | 1.65408832147119 | 0.0990321915036561 | weekly | |||||||||
4049 | 4049 | United States | Hawaii | HI | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 1415872 | 227 | 17 | 223.130325815401 | 3.86967418459906 | 210 | 1.20067350720969 | 0.273306780881256 | 0.0173426636225167 | weekly | |||||||||
4201 | 4201 | United States | Idaho | ID | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 1787065 | 381 | 46 | 249.79699248194 | 131.20300751806 | 335 | 2.57405298632115 | 7.34181507209086 | 0.525238539561466 | weekly | |||||||||
4353 | 4353 | United States | Illinois | IL | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 12671821 | 2525 | 101 | 2022.05263157944 | 502.947368420555 | 2424 | 0.797044087033742 | 3.96902204048302 | 0.248731096592525 | weekly | |||||||||
4505 | 4505 | United States | Indiana | IN | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 6732219 | 1697 | 139 | 1294.85839599159 | 402.14160400841 | 1558 | 2.06469813296329 | 5.97338862577717 | 0.31056801674476 | weekly | |||||||||
4657 | 4657 | United States | Iowa | IA | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 3155070 | 747 | 86 | 620.097744361477 | 126.902255638523 | 661 | 2.72577153597226 | 4.02216925895535 | 0.204648794149696 | weekly | |||||||||
4809 | 4809 | United States | Kansas | KS | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 2913314 | 648 | 39 | 535.256892231302 | 112.743107768698 | 609 | 1.33868165257847 | 3.86992640575984 | 0.210633640416494 | weekly | |||||||||
4961 | 4961 | United States | Kentucky | KY | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 4467673 | 1180 | 189 | 958.576441104212 | 221.423558895788 | 991 | 4.23039018298788 | 4.95612724780412 | 0.230992072620441 | weekly | |||||||||
5113 | 5113 | United States | Louisiana | LA | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 4648794 | 988 | 28 | 896.258145364274 | 91.7418546357261 | 960 | 0.602306748804098 | 1.97345493553223 | 0.102360971680139 | weekly | |||||||||
5265 | 5265 | United States | Maine | ME | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 1344212 | 398 | 32 | 305.535087719996 | 92.4649122800043 | 366 | 2.38057687329082 | 6.87874474264508 | 0.302632712236124 | weekly | |||||||||
5417 | 5417 | United States | Maryland | MD | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 6045680 | 1084 | 53 | 988.16165413621 | 95.8383458637898 | 1031 | 0.876659035873549 | 1.58523682801256 | 0.0969865056619361 | weekly | |||||||||
5569 | 5569 | United States | Massachusetts | MA | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 6949503 | 1270 | 83 | 1159.02130325891 | 110.978696741093 | 1187 | 1.19433001180084 | 1.59692997817387 | 0.0957520767125206 | weekly | |||||||||
5721 | 5721 | United States | Michigan | MI | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 9986857 | 2849 | 403 | 1950.79699248201 | 898.20300751799 | 2446 | 4.03530359952085 | 8.99385069314591 | 0.460428743215972 | weekly | |||||||||
5873 | 5873 | United States | Minnesota | MN | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 5639632 | 1238 | 183 | 907.576441103534 | 330.423558896466 | 1055 | 3.24489257455096 | 5.85895602579151 | 0.364072428427847 | weekly | |||||||||
6025 | 6025 | United States | Mississippi | MS | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 2976149 | 722 | 33 | 638.269423559597 | 83.7305764404032 | 689 | 1.10881545245215 | 2.81338657575287 | 0.131183749917773 | weekly | |||||||||
6177 | 6177 | United States | Missouri | MO | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 6137428 | 1486 | 2990 | 1249.25689223137 | 236.743107768632 | -1504 | 48.7174757895327 | 3.85736676289533 | 0.189507145600591 | weekly | |||||||||
6329 | 6329 | United States | Montana | MT | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 1068778 | 266 | 84 | 200.135338346692 | 65.8646616533078 | 182 | 7.85944321458713 | 6.16261390609723 | 0.329100608605219 | weekly | |||||||||
6481 | 6481 | United States | Nebraska | NE | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 1934408 | 413 | 38 | 326.724310778021 | 86.2756892219788 | 375 | 1.96442529187224 | 4.4600564731938 | 0.264062655810743 | weekly | |||||||||
6633 | 6633 | United States | Nevada | NV | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 3080156 | 617 | 54 | 511.781954888063 | 105.218045111937 | 563 | 1.75315795693465 | 3.41599727779818 | 0.205591549500706 | weekly | |||||||||
6785 | 6785 | United States | New Hampshire | NH | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 1359711 | 295 | 21 | 243.733082707591 | 51.2669172924093 | 274 | 1.54444584180021 | 3.77042748734175 | 0.210340413057159 | weekly | |||||||||
6937 | 6937 | United States | New Jersey | NJ | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 8882190 | 1609 | 0 | 1478.84335839698 | 130.156641603015 | 1609 | 0.0 | 1.46536655490386 | 0.0880124597807983 | weekly | |||||||||
7089 | 7089 | United States | New Mexico | NM | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 2096829 | 528 | 47 | 358.629072682552 | 169.370927317448 | 481 | 2.24147987270302 | 8.07747924687459 | 0.47227327681649 | weekly | |||||||||
7241 | 7241 | United States | New York | NY | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 19453561 | 3591 | 189 | 3034.84962406097 | 556.150375939028 | 3402 | 0.971544489977953 | 2.85886155207794 | 0.183254673157359 | weekly | |||||||||
7393 | 7393 | United States | North Carolina | NC | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 10488084 | 2261 | 79 | 1879.05639097807 | 381.943609021931 | 2182 | 0.75323576737181 | 3.64169098018218 | 0.203263516122113 | weekly | |||||||||
7545 | 7545 | United States | North Dakota | ND | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 762062 | 181 | 22 | 157.343358396883 | 23.6566416031166 | 159 | 2.8869042151426 | 3.10429356182524 | 0.15035043006674 | weekly | |||||||||
7697 | 7697 | United States | Ohio | OH | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 11689100 | 3297 | 420 | 2366.72556391199 | 930.274436088009 | 2877 | 3.59309099930705 | 7.95847786474587 | 0.39306392353761 | weekly | |||||||||
7849 | 7849 | United States | Oklahoma | OK | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 3956971 | 864 | 18 | 771.065162908004 | 92.934837091996 | 846 | 0.454893402049194 | 2.34863578964809 | 0.120527864002441 | weekly | |||||||||
8001 | 8001 | United States | Oregon | OR | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 4217737 | 875 | 202 | 706.082706767845 | 168.917293232155 | 673 | 4.78929814732403 | 4.00492712637499 | 0.239231596543963 | weekly | |||||||||
8153 | 8153 | United States | Pennsylvania | PA | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 12801989 | 3446 | 340 | 2523.4285714297 | 922.571428570301 | 3106 | 2.65583730778085 | 7.20646946791081 | 0.365602355071853 | weekly | |||||||||
8305 | 8305 | United States | Rhode Island | RI | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 1059361 | 248 | 9 | 207.200501254019 | 40.7994987459808 | 239 | 0.84956874946312 | 3.85133101426056 | 0.196908301375016 | weekly | |||||||||
8457 | 8457 | United States | South Carolina | SC | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 5148714 | 1191 | 90 | 993.206766918252 | 197.793233081748 | 1101 | 1.74800930873224 | 3.84160458479045 | 0.199146078812437 | weekly | |||||||||
8609 | 8609 | United States | South Dakota | SD | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 884659 | 217 | 17 | 181.080200501961 | 35.9197994980394 | 200 | 1.92164438501163 | 4.06029888330299 | 0.198364036479242 | weekly | |||||||||
8761 | 8761 | United States | Tennessee | TN | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 6833174 | 1751 | 138 | 1536.04135338437 | 214.958646615635 | 1613 | 2.01955928533358 | 3.14580964300974 | 0.13994326789576 | weekly | |||||||||
8913 | 8913 | United States | Texas | TX | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 28995881 | 4718 | 306 | 4161.67669172985 | 556.32330827015 | 4412 | 1.05532230595097 | 1.91862874685598 | 0.13367768557699 | weekly | |||||||||
9065 | 9065 | United States | Utah | UT | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 3205958 | 474 | 59 | 408.994987469514 | 65.0050125304862 | 415 | 1.84032354759482 | 2.02763144528051 | 0.158938408836445 | weekly | |||||||||
9217 | 9217 | United States | Vermont | VT | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 623989 | 139 | 2 | 98.8721804519987 | 40.1278195480013 | 137 | 0.320518470678169 | 6.43085367658746 | 0.405855513295602 | weekly | |||||||||
9369 | 9369 | United States | Virginia | VA | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 8535519 | 1631 | 143 | 1374.27944862222 | 256.720551377782 | 1488 | 1.67535213734513 | 3.00767359756076 | 0.186803747691314 | weekly | |||||||||
9521 | 9521 | United States | Washington | WA | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 7614893 | 1336 | 98 | 1104.01754386049 | 231.982456139514 | 1238 | 1.28695176675496 | 3.04643093658064 | 0.210125697213403 | weekly | |||||||||
9673 | 9673 | United States | West Virginia | WV | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 1792147 | 575 | 91 | 444.53759398595 | 130.46240601405 | 484 | 5.07770846922713 | 7.27967103223396 | 0.293478904324509 | weekly | |||||||||
9825 | 9825 | United States | Wisconsin | WI | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 5822434 | 1394 | 123 | 1101.12030075273 | 292.879699247267 | 1271 | 2.11251857899978 | 5.03019354529852 | 0.265983379878704 | weekly | |||||||||
9977 | 9977 | United States | Wyoming | WY | 2021-11-21 | 2021-11-27 | 7 | 2021 | 47 | 578759 | 134 | 0 | 97.0839599006097 | 36.9160400993903 | 134 | 0.0 | 6.37848225243846 | 0.380248602726788 | 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);