economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
51 rows where cadence = "weekly", country = "United States" and "start_date" is on date 2021-07-25 sorted by end_date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: start_date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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);