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-09-19 sorted by covid_deaths_per_100k
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6928 | 6928 | United States | New Jersey | NJ | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 8882190 | 1549 | 0 | 1342.84335839697 | 206.156641603028 | 1549 | 0.0 | 2.32101139024303 | 0.153522479233265 | weekly | |||||||||
9968 | 9968 | United States | Wyoming | WY | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 578759 | 134 | 0 | 92.0839599006041 | 41.9160400993959 | 134 | 0.0 | 7.24239970339916 | 0.455193718261469 | weekly | |||||||||
12016 | 12016 | Canada | Canada | 0 | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 38454328 | 5975 | 251 | 5378.17614424422 | 596.82385575578 | 5724 | 0.652722367167618 | 1.5520329876933 | 0.110971422234749 | weekly | |||||||||
3584 | 3584 | United States | District of Columbia | DC | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 705749 | 128 | 5 | 113.61528822098 | 14.3847117790196 | 123 | 0.7084671745904 | 2.03821922227585 | 0.126608945013117 | weekly | |||||||||
8296 | 8296 | United States | Rhode Island | RI | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 1059361 | 216 | 11 | 197.200501254011 | 18.7994987459894 | 205 | 1.03836180489937 | 1.77460740446264 | 0.0953319014223708 | weekly | |||||||||
3280 | 3280 | United States | Connecticut | CT | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 3565287 | 674 | 38 | 577.728070176023 | 96.2719298239771 | 636 | 1.06583284880011 | 2.70025750588878 | 0.166638830262557 | weekly | |||||||||
6776 | 6776 | United States | New Hampshire | NH | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 1359711 | 263 | 15 | 230.399749374247 | 32.6002506257528 | 248 | 1.10317560128586 | 2.39758673907564 | 0.141494297256369 | weekly | |||||||||
9208 | 9208 | United States | Vermont | VT | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 623989 | 149 | 8 | 96.2055137853232 | 52.7944862146768 | 141 | 1.28207388271268 | 8.46080399088395 | 0.548767779905885 | weekly | |||||||||
5560 | 5560 | United States | Massachusetts | MA | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 6949503 | 1161 | 96 | 1042.0213032589 | 118.978696741102 | 1065 | 1.38139374858893 | 1.71204612388975 | 0.114180675931479 | weekly | |||||||||
7536 | 7536 | United States | North Dakota | ND | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 762062 | 167 | 11 | 142.010025063545 | 24.9899749364549 | 156 | 1.4434521075713 | 3.27925745365271 | 0.175973315442151 | weekly | |||||||||
17067 | 17067 | South Africa | South Africa | 0 | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 59893884 | 11801 | 885 | 10073.1012552301 | 1727.89874476995 | 10916 | 1.47761330689457 | 2.88493353473278 | 0.171535925331114 | weekly | |||||||||
5864 | 5864 | United States | Minnesota | MN | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 5639632 | 988 | 93 | 872.576441103532 | 115.423558896468 | 895 | 1.64904376739475 | 2.04665054202949 | 0.132279022741542 | weekly | |||||||||
7232 | 7232 | United States | New York | NY | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 19453561 | 3225 | 330 | 2798.84962406096 | 426.150375939037 | 2895 | 1.69634752218373 | 2.19060343727833 | 0.152259118273285 | weekly | |||||||||
3128 | 3128 | United States | Colorado | CO | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 5758736 | 967 | 98 | 770.46616541456 | 196.53383458544 | 869 | 1.70176233117823 | 3.41279465815832 | 0.255084315713841 | weekly | |||||||||
5408 | 5408 | United States | Maryland | MD | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 6045680 | 1109 | 104 | 911.161654136204 | 197.838345863796 | 1005 | 1.72023659869527 | 3.27239195365609 | 0.217127602951366 | weekly | |||||||||
8600 | 8600 | United States | South Dakota | SD | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 884659 | 215 | 16 | 161.746867168621 | 53.2531328313786 | 199 | 1.80860648001094 | 6.01962256998217 | 0.329237491665678 | weekly | |||||||||
9816 | 9816 | United States | Wisconsin | WI | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 5822434 | 1180 | 106 | 1012.12030075273 | 167.879699247267 | 1074 | 1.82054446645509 | 2.88332507070526 | 0.165869313284608 | weekly | |||||||||
2976 | 2976 | United States | California | CA | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 39512223 | 6370 | 723 | 4801.57142857187 | 1568.42857142813 | 5647 | 1.82981352377972 | 3.96947691712545 | 0.326649013715627 | weekly | |||||||||
6472 | 6472 | United States | Nebraska | NE | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 1934408 | 385 | 36 | 313.390977444678 | 71.6090225553223 | 349 | 1.86103448703686 | 3.70185723773487 | 0.228497396891279 | weekly | |||||||||
2520 | 2520 | United States | Alaska | AK | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 731545 | 153 | 14 | 96.9461152920478 | 56.0538847079522 | 139 | 1.91375786862052 | 7.66239735189937 | 0.57819629532438 | weekly | |||||||||
5712 | 5712 | United States | Michigan | MI | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 9986857 | 2073 | 217 | 1775.46365914867 | 297.536340851329 | 1856 | 2.17285578435738 | 2.97927907500156 | 0.167582332264686 | weekly | |||||||||
4344 | 4344 | United States | Illinois | IL | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 12671821 | 2322 | 276 | 1960.71929824609 | 361.280701753909 | 2046 | 2.17806106951795 | 2.85105591180549 | 0.184259267543847 | weekly | |||||||||
8144 | 8144 | United States | Pennsylvania | PA | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 12801989 | 2946 | 283 | 2397.42857142966 | 548.571428570339 | 2663 | 2.21059399441759 | 4.28504842935218 | 0.228816589202159 | weekly | |||||||||
5256 | 5256 | United States | Maine | ME | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 1344212 | 344 | 31 | 291.53508771999 | 52.4649122800097 | 313 | 2.30618384600048 | 3.90302365103196 | 0.179960884606797 | weekly | |||||||||
9056 | 9056 | United States | Utah | UT | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 3205958 | 506 | 82 | 373.661654136175 | 132.338345863825 | 424 | 2.55773781191145 | 4.12788769733804 | 0.354166247456571 | weekly | |||||||||
4648 | 4648 | United States | Iowa | IA | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 3155070 | 728 | 82 | 550.431077694804 | 177.568922305196 | 646 | 2.59899146453169 | 5.62805016386945 | 0.322599739551138 | weekly | |||||||||
7992 | 7992 | United States | Oregon | OR | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 4217737 | 1018 | 113 | 673.749373434506 | 344.250626565494 | 905 | 2.67916183488918 | 8.16197469319433 | 0.510947601792401 | weekly | |||||||||
3432 | 3432 | United States | Delaware | DE | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 973764 | 241 | 29 | 166.482456144156 | 74.5175438558441 | 212 | 2.97813433234336 | 7.65252605927556 | 0.447599978890988 | weekly | |||||||||
7688 | 7688 | United States | Ohio | OH | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 11689100 | 3130 | 349 | 2282.72556391197 | 847.274436088033 | 2781 | 2.98568752085276 | 7.24841464345444 | 0.371167892226184 | weekly | |||||||||
9360 | 9360 | United States | Virginia | VA | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 8535519 | 1736 | 269 | 1334.94611528889 | 401.053884711114 | 1467 | 3.1515365380828 | 4.69864673385548 | 0.300427021074423 | weekly | |||||||||
7080 | 7080 | United States | New Mexico | NM | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 2096829 | 463 | 74 | 366.295739349214 | 96.7042606507857 | 389 | 3.52913852297922 | 4.6119288053907 | 0.264005966388244 | weekly | |||||||||
4040 | 4040 | United States | Hawaii | HI | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 1415872 | 317 | 53 | 221.463659148728 | 95.5363408512717 | 264 | 3.74327622835963 | 6.74752667269864 | 0.431386084825377 | weekly | |||||||||
9512 | 9512 | United States | Washington | WA | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 7614893 | 1499 | 293 | 1042.68421052715 | 456.315789472852 | 1206 | 3.84772313937963 | 5.99241236183952 | 0.437635656957109 | weekly | |||||||||
4800 | 4800 | United States | Kansas | KS | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 2913314 | 653 | 115 | 503.256892231295 | 149.743107768705 | 538 | 3.94739461657755 | 5.13995771718066 | 0.297548051661622 | weekly | |||||||||
4496 | 4496 | United States | Indiana | IN | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 6732219 | 1731 | 294 | 1199.85839599159 | 531.141604008415 | 1437 | 4.3670593603684 | 7.8895473247144 | 0.442670239907326 | weekly | |||||||||
6168 | 6168 | United States | Missouri | MO | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 6137428 | 1589 | 269 | 1191.59022556469 | 397.409774435307 | 1320 | 4.38294347404157 | 6.47518430253368 | 0.333512113400372 | weekly | |||||||||
7384 | 7384 | United States | North Carolina | NC | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 10488084 | 2549 | 493 | 1824.05639097808 | 724.943609021924 | 2056 | 4.70057257359876 | 6.91206905877111 | 0.397434866930404 | weekly | |||||||||
2672 | 2672 | United States | Arizona | AZ | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 7278717 | 1577 | 358 | 1131.54887219075 | 445.451127809246 | 1219 | 4.91844922669751 | 6.11991272375676 | 0.393664947892903 | weekly | |||||||||
2824 | 2824 | United States | Arkansas | AR | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 3017825 | 796 | 149 | 598.43233082863 | 197.56766917137 | 647 | 4.93733069346301 | 6.54669071836073 | 0.330142037776943 | weekly | |||||||||
8904 | 8904 | United States | Texas | TX | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 28995881 | 6213 | 1548 | 3741.01002506321 | 2471.98997493679 | 4665 | 5.33868931245786 | 8.52531425045092 | 0.660781435595063 | weekly | |||||||||
4952 | 4952 | United States | Kentucky | KY | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 4467673 | 1452 | 241 | 884.909774437541 | 567.090225562459 | 1211 | 5.39430705873057 | 12.6931900692477 | 0.640845249927213 | weekly | |||||||||
6624 | 6624 | United States | Nevada | NV | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 3080156 | 703 | 170 | 476.448621554725 | 226.551378445275 | 533 | 5.51920097553501 | 7.35519169955273 | 0.475500123614596 | weekly | |||||||||
3736 | 3736 | United States | Florida | FL | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 21477737 | 5846 | 1240 | 3926.02756892327 | 1919.97243107673 | 4606 | 5.77342016991827 | 8.93936093489147 | 0.489036920238258 | weekly | |||||||||
6320 | 6320 | United States | Montana | MT | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 1068778 | 311 | 68 | 184.135338346686 | 126.864661653314 | 243 | 6.36240641180863 | 11.8700667166909 | 0.688975091866704 | weekly | |||||||||
7840 | 7840 | United States | Oklahoma | OK | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 3956971 | 1105 | 262 | 712.065162907996 | 392.934837092004 | 843 | 6.62122618538271 | 9.93019249046819 | 0.551824267721933 | weekly | |||||||||
5104 | 5104 | United States | Louisiana | LA | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 4648794 | 1207 | 323 | 864.5914786976 | 342.4085213024 | 884 | 6.94803856656156 | 7.36553440101668 | 0.396035040523642 | weekly | |||||||||
8752 | 8752 | United States | Tennessee | TN | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 6833174 | 2376 | 484 | 1402.3746867177 | 973.625313282299 | 1892 | 7.08309198624241 | 14.2485075498194 | 0.694269029884658 | weekly | |||||||||
6016 | 6016 | United States | Mississippi | MS | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 2976149 | 879 | 211 | 554.602756892923 | 324.397243107077 | 668 | 7.08969880204251 | 10.899899269394 | 0.584918194284612 | weekly | |||||||||
3888 | 3888 | United States | Georgia | GA | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 10617423 | 2715 | 901 | 1608.71177944914 | 1106.28822055086 | 1814 | 8.48605165302353 | 10.4195549197848 | 0.687685783546436 | weekly | |||||||||
9664 | 9664 | United States | West Virginia | WV | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 1792147 | 685 | 153 | 409.537593985943 | 275.462406014057 | 532 | 8.53724610760166 | 15.3705251864974 | 0.672618118725169 | weekly | |||||||||
4192 | 4192 | United States | Idaho | ID | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 1787065 | 515 | 153 | 287.130325815269 | 227.869674184731 | 362 | 8.5615240631986 | 12.7510568549399 | 0.793610614057312 | weekly | |||||||||
8448 | 8448 | United States | South Carolina | SC | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 5148714 | 1480 | 466 | 950.206766918257 | 529.793233081743 | 1014 | 9.05080375410248 | 10.2898167014471 | 0.557555735789998 | weekly | |||||||||
2368 | 2368 | United States | Alabama | AL | 2021-09-19 | 2021-09-25 | 7 | 2021 | 38 | 4903185 | 1450 | 873 | 971.704260638883 | 478.295739361117 | 577 | 17.8047534408757 | 9.75479691998399 | 0.492223569182092 | 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);