economist_excess_deaths
Data license: CC BY 4.0 · Data source: The Economist · About: simonw/covid-19-datasette
53 rows where cadence = "weekly" and "start_date" is on date 2021-01-24 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2334 | 2334 | United States | Alabama | AL | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 4903185 | 1637 | 909 | 1118.61466163568 | 518.385338364319 | 728 | 18.5389700776128 | 10.5724205463249 | 0.463417257204832 | weekly | |||||||||
2486 | 2486 | United States | Alaska | AK | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 731545 | 92 | 8 | 92.3439849659093 | -0.343984965909272 | 84 | 1.09357592492601 | -0.0470217096568593 | -0.00372503922195111 | weekly | |||||||||
2638 | 2638 | United States | Arizona | AZ | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 7278717 | 2083 | 927 | 1330.12406015974 | 752.875939840265 | 1156 | 12.7357609864486 | 10.3435253745992 | 0.566019337887815 | weekly | |||||||||
2790 | 2790 | United States | Arkansas | AR | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 3017825 | 873 | 275 | 653.943609024187 | 219.056390975813 | 598 | 9.11252309196193 | 7.25875062257796 | 0.334977493399911 | weekly | |||||||||
2942 | 2942 | United States | California | CA | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 39512223 | 9597 | 3311 | 5730.39285714357 | 3866.60714285643 | 6286 | 8.37968544569107 | 9.78585067931113 | 0.674754286355128 | weekly | |||||||||
3094 | 3094 | United States | Colorado | CO | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 5758736 | 932 | 134 | 835.721804512518 | 96.2781954874821 | 798 | 2.32689951406003 | 1.67186333055521 | 0.115203641890906 | weekly | |||||||||
3246 | 3246 | United States | Connecticut | CT | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 3565287 | 827 | 227 | 678.578947369273 | 148.421052630727 | 600 | 6.3669488599375 | 4.16294824598207 | 0.218723338244029 | weekly | |||||||||
3398 | 3398 | United States | Delaware | DE | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 973764 | 265 | 45 | 196.513157898295 | 68.4868421017049 | 220 | 4.62124292949832 | 7.03320744058159 | 0.348510210889543 | weekly | |||||||||
3550 | 3550 | United States | District of Columbia | DC | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 705749 | 181 | 39 | 123.234962406614 | 57.765037593386 | 142 | 5.52604396180512 | 8.18492659477888 | 0.468739036920303 | weekly | |||||||||
3702 | 3702 | United States | Florida | FL | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 21477737 | 5491 | 1196 | 4401.5507518809 | 1089.4492481191 | 4295 | 5.56855687356634 | 5.07245827676866 | 0.247514866812238 | weekly | |||||||||
3854 | 3854 | United States | Georgia | GA | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 10617423 | 2768 | 770 | 1844.78759398566 | 923.212406014338 | 1998 | 7.25223060247294 | 8.69525878374006 | 0.500443741612409 | weekly | |||||||||
4006 | 4006 | United States | Hawaii | HI | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 1415872 | 228 | 73 | 235.830827068728 | -7.83082706872818 | 155 | 5.15583329566515 | -0.553074505938968 | -0.0332052733141882 | weekly | |||||||||
4158 | 4158 | United States | Idaho | ID | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 1787065 | 284 | 57 | 282.330827068617 | 1.66917293138266 | 227 | 3.18958739609359 | 0.0934030341024339 | 0.00591211717371909 | weekly | |||||||||
4310 | 4310 | United States | Illinois | IL | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 12671821 | 2585 | 569 | 2206.71052631647 | 378.289473683531 | 2016 | 4.49027807447722 | 2.9852810711541 | 0.171426867807164 | weekly | |||||||||
4462 | 4462 | United States | Indiana | IN | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 6732219 | 1624 | 275 | 1413.65977443776 | 210.340225562237 | 1349 | 4.08483443571874 | 3.12438180579445 | 0.148791264606714 | weekly | |||||||||
4614 | 4614 | United States | Iowa | IA | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 3155070 | 645 | 165 | 642.998120301553 | 2.0018796984466 | 480 | 5.22967794692352 | 0.0634496127961218 | 0.00311335233376386 | weekly | |||||||||
4766 | 4766 | United States | Kansas | KS | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 2913314 | 691 | 181 | 580.325187970853 | 110.674812029147 | 510 | 6.21285587478727 | 3.79893180169205 | 0.190711715299018 | weekly | |||||||||
4918 | 4918 | United States | Kentucky | KY | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 4467673 | 1261 | 328 | 997.924812031618 | 263.075187968382 | 933 | 7.34162952391547 | 5.88841636279964 | 0.263622253697452 | weekly | |||||||||
5070 | 5070 | United States | Louisiana | LA | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 4648794 | 1253 | 318 | 955.020676692796 | 297.979323307204 | 935 | 6.8404837899894 | 6.40981990828597 | 0.312013478429698 | weekly | |||||||||
5222 | 5222 | United States | Maine | ME | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 1344212 | 356 | 36 | 315.72368421143 | 40.2763157885701 | 320 | 2.67814898245217 | 2.99627705961337 | 0.127568243380811 | weekly | |||||||||
5374 | 5374 | United States | Maryland | MD | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 6045680 | 1321 | 219 | 1039.71804511384 | 281.281954886159 | 1102 | 3.62242129917561 | 4.65261070526656 | 0.270536763508188 | weekly | |||||||||
5526 | 5526 | United States | Massachusetts | MA | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 6949503 | 1571 | 467 | 1252.07330827162 | 318.926691728378 | 1104 | 6.71990500615656 | 4.58920143970552 | 0.254718864799241 | weekly | |||||||||
5678 | 5678 | United States | Michigan | MI | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 9986857 | 2191 | 347 | 2040.5808270687 | 150.419172931299 | 1844 | 3.47456662291249 | 1.50617129023975 | 0.073713900932499 | weekly | |||||||||
5830 | 5830 | United States | Minnesota | MN | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 5639632 | 924 | 124 | 947.924812031055 | -23.9248120310554 | 800 | 2.198725023193 | -0.424226474902181 | -0.0252391452649006 | weekly | |||||||||
5982 | 5982 | United States | Mississippi | MS | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 2976149 | 922 | 267 | 645.780075188866 | 276.219924811134 | 655 | 8.97132502438554 | 9.28111881532592 | 0.427730639924669 | weekly | |||||||||
6134 | 6134 | United States | Missouri | MO | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 6137428 | 1619 | 207 | 1385.5751879709 | 233.424812029098 | 1412 | 3.37274832389072 | 3.80330021026883 | 0.168467806045903 | weekly | |||||||||
6286 | 6286 | United States | Montana | MT | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 1068778 | 199 | 91 | 216.362781955903 | -17.3627819559034 | 108 | 8.51439681580272 | -1.62454522416287 | -0.0802484687936861 | weekly | |||||||||
6438 | 6438 | United States | Nebraska | NE | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 1934408 | 378 | 36 | 359.492481204263 | 18.5075187957373 | 342 | 1.86103448703686 | 0.956753631898613 | 0.0514823529375052 | weekly | |||||||||
6590 | 6590 | United States | Nevada | NV | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 3080156 | 782 | 244 | 564.484962407053 | 217.515037592947 | 538 | 7.9216766942973 | 7.06181886868544 | 0.385333626365223 | weekly | |||||||||
6742 | 6742 | United States | New Hampshire | NH | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 1359711 | 272 | 71 | 252.860902256648 | 19.1390977433517 | 201 | 5.22169784608641 | 1.40758571073939 | 0.0756902216694852 | weekly | |||||||||
6894 | 6894 | United States | New Jersey | NJ | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 8882190 | 2007 | 521 | 1578.06390977561 | 428.936090224386 | 1486 | 5.86567051594258 | 4.82917039856597 | 0.271811608875446 | weekly | |||||||||
7046 | 7046 | United States | New Mexico | NM | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 2096829 | 485 | 150 | 397.385338346899 | 87.6146616531012 | 335 | 7.15365916820113 | 4.17843618402365 | 0.220477841526749 | weekly | |||||||||
7198 | 7198 | United States | New York | NY | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 19453561 | 4443 | 1311 | 3335.79135338446 | 1107.20864661554 | 3132 | 6.73912606540263 | 5.6915474067475 | 0.331917835775964 | weekly | |||||||||
7350 | 7350 | United States | North Carolina | NC | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 10488084 | 2931 | 702 | 2021.79699248201 | 909.203007517993 | 2229 | 6.6933102366457 | 8.66891424132371 | 0.449700445147974 | weekly | |||||||||
7502 | 7502 | United States | North Dakota | ND | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 762062 | 147 | 11 | 154.563909775504 | -7.56390977550424 | 136 | 1.4434521075713 | -0.992558318811887 | -0.0489371017237492 | weekly | |||||||||
7654 | 7654 | United States | Ohio | OH | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 11689100 | 3126 | 441 | 2606.18796992708 | 519.812030072922 | 2685 | 3.7727455492724 | 4.446980777587 | 0.199453008022083 | weekly | |||||||||
7806 | 7806 | United States | Oklahoma | OK | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 3956971 | 1171 | 365 | 836.91541353477 | 334.08458646523 | 806 | 9.22422731933087 | 8.44293745052036 | 0.39918560593143 | weekly | |||||||||
7958 | 7958 | United States | Oregon | OR | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 4217737 | 836 | 73 | 751.152255640196 | 84.8477443598038 | 763 | 1.73078596413195 | 2.0116888359754 | 0.112956785688528 | weekly | |||||||||
8110 | 8110 | United States | Pennsylvania | PA | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 12801989 | 3593 | 1076 | 2867.35714285842 | 725.642857141579 | 2517 | 8.40494395050644 | 5.66820403565085 | 0.253070273770709 | weekly | |||||||||
8262 | 8262 | United States | Rhode Island | RI | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 1059361 | 264 | 73 | 218.028195489784 | 45.9718045102162 | 191 | 6.89094652342308 | 4.33957871870082 | 0.210852566141476 | weekly | |||||||||
8414 | 8414 | United States | South Carolina | SC | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 5148714 | 1582 | 535 | 1080.7556390989 | 501.2443609011 | 1047 | 10.3909442241305 | 9.73533120894073 | 0.463790650510991 | weekly | |||||||||
8566 | 8566 | United States | South Dakota | SD | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 884659 | 204 | 79 | 175.511278196391 | 28.4887218036095 | 125 | 8.92999449505403 | 3.22030542882732 | 0.162318468057259 | weekly | |||||||||
8718 | 8718 | United States | Tennessee | TN | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 6833174 | 2083 | 695 | 1566.70112782064 | 516.298872179357 | 1388 | 10.1709688645423 | 7.55576942983387 | 0.329545222768527 | weekly | |||||||||
8870 | 8870 | United States | Texas | TX | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 28995881 | 6641 | 2115 | 4351.06390977518 | 2289.93609022482 | 4526 | 7.29413946760231 | 7.89745305626279 | 0.526293370474337 | weekly | |||||||||
9022 | 9022 | United States | Utah | UT | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 3205958 | 502 | 81 | 413.968045113811 | 88.0319548861891 | 421 | 2.52654588737594 | 2.74588609352303 | 0.212653986038914 | weekly | |||||||||
9174 | 9174 | United States | Vermont | VT | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 623989 | 114 | 3 | 121.56015037699 | -7.56015037699041 | 111 | 0.480777706017254 | -1.21158391846497 | -0.0621926704890079 | weekly | |||||||||
9326 | 9326 | United States | Virginia | VA | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 8535519 | 1957 | 374 | 1450.84398496326 | 506.156015036737 | 1583 | 4.3816902053642 | 5.92999693441884 | 0.34887005100659 | weekly | |||||||||
9478 | 9478 | United States | Washington | WA | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 7614893 | 1331 | 173 | 1231.23684210629 | 99.7631578937114 | 1158 | 2.27186383314907 | 1.31010583988129 | 0.0810267809425242 | weekly | |||||||||
9630 | 9630 | United States | West Virginia | WV | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 1792147 | 623 | 143 | 471.864661655287 | 151.135338344713 | 480 | 7.97925616592835 | 8.43319986277428 | 0.320293827078585 | weekly | |||||||||
9782 | 9782 | United States | Wisconsin | WI | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 5822434 | 1192 | 190 | 1145.01691729427 | 46.983082705731 | 1002 | 3.26324008138177 | 0.806931992801138 | 0.0410326537504393 | weekly | |||||||||
9934 | 9934 | United States | Wyoming | WY | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 578759 | 118 | 25 | 102.097744361944 | 15.9022556380562 | 93 | 4.31958725479863 | 2.74764723106789 | 0.155755210239333 | weekly | |||||||||
11982 | 11982 | Canada | Canada | 0 | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 38454328 | 6675 | 962 | 6380.19579288041 | 294.804207119591 | 5713 | 2.50166899288943 | 0.766634661044112 | 0.0462061379759784 | weekly | |||||||||
17033 | 17033 | South Africa | South Africa | 0 | 2021-01-24 | 2021-01-30 | 7 | 2021 | 4 | 59893884 | 15820 | 3377 | 8844.79693165964 | 6975.20306834036 | 12443 | 5.63830523998076 | 11.6459354486684 | 0.788622183441303 | 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);